· 6 years ago · Jul 27, 2019, 08:12 AM
1-- MySQL dump 10.17 Distrib 10.3.13-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: hentai_collection
4-- ------------------------------------------------------
5-- Server version 10.3.13-MariaDB-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `exhentai_gallery`
20--
21
22DROP TABLE IF EXISTS `exhentai_gallery`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `exhentai_gallery` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `gid` int(11) NOT NULL,
28 `token` varchar(16) NOT NULL,
29 `title` varchar(256) DEFAULT NULL,
30 `title_jpn` varchar(256) DEFAULT NULL,
31 `category` varchar(16) DEFAULT NULL,
32 `thumb` varchar(128) DEFAULT NULL,
33 `rating` float DEFAULT NULL,
34 `rating_count` int(11) DEFAULT NULL,
35 `favorited_count` int(11) DEFAULT NULL,
36 `uploader` varchar(24) DEFAULT NULL,
37 `upload_time` bigint(20) DEFAULT NULL,
38 `file_count` smallint(6) DEFAULT NULL,
39 `file_size` bigint(20) DEFAULT NULL,
40 `archive_key` varchar(64) DEFAULT NULL,
41 `tags` text DEFAULT NULL,
42 `last_update` bigint(20) DEFAULT NULL,
43 PRIMARY KEY (`id`),
44 UNIQUE KEY `exhentaigallery_gid` (`gid`),
45 KEY `upload_time` (`upload_time`)
46) ENGINE=InnoDB AUTO_INCREMENT=227896 DEFAULT CHARSET=utf8mb4;
47/*!40101 SET character_set_client = @saved_cs_client */;
48
49--
50-- Dumping data for table `exhentai_gallery`
51--
52
53LOCK TABLES `exhentai_gallery` WRITE;
54/*!40000 ALTER TABLE `exhentai_gallery` DISABLE KEYS */;
55INSERT INTO `exhentai_gallery` VALUES (1,9,'e56264c60c','(C71) [Arisan-Antenna (Koari)] Eat The Rich! (Sukatto Golf Pangya)','(C71) [ありさんアンテナ (小蟻)] Eat The Rich! (スカッとゴルフ パンヤ)','Doujinshi','https://ehgt.org/32/7b/327b3c0e6f33b586ef81a821d9fd0607bd464620-255758-1050-1500-jpg_l.jpg',4.57,NULL,NULL,'Sakura',1174358472,14,4375953,'430300--7500abfac9d6bfaf7c7d1cd45b6f392ed514bac5','[\"parody:pangya\", \"character:kooh\", \"group:arisan-antenna\", \"artist:koari\", \"female:catgirl\", \"female:gymshorts\", \"female:kemonomimi\", \"female:lolicon\", \"female:twintails\"]',NULL),
56(2,52,'79845e5662','(C56) [Chimatsuriya Honpo (Asanagi Aoi)] Another You (Neon Genesis Evangelion)','(C56) [血祭屋本舗 (朝凪葵)] Another You (新世紀エヴァンゲリオン)','Doujinshi','https://ehgt.org/de/66/de66ad44e1e6c57096269a967b9f3cac1b5651cf-725429-2116-2996-jpg_l.jpg',4.06,NULL,NULL,'Darknemo2000',1174731787,83,27458005,'430300--38da70a3a9c99c45620153263e19184f50e3ead8','[\"parody:neon genesis evangelion\", \"character:mana kirishima\", \"character:mayumi yamagishi\", \"character:misato katsuragi\", \"character:rei ayanami\", \"character:shinji ikari\", \"group:chimatsuriya honpo\", \"artist:asanagi aoi\", \"female:big breasts\", \"female:blowjob\", \"female:bodysuit\", \"female:glasses\", \"female:lolicon\", \"female:nakadashi\", \"female:rape\", \"female:schoolgirl uniform\", \"female:yuri\", \"group\", \"mmf threesome\"]',NULL),
57(3,85,'2e9b253931','[SHYNESS OVER DRIVE (Motozaki Akira)] Seinen 14 Sai (Neon Genesis Evangelion)','[SHYNESS OVER DRIVE (素崎彰)] 青年14歳 (新世紀エヴァンゲリオン)','Doujinshi','https://ehgt.org/bd/0a/bd0aa896fddce1c4c3f893399a82c62d2cfe0b0a-284180-1415-2018-jpg_l.jpg',3.88,NULL,NULL,'gannon',1175048714,58,11917790,'430300--75754a5db4778113b3fa15d9b47a445fccc2f6de','[\"parody:neon genesis evangelion\", \"character:asuka langley soryu\", \"character:misato katsuragi\", \"character:rei ayanami\", \"character:shinji ikari\", \"group:shynes