Skip to content

Releases: ccloli/e-hentai-db

v0.3.1

31 Dec 11:11
Compare
Choose a tag to compare

Database dump @ 2023-12-31

31 Dec 16:48
Compare
Choose a tag to compare
Pre-release

Happy New Year.

The SQL files are dumped at around 2023-12-31 21:00:00 +0800.

You can use the sql file without importing gdata.json.

Note: the structure of some table may not the same as in struct.sql, but mostly it'll be okay.


Due to a server configuration error, most galleries between Mar 2023 and Sep 2023 are not written to the database and gone forever.

Once I recover the server back online, I tried to recover them by searching some common patterns in torrent search page (/torrents.php) manually, so it should sync most of the usual galleries. But if the gallery doesn't match these patterns and didn't sync before, or doesn't have torrents uploaded, then they may lost forever.

The recovery is done around Oct 10th 2023, the following list contains search keywords and counted pages.

If you happened to see this, and have some good ideas to import more cases, (and limit each search result to 100 pages or say 5000 records), feel free to open an issue and provide such keywords.

Besides, if you happened to have the data between Mar 2023 and Oct 2023, and willing to share it, please reach me by issues or email.

The keywords used to import torrents:
c101
	# 64 "" c101
c100
	# 64 "" c100
c101
	# 67 "" c101
c102
	# 56 "" c102
c99
	# 62 "" c99
c98
	# 18 "" c98
ac3
	# 2 "" ac3
ac2
	# 4 "" ac2
ff4
	# 2 "" ff4
ff3
	# 5 "" ff3
ff2
	# 2 "" ff2
