Index: lams_tool_forum/db/sql/cleanup_lams_tool_forum.sql
===================================================================
diff -u
--- lams_tool_forum/db/sql/cleanup_lams_tool_forum.sql	(revision 0)
+++ lams_tool_forum/db/sql/cleanup_lams_tool_forum.sql	(revision 49672b57edce1b3bac88a150425ce0e038868829)
@@ -0,0 +1,4 @@
+DELETE FROM DEFAULT_SCHEMA.ATTACHMENT;
+DELETE FROM DEFAULT_SCHEMA.MESSAGE;
+DELETE FROM DEFAULT_SCHEMA.FORUM;
+DELETE FROM DEFAULT_SCHEMA.GENERICENTITHY;
\ No newline at end of file
Index: lams_tool_forum/db/sql/create_lams_tool_forum.sql
===================================================================
diff -u
--- lams_tool_forum/db/sql/create_lams_tool_forum.sql	(revision 0)
+++ lams_tool_forum/db/sql/create_lams_tool_forum.sql	(revision 49672b57edce1b3bac88a150425ce0e038868829)
@@ -0,0 +1,59 @@
+CREATE TABLE DEFAULT_SCHEMA.genericentity (
+       ID BIGINT(20) NOT NULL AUTO_INCREMENT
+     , CREATED DATETIME
+     , UPDATED DATETIME
+     , CREATEDBY BIGINT(20)
+     , MODIFIEDBY BIGINT(20)
+     , PRIMARY KEY (ID)
+)TYPE=InnoDB;
+
+CREATE TABLE DEFAULT_SCHEMA.forum (
+       id BIGINT(20) NOT NULL DEFAULT 0
+     , TITLE VARCHAR(255)
+     , ALLOWANNOMITY TINYINT(1)
+     , FORCEOFFLINE TINYINT(1)
+     , LOCKWHENFINISHED TINYINT(1)
+     , INSTRUCTIONS VARCHAR(255)
+     , ONLINEINSTRUCTIONS VARCHAR(255)
+     , OFFLINEINSTRUCTIONS VARCHAR(255)
+     , PRIMARY KEY (id)
+     , INDEX (id)
+     , CONSTRAINT FK3FF9501D1B FOREIGN KEY (id)
+                  REFERENCES DEFAULT_SCHEMA.genericentity (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE DEFAULT_SCHEMA.message (
+       id BIGINT(20) NOT NULL DEFAULT 0
+     , SUBJECT VARCHAR(255)
+     , BODY TEXT
+     , ISAUTHORED TINYINT(1)
+     , ISANNONYMOUS TINYINT(1)
+     , FORUM BIGINT(20)
+     , PARENT BIGINT(20)
+     , PRIMARY KEY (id)
+     , INDEX (id)
+     , CONSTRAINT FK63B68BE7D1B FOREIGN KEY (id)
+                  REFERENCES DEFAULT_SCHEMA.genericentity (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
+     , INDEX (FORUM)
+     , CONSTRAINT FK63B68BE73FF9501 FOREIGN KEY (FORUM)
+                  REFERENCES DEFAULT_SCHEMA.forum (id) ON DELETE NO ACTION ON UPDATE NO ACTION
+     , INDEX (PARENT)
+     , CONSTRAINT FK63B68BE78C3DFCAA FOREIGN KEY (PARENT)
+                  REFERENCES DEFAULT_SCHEMA.message (id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE DEFAULT_SCHEMA.attachment (
+       id BIGINT(20) NOT NULL DEFAULT 0
+     , UUID BIGINT(20)
+     , TYPE TINYINT(1)
+     , NAME VARCHAR(255)
+     , FORUM BIGINT(20)
+     , PRIMARY KEY (id)
+     , INDEX (id)
+     , CONSTRAINT FKA7E14523D1B FOREIGN KEY (id)
+                  REFERENCES DEFAULT_SCHEMA.genericentity (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
+     , INDEX (FORUM)
+     , CONSTRAINT FKA7E145233FF9501 FOREIGN KEY (FORUM)
+                  REFERENCES DEFAULT_SCHEMA.forum (id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
Index: lams_tool_forum/db/sql/drop_lams_tool_forum.sql
===================================================================
diff -u
--- lams_tool_forum/db/sql/drop_lams_tool_forum.sql	(revision 0)
+++ lams_tool_forum/db/sql/drop_lams_tool_forum.sql	(revision 49672b57edce1b3bac88a150425ce0e038868829)
@@ -0,0 +1,20 @@
+DROP INDEX PRIMARY ON DEFAULT_SCHEMA.genericentity;
+DROP INDEX PRIMARY ON DEFAULT_SCHEMA.forum;
+DROP INDEX FK3FF9501D1B ON DEFAULT_SCHEMA.forum;
+DROP INDEX PRIMARY ON DEFAULT_SCHEMA.message;
+DROP INDEX FK63B68BE78C3DFCAA ON DEFAULT_SCHEMA.message;
+DROP INDEX FK63B68BE73FF9501 ON DEFAULT_SCHEMA.message;
+DROP INDEX FK63B68BE7D1B ON DEFAULT_SCHEMA.message;
+DROP INDEX PRIMARY ON DEFAULT_SCHEMA.attachment;
+DROP INDEX FKA7E145233FF9501 ON DEFAULT_SCHEMA.attachment;
+DROP INDEX FKA7E14523D1B ON DEFAULT_SCHEMA.attachment;
+
+DROP TABLE DEFAULT_SCHEMA.attachment;
+DROP TABLE DEFAULT_SCHEMA.message;
+DROP TABLE DEFAULT_SCHEMA.forum;
+DROP TABLE DEFAULT_SCHEMA.genericentity;
+
+
+
+
+
Index: lams_tool_forum/db/sql/insert_lams_tool_forum_data.sql
===================================================================
diff -u
--- lams_tool_forum/db/sql/insert_lams_tool_forum_data.sql	(revision 0)
+++ lams_tool_forum/db/sql/insert_lams_tool_forum_data.sql	(revision 49672b57edce1b3bac88a150425ce0e038868829)
@@ -0,0 +1,10 @@
+
+INSERT INTO GENERICENTITY (ID, CREATED
+								) VALUES (1,
+		NOW());
+INSERT INTO GENERICENTITY (ID, CREATED
+								) VALUES (2,
+		NOW());
+insert into FORUM (ID,TITLE, ALLOWANNOMITY, FORCEOFFLINE, LOCKWHENFINISHED, INSTRUCTIONS, 
+ONLINEINSTRUCTIONS, OFFLINEINSTRUCTIONS) VALUES (1, "TEST FORUM", false, false, false, "TEST INSTRUCTIONS", "TEST ONLINE INSTRUCTIONS", "TEST OFFLINE INSTRUCTIONS");
+insert into MESSAGE (ID, SUBJECT, BODY, ISAUTHORED, ISANNONYMOUS, FORUM, PARENT) VALUES  (2, "TITLE", "BODY", true, false, 1, NULL) ;
\ No newline at end of file