
/****************************************************************
  + 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'
)
