All pastes #160892 Raw Edit

Something

public text v1 · immutable
·published 2006-09-04 20:13 UTC
rendered paste body
CREATE TABLE Directors (
  IMDBNumber INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Name TINYTEXT NULL,
  PRIMARY KEY(IMDBNumber)
)
TYPE=InnoDB;

CREATE TABLE Genres (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Genre TINYTEXT NULL,
  PRIMARY KEY(id)
)
TYPE=InnoDB;

CREATE TABLE Movies (
  IMDBNumber INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Year_2 INTEGER UNSIGNED NULL,
  Type_2 INTEGER UNSIGNED NULL,
  OfficialLinks TINYTEXT NULL,
  MiscSites TINYTEXT NULL,
  PRIMARY KEY(IMDBNumber)
)
TYPE=InnoDB;

CREATE TABLE Movies_has_Directors (
  Movies_IMDBNumber INTEGER UNSIGNED NOT NULL,
  Directors_IMDBNumber INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY(Movies_IMDBNumber, Directors_IMDBNumber),
  INDEX Movies_has_Directors_FKIndex1(Movies_IMDBNumber),
  INDEX Movies_has_Directors_FKIndex2(Directors_IMDBNumber)
);

CREATE TABLE Movies_has_Genres (
  Movies_IMDBNumber INTEGER UNSIGNED NOT NULL,
  Genres_id INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY(Movies_IMDBNumber, Genres_id),
  INDEX Movies_has_Genres_FKIndex1(Movies_IMDBNumber),
  INDEX Movies_has_Genres_FKIndex2(Genres_id)
);

CREATE TABLE Movies_has_Titles (
  Movies_IMDBNumber INTEGER UNSIGNED NOT NULL,
  Titles_id INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY(Movies_IMDBNumber, Titles_id),
  INDEX Movies_has_Titles_FKIndex1(Movies_IMDBNumber),
  INDEX Movies_has_Titles_FKIndex2(Titles_id)
);

CREATE TABLE Titles (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Title TINYTEXT NULL,
  PRIMARY KEY(id)
)
TYPE=InnoDB;

CREATE TABLE torrents (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  ChosenTitle TINYTEXT NULL,
  PRIMARY KEY(id)
)
TYPE=InnoDB;