USE se12;

DROP TABLE boardManager;
DROP TABLE board;
DROP TABLE user;
DROP TABLE message;
#
CREATE TABLE boardManager (
	boardID		varchar(30) NOT NULL PRIMARY KEY,
	ownerID		varchar(30) NOT NULL,
	headFile	varchar(100),
	footFile	varchar(100),
	fileBoard	enum('n','y') NOT NULL DEFAULT 'n',
	fileDir		varchar(100),		
	perm		INT UNSIGNED NOT NULL,
	maxItemPerPage  INT UNSIGNED NOT NULL DEFAULT '5'
);

INSERT INTO boardManager VALUES('se12board','darkpgm','headFile.html','footFile.html','y','data','100','5');
INSERT INTO boardManager VALUES('darkpgm','darkpgm','headFile.html','footFile.html','y','data','1000','5');

CREATE TABLE se12board (
	no		INT UNSIGNED NOT NULL DEFAULT '1',
	title		TINYTEXT NOT NULL,
	content		TEXT NOT NULL,
	writer		VARCHAR(30) NOT NULL,
	readTimes	INT UNSIGNED NOT NULL DEFAULT '0',
	writeDate	DATE NOT NULL,
	writeTime	TIME NOT NULL,
	password	VARCHAR(30) NOT NULL,
	html		ENUM('n','y'),
	filename	TINYTEXT
);
INSERT INTO se12board VALUES('1','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');
INSERT INTO se12board VALUES('2','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');
INSERT INTO se12board VALUES('3','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');
INSERT INTO se12board VALUES('4','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');
INSERT INTO se12board VALUES('5','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');
INSERT INTO se12board VALUES('6','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');
INSERT INTO se12board VALUES('7','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');
INSERT INTO se12board VALUES('8','Test','Test','darkpgm','1','2003-12-12','21:00','test','n','');

CREATE TABLE se12message (
	no		INT UNSIGNED NOT NULL PRIMARY KEY DEFAULT '1' AUTO_INCREMENT,
	toID		VARCHAR(30) NOT NULL,
	fromID		VARCHAR(30) NOT NULL,
	date		DATE NOT NULL,
	time		TIME NOT NULL,
	rd		INT NOT NULL,
	reply		INT NOT NULL,
	title		TINYTEXT NOT NULL,
	content		TEXT NOT NULL
);
INSERT INTO se12message VALUES('1','darkpgm','darkpgm',CURDATE(),CURTIME(),0,0,"TEST","ȳ");
INSERT INTO se12message VALUES('2','darkpgm','darkpgm',CURDATE(),CURTIME(),0,1,"","");
INSERT INTO se12message VALUES('3','darkpgm','darkpgm',CURDATE(),CURTIME(),1,0,"","Ⱦ");
INSERT INTO se12message VALUES('4','darkpgm','darkpgm',CURDATE(),CURTIME(),1,1,"׷","ȵ");
INSERT INTO se12message VALUES('5','darkpgm','test',CURDATE(),CURTIME(),0,0,"TEST","ȳ");
INSERT INTO se12message VALUES('6','darkpgm','test',CURDATE(),CURTIME(),0,1,"","");
INSERT INTO se12message VALUES('7','darkpgm','test',CURDATE(),CURTIME(),1,0,"","Ⱦ");
INSERT INTO se12message VALUES('8','darkpgm','test',CURDATE(),CURTIME(),1,1,"׷","ȵ");


CREATE TABLE se12user (
	uid		VARCHAR(30) PRIMARY KEY NOT NULL,
	name		VARCHAR(30) NOT NULL,
	password	VARCHAR(30) NOT NULL,
	age		INT UNSIGNED NOT NULL,
	address		TINYTEXT NOT NULL,
	phone		VARCHAR(30) NOT NULL,
	email		TINYTEXT NOT NULL,
	perm		INT UNSIGNED NOT NULL,
	user_keeey	INT NOT NULL,
	ip		VARCHAR(30) NOT NULL,
	status		INT NOT NULL,
	date		DATE,
	time		TIME
);
INSERT INTO se12user VALUES('darkpgm','ڼ',password('test'),'22','darkpgm@siregi.net.NOSPAM','+82-16-454-8208','darkpgm@darkcity.siregi.net','1','','','0',CURDATE(),CURTIME());
INSERT INTO se12user VALUES('hong','ȫ浿',password('test'),'24',' 13ȣ','+82','earth@test.com','10','','','0',CURDATE(),CURTIME());
INSERT INTO se12user VALUES('guest','',password('test'),'24',' ֿ .','+83','uzo.com','190','','','0',CURDATE(),CURTIME());

SHOW TABLES;
# Show inserted data
SELECT uid,name,perm FROM se12user;
SELECT boardID,perm FROM boardManager;
