/************************************************
  + °Ô½ÃÆÇ Å×À̺í
  + $bbs_bbs
************************************************/
CREATE TABLE IF NOT EXISTS $bbs_bbs (

		no						INT(8) NOT NULL AUTO_INCREMENT,
		parent		  			INT(8) NOT NULL,
		depth 					INT(2) NOT NULL,
		sortno 				INT(2) NOT NULL,
		id 						VARCHAR(20),
		name 					VARCHAR(20) NOT NULL,
		pass 					VARCHAR(20) NOT NULL,
		email 					VARCHAR(50),
		homepage 			VARCHAR(100),
		link 						VARCHAR(200),
		title 						VARCHAR(100) NOT NULL,
		content 				TEXT NOT NULL,
		hit 						SMALLINT(6) NOT NULL,
		ipp 						VARCHAR(16) NOT NULL,
		tag 						CHAR(1),
		secret					CHAR(1),
		notice 					INT(3) DEFAULT '0',
		vote						INT(4) DEFAULT '0',
		cid 						INT(3) DEFAULT '1',
		reg_date 			VARCHAR(10) NOT NULL,
		PRIMARY KEY(no)

);


/************************************************
  + ÷ºÎÆÄÀÏ Å×À̺í
  + $bbs_attach
************************************************/
CREATE TABLE IF NOT EXISTS $bbs_attach (

		no						INT(8) NOT NULL AUTO_INCREMENT,
		name 					VARCHAR(50) NOT NULL,
		file_size 				VARCHAR(20) NOT NULL,
		file_type				VARCHAR(20) NOT NULL,
		file_ext				VARCHAR(10) NOT NULL,
		memo					TEXT,
		download 			INT(4) NOT NULL,
		idx 						INT(2),
		pid 						INT(8) NOT NULL,
		PRIMARY KEY (NO)

);


/************************************************
  + ÄÚ¸àÆ® Å×À̺í
  + $bbs_comment
************************************************/
CREATE TABLE IF NOT EXISTS $bbs_comment (

		no						INT(4) NOT NULL AUTO_INCREMENT,
		name 					VARCHAR(20) NOT NULL,
		pass 					VARCHAR(20) NOT NULL,
		content 				TEXT NOT NULL,
		ipp 						VARCHAR(16) NOT NULL,
		reg_date 			VARCHAR(10) NOT NULL,
		mid 						VARCHAR(20),
		pid 						INT(8) NOT NULL,
		PRIMARY KEY (NO)

);


/************************************************
  + °Ô½ÃÆÇ Ä«Å×°í¸® Å×À̺í
  + $bbs_category
************************************************/
CREATE TABLE IF NOT EXISTS $bbs_category (

		no						INT(4) NOT NULL AUTO_INCREMENT,
		name 					VARCHAR(20) NOT NULL,
		total	 				INT(4),
		idx	 					INT(2),
		PRIMARY KEY (NO)
)