-
Notifications
You must be signed in to change notification settings - Fork 0
/
init.sql
32 lines (27 loc) · 970 Bytes
/
init.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
#DDL
CREATE SCHEMA FAQ_DB;
USE FAQ_DB;
CREATE TABLE `topics` (
`topic_id` INT(5) NOT NULL,
`topic_name` VARCHAR(20) NOT NULL,
PRIMARY KEY (`topic_id`)
) ENGINE=INNODB DEFAULT CHARSET=UTF8;
CREATE TABLE `faq` (
`topic_id` INT(5) NOT NULL,
`question_id` INT(3) NOT NULL,
`question` VARCHAR(50) NOT NULL,
`answer` VARCHAR(100) NOT NULL,
PRIMARY KEY (`topic_id` , `question_id`),
CONSTRAINT `topic_fk` FOREIGN KEY (`topic_id`)
REFERENCES `topics` (`topic_id`)
ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=INNODB DEFAULT CHARSET=UTF8;
#DML
insert into `topics` values
(10,'Javabean'),
(20,'Servlet'),
(30,'jsp');
insert into `faq` values
(10,1,'What is a java bean?','A java bean is a component written in Java.'),
(10,2,'Are Java beans portable?', 'Yes, they are Java components.'),
(20,1,'What is a Java Servlet?','A Java Servlet is a server side Java class that runs on a Web server');