Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- RENAME TABLE `a78`.`files` to `a78`.`globalfiles`;
- ALTER TABLE `a78`.`globalfiles` CHANGE playCount PlayCount1 INT;
- ALTER TABLE `a78`.`globalfiles` CHANGE lastPlayed lastPlayed1 TEXT;
- ALTER TABLE `a78`.`globalfiles` ADD playCount2 INT(11) AFTER lastPlayed1;
- ALTER TABLE `a78`.`globalfiles` ADD lastPlayed2 TEXT AFTER playCount2;
- ALTER TABLE `a78`.`globalfiles` ADD playCount3 INT(11) AFTER lastPlayed2;
- ALTER TABLE `a78`.`globalfiles` ADD lastPlayed3 TEXT AFTER playCount3;
- ALTER TABLE `a78`.`globalfiles` ADD playCount4 INT(11) AFTER lastPlayed3;
- ALTER TABLE `a78`.`globalfiles` ADD lastPlayed4 TEXT AFTER playCount4;
- ALTER TABLE `a78`.`globalfiles` ADD playCount5 INT(11) AFTER lastPlayed4;
- ALTER TABLE `a78`.`globalfiles` ADD lastPlayed5 TEXT AFTER playCount5;
- CREATE VIEW `a78`.`files`
- AS SELECT
- `a78`.`globalfiles`.`idFile` AS `idFile`,
- `a78`.`globalfiles`.`idPath` AS `idPath`,
- `a78`.`globalfiles`.`strFilename` AS `strFilename`,
- `a78`.`globalfiles`.`playCount1` AS `playCount`,
- `a78`.`globalfiles`.`lastPlayed1` AS `lastPlayed`,
- `a78`.`globalfiles`.`dateAdded` AS `dateAdded`
- FROM `a78`.`globalfiles`;
- CREATE DATABASE b78;
- CREATE VIEW `b78`.`actorlinkepisode` AS SELECT * FROM `a78`.`actorlinkepisode`;
- CREATE VIEW `b78`.`actorlinkmovie` AS SELECT * FROM `a78`.`actorlinkmovie`;
- CREATE VIEW `b78`.`actorlinktvshow` AS SELECT * FROM `a78`.`actorlinktvshow`;
- CREATE VIEW `b78`.`actors` AS SELECT * FROM `a78`.`actors`;
- CREATE VIEW `b78`.`art` AS SELECT * FROM `a78`.`art`;
- CREATE VIEW `b78`.`artistlinkmusicvideo` AS SELECT * FROM `a78`.`artistlinkmusicvideo`;
- CREATE VIEW `b78`.`country` AS SELECT * FROM `a78`.`country`;
- CREATE VIEW `b78`.`countrylinkmovie` AS SELECT * FROM `a78`.`countrylinkmovie`;
- CREATE VIEW `b78`.`directorlinkepisode` AS SELECT * FROM `a78`.`directorlinkepisode`;
- CREATE VIEW `b78`.`directorlinkmovie` AS SELECT * FROM `a78`.`directorlinkmovie`;
- CREATE VIEW `b78`.`directorlinkmusicvideo` AS SELECT * FROM `a78`.`directorlinkmusicvideo`;
- CREATE VIEW `b78`.`directorlinktvshow` AS SELECT * FROM `a78`.`directorlinktvshow`;
- CREATE VIEW `b78`.`episode` AS SELECT * FROM `a78`.`episode`;
- CREATE VIEW `b78`.`genre` AS SELECT * FROM `a78`.`genre`;
- CREATE VIEW `b78`.`genrelinkmovie` AS SELECT * FROM `a78`.`genrelinkmovie`;
- CREATE VIEW `b78`.`genrelinkmusicvideo` AS SELECT * FROM `a78`.`genrelinkmusicvideo`;
- CREATE VIEW `b78`.`genrelinktvshow` AS SELECT * FROM `a78`.`genrelinktvshow`;
- CREATE VIEW `b78`.`movie` AS SELECT * FROM `a78`.`movie`;
- CREATE VIEW `b78`.`movielinktvshow` AS SELECT * FROM `a78`.`movielinktvshow`;
- CREATE VIEW `b78`.`musicvideo` AS SELECT * FROM `a78`.`musicvideo`;
- CREATE VIEW `b78`.`path` AS SELECT * FROM `a78`.`path`;
- CREATE VIEW `b78`.`seasons` AS SELECT * FROM `a78`.`seasons`;
- CREATE VIEW `b78`.`sets` AS SELECT * FROM `a78`.`sets`;
- CREATE VIEW `b78`.`settings` AS SELECT * FROM `a78`.`settings`;
- CREATE VIEW `b78`.`stacktimes` AS SELECT * FROM `a78`.`stacktimes`;
- CREATE VIEW `b78`.`streamdetails` AS SELECT * FROM `a78`.`streamdetails`;
- CREATE VIEW `b78`.`studio` AS SELECT * FROM `a78`.`studio`;
- CREATE VIEW `b78`.`studiolinkmovie` AS SELECT * FROM `a78`.`studiolinkmovie`;
- CREATE VIEW `b78`.`studiolinkmusicvideo` AS SELECT * FROM `a78`.`studiolinkmusicvideo`;
- CREATE VIEW `b78`.`studiolinktvshow` AS SELECT * FROM `a78`.`studiolinktvshow`;
- CREATE VIEW `b78`.`tag` AS SELECT * FROM `a78`.`tag`;
- CREATE VIEW `b78`.`taglinks` AS SELECT * FROM `a78`.`taglinks`;
- CREATE VIEW `b78`.`tvshow` AS SELECT * FROM `a78`.`tvshow`;
- CREATE VIEW `b78`.`tvshowlinkpath` AS SELECT * FROM `a78`.`tvshowlinkpath`;
- CREATE VIEW `b78`.`version` AS SELECT * FROM `a78`.`version`;
- CREATE VIEW `b78`.`writerlinkepisode` AS SELECT * FROM `a78`.`writerlinkepisode`;
- CREATE VIEW `b78`.`writerlinkmovie` AS SELECT * FROM `a78`.`writerlinkmovie`;
- CREATE VIEW `b78`.`files`
- AS SELECT
- `a78`.`globalfiles`.`idFile` AS `idFile`,
- `a78`.`globalfiles`.`idPath` AS `idPath`,
- `a78`.`globalfiles`.`strFilename` AS `strFilename`,
- `a78`.`globalfiles`.`playCount2` AS `playCount`,
- `a78`.`globalfiles`.`lastPlayed2` AS `lastPlayed`,
- `a78`.`globalfiles`.`dateAdded` AS `dateAdded`
- FROM `a78`.`globalfiles`;
- CREATE TABLE `b78`.`bookmark` (
- `idBookmark` int(11) NOT NULL AUTO_INCREMENT,
- `idFile` int(11) DEFAULT NULL,
- `timeInSeconds` double DEFAULT NULL,
- `totalTimeInSeconds` double DEFAULT NULL,
- `thumbNailImage` text,
- `player` text,
- `playerState` text,
- `type` int(11) DEFAULT NULL,
- PRIMARY KEY (`idBookmark`),
- KEY `ix_bookmark` (`idFile`,`type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE VIEW `b78`.`episodeview`
- AS SELECT
- `episode`.`idEpisode` AS `idEpisode`,
- `episode`.`idFile` AS `idFile`,
- `episode`.`c00` AS `c00`,
- `episode`.`c01` AS `c01`,
- `episode`.`c02` AS `c02`,
- `episode`.`c03` AS `c03`,
- `episode`.`c04` AS `c04`,
- `episode`.`c05` AS `c05`,
- `episode`.`c06` AS `c06`,
- `episode`.`c07` AS `c07`,
- `episode`.`c08` AS `c08`,
- `episode`.`c09` AS `c09`,
- `episode`.`c10` AS `c10`,
- `episode`.`c11` AS `c11`,
- `episode`.`c12` AS `c12`,
- `episode`.`c13` AS `c13`,
- `episode`.`c14` AS `c14`,
- `episode`.`c15` AS `c15`,
- `episode`.`c16` AS `c16`,
- `episode`.`c17` AS `c17`,
- `episode`.`c18` AS `c18`,
- `episode`.`c19` AS `c19`,
- `episode`.`c20` AS `c20`,
- `episode`.`c21` AS `c21`,
- `episode`.`c22` AS `c22`,
- `episode`.`c23` AS `c23`,
- `episode`.`idShow` AS `idShow`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `tvshow`.`c00` AS `strTitle`,
- `tvshow`.`c14` AS `strStudio`,
- `tvshow`.`c05` AS `premiered`,
- `tvshow`.`c13` AS `mpaa`,
- `tvshow`.`c16` AS `strShowPath`,
- `b78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `b78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
- `seasons`.`idSeason` AS `idSeason`
- FROM (((((`b78`.`episode` join `b78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `b78`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `b78`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `b78`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `b78`.`bookmark` on(((`b78`.`bookmark`.`idFile` = `episode`.`idFile`) and (`b78`.`bookmark`.`type` = 1))));
- CREATE VIEW `b78`.`movieview`
- AS SELECT
- `movie`.`idMovie` AS `idMovie`,
- `movie`.`idFile` AS `idFile`,
- `movie`.`c00` AS `c00`,
- `movie`.`c01` AS `c01`,
- `movie`.`c02` AS `c02`,
- `movie`.`c03` AS `c03`,
- `movie`.`c04` AS `c04`,
- `movie`.`c05` AS `c05`,
- `movie`.`c06` AS `c06`,
- `movie`.`c07` AS `c07`,
- `movie`.`c08` AS `c08`,
- `movie`.`c09` AS `c09`,
- `movie`.`c10` AS `c10`,
- `movie`.`c11` AS `c11`,
- `movie`.`c12` AS `c12`,
- `movie`.`c13` AS `c13`,
- `movie`.`c14` AS `c14`,
- `movie`.`c15` AS `c15`,
- `movie`.`c16` AS `c16`,
- `movie`.`c17` AS `c17`,
- `movie`.`c18` AS `c18`,
- `movie`.`c19` AS `c19`,
- `movie`.`c20` AS `c20`,
- `movie`.`c21` AS `c21`,
- `movie`.`c22` AS `c22`,
- `movie`.`c23` AS `c23`,
- `movie`.`idSet` AS `idSet`,
- `sets`.`strSet` AS `strSet`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `b78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `b78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM ((((`b78`.`movie` left join `b78`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `b78`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `b78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `b78`.`bookmark` on(((`b78`.`bookmark`.`idFile` = `movie`.`idFile`) and (`b78`.`bookmark`.`type` = 1))));
- CREATE VIEW `b78`.`musicvideoview`
- AS SELECT
- `musicvideo`.`idMVideo` AS `idMVideo`,
- `musicvideo`.`idFile` AS `idFile`,
- `musicvideo`.`c00` AS `c00`,
- `musicvideo`.`c01` AS `c01`,
- `musicvideo`.`c02` AS `c02`,
- `musicvideo`.`c03` AS `c03`,
- `musicvideo`.`c04` AS `c04`,
- `musicvideo`.`c05` AS `c05`,
- `musicvideo`.`c06` AS `c06`,
- `musicvideo`.`c07` AS `c07`,
- `musicvideo`.`c08` AS `c08`,
- `musicvideo`.`c09` AS `c09`,
- `musicvideo`.`c10` AS `c10`,
- `musicvideo`.`c11` AS `c11`,
- `musicvideo`.`c12` AS `c12`,
- `musicvideo`.`c13` AS `c13`,
- `musicvideo`.`c14` AS `c14`,
- `musicvideo`.`c15` AS `c15`,
- `musicvideo`.`c16` AS `c16`,
- `musicvideo`.`c17` AS `c17`,
- `musicvideo`.`c18` AS `c18`,
- `musicvideo`.`c19` AS `c19`,
- `musicvideo`.`c20` AS `c20`,
- `musicvideo`.`c21` AS `c21`,
- `musicvideo`.`c22` AS `c22`,
- `musicvideo`.`c23` AS `c23`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `b78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `b78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM (((`b78`.`musicvideo` join `b78`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `b78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `b78`.`bookmark` on(((`b78`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`b78`.`bookmark`.`type` = 1))));
- CREATE VIEW `b78`.`tvshowview`
- AS SELECT
- `tvshow`.`idShow` AS `idShow`,
- `tvshow`.`c00` AS `c00`,
- `tvshow`.`c01` AS `c01`,
- `tvshow`.`c02` AS `c02`,
- `tvshow`.`c03` AS `c03`,
- `tvshow`.`c04` AS `c04`,
- `tvshow`.`c05` AS `c05`,
- `tvshow`.`c06` AS `c06`,
- `tvshow`.`c07` AS `c07`,
- `tvshow`.`c08` AS `c08`,
- `tvshow`.`c09` AS `c09`,
- `tvshow`.`c10` AS `c10`,
- `tvshow`.`c11` AS `c11`,
- `tvshow`.`c12` AS `c12`,
- `tvshow`.`c13` AS `c13`,
- `tvshow`.`c14` AS `c14`,
- `tvshow`.`c15` AS `c15`,
- `tvshow`.`c16` AS `c16`,
- `tvshow`.`c17` AS `c17`,
- `tvshow`.`c18` AS `c18`,
- `tvshow`.`c19` AS `c19`,
- `tvshow`.`c20` AS `c20`,
- `tvshow`.`c21` AS `c21`,
- `tvshow`.`c22` AS `c22`,
- `tvshow`.`c23` AS `c23`,
- `path`.`strPath` AS `strPath`,
- `path`.`dateAdded` AS `dateAdded`,max(`files`.`lastPlayed`) AS `lastPlayed`,nullif(count(`episode`.`c12`),0) AS `totalCount`,count(`files`.`playCount`) AS `watchedcount`,nullif(count(distinct `episode`.`c12`),0) AS `totalSeasons`
- FROM ((((`b78`.`tvshow` left join `b78`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `b78`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) left join `b78`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `b78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;
- CREATE DATABASE c78;
- CREATE VIEW `c78`.`actorlinkepisode` AS SELECT * FROM `a78`.`actorlinkepisode`;
- CREATE VIEW `c78`.`actorlinkmovie` AS SELECT * FROM `a78`.`actorlinkmovie`;
- CREATE VIEW `c78`.`actorlinktvshow` AS SELECT * FROM `a78`.`actorlinktvshow`;
- CREATE VIEW `c78`.`actors` AS SELECT * FROM `a78`.`actors`;
- CREATE VIEW `c78`.`art` AS SELECT * FROM `a78`.`art`;
- CREATE VIEW `c78`.`artistlinkmusicvideo` AS SELECT * FROM `a78`.`artistlinkmusicvideo`;
- CREATE VIEW `c78`.`country` AS SELECT * FROM `a78`.`country`;
- CREATE VIEW `c78`.`countrylinkmovie` AS SELECT * FROM `a78`.`countrylinkmovie`;
- CREATE VIEW `c78`.`directorlinkepisode` AS SELECT * FROM `a78`.`directorlinkepisode`;
- CREATE VIEW `c78`.`directorlinkmovie` AS SELECT * FROM `a78`.`directorlinkmovie`;
- CREATE VIEW `c78`.`directorlinkmusicvideo` AS SELECT * FROM `a78`.`directorlinkmusicvideo`;
- CREATE VIEW `c78`.`directorlinktvshow` AS SELECT * FROM `a78`.`directorlinktvshow`;
- CREATE VIEW `c78`.`episode` AS SELECT * FROM `a78`.`episode`;
- CREATE VIEW `c78`.`genre` AS SELECT * FROM `a78`.`genre`;
- CREATE VIEW `c78`.`genrelinkmovie` AS SELECT * FROM `a78`.`genrelinkmovie`;
- CREATE VIEW `c78`.`genrelinkmusicvideo` AS SELECT * FROM `a78`.`genrelinkmusicvideo`;
- CREATE VIEW `c78`.`genrelinktvshow` AS SELECT * FROM `a78`.`genrelinktvshow`;
- CREATE VIEW `c78`.`movie` AS SELECT * FROM `a78`.`movie`;
- CREATE VIEW `c78`.`movielinktvshow` AS SELECT * FROM `a78`.`movielinktvshow`;
- CREATE VIEW `c78`.`musicvideo` AS SELECT * FROM `a78`.`musicvideo`;
- CREATE VIEW `c78`.`path` AS SELECT * FROM `a78`.`path`;
- CREATE VIEW `c78`.`seasons` AS SELECT * FROM `a78`.`seasons`;
- CREATE VIEW `c78`.`sets` AS SELECT * FROM `a78`.`sets`;
- CREATE VIEW `c78`.`settings` AS SELECT * FROM `a78`.`settings`;
- CREATE VIEW `c78`.`stacktimes` AS SELECT * FROM `a78`.`stacktimes`;
- CREATE VIEW `c78`.`streamdetails` AS SELECT * FROM `a78`.`streamdetails`;
- CREATE VIEW `c78`.`studio` AS SELECT * FROM `a78`.`studio`;
- CREATE VIEW `c78`.`studiolinkmovie` AS SELECT * FROM `a78`.`studiolinkmovie`;
- CREATE VIEW `c78`.`studiolinkmusicvideo` AS SELECT * FROM `a78`.`studiolinkmusicvideo`;
- CREATE VIEW `c78`.`studiolinktvshow` AS SELECT * FROM `a78`.`studiolinktvshow`;
- CREATE VIEW `c78`.`tag` AS SELECT * FROM `a78`.`tag`;
- CREATE VIEW `c78`.`taglinks` AS SELECT * FROM `a78`.`taglinks`;
- CREATE VIEW `c78`.`tvshow` AS SELECT * FROM `a78`.`tvshow`;
- CREATE VIEW `c78`.`tvshowlinkpath` AS SELECT * FROM `a78`.`tvshowlinkpath`;
- CREATE VIEW `c78`.`version` AS SELECT * FROM `a78`.`version`;
- CREATE VIEW `c78`.`writerlinkepisode` AS SELECT * FROM `a78`.`writerlinkepisode`;
- CREATE VIEW `c78`.`writerlinkmovie` AS SELECT * FROM `a78`.`writerlinkmovie`;
- CREATE VIEW `c78`.`files`
- AS SELECT
- `a78`.`globalfiles`.`idFile` AS `idFile`,
- `a78`.`globalfiles`.`idPath` AS `idPath`,
- `a78`.`globalfiles`.`strFilename` AS `strFilename`,
- `a78`.`globalfiles`.`playCount3` AS `playCount`,
- `a78`.`globalfiles`.`lastPlayed3` AS `lastPlayed`,
- `a78`.`globalfiles`.`dateAdded` AS `dateAdded`
- FROM `a78`.`globalfiles`;
- CREATE TABLE `c78`.`bookmark` (
- `idBookmark` int(11) NOT NULL AUTO_INCREMENT,
- `idFile` int(11) DEFAULT NULL,
- `timeInSeconds` double DEFAULT NULL,
- `totalTimeInSeconds` double DEFAULT NULL,
- `thumbNailImage` text,
- `player` text,
- `playerState` text,
- `type` int(11) DEFAULT NULL,
- PRIMARY KEY (`idBookmark`),
- KEY `ix_bookmark` (`idFile`,`type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE VIEW `c78`.`episodeview`
- AS SELECT
- `episode`.`idEpisode` AS `idEpisode`,
- `episode`.`idFile` AS `idFile`,
- `episode`.`c00` AS `c00`,
- `episode`.`c01` AS `c01`,
- `episode`.`c02` AS `c02`,
- `episode`.`c03` AS `c03`,
- `episode`.`c04` AS `c04`,
- `episode`.`c05` AS `c05`,
- `episode`.`c06` AS `c06`,
- `episode`.`c07` AS `c07`,
- `episode`.`c08` AS `c08`,
- `episode`.`c09` AS `c09`,
- `episode`.`c10` AS `c10`,
- `episode`.`c11` AS `c11`,
- `episode`.`c12` AS `c12`,
- `episode`.`c13` AS `c13`,
- `episode`.`c14` AS `c14`,
- `episode`.`c15` AS `c15`,
- `episode`.`c16` AS `c16`,
- `episode`.`c17` AS `c17`,
- `episode`.`c18` AS `c18`,
- `episode`.`c19` AS `c19`,
- `episode`.`c20` AS `c20`,
- `episode`.`c21` AS `c21`,
- `episode`.`c22` AS `c22`,
- `episode`.`c23` AS `c23`,
- `episode`.`idShow` AS `idShow`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `tvshow`.`c00` AS `strTitle`,
- `tvshow`.`c14` AS `strStudio`,
- `tvshow`.`c05` AS `premiered`,
- `tvshow`.`c13` AS `mpaa`,
- `tvshow`.`c16` AS `strShowPath`,
- `c78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `c78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
- `seasons`.`idSeason` AS `idSeason`
- FROM (((((`c78`.`episode` join `c78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `c78`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `c78`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `c78`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `c78`.`bookmark` on(((`c78`.`bookmark`.`idFile` = `episode`.`idFile`) and (`c78`.`bookmark`.`type` = 1))));
- CREATE VIEW `c78`.`movieview`
- AS SELECT
- `movie`.`idMovie` AS `idMovie`,
- `movie`.`idFile` AS `idFile`,
- `movie`.`c00` AS `c00`,
- `movie`.`c01` AS `c01`,
- `movie`.`c02` AS `c02`,
- `movie`.`c03` AS `c03`,
- `movie`.`c04` AS `c04`,
- `movie`.`c05` AS `c05`,
- `movie`.`c06` AS `c06`,
- `movie`.`c07` AS `c07`,
- `movie`.`c08` AS `c08`,
- `movie`.`c09` AS `c09`,
- `movie`.`c10` AS `c10`,
- `movie`.`c11` AS `c11`,
- `movie`.`c12` AS `c12`,
- `movie`.`c13` AS `c13`,
- `movie`.`c14` AS `c14`,
- `movie`.`c15` AS `c15`,
- `movie`.`c16` AS `c16`,
- `movie`.`c17` AS `c17`,
- `movie`.`c18` AS `c18`,
- `movie`.`c19` AS `c19`,
- `movie`.`c20` AS `c20`,
- `movie`.`c21` AS `c21`,
- `movie`.`c22` AS `c22`,
- `movie`.`c23` AS `c23`,
- `movie`.`idSet` AS `idSet`,
- `sets`.`strSet` AS `strSet`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `c78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `c78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM ((((`c78`.`movie` left join `c78`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `c78`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `c78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `c78`.`bookmark` on(((`c78`.`bookmark`.`idFile` = `movie`.`idFile`) and (`c78`.`bookmark`.`type` = 1))));
- CREATE VIEW `c78`.`musicvideoview`
- AS SELECT
- `musicvideo`.`idMVideo` AS `idMVideo`,
- `musicvideo`.`idFile` AS `idFile`,
- `musicvideo`.`c00` AS `c00`,
- `musicvideo`.`c01` AS `c01`,
- `musicvideo`.`c02` AS `c02`,
- `musicvideo`.`c03` AS `c03`,
- `musicvideo`.`c04` AS `c04`,
- `musicvideo`.`c05` AS `c05`,
- `musicvideo`.`c06` AS `c06`,
- `musicvideo`.`c07` AS `c07`,
- `musicvideo`.`c08` AS `c08`,
- `musicvideo`.`c09` AS `c09`,
- `musicvideo`.`c10` AS `c10`,
- `musicvideo`.`c11` AS `c11`,
- `musicvideo`.`c12` AS `c12`,
- `musicvideo`.`c13` AS `c13`,
- `musicvideo`.`c14` AS `c14`,
- `musicvideo`.`c15` AS `c15`,
- `musicvideo`.`c16` AS `c16`,
- `musicvideo`.`c17` AS `c17`,
- `musicvideo`.`c18` AS `c18`,
- `musicvideo`.`c19` AS `c19`,
- `musicvideo`.`c20` AS `c20`,
- `musicvideo`.`c21` AS `c21`,
- `musicvideo`.`c22` AS `c22`,
- `musicvideo`.`c23` AS `c23`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `c78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `c78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM (((`c78`.`musicvideo` join `c78`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `c78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `c78`.`bookmark` on(((`c78`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`c78`.`bookmark`.`type` = 1))));
- CREATE VIEW `c78`.`tvshowview`
- AS SELECT
- `tvshow`.`idShow` AS `idShow`,
- `tvshow`.`c00` AS `c00`,
- `tvshow`.`c01` AS `c01`,
- `tvshow`.`c02` AS `c02`,
- `tvshow`.`c03` AS `c03`,
- `tvshow`.`c04` AS `c04`,
- `tvshow`.`c05` AS `c05`,
- `tvshow`.`c06` AS `c06`,
- `tvshow`.`c07` AS `c07`,
- `tvshow`.`c08` AS `c08`,
- `tvshow`.`c09` AS `c09`,
- `tvshow`.`c10` AS `c10`,
- `tvshow`.`c11` AS `c11`,
- `tvshow`.`c12` AS `c12`,
- `tvshow`.`c13` AS `c13`,
- `tvshow`.`c14` AS `c14`,
- `tvshow`.`c15` AS `c15`,
- `tvshow`.`c16` AS `c16`,
- `tvshow`.`c17` AS `c17`,
- `tvshow`.`c18` AS `c18`,
- `tvshow`.`c19` AS `c19`,
- `tvshow`.`c20` AS `c20`,
- `tvshow`.`c21` AS `c21`,
- `tvshow`.`c22` AS `c22`,
- `tvshow`.`c23` AS `c23`,
- `path`.`strPath` AS `strPath`,
- `path`.`dateAdded` AS `dateAdded`,max(`files`.`lastPlayed`) AS `lastPlayed`,nullif(count(`episode`.`c12`),0) AS `totalCount`,count(`files`.`playCount`) AS `watchedcount`,nullif(count(distinct `episode`.`c12`),0) AS `totalSeasons`
- FROM ((((`c78`.`tvshow` left join `c78`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `c78`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) left join `c78`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `c78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;
- CREATE DATABASE d78;
- CREATE VIEW `d78`.`actorlinkepisode` AS SELECT * FROM `a78`.`actorlinkepisode`;
- CREATE VIEW `d78`.`actorlinkmovie` AS SELECT * FROM `a78`.`actorlinkmovie`;
- CREATE VIEW `d78`.`actorlinktvshow` AS SELECT * FROM `a78`.`actorlinktvshow`;
- CREATE VIEW `d78`.`actors` AS SELECT * FROM `a78`.`actors`;
- CREATE VIEW `d78`.`art` AS SELECT * FROM `a78`.`art`;
- CREATE VIEW `d78`.`artistlinkmusicvideo` AS SELECT * FROM `a78`.`artistlinkmusicvideo`;
- CREATE VIEW `d78`.`country` AS SELECT * FROM `a78`.`country`;
- CREATE VIEW `d78`.`countrylinkmovie` AS SELECT * FROM `a78`.`countrylinkmovie`;
- CREATE VIEW `d78`.`directorlinkepisode` AS SELECT * FROM `a78`.`directorlinkepisode`;
- CREATE VIEW `d78`.`directorlinkmovie` AS SELECT * FROM `a78`.`directorlinkmovie`;
- CREATE VIEW `d78`.`directorlinkmusicvideo` AS SELECT * FROM `a78`.`directorlinkmusicvideo`;
- CREATE VIEW `d78`.`directorlinktvshow` AS SELECT * FROM `a78`.`directorlinktvshow`;
- CREATE VIEW `d78`.`episode` AS SELECT * FROM `a78`.`episode`;
- CREATE VIEW `d78`.`genre` AS SELECT * FROM `a78`.`genre`;
- CREATE VIEW `d78`.`genrelinkmovie` AS SELECT * FROM `a78`.`genrelinkmovie`;
- CREATE VIEW `d78`.`genrelinkmusicvideo` AS SELECT * FROM `a78`.`genrelinkmusicvideo`;
- CREATE VIEW `d78`.`genrelinktvshow` AS SELECT * FROM `a78`.`genrelinktvshow`;
- CREATE VIEW `d78`.`movie` AS SELECT * FROM `a78`.`movie`;
- CREATE VIEW `d78`.`movielinktvshow` AS SELECT * FROM `a78`.`movielinktvshow`;
- CREATE VIEW `d78`.`musicvideo` AS SELECT * FROM `a78`.`musicvideo`;
- CREATE VIEW `d78`.`path` AS SELECT * FROM `a78`.`path`;
- CREATE VIEW `d78`.`seasons` AS SELECT * FROM `a78`.`seasons`;
- CREATE VIEW `d78`.`sets` AS SELECT * FROM `a78`.`sets`;
- CREATE VIEW `d78`.`settings` AS SELECT * FROM `a78`.`settings`;
- CREATE VIEW `d78`.`stacktimes` AS SELECT * FROM `a78`.`stacktimes`;
- CREATE VIEW `d78`.`streamdetails` AS SELECT * FROM `a78`.`streamdetails`;
- CREATE VIEW `d78`.`studio` AS SELECT * FROM `a78`.`studio`;
- CREATE VIEW `d78`.`studiolinkmovie` AS SELECT * FROM `a78`.`studiolinkmovie`;
- CREATE VIEW `d78`.`studiolinkmusicvideo` AS SELECT * FROM `a78`.`studiolinkmusicvideo`;
- CREATE VIEW `d78`.`studiolinktvshow` AS SELECT * FROM `a78`.`studiolinktvshow`;
- CREATE VIEW `d78`.`tag` AS SELECT * FROM `a78`.`tag`;
- CREATE VIEW `d78`.`taglinks` AS SELECT * FROM `a78`.`taglinks`;
- CREATE VIEW `d78`.`tvshow` AS SELECT * FROM `a78`.`tvshow`;
- CREATE VIEW `d78`.`tvshowlinkpath` AS SELECT * FROM `a78`.`tvshowlinkpath`;
- CREATE VIEW `d78`.`version` AS SELECT * FROM `a78`.`version`;
- CREATE VIEW `d78`.`writerlinkepisode` AS SELECT * FROM `a78`.`writerlinkepisode`;
- CREATE VIEW `d78`.`writerlinkmovie` AS SELECT * FROM `a78`.`writerlinkmovie`;
- CREATE VIEW `d78`.`files`
- AS SELECT
- `a78`.`globalfiles`.`idFile` AS `idFile`,
- `a78`.`globalfiles`.`idPath` AS `idPath`,
- `a78`.`globalfiles`.`strFilename` AS `strFilename`,
- `a78`.`globalfiles`.`playCount4` AS `playCount`,
- `a78`.`globalfiles`.`lastPlayed4` AS `lastPlayed`,
- `a78`.`globalfiles`.`dateAdded` AS `dateAdded`
- FROM `a78`.`globalfiles`;
- CREATE TABLE `d78`.`bookmark` (
- `idBookmark` int(11) NOT NULL AUTO_INCREMENT,
- `idFile` int(11) DEFAULT NULL,
- `timeInSeconds` double DEFAULT NULL,
- `totalTimeInSeconds` double DEFAULT NULL,
- `thumbNailImage` text,
- `player` text,
- `playerState` text,
- `type` int(11) DEFAULT NULL,
- PRIMARY KEY (`idBookmark`),
- KEY `ix_bookmark` (`idFile`,`type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE VIEW `d78`.`episodeview`
- AS SELECT
- `episode`.`idEpisode` AS `idEpisode`,
- `episode`.`idFile` AS `idFile`,
- `episode`.`c00` AS `c00`,
- `episode`.`c01` AS `c01`,
- `episode`.`c02` AS `c02`,
- `episode`.`c03` AS `c03`,
- `episode`.`c04` AS `c04`,
- `episode`.`c05` AS `c05`,
- `episode`.`c06` AS `c06`,
- `episode`.`c07` AS `c07`,
- `episode`.`c08` AS `c08`,
- `episode`.`c09` AS `c09`,
- `episode`.`c10` AS `c10`,
- `episode`.`c11` AS `c11`,
- `episode`.`c12` AS `c12`,
- `episode`.`c13` AS `c13`,
- `episode`.`c14` AS `c14`,
- `episode`.`c15` AS `c15`,
- `episode`.`c16` AS `c16`,
- `episode`.`c17` AS `c17`,
- `episode`.`c18` AS `c18`,
- `episode`.`c19` AS `c19`,
- `episode`.`c20` AS `c20`,
- `episode`.`c21` AS `c21`,
- `episode`.`c22` AS `c22`,
- `episode`.`c23` AS `c23`,
- `episode`.`idShow` AS `idShow`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `tvshow`.`c00` AS `strTitle`,
- `tvshow`.`c14` AS `strStudio`,
- `tvshow`.`c05` AS `premiered`,
- `tvshow`.`c13` AS `mpaa`,
- `tvshow`.`c16` AS `strShowPath`,
- `d78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `d78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
- `seasons`.`idSeason` AS `idSeason`
- FROM (((((`d78`.`episode` join `d78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `d78`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `d78`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `d78`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `d78`.`bookmark` on(((`d78`.`bookmark`.`idFile` = `episode`.`idFile`) and (`d78`.`bookmark`.`type` = 1))));
- CREATE VIEW `d78`.`movieview`
- AS SELECT
- `movie`.`idMovie` AS `idMovie`,
- `movie`.`idFile` AS `idFile`,
- `movie`.`c00` AS `c00`,
- `movie`.`c01` AS `c01`,
- `movie`.`c02` AS `c02`,
- `movie`.`c03` AS `c03`,
- `movie`.`c04` AS `c04`,
- `movie`.`c05` AS `c05`,
- `movie`.`c06` AS `c06`,
- `movie`.`c07` AS `c07`,
- `movie`.`c08` AS `c08`,
- `movie`.`c09` AS `c09`,
- `movie`.`c10` AS `c10`,
- `movie`.`c11` AS `c11`,
- `movie`.`c12` AS `c12`,
- `movie`.`c13` AS `c13`,
- `movie`.`c14` AS `c14`,
- `movie`.`c15` AS `c15`,
- `movie`.`c16` AS `c16`,
- `movie`.`c17` AS `c17`,
- `movie`.`c18` AS `c18`,
- `movie`.`c19` AS `c19`,
- `movie`.`c20` AS `c20`,
- `movie`.`c21` AS `c21`,
- `movie`.`c22` AS `c22`,
- `movie`.`c23` AS `c23`,
- `movie`.`idSet` AS `idSet`,
- `sets`.`strSet` AS `strSet`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `d78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `d78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM ((((`d78`.`movie` left join `d78`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `d78`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `d78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `d78`.`bookmark` on(((`d78`.`bookmark`.`idFile` = `movie`.`idFile`) and (`d78`.`bookmark`.`type` = 1))));
- CREATE VIEW `d78`.`musicvideoview`
- AS SELECT
- `musicvideo`.`idMVideo` AS `idMVideo`,
- `musicvideo`.`idFile` AS `idFile`,
- `musicvideo`.`c00` AS `c00`,
- `musicvideo`.`c01` AS `c01`,
- `musicvideo`.`c02` AS `c02`,
- `musicvideo`.`c03` AS `c03`,
- `musicvideo`.`c04` AS `c04`,
- `musicvideo`.`c05` AS `c05`,
- `musicvideo`.`c06` AS `c06`,
- `musicvideo`.`c07` AS `c07`,
- `musicvideo`.`c08` AS `c08`,
- `musicvideo`.`c09` AS `c09`,
- `musicvideo`.`c10` AS `c10`,
- `musicvideo`.`c11` AS `c11`,
- `musicvideo`.`c12` AS `c12`,
- `musicvideo`.`c13` AS `c13`,
- `musicvideo`.`c14` AS `c14`,
- `musicvideo`.`c15` AS `c15`,
- `musicvideo`.`c16` AS `c16`,
- `musicvideo`.`c17` AS `c17`,
- `musicvideo`.`c18` AS `c18`,
- `musicvideo`.`c19` AS `c19`,
- `musicvideo`.`c20` AS `c20`,
- `musicvideo`.`c21` AS `c21`,
- `musicvideo`.`c22` AS `c22`,
- `musicvideo`.`c23` AS `c23`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `d78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `d78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM (((`d78`.`musicvideo` join `d78`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `d78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `d78`.`bookmark` on(((`d78`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`d78`.`bookmark`.`type` = 1))));
- CREATE VIEW `d78`.`tvshowview`
- AS SELECT
- `tvshow`.`idShow` AS `idShow`,
- `tvshow`.`c00` AS `c00`,
- `tvshow`.`c01` AS `c01`,
- `tvshow`.`c02` AS `c02`,
- `tvshow`.`c03` AS `c03`,
- `tvshow`.`c04` AS `c04`,
- `tvshow`.`c05` AS `c05`,
- `tvshow`.`c06` AS `c06`,
- `tvshow`.`c07` AS `c07`,
- `tvshow`.`c08` AS `c08`,
- `tvshow`.`c09` AS `c09`,
- `tvshow`.`c10` AS `c10`,
- `tvshow`.`c11` AS `c11`,
- `tvshow`.`c12` AS `c12`,
- `tvshow`.`c13` AS `c13`,
- `tvshow`.`c14` AS `c14`,
- `tvshow`.`c15` AS `c15`,
- `tvshow`.`c16` AS `c16`,
- `tvshow`.`c17` AS `c17`,
- `tvshow`.`c18` AS `c18`,
- `tvshow`.`c19` AS `c19`,
- `tvshow`.`c20` AS `c20`,
- `tvshow`.`c21` AS `c21`,
- `tvshow`.`c22` AS `c22`,
- `tvshow`.`c23` AS `c23`,
- `path`.`strPath` AS `strPath`,
- `path`.`dateAdded` AS `dateAdded`,max(`files`.`lastPlayed`) AS `lastPlayed`,nullif(count(`episode`.`c12`),0) AS `totalCount`,count(`files`.`playCount`) AS `watchedcount`,nullif(count(distinct `episode`.`c12`),0) AS `totalSeasons`
- FROM ((((`d78`.`tvshow` left join `d78`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `d78`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) left join `d78`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `d78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;
- CREATE DATABASE e78;
- CREATE VIEW `e78`.`actorlinkepisode` AS SELECT * FROM `a78`.`actorlinkepisode`;
- CREATE VIEW `e78`.`actorlinkmovie` AS SELECT * FROM `a78`.`actorlinkmovie`;
- CREATE VIEW `e78`.`actorlinktvshow` AS SELECT * FROM `a78`.`actorlinktvshow`;
- CREATE VIEW `e78`.`actors` AS SELECT * FROM `a78`.`actors`;
- CREATE VIEW `e78`.`art` AS SELECT * FROM `a78`.`art`;
- CREATE VIEW `e78`.`artistlinkmusicvideo` AS SELECT * FROM `a78`.`artistlinkmusicvideo`;
- CREATE VIEW `e78`.`country` AS SELECT * FROM `a78`.`country`;
- CREATE VIEW `e78`.`countrylinkmovie` AS SELECT * FROM `a78`.`countrylinkmovie`;
- CREATE VIEW `e78`.`directorlinkepisode` AS SELECT * FROM `a78`.`directorlinkepisode`;
- CREATE VIEW `e78`.`directorlinkmovie` AS SELECT * FROM `a78`.`directorlinkmovie`;
- CREATE VIEW `e78`.`directorlinkmusicvideo` AS SELECT * FROM `a78`.`directorlinkmusicvideo`;
- CREATE VIEW `e78`.`directorlinktvshow` AS SELECT * FROM `a78`.`directorlinktvshow`;
- CREATE VIEW `e78`.`episode` AS SELECT * FROM `a78`.`episode`;
- CREATE VIEW `e78`.`genre` AS SELECT * FROM `a78`.`genre`;
- CREATE VIEW `e78`.`genrelinkmovie` AS SELECT * FROM `a78`.`genrelinkmovie`;
- CREATE VIEW `e78`.`genrelinkmusicvideo` AS SELECT * FROM `a78`.`genrelinkmusicvideo`;
- CREATE VIEW `e78`.`genrelinktvshow` AS SELECT * FROM `a78`.`genrelinktvshow`;
- CREATE VIEW `e78`.`movie` AS SELECT * FROM `a78`.`movie`;
- CREATE VIEW `e78`.`movielinktvshow` AS SELECT * FROM `a78`.`movielinktvshow`;
- CREATE VIEW `e78`.`musicvideo` AS SELECT * FROM `a78`.`musicvideo`;
- CREATE VIEW `e78`.`path` AS SELECT * FROM `a78`.`path`;
- CREATE VIEW `e78`.`seasons` AS SELECT * FROM `a78`.`seasons`;
- CREATE VIEW `e78`.`sets` AS SELECT * FROM `a78`.`sets`;
- CREATE VIEW `e78`.`settings` AS SELECT * FROM `a78`.`settings`;
- CREATE VIEW `e78`.`stacktimes` AS SELECT * FROM `a78`.`stacktimes`;
- CREATE VIEW `e78`.`streamdetails` AS SELECT * FROM `a78`.`streamdetails`;
- CREATE VIEW `e78`.`studio` AS SELECT * FROM `a78`.`studio`;
- CREATE VIEW `e78`.`studiolinkmovie` AS SELECT * FROM `a78`.`studiolinkmovie`;
- CREATE VIEW `e78`.`studiolinkmusicvideo` AS SELECT * FROM `a78`.`studiolinkmusicvideo`;
- CREATE VIEW `e78`.`studiolinktvshow` AS SELECT * FROM `a78`.`studiolinktvshow`;
- CREATE VIEW `e78`.`tag` AS SELECT * FROM `a78`.`tag`;
- CREATE VIEW `e78`.`taglinks` AS SELECT * FROM `a78`.`taglinks`;
- CREATE VIEW `e78`.`tvshow` AS SELECT * FROM `a78`.`tvshow`;
- CREATE VIEW `e78`.`tvshowlinkpath` AS SELECT * FROM `a78`.`tvshowlinkpath`;
- CREATE VIEW `e78`.`version` AS SELECT * FROM `a78`.`version`;
- CREATE VIEW `e78`.`writerlinkepisode` AS SELECT * FROM `a78`.`writerlinkepisode`;
- CREATE VIEW `e78`.`writerlinkmovie` AS SELECT * FROM `a78`.`writerlinkmovie`;
- CREATE VIEW `e78`.`files`
- AS SELECT
- `a78`.`globalfiles`.`idFile` AS `idFile`,
- `a78`.`globalfiles`.`idPath` AS `idPath`,
- `a78`.`globalfiles`.`strFilename` AS `strFilename`,
- `a78`.`globalfiles`.`playCount5` AS `playCount`,
- `a78`.`globalfiles`.`lastPlayed5` AS `lastPlayed`,
- `a78`.`globalfiles`.`dateAdded` AS `dateAdded`
- FROM `a78`.`globalfiles`;
- CREATE TABLE `e78`.`bookmark` (
- `idBookmark` int(11) NOT NULL AUTO_INCREMENT,
- `idFile` int(11) DEFAULT NULL,
- `timeInSeconds` double DEFAULT NULL,
- `totalTimeInSeconds` double DEFAULT NULL,
- `thumbNailImage` text,
- `player` text,
- `playerState` text,
- `type` int(11) DEFAULT NULL,
- PRIMARY KEY (`idBookmark`),
- KEY `ix_bookmark` (`idFile`,`type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE VIEW `e78`.`episodeview`
- AS SELECT
- `episode`.`idEpisode` AS `idEpisode`,
- `episode`.`idFile` AS `idFile`,
- `episode`.`c00` AS `c00`,
- `episode`.`c01` AS `c01`,
- `episode`.`c02` AS `c02`,
- `episode`.`c03` AS `c03`,
- `episode`.`c04` AS `c04`,
- `episode`.`c05` AS `c05`,
- `episode`.`c06` AS `c06`,
- `episode`.`c07` AS `c07`,
- `episode`.`c08` AS `c08`,
- `episode`.`c09` AS `c09`,
- `episode`.`c10` AS `c10`,
- `episode`.`c11` AS `c11`,
- `episode`.`c12` AS `c12`,
- `episode`.`c13` AS `c13`,
- `episode`.`c14` AS `c14`,
- `episode`.`c15` AS `c15`,
- `episode`.`c16` AS `c16`,
- `episode`.`c17` AS `c17`,
- `episode`.`c18` AS `c18`,
- `episode`.`c19` AS `c19`,
- `episode`.`c20` AS `c20`,
- `episode`.`c21` AS `c21`,
- `episode`.`c22` AS `c22`,
- `episode`.`c23` AS `c23`,
- `episode`.`idShow` AS `idShow`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `tvshow`.`c00` AS `strTitle`,
- `tvshow`.`c14` AS `strStudio`,
- `tvshow`.`c05` AS `premiered`,
- `tvshow`.`c13` AS `mpaa`,
- `tvshow`.`c16` AS `strShowPath`,
- `e78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `e78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
- `seasons`.`idSeason` AS `idSeason`
- FROM (((((`e78`.`episode` join `e78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `e78`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `e78`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `e78`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `e78`.`bookmark` on(((`e78`.`bookmark`.`idFile` = `episode`.`idFile`) and (`e78`.`bookmark`.`type` = 1))));
- CREATE VIEW `e78`.`movieview`
- AS SELECT
- `movie`.`idMovie` AS `idMovie`,
- `movie`.`idFile` AS `idFile`,
- `movie`.`c00` AS `c00`,
- `movie`.`c01` AS `c01`,
- `movie`.`c02` AS `c02`,
- `movie`.`c03` AS `c03`,
- `movie`.`c04` AS `c04`,
- `movie`.`c05` AS `c05`,
- `movie`.`c06` AS `c06`,
- `movie`.`c07` AS `c07`,
- `movie`.`c08` AS `c08`,
- `movie`.`c09` AS `c09`,
- `movie`.`c10` AS `c10`,
- `movie`.`c11` AS `c11`,
- `movie`.`c12` AS `c12`,
- `movie`.`c13` AS `c13`,
- `movie`.`c14` AS `c14`,
- `movie`.`c15` AS `c15`,
- `movie`.`c16` AS `c16`,
- `movie`.`c17` AS `c17`,
- `movie`.`c18` AS `c18`,
- `movie`.`c19` AS `c19`,
- `movie`.`c20` AS `c20`,
- `movie`.`c21` AS `c21`,
- `movie`.`c22` AS `c22`,
- `movie`.`c23` AS `c23`,
- `movie`.`idSet` AS `idSet`,
- `sets`.`strSet` AS `strSet`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `e78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `e78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM ((((`e78`.`movie` left join `e78`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `e78`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `e78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `e78`.`bookmark` on(((`e78`.`bookmark`.`idFile` = `movie`.`idFile`) and (`e78`.`bookmark`.`type` = 1))));
- CREATE VIEW `e78`.`musicvideoview`
- AS SELECT
- `musicvideo`.`idMVideo` AS `idMVideo`,
- `musicvideo`.`idFile` AS `idFile`,
- `musicvideo`.`c00` AS `c00`,
- `musicvideo`.`c01` AS `c01`,
- `musicvideo`.`c02` AS `c02`,
- `musicvideo`.`c03` AS `c03`,
- `musicvideo`.`c04` AS `c04`,
- `musicvideo`.`c05` AS `c05`,
- `musicvideo`.`c06` AS `c06`,
- `musicvideo`.`c07` AS `c07`,
- `musicvideo`.`c08` AS `c08`,
- `musicvideo`.`c09` AS `c09`,
- `musicvideo`.`c10` AS `c10`,
- `musicvideo`.`c11` AS `c11`,
- `musicvideo`.`c12` AS `c12`,
- `musicvideo`.`c13` AS `c13`,
- `musicvideo`.`c14` AS `c14`,
- `musicvideo`.`c15` AS `c15`,
- `musicvideo`.`c16` AS `c16`,
- `musicvideo`.`c17` AS `c17`,
- `musicvideo`.`c18` AS `c18`,
- `musicvideo`.`c19` AS `c19`,
- `musicvideo`.`c20` AS `c20`,
- `musicvideo`.`c21` AS `c21`,
- `musicvideo`.`c22` AS `c22`,
- `musicvideo`.`c23` AS `c23`,
- `files`.`strFilename` AS `strFileName`,
- `path`.`strPath` AS `strPath`,
- `files`.`playCount` AS `playCount`,
- `files`.`lastPlayed` AS `lastPlayed`,
- `files`.`dateAdded` AS `dateAdded`,
- `e78`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
- `e78`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
- FROM (((`e78`.`musicvideo` join `e78`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `e78`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `e78`.`bookmark` on(((`e78`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`e78`.`bookmark`.`type` = 1))));
- CREATE VIEW `e78`.`tvshowview`
- AS SELECT
- `tvshow`.`idShow` AS `idShow`,
- `tvshow`.`c00` AS `c00`,
- `tvshow`.`c01` AS `c01`,
- `tvshow`.`c02` AS `c02`,
- `tvshow`.`c03` AS `c03`,
- `tvshow`.`c04` AS `c04`,
- `tvshow`.`c05` AS `c05`,
- `tvshow`.`c06` AS `c06`,
- `tvshow`.`c07` AS `c07`,
- `tvshow`.`c08` AS `c08`,
- `tvshow`.`c09` AS `c09`,
- `tvshow`.`c10` AS `c10`,
- `tvshow`.`c11` AS `c11`,
- `tvshow`.`c12` AS `c12`,
- `tvshow`.`c13` AS `c13`,
- `tvshow`.`c14` AS `c14`,
- `tvshow`.`c15` AS `c15`,
- `tvshow`.`c16` AS `c16`,
- `tvshow`.`c17` AS `c17`,
- `tvshow`.`c18` AS `c18`,
- `tvshow`.`c19` AS `c19`,
- `tvshow`.`c20` AS `c20`,
- `tvshow`.`c21` AS `c21`,
- `tvshow`.`c22` AS `c22`,
- `tvshow`.`c23` AS `c23`,
- `path`.`strPath` AS `strPath`,
- `path`.`dateAdded` AS `dateAdded`,max(`files`.`lastPlayed`) AS `lastPlayed`,nullif(count(`episode`.`c12`),0) AS `totalCount`,count(`files`.`playCount`) AS `watchedcount`,nullif(count(distinct `episode`.`c12`),0) AS `totalSeasons`
- FROM ((((`e78`.`tvshow` left join `e78`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `e78`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) left join `e78`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `e78`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;
- RENAME TABLE `a46`.`song` to `a46`.`globalsong`;
- ALTER TABLE `a46`.`globalsong` CHANGE iTimesPlayed iTimesPlayed1 INT;
- ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed2 INT(11) AFTER iTimesPlayed1;
- ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed3 INT(11) AFTER iTimesPlayed2;
- ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed4 INT(11) AFTER iTimesPlayed3;
- ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed5 INT(11) AFTER iTimesPlayed4;
- ALTER TABLE `a46`.`globalsong` CHANGE lastPlayed lastPlayed1 VARCHAR(20);
- ALTER TABLE `a46`.`globalsong` ADD lastPlayed2 VARCHAR(20) AFTER lastPlayed1;
- ALTER TABLE `a46`.`globalsong` ADD lastPlayed3 VARCHAR(20) AFTER lastPlayed2;
- ALTER TABLE `a46`.`globalsong` ADD lastPlayed4 VARCHAR(20) AFTER lastPlayed3;
- ALTER TABLE `a46`.`globalsong` ADD lastPlayed5 VARCHAR(20) AFTER lastPlayed4;
- CREATE VIEW `a46`.`song`
- AS SELECT
- `a46`.`globalsong`.`idSong` AS `idSong`,
- `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
- `a46`.`globalsong`.`idPath` AS `idPath`,
- `a46`.`globalsong`.`strArtists` AS `strArtists`,
- `a46`.`globalsong`.`strGenres` AS `strGenres`,
- `a46`.`globalsong`.`strTitle` AS `strTitle`,
- `a46`.`globalsong`.`iTrack` AS `iTrack`,
- `a46`.`globalsong`.`iDuration` AS `iDuration`,
- `a46`.`globalsong`.`iYear` AS `iYear`,
- `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `a46`.`globalsong`.`strFileName` AS `strFileName`,
- `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `a46`.`globalsong`.`iTimesPlayed1` AS `iTimesPlayed`,
- `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
- `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
- `a46`.`globalsong`.`idThumb` AS `idThumb`,
- `a46`.`globalsong`.`lastplayed1` AS `lastplayed`,
- `a46`.`globalsong`.`comment` AS `comment`,
- `a46`.`globalsong`.`rating` AS `rating`
- FROM `a46`.`globalsong`;
- CREATE DATABASE b46;
- CREATE VIEW `b46`.`album` AS SELECT * FROM `a46`.`album`;
- CREATE VIEW `b46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
- CREATE VIEW `b46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
- CREATE VIEW `b46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
- CREATE VIEW `b46`.`art` AS SELECT * FROM `a46`.`art`;
- CREATE VIEW `b46`.`artist` AS SELECT * FROM `a46`.`artist`;
- CREATE VIEW `b46`.`content` AS SELECT * FROM `a46`.`content`;
- CREATE VIEW `b46`.`discography` AS SELECT * FROM `a46`.`discography`;
- CREATE VIEW `b46`.`genre` AS SELECT * FROM `a46`.`genre`;
- CREATE VIEW `b46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
- CREATE VIEW `b46`.`path` AS SELECT * FROM `a46`.`path`;
- CREATE VIEW `b46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
- CREATE VIEW `b46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
- CREATE VIEW `b46`.`version` AS SELECT * FROM `a46`.`version`;
- CREATE VIEW `b46`.`song`
- AS SELECT
- `a46`.`globalsong`.`idSong` AS `idSong`,
- `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
- `a46`.`globalsong`.`idPath` AS `idPath`,
- `a46`.`globalsong`.`strArtists` AS `strArtists`,
- `a46`.`globalsong`.`strGenres` AS `strGenres`,
- `a46`.`globalsong`.`strTitle` AS `strTitle`,
- `a46`.`globalsong`.`iTrack` AS `iTrack`,
- `a46`.`globalsong`.`iDuration` AS `iDuration`,
- `a46`.`globalsong`.`iYear` AS `iYear`,
- `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `a46`.`globalsong`.`strFileName` AS `strFileName`,
- `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `a46`.`globalsong`.`iTimesPlayed2` AS `iTimesPlayed`,
- `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
- `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
- `a46`.`globalsong`.`idThumb` AS `idThumb`,
- `a46`.`globalsong`.`lastplayed2` AS `lastplayed`,
- `a46`.`globalsong`.`comment` AS `comment`,
- `a46`.`globalsong`.`rating` AS `rating`
- FROM `a46`.`globalsong`;
- CREATE VIEW `b46`.`albumartistview`
- AS SELECT
- `album_artist`.`idAlbum` AS `idAlbum`,
- `album_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `album_artist`.`boolFeatured` AS `boolFeatured`,
- `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `album_artist`.`iOrder` AS `iOrder`
- FROM (`b46`.`album_artist` join `b46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `b46`.`albumview`
- AS SELECT
- `album`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
- `album`.`strArtists` AS `strArtists`,
- `album`.`strGenres` AS `strGenres`,
- `album`.`iYear` AS `iYear`,
- `album`.`strMoods` AS `strMoods`,
- `album`.`strStyles` AS `strStyles`,
- `album`.`strThemes` AS `strThemes`,
- `album`.`strReview` AS `strReview`,
- `album`.`strLabel` AS `strLabel`,
- `album`.`strType` AS `strType`,
- `album`.`strImage` AS `strImage`,
- `album`.`iRating` AS `iRating`,
- `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
- FROM (`b46`.`album` left join `b46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;
- CREATE VIEW `b46`.`artistview`
- AS SELECT
- `artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `artist`.`strBorn` AS `strBorn`,
- `artist`.`strFormed` AS `strFormed`,
- `artist`.`strGenres` AS `strGenres`,
- `artist`.`strMoods` AS `strMoods`,
- `artist`.`strStyles` AS `strStyles`,
- `artist`.`strInstruments` AS `strInstruments`,
- `artist`.`strBiography` AS `strBiography`,
- `artist`.`strDied` AS `strDied`,
- `artist`.`strDisbanded` AS `strDisbanded`,
- `artist`.`strYearsActive` AS `strYearsActive`,
- `artist`.`strImage` AS `strImage`,
- `artist`.`strFanart` AS `strFanart`
- FROM `b46`.`artist`;
- CREATE VIEW `b46`.`songartistview`
- AS SELECT
- `song_artist`.`idSong` AS `idSong`,
- `song_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `song_artist`.`boolFeatured` AS `boolFeatured`,
- `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `song_artist`.`iOrder` AS `iOrder`
- FROM (`b46`.`song_artist` join `b46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `b46`.`songview`
- AS SELECT
- `song`.`idSong` AS `idSong`,
- `song`.`strArtists` AS `strArtists`,
- `song`.`strGenres` AS `strGenres`,
- `song`.`strTitle` AS `strTitle`,
- `song`.`iTrack` AS `iTrack`,
- `song`.`iDuration` AS `iDuration`,
- `song`.`iYear` AS `iYear`,
- `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `song`.`strFileName` AS `strFileName`,
- `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `song`.`iTimesPlayed` AS `iTimesPlayed`,
- `song`.`iStartOffset` AS `iStartOffset`,
- `song`.`iEndOffset` AS `iEndOffset`,
- `song`.`lastplayed` AS `lastplayed`,
- `song`.`rating` AS `rating`,
- `song`.`comment` AS `comment`,
- `song`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `path`.`strPath` AS `strPath`,
- `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
- `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
- `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
- `album`.`bCompilation` AS `bCompilation`,
- `album`.`strArtists` AS `strAlbumArtists`
- FROM (((`b46`.`song` join `b46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `b46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `b46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));
- CREATE DATABASE c46;
- CREATE VIEW `c46`.`album` AS SELECT * FROM `a46`.`album`;
- CREATE VIEW `c46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
- CREATE VIEW `c46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
- CREATE VIEW `c46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
- CREATE VIEW `c46`.`art` AS SELECT * FROM `a46`.`art`;
- CREATE VIEW `c46`.`artist` AS SELECT * FROM `a46`.`artist`;
- CREATE VIEW `c46`.`content` AS SELECT * FROM `a46`.`content`;
- CREATE VIEW `c46`.`discography` AS SELECT * FROM `a46`.`discography`;
- CREATE VIEW `c46`.`genre` AS SELECT * FROM `a46`.`genre`;
- CREATE VIEW `c46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
- CREATE VIEW `c46`.`path` AS SELECT * FROM `a46`.`path`;
- CREATE VIEW `c46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
- CREATE VIEW `c46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
- CREATE VIEW `c46`.`version` AS SELECT * FROM `a46`.`version`;
- CREATE VIEW `c46`.`song`
- AS SELECT
- `a46`.`globalsong`.`idSong` AS `idSong`,
- `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
- `a46`.`globalsong`.`idPath` AS `idPath`,
- `a46`.`globalsong`.`strArtists` AS `strArtists`,
- `a46`.`globalsong`.`strGenres` AS `strGenres`,
- `a46`.`globalsong`.`strTitle` AS `strTitle`,
- `a46`.`globalsong`.`iTrack` AS `iTrack`,
- `a46`.`globalsong`.`iDuration` AS `iDuration`,
- `a46`.`globalsong`.`iYear` AS `iYear`,
- `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `a46`.`globalsong`.`strFileName` AS `strFileName`,
- `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `a46`.`globalsong`.`iTimesPlayed3` AS `iTimesPlayed`,
- `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
- `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
- `a46`.`globalsong`.`idThumb` AS `idThumb`,
- `a46`.`globalsong`.`lastplayed3` AS `lastplayed`,
- `a46`.`globalsong`.`comment` AS `comment`,
- `a46`.`globalsong`.`rating` AS `rating`
- FROM `a46`.`globalsong`;
- CREATE VIEW `c46`.`albumartistview`
- AS SELECT
- `album_artist`.`idAlbum` AS `idAlbum`,
- `album_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `album_artist`.`boolFeatured` AS `boolFeatured`,
- `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `album_artist`.`iOrder` AS `iOrder`
- FROM (`c46`.`album_artist` join `c46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `c46`.`albumview`
- AS SELECT
- `album`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
- `album`.`strArtists` AS `strArtists`,
- `album`.`strGenres` AS `strGenres`,
- `album`.`iYear` AS `iYear`,
- `album`.`strMoods` AS `strMoods`,
- `album`.`strStyles` AS `strStyles`,
- `album`.`strThemes` AS `strThemes`,
- `album`.`strReview` AS `strReview`,
- `album`.`strLabel` AS `strLabel`,
- `album`.`strType` AS `strType`,
- `album`.`strImage` AS `strImage`,
- `album`.`iRating` AS `iRating`,
- `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
- FROM (`c46`.`album` left join `c46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;
- CREATE VIEW `c46`.`artistview`
- AS SELECT
- `artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `artist`.`strBorn` AS `strBorn`,
- `artist`.`strFormed` AS `strFormed`,
- `artist`.`strGenres` AS `strGenres`,
- `artist`.`strMoods` AS `strMoods`,
- `artist`.`strStyles` AS `strStyles`,
- `artist`.`strInstruments` AS `strInstruments`,
- `artist`.`strBiography` AS `strBiography`,
- `artist`.`strDied` AS `strDied`,
- `artist`.`strDisbanded` AS `strDisbanded`,
- `artist`.`strYearsActive` AS `strYearsActive`,
- `artist`.`strImage` AS `strImage`,
- `artist`.`strFanart` AS `strFanart`
- FROM `c46`.`artist`;
- CREATE VIEW `c46`.`songartistview`
- AS SELECT
- `song_artist`.`idSong` AS `idSong`,
- `song_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `song_artist`.`boolFeatured` AS `boolFeatured`,
- `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `song_artist`.`iOrder` AS `iOrder`
- FROM (`c46`.`song_artist` join `c46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `c46`.`songview`
- AS SELECT
- `song`.`idSong` AS `idSong`,
- `song`.`strArtists` AS `strArtists`,
- `song`.`strGenres` AS `strGenres`,
- `song`.`strTitle` AS `strTitle`,
- `song`.`iTrack` AS `iTrack`,
- `song`.`iDuration` AS `iDuration`,
- `song`.`iYear` AS `iYear`,
- `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `song`.`strFileName` AS `strFileName`,
- `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `song`.`iTimesPlayed` AS `iTimesPlayed`,
- `song`.`iStartOffset` AS `iStartOffset`,
- `song`.`iEndOffset` AS `iEndOffset`,
- `song`.`lastplayed` AS `lastplayed`,
- `song`.`rating` AS `rating`,
- `song`.`comment` AS `comment`,
- `song`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `path`.`strPath` AS `strPath`,
- `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
- `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
- `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
- `album`.`bCompilation` AS `bCompilation`,
- `album`.`strArtists` AS `strAlbumArtists`
- FROM (((`c46`.`song` join `c46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `c46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `c46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));
- CREATE DATABASE d46;
- CREATE VIEW `d46`.`album` AS SELECT * FROM `a46`.`album`;
- CREATE VIEW `d46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
- CREATE VIEW `d46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
- CREATE VIEW `d46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
- CREATE VIEW `d46`.`art` AS SELECT * FROM `a46`.`art`;
- CREATE VIEW `d46`.`artist` AS SELECT * FROM `a46`.`artist`;
- CREATE VIEW `d46`.`content` AS SELECT * FROM `a46`.`content`;
- CREATE VIEW `d46`.`discography` AS SELECT * FROM `a46`.`discography`;
- CREATE VIEW `d46`.`genre` AS SELECT * FROM `a46`.`genre`;
- CREATE VIEW `d46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
- CREATE VIEW `d46`.`path` AS SELECT * FROM `a46`.`path`;
- CREATE VIEW `d46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
- CREATE VIEW `d46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
- CREATE VIEW `d46`.`version` AS SELECT * FROM `a46`.`version`;
- CREATE VIEW `d46`.`song`
- AS SELECT
- `a46`.`globalsong`.`idSong` AS `idSong`,
- `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
- `a46`.`globalsong`.`idPath` AS `idPath`,
- `a46`.`globalsong`.`strArtists` AS `strArtists`,
- `a46`.`globalsong`.`strGenres` AS `strGenres`,
- `a46`.`globalsong`.`strTitle` AS `strTitle`,
- `a46`.`globalsong`.`iTrack` AS `iTrack`,
- `a46`.`globalsong`.`iDuration` AS `iDuration`,
- `a46`.`globalsong`.`iYear` AS `iYear`,
- `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `a46`.`globalsong`.`strFileName` AS `strFileName`,
- `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `a46`.`globalsong`.`iTimesPlayed4` AS `iTimesPlayed`,
- `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
- `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
- `a46`.`globalsong`.`idThumb` AS `idThumb`,
- `a46`.`globalsong`.`lastplayed4` AS `lastplayed`,
- `a46`.`globalsong`.`comment` AS `comment`,
- `a46`.`globalsong`.`rating` AS `rating`
- FROM `a46`.`globalsong`;
- CREATE VIEW `d46`.`albumartistview`
- AS SELECT
- `album_artist`.`idAlbum` AS `idAlbum`,
- `album_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `album_artist`.`boolFeatured` AS `boolFeatured`,
- `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `album_artist`.`iOrder` AS `iOrder`
- FROM (`d46`.`album_artist` join `d46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `d46`.`albumview`
- AS SELECT
- `album`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
- `album`.`strArtists` AS `strArtists`,
- `album`.`strGenres` AS `strGenres`,
- `album`.`iYear` AS `iYear`,
- `album`.`strMoods` AS `strMoods`,
- `album`.`strStyles` AS `strStyles`,
- `album`.`strThemes` AS `strThemes`,
- `album`.`strReview` AS `strReview`,
- `album`.`strLabel` AS `strLabel`,
- `album`.`strType` AS `strType`,
- `album`.`strImage` AS `strImage`,
- `album`.`iRating` AS `iRating`,
- `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
- FROM (`d46`.`album` left join `d46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;
- CREATE VIEW `d46`.`artistview`
- AS SELECT
- `artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `artist`.`strBorn` AS `strBorn`,
- `artist`.`strFormed` AS `strFormed`,
- `artist`.`strGenres` AS `strGenres`,
- `artist`.`strMoods` AS `strMoods`,
- `artist`.`strStyles` AS `strStyles`,
- `artist`.`strInstruments` AS `strInstruments`,
- `artist`.`strBiography` AS `strBiography`,
- `artist`.`strDied` AS `strDied`,
- `artist`.`strDisbanded` AS `strDisbanded`,
- `artist`.`strYearsActive` AS `strYearsActive`,
- `artist`.`strImage` AS `strImage`,
- `artist`.`strFanart` AS `strFanart`
- FROM `d46`.`artist`;
- CREATE VIEW `d46`.`songartistview`
- AS SELECT
- `song_artist`.`idSong` AS `idSong`,
- `song_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `song_artist`.`boolFeatured` AS `boolFeatured`,
- `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `song_artist`.`iOrder` AS `iOrder`
- FROM (`d46`.`song_artist` join `d46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `d46`.`songview`
- AS SELECT
- `song`.`idSong` AS `idSong`,
- `song`.`strArtists` AS `strArtists`,
- `song`.`strGenres` AS `strGenres`,
- `song`.`strTitle` AS `strTitle`,
- `song`.`iTrack` AS `iTrack`,
- `song`.`iDuration` AS `iDuration`,
- `song`.`iYear` AS `iYear`,
- `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `song`.`strFileName` AS `strFileName`,
- `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `song`.`iTimesPlayed` AS `iTimesPlayed`,
- `song`.`iStartOffset` AS `iStartOffset`,
- `song`.`iEndOffset` AS `iEndOffset`,
- `song`.`lastplayed` AS `lastplayed`,
- `song`.`rating` AS `rating`,
- `song`.`comment` AS `comment`,
- `song`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `path`.`strPath` AS `strPath`,
- `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
- `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
- `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
- `album`.`bCompilation` AS `bCompilation`,
- `album`.`strArtists` AS `strAlbumArtists`
- FROM (((`d46`.`song` join `d46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `d46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `d46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));
- CREATE DATABASE e46;
- CREATE VIEW `e46`.`album` AS SELECT * FROM `a46`.`album`;
- CREATE VIEW `e46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
- CREATE VIEW `e46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
- CREATE VIEW `e46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
- CREATE VIEW `e46`.`art` AS SELECT * FROM `a46`.`art`;
- CREATE VIEW `e46`.`artist` AS SELECT * FROM `a46`.`artist`;
- CREATE VIEW `e46`.`content` AS SELECT * FROM `a46`.`content`;
- CREATE VIEW `e46`.`discography` AS SELECT * FROM `a46`.`discography`;
- CREATE VIEW `e46`.`genre` AS SELECT * FROM `a46`.`genre`;
- CREATE VIEW `e46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
- CREATE VIEW `e46`.`path` AS SELECT * FROM `a46`.`path`;
- CREATE VIEW `e46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
- CREATE VIEW `e46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
- CREATE VIEW `e46`.`version` AS SELECT * FROM `a46`.`version`;
- CREATE VIEW `e46`.`song`
- AS SELECT
- `a46`.`globalsong`.`idSong` AS `idSong`,
- `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
- `a46`.`globalsong`.`idPath` AS `idPath`,
- `a46`.`globalsong`.`strArtists` AS `strArtists`,
- `a46`.`globalsong`.`strGenres` AS `strGenres`,
- `a46`.`globalsong`.`strTitle` AS `strTitle`,
- `a46`.`globalsong`.`iTrack` AS `iTrack`,
- `a46`.`globalsong`.`iDuration` AS `iDuration`,
- `a46`.`globalsong`.`iYear` AS `iYear`,
- `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `a46`.`globalsong`.`strFileName` AS `strFileName`,
- `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `a46`.`globalsong`.`iTimesPlayed5` AS `iTimesPlayed`,
- `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
- `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
- `a46`.`globalsong`.`idThumb` AS `idThumb`,
- `a46`.`globalsong`.`lastplayed5` AS `lastplayed`,
- `a46`.`globalsong`.`comment` AS `comment`,
- `a46`.`globalsong`.`rating` AS `rating`
- FROM `a46`.`globalsong`;
- CREATE VIEW `e46`.`albumartistview`
- AS SELECT
- `album_artist`.`idAlbum` AS `idAlbum`,
- `album_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `album_artist`.`boolFeatured` AS `boolFeatured`,
- `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `album_artist`.`iOrder` AS `iOrder`
- FROM (`e46`.`album_artist` join `e46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `e46`.`albumview`
- AS SELECT
- `album`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
- `album`.`strArtists` AS `strArtists`,
- `album`.`strGenres` AS `strGenres`,
- `album`.`iYear` AS `iYear`,
- `album`.`strMoods` AS `strMoods`,
- `album`.`strStyles` AS `strStyles`,
- `album`.`strThemes` AS `strThemes`,
- `album`.`strReview` AS `strReview`,
- `album`.`strLabel` AS `strLabel`,
- `album`.`strType` AS `strType`,
- `album`.`strImage` AS `strImage`,
- `album`.`iRating` AS `iRating`,
- `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
- FROM (`e46`.`album` left join `e46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;
- CREATE VIEW `e46`.`artistview`
- AS SELECT
- `artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `artist`.`strBorn` AS `strBorn`,
- `artist`.`strFormed` AS `strFormed`,
- `artist`.`strGenres` AS `strGenres`,
- `artist`.`strMoods` AS `strMoods`,
- `artist`.`strStyles` AS `strStyles`,
- `artist`.`strInstruments` AS `strInstruments`,
- `artist`.`strBiography` AS `strBiography`,
- `artist`.`strDied` AS `strDied`,
- `artist`.`strDisbanded` AS `strDisbanded`,
- `artist`.`strYearsActive` AS `strYearsActive`,
- `artist`.`strImage` AS `strImage`,
- `artist`.`strFanart` AS `strFanart`
- FROM `e46`.`artist`;
- CREATE VIEW `e46`.`songartistview`
- AS SELECT
- `song_artist`.`idSong` AS `idSong`,
- `song_artist`.`idArtist` AS `idArtist`,
- `artist`.`strArtist` AS `strArtist`,
- `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
- `song_artist`.`boolFeatured` AS `boolFeatured`,
- `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
- `song_artist`.`iOrder` AS `iOrder`
- FROM (`e46`.`song_artist` join `e46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));
- CREATE VIEW `e46`.`songview`
- AS SELECT
- `song`.`idSong` AS `idSong`,
- `song`.`strArtists` AS `strArtists`,
- `song`.`strGenres` AS `strGenres`,
- `song`.`strTitle` AS `strTitle`,
- `song`.`iTrack` AS `iTrack`,
- `song`.`iDuration` AS `iDuration`,
- `song`.`iYear` AS `iYear`,
- `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `song`.`strFileName` AS `strFileName`,
- `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `song`.`iTimesPlayed` AS `iTimesPlayed`,
- `song`.`iStartOffset` AS `iStartOffset`,
- `song`.`iEndOffset` AS `iEndOffset`,
- `song`.`lastplayed` AS `lastplayed`,
- `song`.`rating` AS `rating`,
- `song`.`comment` AS `comment`,
- `song`.`idAlbum` AS `idAlbum`,
- `album`.`strAlbum` AS `strAlbum`,
- `path`.`strPath` AS `strPath`,
- `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
- `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
- `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
- `album`.`bCompilation` AS `bCompilation`,
- `album`.`strArtists` AS `strAlbumArtists`
- FROM (((`e46`.`song` join `e46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `e46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `e46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement