답변 4개
최신버전은 5.8이 아니라 5.5.8.3 입니다.
다운로드하시면 install폴더 안에 sql 문서있습니다.
gnuboard5 DB
[CODE]
-- --------------------------------------------------------
-- -- Table structure for table `g5_auth` --
DROP TABLE IF EXISTS `g5_auth`; CREATE TABLE IF NOT EXISTS `g5_auth` ( `mb_id` varchar(20) NOT NULL default '', `au_menu` varchar(20) NOT NULL default '', `au_auth` set('r','w','d') NOT NULL default '', PRIMARY KEY (`mb_id`,`au_menu`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_board` --
DROP TABLE IF EXISTS `g5_board`; CREATE TABLE IF NOT EXISTS `g5_board` ( `bo_table` varchar(20) NOT NULL DEFAULT '', `gr_id` varchar(255) NOT NULL DEFAULT '', `bo_subject` varchar(255) NOT NULL DEFAULT '', `bo_mobile_subject` varchar(255) NOT NULL DEFAULT '', `bo_device` enum('both','pc','mobile') NOT NULL DEFAULT 'both', `bo_admin` varchar(255) NOT NULL DEFAULT '', `bo_list_level` tinyint(4) NOT NULL DEFAULT '0', `bo_read_level` tinyint(4) NOT NULL DEFAULT '0', `bo_write_level` tinyint(4) NOT NULL DEFAULT '0', `bo_reply_level` tinyint(4) NOT NULL DEFAULT '0', `bo_comment_level` tinyint(4) NOT NULL DEFAULT '0', `bo_upload_level` tinyint(4) NOT NULL DEFAULT '0', `bo_download_level` tinyint(4) NOT NULL DEFAULT '0', `bo_html_level` tinyint(4) NOT NULL DEFAULT '0', `bo_link_level` tinyint(4) NOT NULL DEFAULT '0', `bo_count_delete` tinyint(4) NOT NULL DEFAULT '0', `bo_count_modify` tinyint(4) NOT NULL DEFAULT '0', `bo_read_point` int(11) NOT NULL DEFAULT '0', `bo_write_point` int(11) NOT NULL DEFAULT '0', `bo_comment_point` int(11) NOT NULL DEFAULT '0', `bo_download_point` int(11) NOT NULL DEFAULT '0', `bo_use_category` tinyint(4) NOT NULL DEFAULT '0', `bo_category_list` text NOT NULL, `bo_use_sideview` tinyint(4) NOT NULL DEFAULT '0', `bo_use_file_content` tinyint(4) NOT NULL DEFAULT '0', `bo_use_secret` tinyint(4) NOT NULL DEFAULT '0', `bo_use_dhtml_editor` tinyint(4) NOT NULL DEFAULT '0', `bo_select_editor` varchar(50) NOT NULL DEFAULT '', `bo_use_rss_view` tinyint(4) NOT NULL DEFAULT '0', `bo_use_good` tinyint(4) NOT NULL DEFAULT '0', `bo_use_nogood` tinyint(4) NOT NULL DEFAULT '0', `bo_use_name` tinyint(4) NOT NULL DEFAULT '0', `bo_use_signature` tinyint(4) NOT NULL DEFAULT '0', `bo_use_ip_view` tinyint(4) NOT NULL DEFAULT '0', `bo_use_list_view` tinyint(4) NOT NULL DEFAULT '0', `bo_use_list_file` tinyint(4) NOT NULL DEFAULT '0', `bo_use_list_content` tinyint(4) NOT NULL DEFAULT '0', `bo_table_width` int(11) NOT NULL DEFAULT '0', `bo_subject_len` int(11) NOT NULL DEFAULT '0', `bo_mobile_subject_len` int(11) NOT NULL DEFAULT '0', `bo_page_rows` int(11) NOT NULL DEFAULT '0', `bo_mobile_page_rows` int(11) NOT NULL DEFAULT '0', `bo_new` int(11) NOT NULL DEFAULT '0', `bo_hot` int(11) NOT NULL DEFAULT '0', `bo_image_width` int(11) NOT NULL DEFAULT '0', `bo_skin` varchar(255) NOT NULL DEFAULT '', `bo_mobile_skin` varchar(255) NOT NULL DEFAULT '', `bo_include_head` varchar(255) NOT NULL DEFAULT '', `bo_include_tail` varchar(255) NOT NULL DEFAULT '', `bo_content_head` text NOT NULL, `bo_mobile_content_head` text NOT NULL, `bo_content_tail` text NOT NULL, `bo_mobile_content_tail` text NOT NULL, `bo_insert_content` text NOT NULL, `bo_gallery_cols` int(11) NOT NULL DEFAULT '0', `bo_gallery_width` int(11) NOT NULL DEFAULT '0', `bo_gallery_height` int(11) NOT NULL DEFAULT '0', `bo_mobile_gallery_width` int(11) NOT NULL DEFAULT '0', `bo_mobile_gallery_height` int(11) NOT NULL DEFAULT '0', `bo_upload_size` int(11) NOT NULL DEFAULT '0', `bo_reply_order` tinyint(4) NOT NULL DEFAULT '0', `bo_use_search` tinyint(4) NOT NULL DEFAULT '0', `bo_order` int(11) NOT NULL DEFAULT '0', `bo_count_write` int(11) NOT NULL DEFAULT '0', `bo_count_comment` int(11) NOT NULL DEFAULT '0', `bo_write_min` int(11) NOT NULL DEFAULT '0', `bo_write_max` int(11) NOT NULL DEFAULT '0', `bo_comment_min` int(11) NOT NULL DEFAULT '0', `bo_comment_max` int(11) NOT NULL DEFAULT '0', `bo_notice` text NOT NULL, `bo_upload_count` tinyint(4) NOT NULL DEFAULT '0', `bo_use_email` tinyint(4) NOT NULL DEFAULT '0', `bo_use_cert` enum('','cert','adult','hp-cert','hp-adult') NOT NULL DEFAULT '', `bo_use_sns` tinyint(4) NOT NULL DEFAULT '0', `bo_use_captcha` tinyint(4) NOT NULL DEFAULT '0', `bo_sort_field` varchar(255) NOT NULL DEFAULT '', `bo_1_subj` varchar(255) NOT NULL DEFAULT '', `bo_2_subj` varchar(255) NOT NULL DEFAULT '', `bo_3_subj` varchar(255) NOT NULL DEFAULT '', `bo_4_subj` varchar(255) NOT NULL DEFAULT '', `bo_5_subj` varchar(255) NOT NULL DEFAULT '', `bo_6_subj` varchar(255) NOT NULL DEFAULT '', `bo_7_subj` varchar(255) NOT NULL DEFAULT '', `bo_8_subj` varchar(255) NOT NULL DEFAULT '', `bo_9_subj` varchar(255) NOT NULL DEFAULT '', `bo_10_subj` varchar(255) NOT NULL DEFAULT '', `bo_1` varchar(255) NOT NULL DEFAULT '', `bo_2` varchar(255) NOT NULL DEFAULT '', `bo_3` varchar(255) NOT NULL DEFAULT '', `bo_4` varchar(255) NOT NULL DEFAULT '', `bo_5` varchar(255) NOT NULL DEFAULT '', `bo_6` varchar(255) NOT NULL DEFAULT '', `bo_7` varchar(255) NOT NULL DEFAULT '', `bo_8` varchar(255) NOT NULL DEFAULT '', `bo_9` varchar(255) NOT NULL DEFAULT '', `bo_10` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`bo_table`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_board_file` --
DROP TABLE IF EXISTS `g5_board_file`; CREATE TABLE IF NOT EXISTS `g5_board_file` ( `bo_table` varchar(20) NOT NULL default '', `wr_id` int(11) NOT NULL default '0', `bf_no` int(11) NOT NULL default '0', `bf_source` varchar(255) NOT NULL default '', `bf_file` varchar(255) NOT NULL default '', `bf_download` int(11) NOT NULL, `bf_content` text NOT NULL, `bf_fileurl` VARCHAR(255) NOT NULL DEFAULT '', `bf_thumburl` VARCHAR(255) NOT NULL DEFAULT '', `bf_storage` VARCHAR(50) NOT NULL DEFAULT '', `bf_filesize` int(11) NOT NULL default '0', `bf_width` int(11) NOT NULL default '0', `bf_height` smallint(6) NOT NULL default '0', `bf_type` tinyint(4) NOT NULL default '0', `bf_datetime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`bo_table`,`wr_id`,`bf_no`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_board_good` --
DROP TABLE IF EXISTS `g5_board_good`; CREATE TABLE IF NOT EXISTS `g5_board_good` ( `bg_id` int(11) NOT NULL auto_increment, `bo_table` varchar(20) NOT NULL default '', `wr_id` int(11) NOT NULL default '0', `mb_id` varchar(20) NOT NULL default '', `bg_flag` varchar(255) NOT NULL default '', `bg_datetime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`bg_id`), UNIQUE KEY `fkey1` (`bo_table`,`wr_id`,`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_board_new` --
DROP TABLE IF EXISTS `g5_board_new`; CREATE TABLE IF NOT EXISTS `g5_board_new` ( `bn_id` int(11) NOT NULL auto_increment, `bo_table` varchar(20) NOT NULL default '', `wr_id` int(11) NOT NULL default '0', `wr_parent` int(11) NOT NULL default '0', `bn_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `mb_id` varchar(20) NOT NULL default '', PRIMARY KEY (`bn_id`), KEY `mb_id` (`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_config` --
DROP TABLE IF EXISTS `g5_config`; CREATE TABLE IF NOT EXISTS `g5_config` ( `cf_title` varchar(255) NOT NULL DEFAULT '', `cf_theme` varchar(100) NOT NULL DEFAULT '', `cf_admin` varchar(100) NOT NULL DEFAULT '', `cf_admin_email` varchar(100) NOT NULL DEFAULT '', `cf_admin_email_name` varchar(100) NOT NULL DEFAULT '', `cf_add_script` text NOT NULL, `cf_use_point` tinyint(4) NOT NULL DEFAULT '0', `cf_point_term` int(11) NOT NULL DEFAULT '0', `cf_use_copy_log` tinyint(4) NOT NULL DEFAULT '0', `cf_use_email_certify` tinyint(4) NOT NULL DEFAULT '0', `cf_login_point` int(11) NOT NULL DEFAULT '0', `cf_cut_name` tinyint(4) NOT NULL DEFAULT '0', `cf_nick_modify` int(11) NOT NULL DEFAULT '0', `cf_new_skin` varchar(50) NOT NULL DEFAULT '', `cf_new_rows` int(11) NOT NULL DEFAULT '0', `cf_search_skin` varchar(50) NOT NULL DEFAULT '', `cf_connect_skin` varchar(50) NOT NULL DEFAULT '', `cf_faq_skin` varchar(50) NOT NULL DEFAULT '', `cf_read_point` int(11) NOT NULL DEFAULT '0', `cf_write_point` int(11) NOT NULL DEFAULT '0', `cf_comment_point` int(11) NOT NULL DEFAULT '0', `cf_download_point` int(11) NOT NULL DEFAULT '0', `cf_write_pages` int(11) NOT NULL DEFAULT '0', `cf_mobile_pages` int(11) NOT NULL DEFAULT '0', `cf_link_target` varchar(50) NOT NULL DEFAULT '', `cf_bbs_rewrite` tinyint(4) NOT NULL DEFAULT '0', `cf_delay_sec` int(11) NOT NULL DEFAULT '0', `cf_filter` text NOT NULL, `cf_possible_ip` text NOT NULL, `cf_intercept_ip` text NOT NULL, `cf_analytics` text NOT NULL, `cf_add_meta` text NOT NULL, `cf_member_skin` varchar(50) NOT NULL DEFAULT '', `cf_use_homepage` tinyint(4) NOT NULL DEFAULT '0', `cf_req_homepage` tinyint(4) NOT NULL DEFAULT '0', `cf_use_tel` tinyint(4) NOT NULL DEFAULT '0', `cf_req_tel` tinyint(4) NOT NULL DEFAULT '0', `cf_use_hp` tinyint(4) NOT NULL DEFAULT '0', `cf_req_hp` tinyint(4) NOT NULL DEFAULT '0', `cf_use_addr` tinyint(4) NOT NULL DEFAULT '0', `cf_req_addr` tinyint(4) NOT NULL DEFAULT '0', `cf_use_signature` tinyint(4) NOT NULL DEFAULT '0', `cf_req_signature` tinyint(4) NOT NULL DEFAULT '0', `cf_use_profile` tinyint(4) NOT NULL DEFAULT '0', `cf_req_profile` tinyint(4) NOT NULL DEFAULT '0', `cf_register_level` tinyint(4) NOT NULL DEFAULT '0', `cf_register_point` int(11) NOT NULL DEFAULT '0', `cf_icon_level` tinyint(4) NOT NULL DEFAULT '0', `cf_use_recommend` tinyint(4) NOT NULL DEFAULT '0', `cf_recommend_point` int(11) NOT NULL DEFAULT '0', `cf_leave_day` int(11) NOT NULL DEFAULT '0', `cf_search_part` int(11) NOT NULL DEFAULT '0', `cf_email_use` tinyint(4) NOT NULL DEFAULT '0', `cf_email_wr_super_admin` tinyint(4) NOT NULL DEFAULT '0', `cf_email_wr_group_admin` tinyint(4) NOT NULL DEFAULT '0', `cf_email_wr_board_admin` tinyint(4) NOT NULL DEFAULT '0', `cf_email_wr_write` tinyint(4) NOT NULL DEFAULT '0', `cf_email_wr_comment_all` tinyint(4) NOT NULL DEFAULT '0', `cf_email_mb_super_admin` tinyint(4) NOT NULL DEFAULT '0', `cf_email_mb_member` tinyint(4) NOT NULL DEFAULT '0', `cf_email_po_super_admin` tinyint(4) NOT NULL DEFAULT '0', `cf_prohibit_id` text NOT NULL, `cf_prohibit_email` text NOT NULL, `cf_new_del` int(11) NOT NULL DEFAULT '0', `cf_memo_del` int(11) NOT NULL DEFAULT '0', `cf_visit_del` int(11) NOT NULL DEFAULT '0', `cf_popular_del` int(11) NOT NULL DEFAULT '0', `cf_optimize_date` date NOT NULL default '0000-00-00', `cf_use_member_icon` tinyint(4) NOT NULL DEFAULT '0', `cf_member_icon_size` int(11) NOT NULL DEFAULT '0', `cf_member_icon_width` int(11) NOT NULL DEFAULT '0', `cf_member_icon_height` int(11) NOT NULL DEFAULT '0', `cf_member_img_size` int(11) NOT NULL DEFAULT '0', `cf_member_img_width` int(11) NOT NULL DEFAULT '0', `cf_member_img_height` int(11) NOT NULL DEFAULT '0', `cf_login_minutes` int(11) NOT NULL DEFAULT '0', `cf_image_extension` varchar(255) NOT NULL DEFAULT '', `cf_flash_extension` varchar(255) NOT NULL DEFAULT '', `cf_movie_extension` varchar(255) NOT NULL DEFAULT '', `cf_formmail_is_member` tinyint(4) NOT NULL DEFAULT '0', `cf_page_rows` int(11) NOT NULL DEFAULT '0', `cf_mobile_page_rows` int(11) NOT NULL DEFAULT '0', `cf_visit` varchar(255) NOT NULL DEFAULT '', `cf_max_po_id` int(11) NOT NULL DEFAULT '0', `cf_stipulation` text NOT NULL, `cf_privacy` text NOT NULL, `cf_open_modify` int(11) NOT NULL DEFAULT '0', `cf_memo_send_point` int(11) NOT NULL DEFAULT '0', `cf_mobile_new_skin` varchar(50) NOT NULL DEFAULT '', `cf_mobile_search_skin` varchar(50) NOT NULL DEFAULT '', `cf_mobile_connect_skin` varchar(50) NOT NULL DEFAULT '', `cf_mobile_faq_skin` varchar(50) NOT NULL DEFAULT '', `cf_mobile_member_skin` varchar(50) NOT NULL DEFAULT '', `cf_captcha_mp3` varchar(255) NOT NULL DEFAULT '', `cf_editor` varchar(50) NOT NULL DEFAULT '', `cf_cert_use` tinyint(4) NOT NULL DEFAULT '0', `cf_cert_find` tinyint(4) NOT NULL DEFAULT '0', `cf_cert_ipin` varchar(255) NOT NULL DEFAULT '', `cf_cert_hp` varchar(255) NOT NULL DEFAULT '', `cf_cert_simple` varchar(255) NOT NULL DEFAULT '', `cf_cert_kg_cd` varchar(255) NOT NULL DEFAULT '', `cf_cert_kg_mid` varchar(255) NOT NULL DEFAULT '', `cf_cert_kcb_cd` varchar(255) NOT NULL DEFAULT '', `cf_cert_kcp_cd` varchar(255) NOT NULL DEFAULT '', `cf_lg_mid` varchar(100) NOT NULL DEFAULT '', `cf_lg_mert_key` varchar(100) NOT NULL DEFAULT '', `cf_cert_limit` int(11) NOT NULL DEFAULT '0', `cf_cert_req` tinyint(4) NOT NULL DEFAULT '0', `cf_sms_use` varchar(255) NOT NULL DEFAULT '', `cf_sms_type` varchar(10) NOT NULL DEFAULT '', `cf_icode_id` varchar(255) NOT NULL DEFAULT '', `cf_icode_pw` varchar(255) NOT NULL DEFAULT '', `cf_icode_server_ip` varchar(50) NOT NULL DEFAULT '', `cf_icode_server_port` varchar(50) NOT NULL DEFAULT '', `cf_icode_token_key` varchar(100) NOT NULL DEFAULT '', `cf_googl_shorturl_apikey` varchar(50) NOT NULL DEFAULT '', `cf_social_login_use` tinyint(4) NOT NULL DEFAULT '0', `cf_social_servicelist` varchar(255) NOT NULL DEFAULT '', `cf_payco_clientid` varchar(100) NOT NULL DEFAULT '', `cf_payco_secret` varchar(100) NOT NULL DEFAULT '', `cf_facebook_appid` varchar(100) NOT NULL, `cf_facebook_secret` varchar(100) NOT NULL, `cf_twitter_key` varchar(100) NOT NULL, `cf_twitter_secret` varchar(100) NOT NULL, `cf_google_clientid` varchar(100) NOT NULL DEFAULT '', `cf_google_secret` varchar(100) NOT NULL DEFAULT '', `cf_naver_clientid` varchar(100) NOT NULL DEFAULT '', `cf_naver_secret` varchar(100) NOT NULL DEFAULT '', `cf_kakao_rest_key` varchar(100) NOT NULL DEFAULT '', `cf_kakao_client_secret` varchar(100) NOT NULL DEFAULT '', `cf_kakao_js_apikey` varchar(100) NOT NULL, `cf_captcha` varchar(100) NOT NULL DEFAULT '', `cf_recaptcha_site_key` varchar(100) NOT NULL DEFAULT '', `cf_recaptcha_secret_key` varchar(100) NOT NULL DEFAULT '', `cf_1_subj` varchar(255) NOT NULL DEFAULT '', `cf_2_subj` varchar(255) NOT NULL DEFAULT '', `cf_3_subj` varchar(255) NOT NULL DEFAULT '', `cf_4_subj` varchar(255) NOT NULL DEFAULT '', `cf_5_subj` varchar(255) NOT NULL DEFAULT '', `cf_6_subj` varchar(255) NOT NULL DEFAULT '', `cf_7_subj` varchar(255) NOT NULL DEFAULT '', `cf_8_subj` varchar(255) NOT NULL DEFAULT '', `cf_9_subj` varchar(255) NOT NULL DEFAULT '', `cf_10_subj` varchar(255) NOT NULL DEFAULT '', `cf_1` varchar(255) NOT NULL DEFAULT '', `cf_2` varchar(255) NOT NULL DEFAULT '', `cf_3` varchar(255) NOT NULL DEFAULT '', `cf_4` varchar(255) NOT NULL DEFAULT '', `cf_5` varchar(255) NOT NULL DEFAULT '', `cf_6` varchar(255) NOT NULL DEFAULT '', `cf_7` varchar(255) NOT NULL DEFAULT '', `cf_8` varchar(255) NOT NULL DEFAULT '', `cf_9` varchar(255) NOT NULL DEFAULT '', `cf_10` varchar(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_cert_history` --
DROP TABLE IF EXISTS `g5_cert_history`; CREATE TABLE IF NOT EXISTS `g5_cert_history` ( `cr_id` int(11) NOT NULL auto_increment, `mb_id` varchar(20) NOT NULL DEFAULT '', `cr_company` varchar(255) NOT NULL DEFAULT '', `cr_method` varchar(255) NOT NULL DEFAULT '', `cr_ip` varchar(255) NOT NULL DEFAULT '', `cr_date` date NOT NULL DEFAULT '0000-00-00', `cr_time` time NOT NULL DEFAULT '00:00:00', PRIMARY KEY (`cr_id`), KEY `mb_id` (`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_cert_history` --
DROP TABLE IF EXISTS `g5_member_cert_history`; CREATE TABLE IF NOT EXISTS `g5_member_cert_history` ( `ch_id` int(11) NOT NULL auto_increment, `mb_id` varchar(20) NOT NULL DEFAULT '', `ch_name` varchar(255) NOT NULL DEFAULT '', `ch_hp` varchar(255) NOT NULL DEFAULT '', `ch_birth` varchar(255) NOT NULL DEFAULT '', `ch_type` varchar(20) NOT NULL DEFAULT '', `ch_datetime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ch_id`), KEY `mb_id` (`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_group` --
DROP TABLE IF EXISTS `g5_group`; CREATE TABLE IF NOT EXISTS `g5_group` ( `gr_id` varchar(10) NOT NULL default '', `gr_subject` varchar(255) NOT NULL default '', `gr_device` ENUM('both','pc','mobile') NOT NULL DEFAULT 'both', `gr_admin` varchar(255) NOT NULL default '', `gr_use_access` tinyint(4) NOT NULL default '0', `gr_order` int(11) NOT NULL default '0', `gr_1_subj` varchar(255) NOT NULL default '', `gr_2_subj` varchar(255) NOT NULL default '', `gr_3_subj` varchar(255) NOT NULL default '', `gr_4_subj` varchar(255) NOT NULL default '', `gr_5_subj` varchar(255) NOT NULL default '', `gr_6_subj` varchar(255) NOT NULL default '', `gr_7_subj` varchar(255) NOT NULL default '', `gr_8_subj` varchar(255) NOT NULL default '', `gr_9_subj` varchar(255) NOT NULL default '', `gr_10_subj` varchar(255) NOT NULL default '', `gr_1` varchar(255) NOT NULL default '', `gr_2` varchar(255) NOT NULL default '', `gr_3` varchar(255) NOT NULL default '', `gr_4` varchar(255) NOT NULL default '', `gr_5` varchar(255) NOT NULL default '', `gr_6` varchar(255) NOT NULL default '', `gr_7` varchar(255) NOT NULL default '', `gr_8` varchar(255) NOT NULL default '', `gr_9` varchar(255) NOT NULL default '', `gr_10` varchar(255) NOT NULL default '', PRIMARY KEY (`gr_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_group_member` --
DROP TABLE IF EXISTS `g5_group_member`; CREATE TABLE IF NOT EXISTS `g5_group_member` ( `gm_id` int(11) NOT NULL auto_increment, `gr_id` varchar(255) NOT NULL default '', `mb_id` varchar(20) NOT NULL default '', `gm_datetime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`gm_id`), KEY `gr_id` (`gr_id`), KEY `mb_id` (`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_login` --
DROP TABLE IF EXISTS `g5_login`; CREATE TABLE IF NOT EXISTS `g5_login` ( `lo_ip` varchar(100) NOT NULL default '', `mb_id` varchar(20) NOT NULL default '', `lo_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `lo_location` text NOT NULL, `lo_url` text NOT NULL, PRIMARY KEY (`lo_ip`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_mail` --
DROP TABLE IF EXISTS `g5_mail`; CREATE TABLE IF NOT EXISTS `g5_mail` ( `ma_id` int(11) NOT NULL auto_increment, `ma_subject` varchar(255) NOT NULL default '', `ma_content` mediumtext NOT NULL, `ma_time` datetime NOT NULL default '0000-00-00 00:00:00', `ma_ip` varchar(255) NOT NULL default '', `ma_last_option` text NOT NULL, PRIMARY KEY (`ma_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_member` --
DROP TABLE IF EXISTS `g5_member`; CREATE TABLE IF NOT EXISTS `g5_member` ( `mb_no` int(11) NOT NULL auto_increment, `mb_id` varchar(20) NOT NULL default '', `mb_password` varchar(255) NOT NULL default '', `mb_name` varchar(255) NOT NULL default '', `mb_nick` varchar(255) NOT NULL default '', `mb_nick_date` date NOT NULL default '0000-00-00', `mb_email` varchar(255) NOT NULL default '', `mb_homepage` varchar(255) NOT NULL default '', `mb_level` tinyint(4) NOT NULL default '0', `mb_sex` char(1) NOT NULL default '', `mb_birth` varchar(255) NOT NULL default '', `mb_tel` varchar(255) NOT NULL default '', `mb_hp` varchar(255) NOT NULL default '', `mb_certify` varchar(20) NOT NULL default '', `mb_adult` tinyint(4) NOT NULL default '0', `mb_dupinfo` varchar(255) NOT NULL default '', `mb_zip1` char(3) NOT NULL default '', `mb_zip2` char(3) NOT NULL default '', `mb_addr1` varchar(255) NOT NULL default '', `mb_addr2` varchar(255) NOT NULL default '', `mb_addr3` varchar(255) NOT NULL default '', `mb_addr_jibeon` varchar(255) NOT NULL default '', `mb_signature` text NOT NULL, `mb_recommend` varchar(255) NOT NULL default '', `mb_point` int(11) NOT NULL default '0', `mb_today_login` datetime NOT NULL default '0000-00-00 00:00:00', `mb_login_ip` varchar(255) NOT NULL default '', `mb_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `mb_ip` varchar(255) NOT NULL default '', `mb_leave_date` varchar(8) NOT NULL default '', `mb_intercept_date` varchar(8) NOT NULL default '', `mb_email_certify` datetime NOT NULL default '0000-00-00 00:00:00', `mb_email_certify2` varchar(255) NOT NULL default '', `mb_memo` text NOT NULL, `mb_lost_certify` varchar(255) NOT NULL, `mb_mailling` tinyint(4) NOT NULL default '0', `mb_sms` tinyint(4) NOT NULL default '0', `mb_open` tinyint(4) NOT NULL default '0', `mb_open_date` date NOT NULL default '0000-00-00', `mb_profile` text NOT NULL, `mb_memo_call` varchar(255) NOT NULL default '', `mb_memo_cnt` int(11) NOT NULL DEFAULT '0', `mb_scrap_cnt` int(11) NOT NULL default '0', `mb_1` varchar(255) NOT NULL default '', `mb_2` varchar(255) NOT NULL default '', `mb_3` varchar(255) NOT NULL default '', `mb_4` varchar(255) NOT NULL default '', `mb_5` varchar(255) NOT NULL default '', `mb_6` varchar(255) NOT NULL default '', `mb_7` varchar(255) NOT NULL default '', `mb_8` varchar(255) NOT NULL default '', `mb_9` varchar(255) NOT NULL default '', `mb_10` varchar(255) NOT NULL default '', PRIMARY KEY (`mb_no`), UNIQUE KEY `mb_id` (`mb_id`), KEY `mb_today_login` (`mb_today_login`), KEY `mb_datetime` (`mb_datetime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_memo` --
DROP TABLE IF EXISTS `g5_memo`; CREATE TABLE IF NOT EXISTS `g5_memo` ( `me_id` INT(11) NOT NULL AUTO_INCREMENT, `me_recv_mb_id` varchar(20) NOT NULL default '', `me_send_mb_id` varchar(20) NOT NULL default '', `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `me_memo` text NOT NULL, `me_send_id` INT(11) NOT NULL DEFAULT '0', `me_type` ENUM('send','recv') NOT NULL DEFAULT 'recv', `me_send_ip` VARCHAR(100) NOT NULL DEFAULT '', PRIMARY KEY (`me_id`), KEY `me_recv_mb_id` (`me_recv_mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_point` --
DROP TABLE IF EXISTS `g5_point`; CREATE TABLE IF NOT EXISTS `g5_point` ( `po_id` int(11) NOT NULL auto_increment, `mb_id` varchar(20) NOT NULL default '', `po_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `po_content` varchar(255) NOT NULL default '', `po_point` int(11) NOT NULL default '0', `po_use_point` int(11) NOT NULL default '0', `po_expired` tinyint(4) NOT NULL default '0', `po_expire_date` date NOT NULL default '0000-00-00', `po_mb_point` int(11) NOT NULL default '0', `po_rel_table` varchar(20) NOT NULL default '', `po_rel_id` varchar(20) NOT NULL default '', `po_rel_action` varchar(100) NOT NULL default '', PRIMARY KEY (`po_id`), KEY `index1` (`mb_id`,`po_rel_table`,`po_rel_id`,`po_rel_action`), KEY `index2` (`po_expire_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_poll` --
DROP TABLE IF EXISTS `g5_poll`; CREATE TABLE IF NOT EXISTS `g5_poll` ( `po_id` int(11) NOT NULL auto_increment, `po_subject` varchar(255) NOT NULL default '', `po_poll1` varchar(255) NOT NULL default '', `po_poll2` varchar(255) NOT NULL default '', `po_poll3` varchar(255) NOT NULL default '', `po_poll4` varchar(255) NOT NULL default '', `po_poll5` varchar(255) NOT NULL default '', `po_poll6` varchar(255) NOT NULL default '', `po_poll7` varchar(255) NOT NULL default '', `po_poll8` varchar(255) NOT NULL default '', `po_poll9` varchar(255) NOT NULL default '', `po_cnt1` int(11) NOT NULL default '0', `po_cnt2` int(11) NOT NULL default '0', `po_cnt3` int(11) NOT NULL default '0', `po_cnt4` int(11) NOT NULL default '0', `po_cnt5` int(11) NOT NULL default '0', `po_cnt6` int(11) NOT NULL default '0', `po_cnt7` int(11) NOT NULL default '0', `po_cnt8` int(11) NOT NULL default '0', `po_cnt9` int(11) NOT NULL default '0', `po_etc` varchar(255) NOT NULL default '', `po_level` tinyint(4) NOT NULL default '0', `po_point` int(11) NOT NULL default '0', `po_date` date NOT NULL default '0000-00-00', `po_ips` mediumtext NOT NULL, `mb_ids` text NOT NULL, `po_use` tinyint(4) NOT NULL default '0', PRIMARY KEY (`po_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_poll_etc` --
DROP TABLE IF EXISTS `g5_poll_etc`; CREATE TABLE IF NOT EXISTS `g5_poll_etc` ( `pc_id` int(11) NOT NULL default '0', `po_id` int(11) NOT NULL default '0', `mb_id` varchar(20) NOT NULL default '', `pc_name` varchar(255) NOT NULL default '', `pc_idea` varchar(255) NOT NULL default '', `pc_datetime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`pc_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_popular` --
DROP TABLE IF EXISTS `g5_popular`; CREATE TABLE IF NOT EXISTS `g5_popular` ( `pp_id` int(11) NOT NULL auto_increment, `pp_word` varchar(50) NOT NULL default '', `pp_date` date NOT NULL default '0000-00-00', `pp_ip` varchar(50) NOT NULL default '', PRIMARY KEY (`pp_id`), UNIQUE KEY `index1` (`pp_date`,`pp_word`,`pp_ip`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_scrap` --
DROP TABLE IF EXISTS `g5_scrap`; CREATE TABLE IF NOT EXISTS `g5_scrap` ( `ms_id` int(11) NOT NULL auto_increment, `mb_id` varchar(20) NOT NULL default '', `bo_table` varchar(20) NOT NULL default '', `wr_id` varchar(15) NOT NULL default '', `ms_datetime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ms_id`), KEY `mb_id` (`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_visit` --
DROP TABLE IF EXISTS `g5_visit`; CREATE TABLE IF NOT EXISTS `g5_visit` ( `vi_id` int(11) NOT NULL default '0', `vi_ip` varchar(100) NOT NULL default '', `vi_date` date NOT NULL default '0000-00-00', `vi_time` time NOT NULL default '00:00:00', `vi_referer` text NOT NULL, `vi_agent` varchar(200) NOT NULL default '', `vi_browser` varchar(255) NOT NULL DEFAULT '', `vi_os` varchar(255) NOT NULL DEFAULT '', `vi_device` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`vi_id`), UNIQUE KEY `index1` (`vi_ip`,`vi_date`), KEY `index2` (`vi_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_visit_sum` --
DROP TABLE IF EXISTS `g5_visit_sum`; CREATE TABLE IF NOT EXISTS `g5_visit_sum` ( `vs_date` date NOT NULL default '0000-00-00', `vs_count` int(11) NOT NULL default '0', PRIMARY KEY (`vs_date`), KEY `index1` (`vs_count`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_unique` --
DROP TABLE IF EXISTS `g5_uniqid`; CREATE TABLE IF NOT EXISTS `g5_uniqid` ( `uq_id` bigint(20) unsigned NOT NULL, `uq_ip` varchar(255) NOT NULL, PRIMARY KEY (`uq_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_autosave` --
DROP TABLE IF EXISTS `g5_autosave`; CREATE TABLE IF NOT EXISTS `g5_autosave` ( `as_id` int(11) NOT NULL AUTO_INCREMENT, `mb_id` varchar(20) NOT NULL, `as_uid` bigint(20) unsigned NOT NULL, `as_subject` varchar(255) NOT NULL, `as_content` text NOT NULL, `as_datetime` datetime NOT NULL, PRIMARY KEY (`as_id`), UNIQUE KEY `as_uid` (`as_uid`), KEY `mb_id` (`mb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_qa_config` --
DROP TABLE IF EXISTS `g5_qa_config`; CREATE TABLE IF NOT EXISTS `g5_qa_config` ( `qa_title` varchar(255) NOT NULL DEFAULT'', `qa_category` varchar(255) NOT NULL DEFAULT'', `qa_skin` varchar(255) NOT NULL DEFAULT '', `qa_mobile_skin` varchar(255) NOT NULL DEFAULT '', `qa_use_email` tinyint(4) NOT NULL DEFAULT '0', `qa_req_email` tinyint(4) NOT NULL DEFAULT '0', `qa_use_hp` tinyint(4) NOT NULL DEFAULT '0', `qa_req_hp` tinyint(4) NOT NULL DEFAULT '0', `qa_use_sms` tinyint(4) NOT NULL DEFAULT '0', `qa_send_number` varchar(255) NOT NULL DEFAULT '0', `qa_admin_hp` varchar(255) NOT NULL DEFAULT '', `qa_admin_email` varchar(255) NOT NULL DEFAULT '', `qa_use_editor` tinyint(4) NOT NULL DEFAULT '0', `qa_subject_len` int(11) NOT NULL DEFAULT '0', `qa_mobile_subject_len` int(11) NOT NULL DEFAULT '0', `qa_page_rows` int(11) NOT NULL DEFAULT '0', `qa_mobile_page_rows` int(11) NOT NULL DEFAULT '0', `qa_image_width` int(11) NOT NULL DEFAULT '0', `qa_upload_size` int(11) NOT NULL DEFAULT '0', `qa_insert_content` text NOT NULL, `qa_include_head` varchar(255) NOT NULL DEFAULT '', `qa_include_tail` varchar(255) NOT NULL DEFAULT '', `qa_content_head` text NOT NULL, `qa_content_tail` text NOT NULL, `qa_mobile_content_head` text NOT NULL, `qa_mobile_content_tail` text NOT NULL, `qa_1_subj` varchar(255) NOT NULL DEFAULT '', `qa_2_subj` varchar(255) NOT NULL DEFAULT '', `qa_3_subj` varchar(255) NOT NULL DEFAULT '', `qa_4_subj` varchar(255) NOT NULL DEFAULT '', `qa_5_subj` varchar(255) NOT NULL DEFAULT '', `qa_1` varchar(255) NOT NULL DEFAULT '', `qa_2` varchar(255) NOT NULL DEFAULT '', `qa_3` varchar(255) NOT NULL DEFAULT '', `qa_4` varchar(255) NOT NULL DEFAULT '', `qa_5` varchar(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_qa_content` --
DROP TABLE IF EXISTS `g5_qa_content`; CREATE TABLE IF NOT EXISTS `g5_qa_content` ( `qa_id` int(11) NOT NULL AUTO_INCREMENT, `qa_num` int(11) NOT NULL DEFAULT '0', `qa_parent` int(11) NOT NULL DEFAULT '0', `qa_related` int(11) NOT NULL DEFAULT '0', `mb_id` varchar(20) NOT NULL DEFAULT '', `qa_name` varchar(255) NOT NULL DEFAULT '', `qa_email` varchar(255) NOT NULL DEFAULT '', `qa_hp` varchar(255) NOT NULL DEFAULT '', `qa_type` tinyint(4) NOT NULL DEFAULT '0', `qa_category` varchar(255) NOT NULL DEFAULT '', `qa_email_recv` tinyint(4) NOT NULL DEFAULT '0', `qa_sms_recv` tinyint(4) NOT NULL DEFAULT '0', `qa_html` tinyint(4) NOT NULL DEFAULT '0', `qa_subject` varchar(255) NOT NULL DEFAULT '', `qa_content` text NOT NULL, `qa_status` tinyint(4) NOT NULL DEFAULT '0', `qa_file1` varchar(255) NOT NULL DEFAULT '', `qa_source1` varchar(255) NOT NULL DEFAULT '', `qa_file2` varchar(255) NOT NULL DEFAULT '', `qa_source2` varchar(255) NOT NULL DEFAULT '', `qa_ip` varchar(255) NOT NULL DEFAULT '', `qa_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `qa_1` varchar(255) NOT NULL DEFAULT '', `qa_2` varchar(255) NOT NULL DEFAULT '', `qa_3` varchar(255) NOT NULL DEFAULT '', `qa_4` varchar(255) NOT NULL DEFAULT '', `qa_5` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`qa_id`), KEY `qa_num_parent` (`qa_num`,`qa_parent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_content` --
DROP TABLE IF EXISTS `g5_content`; CREATE TABLE IF NOT EXISTS `g5_content` ( `co_id` varchar(20) NOT NULL DEFAULT '', `co_html` tinyint(4) NOT NULL DEFAULT '0', `co_subject` varchar(255) NOT NULL DEFAULT '', `co_content` longtext NOT NULL, `co_seo_title` varchar(255) NOT NULL DEFAULT '', `co_mobile_content` longtext NOT NULL, `co_skin` varchar(255) NOT NULL DEFAULT '', `co_mobile_skin` varchar(255) NOT NULL DEFAULT '', `co_tag_filter_use` tinyint(4) NOT NULL DEFAULT '0', `co_hit` int(11) NOT NULL DEFAULT '0', `co_include_head` varchar(255) NOT NULL, `co_include_tail` varchar(255) NOT NULL, PRIMARY KEY (`co_id`), KEY `co_seo_title` (`co_seo_title`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_faq` --
DROP TABLE IF EXISTS `g5_faq`; CREATE TABLE IF NOT EXISTS `g5_faq` ( `fa_id` int(11) NOT NULL AUTO_INCREMENT, `fm_id` int(11) NOT NULL DEFAULT '0', `fa_subject` text NOT NULL, `fa_content` text NOT NULL, `fa_order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`fa_id`), KEY `fm_id` (`fm_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_faq_master` --
DROP TABLE IF EXISTS `g5_faq_master`; CREATE TABLE IF NOT EXISTS `g5_faq_master` ( `fm_id` int(11) NOT NULL AUTO_INCREMENT, `fm_subject` varchar(255) NOT NULL DEFAULT '', `fm_head_html` text NOT NULL, `fm_tail_html` text NOT NULL, `fm_mobile_head_html` text NOT NULL, `fm_mobile_tail_html` text NOT NULL, `fm_order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`fm_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_member_social_profiles` --
DROP TABLE IF EXISTS `g5_member_social_profiles`; CREATE TABLE IF NOT EXISTS `g5_member_social_profiles` ( `mp_no` int(11) NOT NULL AUTO_INCREMENT, `mb_id` varchar(255) NOT NULL DEFAULT '', `provider` varchar(50) NOT NULL DEFAULT '', `object_sha` varchar(45) NOT NULL DEFAULT '', `identifier` varchar(255) NOT NULL DEFAULT '', `profileurl` varchar(255) NOT NULL DEFAULT '', `photourl` varchar(255) NOT NULL DEFAULT '', `displayname` varchar(150) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `mp_register_day` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `mp_latest_day` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', UNIQUE KEY `mp_no` (`mp_no`), KEY `mb_id` (`mb_id`), KEY `provider` (`provider`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_new_win` --
DROP TABLE IF EXISTS `g5_new_win`; CREATE TABLE IF NOT EXISTS `g5_new_win` ( `nw_id` int(11) NOT NULL AUTO_INCREMENT, `nw_division` varchar(10) NOT NULL DEFAULT 'both', `nw_device` varchar(10) NOT NULL DEFAULT 'both', `nw_begin_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `nw_end_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `nw_disable_hours` int(11) NOT NULL DEFAULT '0', `nw_left` int(11) NOT NULL DEFAULT '0', `nw_top` int(11) NOT NULL DEFAULT '0', `nw_height` int(11) NOT NULL DEFAULT '0', `nw_width` int(11) NOT NULL DEFAULT '0', `nw_subject` text NOT NULL, `nw_content` text NOT NULL, `nw_content_html` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`nw_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `g5_menu` --
DROP TABLE IF EXISTS `g5_menu`; CREATE TABLE IF NOT EXISTS `g5_menu` ( `me_id` int(11) NOT NULL AUTO_INCREMENT, `me_code` varchar(255) NOT NULL DEFAULT '', `me_name` varchar(255) NOT NULL DEFAULT '', `me_link` varchar(255) NOT NULL DEFAULT '', `me_target` varchar(255) NOT NULL DEFAULT '', `me_order` int(11) NOT NULL DEFAULT '0', `me_use` tinyint(4) NOT NULL DEFAULT '0', `me_mobile_use` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`me_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[/CODE]
댓글을 작성하려면 로그인이 필요합니다.
그누보드 5.2 DB테이블 http://www.gnuwiz.com/bbs/board.php?bo_table=gnu_tip&sca=%EA%B7%B8%EB%88%84%EB%B3%B4%EB%93%9C+5.2+DB%ED%85%8C%EC%9D%B4%EB%B8%94
영카트 5.2 DB테이블 http://www.gnuwiz.com/bbs/board.php?bo_table=young_tip&sca=%EC%98%81%EC%B9%B4%ED%8A%B8+5.2+DB%ED%85%8C%EC%9D%B4%EB%B8%94
참고하세요
댓글을 작성하려면 로그인이 필요합니다.
댓글을 작성하려면 로그인이 필요합니다.
gnuboard5shop DB
</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_banner`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_banner`;
CREATE TABLE IF NOT EXISTS `g5_shop_banner` (
`bn_id` int(11) NOT NULL AUTO_INCREMENT,
`bn_alt` varchar(255) NOT NULL DEFAULT '',
`bn_url` varchar(255) NOT NULL DEFAULT '',
`bn_device` varchar(10) NOT NULL DEFAULT '',
`bn_position` varchar(255) NOT NULL DEFAULT '',
`bn_border` tinyint(4) NOT NULL DEFAULT '0',
`bn_new_win` tinyint(4) NOT NULL DEFAULT '0',
`bn_begin_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`bn_end_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`bn_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`bn_hit` int(11) NOT NULL DEFAULT '0',
`bn_order` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`bn_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_cart`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_cart`;
CREATE TABLE IF NOT EXISTS `g5_shop_cart` (
`ct_id` int(11) NOT NULL AUTO_INCREMENT,
`od_id` bigint(20) unsigned NOT NULL,
`mb_id` varchar(255) NOT NULL DEFAULT '',
`it_id` varchar(20) NOT NULL DEFAULT '',
`it_name` varchar(255) NOT NULL DEFAULT '',
`it_sc_type` tinyint(4) NOT NULL DEFAULT '0',
`it_sc_method` tinyint(4) NOT NULL DEFAULT '0',
`it_sc_price` int(11) NOT NULL DEFAULT '0',
`it_sc_minimum` int(11) NOT NULL DEFAULT '0',
`it_sc_qty` int(11) NOT NULL DEFAULT '0',
`ct_status` varchar(255) NOT NULL DEFAULT '',
`ct_history` text NOT NULL,
`ct_price` int(11) NOT NULL DEFAULT '0',
`ct_point` int(11) NOT NULL DEFAULT '0',
`cp_price` int(11) NOT NULL DEFAULT '0',
`ct_point_use` tinyint(4) NOT NULL DEFAULT '0',
`ct_stock_use` tinyint(4) NOT NULL DEFAULT '0',
`ct_option` varchar(255) NOT NULL DEFAULT '',
`ct_qty` int(11) NOT NULL DEFAULT '0',
`ct_notax` tinyint(4) NOT NULL DEFAULT '0',
`io_id` varchar(255) NOT NULL DEFAULT '',
`io_type` tinyint(4) NOT NULL DEFAULT '0',
`io_price` int(11) NOT NULL DEFAULT '0',
`ct_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ct_ip` varchar(25) NOT NULL DEFAULT '',
`ct_send_cost` tinyint(4) NOT NULL DEFAULT '0',
`ct_direct` tinyint(4) NOT NULL DEFAULT '0',
`ct_select` tinyint(4) NOT NULL DEFAULT '0',
`ct_select_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`ct_id`),
KEY `od_id` (`od_id`),
KEY `it_id` (`it_id`),
KEY `ct_status` (`ct_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_category`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_category`;
CREATE TABLE IF NOT EXISTS `g5_shop_category` (
`ca_id` varchar(10) NOT NULL DEFAULT '0',
`ca_name` varchar(255) NOT NULL DEFAULT '',
`ca_order` int(11) NOT NULL DEFAULT '0',
`ca_skin_dir` varchar(255) NOT NULL DEFAULT '',
`ca_mobile_skin_dir` varchar(255) NOT NULL DEFAULT '',
`ca_skin` varchar(255) NOT NULL DEFAULT '',
`ca_mobile_skin` varchar(255) NOT NULL DEFAULT '',
`ca_img_width` int(11) NOT NULL DEFAULT '0',
`ca_img_height` int(11) NOT NULL DEFAULT '0',
`ca_mobile_img_width` int(11) NOT NULL DEFAULT '0',
`ca_mobile_img_height` int(11) NOT NULL DEFAULT '0',
`ca_sell_email` varchar(255) NOT NULL DEFAULT '',
`ca_use` tinyint(4) NOT NULL DEFAULT '0',
`ca_stock_qty` int(11) NOT NULL DEFAULT '0',
`ca_explan_html` tinyint(4) NOT NULL DEFAULT '0',
`ca_head_html` text NOT NULL,
`ca_tail_html` text NOT NULL,
`ca_mobile_head_html` text NOT NULL,
`ca_mobile_tail_html` text NOT NULL,
`ca_list_mod` int(11) NOT NULL DEFAULT '0',
`ca_list_row` int(11) NOT NULL DEFAULT '0',
`ca_mobile_list_mod` int(11) NOT NULL DEFAULT '0',
`ca_mobile_list_row` int(11) NOT NULL DEFAULT '0',
`ca_include_head` varchar(255) NOT NULL DEFAULT '',
`ca_include_tail` varchar(255) NOT NULL DEFAULT '',
`ca_mb_id` varchar(255) NOT NULL DEFAULT '',
`ca_cert_use` tinyint(4) NOT NULL DEFAULT '0',
`ca_adult_use` tinyint(4) NOT NULL DEFAULT '0',
`ca_nocoupon` tinyint(4) NOT NULL DEFAULT '0',
`ca_1_subj` varchar(255) NOT NULL DEFAULT '',
`ca_2_subj` varchar(255) NOT NULL DEFAULT '',
`ca_3_subj` varchar(255) NOT NULL DEFAULT '',
`ca_4_subj` varchar(255) NOT NULL DEFAULT '',
`ca_5_subj` varchar(255) NOT NULL DEFAULT '',
`ca_6_subj` varchar(255) NOT NULL DEFAULT '',
`ca_7_subj` varchar(255) NOT NULL DEFAULT '',
`ca_8_subj` varchar(255) NOT NULL DEFAULT '',
`ca_9_subj` varchar(255) NOT NULL DEFAULT '',
`ca_10_subj` varchar(255) NOT NULL DEFAULT '',
`ca_1` varchar(255) NOT NULL DEFAULT '',
`ca_2` varchar(255) NOT NULL DEFAULT '',
`ca_3` varchar(255) NOT NULL DEFAULT '',
`ca_4` varchar(255) NOT NULL DEFAULT '',
`ca_5` varchar(255) NOT NULL DEFAULT '',
`ca_6` varchar(255) NOT NULL DEFAULT '',
`ca_7` varchar(255) NOT NULL DEFAULT '',
`ca_8` varchar(255) NOT NULL DEFAULT '',
`ca_9` varchar(255) NOT NULL DEFAULT '',
`ca_10` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`ca_id`),
KEY `ca_order` (`ca_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_coupon`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_coupon`;
CREATE TABLE IF NOT EXISTS `g5_shop_coupon` (
`cp_no` INT(11) NOT NULL AUTO_INCREMENT,
`cp_id` VARCHAR(100) NOT NULL DEFAULT '',
`cp_subject` VARCHAR(255) NOT NULL DEFAULT '',
`cp_method` TINYINT(4) NOT NULL DEFAULT '0',
`cp_target` VARCHAR(255) NOT NULL DEFAULT '',
`mb_id` VARCHAR(255) NOT NULL DEFAULT '',
`cz_id` int(11) NOT NULL DEFAULT '0',
`cp_start` DATE NOT NULL DEFAULT '0000-00-00',
`cp_end` DATE NOT NULL DEFAULT '0000-00-00',
`cp_price` INT(11) NOT NULL DEFAULT '0',
`cp_type` TINYINT(4) NOT NULL DEFAULT '0',
`cp_trunc` INT(11) NOT NULL DEFAULT '0',
`cp_minimum` INT(11) NOT NULL DEFAULT '0',
`cp_maximum` INT(11) NOT NULL DEFAULT '0',
`od_id` bigint(20) unsigned NOT NULL,
`cp_datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`cp_no`),
UNIQUE KEY `cp_id` (`cp_id`),
KEY `mb_id` (`mb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_coupon_log`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_coupon_log`;
CREATE TABLE IF NOT EXISTS `g5_shop_coupon_log` (
`cl_id` int(11) NOT NULL AUTO_INCREMENT,
`cp_id` varchar(100) NOT NULL DEFAULT '',
`mb_id` varchar(100) NOT NULL DEFAULT '',
`od_id` bigint(20) NOT NULL,
`cp_price` int(11) NOT NULL DEFAULT '0',
`cl_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`cl_id`),
KEY `mb_id` (`mb_id`),
KEY `od_id` (`od_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_coupon_zone`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_coupon_zone`;
CREATE TABLE IF NOT EXISTS `g5_shop_coupon_zone` (
`cz_id` int(11) NOT NULL AUTO_INCREMENT,
`cz_type` tinyint(4) NOT NULL DEFAULT '0',
`cz_subject` varchar(255) NOT NULL DEFAULT '',
`cz_start` DATE NOT NULL DEFAULT '0000-00-00',
`cz_end` DATE NOT NULL DEFAULT '0000-00-00',
`cz_file` varchar(255) NOT NULL DEFAULT '',
`cz_period` int(11) NOT NULL DEFAULT '0',
`cz_point` INT(11) NOT NULL DEFAULT '0',
`cp_method` TINYINT(4) NOT NULL DEFAULT '0',
`cp_target` VARCHAR(255) NOT NULL DEFAULT '',
`cp_price` INT(11) NOT NULL DEFAULT '0',
`cp_type` TINYINT(4) NOT NULL DEFAULT '0',
`cp_trunc` INT(11) NOT NULL DEFAULT '0',
`cp_minimum` INT(11) NOT NULL DEFAULT '0',
`cp_maximum` INT(11) NOT NULL DEFAULT '0',
`cz_download` int(11) NOT NULL DEFAULT '0',
`cz_datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`cz_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_default`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_default`;
CREATE TABLE IF NOT EXISTS `g5_shop_default` (
`de_admin_company_owner` varchar(255) NOT NULL DEFAULT '',
`de_admin_company_name` varchar(255) NOT NULL DEFAULT '',
`de_admin_company_saupja_no` varchar(255) NOT NULL DEFAULT '',
`de_admin_company_tel` varchar(255) NOT NULL DEFAULT '',
`de_admin_company_fax` varchar(255) NOT NULL DEFAULT '',
`de_admin_tongsin_no` varchar(255) NOT NULL DEFAULT '',
`de_admin_company_zip` varchar(255) NOT NULL DEFAULT '',
`de_admin_company_addr` varchar(255) NOT NULL DEFAULT '',
`de_admin_info_name` varchar(255) NOT NULL DEFAULT '',
`de_admin_info_email` varchar(255) NOT NULL DEFAULT '',
`de_shop_skin` varchar(255) NOT NULL DEFAULT '',
`de_shop_mobile_skin` varchar(255) NOT NULL DEFAULT '',
`de_type1_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_type1_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_type1_list_mod` int(11) NOT NULL DEFAULT '0',
`de_type1_list_row` int(11) NOT NULL DEFAULT '0',
`de_type1_img_width` int(11) NOT NULL DEFAULT '0',
`de_type1_img_height` int(11) NOT NULL DEFAULT '0',
`de_type2_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_type2_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_type2_list_mod` int(11) NOT NULL DEFAULT '0',
`de_type2_list_row` int(11) NOT NULL DEFAULT '0',
`de_type2_img_width` int(11) NOT NULL DEFAULT '0',
`de_type2_img_height` int(11) NOT NULL DEFAULT '0',
`de_type3_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_type3_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_type3_list_mod` int(11) NOT NULL DEFAULT '0',
`de_type3_list_row` int(11) NOT NULL DEFAULT '0',
`de_type3_img_width` int(11) NOT NULL DEFAULT '0',
`de_type3_img_height` int(11) NOT NULL DEFAULT '0',
`de_type4_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_type4_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_type4_list_mod` int(11) NOT NULL DEFAULT '0',
`de_type4_list_row` int(11) NOT NULL DEFAULT '0',
`de_type4_img_width` int(11) NOT NULL DEFAULT '0',
`de_type4_img_height` int(11) NOT NULL DEFAULT '0',
`de_type5_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_type5_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_type5_list_mod` int(11) NOT NULL DEFAULT '0',
`de_type5_list_row` int(11) NOT NULL DEFAULT '0',
`de_type5_img_width` int(11) NOT NULL DEFAULT '0',
`de_type5_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_type1_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_mobile_type1_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_type1_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_type1_list_row` int(11) NOT NULL DEFAULT '0',
`de_mobile_type1_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_type1_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_type2_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_mobile_type2_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_type2_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_type2_list_row` int(11) NOT NULL DEFAULT '0',
`de_mobile_type2_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_type2_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_type3_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_mobile_type3_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_type3_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_type3_list_row` int(11) NOT NULL DEFAULT '0',
`de_mobile_type3_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_type3_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_type4_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_mobile_type4_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_type4_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_type4_list_row` int(11) NOT NULL DEFAULT '0',
`de_mobile_type4_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_type4_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_type5_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_mobile_type5_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_type5_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_type5_list_row` int(11) NOT NULL DEFAULT '0',
`de_mobile_type5_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_type5_img_height` int(11) NOT NULL DEFAULT '0',
`de_rel_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_rel_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_rel_list_mod` int(11) NOT NULL DEFAULT '0',
`de_rel_img_width` int(11) NOT NULL DEFAULT '0',
`de_rel_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_rel_list_use` tinyint(4) NOT NULL DEFAULT '0',
`de_mobile_rel_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_rel_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_rel_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_rel_img_height` int(11) NOT NULL DEFAULT '0',
`de_search_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_search_list_mod` int(11) NOT NULL DEFAULT '0',
`de_search_list_row` int(11) NOT NULL DEFAULT '0',
`de_search_img_width` int(11) NOT NULL DEFAULT '0',
`de_search_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_search_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_search_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_search_list_row` int(11) NOT NULL DEFAULT '0',
`de_mobile_search_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_search_img_height` int(11) NOT NULL DEFAULT '0',
`de_listtype_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_listtype_list_mod` int(11) NOT NULL DEFAULT '0',
`de_listtype_list_row` int(11) NOT NULL DEFAULT '0',
`de_listtype_img_width` int(11) NOT NULL DEFAULT '0',
`de_listtype_img_height` int(11) NOT NULL DEFAULT '0',
`de_mobile_listtype_list_skin` varchar(255) NOT NULL DEFAULT '',
`de_mobile_listtype_list_mod` int(11) NOT NULL DEFAULT '0',
`de_mobile_listtype_list_row` int(11) NOT NULL DEFAULT '0',
`de_mobile_listtype_img_width` int(11) NOT NULL DEFAULT '0',
`de_mobile_listtype_img_height` int(11) NOT NULL DEFAULT '0',
`de_bank_use` int(11) NOT NULL DEFAULT '0',
`de_bank_account` text NOT NULL,
`de_card_test` int(11) NOT NULL DEFAULT '0',
`de_card_use` int(11) NOT NULL DEFAULT '0',
`de_card_noint_use` tinyint(4) NOT NULL DEFAULT '0',
`de_card_point` int(11) NOT NULL DEFAULT '0',
`de_settle_min_point` int(11) NOT NULL DEFAULT '0',
`de_settle_max_point` int(11) NOT NULL DEFAULT '0',
`de_settle_point_unit` int(11) NOT NULL DEFAULT '0',
`de_level_sell` int(11) NOT NULL DEFAULT '0',
`de_delivery_company` varchar(255) NOT NULL DEFAULT '',
`de_send_cost_case` varchar(255) NOT NULL DEFAULT '',
`de_send_cost_limit` varchar(255) NOT NULL DEFAULT '',
`de_send_cost_list` varchar(255) NOT NULL DEFAULT '',
`de_hope_date_use` int(11) NOT NULL DEFAULT '0',
`de_hope_date_after` int(11) NOT NULL DEFAULT '0',
`de_baesong_content` text NOT NULL,
`de_change_content` text NOT NULL,
`de_point_days` int(11) NOT NULL DEFAULT '0',
`de_simg_width` int(11) NOT NULL DEFAULT '0',
`de_simg_height` int(11) NOT NULL DEFAULT '0',
`de_mimg_width` int(11) NOT NULL DEFAULT '0',
`de_mimg_height` int(11) NOT NULL DEFAULT '0',
`de_sms_cont1` text NOT NULL,
`de_sms_cont2` text NOT NULL,
`de_sms_cont3` text NOT NULL,
`de_sms_cont4` text NOT NULL,
`de_sms_cont5` text NOT NULL,
`de_sms_use1` tinyint(4) NOT NULL DEFAULT '0',
`de_sms_use2` tinyint(4) NOT NULL DEFAULT '0',
`de_sms_use3` tinyint(4) NOT NULL DEFAULT '0',
`de_sms_use4` tinyint(4) NOT NULL DEFAULT '0',
`de_sms_use5` tinyint(4) NOT NULL DEFAULT '0',
`de_sms_hp` varchar(255) NOT NULL DEFAULT '',
`de_pg_service` varchar(255) NOT NULL DEFAULT '',
`de_kcp_mid` varchar(255) NOT NULL DEFAULT '',
`de_kcp_site_key` varchar(255) NOT NULL DEFAULT '',
`de_inicis_mid` varchar(255) NOT NULL DEFAULT '',
`de_inicis_iniapi_key` varchar(30) NOT NULL DEFAULT '',
`de_inicis_iniapi_iv` varchar(30) NOT NULL DEFAULT '',
`de_inicis_sign_key` varchar(255) NOT NULL DEFAULT '',
`de_iche_use` tinyint(4) NOT NULL DEFAULT '0',
`de_easy_pay_use` tinyint(4) NOT NULL DEFAULT '0',
`de_easy_pay_services` varchar(255) NOT NULL DEFAULT '',
`de_samsung_pay_use` tinyint(4) NOT NULL DEFAULT '0',
`de_inicis_lpay_use` tinyint(4) NOT NULL DEFAULT '0',
`de_inicis_kakaopay_use` tinyint(4) NOT NULL DEFAULT '0',
`de_inicis_cartpoint_use` tinyint(4) NOT NULL DEFAULT '0',
`de_item_use_use` tinyint(4) NOT NULL DEFAULT '0',
`de_item_use_write` tinyint(4) NOT NULL DEFAULT '0',
`de_code_dup_use` tinyint(4) NOT NULL DEFAULT '0',
`de_cart_keep_term` int(11) NOT NULL DEFAULT '0',
`de_guest_cart_use` tinyint(4) NOT NULL DEFAULT '0',
`de_admin_buga_no` varchar(255) NOT NULL DEFAULT '',
`de_vbank_use` varchar(255) NOT NULL DEFAULT '',
`de_taxsave_use` tinyint(4) NOT NULL,
`de_taxsave_types` set('account','vbank','transfer') NOT NULL DEFAULT 'account',
`de_guest_privacy` text NOT NULL,
`de_hp_use` tinyint(4) NOT NULL DEFAULT '0',
`de_escrow_use` tinyint(4) NOT NULL DEFAULT '0',
`de_tax_flag_use` tinyint(4) NOT NULL DEFAULT '0',
`de_kakaopay_mid` varchar(255) NOT NULL DEFAULT '',
`de_kakaopay_key` varchar(255) NOT NULL DEFAULT '',
`de_kakaopay_enckey` varchar(255) NOT NULL DEFAULT '',
`de_kakaopay_hashkey` varchar(255) NOT NULL DEFAULT '',
`de_kakaopay_cancelpwd` varchar(255) NOT NULL DEFAULT '',
`de_naverpay_mid` varchar(255) NOT NULL DEFAULT '',
`de_naverpay_cert_key` varchar(255) NOT NULL DEFAULT '',
`de_naverpay_button_key` varchar(255) NOT NULL DEFAULT '',
`de_naverpay_test` tinyint(4) NOT NULL DEFAULT '0',
`de_naverpay_mb_id` varchar(255) NOT NULL DEFAULT '',
`de_naverpay_sendcost` varchar(255) NOT NULL DEFAULT '',
`de_member_reg_coupon_use` tinyint(4) NOT NULL DEFAULT '0',
`de_member_reg_coupon_term` int(11) NOT NULL DEFAULT '0',
`de_member_reg_coupon_price` int(11) NOT NULL DEFAULT '0',
`de_member_reg_coupon_minimum` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_event`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_event`;
CREATE TABLE IF NOT EXISTS `g5_shop_event` (
`ev_id` int(11) NOT NULL AUTO_INCREMENT,
`ev_skin` varchar(255) NOT NULL DEFAULT '',
`ev_mobile_skin` varchar(255) NOT NULL DEFAULT '',
`ev_img_width` int(11) NOT NULL DEFAULT '0',
`ev_img_height` int(11) NOT NULL DEFAULT '0',
`ev_list_mod` int(11) NOT NULL DEFAULT '0',
`ev_list_row` int(11) NOT NULL DEFAULT '0',
`ev_mobile_img_width` int(11) NOT NULL DEFAULT '0',
`ev_mobile_img_height` int(11) NOT NULL DEFAULT '0',
`ev_mobile_list_mod` int(11) NOT NULL DEFAULT '0',
`ev_mobile_list_row` int(11) NOT NULL DEFAULT '0',
`ev_subject` varchar(255) NOT NULL DEFAULT '',
`ev_subject_strong` tinyint(4) NOT NULL DEFAULT '0',
`ev_head_html` text NOT NULL,
`ev_tail_html` text NOT NULL,
`ev_use` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`ev_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_event_item`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_event_item`;
CREATE TABLE IF NOT EXISTS `g5_shop_event_item` (
`ev_id` int(11) NOT NULL DEFAULT '0',
`it_id` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`ev_id`,`it_id`),
KEY `it_id` (`it_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_item`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_item`;
CREATE TABLE IF NOT EXISTS `g5_shop_item` (
`it_id` varchar(20) NOT NULL DEFAULT '',
`ca_id` varchar(10) NOT NULL DEFAULT '0',
`ca_id2` varchar(255) NOT NULL DEFAULT '',
`ca_id3` varchar(255) NOT NULL DEFAULT '',
`it_skin` varchar(255) NOT NULL DEFAULT '',
`it_mobile_skin` varchar(255) NOT NULL DEFAULT '',
`it_name` varchar(255) NOT NULL DEFAULT '',
`it_seo_title` varchar(200) NOT NULL DEFAULT '',
`it_maker` varchar(255) NOT NULL DEFAULT '',
`it_origin` varchar(255) NOT NULL DEFAULT '',
`it_brand` varchar(255) NOT NULL DEFAULT '',
`it_model` varchar(255) NOT NULL DEFAULT '',
`it_option_subject` varchar(255) NOT NULL DEFAULT '',
`it_supply_subject` varchar(255) NOT NULL DEFAULT '',
`it_type1` tinyint(4) NOT NULL DEFAULT '0',
`it_type2` tinyint(4) NOT NULL DEFAULT '0',
`it_type3` tinyint(4) NOT NULL DEFAULT '0',
`it_type4` tinyint(4) NOT NULL DEFAULT '0',
`it_type5` tinyint(4) NOT NULL DEFAULT '0',
`it_basic` text NOT NULL,
`it_explan` mediumtext NOT NULL,
`it_explan2` mediumtext NOT NULL,
`it_mobile_explan` mediumtext NOT NULL,
`it_cust_price` int(11) NOT NULL DEFAULT '0',
`it_price` int(11) NOT NULL DEFAULT '0',
`it_point` int(11) NOT NULL DEFAULT '0',
`it_point_type` tinyint(4) NOT NULL DEFAULT '0',
`it_supply_point` int(11) NOT NULL DEFAULT '0',
`it_notax` tinyint(4) NOT NULL DEFAULT '0',
`it_sell_email` varchar(255) NOT NULL DEFAULT '',
`it_use` tinyint(4) NOT NULL DEFAULT '0',
`it_nocoupon` tinyint(4) NOT NULL DEFAULT '0',
`it_soldout` tinyint(4) NOT NULL DEFAULT '0',
`it_stock_qty` int(11) NOT NULL DEFAULT '0',
`it_stock_sms` tinyint(4) NOT NULL DEFAULT '0',
`it_noti_qty` int(11) NOT NULL DEFAULT '0',
`it_sc_type` tinyint(4) NOT NULL DEFAULT '0',
`it_sc_method` tinyint(4) NOT NULL DEFAULT '0',
`it_sc_price` int(11) NOT NULL DEFAULT '0',
`it_sc_minimum` int(11) NOT NULL DEFAULT '0',
`it_sc_qty` int(11) NOT NULL DEFAULT '0',
`it_buy_min_qty` int(11) NOT NULL DEFAULT '0',
`it_buy_max_qty` int(11) NOT NULL DEFAULT '0',
`it_head_html` text NOT NULL,
`it_tail_html` text NOT NULL,
`it_mobile_head_html` text NOT NULL,
`it_mobile_tail_html` text NOT NULL,
`it_hit` int(11) NOT NULL DEFAULT '0',
`it_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`it_update_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`it_ip` varchar(25) NOT NULL DEFAULT '',
`it_order` int(11) NOT NULL DEFAULT '0',
`it_tel_inq` tinyint(4) NOT NULL DEFAULT '0',
`it_info_gubun` varchar(50) NOT NULL DEFAULT '',
`it_info_value` text NOT NULL,
`it_sum_qty` int(11) NOT NULL DEFAULT '0',
`it_use_cnt` int(11) NOT NULL DEFAULT '0',
`it_use_avg` DECIMAL(2,1) NOT NULL,
`it_shop_memo` text NOT NULL,
`ec_mall_pid` varchar(255) NOT NULL DEFAULT '',
`it_img1` varchar(255) NOT NULL DEFAULT '',
`it_img2` varchar(255) NOT NULL DEFAULT '',
`it_img3` varchar(255) NOT NULL DEFAULT '',
`it_img4` varchar(255) NOT NULL DEFAULT '',
`it_img5` varchar(255) NOT NULL DEFAULT '',
`it_img6` varchar(255) NOT NULL DEFAULT '',
`it_img7` varchar(255) NOT NULL DEFAULT '',
`it_img8` varchar(255) NOT NULL DEFAULT '',
`it_img9` varchar(255) NOT NULL DEFAULT '',
`it_img10` varchar(255) NOT NULL DEFAULT '',
`it_1_subj` varchar(255) NOT NULL DEFAULT '',
`it_2_subj` varchar(255) NOT NULL DEFAULT '',
`it_3_subj` varchar(255) NOT NULL DEFAULT '',
`it_4_subj` varchar(255) NOT NULL DEFAULT '',
`it_5_subj` varchar(255) NOT NULL DEFAULT '',
`it_6_subj` varchar(255) NOT NULL DEFAULT '',
`it_7_subj` varchar(255) NOT NULL DEFAULT '',
`it_8_subj` varchar(255) NOT NULL DEFAULT '',
`it_9_subj` varchar(255) NOT NULL DEFAULT '',
`it_10_subj` varchar(255) NOT NULL DEFAULT '',
`it_1` varchar(255) NOT NULL DEFAULT '',
`it_2` varchar(255) NOT NULL DEFAULT '',
`it_3` varchar(255) NOT NULL DEFAULT '',
`it_4` varchar(255) NOT NULL DEFAULT '',
`it_5` varchar(255) NOT NULL DEFAULT '',
`it_6` varchar(255) NOT NULL DEFAULT '',
`it_7` varchar(255) NOT NULL DEFAULT '',
`it_8` varchar(255) NOT NULL DEFAULT '',
`it_9` varchar(255) NOT NULL DEFAULT '',
`it_10` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`it_id`),
KEY `ca_id` (`ca_id`),
KEY `it_name` (`it_name`),
KEY `it_seo_title` (`it_seo_title`),
KEY `it_order` (`it_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_item_option`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_item_option`;
CREATE TABLE IF NOT EXISTS `g5_shop_item_option` (
`io_no` INT(11) NOT NULL AUTO_INCREMENT,
`io_id` VARCHAR(255) NOT NULL DEFAULT '0',
`io_type` TINYINT(4) NOT NULL DEFAULT '0',
`it_id` VARCHAR(20) NOT NULL DEFAULT '',
`io_price` INT(11) NOT NULL DEFAULT '0',
`io_stock_qty` INT(11) NOT NULL DEFAULT '0',
`io_noti_qty` INT(11) NOT NULL DEFAULT '0',
`io_use` TINYINT(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`io_no`),
KEY `io_id` (`io_id`),
KEY `it_id` (`it_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_item_use`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_item_use`;
CREATE TABLE IF NOT EXISTS `g5_shop_item_use` (
`is_id` int(11) NOT NULL AUTO_INCREMENT,
`it_id` varchar(20) NOT NULL DEFAULT '0',
`mb_id` varchar(255) NOT NULL DEFAULT '',
`is_name` varchar(255) NOT NULL DEFAULT '',
`is_password` varchar(255) NOT NULL DEFAULT '',
`is_score` tinyint(4) NOT NULL DEFAULT '0',
`is_subject` varchar(255) NOT NULL DEFAULT '',
`is_content` text NOT NULL,
`is_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`is_ip` varchar(25) NOT NULL DEFAULT '',
`is_confirm` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`is_id`),
KEY `index1` (`it_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_item_qa`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_item_qa`;
CREATE TABLE IF NOT EXISTS `g5_shop_item_qa` (
`iq_id` int(11) NOT NULL AUTO_INCREMENT,
`it_id` varchar(20) NOT NULL DEFAULT '',
`mb_id` varchar(255) NOT NULL DEFAULT '',
`iq_secret` tinyint(4) NOT NULL DEFAULT '0',
`iq_name` varchar(255) NOT NULL DEFAULT '',
`iq_email` varchar(255) NOT NULL DEFAULT '',
`iq_hp` varchar(255) NOT NULL DEFAULT '',
`iq_password` varchar(255) NOT NULL DEFAULT '',
`iq_subject` varchar(255) NOT NULL DEFAULT '',
`iq_question` text NOT NULL,
`iq_answer` text NOT NULL,
`iq_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`iq_ip` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`iq_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_item_relation`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_item_relation`;
CREATE TABLE IF NOT EXISTS `g5_shop_item_relation` (
`it_id` varchar(20) NOT NULL DEFAULT '',
`it_id2` varchar(20) NOT NULL DEFAULT '',
`ir_no` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`it_id`,`it_id2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_order`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_order`;
CREATE TABLE IF NOT EXISTS `g5_shop_order` (
`od_id` bigint(20) unsigned NOT NULL,
`mb_id` varchar(255) NOT NULL DEFAULT '',
`od_name` varchar(20) NOT NULL DEFAULT '',
`od_email` varchar(100) NOT NULL DEFAULT '',
`od_tel` varchar(20) NOT NULL DEFAULT '',
`od_hp` varchar(20) NOT NULL DEFAULT '',
`od_zip1` char(3) NOT NULL DEFAULT '',
`od_zip2` char(3) NOT NULL DEFAULT '',
`od_addr1` varchar(100) NOT NULL DEFAULT '',
`od_addr2` varchar(100) NOT NULL DEFAULT '',
`od_addr3` varchar(255) NOT NULL DEFAULT '',
`od_addr_jibeon` varchar(255) NOT NULL DEFAULT '',
`od_deposit_name` varchar(20) NOT NULL DEFAULT '',
`od_b_name` varchar(20) NOT NULL DEFAULT '',
`od_b_tel` varchar(20) NOT NULL DEFAULT '',
`od_b_hp` varchar(20) NOT NULL DEFAULT '',
`od_b_zip1` char(3) NOT NULL DEFAULT '',
`od_b_zip2` char(3) NOT NULL DEFAULT '',
`od_b_addr1` varchar(100) NOT NULL DEFAULT '',
`od_b_addr2` varchar(100) NOT NULL DEFAULT '',
`od_b_addr3` varchar(255) NOT NULL DEFAULT '',
`od_b_addr_jibeon` varchar(255) NOT NULL DEFAULT '',
`od_memo` text NOT NULL,
`od_cart_count` int(11) NOT NULL DEFAULT '0',
`od_cart_price` int(11) NOT NULL DEFAULT '0',
`od_cart_coupon` int(11) NOT NULL DEFAULT '0',
`od_send_cost` int(11) NOT NULL DEFAULT '0',
`od_send_cost2` int(11) NOT NULL DEFAULT '0',
`od_send_coupon` int(11) NOT NULL DEFAULT '0',
`od_receipt_price` int(11) NOT NULL DEFAULT '0',
`od_cancel_price` int(11) NOT NULL DEFAULT '0',
`od_receipt_point` int(11) NOT NULL DEFAULT '0',
`od_refund_price` int(11) NOT NULL DEFAULT '0',
`od_bank_account` varchar(255) NOT NULL DEFAULT '',
`od_receipt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`od_coupon` int(11) NOT NULL DEFAULT '0',
`od_misu` int(11) NOT NULL DEFAULT '0',
`od_shop_memo` text NOT NULL,
`od_mod_history` text NOT NULL,
`od_status` varchar(255) NOT NULL DEFAULT '',
`od_hope_date` date NOT NULL DEFAULT '0000-00-00',
`od_settle_case` varchar(255) NOT NULL DEFAULT '',
`od_other_pay_type` varchar(100) NOT NULL DEFAULT '',
`od_test` tinyint(4) NOT NULL DEFAULT '0',
`od_mobile` tinyint(4) NOT NULL DEFAULT '0',
`od_pg` varchar(255) NOT NULL DEFAULT '',
`od_tno` varchar(255) NOT NULL DEFAULT '',
`od_app_no` varchar(20) NOT NULL DEFAULT '',
`od_escrow` tinyint(4) NOT NULL DEFAULT '0',
`od_casseqno` varchar(255) NOT NULL DEFAULT '',
`od_tax_flag` tinyint(4) NOT NULL DEFAULT '0',
`od_tax_mny` int(11) NOT NULL DEFAULT '0',
`od_vat_mny` int(11) NOT NULL DEFAULT '0',
`od_free_mny` int(11) NOT NULL DEFAULT '0',
`od_delivery_company` varchar(255) NOT NULL DEFAULT '0',
`od_invoice` varchar(255) NOT NULL DEFAULT '',
`od_invoice_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`od_cash` tinyint(4) NOT NULL,
`od_cash_no` varchar(255) NOT NULL,
`od_cash_info` text NOT NULL,
`od_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`od_pwd` varchar(255) NOT NULL DEFAULT '',
`od_ip` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`od_id`),
KEY `index2` (`mb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_order_address`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_order_address`;
CREATE TABLE IF NOT EXISTS `g5_shop_order_address` (
`ad_id` int(11) NOT NULL AUTO_INCREMENT,
`mb_id` varchar(255) NOT NULL DEFAULT '',
`ad_subject` varchar(255) NOT NULL DEFAULT '',
`ad_default` tinyint(4) NOT NULL DEFAULT '0',
`ad_name` varchar(255) NOT NULL DEFAULT '',
`ad_tel` varchar(255) NOT NULL DEFAULT '',
`ad_hp` varchar(255) NOT NULL DEFAULT '',
`ad_zip1` char(3) NOT NULL DEFAULT '',
`ad_zip2` char(3) NOT NULL DEFAULT '',
`ad_addr1` varchar(255) NOT NULL DEFAULT '',
`ad_addr2` varchar(255) NOT NULL DEFAULT '',
`ad_addr3` varchar(255) NOT NULL DEFAULT '',
`ad_jibeon` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`ad_id`),
KEY `mb_id` (`mb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_order_data`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_order_data`;
CREATE TABLE IF NOT EXISTS `g5_shop_order_data` (
`od_id` bigint(20) unsigned NOT NULL,
`cart_id` bigint(20) unsigned NOT NULL,
`mb_id` varchar(20) NOT NULL DEFAULT '',
`dt_pg` varchar(255) NOT NULL DEFAULT '',
`dt_data` text NOT NULL,
`dt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
KEY `od_id` (`od_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_order_delete`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_order_delete`;
CREATE TABLE IF NOT EXISTS `g5_shop_order_delete` (
`de_id` int(11) NOT NULL AUTO_INCREMENT,
`de_key` varchar(255) NOT NULL DEFAULT '',
`de_data` longtext NOT NULL,
`mb_id` varchar(20) NOT NULL DEFAULT '',
`de_ip` varchar(255) NOT NULL DEFAULT '',
`de_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`de_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>
--
-- Table structure for table `g5_shop_personalpay`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_personalpay`;
CREATE TABLE IF NOT EXISTS `g5_shop_personalpay` (
`pp_id` BIGINT(20) unsigned NOT NULL,
`od_id` BIGINT(20) unsigned NOT NULL,
`pp_name` VARCHAR(255) NOT NULL DEFAULT '',
`pp_email` VARCHAR(255) NOT NULL DEFAULT '',
`pp_hp` VARCHAR(255) NOT NULL DEFAULT '',
`pp_content` TEXT NOT NULL,
`pp_use` TINYINT(4) NOT NULL DEFAULT '0',
`pp_price` INT(11) NOT NULL DEFAULT '0',
`pp_pg` varchar(255) NOT NULL DEFAULT '',
`pp_tno` VARCHAR(255) NOT NULL DEFAULT '',
`pp_app_no` VARCHAR(20) NOT NULL DEFAULT '',
`pp_casseqno` VARCHAR(255) NOT NULL DEFAULT '',
`pp_receipt_price` INT(11) NOT NULL DEFAULT '0',
`pp_settle_case` VARCHAR(255) NOT NULL DEFAULT '',
`pp_bank_account` VARCHAR(255) NOT NULL DEFAULT '',
`pp_deposit_name` VARCHAR(255) NOT NULL DEFAULT '',
`pp_receipt_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`pp_receipt_ip` VARCHAR(255) NOT NULL DEFAULT '',
`pp_shop_memo` TEXT NOT NULL,
`pp_cash` TINYINT(4) NOT NULL DEFAULT '0',
`pp_cash_no` varchar(255) NOT NULL DEFAULT '',
`pp_cash_info` TEXT NOT NULL,
`pp_ip` VARCHAR(255) NOT NULL DEFAULT '',
`pp_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`pp_id`),
KEY `od_id` (`od_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_sendcost`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_sendcost`;
CREATE TABLE IF NOT EXISTS `g5_shop_sendcost` (
`sc_id` INT(11) NOT NULL AUTO_INCREMENT,
`sc_name` VARCHAR(255) NOT NULL DEFAULT '',
`sc_zip1` VARCHAR(10) NOT NULL DEFAULT '',
`sc_zip2` VARCHAR(10) NOT NULL DEFAULT '',
`sc_price` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`sc_id`),
KEY `sc_zip1` (`sc_zip1`),
KEY `sc_zip2` (`sc_zip2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_wish`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_wish`;
CREATE TABLE IF NOT EXISTS `g5_shop_wish` (
`wi_id` int(11) NOT NULL AUTO_INCREMENT,
`mb_id` varchar(255) NOT NULL DEFAULT '',
`it_id` varchar(20) NOT NULL DEFAULT '0',
`wi_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`wi_ip` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`wi_id`),
KEY `index1` (`mb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_item_stocksms`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_item_stocksms`;
CREATE TABLE IF NOT EXISTS `g5_shop_item_stocksms` (
`ss_id` int(11) NOT NULL AUTO_INCREMENT,
`it_id` varchar(20) NOT NULL DEFAULT '',
`ss_hp` varchar(255) NOT NULL DEFAULT '',
`ss_send` tinyint(4) NOT NULL DEFAULT '0',
`ss_send_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ss_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ss_ip` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`ss_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_order_post_log`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_order_post_log`;
CREATE TABLE IF NOT EXISTS `g5_shop_order_post_log` (
`log_id` int(11) NOT NULL AUTO_INCREMENT,
`oid` bigint(20) unsigned NOT NULL,
`mb_id` varchar(255) NOT NULL DEFAULT '',
`post_data` text NOT NULL,
`ol_code` varchar(255) NOT NULL DEFAULT '',
`ol_msg` text NOT NULL,
`ol_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ol_ip` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;</p>
<p>-- --------------------------------------------------------</p>
<p>--
-- Table structure for table `g5_shop_inicis_log`
--</p>
<p>DROP TABLE IF EXISTS `g5_shop_inicis_log`;
CREATE TABLE IF NOT EXISTS `g5_shop_inicis_log` (
`oid` bigint(20) unsigned NOT NULL,
`P_TID` varchar(255) NOT NULL DEFAULT '',
`P_MID` varchar(255) NOT NULL DEFAULT '',
`P_AUTH_DT` varchar(255) NOT NULL DEFAULT '',
`P_STATUS` varchar(255) NOT NULL DEFAULT '',
`P_TYPE` varchar(255) NOT NULL DEFAULT '',
`P_OID` varchar(255) NOT NULL DEFAULT '',
`P_FN_NM` varchar(255) NOT NULL DEFAULT '',
`P_AUTH_NO` varchar(255) NOT NULL DEFAULT '',
`P_AMT` int(11) NOT NULL DEFAULT '0',
`P_RMESG1` varchar(255) NOT NULL DEFAULT '',
`post_data` text NOT NULL,
`is_mail_send` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`oid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인