DxNbPx4H

1DROP TABLE IF EXISTS USER;
2CREATE TABLE USER (
3	ID VARCHAR(32),
4	NAME VARCHAR(32) NOT NULL,
5	PRIMARY KEY(ID)
6	);
7
8INSERT INTO USER VALUES ('apple', 'honux'),('banana','crong'),('carrot','pobi');
9
10DROP TABLE IF EXISTS BOARD;
11CREATE TABLE BOARD(
12	ID INT NOT NULL AUTO_INCREMENT,
13	DATE DATE,
14	UID VARCHAR(32),
15	TITLE VARCHAR(64) NOT NULL,
16	PRIMARY KEY(ID),
17	FOREIGN KEY(UID) REFERENCES USER(ID) ON DELETE CASCADE ON UPDATE CASCADE);	
18
19DESC USER;
20DESC BOARD;
21
22INSERT INTO BOARD (DATE, UID, TITLE) VALUES 
23	('2015-1-1','apple', 'hello'), 
24	('2015-1-2','banana', 'hi'), 
25	('2015-1-3','apple', 'good'), 
26	('2015-1-4','banana', 'zizi'), 
27	('2015-1-3',NULL, 'I am hacker');
28	
29SELECT * FROM USER;
30SELECT * FROM BOARD;