Commit 49053ac

mo khan <mo@mokhan.ca>
2025-01-13 23:54:22
Generate the initial schema for the project 3 database
1 parent 9b5132c
projects/3/Makefile
@@ -0,0 +1,7 @@
+default: clean project.db
+
+clean:
+	rm -f project.db
+
+project.db:
+	sqlite3 project.db < structure.sql
projects/3/project.db
Binary file
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
.gitignore
@@ -1,1 +1,2 @@
 *.out
+*.db