GREEN   168   0
   3929 28.05 KB    445

38904451

By Guest
Created: 2022-08-08 08:04:50
Expiry: Never

  1.  
  2. >>38927169
  3. No missing images were found in
  4.  
  5. $ sqlite3 -header -csv
  6. SQLite version 3.31.1 2020-01-27 19:55:54
  7. Enter ".help" for usage hints.
  8. sqlite> .open database_pony_furry.sqlite
  9. sqlite> .schema
  10. CREATE TABLE local_files (location_short varchar(768), last_modified_date varchar(768), size varchar(768), file_hash_sha1, file_hash_md5 varchar(768), UNIQUE(location_short));
  11. CREATE INDEX file_hash_md5_index ON local_files (file_hash_md5);
  12. sqlite> CREATE INDEX file_hash_md5_index ON local_files(file_hash_md5);
  13. Error: index file_hash_md5_index already exists
  14. sqlite> .tables
  15. local_files
  16. sqlite> select * from local_files limit 5;
  17. location_short,last_modified_date,size,file_hash_sha1,file_hash_md5
  18. "Pony/Art/Image archives/ponybooru.org/found_deleted/2022/03/17/3065650.json",1653330683,286,42bd17c309bd1195e7360460657ecbfce3a9e9d0,bcd18f39369f1a062e66453296e11d61
  19. "Pony/Art/Image archives/ponybooru.org/found_deleted/2022/03/29/3073192.json",1653330677,286,af54e12a1224ca454eb0528fb98b8d03264e1bf3,7ab0cf42ebf5f62c6a46e90e3c475122
  20. "Pony/Art/Image archives/ponybooru.org/found_deleted/2022/04/11/3082338.json",1653330674,286,4816e02ea45ec46128b6bd814d2c8f39b990da4c,bf58af150994186988eccd78e24271a5
  21. "Pony/Art/Image archives/ponybooru.org/found_deleted/2022/05/16/3105393.json",1653251292,278,00b011e5a74c860343f680aab63fb34a0d6c26d8,9eadb6099d5fb9e7f74a213d617f7f88
  22. "Pony/Art/Image archives/ponybooru.org/found_deleted/2022/05/06/3098109.json",1653291319,280,a0a3101fe0ed3adbc2a7a1c579756047d7cba498,c2b0e982655ec6c053fbc8cb925b840c
  23. sqlite> select * from local_files where file_hash_md5='03b4f4395c162a426f3969246d99d27b';
  24. sqlite> select * from local_files where file_hash_md5='04af360f181233eb9ca171be1137ed5e';
  25. sqlite> select * from local_files where file_hash_md5='0bb963a6364d57974af9404fb2219f95';
  26. [...]
  27.  
  28. ----
  29.  
  30. Some random images:
  31.  
  32. vc: ggZoR

Yandere Thread - Yandere Applejack (completed)

by Guest

Bonding with Nature

by Guest

The Long and Short of It (RGRE)

by Guest

incest relationships piece of the whole pie (lewd) by Frostybox[...]

by Guest

incest thread piece of the (non-canon) pie, limestone's pie by[...]

by Guest