diff options
Diffstat (limited to 'projects')
| -rw-r--r-- | projects/3/.gitignore | 1 | ||||
| -rw-r--r-- | projects/3/project.db | bin | 20480 -> 0 bytes | |||
| -rw-r--r-- | projects/3/structure.sql | 52 |
3 files changed, 48 insertions, 5 deletions
diff --git a/projects/3/.gitignore b/projects/3/.gitignore new file mode 100644 index 0000000..98e6ef6 --- /dev/null +++ b/projects/3/.gitignore @@ -0,0 +1 @@ +*.db diff --git a/projects/3/project.db b/projects/3/project.db Binary files differdeleted file mode 100644 index fd44014..0000000 --- a/projects/3/project.db +++ /dev/null diff --git a/projects/3/structure.sql b/projects/3/structure.sql index 6017494..9bf9e59 100644 --- a/projects/3/structure.sql +++ b/projects/3/structure.sql @@ -1,22 +1,64 @@ create table customers( id integer primary key asc, - first_name varchar(255), - last_name varchar(255), + first_name varchar(255) not null, + last_name varchar(255) not null, + address text, created_at datetime default current_timestamp, updated_at datetime default current_timestamp ); create table categories( - id integer primary key asc + id integer primary key asc, + title varchar(16) unique not null, + description varchar(255) not null, + created_at datetime default current_timestamp, + updated_at datetime default current_timestamp ); create table media( - id integer primary key asc + id integer primary key asc, + title varchar(255) unique not null, + category_id integer not null, + created_at datetime default current_timestamp, + updated_at datetime default current_timestamp, + foreign key(category_id) references categories(id) ); create table rentals( - id integer primary key asc + id integer primary key asc, + rented_at datetime not null, + due_at datetime not null, + created_at datetime default current_timestamp, + updated_at datetime default current_timestamp ); .schema + +insert into customers(first_name, last_name) values('Achilleas', 'Pipinellis'); +insert into customers(first_name, last_name) values('Jessie', 'Young'); +insert into customers(first_name, last_name) values('Laura', 'Montemayor'); +insert into customers(first_name, last_name) values('Michał', 'Zając'); +insert into customers(first_name, last_name) values('Rahul', 'Chanila'); +insert into customers(first_name, last_name) values('Segolene', 'Bouly'); +insert into customers(first_name, last_name) values('Shinya', 'Maeda'); +insert into customers(first_name, last_name) values('Taras', 'Tadai'); +insert into customers(first_name, last_name) values('Tiffany', 'Rea'); +insert into customers(first_name, last_name) values('Vijay', 'Hawoldar'); + +select * from customers; + +-- insert 3 categories +insert into categories(title, description) values('Action', 'A film genre that predominantly features chase sequences, fights, shootouts, explosions, and stunt work'); +insert into categories(title, description) values('Comedy', 'A film genre that emphasizes humor'); +insert into categories(title, description) values('Documentary', 'A film genre that is a non-fictional motion picture intended to document reality, primarily for instruction, education or maintaining a historical record'); +insert into categories(title, description) values('Horror', 'A film genre that seeks to elicit fear or disgust in its audience for entertainment purposes'); + +select * from categories; + +-- insert 30 media +-- insert into media(title, description) values('Action', 'A film genre that predominantly features chase sequences, fights, shootouts, explosions, and stunt work'); + +-- insert 20 rentals + .quit + |