X-Git-Url: https://jfr.im/git/uguu.git/blobdiff_plain/8fa0750dd772e5a256cca809aef631de081d9927..2057341d8f6beb79fdaa034619c4030b86baecf3:/sqlite_schema.sql diff --git a/sqlite_schema.sql b/sqlite_schema.sql index db3b7ee..810f69f 100644 --- a/sqlite_schema.sql +++ b/sqlite_schema.sql @@ -10,4 +10,16 @@ CREATE TABLE `files` ( , `date` integer default NULL , `ip` char(15) default NULL ); +CREATE TABLE `accounts` ( + `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT +, `email` varchar(255) default NULL +, `pass` varchar(255) default NULL +, `level` integer default NULL +); +CREATE TABLE `blacklist` ( + `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT +, `hash` char(40) default NULL +, `originalname` varchar(255) default NULL +, `time` integer default NULL +); END TRANSACTION;