Generate the initial schema for the project 3 database

3 files changed, 29 insertions, 0 deletions

diff --git a/projects/3/Makefile b/projects/3/Makefile
new file mode 100644
index 0000000..a1b102d
--- /dev/null
+++ b/projects/3/Makefile
@@ -0,0 +1,7 @@
+default: clean project.db
+
+clean:
+	rm -f project.db
+
+project.db:
+	sqlite3 project.db < structure.sql
diff --git a/projects/3/project.db b/projects/3/project.db
new file mode 100644
index 0000000..fd44014
--- /dev/null
+++ b/projects/3/project.db
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