e-hentai-db icon indicating copy to clipboard operation
e-hentai-db copied to clipboard

[Feature Request] Add parent gallery

Open GGACHA opened this issue 2 years ago • 2 comments

please add parent_gid and parent_key

GGACHA avatar Jan 15 '23 14:01 GGACHA

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.

ccloli avatar Jan 15 '23 19:01 ccloli

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?

GGACHA avatar Jan 27 '23 16:01 GGACHA