static/index.html

2 files changed, 29 insertions, 0 deletions

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
--- /dev/null
+++ b/lib/postgresql-8.4-701.jdbc4.jar