r5ypwfei

1DROP DATABASE IF EXISTS `a2`;
2
3CREATE DATABASE `a2`;
4
5USE `a2`;
6
7CREATE TABLE `member` (
8  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
9  `regDate` DATETIME NOT NULL,
10  `loginId` CHAR(100) NOT NULL,
11  `loginPw` CHAR(100) NOT NULL,
12  `name` CHAR(100) NOT NULL,
13  PRIMARY KEY (`id`)
14);
15
16INSERT INTO `member`
17(`id`, `regDate`, `loginId`, `loginPw`, `name`)
18VALUES
19(1, '2019-05-27 22:54:25', 'user1', 'user1', '홍길동'),
20(2, '2019-05-27 22:54:36', 'user2', 'user2', '홍길순');
21
22CREATE TABLE `board` (
23  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
24  `regDate` DATETIME NOT NULL,
25  `name` CHAR(100) NOT NULL,
26  PRIMARY KEY (`id`)
27);
28
29INSERT  INTO `board`(`id`,`regDate`,`name`) VALUES
30(1,'2019-05-27 22:54:25','공지사항'),
31(2,'2019-05-27 22:54:36','자유게시판');
32
33CREATE TABLE `article` (
34  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
35  `regDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
36  `title` CHAR(100) NOT NULL,
37  `body` TEXT NOT NULL,
38  `memberId` INT(10) UNSIGNED NOT NULL,
39  `boardId` INT(10) UNSIGNED NOT NULL,
40  PRIMARY KEY (`id`)
41);
42
43INSERT  INTO `article`(`id`,`regDate`,`title`,`body`,`memberId`,`boardId`) VALUES
44(1,'2019-06-28 22:55:18','제목1','내용1\nㅎㅎ',1,1),
45(2,'2019-06-28 22:55:28','제목2','내용2\nㅋㅋ',2,1),
46(3,'2019-06-28 22:56:44','제목3','내용3\nㅋㅋ',2,2);
47
48CREATE TABLE `articleReply` (
49  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
50  `regDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
51  `articleId` INT(10) UNSIGNED NOT NULL,
52  `boardId` INT(10) UNSIGNED NOT NULL,
53  `memberId` INT(10) UNSIGNED NOT NULL,
54  `body` TEXT NOT NULL,
55  PRIMARY KEY (`id`)
56);
57
58INSERT  INTO `articleReply`(`id`,`regDate`,`articleId`,`boardId`,`memberId`,`body`) VALUES
59(1,'2019-06-28 22:55:18',1,1,1,'댓글 내용1'),
60(2,'2019-06-28 22:55:18',1,1,1,'댓글 내용\n1_2'),
61(3,'2019-06-28 22:55:18',1,1,1,'댓글 내용\n1_3');