major code refactor

[uguu.git] / sqlite_schema.sql

diff --git a/sqlite_schema.sql b/sqlite_schema.sql
deleted file mode 100644 (file)
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;