Index: lams_tool_larsrc/db/sql/table-schema.sql
===================================================================
diff -u -r0a704617c31a5847217132f6b7cd73a4b9b43c9f -r5d0efcab8441b253fc761272cbaeb62aa4f4a4ef
--- lams_tool_larsrc/db/sql/table-schema.sql	(.../table-schema.sql)	(revision 0a704617c31a5847217132f6b7cd73a4b9b43c9f)
+++ lams_tool_larsrc/db/sql/table-schema.sql	(.../table-schema.sql)	(revision 5d0efcab8441b253fc761272cbaeb62aa4f4a4ef)
@@ -1,41 +1,29 @@
-alter table tl_lafrum11_attachment drop foreign key FK389AD9A2FE939F2A;
-alter table tl_lafrum11_attachment drop foreign key FK389AD9A2131CE31E;
-alter table tl_lafrum11_forum drop foreign key FK87917942E42F4351;
-alter table tl_lafrum11_forum_user drop foreign key FK7B83A4A85F0116B6;
-alter table tl_lafrum11_message drop foreign key FK4A6067E8E42F4351;
-alter table tl_lafrum11_message drop foreign key FK4A6067E897F0DB46;
-alter table tl_lafrum11_message drop foreign key FK4A6067E8131CE31E;
-alter table tl_lafrum11_message drop foreign key FK4A6067E824089E4D;
-alter table tl_lafrum11_message drop foreign key FK4A6067E89357B45B;
-alter table tl_lafrum11_message drop foreign key FK4A6067E8647A7264;
-alter table tl_lafrum11_message_seq drop foreign key FKD2C71F88FE939F2A;
-alter table tl_lafrum11_message_seq drop foreign key FKD2C71F8845213B4D;
-alter table tl_lafrum11_tool_session drop foreign key FK5A04D7AE131CE31E;
-drop table if exists tl_lafrum11_attachment;
-drop table if exists tl_lafrum11_forum;
-drop table if exists tl_lafrum11_forum_user;
-drop table if exists tl_lafrum11_message;
-drop table if exists tl_lafrum11_message_seq;
-drop table if exists tl_lafrum11_report;
-drop table if exists tl_lafrum11_tool_session;
-create table tl_lafrum11_attachment (
+alter table tl_larsrc11_attachment drop foreign key FK1E7009430E79035;
+alter table tl_larsrc11_resource drop foreign key FK89093BF758092FB;
+alter table tl_larsrc11_resource_item drop foreign key FKF52D1F9330E79035;
+alter table tl_larsrc11_session drop foreign key FK24AA78C530E79035;
+alter table tl_larsrc11_user drop foreign key FK30113BFC506CD584;
+drop table if exists tl_larsrc11_attachment;
+drop table if exists tl_larsrc11_resource;
+drop table if exists tl_larsrc11_resource_item;
+drop table if exists tl_larsrc11_session;
+drop table if exists tl_larsrc11_user;
+create table tl_larsrc11_attachment (
    uid bigint not null auto_increment,
    file_version_id bigint,
    file_type varchar(255),
    file_name varchar(255),
    file_uuid bigint,
    create_date datetime,
-   forum_uid bigint,
-   message_uid bigint,
+   resource_uid bigint,
    primary key (uid)
 );
-create table tl_lafrum11_forum (
+create table tl_larsrc11_resource (
    uid bigint not null auto_increment,
    create_date datetime,
    update_date datetime,
    create_by bigint,
    title varchar(255),
-   allow_anonym bit,
    run_offline bit,
    lock_on_finished bit,
    instructions text,
@@ -44,74 +32,38 @@
    content_in_use bit,
    define_later bit,
    content_id bigint unique,
-   allow_edit bit,
-   allow_rich_editor bit,
-   limited_of_chars integer,
-   limited_input_flag bit,
+   allow_add_files bit,
+   allow_add_urls bit,
+   min_view_resource_number integer,
+   allow_auto_run bit,
    primary key (uid)
 );
-create table tl_lafrum11_forum_user (
+create table tl_larsrc11_resource_item (
    uid bigint not null auto_increment,
-   user_id bigint,
-   last_name varchar(255),
-   first_name varchar(255),
-   session_id bigint,
-   login_name varchar(255),
+   resource_uid bigint,
    primary key (uid)
 );
-create table tl_lafrum11_message (
+create table tl_larsrc11_session (
    uid bigint not null auto_increment,
-   create_date datetime,
-   last_reply_date datetime,
-   update_date datetime,
-   create_by bigint,
-   modified_by bigint,
-   subject varchar(255),
-   body text,
-   is_authored bit,
-   is_anonymous bit,
-   forum_session_uid bigint,
-   parent_uid bigint,
-   forum_uid bigint,
-   reply_number integer,
-   hide_flag bit,
-   report_id bigint,
-   primary key (uid)
-);
-create table tl_lafrum11_message_seq (
-   uid bigint not null auto_increment,
-   root_message_uid bigint,
-   message_uid bigint,
-   message_level smallint,
-   primary key (uid)
-);
-create table tl_lafrum11_report (
-   uid bigint not null auto_increment,
-   comment text,
-   release_date datetime,
-   mark float,
-   primary key (uid)
-);
-create table tl_lafrum11_tool_session (
-   uid bigint not null auto_increment,
    session_end_date datetime,
    session_start_date datetime,
    status integer,
-   forum_uid bigint,
+   resource_uid bigint,
    session_id bigint,
    session_name varchar(250),
    primary key (uid)
 );
-alter table tl_lafrum11_attachment add index FK389AD9A2FE939F2A (message_uid), add constraint FK389AD9A2FE939F2A foreign key (message_uid) references tl_lafrum11_message (uid);
-alter table tl_lafrum11_attachment add index FK389AD9A2131CE31E (forum_uid), add constraint FK389AD9A2131CE31E foreign key (forum_uid) references tl_lafrum11_forum (uid);
-alter table tl_lafrum11_forum add index FK87917942E42F4351 (create_by), add constraint FK87917942E42F4351 foreign key (create_by) references tl_lafrum11_forum_user (uid);
-alter table tl_lafrum11_forum_user add index FK7B83A4A85F0116B6 (session_id), add constraint FK7B83A4A85F0116B6 foreign key (session_id) references tl_lafrum11_tool_session (uid);
-alter table tl_lafrum11_message add index FK4A6067E8E42F4351 (create_by), add constraint FK4A6067E8E42F4351 foreign key (create_by) references tl_lafrum11_forum_user (uid);
-alter table tl_lafrum11_message add index FK4A6067E897F0DB46 (report_id), add constraint FK4A6067E897F0DB46 foreign key (report_id) references tl_lafrum11_report (uid);
-alter table tl_lafrum11_message add index FK4A6067E8131CE31E (forum_uid), add constraint FK4A6067E8131CE31E foreign key (forum_uid) references tl_lafrum11_forum (uid);
-alter table tl_lafrum11_message add index FK4A6067E824089E4D (parent_uid), add constraint FK4A6067E824089E4D foreign key (parent_uid) references tl_lafrum11_message (uid);
-alter table tl_lafrum11_message add index FK4A6067E89357B45B (forum_session_uid), add constraint FK4A6067E89357B45B foreign key (forum_session_uid) references tl_lafrum11_tool_session (uid);
-alter table tl_lafrum11_message add index FK4A6067E8647A7264 (modified_by), add constraint FK4A6067E8647A7264 foreign key (modified_by) references tl_lafrum11_forum_user (uid);
-alter table tl_lafrum11_message_seq add index FKD2C71F88FE939F2A (message_uid), add constraint FKD2C71F88FE939F2A foreign key (message_uid) references tl_lafrum11_message (uid);
-alter table tl_lafrum11_message_seq add index FKD2C71F8845213B4D (root_message_uid), add constraint FKD2C71F8845213B4D foreign key (root_message_uid) references tl_lafrum11_message (uid);
-alter table tl_lafrum11_tool_session add index FK5A04D7AE131CE31E (forum_uid), add constraint FK5A04D7AE131CE31E foreign key (forum_uid) references tl_lafrum11_forum (uid);
+create table tl_larsrc11_user (
+   uid bigint not null auto_increment,
+   user_id bigint,
+   last_name varchar(255),
+   first_name varchar(255),
+   login_name varchar(255),
+   session_id bigint,
+   primary key (uid)
+);
+alter table tl_larsrc11_attachment add index FK1E7009430E79035 (resource_uid), add constraint FK1E7009430E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+alter table tl_larsrc11_resource add index FK89093BF758092FB (create_by), add constraint FK89093BF758092FB foreign key (create_by) references tl_larsrc11_user (uid);
+alter table tl_larsrc11_resource_item add index FKF52D1F9330E79035 (resource_uid), add constraint FKF52D1F9330E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+alter table tl_larsrc11_session add index FK24AA78C530E79035 (resource_uid), add constraint FK24AA78C530E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+alter table tl_larsrc11_user add index FK30113BFC506CD584 (session_id), add constraint FK30113BFC506CD584 foreign key (session_id) references tl_larsrc11_session (uid);