DROP TABLE IF EXISTS year;
CREATE TABLE year (
  yearID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS network;
CREATE TABLE network (
  networkID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS title;
CREATE TABLE title (
  titleID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS channel;
CREATE TABLE channel (
  channelID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  name text DEFAULT "",
  stationid integer DEFAULT 0,
  network integer DEFAULT 0,
  longName text DEFAULT "",
  logoMask integer DEFAULT 0
);

DROP TABLE IF EXISTS channel_logoImage;
CREATE TABLE channel_logoImage (
  channelID integer DEFAULT 0,
  logoImages integer DEFAULT 0
);


DROP TABLE IF EXISTS bonus;
CREATE TABLE bonus (
  bonusID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS person;
CREATE TABLE person (
  personID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  name text DEFAULT "",
  extID integer DEFAULT 0,
  dateOfBirth integer DEFAULT 0,
  dateOfDeath integer DEFAULT 0,
  birthPlace integer DEFAULT 0,
  headshotImageId integer DEFAULT 0
);

DROP TABLE IF EXISTS person_award1;
CREATE TABLE person_award1 (
  personID integer DEFAULT 0,
  awardYear integer DEFAULT 0
);

DROP TABLE IF EXISTS person_award2;
CREATE TABLE person_award2 (
  personID integer DEFAULT 0,
  awardName integer DEFAULT 0
);


DROP TABLE IF EXISTS subCategory;
CREATE TABLE subCategory (
  subCategoryID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS rated;
CREATE TABLE rated (
  ratedID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS parentalRating;
CREATE TABLE parentalRating (
  parentalRatingID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS extendedRating;
CREATE TABLE extendedRating (
  extendedRatingID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS category;
CREATE TABLE category (
  categoryID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS primeTitle;
CREATE TABLE primeTitle (
  primeTitleID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  str text DEFAULT ""
);


DROP TABLE IF EXISTS show;
CREATE TABLE show (
  showID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  duration integer DEFAULT 0,
  titleID integer DEFAULT 0,
  episodeNameStr text DEFAULT "",
  descrStr text DEFAULT "",
  categories0 integer DEFAULT 0,
  categories1 integer DEFAULT 0,
  rated integer DEFAULT 0,
  year integer DEFAULT 0,
  pr integer DEFAULT 0,
  lastwatched integer DEFAULT 0,
  forcedFirstRun integer DEFAULT 0,
  extID text DEFAULT "",
  updateCount integer DEFAULT 0,
  language integer DEFAULT 0,
  originalAirDate integer DEFAULT 0,
  seasonNum integer DEFAULT 0,
  episodeNum integer DEFAULT 0,
  cachedUnique integer DEFAULT 0,
  altEpisodeNum integer DEFAULT 0,
  showcardID integer DEFAULT 0,
  seriesID integer DEFAULT 0
);

DROP TABLE IF EXISTS show_person;
CREATE TABLE show_person (
  showID integer DEFAULT 0,
  personID integer DEFAULT 0,
  role integer DEFAULT 0
);

DROP TABLE IF EXISTS show_ers;
CREATE TABLE show_ers (
  showID integer DEFAULT 0,
  er integer DEFAULT 0
);

DROP TABLE IF EXISTS show_bonus;
CREATE TABLE show_bonus (
  showID integer DEFAULT 0,
  bonus integer DEFAULT 0
);

DROP TABLE IF EXISTS show_extraCat;
CREATE TABLE show_extraCat (
  showID integer DEFAULT 0,
  extraCat integer DEFAULT 0
);

DROP TABLE IF EXISTS show_image;
CREATE TABLE show_image (
  showID integer DEFAULT 0,
  imageID integer DEFAULT 0
);


DROP TABLE IF EXISTS airing;
CREATE TABLE airing (
  airingID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  showID integer DEFAULT 0,
  stationID integer DEFAULT 0,
  airTime integer DEFAULT 0,
  duration integer DEFAULT 0,
  partsB integer DEFAULT 0,
  miscB integer DEFAULT 0,
  prB integer DEFAULT 0,
  persist integer DEFAULT 0
);


DROP TABLE IF EXISTS manualRecord;
CREATE TABLE manualRecord (
  manualRecordID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  startTime integer DEFAULT 0,
  duration integer DEFAULT 0,
  providerID integer DEFAULT 0,
  stationID integer DEFAULT 0,
  recur integer DEFAULT 0,
  infoAiringID integer DEFAULT 0,
  mrProperties text DEFAULT ""
);

DROP TABLE IF EXISTS manualRecord_extraInfo;
CREATE TABLE manualRecord_extraInfo (
  manualRecordID integer DEFAULT 0,
  extraInfo text DEFAULT ""
);

DROP TABLE IF EXISTS manualRecord_weakAiring;
CREATE TABLE manualRecord_weakAiring (
  manualRecordID integer DEFAULT 0,
  weakAiring integer DEFAULT 0
);


DROP TABLE IF EXISTS mediaFile;
CREATE TABLE mediaFile (
  mediaFileID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  createWatchCount integer DEFAULT 0,
  videoDirectory text DEFAULT "",
  name text DEFAULT "",
  archive integer DEFAULT 0,
  infoAiringID integer DEFAULT 0,
  host text DEFAULT "",
  encodedBy text DEFAULT "",
  mediaType integer DEFAULT 0,
  mediaSubtype integer DEFAULT 0,
  generalType integer DEFAULT 0,
  acquisitionTech integer DEFAULT 0,
  forcedComplete integer DEFAULT 0,
  thumbnailFile text DEFAULT "",
  thumbnailOffset integer DEFAULT 0,
  thumbnailSize integer DEFAULT 0,
  fileFormat text DEFAULT ""
);

DROP TABLE IF EXISTS mediaFile_file;
CREATE TABLE mediaFile_file (
  mediaFileID integer DEFAULT 0,
  currFile text DEFAULT "",
  times1 integer DEFAULT 0,
  times2 integer DEFAULT 0
);


DROP TABLE IF EXISTS watched;
CREATE TABLE watched (
  watchedID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  airingID integer DEFAULT 0,
  watchStart integer DEFAULT 0,
  watchEnd integer DEFAULT 0,
  realStart integer DEFAULT 0,
  realEnd integer DEFAULT 0,
  showID integer DEFAULT 0,
  watchTime integer DEFAULT 0,
  titleNum integer DEFAULT 0
);


DROP TABLE IF EXISTS agent;
CREATE TABLE agent (
  agentID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  agentMask integer DEFAULT 0,
  title integer DEFAULT 0,
  category integer DEFAULT 0,
  subCategory integer DEFAULT 0,
  person integer DEFAULT 0,
  rated integer DEFAULT 0,
  year integer DEFAULT 0,
  pr integer DEFAULT 0,
  chanName text DEFAULT "",
  network integer DEFAULT 0,
  createTime integer DEFAULT 0,
  slotType integer DEFAULT 0,
  quality text DEFAULT "",
  startPad integer DEFAULT 0,
  stopPad integer DEFAULT 0,
  agentFlags integer DEFAULT 0,
  role integer DEFAULT 0,
  keyword text DEFAULT "",
  autoConvertFormat text DEFAULT "",
  autoConvertDest text DEFAULT "",
  favProps text DEFAULT ""
);

DROP TABLE IF EXISTS agent_timeSlot;
CREATE TABLE agent_timeSlot (
  agentID integer DEFAULT 0,
  timeslot integer DEFAULT 0
);

DROP TABLE IF EXISTS agent_weakAgent;
CREATE TABLE agent_weakAgent (
  agentID integer DEFAULT 0,
  weakAgent integer DEFAULT 0
);


DROP TABLE IF EXISTS wasted;
CREATE TABLE wasted (
  wastedID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  airingID integer DEFAULT 0,
  manual integer DEFAULT 0
);


DROP TABLE IF EXISTS playlist;
CREATE TABLE playlist (
  playlistID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  name text DEFAULT "",
  playlistProps text DEFAULT ""
);

DROP TABLE IF EXISTS playlist_segment1;
CREATE TABLE playlist_segment1 (
  playlist_segmentID integer DEFAULT 0,
  title integer DEFAULT 0,
  artist integer DEFAULT 0,
  genre integer DEFAULT 0,
  year integer DEFAULT 0
);

DROP TABLE IF EXISTS playlist_segment2;
CREATE TABLE playlist_segment2 (
  playlist_segmentID integer DEFAULT 0,
  segElem integer DEFAULT 0
);

DROP TABLE IF EXISTS playlist_segment2_currTime;
CREATE TABLE playlist_segment2_currTime (
  playlist_segment2ID integer DEFAULT 0,
  currTime integer DEFAULT 0
);


DROP TABLE IF EXISTS tVEditorial;
CREATE TABLE tVEditorial (
  tVEditorialID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  showID integer DEFAULT 0,
  title integer DEFAULT 0,
  network integer DEFAULT 0,
  airdate text DEFAULT "",
  description text DEFAULT "",
  imageURL text DEFAULT ""
);


DROP TABLE IF EXISTS seriesInfo;
CREATE TABLE seriesInfo (
  seriesInfoID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  legacySeriesID integer DEFAULT 0,
  title integer DEFAULT 0,
  network integer DEFAULT 0,
  description text DEFAULT "",
  history text DEFAULT "",
  premiereDate text DEFAULT "",
  finaleDate text DEFAULT "",
  airDow text DEFAULT "",
  airHrMin text DEFAULT "",
  imageUrl text DEFAULT "",
  props text DEFAULT "",
  showcardID integer DEFAULT 0
);

DROP TABLE IF EXISTS seriesInfo_person;
CREATE TABLE seriesInfo_person (
  seriesInfoID integer DEFAULT 0,
  person integer DEFAULT 0,
  character text DEFAULT ""
);

DROP TABLE IF EXISTS seriesInfo_seriesImage;
CREATE TABLE seriesInfo_seriesImage (
  seriesInfoID integer DEFAULT 0,
  seriesImage integer DEFAULT 0
);

DROP TABLE IF EXISTS seriesInfo_castImage;
CREATE TABLE seriesInfo_castImage (
  seriesInfoID integer DEFAULT 0,
  castImage integer DEFAULT 0
);


DROP TABLE IF EXISTS userRecord;
CREATE TABLE userRecord (
  userRecordID integer DEFAULT 0,
  mediamask integer DEFAULT 0,
  store text DEFAULT "",
  usaerKey text DEFAULT "",
  props text DEFAULT ""
);


DROP TABLE IF EXISTS titles_by_name;
CREATE TABLE titles_by_name (
  pos integer DEFAULT 0,
  titleID integer DEFAULT 0
);

DROP TABLE IF EXISTS person_by_name;
CREATE TABLE person_by_name (
  pos integer DEFAULT 0,
  peopleID integer DEFAULT 0
);

DROP TABLE IF EXISTS shows_by_extid;
CREATE TABLE shows_by_extid (
  pos integer DEFAULT 0,
  showID integer DEFAULT 0
);

DROP TABLE IF EXISTS airings_by_ct;
CREATE TABLE airings_by_ct (
  pos integer DEFAULT 0,
  airingID integer DEFAULT 0
);

DROP TABLE IF EXISTS airings_by_show;
CREATE TABLE airings_by_show (
  pos integer DEFAULT 0,
  airingID integer DEFAULT 0
);

DROP TABLE IF EXISTS watched_by_time;
CREATE TABLE watched_by_time (
  pos integer DEFAULT 0,
  watchedID integer DEFAULT 0
);

DROP TABLE IF EXISTS prime_titles_by_name;
CREATE TABLE prime_titles_by_name (
  pos integer DEFAULT 0,
  primeTitleID integer DEFAULT 0
);

DROP TABLE IF EXISTS shows_by_titleid;
CREATE TABLE shows_by_titleid (
  pos integer DEFAULT 0,
  showID integer DEFAULT 0
);

DROP TABLE IF EXISTS mediafile_by_airing_id;
CREATE TABLE mediafile_by_airing_id (
  pos integer DEFAULT 0,
  mediafileID integer DEFAULT 0
);

DROP TABLE IF EXISTS agents_by_carny;
CREATE TABLE agents_by_carny (
  pos integer DEFAULT 0,
  agentID integer DEFAULT 0
);

DROP TABLE IF EXISTS mediafile_by_file_path;
CREATE TABLE mediafile_by_file_path (
  pos integer DEFAULT 0,
  mediafileID integer DEFAULT 0
);

DROP TABLE IF EXISTS seriesinfo_by_legacyseriesid;
CREATE TABLE seriesinfo_by_legacyseriesid (
  pos integer DEFAULT 0,
  seriesinfoID integer DEFAULT 0
);

DROP TABLE IF EXISTS userrecord_by_storekey;
CREATE TABLE userrecord_by_storekey (
  pos integer DEFAULT 0,
  userrecordID integer DEFAULT 0
);

DROP TABLE IF EXISTS seriesinfo_by_showcardid;
CREATE TABLE seriesinfo_by_showcardid (
  pos integer DEFAULT 0,
  seriesinfoID integer DEFAULT 0
);

DROP TABLE IF EXISTS person_by_extid;
CREATE TABLE person_by_extid (
  pos integer DEFAULT 0,
  personID integer DEFAULT 0
);