Fork of elimage with specific modifications for my instance. https://i.catgirlsin.space
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 

21 lines
460 B

BEGIN TRANSACTION;
CREATE TABLE user (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
ip VARCHAR(40) NOT NULL,
blocked BOOLEAN default 0,
comment text
);
CREATE TABLE image (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
uid INTEGER NOT NULL REFERENCES "user" ("id"),
name VARCHAR(40) NOT NULL,
filename VARCHAR(256) NOT NULL,
size INTEGER NOT NULL,
time TIMESTAMP
);
CREATE INDEX idx_name ON image (name);
COMMIT;