ccloli / e-hentai-db

Just another E-Hentai metadata database
https://イー変態.ロリ.みんな
GNU General Public License v3.0
90 stars 13 forks source link

[Feature Request] Add parent gallery #35

Open GGACHA opened 1 year ago

GGACHA commented 1 year ago

please add parent_gid and parent_key

ccloli commented 1 year ago
CREATE TABLE IF NOT EXISTS `gallery` (
  `gid` int(11) NOT NULL,
  `token` char(10) NOT NULL,
  `archiver_key` varchar(60) NOT NULL,
  `title` varchar(300) NOT NULL,
  `title_jpn` varchar(300) NOT NULL,
  `category` varchar(15) NOT NULL,
  `thumb` varchar(150) NOT NULL,
  `uploader` varchar(50) DEFAULT NULL,
  `posted` int(11) NOT NULL,
  `filecount` int(11) NOT NULL,
  `filesize` bigint(20) NOT NULL,
  `expunged` tinyint(1) NOT NULL,
  `removed` tinyint(1) NOT NULL DEFAULT 0,
  `replaced` tinyint(1) NOT NULL DEFAULT 0,
  `rating` char(4) NOT NULL,
  `torrentcount` int(11) NOT NULL,
  `root_gid` int(11) DEFAULT NULL,
  `bytorrent` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

See root_gid field.

GGACHA commented 1 year ago
CREATE TABLE IF NOT EXISTS `gallery` (
  `gid` int(11) NOT NULL,
  `token` char(10) NOT NULL,
  `archiver_key` varchar(60) NOT NULL,
  `title` varchar(300) NOT NULL,
  `title_jpn` varchar(300) NOT NULL,
  `category` varchar(15) NOT NULL,
  `thumb` varchar(150) NOT NULL,
  `uploader` varchar(50) DEFAULT NULL,
  `posted` int(11) NOT NULL,
  `filecount` int(11) NOT NULL,
  `filesize` bigint(20) NOT NULL,
  `expunged` tinyint(1) NOT NULL,
  `removed` tinyint(1) NOT NULL DEFAULT 0,
  `replaced` tinyint(1) NOT NULL DEFAULT 0,
  `rating` char(4) NOT NULL,
  `torrentcount` int(11) NOT NULL,
  `root_gid` int(11) DEFAULT NULL,
  `bytorrent` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

See root_gid field.

um, can we provide parent_gid and parent_key on the website? And provide Redistributable Torrent instead of Magnet Link on the website?