-- MySQL dump 10.14 Distrib 5.5.57-MariaDB, for Linux () -- -- Host: localhost Database: s01 -- ------------------------------------------------------ -- Server version 10.11.8-MariaDB-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `ACL2Table` -- DROP TABLE IF EXISTS `ACL2Table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ACL2Table` ( `ProtectionStatus2` bigint(20) DEFAULT NULL, `uid` bigint(20) DEFAULT NULL, `rights` int(11) DEFAULT 1, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `ProtectionStatus2` (`ProtectionStatus2`,`uid`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_Acl2_Protection_Uid` (`ProtectionStatus2`,`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ACL2Table` -- LOCK TABLES `ACL2Table` WRITE; /*!40000 ALTER TABLE `ACL2Table` DISABLE KEYS */; INSERT INTO `ACL2Table` VALUES (65557,0,1,'2024-11-26 08:53:06'),(65557,99,1,'2024-11-26 08:53:06'),(65557,500,1,'2024-11-26 08:53:06'),(393237,500,1,'2024-12-06 07:34:42'),(393237,501,1,'2024-12-06 07:34:42'),(393237,502,1,'2024-12-06 07:34:42'),(393237,0,1,'2024-12-06 07:34:42'),(393237,99,1,'2024-12-06 07:34:42'); /*!40000 ALTER TABLE `ACL2Table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ACL3Table` -- DROP TABLE IF EXISTS `ACL3Table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ACL3Table` ( `iDirId` bigint(20) DEFAULT NULL, `uid` bigint(20) DEFAULT NULL, `ReadPerm` tinyint(1) DEFAULT 0, `WritePerm` tinyint(1) DEFAULT 0, `ExecPerm` tinyint(1) DEFAULT 0, `LastChange` bigint(20) DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iDirId` (`iDirId`,`uid`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ACL3Table` -- LOCK TABLES `ACL3Table` WRITE; /*!40000 ALTER TABLE `ACL3Table` DISABLE KEYS */; INSERT INTO `ACL3Table` VALUES (6,0,1,1,0,1732881829,'2024-12-06 07:34:44'),(6,502,1,1,0,1732881829,'2024-12-06 07:34:44'),(7,0,1,1,0,1733436010,'2024-12-06 07:34:45'),(7,502,1,1,0,1733436010,'2024-12-06 07:34:45'),(8,0,1,1,0,1732881835,'2024-12-06 07:34:45'),(8,502,1,1,0,1732881835,'2024-12-06 07:34:45'); /*!40000 ALTER TABLE `ACL3Table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ACLTable` -- DROP TABLE IF EXISTS `ACLTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ACLTable` ( `ProtectionStatus` bigint(20) DEFAULT NULL, `uid` bigint(20) DEFAULT NULL, `rights` int(11) DEFAULT 1, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `ProtectionStatus` (`ProtectionStatus`,`uid`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_Acl_Protection_Uid` (`ProtectionStatus`,`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ACLTable` -- LOCK TABLES `ACLTable` WRITE; /*!40000 ALTER TABLE `ACLTable` DISABLE KEYS */; /*!40000 ALTER TABLE `ACLTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ExSongTable` -- DROP TABLE IF EXISTS `ExSongTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ExSongTable` ( `iExSongId` bigint(20) NOT NULL AUTO_INCREMENT, `URL` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `type` int(11) DEFAULT NULL, `cSongTitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cAlbumTitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cArtistName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `iTrackNr` int(11) DEFAULT NULL, `iTrackLength` int(11) DEFAULT NULL, `FormatId` int(11) DEFAULT NULL, `CoverPath` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `cFileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iExSongId`), UNIQUE KEY `URL` (`URL`(320)), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_ExSongTable_URL` (`URL`(333)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ExSongTable` -- LOCK TABLES `ExSongTable` WRITE; /*!40000 ALTER TABLE `ExSongTable` DISABLE KEYS */; /*!40000 ALTER TABLE `ExSongTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `KTVArtistMapping` -- DROP TABLE IF EXISTS `KTVArtistMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KTVArtistMapping` ( `iVideoId` bigint(20) DEFAULT NULL, `iArtistId` bigint(20) DEFAULT NULL, `iOrder` int(11) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `cArtistName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `Subtype` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iVideoId` (`iVideoId`,`iArtistId`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `KTVArtistMapping` -- LOCK TABLES `KTVArtistMapping` WRITE; /*!40000 ALTER TABLE `KTVArtistMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `KTVArtistMapping` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_KTVArtistMapping AFTER DELETE ON KTVArtistMapping FOR EACH ROW BEGIN DELETE FROM KTVArtistTable WHERE NOT EXISTS ( SELECT * FROM KTVArtistMapping WHERE iArtistId = old.iArtistId ) AND iArtistId = old.iArtistId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `KTVArtistSearchPattern` -- DROP TABLE IF EXISTS `KTVArtistSearchPattern`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KTVArtistSearchPattern` ( `iArtistId` bigint(20) DEFAULT NULL, `cSearchPattern` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `iSearchPattern` int(11) DEFAULT NULL, `iSearchPatternType` int(11) DEFAULT NULL, UNIQUE KEY `iArtistId` (`iArtistId`,`iSearchPatternType`), KEY `idx_cSearchPattern` (`iSearchPatternType`,`cSearchPattern`), KEY `idx_iSearchPattern` (`iSearchPatternType`,`iSearchPattern`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `KTVArtistSearchPattern` -- LOCK TABLES `KTVArtistSearchPattern` WRITE; /*!40000 ALTER TABLE `KTVArtistSearchPattern` DISABLE KEYS */; /*!40000 ALTER TABLE `KTVArtistSearchPattern` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `KTVArtistTable` -- DROP TABLE IF EXISTS `KTVArtistTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KTVArtistTable` ( `iArtistId` bigint(20) NOT NULL AUTO_INCREMENT, `cArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iNationality` int(11) DEFAULT 0, `iGender` int(11) DEFAULT 0, `iThumbnail` int(11) DEFAULT 0, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iArtistId`), UNIQUE KEY `cArtistName` (`cArtistName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_KTVArtist_cArtistName` (`cArtistName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `KTVArtistTable` -- LOCK TABLES `KTVArtistTable` WRITE; /*!40000 ALTER TABLE `KTVArtistTable` DISABLE KEYS */; /*!40000 ALTER TABLE `KTVArtistTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_KTVArtist AFTER DELETE ON KTVArtistTable FOR EACH ROW BEGIN DELETE FROM KTVArtistSearchPattern WHERE iArtistId = old.iArtistId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `KTVGenreMapping` -- DROP TABLE IF EXISTS `KTVGenreMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KTVGenreMapping` ( `iVideoId` bigint(20) DEFAULT NULL, `iGenreId` bigint(20) DEFAULT NULL, `iOrder` int(11) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Subtype` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iVideoId` (`iVideoId`,`iGenreId`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `KTVGenreMapping` -- LOCK TABLES `KTVGenreMapping` WRITE; /*!40000 ALTER TABLE `KTVGenreMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `KTVGenreMapping` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_KTVGenreMapping AFTER DELETE ON KTVGenreMapping FOR EACH ROW BEGIN DELETE FROM KTVGenreTable WHERE NOT EXISTS ( SELECT * FROM KTVGenreMapping WHERE iGenreId = old.iGenreId ) AND iGenreId = old.iGenreId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `KTVGenreTable` -- DROP TABLE IF EXISTS `KTVGenreTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KTVGenreTable` ( `iGenreId` bigint(20) NOT NULL AUTO_INCREMENT, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iGenreId`), UNIQUE KEY `cGenreName` (`cGenreName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_KTVGenre_cGenreName` (`cGenreName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `KTVGenreTable` -- LOCK TABLES `KTVGenreTable` WRITE; /*!40000 ALTER TABLE `KTVGenreTable` DISABLE KEYS */; /*!40000 ALTER TABLE `KTVGenreTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `KTVLyricsMapping` -- DROP TABLE IF EXISTS `KTVLyricsMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KTVLyricsMapping` ( `iVideoId` bigint(20) DEFAULT NULL, `iLyricsLangId` int(11) DEFAULT NULL, UNIQUE KEY `iVideoId` (`iVideoId`,`iLyricsLangId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `KTVLyricsMapping` -- LOCK TABLES `KTVLyricsMapping` WRITE; /*!40000 ALTER TABLE `KTVLyricsMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `KTVLyricsMapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `KTVTitleSearchPattern` -- DROP TABLE IF EXISTS `KTVTitleSearchPattern`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KTVTitleSearchPattern` ( `iVideoId` bigint(20) DEFAULT NULL, `cSearchPattern` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `iSearchPattern` int(11) DEFAULT NULL, `iSearchPatternType` int(11) DEFAULT NULL, UNIQUE KEY `iVideoId` (`iVideoId`,`iSearchPatternType`), KEY `idx_cSearchPattern` (`iSearchPatternType`,`cSearchPattern`), KEY `idx_iSearchPattern` (`iSearchPatternType`,`iSearchPattern`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `KTVTitleSearchPattern` -- LOCK TABLES `KTVTitleSearchPattern` WRITE; /*!40000 ALTER TABLE `KTVTitleSearchPattern` DISABLE KEYS */; /*!40000 ALTER TABLE `KTVTitleSearchPattern` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `MusicVideoAlbumTable` -- DROP TABLE IF EXISTS `MusicVideoAlbumTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `MusicVideoAlbumTable` ( `iAlbumId` bigint(20) NOT NULL AUTO_INCREMENT, `cAlbumTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iArtistId` bigint(20) DEFAULT NULL, `iAlbumArt` int(11) DEFAULT 0, `AlbumArtBLOB` blob DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `cArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iAlbumId`), UNIQUE KEY `cAlbumTitle` (`cAlbumTitle`(100),`cArtistName`(100)), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_MusicVideoAlbumTable_cAlbumTitle` (`cAlbumTitle`), KEY `idx_MusicVideoAlbumTable_cArtistName` (`cArtistName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `MusicVideoAlbumTable` -- LOCK TABLES `MusicVideoAlbumTable` WRITE; /*!40000 ALTER TABLE `MusicVideoAlbumTable` DISABLE KEYS */; /*!40000 ALTER TABLE `MusicVideoAlbumTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `MusicVideoArtistTable` -- DROP TABLE IF EXISTS `MusicVideoArtistTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `MusicVideoArtistTable` ( `iArtistId` bigint(20) NOT NULL AUTO_INCREMENT, `cArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iThumbnail` int(11) DEFAULT 0, `thumbnailBLOB` blob DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iArtistId`), UNIQUE KEY `cArtistName` (`cArtistName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_MusicVideoArtistTable_cArtistName` (`cArtistName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `MusicVideoArtistTable` -- LOCK TABLES `MusicVideoArtistTable` WRITE; /*!40000 ALTER TABLE `MusicVideoArtistTable` DISABLE KEYS */; /*!40000 ALTER TABLE `MusicVideoArtistTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `MusicVideoGenreTable` -- DROP TABLE IF EXISTS `MusicVideoGenreTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `MusicVideoGenreTable` ( `iGenreId` bigint(20) NOT NULL AUTO_INCREMENT, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iGenreId`), UNIQUE KEY `cGenreName` (`cGenreName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_MusicVideoGenreTable_cGenreName` (`cGenreName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `MusicVideoGenreTable` -- LOCK TABLES `MusicVideoGenreTable` WRITE; /*!40000 ALTER TABLE `MusicVideoGenreTable` DISABLE KEYS */; /*!40000 ALTER TABLE `MusicVideoGenreTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `StorageTable` -- DROP TABLE IF EXISTS `StorageTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `StorageTable` ( `iStorageId` int(11) NOT NULL AUTO_INCREMENT, `IsValid` int(11) NOT NULL DEFAULT 1, `prefix` varchar(1024) DEFAULT NULL, `uuid` varchar(256) DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iStorageId`), UNIQUE KEY `prefix` (`prefix`(100)), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `StorageTable` -- LOCK TABLES `StorageTable` WRITE; /*!40000 ALTER TABLE `StorageTable` DISABLE KEYS */; INSERT INTO `StorageTable` VALUES (1,1,'/share/CACHEDEV1_DATA/',NULL,'2024-11-26 08:48:41'); /*!40000 ALTER TABLE `StorageTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `TVShowEpisode` -- DROP TABLE IF EXISTS `TVShowEpisode`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `TVShowEpisode` ( `EpisodeName` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Season` int(11) DEFAULT NULL, `iEpisodeId` bigint(20) NOT NULL AUTO_INCREMENT, `iThumbnail` int(11) DEFAULT 0, `thumbnailBLOB` blob DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `DisplayName` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `AirDate` date DEFAULT NULL, `Comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Actors` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Directors` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Rating` decimal(8,3) DEFAULT NULL, `Genre` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Creators` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastAirDate` date DEFAULT NULL, PRIMARY KEY (`iEpisodeId`), UNIQUE KEY `EpisodeName` (`EpisodeName`(100),`Season`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_TVShowEpisode_EpisodeName_Season` (`EpisodeName`(100),`Season`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `TVShowEpisode` -- LOCK TABLES `TVShowEpisode` WRITE; /*!40000 ALTER TABLE `TVShowEpisode` DISABLE KEYS */; /*!40000 ALTER TABLE `TVShowEpisode` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `TrashBin` -- DROP TABLE IF EXISTS `TrashBin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `TrashBin` ( `Id` bigint(20) DEFAULT NULL, `MediaType` int(11) DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_TrashBin_Id_MediaType` (`Id`,`MediaType`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `TrashBin` -- LOCK TABLES `TrashBin` WRITE; /*!40000 ALTER TABLE `TrashBin` DISABLE KEYS */; /*!40000 ALTER TABLE `TrashBin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `albumTable` -- DROP TABLE IF EXISTS `albumTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `albumTable` ( `iAlbumId` bigint(20) NOT NULL AUTO_INCREMENT, `cAlbumTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iArtistId` bigint(20) DEFAULT NULL, `iAlbumArt` int(11) DEFAULT 0, `AlbumArtBLOB` blob DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `cArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iAlbumId`), UNIQUE KEY `cAlbumTitle` (`cAlbumTitle`(100),`cArtistName`(100)), KEY `idx_LastUpdate` (`LastUpdate`), KEY `album_cAlbumTitle` (`cAlbumTitle`), KEY `idx_albumTable_cArtistName` (`cArtistName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `albumTable` -- LOCK TABLES `albumTable` WRITE; /*!40000 ALTER TABLE `albumTable` DISABLE KEYS */; /*!40000 ALTER TABLE `albumTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `albumViewHistory` -- DROP TABLE IF EXISTS `albumViewHistory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `albumViewHistory` ( `AlbumType` tinyint(4) NOT NULL, `AlbumSubtype` tinyint(4) NOT NULL DEFAULT 0, `AlbumId` int(11) NOT NULL, `Uid` int(11) NOT NULL, `LastView` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `Uid` (`Uid`,`AlbumType`,`AlbumSubtype`,`AlbumId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `albumViewHistory` -- LOCK TABLES `albumViewHistory` WRITE; /*!40000 ALTER TABLE `albumViewHistory` DISABLE KEYS */; /*!40000 ALTER TABLE `albumViewHistory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `appTable` -- DROP TABLE IF EXISTS `appTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `appTable` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `ownerData` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `appTable` -- LOCK TABLES `appTable` WRITE; /*!40000 ALTER TABLE `appTable` DISABLE KEYS */; /*!40000 ALTER TABLE `appTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `artistTable` -- DROP TABLE IF EXISTS `artistTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artistTable` ( `iArtistId` bigint(20) NOT NULL AUTO_INCREMENT, `cArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iThumbnail` int(11) DEFAULT 0, `thumbnailBLOB` blob DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iArtistId`), UNIQUE KEY `cArtistName` (`cArtistName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `artist_cArtistName` (`cArtistName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `artistTable` -- LOCK TABLES `artistTable` WRITE; /*!40000 ALTER TABLE `artistTable` DISABLE KEYS */; /*!40000 ALTER TABLE `artistTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dirTable` -- DROP TABLE IF EXISTS `dirTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dirTable` ( `iDirId` bigint(20) NOT NULL AUTO_INCREMENT, `cDirName` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `iParentDirId` bigint(20) DEFAULT NULL, `cFullPath` varchar(1023) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `ProtectionStatus` bigint(20) DEFAULT NULL, `ProtectionStatus2` bigint(20) DEFAULT NULL, `DateCreated` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `iFileSize` bigint(20) DEFAULT NULL, `iStorageId` int(11) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `AttrFlag` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `QtagId` char(64) DEFAULT NULL, `App1` tinyint(1) NOT NULL DEFAULT 0, `App2` tinyint(1) NOT NULL DEFAULT 0, `App3` tinyint(1) NOT NULL DEFAULT 0, `App4` tinyint(1) NOT NULL DEFAULT 0, `App5` tinyint(1) NOT NULL DEFAULT 0, `App6` tinyint(1) NOT NULL DEFAULT 0, `App7` tinyint(1) NOT NULL DEFAULT 0, `App8` tinyint(1) NOT NULL DEFAULT 0, `App9` tinyint(1) NOT NULL DEFAULT 0, `App10` tinyint(1) NOT NULL DEFAULT 0, `App11` tinyint(1) NOT NULL DEFAULT 0, `App12` tinyint(1) NOT NULL DEFAULT 0, `App13` tinyint(1) NOT NULL DEFAULT 0, `App14` tinyint(1) NOT NULL DEFAULT 0, `App15` tinyint(1) NOT NULL DEFAULT 0, `App16` tinyint(1) NOT NULL DEFAULT 0, `App17` tinyint(1) NOT NULL DEFAULT 0, `App18` tinyint(1) NOT NULL DEFAULT 0, `App19` tinyint(1) NOT NULL DEFAULT 0, `App20` tinyint(1) NOT NULL DEFAULT 0, `App21` tinyint(1) NOT NULL DEFAULT 0, `App22` tinyint(1) NOT NULL DEFAULT 0, `App23` tinyint(1) NOT NULL DEFAULT 0, `App24` tinyint(1) NOT NULL DEFAULT 0, `App25` tinyint(1) NOT NULL DEFAULT 0, `App26` tinyint(1) NOT NULL DEFAULT 0, `App27` tinyint(1) NOT NULL DEFAULT 0, `App28` tinyint(1) NOT NULL DEFAULT 0, `App29` tinyint(1) NOT NULL DEFAULT 0, `App30` tinyint(1) NOT NULL DEFAULT 0, `App31` tinyint(1) NOT NULL DEFAULT 0, `App32` tinyint(1) NOT NULL DEFAULT 0, `App33` tinyint(1) NOT NULL DEFAULT 0, `App34` tinyint(1) NOT NULL DEFAULT 0, `App35` tinyint(1) NOT NULL DEFAULT 0, `App36` tinyint(1) NOT NULL DEFAULT 0, `App37` tinyint(1) NOT NULL DEFAULT 0, `App38` tinyint(1) NOT NULL DEFAULT 0, `App39` tinyint(1) NOT NULL DEFAULT 0, `App40` tinyint(1) NOT NULL DEFAULT 0, `App41` tinyint(1) NOT NULL DEFAULT 0, `App42` tinyint(1) NOT NULL DEFAULT 0, `App43` tinyint(1) NOT NULL DEFAULT 0, `App44` tinyint(1) NOT NULL DEFAULT 0, `App45` tinyint(1) NOT NULL DEFAULT 0, `App46` tinyint(1) NOT NULL DEFAULT 0, `App47` tinyint(1) NOT NULL DEFAULT 0, `App48` tinyint(1) NOT NULL DEFAULT 0, `App49` tinyint(1) NOT NULL DEFAULT 0, `App50` tinyint(1) NOT NULL DEFAULT 0, `App51` tinyint(1) NOT NULL DEFAULT 0, `App52` tinyint(1) NOT NULL DEFAULT 0, `App53` tinyint(1) NOT NULL DEFAULT 0, `App54` tinyint(1) NOT NULL DEFAULT 0, `App55` tinyint(1) NOT NULL DEFAULT 0, `App56` tinyint(1) NOT NULL DEFAULT 0, `App57` tinyint(1) NOT NULL DEFAULT 0, `App58` tinyint(1) NOT NULL DEFAULT 0, `App59` tinyint(1) NOT NULL DEFAULT 0, `App60` tinyint(1) NOT NULL DEFAULT 0, `App61` tinyint(1) NOT NULL DEFAULT 0, `App62` tinyint(1) NOT NULL DEFAULT 0, `App63` tinyint(1) NOT NULL DEFAULT 0, `App64` tinyint(1) NOT NULL DEFAULT 0, `ScannedFlag` int(11) DEFAULT 0, `coverWidth` int(11) DEFAULT NULL, `coverHeight` int(11) DEFAULT NULL, `UserGroupHash` varbinary(32) DEFAULT NULL, `CoverId` bigint(20) NOT NULL DEFAULT 0, PRIMARY KEY (`iDirId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_QtagId` (`QtagId`), KEY `dir_iParentDirId` (`iParentDirId`), KEY `dir_cDirName` (`cDirName`(250)), KEY `idx_dirTable_cFullPath` (`cFullPath`(250)) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dirTable` -- LOCK TABLES `dirTable` WRITE; /*!40000 ALTER TABLE `dirTable` DISABLE KEYS */; INSERT INTO `dirTable` VALUES (6,'Multimedia',0,'Multimedia/',0,393237,1732881829,1732610857,NULL,1,0,0,'2024-12-06 07:34:45','190e36c5d2244eb8bc5e0acfcdf0340f245ebe465ef7',0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,'ôwrͤMAr7&ѵų ¨',0),(7,'@Recycle',6,'Multimedia/@Recycle/',0,393237,1733436010,1733436010,NULL,1,1,0,'2024-12-06 07:34:45','b9cd49afdcaa4a14893857d39451f3c6245ebe465ef7',0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,'ôwrͤMAr7&ѵų ¨',0),(8,'Samples',6,'Multimedia/Samples/',0,393237,1732881835,1732881835,NULL,1,0,0,'2024-12-06 07:34:45','829de5dfb6054ea0a00378030ee017b8245ebe465ef7',0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,601,400,'ôwrͤMAr7&ѵų ¨',21); /*!40000 ALTER TABLE `dirTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_dirTable AFTER DELETE ON dirTable FOR EACH ROW BEGIN DELETE FROM songTable WHERE iDirId = old.iDirId; DELETE FROM pictureTable WHERE iDirId = old.iDirId; DELETE FROM playlistTable WHERE iDirId = old.iDirId; DELETE FROM videoTable WHERE iDirId = old.iDirid; DELETE FROM ACL3Table WHERE iDirId = old.iDirid; INSERT INTO objDeletionTable (iMediaId, type, iStorageId, iDirId, cFullPath) VALUES (old.iDirid, 20, old.iStorageId, old.iDirid, old.cFullPath); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `faceClusterSuggestion` -- DROP TABLE IF EXISTS `faceClusterSuggestion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceClusterSuggestion` ( `ClusterId` bigint(20) NOT NULL, `SuggestClusterId` bigint(20) NOT NULL, `iOrder` smallint(6) NOT NULL DEFAULT 32767, `Touched` tinyint(4) NOT NULL DEFAULT 0, UNIQUE KEY `ClusterId` (`ClusterId`,`SuggestClusterId`), KEY `idx_fcsug_cluid` (`ClusterId`), KEY `idx_fcsug_sugcluid` (`SuggestClusterId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceClusterSuggestion` -- LOCK TABLES `faceClusterSuggestion` WRITE; /*!40000 ALTER TABLE `faceClusterSuggestion` DISABLE KEYS */; /*!40000 ALTER TABLE `faceClusterSuggestion` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faceClusterTable` -- DROP TABLE IF EXISTS `faceClusterTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceClusterTable` ( `ClusterId` bigint(20) NOT NULL AUTO_INCREMENT, `KeyFaceId` bigint(20) DEFAULT NULL, `IsHidden` tinyint(4) DEFAULT 0, `NoMerge` tinyint(4) NOT NULL DEFAULT 0, PRIMARY KEY (`ClusterId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceClusterTable` -- LOCK TABLES `faceClusterTable` WRITE; /*!40000 ALTER TABLE `faceClusterTable` DISABLE KEYS */; /*!40000 ALTER TABLE `faceClusterTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER update_faceClusterTable AFTER UPDATE ON faceClusterTable FOR EACH ROW BEGIN UPDATE faceGroupTable a JOIN faceGroupClusterMapping b ON a.GroupId = b.GroupId JOIN faceClusterTable c ON b.ClusterId = c.ClusterId SET a.KeyFaceId = new.KeyFaceId WHERE a.KeyFaceId = old.KeyFaceId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_faceClusterTable AFTER DELETE ON faceClusterTable FOR EACH ROW BEGIN UPDATE faceGroupTable fgt SET KeyFaceId = ( SELECT keyfaceid FROM faceClusterTable WHERE ClusterId = ( SELECT MIN(ClusterId) FROM faceGroupClusterMapping WHERE groupid = fgt.groupid AND ClusterId != old.ClusterId ) ) WHERE fgt.keyfaceid = old.KeyFaceId; DELETE FROM faceGroupClusterMapping WHERE ClusterId = old.ClusterId; DELETE from faceClusterSuggestion where ClusterId = old.ClusterId; DELETE from faceClusterSuggestion where SuggestClusterId = old.ClusterId; DELETE from albumViewHistory where AlbumType = 1 and AlbumSubtype = 1 and AlbumId = old.ClusterId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `faceFeatureTable` -- DROP TABLE IF EXISTS `faceFeatureTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceFeatureTable` ( `FeatureId` bigint(20) NOT NULL AUTO_INCREMENT, `FaceId` bigint(20) DEFAULT NULL, `Version` char(16) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `Description` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '', `Data` blob NOT NULL, `DataHash` char(64) CHARACTER SET ascii COLLATE ascii_general_ci GENERATED ALWAYS AS (md5(`Data`)) STORED, PRIMARY KEY (`FeatureId`), UNIQUE KEY `FaceId` (`FaceId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceFeatureTable` -- LOCK TABLES `faceFeatureTable` WRITE; /*!40000 ALTER TABLE `faceFeatureTable` DISABLE KEYS */; /*!40000 ALTER TABLE `faceFeatureTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faceGroupArchive` -- DROP TABLE IF EXISTS `faceGroupArchive`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceGroupArchive` ( `GroupId` bigint(20) NOT NULL, `uid` int(11) NOT NULL, `TagName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `KeyFacePictureId` bigint(20) DEFAULT NULL, `ShareType` int(11) DEFAULT NULL, PRIMARY KEY (`GroupId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceGroupArchive` -- LOCK TABLES `faceGroupArchive` WRITE; /*!40000 ALTER TABLE `faceGroupArchive` DISABLE KEYS */; /*!40000 ALTER TABLE `faceGroupArchive` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faceGroupArchivePictureMapping` -- DROP TABLE IF EXISTS `faceGroupArchivePictureMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceGroupArchivePictureMapping` ( `GroupId` bigint(20) NOT NULL, `iPictureId` bigint(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceGroupArchivePictureMapping` -- LOCK TABLES `faceGroupArchivePictureMapping` WRITE; /*!40000 ALTER TABLE `faceGroupArchivePictureMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `faceGroupArchivePictureMapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faceGroupClusterMapping` -- DROP TABLE IF EXISTS `faceGroupClusterMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceGroupClusterMapping` ( `GroupId` bigint(20) NOT NULL, `ClusterId` bigint(20) NOT NULL, UNIQUE KEY `GroupId` (`GroupId`,`ClusterId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceGroupClusterMapping` -- LOCK TABLES `faceGroupClusterMapping` WRITE; /*!40000 ALTER TABLE `faceGroupClusterMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `faceGroupClusterMapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faceGroupClusterSummary` -- DROP TABLE IF EXISTS `faceGroupClusterSummary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceGroupClusterSummary` ( `uid` int(11) NOT NULL, `ItemType` enum('Group','Cluster') NOT NULL, `ItemId` bigint(20) NOT NULL, `ItemName` varchar(255) DEFAULT NULL, `ItemKeyFace` bigint(20) NOT NULL, `AlbumCover` bigint(20) NOT NULL, `CoverWidth` int(11) DEFAULT NULL, `CoverHeight` int(11) DEFAULT NULL, `PhotoCount` bigint(20) NOT NULL DEFAULT 0, KEY `idx_uid_ItemType_PhotoCount` (`uid`,`ItemType`,`PhotoCount`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceGroupClusterSummary` -- LOCK TABLES `faceGroupClusterSummary` WRITE; /*!40000 ALTER TABLE `faceGroupClusterSummary` DISABLE KEYS */; /*!40000 ALTER TABLE `faceGroupClusterSummary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faceGroupTable` -- DROP TABLE IF EXISTS `faceGroupTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceGroupTable` ( `GroupId` bigint(20) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `TagName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `KeyFaceId` bigint(20) DEFAULT NULL, `ShareType` int(11) DEFAULT NULL, PRIMARY KEY (`GroupId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceGroupTable` -- LOCK TABLES `faceGroupTable` WRITE; /*!40000 ALTER TABLE `faceGroupTable` DISABLE KEYS */; /*!40000 ALTER TABLE `faceGroupTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_faceGroupTable AFTER DELETE ON faceGroupTable FOR EACH ROW BEGIN DELETE FROM faceGroupClusterMapping WHERE GroupId = old.GroupId; DELETE from albumViewHistory where AlbumType = 1 and AlbumSubtype = 0 and AlbumId = old.GroupId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `faceTable` -- DROP TABLE IF EXISTS `faceTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faceTable` ( `FaceId` bigint(20) NOT NULL AUTO_INCREMENT, `iPictureId` bigint(20) NOT NULL, `X` int(11) DEFAULT NULL, `Y` int(11) DEFAULT NULL, `Width` int(11) DEFAULT NULL, `Height` int(11) DEFAULT NULL, `ClusterId` bigint(20) DEFAULT NULL, `MigrateNameId` bigint(20) DEFAULT NULL, `Gender` varchar(8) DEFAULT NULL, `Age` int(11) DEFAULT NULL, `Yaw` float DEFAULT NULL, `Pitch` float DEFAULT NULL, `Roll` float DEFAULT NULL, `Passerby` int(11) DEFAULT NULL, `MaskType` tinyint(4) DEFAULT NULL, `GroupId` bigint(20) DEFAULT NULL, PRIMARY KEY (`FaceId`), KEY `idx_iPictureId` (`iPictureId`), KEY `idx_ClusterId` (`ClusterId`), KEY `idx_cluster_pic_face` (`ClusterId`,`iPictureId`,`FaceId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faceTable` -- LOCK TABLES `faceTable` WRITE; /*!40000 ALTER TABLE `faceTable` DISABLE KEYS */; /*!40000 ALTER TABLE `faceTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_faceTable AFTER DELETE ON faceTable FOR EACH ROW BEGIN DELETE FROM faceClusterTable WHERE NOT EXISTS ( SELECT * FROM faceTable WHERE ClusterId = old.ClusterId ) AND ClusterId = old.ClusterId; SET @KeyFaceId = (SELECT KeyFaceId from faceClusterTable where ClusterId = old.ClusterId); IF old.FaceId = @KeyFaceId THEN SET @MinFaceId = (SELECT MIN(FaceId) from faceTable where ClusterId = old.ClusterId); UPDATE faceClusterTable SET KeyFaceId = @MinFaceId where ClusterId = old.ClusterId; END IF; DELETE FROM faceFeatureTable WHERE FaceId = old.FaceId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `favoriteContent` -- DROP TABLE IF EXISTS `favoriteContent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `favoriteContent` ( `MediaType` tinyint(4) NOT NULL, `MediaId` bigint(20) NOT NULL, `UserId` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `MediaType` (`MediaType`,`MediaId`,`UserId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `favoriteContent` -- LOCK TABLES `favoriteContent` WRITE; /*!40000 ALTER TABLE `favoriteContent` DISABLE KEYS */; /*!40000 ALTER TABLE `favoriteContent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `flagSummary` -- DROP TABLE IF EXISTS `flagSummary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `flagSummary` ( `MediaType` tinyint(4) NOT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ScannedFlag` int(11) DEFAULT 0, `FacialFlag` int(11) DEFAULT 0, `ImgClassFlag` tinyint(4) NOT NULL DEFAULT 0, `SimilarFlag` tinyint(4) NOT NULL DEFAULT 0, `Cnt` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `MediaType` (`MediaType`,`InvalidFlag`,`ScannedFlag`,`FacialFlag`,`ImgClassFlag`,`SimilarFlag`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `flagSummary` -- LOCK TABLES `flagSummary` WRITE; /*!40000 ALTER TABLE `flagSummary` DISABLE KEYS */; INSERT INTO `flagSummary` VALUES (1,0,1,16,0,0,13,'2024-12-06 07:33:03'); /*!40000 ALTER TABLE `flagSummary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `genreTable` -- DROP TABLE IF EXISTS `genreTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `genreTable` ( `iGenreId` bigint(20) NOT NULL AUTO_INCREMENT, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iGenreId`), UNIQUE KEY `cGenreName` (`cGenreName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `genre_cGenreName` (`cGenreName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `genreTable` -- LOCK TABLES `genreTable` WRITE; /*!40000 ALTER TABLE `genreTable` DISABLE KEYS */; /*!40000 ALTER TABLE `genreTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `keySummary` -- DROP TABLE IF EXISTS `keySummary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `keySummary` ( `MediaType` tinyint(4) NOT NULL, `Classifier` varchar(32) NOT NULL, `KeyName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `DisplayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `Value` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `MediaType` (`MediaType`,`Classifier`,`KeyName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `keySummary` -- LOCK TABLES `keySummary` WRITE; /*!40000 ALTER TABLE `keySummary` DISABLE KEYS */; /*!40000 ALTER TABLE `keySummary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mediaPick` -- DROP TABLE IF EXISTS `mediaPick`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mediaPick` ( `MediaId` bigint(20) NOT NULL, `MediaType` tinyint(3) unsigned NOT NULL, `dateTime` bigint(20) DEFAULT NULL, `YearMonthDay` char(12) DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `MediaTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `iWidth` int(11) DEFAULT NULL, `iHeight` int(11) DEFAULT NULL, `appleAssetId` varchar(64) DEFAULT NULL, `ThumbSetting` text DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`MediaType`,`MediaId`), KEY `idx_dt_ty_id` (`dateTime`,`MediaType`,`MediaId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mediaPick` -- LOCK TABLES `mediaPick` WRITE; /*!40000 ALTER TABLE `mediaPick` DISABLE KEYS */; /*!40000 ALTER TABLE `mediaPick` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mediaPick_5_0` -- DROP TABLE IF EXISTS `mediaPick_5_0`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mediaPick_5_0` ( `MediaId` bigint(20) NOT NULL, `MediaType` tinyint(3) unsigned NOT NULL, `dateTime` bigint(20) DEFAULT NULL, `YearMonthDay` char(12) DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `MediaTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `iWidth` int(11) DEFAULT NULL, `iHeight` int(11) DEFAULT NULL, `appleAssetId` varchar(64) DEFAULT NULL, `ThumbSetting` text DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`MediaType`,`MediaId`), KEY `idx_dt_ty_id` (`dateTime`,`MediaType`,`MediaId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mediaPick_5_0` -- LOCK TABLES `mediaPick_5_0` WRITE; /*!40000 ALTER TABLE `mediaPick_5_0` DISABLE KEYS */; INSERT INTO `mediaPick_5_0` VALUES (21,1,1732889030,'2024-11-29',1732881835,1732881830,'sample01',8,601,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(22,1,1732889030,'2024-11-29',1732881835,1732881830,'sample02',8,597,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(23,1,1732889030,'2024-11-29',1732881835,1732881830,'sample03',8,602,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(24,1,1732889030,'2024-11-29',1732881835,1732881830,'sample04',8,400,617,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(25,1,1732889030,'2024-11-29',1732881835,1732881830,'sample05',8,400,597,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(26,1,1732889030,'2024-11-29',1732881835,1732881830,'sample06',8,400,611,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(27,1,1732889030,'2024-11-29',1732881836,1732881830,'sample07',8,602,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(28,1,1732889030,'2024-11-29',1732881836,1732881830,'sample08',8,400,597,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(29,1,1732889030,'2024-11-29',1732881837,1732881830,'sample09',8,597,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(30,1,1732889030,'2024-11-29',1732881837,1732881830,'sample10',8,614,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(31,1,1732889030,'2024-11-29',1732881837,1732881830,'sample11',8,533,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(32,1,1732889030,'2024-11-29',1732881837,1732881830,'sample12',8,533,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'),(33,1,1732889030,'2024-11-29',1732881838,1732881830,'sample13',8,606,400,NULL,'{\"4k\":1,\"quality\":1}','2024-11-29 12:58:12'); /*!40000 ALTER TABLE `mediaPick_5_0` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mediaPick_5_500` -- DROP TABLE IF EXISTS `mediaPick_5_500`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mediaPick_5_500` ( `MediaId` bigint(20) NOT NULL, `MediaType` tinyint(3) unsigned NOT NULL, `dateTime` bigint(20) DEFAULT NULL, `YearMonthDay` char(12) DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `MediaTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `iWidth` int(11) DEFAULT NULL, `iHeight` int(11) DEFAULT NULL, `appleAssetId` varchar(64) DEFAULT NULL, `ThumbSetting` text DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`MediaType`,`MediaId`), KEY `idx_dt_ty_id` (`dateTime`,`MediaType`,`MediaId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mediaPick_5_500` -- LOCK TABLES `mediaPick_5_500` WRITE; /*!40000 ALTER TABLE `mediaPick_5_500` DISABLE KEYS */; /*!40000 ALTER TABLE `mediaPick_5_500` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mediaPick_5_501` -- DROP TABLE IF EXISTS `mediaPick_5_501`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mediaPick_5_501` ( `MediaId` bigint(20) NOT NULL, `MediaType` tinyint(3) unsigned NOT NULL, `dateTime` bigint(20) DEFAULT NULL, `YearMonthDay` char(12) DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `MediaTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `iWidth` int(11) DEFAULT NULL, `iHeight` int(11) DEFAULT NULL, `appleAssetId` varchar(64) DEFAULT NULL, `ThumbSetting` text DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`MediaType`,`MediaId`), KEY `idx_dt_ty_id` (`dateTime`,`MediaType`,`MediaId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mediaPick_5_501` -- LOCK TABLES `mediaPick_5_501` WRITE; /*!40000 ALTER TABLE `mediaPick_5_501` DISABLE KEYS */; /*!40000 ALTER TABLE `mediaPick_5_501` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `objDeletionTable` -- DROP TABLE IF EXISTS `objDeletionTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `objDeletionTable` ( `Id` bigint(20) NOT NULL AUTO_INCREMENT, `iMediaId` bigint(20) NOT NULL, `type` int(11) NOT NULL, `iStorageId` int(11) DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `cFileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `cFullPath` varchar(1023) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`Id`), KEY `idx_objdel_dirid_imediaid` (`iDirId`,`iMediaId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `objDeletionTable` -- LOCK TABLES `objDeletionTable` WRITE; /*!40000 ALTER TABLE `objDeletionTable` DISABLE KEYS */; /*!40000 ALTER TABLE `objDeletionTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureAlbumMapping` -- DROP TABLE IF EXISTS `pictureAlbumMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureAlbumMapping` ( `iMediaId` bigint(20) DEFAULT NULL, `type` int(11) DEFAULT NULL, `iPhotoAlbumId` bigint(20) DEFAULT NULL, `iOrder` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iMediaId` (`iMediaId`,`type`,`iPhotoAlbumId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_pictureAlbumMapping_iPhotoAlbumId` (`iPhotoAlbumId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureAlbumMapping` -- LOCK TABLES `pictureAlbumMapping` WRITE; /*!40000 ALTER TABLE `pictureAlbumMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureAlbumMapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureAlbumTable` -- DROP TABLE IF EXISTS `pictureAlbumTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureAlbumTable` ( `iPhotoAlbumId` bigint(20) NOT NULL AUTO_INCREMENT, `cAlbumTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `DateCreated` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `albumType` int(11) DEFAULT NULL, `iAlbumCover` bigint(20) DEFAULT NULL, `Config` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `owner` bigint(20) DEFAULT NULL, `expiration` bigint(20) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `ParentAlbumId` bigint(20) DEFAULT NULL, `IsRecommended` tinyint(4) NOT NULL DEFAULT 1, PRIMARY KEY (`iPhotoAlbumId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `pictureAlbum_cAlbumTitle` (`cAlbumTitle`), KEY `pictureAlbum_ParentAlbumId` (`ParentAlbumId`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureAlbumTable` -- LOCK TABLES `pictureAlbumTable` WRITE; /*!40000 ALTER TABLE `pictureAlbumTable` DISABLE KEYS */; INSERT INTO `pictureAlbumTable` VALUES (4,'Images',1732872868,1732882909,14,NULL,'{\"filters\":{\"source\":{\"shared\":true,\"private\":false,\"qsync\":false},\"folders\":[]},\"_internal\":{\"x_read\":\"0|admin,500|BHDirector,502|ImageLogin02\",\"x_manage\":\"0|admin,500|BHDirector,502|ImageLogin02\",\"x_group_read\":\"0|administrators,100|everyone\",\"x_group_manage\":\"0|administrators\",\"cacheStatus\":\"\"}}',0,0,0,500,0,'2024-11-29 12:21:49',NULL,1),(6,'Images02',1732881937,1732883604,114,NULL,'{\"filters\":{\"source\":{\"shared\":true,\"private\":false,\"qsync\":false},\"folders\":[]},\"_internal\":{\"x_read\":\"0|admin,500|BHDirector\",\"x_manage\":\"0|admin,500|BHDirector\",\"x_group_read\":\"0|administrators,100|everyone\",\"x_group_manage\":\"0|administrators\"},\"password\":\"biancavv1703\"}',0,0,0,500,0,'2024-11-29 12:33:24',NULL,1); /*!40000 ALTER TABLE `pictureAlbumTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_pictureAlbumTable AFTER DELETE ON pictureAlbumTable FOR EACH ROW BEGIN DELETE FROM pictureAlbumMapping WHERE iPhotoAlbumId = old.iPhotoAlbumId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `pictureColorMapping` -- DROP TABLE IF EXISTS `pictureColorMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureColorMapping` ( `iPictureId` bigint(20) NOT NULL, `ColorCode` tinyint(4) NOT NULL, PRIMARY KEY (`iPictureId`,`ColorCode`), KEY `ColorCode` (`ColorCode`,`iPictureId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureColorMapping` -- LOCK TABLES `pictureColorMapping` WRITE; /*!40000 ALTER TABLE `pictureColorMapping` DISABLE KEYS */; INSERT INTO `pictureColorMapping` VALUES (21,4),(22,9),(23,5),(24,5),(25,5),(26,1),(28,10),(29,5),(30,1),(32,2); /*!40000 ALTER TABLE `pictureColorMapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureFaceNameSuggestionTable` -- DROP TABLE IF EXISTS `pictureFaceNameSuggestionTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureFaceNameSuggestionTable` ( `FaceId` int(11) NOT NULL, `NameId` int(11) NOT NULL, `Rank` int(11) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureFaceNameSuggestionTable` -- LOCK TABLES `pictureFaceNameSuggestionTable` WRITE; /*!40000 ALTER TABLE `pictureFaceNameSuggestionTable` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureFaceNameSuggestionTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureFaceNameTable` -- DROP TABLE IF EXISTS `pictureFaceNameTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureFaceNameTable` ( `NameId` int(11) NOT NULL AUTO_INCREMENT, `iPictureId` bigint(20) DEFAULT NULL, `Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`NameId`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureFaceNameTable` -- LOCK TABLES `pictureFaceNameTable` WRITE; /*!40000 ALTER TABLE `pictureFaceNameTable` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureFaceNameTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureFaceTable` -- DROP TABLE IF EXISTS `pictureFaceTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureFaceTable` ( `FaceId` int(11) NOT NULL, `iPictureId` bigint(20) DEFAULT NULL, `NameId` int(11) DEFAULT NULL, `X` int(11) DEFAULT NULL, `Y` int(11) DEFAULT NULL, `Width` int(11) DEFAULT NULL, `Height` int(11) DEFAULT NULL, `GroupId` int(11) DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`FaceId`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureFaceTable` -- LOCK TABLES `pictureFaceTable` WRITE; /*!40000 ALTER TABLE `pictureFaceTable` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureFaceTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_pictureFaceTable AFTER DELETE ON pictureFaceTable FOR EACH ROW BEGIN DELETE FROM pictureFaceNameSuggestionTable WHERE FaceId = old.FaceId; DELETE FROM pictureFaceNameTable WHERE NOT EXISTS ( SELECT * FROM pictureFaceTable WHERE NameId = old.NameId ) AND NameId = old.NameId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `pictureImageClassSummary` -- DROP TABLE IF EXISTS `pictureImageClassSummary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureImageClassSummary` ( `ImgClass` smallint(6) NOT NULL, `uid` int(11) NOT NULL DEFAULT 0, `cnt` bigint(20) NOT NULL DEFAULT 0, `ipictureid` bigint(20) NOT NULL DEFAULT 0 ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureImageClassSummary` -- LOCK TABLES `pictureImageClassSummary` WRITE; /*!40000 ALTER TABLE `pictureImageClassSummary` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureImageClassSummary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureImgClass` -- DROP TABLE IF EXISTS `pictureImgClass`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureImgClass` ( `ImgClassId` smallint(6) NOT NULL, `ModelId` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Category` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_cs_CZ` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_da_DK` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_de_DE` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_el_GR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_en_US` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_es_ES` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_es_MX` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_fi_FI` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_fr_FR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_hu_HU` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_it_IT` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ja_JP` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ko_KR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_nl_NL` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_no_NO` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_pl_PL` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_pt_BR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ro_RO` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ru_RU` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_sv_SE` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_th_TH` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_tr_TR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_zh_CN` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_zh_TW` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `CategoryId` smallint(6) DEFAULT NULL, PRIMARY KEY (`ImgClassId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureImgClass` -- LOCK TABLES `pictureImgClass` WRITE; /*!40000 ALTER TABLE `pictureImgClass` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureImgClass` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureImgClassCategory` -- DROP TABLE IF EXISTS `pictureImgClassCategory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureImgClassCategory` ( `CategoryId` smallint(6) NOT NULL, `Description_cs_CZ` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_da_DK` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_de_DE` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_el_GR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_en_US` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_es_ES` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_es_MX` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_fi_FI` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_fr_FR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_hu_HU` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_it_IT` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ja_JP` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ko_KR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_nl_NL` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_no_NO` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_pl_PL` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_pt_BR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ro_RO` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_ru_RU` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_sv_SE` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_th_TH` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_tr_TR` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_zh_CN` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Description_zh_TW` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, PRIMARY KEY (`CategoryId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureImgClassCategory` -- LOCK TABLES `pictureImgClassCategory` WRITE; /*!40000 ALTER TABLE `pictureImgClassCategory` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureImgClassCategory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureImgClassError` -- DROP TABLE IF EXISTS `pictureImgClassError`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureImgClassError` ( `uid` int(11) NOT NULL DEFAULT 0, `iPictureId` bigint(20) NOT NULL DEFAULT 0, `ImgClass` smallint(6) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureImgClassError` -- LOCK TABLES `pictureImgClassError` WRITE; /*!40000 ALTER TABLE `pictureImgClassError` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureImgClassError` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureImgClassMapping` -- DROP TABLE IF EXISTS `pictureImgClassMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureImgClassMapping` ( `iPictureId` bigint(20) NOT NULL DEFAULT 0, `ImgClass` smallint(6) NOT NULL DEFAULT 0, `Score` smallint(6) NOT NULL DEFAULT 0, KEY `idx_pic_ic_score` (`iPictureId`,`ImgClass`,`Score`), KEY `idx_ic_pic` (`ImgClass`,`iPictureId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureImgClassMapping` -- LOCK TABLES `pictureImgClassMapping` WRITE; /*!40000 ALTER TABLE `pictureImgClassMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureImgClassMapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureImgClassSynonym` -- DROP TABLE IF EXISTS `pictureImgClassSynonym`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureImgClassSynonym` ( `ImgClassId` smallint(6) DEFAULT NULL, `Language` char(7) DEFAULT NULL, `Synonym` varchar(63) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, KEY `idx_lang_syn_ic` (`Language`,`Synonym`,`ImgClassId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureImgClassSynonym` -- LOCK TABLES `pictureImgClassSynonym` WRITE; /*!40000 ALTER TABLE `pictureImgClassSynonym` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureImgClassSynonym` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureImgHash` -- DROP TABLE IF EXISTS `pictureImgHash`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureImgHash` ( `image_id` bigint(20) NOT NULL, `hash8` tinyint(4) NOT NULL DEFAULT 0, `hash12` smallint(6) NOT NULL DEFAULT 0, `hash16` smallint(6) NOT NULL DEFAULT 0, `hash20` mediumint(9) NOT NULL DEFAULT 0, `hash24` mediumint(9) NOT NULL DEFAULT 0, `hash28` int(11) NOT NULL DEFAULT 0, `hash32` int(11) NOT NULL DEFAULT 0, `hash64` bigint(20) NOT NULL DEFAULT 0, UNIQUE KEY `image_id` (`image_id`), UNIQUE KEY `index_image_id` (`image_id`), KEY `index_hash8` (`hash8`), KEY `index_hash12` (`hash12`), KEY `index_hash16` (`hash16`), KEY `index_hash20` (`hash20`), KEY `index_hash24` (`hash24`), KEY `index_hash28` (`hash28`), KEY `index_hash32` (`hash32`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureImgHash` -- LOCK TABLES `pictureImgHash` WRITE; /*!40000 ALTER TABLE `pictureImgHash` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureImgHash` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureKeyWordMapping` -- DROP TABLE IF EXISTS `pictureKeyWordMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureKeyWordMapping` ( `iMediaId` bigint(20) DEFAULT NULL, `type` int(11) DEFAULT NULL, `iKeyWordId` bigint(20) DEFAULT NULL, `iOrder` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `cKeyWord` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iMediaId` (`iMediaId`,`type`,`iKeyWordId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_pictureKeyWordMapping_iKeyWordId` (`iKeyWordId`), KEY `idx_pictureKeyWordMapping_cKeyWord` (`cKeyWord`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureKeyWordMapping` -- LOCK TABLES `pictureKeyWordMapping` WRITE; /*!40000 ALTER TABLE `pictureKeyWordMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureKeyWordMapping` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_pictureKeyWordMapping AFTER DELETE ON pictureKeyWordMapping FOR EACH ROW BEGIN DELETE FROM pictureKeyWordTable WHERE NOT EXISTS ( SELECT * FROM pictureKeyWordMapping WHERE iKeyWordId = old.iKeyWordId ) AND iKeyWordId = old.iKeyWordId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `pictureKeyWordTable` -- DROP TABLE IF EXISTS `pictureKeyWordTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureKeyWordTable` ( `iKeyWordId` bigint(20) NOT NULL AUTO_INCREMENT, `cKeyWord` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iKeyWordId`), UNIQUE KEY `cKeyWord` (`cKeyWord`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `pictureKeyWord_cKeyWord` (`cKeyWord`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureKeyWordTable` -- LOCK TABLES `pictureKeyWordTable` WRITE; /*!40000 ALTER TABLE `pictureKeyWordTable` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureKeyWordTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_pictureKeyWordTable AFTER DELETE ON pictureKeyWordTable FOR EACH ROW BEGIN DELETE from albumViewHistory where AlbumType = 3 and AlbumId = old.iKeyWordId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `pictureMyFavorite` -- DROP TABLE IF EXISTS `pictureMyFavorite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureMyFavorite` ( `iPictureId` bigint(20) DEFAULT NULL, `UserId` bigint(20) DEFAULT NULL, `AddTime` bigint(20) DEFAULT NULL, `iRating` int(11) NOT NULL DEFAULT 100, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iPictureId` (`iPictureId`,`UserId`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureMyFavorite` -- LOCK TABLES `pictureMyFavorite` WRITE; /*!40000 ALTER TABLE `pictureMyFavorite` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureMyFavorite` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictureTable` -- DROP TABLE IF EXISTS `pictureTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureTable` ( `iPictureId` bigint(20) NOT NULL AUTO_INCREMENT, `cFileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `DateCreated` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `iFileSize` bigint(20) DEFAULT NULL, `YearMonth` char(8) DEFAULT NULL, `YearMonthDay` char(12) DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `iStorageId` int(11) DEFAULT NULL, `iWidth` int(11) DEFAULT NULL, `iHeight` int(11) DEFAULT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `mime` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `dlna_pn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `cPictureTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `longitude` bigint(20) DEFAULT NULL, `latitude` bigint(20) DEFAULT NULL, `location` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `lensInfo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `thumbnail` int(11) DEFAULT NULL, `iLike` int(11) DEFAULT 0, `iDislike` int(11) DEFAULT 0, `ChromSample` int(11) DEFAULT -1, `ColorLevel` int(11) DEFAULT 0, `dateTime` bigint(20) DEFAULT NULL, `Aperture` int(11) DEFAULT NULL, `Exposure` int(11) DEFAULT NULL, `ISO` int(11) DEFAULT NULL, `Maker` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Model` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `FocalLength` int(11) DEFAULT NULL, `WhiteBalance` int(11) DEFAULT NULL, `FlashFiring` int(11) DEFAULT NULL, `MeteringMode` int(11) DEFAULT NULL, `Orientation` int(11) DEFAULT 1, `ScannedFlag` int(11) DEFAULT 0, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `FormatId` int(11) DEFAULT 0, `AttrFlag` int(11) NOT NULL DEFAULT 0, `iRating` int(11) DEFAULT NULL, `FacialFlag` int(11) DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `QtagId` char(64) DEFAULT NULL, `ProjectionType` tinyint(4) NOT NULL DEFAULT 0, `PrevInvalidFlag` int(11) NOT NULL DEFAULT 0, `ThumbSetting` text DEFAULT NULL, `longitudeDegree` decimal(11,8) DEFAULT NULL, `latitudeDegree` decimal(11,8) DEFAULT NULL, `geohash1` char(1) DEFAULT NULL, `geohash2` char(2) DEFAULT NULL, `geohash3` char(3) DEFAULT NULL, `geohash4` char(4) DEFAULT NULL, `geohash5` char(5) DEFAULT NULL, `geohash6` char(6) DEFAULT NULL, `geohash7` char(7) DEFAULT NULL, `geohash8` char(8) DEFAULT NULL, `ImgClassFlag` tinyint(4) NOT NULL DEFAULT 0, `appleAssetId` varchar(64) DEFAULT NULL, `BurstUUID` varchar(64) DEFAULT NULL, `userRating` int(11) DEFAULT 0, `OsmFlag` tinyint(4) NOT NULL DEFAULT 0, `AddrId` bigint(20) DEFAULT NULL, `FileHash` varbinary(32) DEFAULT NULL, `CaptureCat` tinyint(4) NOT NULL DEFAULT 0, `CatCover` bigint(20) NOT NULL DEFAULT -1, `ImageHash` varbinary(16) DEFAULT NULL, `IsRecommended` tinyint(4) NOT NULL DEFAULT 1, `ImageQuality` float DEFAULT NULL, `ImageAesthetic` float DEFAULT NULL, `ImageScore` float NOT NULL DEFAULT 0, `SimilarFlag` tinyint(4) NOT NULL DEFAULT 0, `SelectedFlag` tinyint(4) NOT NULL DEFAULT 0, `FocalLengthDec` smallint(5) unsigned DEFAULT NULL, `ExposureDec` double DEFAULT NULL, `ApertureDec` smallint(5) unsigned DEFAULT NULL, `FaceGroupCount` smallint(6) NOT NULL DEFAULT 0, `ColorCodeFlag` tinyint(4) NOT NULL DEFAULT 0, PRIMARY KEY (`iPictureId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_QtagId` (`QtagId`), KEY `idx_pictureTable_YearMonth` (`YearMonth` DESC), KEY `idx_pictureTable_YearMonthDay` (`YearMonthDay` DESC,`dateTime` DESC), KEY `idx_pictureTable_cPictureTitle` (`cPictureTitle`), KEY `idx_pictureTable_dateTime` (`dateTime`), KEY `idx_pictureTable_addToDbTime` (`AddToDbTime`), KEY `idx_pictureTable_iDirId` (`iDirId`), KEY `idx_geohash1` (`geohash1`), KEY `idx_geohash2` (`geohash2`), KEY `idx_geohash3` (`geohash3`), KEY `idx_geohash4` (`geohash4`), KEY `idx_geohash5` (`geohash5`), KEY `idx_geohash6` (`geohash6`), KEY `idx_geohash7` (`geohash7`), KEY `idx_geohash8` (`geohash8`), KEY `idx_appleAssetId` (`appleAssetId`), KEY `idx_size_hash_id` (`iFileSize`,`FileHash`,`iPictureId`), KEY `idx_imghash` (`ImageHash`), KEY `idx_cat_cover_id` (`CatCover`,`iPictureId`), KEY `idx_burstuuid` (`BurstUUID`,`iPictureId`), KEY `idx_addr` (`AddrId`), KEY `idx_inv_scan_prot_ymd_dir` (`InvalidFlag`,`ScannedFlag`,`ProtectionStatus`,`YearMonthDay`,`iDirId`), KEY `idx_inv_scan_id_flags` (`InvalidFlag`,`ScannedFlag`,`iPictureId`,`FacialFlag`,`ImgClassFlag`,`OsmFlag`,`SimilarFlag`,`SelectedFlag`), KEY `idx_FocalLengthDec` (`FocalLengthDec`), KEY `idx_ExposureDec` (`ExposureDec`), KEY `idx_ApertureDec` (`ApertureDec`), KEY `idx_FaceGroupCount` (`FaceGroupCount`) ) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureTable` -- LOCK TABLES `pictureTable` WRITE; /*!40000 ALTER TABLE `pictureTable` DISABLE KEYS */; INSERT INTO `pictureTable` VALUES (21,'sample01.jpg',8,0,393237,1732881830,1732881830,28885,'2024-11','2024-11-29',1732881835,1,601,400,'','image/jpeg','','sample01',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','15c37f3dc09f419fae7dda4d1f96a527245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(22,'sample02.jpg',8,0,393237,1732881830,1732881830,34473,'2024-11','2024-11-29',1732881835,1,597,400,'','image/jpeg','','sample02',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','01b6b0c564a04e7e90666f89b3accd92245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(23,'sample03.jpg',8,0,393237,1732881830,1732881830,62230,'2024-11','2024-11-29',1732881835,1,602,400,'','image/jpeg','','sample03',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','01d5aa63472a411f874a2a855369d70e245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(24,'sample04.jpg',8,0,393237,1732881830,1732881830,105797,'2024-11','2024-11-29',1732881835,1,400,617,'','image/jpeg','','sample04',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','9ca765c1e73c447fafe7b46dcabcfb3f245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(25,'sample05.jpg',8,0,393237,1732881830,1732881830,24130,'2024-11','2024-11-29',1732881835,1,400,597,'','image/jpeg','','sample05',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','75194bad1a794ab2bdb2ba60554f101b245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(26,'sample06.jpg',8,0,393237,1732881830,1732881830,39817,'2024-11','2024-11-29',1732881835,1,400,611,'','image/jpeg','','sample06',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','8420dbd6938a48aab6e1c7cc1dcd8a66245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(27,'sample07.jpg',8,0,393237,1732881830,1732881830,53895,'2024-11','2024-11-29',1732881836,1,602,400,'','image/jpeg','','sample07',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','bc5179b42e28473cad85c709e6b9b236245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(28,'sample08.jpg',8,0,393237,1732881830,1732881830,29696,'2024-11','2024-11-29',1732881836,1,400,597,'','image/jpeg','','sample08',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','e8b72434df474f63878939b33f4b5c90245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(29,'sample09.jpg',8,0,393237,1732881830,1732881830,20633,'2024-11','2024-11-29',1732881837,1,597,400,'','image/jpeg','','sample09',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','900d96ca29bd4cba9d09cc05d6c5eb9d245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(30,'sample10.jpg',8,0,393237,1732881830,1732881830,43640,'2024-11','2024-11-29',1732881837,1,614,400,'','image/jpeg','','sample10',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','3bfc8ce81be54880a755421b57925f28245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(31,'sample11.jpg',8,0,393237,1732881830,1732881830,43332,'2024-11','2024-11-29',1732881837,1,533,400,'','image/jpeg','','sample11',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','5361e1c2a115416d915cbd419b34d88c245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(32,'sample12.jpg',8,0,393237,1732881830,1732881830,40584,'2024-11','2024-11-29',1732881837,1,533,400,'','image/jpeg','','sample12',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','7dc5ec91c26641b0baab7b784a253aca245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1),(33,'sample13.jpg',8,0,393237,1732881830,1732881830,47711,'2024-11','2024-11-29',1732881838,1,606,400,'','image/jpeg','','sample13',0,0,NULL,'',0,0,0,12,0,1732889030,0,0,0,'','',0,0,0,0,1,1,0,1,0,0,16,'2024-11-29 12:58:12','08c595322ba749c1934c206ff672e369245ebe465ef7',0,0,'{\"4k\":1,\"quality\":1}',0.00000000,0.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,0,NULL,NULL,0,-1,NULL,1,NULL,NULL,0,0,0,0,0,0,0,1); /*!40000 ALTER TABLE `pictureTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER update_pictureTable AFTER UPDATE ON pictureTable FOR EACH ROW BEGIN UPDATE pictureKeyWordMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iMediaId = new.iPictureId AND type = 1; UPDATE pictureAlbumMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iMediaId = new.iPictureId AND type = 1; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_pictureTable AFTER DELETE ON pictureTable FOR EACH ROW BEGIN DELETE FROM pictureKeyWordMapping WHERE iMediaId = old.iPictureId AND type = 1; DELETE FROM playmediaTable WHERE iMediaId = old.iPictureId AND type = 1; DELETE FROM pictureMyFavorite WHERE iPictureId = old.iPictureId; DELETE FROM pictureAlbumMapping WHERE iMediaId = old.iPictureId AND type = 1; DELETE FROM pictureFaceTable WHERE iPictureId = old.iPictureId; UPDATE pictureFaceNameTable SET iPictureId = NULL WHERE iPictureId = old.iPictureId; SELECT iStorageId,cfullpath INTO @storage,@fullpath FROM dirTable where idirid = old.idirid; INSERT INTO objDeletionTable (iMediaId, type, iStorageId, iDirId, cFileName, cFullPath) VALUES (old.iPictureId, 1, @storage, old.idirid, old.cFileName, @fullpath); DELETE FROM faceTable WHERE iPictureId = old.iPictureId; DELETE FROM placeAddress WHERE NOT EXISTS ( SELECT AddrId FROM pictureTable WHERE AddrId = old.AddrId ) AND AddrId = old.AddrId; DELETE FROM pictureImgHash WHERE image_id = old.iPictureId; DELETE FROM pictureViewHistory WHERE iPictureId = old.iPictureId; DELETE FROM pictureColorMapping WHERE iPictureId = old.iPictureId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `pictureViewHistory` -- DROP TABLE IF EXISTS `pictureViewHistory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pictureViewHistory` ( `iPictureId` bigint(20) NOT NULL, `Uid` int(11) NOT NULL, `Cnt` int(11) NOT NULL DEFAULT 0, `LastView` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `Uid` (`Uid`,`iPictureId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictureViewHistory` -- LOCK TABLES `pictureViewHistory` WRITE; /*!40000 ALTER TABLE `pictureViewHistory` DISABLE KEYS */; /*!40000 ALTER TABLE `pictureViewHistory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `placeAddress` -- DROP TABLE IF EXISTS `placeAddress`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `placeAddress` ( `AddrId` bigint(20) NOT NULL AUTO_INCREMENT, `OsmType` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1: node, 2: way, 3: relation, 4: user-defined', `OsmId` varchar(31) NOT NULL DEFAULT '', `Addr_cs_CZ` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_da_DK` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_de_DE` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_el_GR` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_en_US` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_es_ES` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_fi_FI` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_fr_FR` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_hu_HU` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_it_IT` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_ja_JP` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_ko_KR` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_nl_NL` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_no_NO` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_pl_PL` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_pt_BR` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_ro_RO` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_ru_RU` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_sv_SE` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_th_TH` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_tr_TR` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_zh_CN` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Addr_zh_TW` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`AddrId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `placeAddress` -- LOCK TABLES `placeAddress` WRITE; /*!40000 ALTER TABLE `placeAddress` DISABLE KEYS */; /*!40000 ALTER TABLE `placeAddress` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_placeAddress AFTER DELETE ON placeAddress FOR EACH ROW BEGIN DELETE FROM placeAddressUnit WHERE AddrId = old.AddrId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `placeAddressUnit` -- DROP TABLE IF EXISTS `placeAddressUnit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `placeAddressUnit` ( `UnitId` bigint(20) NOT NULL AUTO_INCREMENT, `AddrId` bigint(20) NOT NULL, `Language` char(7) NOT NULL, `Position` tinyint(3) unsigned NOT NULL DEFAULT 0, `Unit` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Name` varchar(63) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`UnitId`), KEY `idx_addr_unit_name` (`Language`,`Name`,`AddrId`), KEY `idx_addr_unit_addrid` (`AddrId`), KEY `idx_addr_unit_addr_lang_unit` (`AddrId`,`Language`,`Unit`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `placeAddressUnit` -- LOCK TABLES `placeAddressUnit` WRITE; /*!40000 ALTER TABLE `placeAddressUnit` DISABLE KEYS */; /*!40000 ALTER TABLE `placeAddressUnit` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `playHistoryTable` -- DROP TABLE IF EXISTS `playHistoryTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playHistoryTable` ( `UserId` bigint(20) NOT NULL, `ClientType` tinyint(4) NOT NULL, `FullPath` varchar(1023) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `Position` char(11) DEFAULT NULL, `Offset` char(11) DEFAULT NULL, `MarkType` tinyint(4) DEFAULT NULL, `SubtitleFullPath` varchar(1023) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `EmbedSubtitle` tinyint(4) DEFAULT NULL, `SubEncoding` varchar(255) DEFAULT NULL, `AudioTrack` tinyint(4) DEFAULT NULL, `PlayHistoryId` bigint(20) NOT NULL AUTO_INCREMENT, `MediaType` tinyint(4) DEFAULT NULL, `MediaId` bigint(20) DEFAULT NULL, `MarkName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`PlayHistoryId`), KEY `idx_UserId` (`UserId`), KEY `idx_ClientType` (`ClientType`), KEY `idx_MediaId` (`MediaId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `playHistoryTable` -- LOCK TABLES `playHistoryTable` WRITE; /*!40000 ALTER TABLE `playHistoryTable` DISABLE KEYS */; /*!40000 ALTER TABLE `playHistoryTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `playlistTable` -- DROP TABLE IF EXISTS `playlistTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playlistTable` ( `iPlaylistId` bigint(20) NOT NULL AUTO_INCREMENT, `cPlaylistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cFileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `DateCreated` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `iFileSize` bigint(20) DEFAULT NULL, `iStorageId` int(11) DEFAULT NULL, `mime` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `dlna_pn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `owner` bigint(20) DEFAULT NULL, `playlistType` int(11) DEFAULT NULL, `expiration` bigint(20) DEFAULT 0, `Config` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `ScannedFlag` int(11) DEFAULT 0, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `AttrFlag` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `QtagId` char(64) DEFAULT NULL, `PrevInvalidFlag` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`iPlaylistId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_QtagId` (`QtagId`), KEY `playlist_cPlaylistName` (`cPlaylistName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `playlistTable` -- LOCK TABLES `playlistTable` WRITE; /*!40000 ALTER TABLE `playlistTable` DISABLE KEYS */; /*!40000 ALTER TABLE `playlistTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_playlistTable AFTER DELETE ON playlistTable FOR EACH ROW BEGIN DELETE FROM playmediaTable WHERE iPlaylistId = old.iPlaylistId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `playmediaTable` -- DROP TABLE IF EXISTS `playmediaTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playmediaTable` ( `iPlaylistId` bigint(20) DEFAULT NULL, `iOrderNr` bigint(20) DEFAULT 0, `iMediaId` bigint(20) DEFAULT NULL, `type` int(11) DEFAULT 0, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `uuid` bigint(20) DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_playmediaTable_iPlaylistId` (`iPlaylistId`), KEY `idx_playmedia_type_iMediaId` (`type`,`iMediaId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `playmediaTable` -- LOCK TABLES `playmediaTable` WRITE; /*!40000 ALTER TABLE `playmediaTable` DISABLE KEYS */; /*!40000 ALTER TABLE `playmediaTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_playmediaTable AFTER DELETE ON playmediaTable FOR EACH ROW BEGIN DELETE FROM ExSongTable WHERE old.type = 10 AND iExSongId = old.iMediaId AND ( NOT EXISTS ( SELECT * FROM playmediaTable WHERE type = old.type AND iMediaId = old.iMediaId ) ) AND ( NOT EXISTS ( SELECT * FROM songMyFavorite WHERE type = 10 AND iSongId = old.iMediaId ) ); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `songKeyWordMapping` -- DROP TABLE IF EXISTS `songKeyWordMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `songKeyWordMapping` ( `iSongId` bigint(20) DEFAULT NULL, `iKeyWordId` bigint(20) DEFAULT NULL, `iOrder` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `cKeyWord` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iSongId` (`iSongId`,`iKeyWordId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_songKeyWordMapping_iKeyWordId` (`iKeyWordId`), KEY `idx_songKeyWordMapping_cKeyWord` (`cKeyWord`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `songKeyWordMapping` -- LOCK TABLES `songKeyWordMapping` WRITE; /*!40000 ALTER TABLE `songKeyWordMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `songKeyWordMapping` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_songKeyWordMapping AFTER DELETE ON songKeyWordMapping FOR EACH ROW BEGIN DELETE FROM songKeyWordTable WHERE NOT EXISTS ( SELECT * FROM songKeyWordMapping WHERE iKeyWordId = old.iKeyWordId ) AND iKeyWordId = old.iKeyWordId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `songKeyWordTable` -- DROP TABLE IF EXISTS `songKeyWordTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `songKeyWordTable` ( `iKeyWordId` bigint(20) NOT NULL AUTO_INCREMENT, `cKeyWord` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iKeyWordId`), UNIQUE KEY `cKeyWord` (`cKeyWord`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `songKeyWord_cKeyWord` (`cKeyWord`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `songKeyWordTable` -- LOCK TABLES `songKeyWordTable` WRITE; /*!40000 ALTER TABLE `songKeyWordTable` DISABLE KEYS */; /*!40000 ALTER TABLE `songKeyWordTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `songMyFavorite` -- DROP TABLE IF EXISTS `songMyFavorite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `songMyFavorite` ( `iSongId` bigint(20) DEFAULT NULL, `UserId` bigint(20) DEFAULT NULL, `AddTime` bigint(20) DEFAULT NULL, `type` int(11) DEFAULT 0, `iRating` int(11) NOT NULL DEFAULT 100, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iSongId` (`iSongId`,`UserId`,`type`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `songMyFavorite` -- LOCK TABLES `songMyFavorite` WRITE; /*!40000 ALTER TABLE `songMyFavorite` DISABLE KEYS */; /*!40000 ALTER TABLE `songMyFavorite` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_songMyFavorite AFTER DELETE ON songMyFavorite FOR EACH ROW BEGIN DELETE FROM ExSongTable WHERE old.type = 10 AND iExSongId = old.iSongId AND ( NOT EXISTS ( SELECT * FROM playmediaTable WHERE type = 10 AND iMediaId = old.iSongId ) ) AND ( NOT EXISTS ( SELECT * FROM songMyFavorite WHERE type = 10 AND iSongId = old.iSongId ) ); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `songTable` -- DROP TABLE IF EXISTS `songTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `songTable` ( `iSongId` bigint(20) NOT NULL AUTO_INCREMENT, `cSongTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `iArtistId` bigint(20) DEFAULT NULL, `iAArtistId` bigint(20) DEFAULT NULL, `iAlbumId` bigint(20) DEFAULT NULL, `iTrackNr` int(11) DEFAULT NULL, `iTrackLength` int(11) DEFAULT NULL, `cFileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `iYear` int(11) DEFAULT NULL, `iGenreId` bigint(20) DEFAULT NULL, `iRating` int(11) DEFAULT NULL, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `UseCount` int(11) DEFAULT 0, `DateCreated` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `iFileSize` bigint(20) DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `iStorageId` int(11) DEFAULT NULL, `iSampleFrequency` int(11) DEFAULT NULL, `iBitrate` int(11) DEFAULT NULL, `AudioChannels` int(11) DEFAULT NULL, `mime` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `dlna_pn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `Disc` int(11) DEFAULT NULL, `cAlbumTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cAArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `iLike` int(11) DEFAULT 0, `iDislike` int(11) DEFAULT 0, `TranscodeStatus` int(11) DEFAULT 0, `FormatId` int(11) DEFAULT 0, `ACodecId` int(11) DEFAULT 0, `ProfileId` int(11) DEFAULT -99, `Level` int(11) DEFAULT -99, `RefId` int(11) NOT NULL DEFAULT 0, `StartTime` int(11) NOT NULL DEFAULT -1, `ScannedFlag` int(11) DEFAULT 0, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ContentType` int(11) DEFAULT 0, `AttrFlag` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `LastPlayed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `QtagId` char(64) DEFAULT NULL, `PrevInvalidFlag` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`iSongId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_QtagId` (`QtagId`), KEY `song_iGenreId` (`iGenreId`), KEY `song_iAlbumId` (`iAlbumId`), KEY `song_iArtistId` (`iArtistId`), KEY `song_iAArtistId` (`iAArtistId`), KEY `song_cSongTitle` (`cSongTitle`), KEY `idx_songTable_cArtistName` (`cArtistName`), KEY `idx_songTable_cAArtistName` (`cAArtistName`), KEY `idx_songTable_cGenreName` (`cGenreName`), KEY `idx_songTable_cAlbumTitle` (`cAlbumTitle`), KEY `idx_songTable_ScannedFlag` (`ScannedFlag`), KEY `idx_songTable_IDBStatus` (`IDBStatus`), KEY `idx_songTable_iDirId` (`iDirId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `songTable` -- LOCK TABLES `songTable` WRITE; /*!40000 ALTER TABLE `songTable` DISABLE KEYS */; /*!40000 ALTER TABLE `songTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER update_songTable AFTER UPDATE ON songTable FOR EACH ROW BEGIN UPDATE playmediaTable SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iMediaId = new.iSongId AND type = 0; UPDATE songMyFavorite SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iSongId = new.iSongId AND type = 0; UPDATE songKeyWordMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iSongId = new.iSongId; DELETE FROM playmediaTable WHERE InvalidFlag = 1; DELETE FROM songMyFavorite WHERE InvalidFlag = 1;END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_songTable AFTER DELETE ON songTable FOR EACH ROW BEGIN DELETE FROM albumTable WHERE NOT EXISTS ( SELECT * FROM songTable WHERE iAlbumId = old.iAlbumId ) AND iAlbumId = old.iAlbumId; DELETE FROM artistTable WHERE NOT EXISTS ( SELECT * FROM songTable WHERE iArtistId = old.iArtistId OR iAArtistId = old.iArtistId ) AND ( iArtistId = old.iArtistId ); DELETE FROM artistTable WHERE NOT EXISTS ( SELECT * FROM songTable WHERE iArtistId = old.iAArtistId OR iAArtistId = old.iAArtistId ) AND ( iArtistId = old.iAArtistId ); DELETE FROM genreTable WHERE NOT EXISTS ( SELECT * FROM songTable WHERE iGenreId = old.iGenreId ) AND iGenreId = old.iGenreId; DELETE FROM playmediaTable WHERE iMediaId = old.iSongId AND type = 0; DELETE FROM songMyFavorite WHERE iSongId = old.iSongId AND type = 0; DELETE FROM songKeyWordMapping WHERE iSongId = old.iSongId; SELECT iStorageId,cfullpath INTO @storage,@fullpath FROM dirTable where idirid = old.idirid; INSERT INTO objDeletionTable (iMediaId, type, iStorageId, iDirId, cFileName, cFullPath) VALUES (old.iSongId, 0, @storage, old.idirid, old.cFileName, @fullpath); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `subtypeTable` -- DROP TABLE IF EXISTS `subtypeTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subtypeTable` ( `MediaType` int(11) NOT NULL, `Id` int(11) NOT NULL, `Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `DisplayOrder` int(11) NOT NULL, `IsHidden` tinyint(1) DEFAULT 0, `InternalSubType` int(11) NOT NULL, `Scraper` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Lang` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, UNIQUE KEY `MediaType` (`MediaType`,`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subtypeTable` -- LOCK TABLES `subtypeTable` WRITE; /*!40000 ALTER TABLE `subtypeTable` DISABLE KEYS */; INSERT INTO `subtypeTable` VALUES (2,0,'Uncategorized',6,0,0,'',''),(2,1,'Movies',1,0,1,'IMDB','en'),(2,2,'TV Shows',2,0,2,'IMDBTV','en'),(2,3,'Music Videos',3,0,3,'IMDBTV','en'),(2,4,'Home Videos',4,0,4,'IMDBTV','en'),(2,5,'Karaoke',5,0,5,'DefaultKTV','en'); /*!40000 ALTER TABLE `subtypeTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `systemTable` -- DROP TABLE IF EXISTS `systemTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `systemTable` ( `iItemId` int(11) NOT NULL, `cItemValue` varchar(16) DEFAULT NULL, PRIMARY KEY (`iItemId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `systemTable` -- LOCK TABLES `systemTable` WRITE; /*!40000 ALTER TABLE `systemTable` DISABLE KEYS */; INSERT INTO `systemTable` VALUES (1,'3602012000'); /*!40000 ALTER TABLE `systemTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videoActorMapping` -- DROP TABLE IF EXISTS `videoActorMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoActorMapping` ( `iVideoId` bigint(20) DEFAULT NULL, `iActorId` bigint(20) DEFAULT NULL, `iOrder` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `strRole` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `cActorName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Subtype` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iVideoId` (`iVideoId`,`iActorId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_videoActorMapping_iActorId` (`iActorId`), KEY `idx_videoActorMapping_iVideoId` (`iVideoId`,`Subtype`), KEY `idx_videoActorMapping_cActorName` (`cActorName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoActorMapping` -- LOCK TABLES `videoActorMapping` WRITE; /*!40000 ALTER TABLE `videoActorMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `videoActorMapping` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_videoActorMapping AFTER DELETE ON videoActorMapping FOR EACH ROW BEGIN DELETE FROM videoActorTable WHERE NOT EXISTS ( SELECT * FROM videoActorMapping WHERE iActorId = old.iActorId ) AND iActorId = old.iActorId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `videoActorTable` -- DROP TABLE IF EXISTS `videoActorTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoActorTable` ( `iActorId` bigint(20) NOT NULL AUTO_INCREMENT, `cActorName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `iThumbnail` int(11) DEFAULT 0, `thumbnailBLOB` blob DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iActorId`), UNIQUE KEY `cActorName` (`cActorName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `videoActor_cActorName` (`cActorName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoActorTable` -- LOCK TABLES `videoActorTable` WRITE; /*!40000 ALTER TABLE `videoActorTable` DISABLE KEYS */; /*!40000 ALTER TABLE `videoActorTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videoAlbumMapping` -- DROP TABLE IF EXISTS `videoAlbumMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoAlbumMapping` ( `iVideoId` bigint(20) DEFAULT NULL, `iVideoAlbumId` bigint(20) DEFAULT NULL, `iOrder` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `OwnerFlag` int(11) NOT NULL DEFAULT 0, UNIQUE KEY `iVideoId` (`iVideoId`,`iVideoAlbumId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_videoAlbumMapping_iVideoAlbumId` (`iVideoAlbumId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoAlbumMapping` -- LOCK TABLES `videoAlbumMapping` WRITE; /*!40000 ALTER TABLE `videoAlbumMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `videoAlbumMapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videoAlbumTable` -- DROP TABLE IF EXISTS `videoAlbumTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoAlbumTable` ( `iVideoAlbumId` bigint(20) NOT NULL AUTO_INCREMENT, `cAlbumTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `DateCreated` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `albumType` int(11) DEFAULT NULL, `iAlbumCover` bigint(20) DEFAULT NULL, `Config` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `owner` bigint(20) DEFAULT NULL, `expiration` bigint(20) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `IsRecommended` tinyint(4) NOT NULL DEFAULT 1, PRIMARY KEY (`iVideoAlbumId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_videoAlbumTable_cAlbumTitle` (`cAlbumTitle`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoAlbumTable` -- LOCK TABLES `videoAlbumTable` WRITE; /*!40000 ALTER TABLE `videoAlbumTable` DISABLE KEYS */; /*!40000 ALTER TABLE `videoAlbumTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_videoAlbumTable AFTER DELETE ON videoAlbumTable FOR EACH ROW BEGIN DELETE FROM videoAlbumMapping WHERE iVideoAlbumId = old.iVideoAlbumId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `videoDirectorMapping` -- DROP TABLE IF EXISTS `videoDirectorMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoDirectorMapping` ( `iVideoId` bigint(20) DEFAULT NULL, `iDirectorId` bigint(20) DEFAULT NULL, `iOrder` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `cDirector` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Subtype` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iVideoId` (`iVideoId`,`iDirectorId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_videoDirectorMapping_iDirectorId` (`iDirectorId`), KEY `idx_videoDirectorMapping_iVideoId` (`iVideoId`,`Subtype`), KEY `idx_videoDirectorMapping_cDirector` (`cDirector`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoDirectorMapping` -- LOCK TABLES `videoDirectorMapping` WRITE; /*!40000 ALTER TABLE `videoDirectorMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `videoDirectorMapping` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_videoDirectorMapping AFTER DELETE ON videoDirectorMapping FOR EACH ROW BEGIN DELETE FROM videoDirectorTable WHERE NOT EXISTS ( SELECT * FROM videoDirectorMapping WHERE iDirectorId = old.iDirectorId ) AND iDirectorId = old.iDirectorId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `videoDirectorTable` -- DROP TABLE IF EXISTS `videoDirectorTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoDirectorTable` ( `iDirectorId` bigint(20) NOT NULL AUTO_INCREMENT, `cDirector` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `iThumbnail` int(11) DEFAULT 0, `thumbnailBLOB` blob DEFAULT NULL, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iDirectorId`), UNIQUE KEY `cDirector` (`cDirector`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `videoDirector_cDirector` (`cDirector`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoDirectorTable` -- LOCK TABLES `videoDirectorTable` WRITE; /*!40000 ALTER TABLE `videoDirectorTable` DISABLE KEYS */; /*!40000 ALTER TABLE `videoDirectorTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videoGenreMapping` -- DROP TABLE IF EXISTS `videoGenreMapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoGenreMapping` ( `iVideoId` bigint(20) DEFAULT NULL, `iGenreId` bigint(20) DEFAULT NULL, `iOrder` bigint(20) DEFAULT NULL, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Subtype` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iVideoId` (`iVideoId`,`iGenreId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_videoGenreMapping_iVideoId` (`iVideoId`,`Subtype`), KEY `idx_videoGenreMapping_iGenreId` (`iGenreId`), KEY `idx_videoGenreMapping_cGenreName` (`cGenreName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoGenreMapping` -- LOCK TABLES `videoGenreMapping` WRITE; /*!40000 ALTER TABLE `videoGenreMapping` DISABLE KEYS */; /*!40000 ALTER TABLE `videoGenreMapping` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_videoGenreMapping AFTER DELETE ON videoGenreMapping FOR EACH ROW BEGIN DELETE FROM videoGenreTable WHERE NOT EXISTS ( SELECT * FROM videoGenreMapping WHERE iGenreId = old.iGenreId ) AND iGenreId = old.iGenreId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `videoGenreTable` -- DROP TABLE IF EXISTS `videoGenreTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoGenreTable` ( `iGenreId` bigint(20) NOT NULL AUTO_INCREMENT, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`iGenreId`), UNIQUE KEY `cGenreName` (`cGenreName`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `videoGenre_cGenreName` (`cGenreName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoGenreTable` -- LOCK TABLES `videoGenreTable` WRITE; /*!40000 ALTER TABLE `videoGenreTable` DISABLE KEYS */; /*!40000 ALTER TABLE `videoGenreTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videoMyFavorite` -- DROP TABLE IF EXISTS `videoMyFavorite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoMyFavorite` ( `iVideoId` bigint(20) DEFAULT NULL, `UserId` bigint(20) DEFAULT NULL, `AddTime` bigint(20) DEFAULT NULL, `iRating` int(11) NOT NULL DEFAULT 100, `Subtype` int(11) NOT NULL DEFAULT 0, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), UNIQUE KEY `iVideoId` (`iVideoId`,`UserId`), KEY `idx_LastUpdate` (`LastUpdate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoMyFavorite` -- LOCK TABLES `videoMyFavorite` WRITE; /*!40000 ALTER TABLE `videoMyFavorite` DISABLE KEYS */; /*!40000 ALTER TABLE `videoMyFavorite` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videoTable` -- DROP TABLE IF EXISTS `videoTable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videoTable` ( `iVideoId` bigint(20) NOT NULL AUTO_INCREMENT, `cVideoTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cFileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `iDirId` bigint(20) DEFAULT NULL, `iRating` int(11) DEFAULT NULL, `ProtectionStatus` bigint(20) NOT NULL DEFAULT 0, `ProtectionStatus2` bigint(20) NOT NULL DEFAULT 0, `UseCount` int(11) DEFAULT 0, `DateCreated` bigint(20) DEFAULT NULL, `DateModified` bigint(20) DEFAULT NULL, `iFileSize` bigint(20) DEFAULT NULL, `AddToDbTime` bigint(20) DEFAULT NULL, `iStorageId` int(11) DEFAULT NULL, `iYear` int(11) DEFAULT NULL, `YearMonth` char(8) DEFAULT NULL, `YearMonthDay` char(12) DEFAULT NULL, `dateTime` bigint(20) DEFAULT NULL, `mime` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `dlna_pn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `Duration` int(11) DEFAULT NULL, `iWidth` int(11) DEFAULT NULL, `iHeight` int(11) DEFAULT NULL, `iBitrate` int(11) DEFAULT NULL, `VCodecFlag` int(11) DEFAULT 0, `IDBStatus` int(11) DEFAULT 0, `IDBId` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `ThumbnailPath` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `iLike` int(11) DEFAULT 0, `iDislike` int(11) DEFAULT 0, `TranscodeStatus` int(11) DEFAULT 0, `FormatId` int(11) DEFAULT 0, `VCodecId` int(11) DEFAULT 0, `ProfileId` int(11) DEFAULT -99, `Level` int(11) DEFAULT -99, `ACodecId` int(11) DEFAULT 0, `AProfileId` int(11) DEFAULT -99, `ALevel` int(11) DEFAULT -99, `ASampleFrequency` int(11) DEFAULT 0, `ABitrate` int(11) DEFAULT 0, `AudioChannels` int(11) DEFAULT 0, `Orientation` int(11) DEFAULT 1, `ColorLevel` int(11) DEFAULT 0, `ScannedFlag` int(11) DEFAULT 0, `InvalidFlag` int(11) NOT NULL DEFAULT 0, `AttrFlag` int(11) NOT NULL DEFAULT 0, `Subtype` int(11) NOT NULL DEFAULT 0, `iEpisodeId` bigint(20) DEFAULT NULL, `EpisodeName` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `Season` int(11) DEFAULT NULL, `iEpisodeOrder` int(11) DEFAULT NULL, `Disc` int(11) DEFAULT NULL, `iArtistId` bigint(20) DEFAULT NULL, `iAlbumId` bigint(20) DEFAULT NULL, `iGenreId` bigint(20) DEFAULT NULL, `iTrackNr` int(11) DEFAULT NULL, `iTrackLength` int(11) DEFAULT NULL, `cAlbumTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cArtistName` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `cGenreName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `AirDate` date DEFAULT NULL, `iLanguage` int(11) NOT NULL DEFAULT 0, `iSongStyle` int(11) NOT NULL DEFAULT 0, `iGain` int(11) NOT NULL DEFAULT 0, `iVocalTrack` int(11) NOT NULL DEFAULT 0, `iKTVSongId` int(11) NOT NULL DEFAULT 0, `QtagId` char(64) DEFAULT NULL, `Outline` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, `ProjectionType` tinyint(4) NOT NULL DEFAULT 0, `SubtitleFlag` int(11) NOT NULL DEFAULT 0, `SubtitleBits` int(11) NOT NULL DEFAULT 0, `Subtitles` int(11) NOT NULL DEFAULT 0, `PrevInvalidFlag` int(11) NOT NULL DEFAULT 0, `ThumbSetting` text DEFAULT NULL, `appleAssetId` varchar(64) DEFAULT NULL, `userRating` int(11) DEFAULT 0, `CaptureCat` tinyint(4) NOT NULL DEFAULT 0, `CatCover` bigint(20) NOT NULL DEFAULT -1, `IsRecommended` tinyint(4) NOT NULL DEFAULT 1, `longitude` bigint(20) DEFAULT NULL, `latitude` bigint(20) DEFAULT NULL, `longitudeDegree` decimal(11,8) DEFAULT NULL, `latitudeDegree` decimal(11,8) DEFAULT NULL, `geohash1` char(1) DEFAULT NULL, `geohash2` char(2) DEFAULT NULL, `geohash3` char(3) DEFAULT NULL, `geohash4` char(4) DEFAULT NULL, `geohash5` char(5) DEFAULT NULL, `geohash6` char(6) DEFAULT NULL, `geohash7` char(7) DEFAULT NULL, `geohash8` char(8) DEFAULT NULL, `OsmFlag` tinyint(4) NOT NULL DEFAULT 0, `AddrId` bigint(20) DEFAULT NULL, PRIMARY KEY (`iVideoId`), KEY `idx_LastUpdate` (`LastUpdate`), KEY `idx_QtagId` (`QtagId`), KEY `idx_video_cVideoTitle` (`cVideoTitle`), KEY `idx_videoTable_iArtistId` (`iArtistId`), KEY `idx_videoTable_iAlbumId` (`iAlbumId`), KEY `idx_videoTable_iGenreId` (`iGenreId`), KEY `idx_videoTable_cArtistName` (`cArtistName`), KEY `idx_videoTable_cGenreName` (`cGenreName`), KEY `idx_videoTable_cAlbumTitle` (`cAlbumTitle`), KEY `idx_videoTable_EpisodeName_Season` (`Season`,`EpisodeName`(100)), KEY `idx_videoTable_iDirId` (`iDirId`), KEY `idx_appleAssetId` (`appleAssetId`), KEY `idx_cat_cover_id` (`CatCover`,`iVideoId`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videoTable` -- LOCK TABLES `videoTable` WRITE; /*!40000 ALTER TABLE `videoTable` DISABLE KEYS */; /*!40000 ALTER TABLE `videoTable` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER update_videoTable AFTER UPDATE ON videoTable FOR EACH ROW BEGIN UPDATE videoActorMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2, Subtype = new.Subtype WHERE iVideoId = new.iVideoId; UPDATE videoDirectorMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2, Subtype = new.Subtype WHERE iVideoId = new.iVideoId; UPDATE videoGenreMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2, Subtype = new.Subtype WHERE iVideoId = new.iVideoId; UPDATE pictureAlbumMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iMediaId = new.iVideoId AND type = 2; UPDATE pictureKeyWordMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iMediaId = new.iVideoId AND type = 2; UPDATE videoMyFavorite SET Subtype = new.Subtype WHERE iVideoId = new.iVideoId; UPDATE videoAlbumMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iVideoId = new.iVideoId; UPDATE KTVArtistMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iVideoId = new.iVideoId; UPDATE KTVGenreMapping SET InvalidFlag = new.InvalidFlag, ProtectionStatus = new.ProtectionStatus, ProtectionStatus2 = new.ProtectionStatus2 WHERE iVideoId = new.iVideoId; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER delete_videoTable AFTER DELETE ON videoTable FOR EACH ROW BEGIN DELETE FROM videoDirectorMapping WHERE iVideoId = old.iVideoId; DELETE FROM videoGenreMapping WHERE iVideoId = old.iVideoId; DELETE FROM videoActorMapping WHERE iVideoId = old.iVideoId; DELETE FROM videoMyFavorite WHERE iVideoId = old.iVideoId; DELETE FROM playmediaTable WHERE iMediaId = old.iVideoId AND type = 2; DELETE FROM pictureAlbumMapping WHERE iMediaId = old.iVideoId AND type = 2; DELETE FROM pictureKeyWordMapping WHERE iMediaId = old.iVideoId AND type = 2; DELETE FROM videoAlbumMapping WHERE iVideoId = old.iVideoId; DELETE FROM MusicVideoAlbumTable WHERE NOT EXISTS ( SELECT * FROM videoTable WHERE iAlbumId = old.iAlbumId ) AND iAlbumId = old.iAlbumId; DELETE FROM MusicVideoArtistTable WHERE NOT EXISTS ( SELECT * FROM videoTable WHERE iArtistId = old.iArtistId ) AND iArtistId = old.iArtistId; DELETE FROM MusicVideoGenreTable WHERE NOT EXISTS ( SELECT * FROM videoTable WHERE iGenreId = old.iGenreId ) AND iGenreId = old.iGenreId; DELETE FROM TVShowEpisode WHERE NOT EXISTS ( SELECT * FROM videoTable WHERE iEpisodeId = old.iEpisodeId ) AND iEpisodeId = old.iEpisodeId; DELETE FROM KTVArtistMapping WHERE iVideoId = old.iVideoId; DELETE FROM KTVGenreMapping WHERE iVideoId = old.iVideoId; DELETE FROM KTVLyricsMapping WHERE iVideoId = old.iVideoId; DELETE FROM KTVTitleSearchPattern WHERE iVideoId = old.iVideoId; SELECT iStorageId,cfullpath INTO @storage,@fullpath FROM dirTable where idirid = old.idirid; INSERT INTO objDeletionTable (iMediaId, type, iStorageId, iDirId, cFileName, cFullPath) VALUES (old.iVideoId, 2, @storage, old.idirid, old.cFileName, @fullpath); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-12-13 0:37:52