Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `directors` (
- `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- `director_name` VARCHAR(45) NOT NULL,
- `notes` VARCHAR(200) NULL
- );
- CREATE TABLE `genres` (
- `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- `genre_name` VARCHAR(45) NOT NULL,
- `notes` VARCHAR(200) NULL
- );
- CREATE TABLE `categories` (
- `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- `category_name` VARCHAR(45) NOT NULL,
- `notes` VARCHAR(200) NULL
- );
- CREATE TABLE `movies` (
- `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- `title` VARCHAR(45) NOT NULL,
- `director_id` INT NOT NULL,
- `copyright_year` DATE NOT NULL,
- `length` INT NOT NULL,
- `genre_id` INT NOT NULL,
- `category_id` INT NOT NULL,
- `rating` VARCHAR(200) NULL,
- `notes` VARCHAR(200) NULL
- );
- INSERT INTO `directors` (`id`, `director_name`, `notes`) VALUES
- ('1', 'text', 'text'),
- ('2', 'text', 'text'),
- ('3', 'text', 'text');
- INSERT INTO `genres` (`id`, `genre_name`, `notes`) VALUES
- ('1', 'text', 'text'),
- ('2', 'text', 'text'),
- ('3', 'text', 'text');
- INSERT INTO `categories` (`id`, `category_name`, `notes`) VALUES
- ('1', 'text', 'text'),
- ('2', 'text', 'text'),
- ('3', 'text', 'text');
- INSERT INTO `movies` (`id`, `title`, `director_id`, `copyright_year`, `length`, `genre_id`, `category_id`, `rating`, `notes`) VALUES
- ('1', 'text', '123', '1989-10-10', '123', '123', '123', 'text', 'text'),
- ('2', 'text', '123', '1989-10-10', '123', '123', '123', 'text', 'text'),
- ('3', 'text', '123', '1989-10-10', '123', '123', '123', 'text', 'text'),
- ('4', 'text', '123', '1989-10-10', '123', '123', '123', 'text', 'text'),
- ('5', 'text', '123', '1989-10-10', '123', '123', '123', 'text', 'text');
Add Comment
Please, Sign In to add comment