Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `film_actor` (
- `actor_id` SMALLINT(5) UNSIGNED NOT NULL,
- `film_id` SMALLINT(5) UNSIGNED NOT NULL,
- `last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP()
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ALTER TABLE `film_actor`
- ADD PRIMARY KEY (`actor_id`,`film_id`),
- ADD KEY `idx_fk_film_id` (`film_id`);
- ALTER TABLE `film_actor`
- ADD CONSTRAINT `fk_film_actor_actor` FOREIGN KEY (`actor_id`) REFERENCES `actor` (`actor_id`) ON UPDATE CASCADE,
- ADD CONSTRAINT `fk_film_actor_film` FOREIGN KEY (`film_id`) REFERENCES `film` (`film_id`) ON UPDATE CASCADE;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement