From 49ead645c7f78d38ef3ddc0e67a9ff6cc1b846f8 Mon Sep 17 00:00:00 2001
From: sostler <sbostler@gmail.com>
Date: Sun, 22 Nov 2009 14:57:44 -0500
Subject: static/index.html

---
 db/0-create.psql                 |  29 +++++++++++++++++++++++++++++
 lib/postgresql-8.4-701.jdbc4.jar | Bin 0 -> 510170 bytes
 2 files changed, 29 insertions(+)
 create mode 100755 db/0-create.psql
 create mode 100755 lib/postgresql-8.4-701.jdbc4.jar

diff --git a/db/0-create.psql b/db/0-create.psql
new file mode 100755
index 0000000..732c986
--- /dev/null
+++ b/db/0-create.psql
@@ -0,0 +1,29 @@
+CREATE TABLE users (
+    user_id integer PRIMARY KEY,
+    nick text UNIQUE NOT NULL,
+    email text NOT NULL,
+    salt integer NOT NULL,
+    password_hash text NOT NULL,
+    created_on timestamp NOT NULL
+);
+
+CREATE TABLE rooms (
+    room_id integer PRIMARY KEY,
+    name text UNIQUE NOT NULL,
+    created_on timestamp NOT NULL
+);
+
+CREATE TABLE messages (
+    message_id integer PRIMARY KEY,
+    user_id integer NOT NULL REFERENCES users,
+    room_id integer NOT NULL REFERENCES rooms,
+    content text NOT NULL,
+    created_on timestamp NOT NULL
+);
+
+CREATE TABLE user_session (
+    session_id integer PRIMARY KEY,
+    user_id NOT NULL REFERENCES users,
+    id_address text NOT NULL,
+    ttl timestamp NOT NULL
+);
\ No newline at end of file
diff --git a/lib/postgresql-8.4-701.jdbc4.jar b/lib/postgresql-8.4-701.jdbc4.jar
new file mode 100755
index 0000000..e21beec
Binary files /dev/null and b/lib/postgresql-8.4-701.jdbc4.jar differ
-- 
cgit v1.2.3-70-g09d2