Index: lams_tool_forum/db/sql/cleanup_lams_tool_forum.sql =================================================================== diff -u -r41652a256ea5191bebf33acb6139e21083102877 -r8f714bc2a298cad42acd47e9c5df932b23555eb7 --- lams_tool_forum/db/sql/cleanup_lams_tool_forum.sql (.../cleanup_lams_tool_forum.sql) (revision 41652a256ea5191bebf33acb6139e21083102877) +++ lams_tool_forum/db/sql/cleanup_lams_tool_forum.sql (.../cleanup_lams_tool_forum.sql) (revision 8f714bc2a298cad42acd47e9c5df932b23555eb7) @@ -1,4 +1,5 @@ -DELETE FROM ATTACHMENT; -DELETE FROM MESSAGE; -DELETE FROM FORUM; -DELETE FROM GENERICENTITY; \ No newline at end of file +delete from tl_lafrum11_attachment; +delete from tl_lafrum11_forum; +delete from tl_lafrum11_genericentity; +delete from tl_lafrum11_message; + Index: lams_tool_forum/db/sql/create_lams_tool_forum.sql =================================================================== diff -u -r41652a256ea5191bebf33acb6139e21083102877 -r8f714bc2a298cad42acd47e9c5df932b23555eb7 --- lams_tool_forum/db/sql/create_lams_tool_forum.sql (.../create_lams_tool_forum.sql) (revision 41652a256ea5191bebf33acb6139e21083102877) +++ lams_tool_forum/db/sql/create_lams_tool_forum.sql (.../create_lams_tool_forum.sql) (revision 8f714bc2a298cad42acd47e9c5df932b23555eb7) @@ -1,12 +1,11 @@ -create table ATTACHMENT ( +create table tl_lafrum11_attachment ( id bigint not null, UUID bigint, - TYPE bit, - NAME varchar(255), + VERSION bigint, FORUM bigint, primary key (id) ); -create table FORUM ( +create table tl_lafrum11_forum ( id bigint not null, TITLE varchar(255), ALLOWANNOMITY bit, @@ -17,15 +16,15 @@ OFFLINEINSTRUCTIONS varchar(255), primary key (id) ); -create table GENERICENTITY ( +create table tl_lafrum11_genericentity ( ID bigint not null auto_increment, CREATED datetime, UPDATED datetime, CREATEDBY bigint, MODIFIEDBY bigint, primary key (ID) ); -create table MESSAGE ( +create table tl_lafrum11_message ( id bigint not null, SUBJECT varchar(255), BODY text, @@ -35,9 +34,9 @@ PARENT bigint, primary key (id) ); -alter table ATTACHMENT add index FKA7E145233FF9501 (FORUM), add constraint FKA7E145233FF9501 foreign key (FORUM) references FORUM (id); -alter table ATTACHMENT add index FKA7E14523D1B (id), add constraint FKA7E14523D1B foreign key (id) references GENERICENTITY (ID); -alter table FORUM add index FK3FF9501D1B (id), add constraint FK3FF9501D1B foreign key (id) references GENERICENTITY (ID); -alter table MESSAGE add index FK63B68BE78C3DFCAA (PARENT), add constraint FK63B68BE78C3DFCAA foreign key (PARENT) references MESSAGE (id); -alter table MESSAGE add index FK63B68BE73FF9501 (FORUM), add constraint FK63B68BE73FF9501 foreign key (FORUM) references FORUM (id); -alter table MESSAGE add index FK63B68BE7D1B (id), add constraint FK63B68BE7D1B foreign key (id) references GENERICENTITY (ID); \ No newline at end of file +alter table tl_lafrum11_attachment add index FK389AD9A23FF9501 (FORUM), add constraint FK389AD9A23FF9501 foreign key (FORUM) references tl_lafrum11_forum (id); +alter table tl_lafrum11_attachment add index FK389AD9A2D1B (id), add constraint FK389AD9A2D1B foreign key (id) references tl_lafrum11_genericentity (ID); +alter table tl_lafrum11_forum add index FK87917942D1B (id), add constraint FK87917942D1B foreign key (id) references tl_lafrum11_genericentity (ID); +alter table tl_lafrum11_message add index FK4A6067E83FF9501 (FORUM), add constraint FK4A6067E83FF9501 foreign key (FORUM) references tl_lafrum11_forum (id); +alter table tl_lafrum11_message add index FK4A6067E88C3DFCAA (PARENT), add constraint FK4A6067E88C3DFCAA foreign key (PARENT) references tl_lafrum11_message (id); +alter table tl_lafrum11_message add index FK4A6067E8D1B (id), add constraint FK4A6067E8D1B foreign key (id) references tl_lafrum11_genericentity (ID); Index: lams_tool_forum/db/sql/drop_lams_tool_forum.sql =================================================================== diff -u -r41652a256ea5191bebf33acb6139e21083102877 -r8f714bc2a298cad42acd47e9c5df932b23555eb7 --- lams_tool_forum/db/sql/drop_lams_tool_forum.sql (.../drop_lams_tool_forum.sql) (revision 41652a256ea5191bebf33acb6139e21083102877) +++ lams_tool_forum/db/sql/drop_lams_tool_forum.sql (.../drop_lams_tool_forum.sql) (revision 8f714bc2a298cad42acd47e9c5df932b23555eb7) @@ -1,15 +1,16 @@ -alter table ATTACHMENT drop foreign key FKA7E145233FF9501; -alter table ATTACHMENT drop foreign key FKA7E14523D1B; -alter table FORUM drop foreign key FK3FF9501D1B; -alter table MESSAGE drop foreign key FK63B68BE78C3DFCAA; -alter table MESSAGE drop foreign key FK63B68BE73FF9501; -alter table MESSAGE drop foreign key FK63B68BE7D1B; -drop table if exists ATTACHMENT; -drop table if exists FORUM; -drop table if exists GENERICENTITY; -drop table if exists MESSAGE; +alter table tl_lafrum11_attachment drop foreign key FK389AD9A23FF9501; +alter table tl_lafrum11_attachment drop foreign key FK389AD9A2D1B; +alter table tl_lafrum11_forum drop foreign key FK87917942D1B; +alter table tl_lafrum11_message drop foreign key FK4A6067E83FF9501; +alter table tl_lafrum11_message drop foreign key FK4A6067E88C3DFCAA; +alter table tl_lafrum11_message drop foreign key FK4A6067E8D1B; +drop table if exists tl_lafrum11_attachment; +drop table if exists tl_lafrum11_forum; +drop table if exists tl_lafrum11_genericentity; +drop table if exists tl_lafrum11_message; + Index: lams_tool_forum/db/sql/insert_lams_tool_forum_data.sql =================================================================== diff -u -r49672b57edce1b3bac88a150425ce0e038868829 -r8f714bc2a298cad42acd47e9c5df932b23555eb7 --- lams_tool_forum/db/sql/insert_lams_tool_forum_data.sql (.../insert_lams_tool_forum_data.sql) (revision 49672b57edce1b3bac88a150425ce0e038868829) +++ lams_tool_forum/db/sql/insert_lams_tool_forum_data.sql (.../insert_lams_tool_forum_data.sql) (revision 8f714bc2a298cad42acd47e9c5df932b23555eb7) @@ -1,10 +1,9 @@ - -INSERT INTO GENERICENTITY (ID, CREATED +INSERT INTO tl_lafrum11_genericentity (ID, CREATED ) VALUES (1, NOW()); -INSERT INTO GENERICENTITY (ID, CREATED +INSERT INTO tl_lafrum11_genericentity (ID, CREATED ) VALUES (2, NOW()); -insert into FORUM (ID,TITLE, ALLOWANNOMITY, FORCEOFFLINE, LOCKWHENFINISHED, INSTRUCTIONS, +insert into tl_lafrum11_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 +insert into tl_lafrum11_message (ID, SUBJECT, BODY, ISAUTHORED, ISANNONYMOUS, FORUM, PARENT) VALUES (2, "TITLE", "BODY", true, false, 1, NULL) ; \ No newline at end of file