sd9EYvDz

1USE `container-db`;
2
3DROP TABLE IF EXISTS tbl_posts;
4DROP TABLE IF EXISTS tbl_people;
5
6CREATE TABLE tbl_people (
7
8    ID INT(11) NOT NULL AUTO_INCREMENT,
9    FNAME VARCHAR(255) NOT NULL,
10    LNAME VARCHAR(255),
11    PRIMARY KEY (ID)
12
13) AUTO_INCREMENT=1;
14
15CREATE TABLE tbl_posts (
16
17    ID INT(11) NOT NULL AUTO_INCREMENT,
18    TITLE VARCHAR(20) NOT NULL,
19    CONTENT VARCHAR(255) NOT NULL,
20    PID INT(11) NOT NULL,
21    PRIMARY KEY (ID),
22    FOREIGN KEY (PID) REFERENCES tbl_people(ID)
23
24) AUTO_INCREMENT=1;
25
26-- *********************************
27-- ********* CREATE PEOPLE *********
28-- *********************************
29
30-- INSERT INTO tbl_people (FNAME,LNAME) VALUES ('Jeff', 'Kranenburg');
31-- INSERT INTO tbl_people (FNAME,LNAME) VALUES ('Steve', 'Stevenson');
32-- INSERT INTO tbl_people (FNAME,LNAME) VALUES ('Roger', 'Rogers');
33-- INSERT INTO tbl_people (FNAME,LNAME) VALUES ('Kevin', 'Bateman');
34
35-- SELECT * FROM tbl_people;
36
37-- UPDATE tbl_people SET FNAME = 'Peter' WHERE ID = 1;
38
39-- DELETE FROM tbl_people WHERE ID = 1;
40
41-- *********************************
42-- ********** CREATE POST **********
43-- *********************************
44
45-- INSERT INTO tbl_posts (TITLE, CONTENT, PID) VALUES ('LOREM IPSUM', 'Lorem ipsum dolor sit amet consectetur, adipisicing elit. Nobis, doloremque.', 1);
46-- INSERT INTO tbl_posts (TITLE, CONTENT, PID) VALUES ('LOREM IPSUM', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Excepturi repellat vitae magni et exercitationem non optio dolorem qui iure similique!', 2);
47-- INSERT INTO tbl_posts (TITLE, CONTENT, PID) VALUES ('LOREM IPSUM', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Beatae, illo.', 2);
48-- INSERT INTO tbl_posts (TITLE, CONTENT, PID) VALUES ('LOREM IPSUM', 'Lorem ipsum, dolor sit amet consectetur adipisicing elit. Excepturi, modi?', 3);
49
50-- SELECT * FROM tbl_posts;
51
52-- SELECT * FROM tbl_posts WHERE PID = 2;
53
54-- UPDATE tbl_posts SET TITLE = 'NOPE!' WHERE ID = 1;
55
56-- DELETE FROM tbl_posts WHERE ID = 1;
57
58-- TRUNCATE tbl_posts;