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.

22 lines
460B

  1. BEGIN TRANSACTION;
  2. CREATE TABLE user (
  3. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  4. ip VARCHAR(40) NOT NULL,
  5. blocked BOOLEAN default 0,
  6. comment text
  7. );
  8. CREATE TABLE image (
  9. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  10. uid INTEGER NOT NULL REFERENCES "user" ("id"),
  11. name VARCHAR(40) NOT NULL,
  12. filename VARCHAR(256) NOT NULL,
  13. size INTEGER NOT NULL,
  14. time TIMESTAMP
  15. );
  16. CREATE INDEX idx_name ON image (name);
  17. COMMIT;