-
-
>>38927169
-
No missing images were found in
-
-
$ sqlite3 -header -csv
-
SQLite version 3.31.1 2020-01-27 19:55:54
-
Enter ".help" for usage hints.
-
sqlite> .open database_pony_furry.sqlite
-
sqlite> .schema
-
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));
-
CREATE INDEX file_hash_md5_index ON local_files (file_hash_md5);
-
sqlite> CREATE INDEX file_hash_md5_index ON local_files(file_hash_md5);
-
Error: index file_hash_md5_index already exists
-
sqlite> .tables
-
local_files
-
sqlite> select * from local_files limit 5;
-
location_short,last_modified_date,size,file_hash_sha1,file_hash_md5
-
"Pony/Art/Image archives/ponybooru.org/found_deleted/2022/03/17/3065650.json",1653330683,286,42bd17c309bd1195e7360460657ecbfce3a9e9d0,bcd18f39369f1a062e66453296e11d61
-
"Pony/Art/Image archives/ponybooru.org/found_deleted/2022/03/29/3073192.json",1653330677,286,af54e12a1224ca454eb0528fb98b8d03264e1bf3,7ab0cf42ebf5f62c6a46e90e3c475122
-
"Pony/Art/Image archives/ponybooru.org/found_deleted/2022/04/11/3082338.json",1653330674,286,4816e02ea45ec46128b6bd814d2c8f39b990da4c,bf58af150994186988eccd78e24271a5
-
"Pony/Art/Image archives/ponybooru.org/found_deleted/2022/05/16/3105393.json",1653251292,278,00b011e5a74c860343f680aab63fb34a0d6c26d8,9eadb6099d5fb9e7f74a213d617f7f88
-
"Pony/Art/Image archives/ponybooru.org/found_deleted/2022/05/06/3098109.json",1653291319,280,a0a3101fe0ed3adbc2a7a1c579756047d7cba498,c2b0e982655ec6c053fbc8cb925b840c
-
sqlite> select * from local_files where file_hash_md5='03b4f4395c162a426f3969246d99d27b';
-
sqlite> select * from local_files where file_hash_md5='04af360f181233eb9ca171be1137ed5e';
-
sqlite> select * from local_files where file_hash_md5='0bb963a6364d57974af9404fb2219f95';
-
[...]
-
-
----
-
-
Some random images:
-
-
vc: ggZoR
by Guest
by Guest
by Guest
by Guest
by Guest