Advertisement
chiabgigi

film_actor.sql

Oct 29th, 2019
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.62 KB | None | 0 0
  1. CREATE TABLE `film_actor` (
  2.   `actor_id` SMALLINT(5) UNSIGNED NOT NULL,
  3.   `film_id` SMALLINT(5) UNSIGNED NOT NULL,
  4.   `last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP()
  5. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  6.  
  7. ALTER TABLE `film_actor`
  8.   ADD PRIMARY KEY (`actor_id`,`film_id`),
  9.   ADD KEY `idx_fk_film_id` (`film_id`);
  10.  
  11. ALTER TABLE `film_actor`
  12.   ADD CONSTRAINT `fk_film_actor_actor` FOREIGN KEY (`actor_id`) REFERENCES `actor` (`actor_id`) ON UPDATE CASCADE,
  13.   ADD CONSTRAINT `fk_film_actor_film` FOREIGN KEY (`film_id`) REFERENCES `film` (`film_id`) ON UPDATE CASCADE;
  14. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement