bispo-daniel
diff --git a/‎BandsDB/BandsDB--ConceptualModel.png
Copy file name to clipboard
11.4 KB b/‎BandsDB/BandsDB--ConceptualModel.png
Copy file name to clipboard
11.4 KB
diff --git a/‎BandsDB/BandsDB-DDL.sql renamed to ‎BandsDB/BandsDB--DDL.sql
Copy file name to clipboard b/‎BandsDB/BandsDB-DDL.sql renamed to ‎BandsDB/BandsDB--DDL.sql
Copy file name to clipboard
diff --git a/‎BandsDB/BandsDB--LogicModel.png
Copy file name to clipboard
18.9 KB b/‎BandsDB/BandsDB--LogicModel.png
Copy file name to clipboard
18.9 KB
diff --git a/‎BandsDB/README.md
Copy file name to clipboard
+5Lines changed: 5 additions & 0 deletions b/‎BandsDB/README.md
Copy file name to clipboard
+5Lines changed: 5 additions & 0 deletions
diff --git a/‎PostsDB/PostsDB--DDL.sql
Copy file name to clipboardExpand all lines: PostsDB/PostsDB--DDL.sql
+2-1Lines changed: 2 additions & 1 deletion b/‎PostsDB/PostsDB--DDL.sql
Copy file name to clipboardExpand all lines: PostsDB/PostsDB--DDL.sql
+2-1Lines changed: 2 additions & 1 deletion
diff --git a/‎PostsDB/PostsDB--DML.sql
Copy file name to clipboard
+7-10Lines changed: 7 additions & 10 deletions b/‎PostsDB/PostsDB--DML.sql
Copy file name to clipboard
+7-10Lines changed: 7 additions & 10 deletions
diff --git a/‎PostsDB/PostsDB--DQL.sql
Copy file name to clipboard
+2-1Lines changed: 2 additions & 1 deletion b/‎PostsDB/PostsDB--DQL.sql
Copy file name to clipboard
+2-1Lines changed: 2 additions & 1 deletion
diff --git a/‎RandomDataDB/RandomDataDB--DDL.sql
Copy file name to clipboard
+20Lines changed: 20 additions & 0 deletions b/‎RandomDataDB/RandomDataDB--DDL.sql
Copy file name to clipboard
+20Lines changed: 20 additions & 0 deletions
@@ -0,0 +1,5 @@
+# Conceptual model:
+![all-text](https://github.com/bispo-daniel/SQL_Scripts/blob/main/BandsDB/BandsDB--ConceptualModel.png)
+
+# Logic model:
+![all-text](https://github.com/bispo-daniel/SQL_Scripts/blob/main/BandsDB/BandsDB--LogicModel.png)
@@ -2,7 +2,7 @@ CREATE DATABASE IF NOT EXISTS postsdb;
 USE postsdb;
 
 CREATE TABLE IF NOT EXISTS user (
-    id int auto_increment primary key PRIMARY KEY,
+    id int auto_increment primary key,
     username varchar(100) not null unique,
     password varchar(100) not null
 );
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS user (
 
 CREATE TABLE IF NOT EXISTS post (
     id int auto_increment primary key,
+    posted datetime default current_timestamp,
     title varchar(100) not null,
     content text not null,
     fk_user_id int not null,
 
@@ -1,14 +1,11 @@
 use postsdb;
 
-insert into user (id, username, password) values
-(1, '@bishop', '1234'),
-(2, '@data', '1234'),
-(3, '@bishop&co.', '1234');
+insert into user (username, password) values
+('@bishop', '1234'),
+('@data', '1234'),
+('@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);  
+('How to catch a butterfly', '[...] Just catch a look...', 1),  
+('Lose weight following these simples steps!', 'Under development...', 2),  
+('My favorite country from Europe is...', 'Shitzerland', 3);
@@ -1,2 +1,3 @@
 use postsdb;
-select * from post;
+select * from post;
+select * from user;
@@ -0,0 +1,20 @@
+CREATE DATABASE IF NOT EXISTS randomdatadb;
+use randomdatadb;
+
+CREATE TABLE IF NOT EXISTS randomData (
+  id int auto_increment primary key,
+  randomNumber bigint UNSIGNED not null,
+  randomString longtext not null,
+  randomDate date not null
+);
+
+/*
+  randomNumber limits: 0 - 18,446,744,073,709,551,615
+  randomString limits: 4,294,967,295 characters
+  randomDate limits: '1000-01-01' to '9999-12-31'
+*/
+
+insert into randomData (randomNumber, randomString, randomDate) 
+values (0, 'o', '1000-01-01');
+
+select * from randomData;