전체 그누보드기본설치 테이블과 추가 테이블 명이다. 아래는 SQL `fd`,'dat' 형식이다 SQL=select * from `u1_config` where 1; `cf_id`, `cf_title`, `cf_theme`, `cf_admin`, `cf_admin_email`, `cf_admin_email_name`, `cf_add_script`, `cf_use_point`, `cf_point_term`, `cf_use_copy_log`, `cf_use_email_certify`, `cf_login_point`, `cf_cut_name`, `cf_nick_modify`, `cf_new_skin`, `cf_new_rows`, `cf_search_skin`, `cf_connect_skin`, `cf_faq_skin`, `cf_read_point`, `cf_write_point`, `cf_comment_point`, `cf_download_point`, `cf_write_pages`, `cf_mobile_pages`, `cf_link_target`, `cf_bbs_rewrite`, `cf_delay_sec`, `cf_filter`, `cf_possible_ip`, `cf_intercept_ip`, `cf_analytics`, `cf_add_meta`, `cf_syndi_token`, `cf_syndi_except`, `cf_member_skin`, `cf_use_homepage`, `cf_req_homepage`, `cf_use_tel`, `cf_req_tel`, `cf_use_hp`, `cf_req_hp`, `cf_use_addr`, `cf_req_addr`, `cf_use_signature`, `cf_req_signature`, `cf_use_profile`, `cf_req_profile`, `cf_register_level`, `cf_register_point`, `cf_icon_level`, `cf_use_recommend`, `cf_recommend_point`, `cf_leave_day`, `cf_search_part`, `cf_email_use`, `cf_email_wr_super_admin`, `cf_email_wr_group_admin`, `cf_email_wr_board_admin`, `cf_email_wr_write`, `cf_email_wr_comment_all`, `cf_email_mb_super_admin`, `cf_email_mb_member`, `cf_email_po_super_admin`, `cf_prohibit_id`, `cf_prohibit_email`, `cf_new_del`, `cf_memo_del`, `cf_visit_del`, `cf_popular_del`, `cf_optimize_date`, `cf_use_member_icon`, `cf_member_icon_size`, `cf_member_icon_width`, `cf_member_icon_height`, `cf_member_img_size`, `cf_member_img_width`, `cf_member_img_height`, `cf_login_minutes`, `cf_image_extension`, `cf_flash_extension`, `cf_movie_extension`, `cf_formmail_is_member`, `cf_page_rows`, `cf_mobile_page_rows`, `cf_visit`, `cf_max_po_id`, `cf_stipulation`, `cf_privacy`, `cf_use_promotion`, `cf_open_modify`, `cf_memo_send_point`, `cf_mobile_new_skin`, `cf_mobile_search_skin`, `cf_mobile_connect_skin`, `cf_mobile_faq_skin`, `cf_mobile_member_skin`, `cf_captcha_mp3`, `cf_editor`, `cf_cert_use`, `cf_cert_find`, `cf_cert_ipin`, `cf_cert_hp`, `cf_cert_simple`, `cf_cert_kg_cd`, `cf_cert_kg_mid`, `cf_cert_use_seed`, `cf_cert_kcb_cd`, `cf_cert_kcp_cd`, `cf_cert_kcp_enckey`, `cf_lg_mid`, `cf_lg_mert_key`, `cf_cert_limit`, `cf_cert_req`, `cf_sms_use`, `cf_sms_type`, `cf_icode_id`, `cf_icode_pw`, `cf_icode_server_ip`, `cf_icode_server_port`, `cf_icode_token_key`, `cf_googl_shorturl_apikey`, `cf_social_login_use`, `cf_social_servicelist`, `cf_payco_clientid`, `cf_payco_secret`, `cf_facebook_appid`, `cf_facebook_secret`, `cf_twitter_key`, `cf_twitter_secret`, `cf_google_clientid`, `cf_google_secret`, `cf_naver_clientid`, `cf_naver_secret`, `cf_kakao_rest_key`, `cf_kakao_client_secret`, `cf_kakao_js_apikey`, `cf_captcha`, `cf_recaptcha_site_key`, `cf_recaptcha_secret_key`, `cf_kakaotalk_use`, `cf_kakaotalk_corpnum`, `cf_kakaotalk_sender_hp`, `cf_popbill_userid`, `cf_popbill_link_id`, `cf_popbill_secretkey`, `cf_1_subj`, `cf_2_subj`, `cf_3_subj`, `cf_4_subj`, `cf_5_subj`, `cf_6_subj`, `cf_7_subj`, `cf_8_subj`, `cf_9_subj`, `cf_10_subj`, `cf_1`, `cf_2`, `cf_3`, `cf_4`, `cf_5`, `cf_6`, `cf_7`, `cf_8`, `cf_9`, `cf_10`, 1 ,'🏠외국인취업' ,'boba1664' ,'admin' ,'admin@domain.com' ,'🏠외국인취업' ,' ' ,'1' ,'0' ,'1' ,'0' ,'100' ,'15' ,'60' ,'basic' ,'15' ,'basic' ,'basic' ,'basic' ,'0' ,'0' ,'0' ,'0' ,'10' ,'5' ,'_blank' ,'0' ,'30' ,'18아,18놈,18새끼,18뇬,18노,18것,18넘,개년,개놈,개뇬,개새,개색끼,개세끼,개세이,개쉐이,개쉑,개쉽,개시키,개자식,개좆,게색기,게색끼,광뇬,뇬,눈깔,뉘미럴,니귀미,니기미,니미,도촬,되질래,뒈져라,뒈진다,디져라,디진다,디질래,병쉰,병신,뻐큐,뻑큐,뽁큐,삐리넷,새꺄,쉬발,쉬밸,쉬팔,쉽알,스패킹,스팽,시벌,시부랄,시부럴,시부리,시불,시브랄,시팍,시팔,시펄,실밸,십8,십쌔,십창,싶알,쌉년,썅놈,쌔끼,쌩쑈,썅,써벌,썩을년,쎄꺄,쎄엑,쓰바,쓰발,쓰벌,쓰팔,씨8,씨댕,씨바,씨발,씨뱅,씨봉알,씨부랄,씨부럴,씨부렁,씨부리,씨불,씨브랄,씨빠,씨빨,씨뽀랄,씨팍,씨팔,씨펄,씹,아가리,아갈이,엄창,접년,잡놈,재랄,저주글,조까,조빠,조쟁이,조지냐,조진다,조질래,존나,존니,좀물,좁년,좃,좆,좇,쥐랄,쥐롤,쥬디,지랄,지럴,지롤,지미랄,쫍빱,凸,퍽큐,뻑큐,빠큐,ㅅㅂㄹㅁ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,'fj2025' ,'0' ,'0' ,'1' ,'0' ,'1' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'0' ,'2' ,'1000' ,'2' ,'0' ,'0' ,'30' ,'10000' ,'1' ,'1' ,'1' ,'0' ,'1' ,'0' ,'1' ,'1' ,'0' ,'admin,administrator,관리자,운영자,어드민,주인장,webmaster,웹마스터,sysop,시삽,시샵,manager,매니저,메니저,root,루트,su,guest,방문객' ,' ' ,'30' ,'180' ,'180' ,'180' ,'2026-04-20' ,'2' ,'5000' ,'22' ,'22' ,'50000' ,'60' ,'60' ,'10' ,'gif|jpg|jpeg|png' ,'swf' ,'asx|asf|wmv|wma|mpg|mpeg|mov|avi|mp3' ,'1' ,'15' ,'15' ,'오늘:7,어제:46,최대:146,전체:7587' ,'0' ,'해당 홈페이지에 맞는 회원가입약관을 입력합니다.' ,'해당 홈페이지에 맞는 개인정보처리방침을 입력합니다.' ,'0' ,'0' ,'500' ,'theme/basic' ,'theme/basic' ,'theme/basic' ,'theme/basic' ,'theme/basic' ,'basic' ,'ckeditor5' ,'0' ,'0' ,' ' ,' ' ,' ' ,' ' ,' ' ,'1' ,' ' ,' ' ,' ' ,' ' ,' ' ,'2' ,'0' ,' ' ,' ' ,' ' ,'1234' ,'211.172.232.124' ,'7295' ,' ' ,' ' ,'1' ,'naver,kakao,google' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,'O3nqquOSWIN4JWKPOM2B' ,'zoNv023FeV' ,' ' ,' ' ,' ' ,'kcaptcha' ,' ' ,' ' ,' ' ,' ' ,' ' ,'admin' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' 테이블명 리스트 ;;는 내프로그램이 그렇게 2개 넣는다. foreign_jobs ;; foreign_level_sync_log ;; foreign_matches ;; foreign_resumes ;; g5_write_board_div ;; g5_write_board_div_wide ;; g5_write_board_qa ;; g5_write_download ;; g5_write_gallery_effect_1 ;; g5_write_gallery_effect_2 ;; g5_write_gallery_effect_3 ;; g5_write_gallery_full_1 ;; g5_write_gallery_full_2 ;; g5_write_gallery_image_1 ;; g5_write_gallery_image_2 ;; g5_write_gallery_masonry ;; g5_write_gallery_movie ;; g5_write_gallery_webzin ;; g5_write_gallery_webzin_movie ;; g5_write_gallery_webzin_wide ;; g5_write_item ;; g5_write_item2 ;; g5_write_item2_1 ;; g5_write_item_full ;; u1_auth ;; u1_autosave ;; u1_board ;; u1_board_file ;; u1_board_good ;; u1_board_new ;; u1_cert_history ;; u1_config ;; u1_content ;; u1_faq ;; u1_faq_master ;; u1_group ;; u1_group_member ;; u1_kakao5_preset ;; u1_kakao5_preset_history ;; u1_login ;; u1_mail ;; u1_member ;; u1_member_cert_history ;; u1_member_social_profiles ;; u1_memo ;; u1_menu ;; u1_new_win ;; u1_point ;; u1_poll ;; u1_poll_etc ;; u1_popular ;; u1_qa_config ;; u1_qa_content ;; u1_scrap ;; u1_uniqid ;; u1_visit ;; u1_visit_sum ;; u1_write_employers ;; u1_write_free ;; u1_write_gallery ;; u1_write_legal ;; u1_write_notice ;; u1_write_qa ;; 아래는 테이블구조와 foregien_* 테이블 과 test데이터이다. CREATE TABLE `foreign_resumes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mb_id` varchar(50) NOT NULL, `title` varchar(200) NOT NULL, `content_ko` text DEFAULT NULL, `content_en` text DEFAULT NULL, `content_vi` text DEFAULT NULL, `content_cn` text DEFAULT NULL, `visa_type` varchar(20) DEFAULT NULL, `work_experience` text DEFAULT NULL, `skills` text DEFAULT NULL, `job_category_1` varchar(50) DEFAULT NULL, `job_category_2` varchar(50) DEFAULT NULL, `region` varchar(50) DEFAULT NULL, `skill_level` varchar(20) DEFAULT NULL, `keywords` text DEFAULT NULL, `location_preference` varchar(100) DEFAULT NULL, `salary_expectation` int(11) DEFAULT NULL, `status` enum('active','matched','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `idx_mb_id` (`mb_id`), KEY `idx_status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 아래는 SQL `fd`,'dat' 형식이다 SQL=select * from `foreign_resumes` where 1; `id`, `mb_id`, `title`, `content_ko`, `content_en`, `content_vi`, `content_cn`, `visa_type`, `work_experience`, `skills`, `job_category_1`, `job_category_2`, `region`, `skill_level`, `keywords`, `location_preference`, `salary_expectation`, `status`, `created_at`, `updated_at`, 2 ,'test001' ,'test001 외국인 구직자 이력서' ,'안녕하세요. 한국에서 일하고 싶은 베트남 출신 구직자입니다.' ,'Hello. I am a Vietnamese job seeker who wants to work in Korea.' ,' ' ,' ' ,'E-9' ,' ' ,' ' ,'건설업' ,'철근' ,'서울' ,'고급' ,' ' ,' ' ,' ' ,'active' ,'2025-09-28 00:18:23' ,'2025-09-28 17:34:01' 3 ,'test001' ,'test001 베트남 구직자 이력서' ,'안녕하세요. 한국에서 일하고 싶은 베트남 출신 구직자입니다. 성실하게 일하겠습니다.' ,'Hello. I am a Vietnamese job seeker who wants to work in Korea. I will work diligently.' ,'Xin chào. Tôi là người tìm việc từ Việt Nam muốn làm việc ở Hàn Quốc.' ,' ' ,'E-9' ,' ' ,' ' ,'농업' ,'과수원' ,'제주' ,'초급' ,'제조업,조립,생산직,베트남' ,' ' ,' ' ,'matched' ,'2025-09-28 00:18:55' ,'2026-01-14 22:18:50' 4 ,'thai_worker01' ,'제조업 경력 3년 태국 노동자' ,'제조업 경력 3년 태국 노동자 상세 내용' ,' ' ,' ' ,' ' ,'E-9' ,'제조업 3년' ,' ' ,' ' ,' ' ,' ' ,' ' ,'건설업,철근,콘크리트,태국' ,'경기도' ,'2800000' ,'active' ,'2025-09-28 00:49:45' ,'2025-09-28 17:12:46' 5 ,'indo_worker01' ,'건설업 숙련 인도네시아 근로자' ,'건설업 숙련 인도네시아 근로자 상세 내용' ,' ' ,' ' ,' ' ,'E-9' ,'건설업 5년' ,' ' ,' ' ,' ' ,' ' ,' ' ,'건설업,용접,도장,인도네시아' ,'서울' ,'3000000' ,'active' ,'2025-09-28 00:49:45' ,'2025-10-19 18:52:05' 6 ,'thai_worker02' ,'농업 전문 태국 근로자' ,'농업 전문 태국 근로자 상세 내용' ,' ' ,' ' ,' ' ,'E-9' ,'농업 7년' ,' ' ,' ' ,' ' ,' ' ,' ' ,'농업,과수원,수확,태국' ,'전남' ,'2500000' ,'active' ,'2025-09-28 00:49:45' ,'2025-10-19 18:51:37' 7 ,'viet_worker02' ,'음식서비스업 베트남 근로자' ,'음식서비스업 베트남 근로자 상세 내용' ,' ' ,' ' ,' ' ,'E-7' ,'서비스업 2년' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,'부산' ,'2700000' ,'matched' ,'2025-09-28 00:49:45' ,'2025-10-19 18:51:05' 8 ,'phil_worker01' ,'간병 전문 필리핀 근로자' ,'간병 전문 필리핀 근로자 상세 내용' ,' ' ,' ' ,' ' ,'E-7' ,'간병 2년' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,'서울' ,'2900000' ,'active' ,'2025-09-28 00:49:45' ,'2025-09-28 00:49:45' 9 ,'user216' ,'🎯 JavaScript SSH 터널링 + MySQL 완전 성공!' ,'YOUR_ID/YOUR_PW 계정으로 SSH 터널링을 통한 MariaDB 10.5.29 연동 완료' ,'Complete success: JavaScript SSH tunneling to MariaDB 10.5.29 with YOUR_ID/YOUR_PW' ,' ' ,' ' ,'F-4' ,'SSH Tunneling Expert' ,'JavaScript, SSH2, MariaDB, Drizzle ORM' ,' ' ,' ' ,' ' ,' ' ,' ' ,'foreignerjob.com' ,'15000' ,'active' ,'2025-09-28 13:56:42' ,'2025-10-19 17:34:24' 10 ,'test_user_1' ,'베트남 출신 3년차 자동차 제조 숙련공 구직합니다' ,'안녕하세요. 베트남에서 온 25살 응우옌입니다. 본국에서 자동차 부품 조립 경험이 3년 있습니다. 한국어 일상회화 가능하며 성실하고 책임감 있게 일하겠습니다. 빠른 시일 내에 취업을 희망합니다.' ,' ' ,' ' ,' ' ,' ' ,'베트남 현대자동차 협력사에서 3년간 엔진 부품 조립 및 검수 업무 담당. 품질관리 경험 보유.' ,'자동차 부품 조립, 용접 기초, 한국어 중급 수준, 지게차 운전 가능' ,'제조업' ,'자동차 제조' ,'경기도' ,'숙련' ,' ' ,' ' ,'280' ,'active' ,'2025-09-28 18:02:49' ,'2025-09-28 18:02:49' 11 ,'test_user_2' ,'인도네시아 건설 현장 경력 5년 중장비 운전 전문가' ,'인도네시아에서 건설 현장 경험이 풍부한 30살 아디입니다. 굴삭기, 크레인 등 중장비 운전에 능숙합니다. 안전 규정을 철저히 지키며 팀워크를 중시합니다. 한국에서 새로운 도전을 하고 싶습니다.' ,' ' ,' ' ,' ' ,' ' ,'인도네시아 자카르타 아파트 건설 현장에서 5년간 굴삭기 및 크레인 운전. 대형 건설사 프로젝트 다수 참여.' ,'굴삭기 운전, 크레인 조작, 건설 현장 안전관리, 한국어 초급 수준' ,'건설업' ,'중장비 운전' ,'서울특별시' ,'전문가' ,' ' ,' ' ,'350' ,'active' ,'2025-09-28 18:02:49' ,'2025-09-28 18:02:49' 12 ,'test_user_3' ,'필리핀 출신 간병 서비스 전문 요양보호사 지원' ,'필리핀에서 간호학을 전공한 28살 마리아입니다. 노인 돌봄 서비스에 대한 깊은 이해와 경험이 있습니다. 한국어를 열심히 공부하고 있으며 정성스럽게 어르신들을 모시겠습니다.' ,' ' ,' ' ,' ' ,' ' ,'필리핀 마닐라 요양원에서 2년간 치매 어르신 전담 케어. 가족 돌봄 서비스 1년 경험.' ,'요양보호사 자격증(필리핀), 기본 간병 서비스, 한국어 중급, 응급처치' ,'돌봄서비스업' ,'요양보호' ,'부산광역시' ,'숙련' ,' ' ,' ' ,'220' ,'active' ,'2025-09-28 18:02:49' ,'2025-09-28 18:02:49' 13 ,'user957' ,'식당일' ,'한국어능함' ,' ' ,' ' ,' ' ,'E-7' ,'단체급식 보조 3년' ,'한식,일식,양식 자격증' ,' ' ,' ' ,' ' ,' ' ,' ' ,'서울,경기' ,'200' ,'inactive' ,'2025-10-29 05:16:46' ,'2025-10-29 05:16:46' 14 ,'user494' ,'식당일' ,'한국어능함' ,' ' ,' ' ,' ' ,'E-7' ,'단체급식 보조 3년' ,'한식,일식,양식 자격증' ,' ' ,' ' ,' ' ,' ' ,' ' ,'서울,경기' ,'200' ,'inactive' ,'2025-10-29 05:17:20' ,'2025-10-29 05:17:20' 15 ,'user279' ,'aaa' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,'active' ,'2025-10-29 05:20:34' ,'2025-10-29 05:20:34' CREATE TABLE `foreign_matches` ( `id` int(11) NOT NULL AUTO_INCREMENT, `resume_id` int(11) NOT NULL, `job_id` int(11) NOT NULL, `status` enum('proposed','contacted','interview','offer','placed','paid1','paid2','closed') DEFAULT 'proposed', `admin_note` text DEFAULT NULL, `fee_total` decimal(10,2) DEFAULT NULL, `fee_stage1` decimal(10,2) DEFAULT NULL, `fee_stage2` decimal(10,2) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `resume_id` (`resume_id`), KEY `job_id` (`job_id`), KEY `idx_status` (`status`), KEY `idx_created` (`created_at`), CONSTRAINT `foreign_matches_ibfk_1` FOREIGN KEY (`resume_id`) REFERENCES `foreign_resumes` (`id`) ON DELETE CASCADE, CONSTRAINT `foreign_matches_ibfk_2` FOREIGN KEY (`job_id`) REFERENCES `foreign_jobs` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ; CREATE TABLE `foreign_level_sync_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mb_id` varchar(50) NOT NULL, `from_level` int(11) DEFAULT NULL, `to_level` int(11) DEFAULT NULL, `reason` varchar(200) DEFAULT NULL, `processed` tinyint(1) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_mb_id` (`mb_id`), KEY `idx_processed` (`processed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ; CREATE TABLE `foreign_jobs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `company_mb_id` varchar(50) NOT NULL, `title` varchar(200) NOT NULL, `description_ko` text DEFAULT NULL, `description_en` text DEFAULT NULL, `visa_support` tinyint(1) DEFAULT 0, `location` varchar(100) DEFAULT NULL, `salary_min` int(11) DEFAULT NULL, `salary_max` int(11) DEFAULT NULL, `employment_type` enum('full_time','part_time','contract','temporary') DEFAULT 'full_time', `required_skills` text DEFAULT NULL, `status` enum('active','filled','closed') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `idx_company` (`company_mb_id`), KEY `idx_status` (`status`), KEY `idx_location` (`location`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ;