MoviesAppBackend
MoviesAppBackend
Simple Movie Directory, Exposing REST API, using mysql database.
Table Structure:
CREATE TABLE movies (
id int NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
year int(4) NOT NULL,
director varchar(255) NOT NULL,
created timestamp default CURRENT_TIMESTAMP ,
updated timestamp default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (ID)
);
CREATE TABLE users (
id int NOT NULL AUTO_INCREMENT,
email varchar(255) NOT NULL,
name varchar(255) NOT NULL,
lastname varchar(255) NOT NULL,
password varchar(255),
role varchar(255),
created timestamp default CURRENT_TIMESTAMP ,
updated timestamp default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (ID)
);