[MYSQL] HOW-TO: 5 User XBMC
(2015-08-02, 16:59)BigMong Wrote: I have done a little look into this over the last few hours and here is what I have.

@masterxilef That would be good but but there is some bigger changes in the Video DB tables in v90 was 45 now in v93 it's 34 and lots of changes with table names Sad

Please Note: I have only done very limited testing
Please let me know if something isn't working right,
as my testing was like 5 mins.

I had some slows but that was my SQL not my collection of 31,547 episodes (561 shows) collected 2,019 movies collected

- Start Kodi 15 on your master system, once loaded exit/shutdown that system, this is so the data is updated or the default tables are created.
- Now in your SQL editor like PHPMyAdmin you must run some SQL.

- My DB Names;
Kodi_Matt_Video_ <- Master User
Kodi_Mace_Video_
Kodi_Kiyana_Video_
Kodi_Jaide_Video_

I name mine like this so its easier to find the correct DB when doing other backend scripts and I have a bit going on with my SQL server.
Names will be based on the above but a simple find and replace can change the names to what you like.
[Find: Kodi_Matt_Video_ Replace With: a] from memory that's what this guide was using.

USER 01 is Master User
If you need more then 3 slaves, Copy the code from USER 02 or higher, then add them to the `globalfiles` table, this should be easy to understand

Known Bugs;
- When removing file from the DB it won't be cleaned from Slave Users bookmarks.
- Will error if View or Table exists (Work around, drop the table or view not on the master tho Smile or just skip that SQL cmd)

**** This SQL is for Video93 DB ONLY ****

