diff options
Diffstat (limited to 'projects/3')
| -rw-r--r-- | projects/3/Makefile | 7 | ||||
| -rw-r--r-- | projects/3/project.db | bin | 0 -> 20480 bytes | |||
| -rw-r--r-- | projects/3/structure.sql | 22 |
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 Binary files differnew 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 |