Guest User

Untitled

a guest
Sep 1st, 2016
40
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `main` (
  2.   `movie_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  3.   `Title` varchar(100) COLLATE latin1_general_ci NOT NULL
  4. );
  5.  
  6. CREATE TABLE genre (
  7.     genre_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  8.     genre varchar(150) COLLATE latin1_general_ci NOT NULL,
  9.     UNIQUE KEY (genre)
  10. );
  11.  
  12. CREATE TABLE genre_main (
  13.     movie_id INT UNSIGNED NOT NULL,
  14.     genre_id SMALLINT UNSIGNED NOT NULL,
  15.     PRIMARY KEY (movie_id, genre_id)
  16. );
RAW Paste Data