init.sql (1511B)
1CREATE TABLE IF NOT EXISTS users ( 2 uid INTEGER PRIMARY KEY, 3 user STRING NOT NULL UNIQUE, 4 pass STRING NOT NULL, 5 auth STRING NOT NULL, 6 creat INTEGER NOT NULL, 7 delet INTEGER DEFAULT NULL 8); 9 10CREATE TABLE IF NOT EXISTS files ( 11 uid INTEGER SECONDARY KEY, 12 file STRING NOT NULL, 13 dir STRING NOT NULL, 14 creat INTEGER NOT NULL, 15 UNIQUE(uid, file) ON CONFLICT ABORT, 16 FOREIGN KEY (uid) REFERENCES users(uid) ON DELETE CASCADE 17); 18 19CREATE TABLE IF NOT EXISTS reports ( 20 uid INTEGER SECONDARY KEY, 21 file STRING NOT NULL, 22 creat INTEGER NOT NULL, 23 FOREIGN KEY (uid) REFERENCES users(uid) ON DELETE CASCADE 24); 25 26CREATE TRIGGER IF NOT EXISTS users_delete_by 27AFTER INSERT ON users 28BEGIN 29 UPDATE users SET delet = strftime("%s", "now") + 780 WHERE delet IS NULL; 30END; 31 32INSERT OR IGNORE INTO users (uid, user, pass, auth, creat) 33 VALUES (1, "catlover1998", "ILOVECATS123", 34 hex(randomblob(16)), 9999999999); 35 36INSERT OR IGNORE INTO files (uid, file, dir, creat) 37 VALUES (1, "cat.jpg", "54b8617eca0e54c7d3c8e6732c6b687a", 9999999999); 38INSERT OR IGNORE INTO files (uid, file, dir, creat) 39 VALUES (1, "cat2.jpg", "4307ab44204de40235bad8c66cce0ae9", 9999999999); 40INSERT OR IGNORE INTO files (uid, file, dir, creat) 41 VALUES (1, "cat3.jpg", "6ed554592bbf418df53acb9317644d58", 9999999999); 42INSERT OR IGNORE INTO files (uid, file, dir, creat) 43 VALUES (1, "cat4.jpg", "bdd921efdb71adfc8c097a7ce0718eb3", 9999999999); 44 45INSERT OR IGNORE INTO reports (uid, file, creat) 46 VALUES (1, "2a4db6742253d94be4cf0e56c971fced", 9999999999);