fNpFTRE8

1CREATE TABLE IF NOT EXISTS `shows` (
2  `showId` int(11) NOT NULL,
3  `showName` varchar(200) NOT NULL,
4  `showTotalSeasons` int(11) NOT NULL,
5  `showLink` varchar(100) NOT NULL,
6  `showStarted` date NOT NULL,
7  `showEnded` date NOT NULL,
8  `showImage` varchar(500) NOT NULL,
9  `originCountry` varchar(20) NOT NULL,
10  `showStatus` varchar(100) NOT NULL,
11  `showAirtime` time NOT NULL,
12  `showAirday` varchar(20) NOT NULL,
13  PRIMARY KEY (`showId`)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1;
15
16CREATE TABLE IF NOT EXISTS `seasons` (
17  `seasonId` int(11) NOT NULL AUTO_INCREMENT,
18  `showId` int(11) NOT NULL,
19  `season` int(11) NOT NULL,
20  PRIMARY KEY (`seasonId`)
21) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
22
23CREATE TABLE IF NOT EXISTS `episodes` (
24  `episodesId` int(11) NOT NULL AUTO_INCREMENT,
25  `seasonId` int(11) NOT NULL,
26  `episodeNr` int(11) NOT NULL,
27  `title` varchar(100) NOT NULL,
28  `screencap` varchar(200) NOT NULL,
29  `airDate` date NOT NULL,
30  `link` varchar(200) NOT NULL,
31  PRIMARY KEY (`episodesId`)
32) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=326 ;