9 files changed, 212 insertions, 0 deletions
diff --git a/databases/fb87181b96a99be45f5a23f4277867ce_auth_event.table b/databases/fb87181b96a99be45f5a23f4277867ce_auth_event.table
new file mode 100644
index 0000000..4e39a3a
--- /dev/null
+++ b/databases/fb87181b96a99be45f5a23f4277867ce_auth_event.table
@@ -0,0 +1,26 @@
+(dp1
+S'origin'
+p2
+S'CHAR(512)'
+p3
+sS'client_ip'
+p4
+S'CHAR(512)'
+p5
+sS'user_id'
+p6
+S'REFERENCES auth_user(id) ON DELETE CASCADE'
+p7
+sS'description'
+p8
+S'TEXT'
+p9
+sS'time_stamp'
+p10
+S'TIMESTAMP'
+p11
+sS'id'
+p12
+S'INTEGER PRIMARY KEY AUTOINCREMENT'
+p13
+s.
+\ No newline at end of file
diff --git a/databases/fb87181b96a99be45f5a23f4277867ce_auth_group.table b/databases/fb87181b96a99be45f5a23f4277867ce_auth_group.table
new file mode 100644
index 0000000..d0f448f
--- /dev/null
+++ b/databases/fb87181b96a99be45f5a23f4277867ce_auth_group.table
@@ -0,0 +1,14 @@
+(dp1
+S'role'
+p2
+S'CHAR(512)'
+p3
+sS'id'
+p4
+S'INTEGER PRIMARY KEY AUTOINCREMENT'
+p5
+sS'description'
+p6
+S'TEXT'
+p7
+s.
+\ No newline at end of file
diff --git a/databases/fb87181b96a99be45f5a23f4277867ce_auth_membership.table b/databases/fb87181b96a99be45f5a23f4277867ce_auth_membership.table
new file mode 100644
index 0000000..c7ebb10
--- /dev/null
+++ b/databases/fb87181b96a99be45f5a23f4277867ce_auth_membership.table
@@ -0,0 +1,14 @@
+(dp1
+S'group_id'
+p2
+S'REFERENCES auth_group(id) ON DELETE CASCADE'
+p3
+sS'user_id'
+p4
+S'REFERENCES auth_user(id) ON DELETE CASCADE'
+p5
+sS'id'
+p6
+S'INTEGER PRIMARY KEY AUTOINCREMENT'
+p7
+s.
+\ No newline at end of file
diff --git a/databases/fb87181b96a99be45f5a23f4277867ce_auth_permission.table b/databases/fb87181b96a99be45f5a23f4277867ce_auth_permission.table
new file mode 100644
index 0000000..c9791b0
--- /dev/null
+++ b/databases/fb87181b96a99be45f5a23f4277867ce_auth_permission.table
@@ -0,0 +1,22 @@
+(dp1
+S'record_id'
+p2
+S'INTEGER'
+p3
+sS'group_id'
+p4
+S'REFERENCES auth_group(id) ON DELETE CASCADE'
+p5
+sS'table_name'
+p6
+S'CHAR(512)'
+p7
+sS'id'
+p8
+S'INTEGER PRIMARY KEY AUTOINCREMENT'
+p9
+sS'name'
+p10
+S'CHAR(512)'
+p11
+s.
+\ No newline at end of file
diff --git a/databases/fb87181b96a99be45f5a23f4277867ce_auth_user.table b/databases/fb87181b96a99be45f5a23f4277867ce_auth_user.table
new file mode 100644
index 0000000..a01e993
--- /dev/null
+++ b/databases/fb87181b96a99be45f5a23f4277867ce_auth_user.table
@@ -0,0 +1,22 @@
+(dp1
+S'username'
+p2
+S'CHAR(128) UNIQUE'
+p3
+sS'password'
+p4
+S'CHAR(256)'
+p5
+sS'registration_key'
+p6
+S'CHAR(128)'
+p7
+sS'id'
+p8
+S'INTEGER PRIMARY KEY AUTOINCREMENT'
+p9
+sS'email'
+p10
+S'CHAR(128) UNIQUE'
+p11
+s.
+\ No newline at end of file
diff --git a/databases/fb87181b96a99be45f5a23f4277867ce_comment.table b/databases/fb87181b96a99be45f5a23f4277867ce_comment.table
new file mode 100644
index 0000000..9ed83e8
--- /dev/null
+++ b/databases/fb87181b96a99be45f5a23f4277867ce_comment.table
@@ -0,0 +1,18 @@
+(dp1
+S'body'
+p2
+S'TEXT'
+p3
+sS'image_id'
+p4
+S'REFERENCES image(id) ON DELETE CASCADE'
+p5
+sS'id'
+p6
+S'INTEGER PRIMARY KEY AUTOINCREMENT'
+p7
+sS'author'
+p8
+S'CHAR(512)'
+p9
+s.
+\ No newline at end of file
diff --git a/databases/fb87181b96a99be45f5a23f4277867ce_image.table b/databases/fb87181b96a99be45f5a23f4277867ce_image.table
new file mode 100644
index 0000000..07353ec
--- /dev/null
+++ b/databases/fb87181b96a99be45f5a23f4277867ce_image.table
@@ -0,0 +1,34 @@
+(dp1
+S'description'
+p2
+S'TEXT'
+p3
+sS'creator'
+p4
+S'CHAR(512)'
+p5
+sS'views'
+p6
+S'CHAR(512)'
+p7
+sS'title'
+p8
+S'CHAR(512)'
+p9
+sS'image_id'
+p10
+S'CHAR(512)'
+p11
+sS'file'
+p12
+S'CHAR(512)'
+p13
+sS'newimage'
+p14
+S'CHAR(512)'
+p15
+sS'id'
+p16
+S'INTEGER PRIMARY KEY AUTOINCREMENT'
+p17
+s.
+\ No newline at end of file
diff --git a/databases/sql.log b/databases/sql.log
new file mode 100644
index 0000000..7a8e599
--- /dev/null
+++ b/databases/sql.log
@@ -0,0 +1,62 @@
+timestamp: 2010-07-08T16:17:34.182357
+CREATE TABLE image(
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    file CHAR(512),
+    title CHAR(512),
+    image_id CHAR(512),
+    creator CHAR(512),
+    description TEXT,
+    views CHAR(512),
+    newimage CHAR(512)
+);
+success!
+timestamp: 2010-07-08T16:17:34.305771
+CREATE TABLE comment(
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    image_id REFERENCES image(id) ON DELETE CASCADE,
+    author CHAR(512),
+    body TEXT
+);
+success!
+timestamp: 2010-07-08T16:17:34.388196
+CREATE TABLE auth_user(
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    username CHAR(128) UNIQUE,
+    email CHAR(128) UNIQUE,
+    password CHAR(256),
+    registration_key CHAR(128)
+);
+success!
+timestamp: 2010-07-08T16:17:34.496921
+CREATE TABLE auth_group(
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    role CHAR(512),
+    description TEXT
+);
+success!
+timestamp: 2010-07-08T16:17:34.600049
+CREATE TABLE auth_membership(
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    user_id REFERENCES auth_user(id) ON DELETE CASCADE,
+    group_id REFERENCES auth_group(id) ON DELETE CASCADE
+);
+success!
+timestamp: 2010-07-08T16:17:34.678659
+CREATE TABLE auth_permission(
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    group_id REFERENCES auth_group(id) ON DELETE CASCADE,
+    name CHAR(512),
+    table_name CHAR(512),
+    record_id INTEGER
+);
+success!
+timestamp: 2010-07-08T16:17:34.767754
+CREATE TABLE auth_event(
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    time_stamp TIMESTAMP,
+    client_ip CHAR(512),
+    user_id REFERENCES auth_user(id) ON DELETE CASCADE,
+    origin CHAR(512),
+    description TEXT
+);
+success!
diff --git a/databases/storage.db b/databases/storage.db
new file mode 100644
index 0000000..c84e34a
--- /dev/null
+++ b/databases/storage.db