X-Git-Url: https://jfr.im/git/uguu.git/blobdiff_plain/d8c46ff78ae2707a580f7b0446349122297b434f..2057341d8f6beb79fdaa034619c4030b86baecf3:/sqlite_schema.sql

diff --git a/sqlite_schema.sql b/sqlite_schema.sql
index 6338b51..810f69f 100644
--- a/sqlite_schema.sql
+++ b/sqlite_schema.sql
@@ -8,5 +8,18 @@ CREATE TABLE `files` (
 ,  `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;
