rendered paste bodyCREATE 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;