refactoring

[uguu.git] / sqlite_schema.sql

diff --git a/sqlite_schema.sql b/sqlite_schema.sql
index 6338b51e97ad65b0bc11417d5c4aca77e2d86f83..810f69f9faae3718080fb2b0cb69ccbd830a9643 100644 (file)
--- 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;