refactoring

[uguu.git] / sqlite_schema.sql

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