/**************************************************************** + config_table ****************************************************************/ CREATE TABLE IF NOT EXISTS config_table ( mem_use_homepage INT(1) NOT NULL, mem_use_reg INT(1) NOT NULL, mem_use_tel INT(1) NOT NULL, mem_use_addr INT(1) NOT NULL, mem_use_message INT(1) NOT NULL, mem_use_attach INT(1) NOT NULL, mem_use_mailing INT(1) NOT NULL, mem_addr_type INT(1) NOT NULL, mem_auto_join INT(1) NOT NULL, mailer_man1 VARCHAR(100), mailer_man2 VARCHAR(100), mailer_man3 VARCHAR(100), mailer_frm1 VARCHAR(50), mailer_frm2 VARCHAR(50), mailer_frm3 VARCHAR(50), mailer_frm4 VARCHAR(50), mailer_frm5 VARCHAR(50), mailer_frm6 VARCHAR(50), mailer_frm7 VARCHAR(50), mailer_frm8 VARCHAR(50), mailer_use_frm1 INT(1) NOT NULL, mailer_use_frm2 INT(1) NOT NULL, mailer_use_frm3 INT(1) NOT NULL, mailer_use_frm4 INT(1) NOT NULL, mailer_use_frm5 INT(1) NOT NULL, mailer_use_frm6 INT(1) NOT NULL, mailer_use_frm7 INT(1) NOT NULL, mailer_use_frm8 INT(1) NOT NULL, mailer_auth INT(1) NOT NULL, mem_frm1 VARCHAR(255), mem_frm2 VARCHAR(255), mem_frm3 VARCHAR(255), mem_frm4 VARCHAR(255), mem_frm5 VARCHAR(255), mem_frm6 VARCHAR(255), mem_frm7 VARCHAR(255), mem_frm8 VARCHAR(255), mem_frm9 VARCHAR(255), mem_frm10 VARCHAR(255), mem_use_frm1 INT(1) NOT NULL, mem_use_frm2 INT(1) NOT NULL, mem_use_frm3 INT(1) NOT NULL, mem_use_frm4 INT(1) NOT NULL, mem_use_frm5 INT(1) NOT NULL, mem_use_frm6 INT(1) NOT NULL, mem_use_frm7 INT(1) NOT NULL, mem_use_frm8 INT(1) NOT NULL, mem_use_frm9 INT(1) NOT NULL, mem_use_frm10 INT(1) NOT NULL ); /**************************************************************** + group_table ****************************************************************/ CREATE TABLE IF NOT EXISTS group_table ( no INT(3) NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, code VARCHAR(16) NOT NULL, PRIMARY KEY(no) ); /**************************************************************** + admin_table ****************************************************************/ CREATE TABLE IF NOT EXISTS admin_table ( no INT(4) NOT NULL AUTO_INCREMENT, tb_memo VARCHAR(100) NOT NULL, tb_name VARCHAR(50) NOT NULL, tb_skin VARCHAR(50) NOT NULL, tb_title VARCHAR(100), tb_bgcolor VARCHAR(20), tb_size INT(4) DEFAULT '550', add_head VARCHAR(200), add_foot VARCHAR(200), page_size INT(2) DEFAULT '10', page_scale INT(2) DEFAULT '10', use_comment CHAR(1) DEFAULT '0', use_attach CHAR(1) DEFAULT '0', use_attach_memo CHAR(1) DEFAULT '0', use_category CHAR(1) DEFAULT '0', use_list CHAR(1) DEFAULT '0', use_copy CHAR(1) DEFAULT '1', size_str INT(3) DEFAULT '0', size_attach INT(5) DEFAULT '1000', size_new INT(2) DEFAULT '1', num_attach INT(2) DEFAULT '1', img_w INT(5) DEFAULT '100', img_h INT(5) DEFAULT '120', img_x INT(2) DEFAULT '5', img_y INT(2) DEFAULT '3', check_word TEXT, check_ipp TEXT, auth_write CHAR(2) DEFAULT '10', auth_notice CHAR(2) DEFAULT '1', auth_reply CHAR(2) DEFAULT '10', auth_read CHAR(2) DEFAULT '10', auth_html CHAR(2) DEFAULT '10', auth_secret CHAR(2) DEFAULT '10', gid VARCHAR(16) NOT NULL, reg_date VARCHAR(10) NOT NULL, PRIMARY KEY (no) ); /**************************************************************** + mem_table ****************************************************************/ CREATE TABLE IF NOT EXISTS mem_table ( no INT(4) NOT NULL AUTO_INCREMENT, id VARCHAR(20) NOT NULL, pass VARCHAR(60) NOT NULL, name VARCHAR(20) NOT NULL, email VARCHAR(50), homepage VARCHAR(100), reg_01 VARCHAR(6), reg_02 VARCHAR(20), tel_01 CHAR(3), tel_02 CHAR(4), tel_03 CHAR(4), code_01 VARCHAR(10), code_02 CHAR(3), addr_01 VARCHAR(100), addr_02 VARCHAR(100), message TEXT, attach VARCHAR(50), mailing INT(1) NOT NULL, grade INT(1) NOT NULL, point INT(8) NOT NULL, add_frm1 VARCHAR(100), add_frm2 VARCHAR(100), add_frm3 VARCHAR(100), add_frm4 VARCHAR(100), add_frm5 VARCHAR(100), add_frm6 VARCHAR(100), add_frm7 VARCHAR(100), add_frm8 VARCHAR(100), add_frm9 VARCHAR(100), add_frm10 VARCHAR(100), gid VARCHAR(16) NOT NULL, approval INT(1) NOT NULL, reg_date VARCHAR(10) NOT NULL, PRIMARY KEY (no) ); /**************************************************************** + poll_table ****************************************************************/ CREATE TABLE IF NOT EXISTS poll_table ( no INT(8) NOT NULL AUTO_INCREMENT, title TINYTEXT NOT NULL, add_head VARCHAR(200), add_foot VARCHAR(200), start_date VARCHAR(10) NOT NULL, end_date VARCHAR(10) NOT NULL, use_auth INT(1) NOT NULL, total INT(8), reg_date VARCHAR(10) NOT NULL, PRIMARY KEY (no) ); /**************************************************************** + poll_item ****************************************************************/ CREATE TABLE IF NOT EXISTS poll_item ( no INT(8) NOT NULL AUTO_INCREMENT, name TINYTEXT NOT NULL, hit INT(8), pid INT(8) NOT NULL, PRIMARY KEY (no) ); /**************************************************************** + poll_comment ****************************************************************/ CREATE TABLE IF NOT EXISTS poll_comment ( no INT(8) NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, pass VARCHAR(20) NOT NULL, content text, ipp VARCHAR(16) NOT NULL, reg_date VARCHAR(10) NOT NULL, mid VARCHAR(20), pid INT(8) NOT NULL, primary key (no) ); /**************************************************************** + zipcode ****************************************************************/ CREATE TABLE IF NOT EXISTS zipcode ( zipcode VARCHAR(7) NOT NULL default '', sido VARCHAR(4) NOT NULL default '', gugun VARCHAR(13) NOT NULL default '', dong VARCHAR(43) NOT NULL default '', bunji VARCHAR(17) NOT NULL default '', seq INT(5) UNSIGNED NOT NULL default '0' )