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
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;
|