GlobalFiles and Triggers
Code:
/* *****************
*** GlobalFiles ****
*******************/
  /* ONLY ON FRESH INSTALL */
    RENAME TABLE `Kodi_Matt_Video_93`.`files` to `Kodi_Matt_Video_93`.`globalfiles`;

  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` CHANGE playCount playCountMatt INT;
  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` CHANGE lastPlayed lastPlayedMatt TEXT;
  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` ADD playCountMace INT(11) AFTER lastPlayedMatt;
  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` ADD lastPlayedMace TEXT AFTER playCountMace;
  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` ADD playCountKiyana INT(11) AFTER lastPlayedMace;
  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` ADD lastPlayedKiyana TEXT AFTER playCountKiyana;
  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` ADD playCountJaide INT(11) AFTER lastPlayedKiyana;
  ALTER TABLE `Kodi_Matt_Video_93`.`globalfiles` ADD lastPlayedJaide TEXT AFTER playCountJaide;
  /* As you can see above its easy to add or remove users from the globalfiles. Just remember there is two lines for each user. */

  /* If doing an upgrade it can freeze if have been using SQL this will update the DB Version number to stop the auto upgrade. */
  UPDATE `Kodi_Matt_Video_93`.`version` SET `idVersion` = '93' WHERE `idVersion` = '90'

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_person`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_person` AFTER DELETE ON `actor`
    FOR EACH ROW BEGIN
      DELETE FROM art WHERE media_id=old.actor_id AND media_type IN ('actor','artist','writer','director');
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_episode`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_episode`
    AFTER DELETE ON `episode`
    FOR EACH ROW BEGIN
      DELETE FROM actor_link WHERE media_id=old.idEpisode AND media_type='episode';
      DELETE FROM director_link WHERE media_id=old.idEpisode AND media_type='episode';
      DELETE FROM writer_link WHERE media_id=old.idEpisode AND media_type='episode';
      DELETE FROM art WHERE media_id=old.idEpisode AND media_type='episode';
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_file`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_file`
    AFTER DELETE ON `globalfiles`
    FOR EACH ROW BEGIN
      DELETE FROM bookmark WHERE idFile=old.idFile;
      DELETE FROM settings WHERE idFile=old.idFile;
      DELETE FROM stacktimes WHERE idFile=old.idFile;
      DELETE FROM streamdetails WHERE idFile=old.idFile;
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_movie`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_movie`
    AFTER DELETE ON `movie`
    FOR EACH ROW BEGIN
      DELETE FROM genre_link WHERE media_id=old.idMovie AND media_type='movie';
      DELETE FROM actor_link WHERE media_id=old.idMovie AND media_type='movie';
      DELETE FROM director_link WHERE media_id=old.idMovie AND media_type='movie';
      DELETE FROM studio_link WHERE media_id=old.idMovie AND media_type='movie';
      DELETE FROM country_link WHERE media_id=old.idMovie AND media_type='movie';
      DELETE FROM writer_link WHERE media_id=old.idMovie AND media_type='movie';
      DELETE FROM movielinktvshow WHERE idMovie=old.idMovie;
      DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie';
      DELETE FROM tag_link WHERE media_id=old.idMovie AND media_type='movie';
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_musicvideo`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_musicvideo`
    AFTER DELETE ON `musicvideo`
    FOR EACH ROW BEGIN
      DELETE FROM actor_link WHERE media_id=old.idMVideo AND media_type='musicvideo';
      DELETE FROM director_link WHERE media_id=old.idMVideo AND media_type='musicvideo';
      DELETE FROM genre_link WHERE media_id=old.idMVideo AND media_type='musicvideo';
      DELETE FROM studio_link WHERE media_id=old.idMVideo AND media_type='musicvideo';
      DELETE FROM art WHERE media_id=old.idMVideo AND media_type='musicvideo';
      DELETE FROM tag_link WHERE media_id=old.idMVideo AND media_type='musicvideo';
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_season`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_season`
    AFTER DELETE ON `seasons`
    FOR EACH ROW BEGIN
      DELETE FROM art WHERE media_id=old.idSeason AND media_type='season';
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_set`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_set`
    AFTER DELETE ON `sets`
    FOR EACH ROW BEGIN
      DELETE FROM art WHERE media_id=old.idSet AND media_type='set';
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_tag`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_tag`
    AFTER DELETE ON `tag_link`
    FOR EACH ROW BEGIN
      DELETE FROM tag WHERE tag_id=old.tag_id AND tag_id NOT IN (SELECT DISTINCT tag_id FROM tag_link);
    END
  //
  DELIMITER ;

  DROP TRIGGER IF EXISTS `Kodi_Matt_Video_93`.`delete_tvshow`;
  DELIMITER //
  CREATE TRIGGER `Kodi_Matt_Video_93`.`delete_tvshow`
    AFTER DELETE ON `tvshow`
    FOR EACH ROW BEGIN
      DELETE FROM actor_link WHERE media_id=old.idShow AND media_type='tvshow';
      DELETE FROM director_link WHERE media_id=old.idShow AND media_type='tvshow';
      DELETE FROM studio_link WHERE media_id=old.idShow AND media_type='tvshow';
      DELETE FROM tvshowlinkpath WHERE idShow=old.idShow;
      DELETE FROM genre_link WHERE media_id=old.idShow AND media_type='tvshow';
      DELETE FROM movielinktvshow WHERE idShow=old.idShow;
      DELETE FROM seasons WHERE idShow=old.idShow;
      DELETE FROM art WHERE media_id=old.idShow AND media_type='tvshow';
      DELETE FROM tag_link WHERE media_id=old.idShow AND media_type='tvshow';
    END
  //
  DELIMITER ;

USER 01 - Master User
Code:
/* ************
*** USER 01 ***
**************/
  CREATE VIEW `Kodi_Matt_Video_93`.`files`
    AS SELECT
      `globalfiles`.`idFile` AS `idFile`,
      `globalfiles`.`idPath` AS `idPath`,
      `globalfiles`.`strFilename` AS `strFilename`,
      `globalfiles`.`playCountMatt` AS `playCount`,
      `globalfiles`.`lastPlayedMatt` AS `lastPlayed`,
      `globalfiles`.`dateAdded` AS `dateAdded`
    FROM `Kodi_Matt_Video_93`.`globalfiles`;

  CREATE VIEW `Kodi_Matt_Video_93`.`episode_view`
    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 `studio`,
      `tvshow`.`c05` AS `premiered`,
      `tvshow`.`c13` AS `mpaa`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
      `seasons`.`idSeason` AS `idSeason`
    FROM (((((`Kodi_Matt_Video_93`.`episode` join `Kodi_Matt_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `Kodi_Matt_Video_93`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `Kodi_Matt_Video_93`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `Kodi_Matt_Video_93`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `Kodi_Matt_Video_93`.`bookmark` on(((`Kodi_Matt_Video_93`.`bookmark`.`idFile` = `episode`.`idFile`) and (`Kodi_Matt_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Matt_Video_93`.`movie_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM ((((`Kodi_Matt_Video_93`.`movie` left join `Kodi_Matt_Video_93`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `Kodi_Matt_Video_93`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `Kodi_Matt_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Matt_Video_93`.`bookmark` on(((`Kodi_Matt_Video_93`.`bookmark`.`idFile` = `movie`.`idFile`) and (`Kodi_Matt_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Matt_Video_93`.`musicvideo_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM (((`Kodi_Matt_Video_93`.`musicvideo` join `Kodi_Matt_Video_93`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `Kodi_Matt_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Matt_Video_93`.`bookmark` on(((`Kodi_Matt_Video_93`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`Kodi_Matt_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Matt_Video_93`.`tvshowcounts`
    AS SELECT
      `tvshow`.`idShow` AS `idShow`,
      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`,
      max(`files`.`dateAdded`) AS `dateAdded`
    FROM ((`Kodi_Matt_Video_93`.`tvshow` left join `Kodi_Matt_Video_93`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Matt_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Matt_Video_93`.`tvshow_view`
    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`.`idParentPath` AS `idParentPath`,
      `path`.`strPath` AS `strPath`,
      `tvshowcounts`.`dateAdded` AS `dateAdded`,
      `tvshowcounts`.`lastPlayed` AS `lastPlayed`,
      `tvshowcounts`.`totalCount` AS `totalCount`,
      `tvshowcounts`.`watchedcount` AS `watchedcount`,
      `tvshowcounts`.`totalSeasons` AS `totalSeasons`
    FROM (((`Kodi_Matt_Video_93`.`tvshow` left join `Kodi_Matt_Video_93`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Matt_Video_93`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) join `Kodi_Matt_Video_93`.`tvshowcounts` on((`tvshow`.`idShow` = `tvshowcounts`.`idShow`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Matt_Video_93`.`season_view`
    AS SELECT
      `seasons`.`idSeason` AS `idSeason`,
      `seasons`.`idShow` AS `idShow`,
      `seasons`.`season` AS `season`,
      `tvshow_view`.`strPath` AS `strPath`,
      `tvshow_view`.`c00` AS `showTitle`,
      `tvshow_view`.`c01` AS `plot`,
      `tvshow_view`.`c05` AS `premiered`,
      `tvshow_view`.`c08` AS `genre`,
      `tvshow_view`.`c14` AS `studio`,
      `tvshow_view`.`c13` AS `mpaa`,
      count(distinct `episode_view`.`idEpisode`) AS `episodes`,
      count(`files`.`playCount`) AS `playCount`
    FROM (((`Kodi_Matt_Video_93`.`seasons` join `Kodi_Matt_Video_93`.`tvshow_view` on((`tvshow_view`.`idShow` = `seasons`.`idShow`))) join `Kodi_Matt_Video_93`.`episode_view` on(((`episode_view`.`idShow` = `seasons`.`idShow`) and (`episode_view`.`c12` = `seasons`.`season`)))) join `Kodi_Matt_Video_93`.`files` on((`files`.`idFile` = `episode_view`.`idFile`))) group by `seasons`.`idSeason`;

USER 02
Code:
/* ************
*** USER 02 ***
**************/
  CREATE DATABASE Kodi_Mace_Video_93;

  CREATE VIEW `Kodi_Mace_Video_93`.`actor` AS SELECT * FROM `Kodi_Matt_Video_93`.`actor`;
  CREATE VIEW `Kodi_Mace_Video_93`.`actor_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`actor_link`;
  CREATE VIEW `Kodi_Mace_Video_93`.`art` AS SELECT * FROM `Kodi_Matt_Video_93`.`art`;
  CREATE VIEW `Kodi_Mace_Video_93`.`country` AS SELECT * FROM `Kodi_Matt_Video_93`.`country`;
  CREATE VIEW `Kodi_Mace_Video_93`.`country_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`country_link`;
  CREATE VIEW `Kodi_Mace_Video_93`.`director_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`director_link`;
  CREATE VIEW `Kodi_Mace_Video_93`.`episode` AS SELECT * FROM `Kodi_Matt_Video_93`.`episode`;
  CREATE VIEW `Kodi_Mace_Video_93`.`genre` AS SELECT * FROM `Kodi_Matt_Video_93`.`genre`;
  CREATE VIEW `Kodi_Mace_Video_93`.`genre_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`genre_link`;
  CREATE VIEW `Kodi_Mace_Video_93`.`movie` AS SELECT * FROM `Kodi_Matt_Video_93`.`movie`;
  CREATE VIEW `Kodi_Mace_Video_93`.`movielinktvshow` AS SELECT * FROM `Kodi_Matt_Video_93`.`movielinktvshow`;
  CREATE VIEW `Kodi_Mace_Video_93`.`musicvideo` AS SELECT * FROM `Kodi_Matt_Video_93`.`musicvideo`;
  CREATE VIEW `Kodi_Mace_Video_93`.`path` AS SELECT * FROM `Kodi_Matt_Video_93`.`path`;
  CREATE VIEW `Kodi_Mace_Video_93`.`seasons` AS SELECT * FROM `Kodi_Matt_Video_93`.`seasons`;
  CREATE VIEW `Kodi_Mace_Video_93`.`sets` AS SELECT * FROM `Kodi_Matt_Video_93`.`sets`;
  CREATE VIEW `Kodi_Mace_Video_93`.`settings` AS SELECT * FROM `Kodi_Matt_Video_93`.`settings`;
  CREATE VIEW `Kodi_Mace_Video_93`.`stacktimes` AS SELECT * FROM `Kodi_Matt_Video_93`.`stacktimes`;
  CREATE VIEW `Kodi_Mace_Video_93`.`streamdetails` AS SELECT * FROM `Kodi_Matt_Video_93`.`streamdetails`;
  CREATE VIEW `Kodi_Mace_Video_93`.`studio` AS SELECT * FROM `Kodi_Matt_Video_93`.`studio`;
  CREATE VIEW `Kodi_Mace_Video_93`.`studio_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`studio_link`;
  CREATE VIEW `Kodi_Mace_Video_93`.`tag` AS SELECT * FROM `Kodi_Matt_Video_93`.`tag`;
  CREATE VIEW `Kodi_Mace_Video_93`.`tag_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`tag_link`;
  CREATE VIEW `Kodi_Mace_Video_93`.`tvshow` AS SELECT * FROM `Kodi_Matt_Video_93`.`tvshow`;
  CREATE VIEW `Kodi_Mace_Video_93`.`tvshowlinkpath` AS SELECT * FROM `Kodi_Matt_Video_93`.`tvshowlinkpath`;
  CREATE VIEW `Kodi_Mace_Video_93`.`version` AS SELECT * FROM `Kodi_Matt_Video_93`.`version`;
  CREATE VIEW `Kodi_Mace_Video_93`.`writer_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`writer_link`;

  CREATE VIEW `Kodi_Mace_Video_93`.`files`
    AS SELECT
      `globalfiles`.`idFile` AS `idFile`,
      `globalfiles`.`idPath` AS `idPath`,
      `globalfiles`.`strFilename` AS `strFilename`,
      `globalfiles`.`playCountJaide` AS `playCount`,
      `globalfiles`.`lastPlayedJaide` AS `lastPlayed`,
      `globalfiles`.`dateAdded` AS `dateAdded`
    FROM `Kodi_Matt_Video_93`.`globalfiles`;

  CREATE TABLE `Kodi_Mace_Video_93`.`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 `Kodi_Mace_Video_93`.`episode_view`
    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 `studio`,
      `tvshow`.`c05` AS `premiered`,
      `tvshow`.`c13` AS `mpaa`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
      `seasons`.`idSeason` AS `idSeason`
    FROM (((((`Kodi_Mace_Video_93`.`episode` join `Kodi_Mace_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `Kodi_Mace_Video_93`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `Kodi_Mace_Video_93`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `Kodi_Mace_Video_93`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `Kodi_Mace_Video_93`.`bookmark` on(((`Kodi_Mace_Video_93`.`bookmark`.`idFile` = `episode`.`idFile`) and (`Kodi_Mace_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Mace_Video_93`.`movie_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM ((((`Kodi_Mace_Video_93`.`movie` left join `Kodi_Mace_Video_93`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `Kodi_Mace_Video_93`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `Kodi_Mace_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Mace_Video_93`.`bookmark` on(((`Kodi_Mace_Video_93`.`bookmark`.`idFile` = `movie`.`idFile`) and (`Kodi_Mace_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Mace_Video_93`.`musicvideo_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM (((`Kodi_Mace_Video_93`.`musicvideo` join `Kodi_Mace_Video_93`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `Kodi_Mace_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Mace_Video_93`.`bookmark` on(((`Kodi_Mace_Video_93`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`Kodi_Mace_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Mace_Video_93`.`tvshowcounts`
    AS SELECT
      `tvshow`.`idShow` AS `idShow`,
      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`,
      max(`files`.`dateAdded`) AS `dateAdded`
    FROM ((`Kodi_Mace_Video_93`.`tvshow` left join `Kodi_Mace_Video_93`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Mace_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Mace_Video_93`.`tvshow_view`
    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`.`idParentPath` AS `idParentPath`,
      `path`.`strPath` AS `strPath`,
      `tvshowcounts`.`dateAdded` AS `dateAdded`,
      `tvshowcounts`.`lastPlayed` AS `lastPlayed`,
      `tvshowcounts`.`totalCount` AS `totalCount`,
      `tvshowcounts`.`watchedcount` AS `watchedcount`,
      `tvshowcounts`.`totalSeasons` AS `totalSeasons`
    FROM (((`Kodi_Mace_Video_93`.`tvshow` left join `Kodi_Mace_Video_93`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Mace_Video_93`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) join `Kodi_Mace_Video_93`.`tvshowcounts` on((`tvshow`.`idShow` = `tvshowcounts`.`idShow`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Mace_Video_93`.`season_view`
    AS SELECT
      `seasons`.`idSeason` AS `idSeason`,
      `seasons`.`idShow` AS `idShow`,
      `seasons`.`season` AS `season`,
      `tvshow_view`.`strPath` AS `strPath`,
      `tvshow_view`.`c00` AS `showTitle`,
      `tvshow_view`.`c01` AS `plot`,
      `tvshow_view`.`c05` AS `premiered`,
      `tvshow_view`.`c08` AS `genre`,
      `tvshow_view`.`c14` AS `studio`,
      `tvshow_view`.`c13` AS `mpaa`,
      count(distinct `episode_view`.`idEpisode`) AS `episodes`,
      count(`files`.`playCount`) AS `playCount`
    FROM (((`Kodi_Mace_Video_93`.`seasons` join `Kodi_Mace_Video_93`.`tvshow_view` on((`tvshow_view`.`idShow` = `seasons`.`idShow`))) join `Kodi_Mace_Video_93`.`episode_view` on(((`episode_view`.`idShow` = `seasons`.`idShow`) and (`episode_view`.`c12` = `seasons`.`season`)))) join `Kodi_Mace_Video_93`.`files` on((`files`.`idFile` = `episode_view`.`idFile`))) group by `seasons`.`idSeason`;

USER 03
Code:
/* ************
*** USER 03 ***
**************/
  CREATE DATABASE Kodi_Kiyana_Video_93;

  CREATE VIEW `Kodi_Kiyana_Video_93`.`actor` AS SELECT * FROM `Kodi_Matt_Video_93`.`actor`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`actor_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`actor_link`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`art` AS SELECT * FROM `Kodi_Matt_Video_93`.`art`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`country` AS SELECT * FROM `Kodi_Matt_Video_93`.`country`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`country_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`country_link`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`director_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`director_link`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`episode` AS SELECT * FROM `Kodi_Matt_Video_93`.`episode`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`genre` AS SELECT * FROM `Kodi_Matt_Video_93`.`genre`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`genre_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`genre_link`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`movie` AS SELECT * FROM `Kodi_Matt_Video_93`.`movie`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`movielinktvshow` AS SELECT * FROM `Kodi_Matt_Video_93`.`movielinktvshow`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`musicvideo` AS SELECT * FROM `Kodi_Matt_Video_93`.`musicvideo`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`path` AS SELECT * FROM `Kodi_Matt_Video_93`.`path`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`seasons` AS SELECT * FROM `Kodi_Matt_Video_93`.`seasons`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`sets` AS SELECT * FROM `Kodi_Matt_Video_93`.`sets`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`settings` AS SELECT * FROM `Kodi_Matt_Video_93`.`settings`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`stacktimes` AS SELECT * FROM `Kodi_Matt_Video_93`.`stacktimes`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`streamdetails` AS SELECT * FROM `Kodi_Matt_Video_93`.`streamdetails`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`studio` AS SELECT * FROM `Kodi_Matt_Video_93`.`studio`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`studio_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`studio_link`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`tag` AS SELECT * FROM `Kodi_Matt_Video_93`.`tag`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`tag_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`tag_link`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`tvshow` AS SELECT * FROM `Kodi_Matt_Video_93`.`tvshow`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`tvshowlinkpath` AS SELECT * FROM `Kodi_Matt_Video_93`.`tvshowlinkpath`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`version` AS SELECT * FROM `Kodi_Matt_Video_93`.`version`;
  CREATE VIEW `Kodi_Kiyana_Video_93`.`writer_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`writer_link`;

  CREATE VIEW `Kodi_Kiyana_Video_93`.`files`
    AS SELECT
      `globalfiles`.`idFile` AS `idFile`,
      `globalfiles`.`idPath` AS `idPath`,
      `globalfiles`.`strFilename` AS `strFilename`,
      `globalfiles`.`playCountJaide` AS `playCount`,
      `globalfiles`.`lastPlayedJaide` AS `lastPlayed`,
      `globalfiles`.`dateAdded` AS `dateAdded`
    FROM `Kodi_Matt_Video_93`.`globalfiles`;

  CREATE TABLE `Kodi_Kiyana_Video_93`.`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 `Kodi_Kiyana_Video_93`.`episode_view`
    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 `studio`,
      `tvshow`.`c05` AS `premiered`,
      `tvshow`.`c13` AS `mpaa`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
      `seasons`.`idSeason` AS `idSeason`
    FROM (((((`Kodi_Kiyana_Video_93`.`episode` join `Kodi_Kiyana_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `Kodi_Kiyana_Video_93`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `Kodi_Kiyana_Video_93`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `Kodi_Kiyana_Video_93`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `Kodi_Kiyana_Video_93`.`bookmark` on(((`Kodi_Kiyana_Video_93`.`bookmark`.`idFile` = `episode`.`idFile`) and (`Kodi_Kiyana_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Kiyana_Video_93`.`movie_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM ((((`Kodi_Kiyana_Video_93`.`movie` left join `Kodi_Kiyana_Video_93`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `Kodi_Kiyana_Video_93`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `Kodi_Kiyana_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Kiyana_Video_93`.`bookmark` on(((`Kodi_Kiyana_Video_93`.`bookmark`.`idFile` = `movie`.`idFile`) and (`Kodi_Kiyana_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Kiyana_Video_93`.`musicvideo_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM (((`Kodi_Kiyana_Video_93`.`musicvideo` join `Kodi_Kiyana_Video_93`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `Kodi_Kiyana_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Kiyana_Video_93`.`bookmark` on(((`Kodi_Kiyana_Video_93`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`Kodi_Kiyana_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Kiyana_Video_93`.`tvshowcounts`
    AS SELECT
      `tvshow`.`idShow` AS `idShow`,
      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`,
      max(`files`.`dateAdded`) AS `dateAdded`
    FROM ((`Kodi_Kiyana_Video_93`.`tvshow` left join `Kodi_Kiyana_Video_93`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Kiyana_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Kiyana_Video_93`.`tvshow_view`
    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`.`idParentPath` AS `idParentPath`,
      `path`.`strPath` AS `strPath`,
      `tvshowcounts`.`dateAdded` AS `dateAdded`,
      `tvshowcounts`.`lastPlayed` AS `lastPlayed`,
      `tvshowcounts`.`totalCount` AS `totalCount`,
      `tvshowcounts`.`watchedcount` AS `watchedcount`,
      `tvshowcounts`.`totalSeasons` AS `totalSeasons`
    FROM (((`Kodi_Kiyana_Video_93`.`tvshow` left join `Kodi_Kiyana_Video_93`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Kiyana_Video_93`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) join `Kodi_Kiyana_Video_93`.`tvshowcounts` on((`tvshow`.`idShow` = `tvshowcounts`.`idShow`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Kiyana_Video_93`.`season_view`
    AS SELECT
      `seasons`.`idSeason` AS `idSeason`,
      `seasons`.`idShow` AS `idShow`,
      `seasons`.`season` AS `season`,
      `tvshow_view`.`strPath` AS `strPath`,
      `tvshow_view`.`c00` AS `showTitle`,
      `tvshow_view`.`c01` AS `plot`,
      `tvshow_view`.`c05` AS `premiered`,
      `tvshow_view`.`c08` AS `genre`,
      `tvshow_view`.`c14` AS `studio`,
      `tvshow_view`.`c13` AS `mpaa`,
      count(distinct `episode_view`.`idEpisode`) AS `episodes`,
      count(`files`.`playCount`) AS `playCount`
    FROM (((`Kodi_Kiyana_Video_93`.`seasons` join `Kodi_Kiyana_Video_93`.`tvshow_view` on((`tvshow_view`.`idShow` = `seasons`.`idShow`))) join `Kodi_Kiyana_Video_93`.`episode_view` on(((`episode_view`.`idShow` = `seasons`.`idShow`) and (`episode_view`.`c12` = `seasons`.`season`)))) join `Kodi_Kiyana_Video_93`.`files` on((`files`.`idFile` = `episode_view`.`idFile`))) group by `seasons`.`idSeason`;

USER 04
Code:
/* ************
*** USER 04 ***
**************/
  CREATE DATABASE Kodi_Jaide_Video_93;

  CREATE VIEW `Kodi_Jaide_Video_93`.`actor` AS SELECT * FROM `Kodi_Matt_Video_93`.`actor`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`actor_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`actor_link`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`art` AS SELECT * FROM `Kodi_Matt_Video_93`.`art`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`country` AS SELECT * FROM `Kodi_Matt_Video_93`.`country`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`country_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`country_link`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`director_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`director_link`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`episode` AS SELECT * FROM `Kodi_Matt_Video_93`.`episode`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`genre` AS SELECT * FROM `Kodi_Matt_Video_93`.`genre`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`genre_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`genre_link`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`movie` AS SELECT * FROM `Kodi_Matt_Video_93`.`movie`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`movielinktvshow` AS SELECT * FROM `Kodi_Matt_Video_93`.`movielinktvshow`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`musicvideo` AS SELECT * FROM `Kodi_Matt_Video_93`.`musicvideo`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`path` AS SELECT * FROM `Kodi_Matt_Video_93`.`path`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`seasons` AS SELECT * FROM `Kodi_Matt_Video_93`.`seasons`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`sets` AS SELECT * FROM `Kodi_Matt_Video_93`.`sets`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`settings` AS SELECT * FROM `Kodi_Matt_Video_93`.`settings`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`stacktimes` AS SELECT * FROM `Kodi_Matt_Video_93`.`stacktimes`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`streamdetails` AS SELECT * FROM `Kodi_Matt_Video_93`.`streamdetails`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`studio` AS SELECT * FROM `Kodi_Matt_Video_93`.`studio`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`studio_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`studio_link`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`tag` AS SELECT * FROM `Kodi_Matt_Video_93`.`tag`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`tag_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`tag_link`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`tvshow` AS SELECT * FROM `Kodi_Matt_Video_93`.`tvshow`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`tvshowlinkpath` AS SELECT * FROM `Kodi_Matt_Video_93`.`tvshowlinkpath`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`version` AS SELECT * FROM `Kodi_Matt_Video_93`.`version`;
  CREATE VIEW `Kodi_Jaide_Video_93`.`writer_link` AS SELECT * FROM `Kodi_Matt_Video_93`.`writer_link`;

  CREATE VIEW `Kodi_Jaide_Video_93`.`files`
    AS SELECT
      `globalfiles`.`idFile` AS `idFile`,
      `globalfiles`.`idPath` AS `idPath`,
      `globalfiles`.`strFilename` AS `strFilename`,
      `globalfiles`.`playCountJaide` AS `playCount`,
      `globalfiles`.`lastPlayedJaide` AS `lastPlayed`,
      `globalfiles`.`dateAdded` AS `dateAdded`
    FROM `Kodi_Matt_Video_93`.`globalfiles`;

  CREATE TABLE `Kodi_Jaide_Video_93`.`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 `Kodi_Jaide_Video_93`.`episode_view`
    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 `studio`,
      `tvshow`.`c05` AS `premiered`,
      `tvshow`.`c13` AS `mpaa`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
      `seasons`.`idSeason` AS `idSeason`
    FROM (((((`Kodi_Jaide_Video_93`.`episode` join `Kodi_Jaide_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) join `Kodi_Jaide_Video_93`.`tvshow` on((`tvshow`.`idShow` = `episode`.`idShow`))) left join `Kodi_Jaide_Video_93`.`seasons` on(((`seasons`.`idShow` = `episode`.`idShow`) and (`seasons`.`season` = `episode`.`c12`)))) join `Kodi_Jaide_Video_93`.`path` on((`files`.`idPath` = `path`.`idPath`))) left join `Kodi_Jaide_Video_93`.`bookmark` on(((`Kodi_Jaide_Video_93`.`bookmark`.`idFile` = `episode`.`idFile`) and (`Kodi_Jaide_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Jaide_Video_93`.`movie_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM ((((`Kodi_Jaide_Video_93`.`movie` left join `Kodi_Jaide_Video_93`.`sets` on((`sets`.`idSet` = `movie`.`idSet`))) join `Kodi_Jaide_Video_93`.`files` on((`files`.`idFile` = `movie`.`idFile`))) join `Kodi_Jaide_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Jaide_Video_93`.`bookmark` on(((`Kodi_Jaide_Video_93`.`bookmark`.`idFile` = `movie`.`idFile`) and (`Kodi_Jaide_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Jaide_Video_93`.`musicvideo_view`
    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`,
      `bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
      `bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
    FROM (((`Kodi_Jaide_Video_93`.`musicvideo` join `Kodi_Jaide_Video_93`.`files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `Kodi_Jaide_Video_93`.`path` on((`path`.`idPath` = `files`.`idPath`))) left join `Kodi_Jaide_Video_93`.`bookmark` on(((`Kodi_Jaide_Video_93`.`bookmark`.`idFile` = `musicvideo`.`idFile`) and (`Kodi_Jaide_Video_93`.`bookmark`.`type` = 1))));

  CREATE VIEW `Kodi_Jaide_Video_93`.`tvshowcounts`
    AS SELECT
      `tvshow`.`idShow` AS `idShow`,
      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`,
      max(`files`.`dateAdded`) AS `dateAdded`
    FROM ((`Kodi_Jaide_Video_93`.`tvshow` left join `Kodi_Jaide_Video_93`.`episode` on((`episode`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Jaide_Video_93`.`files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Jaide_Video_93`.`tvshow_view`
    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`.`idParentPath` AS `idParentPath`,
      `path`.`strPath` AS `strPath`,
      `tvshowcounts`.`dateAdded` AS `dateAdded`,
      `tvshowcounts`.`lastPlayed` AS `lastPlayed`,
      `tvshowcounts`.`totalCount` AS `totalCount`,
      `tvshowcounts`.`watchedcount` AS `watchedcount`,
      `tvshowcounts`.`totalSeasons` AS `totalSeasons`
    FROM (((`Kodi_Jaide_Video_93`.`tvshow` left join `Kodi_Jaide_Video_93`.`tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `Kodi_Jaide_Video_93`.`path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) join `Kodi_Jaide_Video_93`.`tvshowcounts` on((`tvshow`.`idShow` = `tvshowcounts`.`idShow`))) group by `tvshow`.`idShow`;

  CREATE VIEW `Kodi_Jaide_Video_93`.`season_view`
    AS SELECT
      `seasons`.`idSeason` AS `idSeason`,
      `seasons`.`idShow` AS `idShow`,
      `seasons`.`season` AS `season`,
      `tvshow_view`.`strPath` AS `strPath`,
      `tvshow_view`.`c00` AS `showTitle`,
      `tvshow_view`.`c01` AS `plot`,
      `tvshow_view`.`c05` AS `premiered`,
      `tvshow_view`.`c08` AS `genre`,
      `tvshow_view`.`c14` AS `studio`,
      `tvshow_view`.`c13` AS `mpaa`,
      count(distinct `episode_view`.`idEpisode`) AS `episodes`,
      count(`files`.`playCount`) AS `playCount`
    FROM (((`Kodi_Jaide_Video_93`.`seasons` join `Kodi_Jaide_Video_93`.`tvshow_view` on((`tvshow_view`.`idShow` = `seasons`.`idShow`))) join `Kodi_Jaide_Video_93`.`episode_view` on(((`episode_view`.`idShow` = `seasons`.`idShow`) and (`episode_view`.`c12` = `seasons`.`season`)))) join `Kodi_Jaide_Video_93`.`files` on((`files`.`idFile` = `episode_view`.`idFile`))) group by `seasons`.`idSeason`;

Can't work out Signatures so I just add it here Smile
------------------------
Image

I am going to attempt this. I've already backed up both profiles video databases to single files, separately. I previously used your posts and the scripts from bigmong to upgrade from Gotham to Helix. This post is a little more confusing...

I have a b c d e in the SQL database, and the two of which I really use are a (master) b (secondary). c is set up to be able to login as a guest on the clients.
I understand the find and replace part so the scripts will have a_93 instead of Kodi_Matt_Video_93.
I will find and replace Kodi_Mace_Video_ with b, Kodi_Kiyana_Video_ with c
I understand how I would add a fifth user based on your globalfiles script.

I have few questions so far:
I guess I should change playCountMatt and lastPlayedMatt to playCounta and lastPlayeda, respectively? and then carry on with b and c in place of Mace and Kiyana?
Do I run all of these scripts with the master user database (a) selected?
Reply


Messages In This Thread
[MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-02, 19:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by kikinjo - 2014-06-08, 11:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 14:41
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-07, 19:55
RE: [MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-06-07, 20:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-07, 21:02
RE: [MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-06-09, 17:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 15:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 22:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 22:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-09, 00:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-10, 01:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-09, 02:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-09, 02:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by queonda - 2014-06-09, 21:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by queonda - 2014-06-10, 01:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-10, 02:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-11, 07:44
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-06-15, 02:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-15, 04:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-15, 09:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-15, 11:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-17, 05:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-19, 17:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Martijn - 2014-06-19, 17:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-19, 18:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by Martijn - 2014-06-19, 18:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-20, 15:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-07-04, 14:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by narvatu - 2014-07-04, 22:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-07-26, 17:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by rmilyard - 2014-07-26, 16:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-08-25, 04:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-09-14, 13:21
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2014-10-02, 02:17
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2014-10-04, 00:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-10-06, 15:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by Speed... - 2014-12-25, 17:56
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-10-09, 13:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by fnc1 - 2014-10-18, 04:55
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-12-02, 01:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2014-12-04, 02:03
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-12-05, 10:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by raphibb - 2014-12-06, 05:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by judocama - 2014-12-15, 14:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by Blend - 2015-01-07, 12:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by dual-o - 2015-01-07, 15:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by Blend - 2015-01-07, 18:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-11, 10:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by Blend - 2015-01-15, 22:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by Dersch - 2015-02-05, 12:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-15, 22:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Speed... - 2015-01-17, 02:13
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-17, 11:42
RE: [MYSQL] HOW-TO: 5 User XBMC - by Speed... - 2015-01-18, 18:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-01-24, 01:18
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-18, 19:02
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-01-20, 19:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-23, 18:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-23, 20:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-24, 12:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-05-23, 07:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by gardar - 2015-07-20, 02:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-24, 19:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-25, 08:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by Keithh - 2015-01-25, 10:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-25, 16:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-25, 22:48
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-26, 00:21
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-04-12, 18:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-04-12, 19:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-05-23, 08:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-05-24, 05:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by nebulous - 2015-06-10, 15:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by papirri2 - 2015-06-14, 09:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by nickr - 2015-06-14, 09:55
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-06-17, 05:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by lody2mk - 2015-06-17, 19:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by freddy12 - 2015-06-23, 17:15
RE: [MYSQL] HOW-TO: 5 User XBMC - by Xiled78 - 2015-07-03, 04:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-07-27, 10:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-07-30, 09:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-07-30, 11:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-02, 07:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-02, 16:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-02, 03:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-09-02, 14:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-08-13, 01:50
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-13, 04:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-08-13, 10:36
Re: [MYSQL] HOW-TO: 5 User XBMC - by nickr - 2015-08-13, 11:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-08-13, 12:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-08-13, 13:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-08-13, 13:57
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-08-13, 14:01
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-08-18, 20:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-22, 08:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-08-22, 08:10
RE: [MYSQL] HOW-TO: 5 User XBMC - by quim_3000 - 2015-08-25, 08:41
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-25, 23:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-03, 00:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-09, 00:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-09-10, 05:01
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-09-10, 10:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-12, 05:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-09-12, 09:22
RE: [MYSQL] HOW-TO: 5 User XBMC - by mert0267 - 2015-09-18, 01:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-03, 16:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-10-04, 13:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-04, 17:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by bym007 - 2015-10-08, 13:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-10-08, 13:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-08, 15:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-10-08, 16:34
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-13, 22:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-22, 04:36
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 07:09
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-22, 11:26
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 13:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-22, 18:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by Connex - 2015-10-22, 16:24
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 18:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-22, 19:07
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 20:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-27, 17:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-28, 01:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-01-25, 20:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-01-23, 03:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-01-23, 05:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-01-25, 20:13
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-02-03, 14:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-02-07, 00:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-02-24, 10:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by birt - 2016-02-26, 10:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 06:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2016-04-27, 21:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2017-04-10, 03:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by D0bby - 2016-05-17, 18:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 07:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 13:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-03-14, 21:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 23:05
RE: [MYSQL] HOW-TO: 5 User XBMC - by gimalugi - 2016-03-15, 23:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2016-04-27, 22:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-04-28, 11:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by npbhdk - 2016-05-04, 18:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-05-05, 16:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by npbhdk - 2016-05-06, 01:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by RonM - 2016-05-05, 08:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by D0bby - 2016-05-17, 21:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by Sushi7 - 2016-06-27, 22:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-06-28, 10:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by Sushi7 - 2016-06-28, 13:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by mcfang - 2016-11-17, 15:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-06-28, 14:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by gaxander - 2016-07-28, 11:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by ascona - 2016-08-01, 15:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by matika - 2016-09-07, 23:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Sushi7 - 2016-08-15, 16:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by vibe666 - 2016-08-17, 03:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by bpanonpt - 2017-01-11, 01:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by bpanonpt - 2017-01-11, 18:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by Meddie31 - 2017-01-15, 16:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by TRaSH - 2017-01-15, 17:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by Meddie31 - 2017-01-15, 17:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-03, 09:48
RE: [MYSQL] HOW-TO: 5 User XBMC - by zosky - 2019-12-13, 04:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-04, 12:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by Ruben_82 - 2017-02-06, 05:51
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-11, 11:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by birt - 2017-02-25, 00:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-26, 13:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by nulled - 2017-03-21, 10:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-03-21, 12:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by nulled - 2017-03-21, 15:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-03-23, 04:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by nulled - 2017-03-23, 14:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-03-24, 10:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by Smasher - 2017-04-07, 00:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2017-04-07, 03:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-04-10, 12:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2017-04-10, 20:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by Smasher - 2017-04-10, 13:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-04-11, 12:51
RE: [MYSQL] HOW-TO: 5 User XBMC - by Smasher - 2017-04-11, 13:18
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-04-12, 11:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-06-22, 13:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by Karellen - 2017-06-22, 13:17
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-06-22, 13:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2017-06-25, 21:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-07-13, 13:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by sloth85 - 2018-06-02, 15:34
RE: [MYSQL] HOW-TO: 5 User XBMC - by djibax - 2018-07-18, 00:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by greyd - 2018-07-19, 19:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by calibos - 2018-08-09, 12:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by Klojum - 2018-08-31, 16:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by nickty - 2018-11-23, 13:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by Michal_K - 2019-02-06, 20:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-02-06, 23:05
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-02-07, 07:01
RE: [MYSQL] HOW-TO: 5 User XBMC - by birt - 2019-02-13, 12:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by sloth85 - 2020-08-25, 13:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by Michal_K - 2019-02-07, 10:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2019-07-03, 00:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-07-03, 12:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2019-07-04, 22:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-07-05, 00:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-19, 03:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-19, 09:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-19, 16:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-20, 01:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-20, 02:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-20, 10:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-20, 17:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 02:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-21, 03:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 14:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-21, 17:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 20:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-21, 22:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by NicCo - 2019-08-20, 17:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 02:13
RE: [MYSQL] HOW-TO: 5 User XBMC - by NicCo - 2019-08-22, 08:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-22, 13:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by NicCo - 2019-08-22, 16:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-25, 06:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-25, 21:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-25, 22:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-27, 21:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-28, 05:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-28, 14:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by sloth85 - 2019-10-12, 13:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-11-01, 00:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-09-12, 19:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by ponkotsu - 2019-09-26, 19:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-09-27, 01:50
RE: [MYSQL] HOW-TO: 5 User XBMC - by Moukrea - 2019-11-19, 13:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2020-01-26, 08:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2020-05-22, 19:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2021-01-28, 00:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2021-01-30, 02:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-08, 19:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-09, 14:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by Knallex - 2021-04-09, 13:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-09, 14:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-10, 09:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-10, 11:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by Knallex - 2021-04-10, 10:41
RE: [MYSQL] HOW-TO: 5 User XBMC - by Knallex - 2021-04-10, 10:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-10, 12:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-13, 21:15
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-14, 10:34
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-14, 13:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-14, 13:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-14, 19:02
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-14, 23:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-05-15, 03:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-05-16, 16:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-05-17, 11:22
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-05-22, 09:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-10-03, 13:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by ponkotsu - 2021-05-26, 02:48
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-05-29, 10:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by ponkotsu - 2021-06-01, 18:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2021-12-24, 19:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by Giangi - 2022-01-02, 17:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by palym - 2022-01-14, 09:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by palym - 2022-03-03, 08:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by yusufvml - 2022-03-19, 03:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2022-03-19, 15:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2022-03-13, 18:22
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2022-03-15, 03:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by TakedaT - 2022-08-10, 15:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-08-12, 11:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-08-13, 04:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by bart330 - 2023-01-16, 13:55
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2023-01-16, 15:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-02-05, 15:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by jro9909 - 2024-02-13, 18:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by bart330 - 2023-01-17, 00:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by *MarioP* - 2023-01-23, 10:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by bart330 - 2023-01-24, 00:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by *MarioP* - 2023-03-15, 17:51
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-08-13, 04:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by Mairiver - 2023-10-30, 17:36
Logout Mark Read Team Forum Stats Members Help
[MYSQL] HOW-TO: 5 User XBMC5