X-Git-Url: https://jfr.im/git/uguu.git/blobdiff_plain/2057341d8f6beb79fdaa034619c4030b86baecf3..e480c0e52fadac2ffac84c751cb7b0f606e93efc:/sqlite_schema.sql diff --git a/sqlite_schema.sql b/sqlite_schema.sql deleted file mode 100644 index 810f69f..0000000 --- a/sqlite_schema.sql +++ /dev/null @@ -1,25 +0,0 @@ -PRAGMA synchronous = OFF; -PRAGMA journal_mode = MEMORY; -BEGIN TRANSACTION; -CREATE TABLE `files` ( - `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT -, `hash` char(40) default NULL -, `originalname` varchar(255) default NULL -, `filename` varchar(30) default NULL -, `size` integer default NULL -, `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;