---

use cinema;

create table ratings (
 	id_rating int,
    id_user int,
    id_movie int,
    score int
);

create table users (
 	id_user int,
    name varchar(100),
    age int
);

create table subscriptions (
 	id_sub int,
    id_user int,
    type varchar(50),
    price decimal(8,2),
    start_date date,
    status varchar(45),
    date_of_last_renewal date
);

create table views (
	id_view int,
    id_user int,
    id_movie int,
    view_date date,
    watch_time int
);

create table movies (
 	 id_movie int,
     title varchar(100),
     genre varchar(50),
     duration int
);

insert into ratings(id_rating, id_user, id_movie, score) values
(1, 1, 1, 100),
(2, 2, 2, 80),
(3, 3, 3, 75);

insert into users(id_user, name, age) values
(1, "Stepan", 20),
(2, "Maria", 31),
(3, "Vitaliy", 28);

insert into subscriptions(id_sub, id_user, type, price, start_date, status, date_of_last_renewal) values
(1, 1, "base", 200, "2026-12-12", "activated", "2026-02-21"),
(2, 2, "pro", 400, "2026-01-14", "activated", "2026-05-12"),
(3, 3, "base", 200, "2026-02-21", "disactive", "2026-03-02");

insert into views(id_view, id_user, id_movie, view_date, watch_time) values
(1, 1, 1, "2026-05-12", 100),
(2, 2, 2, "2026-04-16", 370),
(3, 3, 3, "2026-03-31", 230);

insert into movies(id_movie, title, genre, duration) values 
(1, "Avatar 1", "drama", 300),
(2, "Avatar 2", "fantastic", 230),
(3, "Avatar 3", "fantastic", 310);


select * from ratings;
select * from users;
select * from subscriptions; 
select * from views;
select * from movies;

DELIMITER //
CREATE TRIGGER zapret_ratings