From 1c22d704254cfbee50e0e0456bc1ac066885690f Mon Sep 17 00:00:00 2001
From: uckelman <uckelman@nomic.net>
Date: Sun, 4 Jul 2010 18:23:23 +0000
Subject: Added SQL schema.

git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6973 67b53d14-2c14-4ace-a08f-0dab2b34000c
---
 src/schema.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 src/schema.sql

(limited to 'src/schema.sql')

diff --git a/src/schema.sql b/src/schema.sql
new file mode 100644
index 0000000..92fba4b
--- /dev/null
+++ b/src/schema.sql
@@ -0,0 +1,18 @@
+
+CREATE TABLE posts (
+  post_id MEDIUMINT UNSIGNED,
+  message_id VARCHAR(255) NOT NULL,
+  in_reply_to VARCHAR(255),
+  edit_id MEDIUMINT NOT NULL AUTO_INCREMENT,
+  UNIQUE KEY (message_id),
+  PRIMARY KEY (edit_id),
+  INDEX (post_id)
+);
+
+CREATE TABLE forums (
+  list_name VARCHAR(255) NOT NULL,
+  forum_id MEDIUMINT UNSIGNED NOT NULL,
+  PRIMARY KEY (list_name),
+  INDEX (forum_id)
+);
+
-- 
cgit v1.2.3

