3gAQApSc

1$sql = "DROP TABLE IF EXISTS ".$table_shows.";
2        CREATE TABLE $table_shows (
3          show_id int(11) NOT NULL,
4          name varchar(120) DEFAULT NULL
5          PRIMARY KEY  (show_id),
6          UNIQUE KEY  show_id_UNIQUE (show_id)
7        ) $charset_collate;
8
9        DROP TABLE IF EXISTS ".$table_seasons.";
10        CREATE TABLE $table_seasons (
11          season_id int(10) NOT NULL,
12          show_id int(11) DEFAULT NULL,
13          name varchar(120) DEFAULT NULL
14          PRIMARY KEY  (season_id),
15          KEY seasons_ibfk_1 (show_id),
16          CONSTRAINT  seasons_ibfk_1 FOREIGN KEY  (show_id) REFERENCES $table_shows (show_id) ON DELETE CASCADE ON UPDATE CASCADE
17        ) $charset_collate;
18
19        DROP TABLE IF EXISTS ".$table_episodes.";
20        CREATE TABLE $table_episodes (
21          episode_id int(10) NOT NULL,
22          season_id int(10) DEFAULT NULL,
23          name varchar(120) DEFAULT NULL
24          PRIMARY KEY  (episode_id),
25          KEY  season_id (season_id),
26          CONSTRAINT  episodes_ibfk_1 FOREIGN KEY  (season_id) REFERENCES $table_seasons (season_id)
27        ) $charset_collate;";