artist -[artist -2023 zip
	# 98 "" "artist -[artist -2023 zip"
artist -[artist -2023 zip
	# 98 "" "artist+-[artist+-2023+zip"
artist -[artist -2023 -zip
	# 14 "" "artist+-[artist+-2023+-zip"
artist -[artist 2023
	# 14 "" "artist+-[artist+2023"
artist [artist
	# 90 "" "artist+[artist"
pixiv -[pixiv ●PIXIV
	# 71 "" "pixiv -[pixiv ●PIXIV"
pixiv -[pixiv ●PIXIV
	# 71 "" "pixiv+-[pixiv+●PIXIV"
pixiv -[pixiv ●PIXIV
	# 71 "" "pixiv+-[pixiv+%E2%97%8FPIXIV"
pixiv -[pixiv -●PIXIV
	# 71 "" "pixiv+-[pixiv+-%E2%97%8FPIXIV"
pixiv -[pixiv ●PIXIV
	# 71 "" "pixiv+-[pixiv+%E2%97%8FPIXIV"
pixiv -[pixiv -●PIXIV
	# 63 "" "pixiv+-[pixiv+-%E2%97%8FPIXIV"
pixiv zip -202 ).z
	# 100 "" "%5Bpixiv+zip+-202+"%29.z""
pixiv zip -202 -).z
	# 21 "" "%5Bpixiv+zip+-202+-"%29.z""
pixiv zip 202
	# 35 "" "%5Bpixiv+zip+202"
pixiv -zip
	# 42 "" "%5Bpixiv+-zip"
fanbox
	# 85 "" "[fanbox"
fanbox -[fanbox
	# 95 "" "fanbox -[fanbox"
fanbox -[fanbox
	# 95 "" "fanbox+-[fanbox"
fantia
	# 21 "" "fantia"
gumroad
	# 7 "" "gumroad"
pat
	# 99 "" "pat"
twi
	# 69 "" "twi"
dls
	# 2 "" "dls"
bil
	# 10 "" "bil"
wei
	# 6 "" "wei"
paw
	# 3 "" "paw"
2023 -pixiv -fanbox -twitter [2023 -].z
	# 85 "" "2023+-pixiv+-fanbox+-twitter+%5B2023+-%5D.z"
2023 -pixiv -fanbox -twitter [2023 ].z
	# 47 "" "2023+-pixiv+-fanbox+-twitter+%5B2023+%5D.z"
2023 -pixiv -fanbox -twitter -[2023
	# 93 "" "2023+-pixiv+-fanbox+-twitter+-%5B2023"
2022 -pixiv -fanbox -twitter -[2022 -2023
	# 93 "" "2022+-pixiv+-fanbox+-twitter+-%5B2022 -2023"
2022 -pixiv -fanbox -twitter -[2022 -2023
	# 93 "" "2022+-pixiv+-fanbox+-twitter+-%5B2022+-2023"
99  2022 -pixiv -fanbox -twitter -[2022 -2023
	# 9 99 "" "2022+-pixiv+-fanbox+-twitter+-%5B2022+-2023"
2022 -pixiv -fanbox -twitter -[2022 -2023
	# 99 "" "2022+-pixiv+-fanbox+-twitter+-%5B2022+-2023"
2022 -pixiv -fanbox -twitter [2022 -2023
	# 47 "" "2022+-pixiv+-fanbox+-twitter+%5B2022+-2023"
2021 -pixiv -fanbox -twitter -2022 -2023
	# 94 "" "2021+-pixiv+-fanbox+-twitter+-2022+-2023"
2021 -pixiv -fanbox -twitter -2022 -2023
	# 94 "" "2021+-pixiv+-fanbox+-twitter+-2022+-2023"
2021 -pixiv -fanbox -twitter -2022 -2023
	# 94 "" "2021+-pixiv+-fanbox+-twitter+-2022+-2023"
2020 -pixiv -fanbox -twitter -2022 -2023
	# 72 "" "2020+-pixiv+-fanbox+-twitter+-2022+-2023"
201 -pixiv -fanbox -twitter ].z
	# 94 "" "201+-pixiv+-fanbox+-twitter+%5D.z"
201 -pixiv -fanbox -twitter -].z
	# 79 "" "201+-pixiv+-fanbox+-twitter+-%5D.z"
200 -pixiv -fanbox -twitter
	# 32 "" "200+-pixiv+-fanbox+-twitter"
199 -pixiv -fanbox -twitter
	# 9 "" "199+-pixiv+-fanbox+-twitter"
198 -pixiv -fanbox -twitter
	# 7 "" "198+-pixiv+-fanbox+-twitter"
197 -pixiv -fanbox -twitter
	# 7 "" "197+-pixiv+-fanbox+-twitter"
196 -pixiv -fanbox -twitter
	# 6 "" "196+-pixiv+-fanbox+-twitter"
195 -pixiv -fanbox -twitter
	# 4 "" "195+-pixiv+-fanbox+-twitter"
194 -pixiv -fanbox -twitter
	# 4 "" "194+-pixiv+-fanbox+-twitter"
193 -pixiv -fanbox -twitter
	# 4 "" "193+-pixiv+-fanbox+-twitter"
201 -pixiv -fanbox -twitter ].z
	# 94 "" "201+-pixiv+-fanbox+-twitter+%5D.z"
201 -pixiv -fanbox -twitter -].z
	# 79 "" "201+-pixiv+-fanbox+-twitter+-%5D.z"
201 -pixiv -fanbox -twitter ].z
	# 32 "" "201+-pixiv+-fanbox+-twitter+%5D.z"
lol
	# 45 "" "lol"
chinese 汉化
	# 97 "" "chinese+%E6%B1%89%E5%8C%96"
chinese -汉化 -漢化
	# 91 "" "chinese+-%E6%B1%89%E5%8C%96+-%E6%BC%A2%E5%8C%96"
chinese -汉化 -漢化
	# 32 "" "chinese+-%E6%B1%89%E5%8C%96+-%E6%BC%A2%E5%8C%96"
chinese 汉化 中国
	# 89 "" "-chinese+%E6%B1%89%E5%8C%96+%E4%B8%AD%E5%9B%BD"
chinese 汉化 -中国
	# 46 "" "-chinese+%E6%B1%89%E5%8C%96+-%E4%B8%AD%E5%9B%BD"
chinese -汉化 中国 DL版 -202 ") ["
	# 70 "" "-chinese+-%E6%B1%89%E5%8C%96+%E4%B8%AD%E5%9B%BD+DL%E7%89%88+-202+%22%29+%5B%22"
chinese -汉化 中国 DL版 -202 ") ["
	# 63 "" "-chinese+-%E6%B1%89%E5%8C%96+%E4%B8%AD%E5%9B%BD+DL%E7%89%88+-202+%22%29+%5B%22"
chinese -汉化 中国 -DL版 -202 ") [" の
	# 48 "" "-chinese+-%E6%B1%89%E5%8C%96+%E4%B8%AD%E5%9B%BD+-DL%E7%89%88+-202+%22%29+%5B%22+%E3%81%AE"
chinese -汉化 中国 -DL版 -202 ") [" の
	# 82 "" "-chinese+-%E6%B1%89%E5%8C%96+%E4%B8%AD%E5%9B%BD+-DL%E7%89%88+-202+%22%29+%5B%22+%E3%81%AE"
chinese -汉化 中国 -DL版 -202 -") [" -の
	# 82 "" "-chinese+-%E6%B1%89%E5%8C%96+%E4%B8%AD%E5%9B%BD+-DL%E7%89%88+-202+-%22%29+%5B%22+-%E3%81%AE"
chinese -汉化 中国 -DL版 -202 -") [" の
	# 62 "" "-chinese+-%E6%B1%89%E5%8C%96+%E4%B8%AD%E5%9B%BD+-DL%E7%89%88+-202+-%22%29+%5B%22+%E3%81%AE"
chinese -汉化 -中国 中文
	# 19 "" "-chinese+-%E6%B1%89%E5%8C%96+-%E4%B8%AD%E5%9B%BD+%E4%B8%AD%E6%96%87"
chinese -汉化 -中国 -中文 中
	# 82 "" "-chinese+-%E6%B1%89%E5%8C%96+-%E4%B8%AD%E5%9B%BD+-%E4%B8%AD%E6%96%87+%E4%B8%AD"
翻 -中国
	# 75 "" "%E7%BF%BB+-%E4%B8%AD%E5%9B%BD"
translate
	# 26 "" "translate"
jap
	# 10 "" "jap"
eng -english
	# 72 "" "eng+-english"
english 1280 -") ["
	# 97 "" "english+1280+-%22%29+%5B%22"
english 1280 ") [" "] ["
	# 86 "" "english+1280+%22%29+%5B%22+%22%5D+%5B%22"
english 1280 ") [" "] -["
	# 46 "" "english+1280+%22%29+%5B%22+%22%5D+-%5B%22"
english 1280 ") [" -"] ["
	# 60 "" "english+1280+%22%29+%5B%22+-%22%5D+%5B%22"
english 1280 ") [" -"] -["
	# 37 "" "english+1280+%22%29+%5B%22+-%22%5D+-%5B%22"
english -1280 ") [" "] [" "digital" com
	# 62 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+%22digital%22+com"
english -1280 ") [" "] [" "digital" -com
	# 96 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+%22digital%22+-com"
english -1280 ") [" "] [" -"digital" com
	# 81 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+-%22digital%22+com"
english -1280 ") [" "] [" -"digital" com
	# 81 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+-%22digital%22+com"
english -1280 ") [" "] [" -"digital" -com "(c9"
	# 77 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+-%22digital%22+-com+%22%28c9%22"
english -1280 "digital" com -cha
	# 95 "" "english+-1280+%22digital%22+com+-cha"
english -1280 "digital" com cha
	# 12 "" "english+-1280+%22digital%22+com+cha"
english -1280 "digital" -com chi
	# 55 "" "english+-1280+%22digital%22+-com+chi"
english -1280 "digital" -com -chi shi
	# 65 "" "english+-1280+%22digital%22+-com+-chi+shi"
english -1280 "digital" -com -chi -shi -kan
	# 96 "" "english+-1280+%22digital%22+-com+-chi+-shi+-kan"
english -1280 "digital" -com -chi -shi kan
	# 14 "" "english+-1280+%22digital%22+-com+-chi+-shi+kan"
english -1280 -"digital" com comic 201
	# 39 "" "english+-1280+-%22digital%22+com+comic+201"
english -1280 -"digital" com comic -201
	# 68 "" "english+-1280+-%22digital%22+com+comic+-201"
english -1280 -"digital" com -comic -(c9
	# 92 "" "english+-1280+-%22digital%22+com+-comic+-%28c9"
english -1280 -"digital" com -comic (c9 
	# 23 "" "english+-1280+-%22digital%22+com+-comic+%28c9" 
english -1280 ") [" "] [" "digital" com
	# 62 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+%22digital%22+com"
english -1280 ") [" "] [" "digital" -com
	# 96 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+%22digital%22+-com"
english -1280 ") [" "] [" -"digital" com
	# 81 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+-%22digital%22+com"
english -1280 ") [" "] [" -"digital" com
	# 81 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+-%22digital%22+com"
english -1280 ") [" "] [" -"digital" -com "(c9"
	# 77 "" "english+-1280+%22%29+%5B%22+%22%5D+%5B%22+-%22digital%22+-com+%22%28c9%22"
english -1280 "digital" com -cha
	# 95 "" "english+-1280+%22digital%22+com+-cha"
english -1280 "digital" com cha
	# 12 "" "english+-1280+%22digital%22+com+cha"
english -1280 "digital" -com chi
	# 55 "" "english+-1280+%22digital%22+-com+chi"
english -1280 "digital" -com -chi shi
	# 65 "" "english+-1280+%22digital%22+-com+-chi+shi"
english -1280 "digital" -com -chi -shi -kan
	# 96 "" "english+-1280+%22digital%22+-com+-chi+-shi+-kan"
english -1280 "digital" -com -chi -shi kan
	# 14 "" "english+-1280+%22digital%22+-com+-chi+-shi+kan"
english -1280 -"digital" com comic 201
	# 39 "" "english+-1280+-%22digital%22+com+comic+201"
english -1280 -"digital" com comic -201
	# 68 "" "english+-1280+-%22digital%22+com+comic+-201"
english -1280 -"digital" com -comic -(c9
	# 92 "" "english+-1280+-%22digital%22+com+-comic+-%28c9"
english -1280 -"digital" com -comic (c9 
	# 23 "" "english+-1280+-%22digital%22+com+-comic+%28c9" 
english -1280 -"digital" ita
	# 94 "" "english+-1280+-%22digital%22+ita"
english -1280 -ita ish
	# 94 "" "-english+-1280+-ita+ish"
english -1280 -"digital" ita
	# 94 "" "english+-1280+-%22digital%22+ita"
english -1280 -ita ish
	# 94 "" "-english+-1280+-ita+ish"
english -1280 -ita ish
	# 94...
Read more

Database dump @ 2023-03-04

05 Mar 08:33
Compare
Choose a tag to compare
Pre-release

Just for dumping database.

The SQL files are dumped at around 2023-03-04 20:30:00 +0800.

You can use the sql file without importing gdata.json.

Note: the structure of some table may not the same as in struct.sql, but mostly it'll be okay.

  • gallery-2023-03-04_202504.sql.gz
    Size: 267771884 bytes (255 MiB)
    CRC32: 64548B6F
    CRC64: 7801509F81638F3E
    SHA256: 2f8b3d32ea86c592d8d200c6e035476021a795344f373eddac3dc7e5d4f88423
    SHA1: e3d40a35a34bfbfd1253d7a32104f42437a1e3d2
    BLAKE2sp: 64d89f685ef79edf90f5dbcd53918711301a7a1007a9d6efb152825aa69535f0

  • gid_tid-2023-03-04_203641.sql.gz
    Size: 46833293 bytes (44 MiB)
    CRC32: A8DE69A9
    CRC64: 399F9317817731AB
    SHA256: 0b1b9597f956aa9d510ce4152528fdf54ec1538a22087f5559b87dbfba89c58a
    SHA1: 8a63787676b4774d0c4a863c82cddbe995e4cc01
    BLAKE2sp: 59edf04ab4d8a1f2da49fb8a9a0019c863ab301fb1681327af1d88a944ffda9d

  • tag-2023-03-04_204433.sql.gz
    Size: 1283520 bytes (1253 KiB)
    CRC32: 1897AD85
    CRC64: 9BF8A168600C0344
    SHA256: 5a4d65ffffaae2a7fe7b67694cb2e3cf519dbf98a7f5094fc326b5e3b754b4a0
    SHA1: e8e9588ccde3a686097893eee2a8fcba52f57803
    BLAKE2sp: 18d7172591ae2776f73dcafbd88785c8a0448112bb8db47aa82bfc53541f602d

  • torrent-2023-03-04_204449.sql.gz
    Size: 54181252 bytes (51 MiB)
    CRC32: 4C4FD8E0
    CRC64: 424AF92C4961E225
    SHA256: e3be44a04c9340f2d7440b0464ae0b3186af805a59c5b9c0219704f44d0ac34b
    SHA1: 76a4c147fd0cf4b4ec00277c15eebd946e22d271
    BLAKE2sp: 7fc116d955b1fb8dfb8461a01f42360eca2a1cb38f89222af126ae4a15b82cf8

Database dump @ 2022-06-10

10 Jun 14:13
Compare
Choose a tag to compare
Pre-release

Just for dumping database.

The SQL files are dumped at around 2022-06-10 21:30:00 +0800.

You can use the sql file without importing gdata.json.

Note: the structure of some table may not the same as in struct.sql, but mostly it'll be okay.

  • gallery-2022-06-10_212606.sql.gz
    Size: 254759356 bytes (242 MiB)
    CRC32: 78916C96
    CRC64: EB5B49058BAABD52
    SHA256: FFE88DB8ED9AEEEA2E6AE882C8B2AEA5F604FCA0D1072E3DC1E89951F78C106D
    SHA1: B658A43B45FE53DCB61890F97F9738051DB75EB3
    BLAKE2sp: 0DA29DE6BB0872311A3C33D3B65ED2344CD17C1D4864CBEDC16200B172C69035

  • gid_tid-2022-06-10_213329.sql.gz
    Size: 51682028 bytes (49 MiB)
    CRC32: A6FEECAC
    CRC64: 8FFAF08CF8E00201
    SHA256: 2C215E2E2F83483A407BAC324303DD4ED1042A77D280DDF814855ED2089FD278
    SHA1: E6E367ABDD4836F37C7C6D2CE8C9FA7FC8913E7F
    BLAKE2sp: 957652D8FE9BF9B4D89F10B73E65F3F99CBD19045FD9A8C53EC4D49352F9B4EA

  • tag-2022-06-10_213730.sql.gz
    Size: 1356846 bytes (1325 KiB)
    CRC32: 7B30F814
    CRC64: A88269044CABBA5F
    SHA256: B6624C6263E8DC171DF6A84F774F6315D8E542FBB7DB26F96C5763F611BB42FC
    SHA1: D043FB7344B6E847B3D668C06D4C0A4727C6C6AB
    BLAKE2sp: 013E994137B03CB6AAC3D6B2E98AAE31789DC01F46A7B427B1C8BA38DDA65BAB

  • torrent-2022-06-10_213751.sql.gz
    Size: 48068484 bytes (45 MiB)
    CRC32: 3D755B62
    CRC64: AC183B8C15281015
    SHA256: BDD5C940AB849F3FD1007DB7D8DA361D663ADE135E4DB6687489D9B9E3845411
    SHA1: 62582B8A76A10BBF693A9213B9D8B28D57CDAA9B
    BLAKE2sp: 0D394A9E0938E15688415A4FEDA4E23769236ED2202D026B88A14449A7053345

Database dump @ 2022-01-18

19 Jan 11:54
Compare
Choose a tag to compare
Pre-release

Just for dumping database.

The SQL files are dumped at around 2022-01-18 23:45:00 +0800.

You can use the sql file without importing gdata.json.

Note: the structure of some table may not the same as in struct.sql, but mostly it'll be okay.

  • gallery-2022-01-18_23-49-21.sql.gz
    Size: 236163821 bytes (225 MiB)
    CRC32: 4CD21901
    CRC64: CC42955181F7689C
    SHA256: 35ECAD8B5A2CCB3A934DEB64D746071A49D3D38E48F4F0AF0409C4AEFE4A22D8
    SHA1: B787B6D1BE60C47C8DF27E39D73F4FC88361BF8A
    BLAKE2sp: D172CD0BADAD04A5264F0B33DF564A7B7444AB15FB9869CD79A9F6D0A981BF62

  • gid_tid-2022-01-18_23-45-44.sql.gz
    Size: 47404217 bytes (45 MiB)
    CRC32: A662A984
    CRC64: 193CFC06EE7D782B
    SHA256: 12453299DA295E9B292BDEDF963DE69EF8F6194D0324DBC46DD4C19E3A2C0A2C
    SHA1: 8D1340A3EF68595F9E65C627BC605006AF57A5A9
    BLAKE2sp: 1948EEDF40896DBC5F2BAD983D297A19DB6313339105225F2C4263ED93455FDB

  • tag-2022-01-18_23-47-46.sql.gz
    Size: 1331138 bytes (1299 KiB)
    CRC32: 889AA8B4
    CRC64: 505D87D390DC52BD
    SHA256: D372555E2F43C47ECEC8303063055D97AD91603D6F45B8FC8A2D6E7593D316F5
    SHA1: D5D3D95F437B60847DEF29231C80EAAD1C7F00B8
    BLAKE2sp: C9B6DE43DF400E0A9AA4E3FE2E3627646400933BE084D5979BB6659AC6C7600A

  • torrent-2022-01-18_23-48-09.sql.gz
    Size: 43358858 bytes (41 MiB)
    CRC32: DD496C8A
    CRC64: 6D9248B9F458BFF5
    SHA256: 73C38A7F2851EFDD4063AAAF6D454796AC124A5DE3D811A58EA8A3A7460BE874
    SHA1: F3A70BAA72AD0D650BE61E6ED2DB38E2FD1D4B32
    BLAKE2sp: 860767740881A5728ECF0B18EC561BCA729497566CCE6BA54A9FF4913C16FB4F

Database dump @ 2021-09-25

25 Sep 10:21
Compare
Choose a tag to compare
Pre-release

Just for dumping database.

The SQL files are dumped at around 2021-09-25 17:45:00 +0800.

You can use the sql file without importing gdata.json.

Note: the structure of some table may not the same as in struct.sql, but mostly it'll be okay.

  • gallery-2021-09-25_17-35-39.sql.gz
    Size: 204571345 bytes (195 MiB)
    CRC32: 304F0ADC
    CRC64: 5E6880B5348DBEA9
    SHA256: 91D32B676F9839DDD696DD385B377ACBB3E6A379DB03E7E34D482288A39B034F
    SHA1: 1A7EC9F9628221CE2E1E2998BE9AF4268961EE83
    BLAKE2sp: BA728665B77CFB176714E36A610EBF85848761DE78A66036E6DBE73D0AD6A5D0

  • gid_tid-2021-09-25_17-42-27.sql.gz
    Size: 33933919 bytes (32 MiB)
    CRC32: 23E4CA2B
    CRC64: AB4233966EABD53D
    SHA256: B171ABB3A105A5A31AA362E8F9E07B650F0D9E76304121C53353E1725D6CD478
    SHA1: CCA91AA3E9A7FD098E54E1A5D6967A65F60E3A17
    BLAKE2sp: 36A95E82CAF0AD10D795593CDE3BAAAFC7F3C4F67FC8108E149E2F0480DDE079

  • tag-2021-09-25_17-45-50.sql.gz
    Size: 1180806 bytes (1153 KiB)
    CRC32: 4D9672E3
    CRC64: 0237CDA0DCE26D8F
    SHA256: 40898A3019F65792FCEEE42C3CDD49C54499C2F82464B09DCB9D84D9EB9FF802
    SHA1: 89DC210D3927958FB3DFC20CA2F987026F2DBC2B
    BLAKE2sp: 01E015B52D2DC2380C7D340788A421C452FC17E48909A324E422F90D2F86AF32

  • torrent-2021-09-25_17-46-16.sql.gz
    Size: 36433219 bytes (34 MiB)
    CRC32: E05C2A79
    CRC64: 0B1F9F7254494785
    SHA256: 08557EA247878508BBD667058A95BE681D8AF2A42EEE541493E26772403B7B75
    SHA1: 2C076E404302D8A1AE78D95C557CA4F941060923
    BLAKE2sp: B28B7DDD527DA4F763E1F3F8BEA8880ABEB9EEA93CA23165710F30C342203352

Database dump @ 2020-03-16

06 Jul 18:12
Compare
Choose a tag to compare
Pre-release

Just for dumping database.

The SQL files are dumped at around 2020-03-16 01:20:00 +0800.

You can use the sql file without importing gdata.json.

  • gallery-2020-03-16.sql.gz

    • Size: 162184497 bytes (154 MiB)
    • CRC32: 833BCE61
    • SHA256: 5AB5926D2949ABDCB552AD309BB3A9C0B3F57F884F2FBE756C8A5EF94B92C9A6
    • SHA1: 3B1020053A2CC26CAFC7B06BC263840698526D39
  • gid_tid-2020-03-16.sql.gz

    • Size: 30980143 bytes (29 MiB)
    • CRC32: FC294BE9
    • SHA256: 546EE3401B1AF8988A92AF811187C7BF7115EAA846EE76BA4B6D3E9582CAE428
    • SHA1: A04BD55E49D352895B4D1330D645A950B0555C84
  • tag-2020-03-16.sql.gz

    • Size: 1144819 bytes (1117 KiB)
    • CRC32: 0A2B5B7C
    • SHA256: A15F15A2571444B1F2ED814C6957C5E6145DB61BACF44813D98A13214ADEA3C3
    • SHA1: 6ADFB928FEB8DDE837172F5C41CB9014F3C478AB
  • torrent-2020-03-16.sql.gz

    • Size: 19542499 bytes (18 MiB)
    • CRC32: 01E44C22
    • SHA256: A24BAD65571EF81266AF86AD2FCE08C76C00828C254E2E97EC3EBB67BBA45B6E
    • SHA1: 800D61E9B476A766C84D99B60256B1AEDC08C752

v0.3.0

23 Aug 19:16
Compare
Choose a tag to compare

The SQL files are dumped at 2019-08-24 00:00:00 +0800.

  • insert_into_torrent_20190824.sql

    • Size: 28,142,603 bytes
    • CRC32: 34E86A93
    • SHA1: 05CAA7ED27AD2888426981070C17749BE360B89B
    • SHA256: 2100FD58C03DF364B27126056BE4E8A8333EA6539655F51F60C4E19EAD6A7484
  • update_gallery_removed_replaced_root_gid_20190824.sql

    • Size: 99,205,427 bytes
    • CRC32: 9C31A477
    • SHA1: B9DB936F57F3F594C1EC48D93DA000FBBA6F0F01
    • SHA256: C80C2190529C8AABD2FF1C5C57A5144AC6D8CB4B354E824F476F4D73D34E72C7

v0.2.1

09 Aug 19:57
Compare
Choose a tag to compare
0.2.1

v0.2.0

09 Aug 19:57
Compare
Choose a tag to compare
0.2.0