Generate the initial schema for the project 3 database

1 files changed, 22 insertions, 0 deletions

diff --git a/projects/3/structure.sql b/projects/3/structure.sql
new file mode 100644
index 0000000..6017494
--- /dev/null
+++ b/projects/3/structure.sql
@@ -0,0 +1,22 @@
+create table customers(
+  id integer primary key asc,
+  first_name varchar(255),
+  last_name varchar(255),
+  created_at datetime default current_timestamp,
+  updated_at datetime default current_timestamp
+);
+
+create table categories(
+  id integer primary key asc
+);
+
+create table media(
+  id integer primary key asc
+);
+
+create table rentals(
+  id integer primary key asc
+);
+
+.schema
+.quit