bispo-daniel
diff --git a/‎PostsDB/PostsDB--DDL.sql
Copy file name to clipboard
+19Lines changed: 19 additions & 0 deletions b/‎PostsDB/PostsDB--DDL.sql
Copy file name to clipboard
+19Lines changed: 19 additions & 0 deletions
diff --git a/‎PostsDB/PostsDB--DML.sql
Copy file name to clipboard
+14Lines changed: 14 additions & 0 deletions b/‎PostsDB/PostsDB--DML.sql
Copy file name to clipboard
+14Lines changed: 14 additions & 0 deletions
diff --git a/‎PostsDB/PostsDB--DQL.sql
Copy file name to clipboard
+2Lines changed: 2 additions & 0 deletions b/‎PostsDB/PostsDB--DQL.sql
Copy file name to clipboard
+2Lines changed: 2 additions & 0 deletions
@@ -0,0 +1,19 @@
+CREATE DATABASE IF NOT EXISTS postsdb;
+USE postsdb;
+
+CREATE TABLE IF NOT EXISTS user (
+    id int auto_increment primary key PRIMARY KEY,
+    username varchar(100) not null unique,
+    password varchar(100) not null
+);
+
+/*One user cannot post 2 posts with the same title*/
+
+CREATE TABLE IF NOT EXISTS post (
+    id int auto_increment primary key,
+    title varchar(100) not null,
+    content text not null,
+    fk_user_id int not null,
+    foreign key (fk_user_id) references user(id),
+    constraint unique_post unique (title, fk_user_id)
+);
@@ -0,0 +1,14 @@
+use postsdb;
+
+insert into user (id, username, password) values
+(1, '@bishop', '1234'),
+(2, '@data', '1234'),
+(3, '@bishop&co.', '1234');
+
+insert into post (title, content, fk_user_id) values
+('How...', 'Forget it... NEVERMIND!', 1),  
+('How to...', 'Forget it... NEVERMIND!', 1),  
+('How to...', 'Forget it... NEVERMIND!', 2),  
+('How to do...', 'Forget it... NEVERMIND!', 2),  
+('How to do...', 'Forget it... NEVERMIND!', 3),  
+('How to do your', 'Forget it... NEVERMIND!', 3);  
@@ -0,0 +1,2 @@
+use postsdb;
+select * from post;
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+use postsdb;`
	`2`	`+select * from post;`