X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=memories.sql;fp=memories.sql;h=9ebe256a095fc76502cfd50704a4de1cf8169bc6;hb=b9d021d4af1018ac2c60640678c1b790251190e9;hp=0000000000000000000000000000000000000000;hpb=619ab99c593a8fe9adc50834d27d25b5fa24f4e3;p=memories.git

diff --git a/memories.sql b/memories.sql
new file mode 100644
index 0000000..9ebe256
--- /dev/null
+++ b/memories.sql
@@ -0,0 +1,58 @@
+CREATE TABLE photo (
+    id integer not null auto_increment primary key,
+    title varchar(255),
+    uploader integer,
+    uploaded datetime,
+    x integer,
+    y integer
+);
+
+CREATE TABLE comment (
+    id integer not null auto_increment primary key,
+    name varchar(255),
+    content text,
+    photo integer
+);
+
+CREATE TABLE user (
+    id integer not null auto_increment primary key,
+    name varchar(255),
+    password varchar(255)
+);
+
+CREATE TABLE tag (
+    id integer not null auto_increment primary key,
+    name varchar(255)
+);
+
+CREATE TABLE tagging (
+    id integer not null auto_increment primary key,
+    tag integer,
+    photo integer
+);
+
+CREATE TABLE album (
+    id integer not null auto_increment primary key,
+    name varchar(255),
+    user integer,
+    privacy integer
+);
+
+CREATE TABLE album_entry (
+    id integer not null auto_increment primary key,
+    album integer,
+    photo integer
+);
+
+CREATE TABLE system_tag (
+    id integer not null auto_increment primary key,
+    name varchar(255)
+);
+
+CREATE TABLE system_tagging (
+    id integer not null auto_increment primary key,
+    tag integer,
+    photo integer
+);
+
+