Index: lams_tool_forum/db/sql/table-schema.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/db/sql/table-schema.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_forum/db/sql/table-schema.sql	11 Oct 2005 07:22:57 -0000	1.1
+++ lams_tool_forum/db/sql/table-schema.sql	13 Oct 2005 02:06:08 -0000	1.2
@@ -3,43 +3,66 @@
 alter table tl_lafrum11_message drop foreign key FK4A6067E89EAD680D;
 drop table if exists tl_lafrum11_attachment;
 drop table if exists tl_lafrum11_forum;
+drop table if exists tl_lafrum11_forum_learners;
 drop table if exists tl_lafrum11_message;
+drop table if exists tl_lafrum11_tool_session;
 create table tl_lafrum11_attachment (
-   UUID bigint not null auto_increment,
-   VERSION bigint,
+   uuid bigint not null auto_increment,
+   version_id bigint,
    type varchar(255),
-   NAME varchar(255),
+   file_name varchar(255),
    forum bigint,
-   primary key (UUID)
+   primary key (uuid)
 );
 create table tl_lafrum11_forum (
-   UUID bigint not null auto_increment,
-   CREATED datetime,
-   UPDATED datetime,
-   CREATEDBY bigint,
-   TITLE varchar(255),
-   ALLOWANNOMITY bit,
-   FORCEOFFLINE bit,
-   LOCKWHENFINISHED bit,
-   INSTRUCTIONS varchar(255),
-   ONLINEINSTRUCTIONS varchar(255),
-   OFFLINEINSTRUCTIONS varchar(255),
-   primary key (UUID)
+   uuid 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 varchar(255),
+   online_instructions varchar(255),
+   offline_instructions varchar(255),
+   content_in_use bit,
+   define_later bit,
+   tool_content_id bigint,
+   primary key (uuid)
 );
+create table tl_lafrum11_forum_learners (
+   uuid bigint not null auto_increment,
+   user_id bigint,
+   status bit,
+   session_id bigint,
+   fullName varchar(255),
+   userName varchar(255),
+   primary key (uuid)
+);
 create table tl_lafrum11_message (
-   UUID bigint not null auto_increment,
-   CREATED datetime,
-   UPDATED datetime,
-   CREATEDBY bigint,
-   MODIFIEDBY bigint,
-   SUBJECT varchar(255),
-   BODY text,
-   ISAUTHORED bit,
-   ISANNONYMOUS bit,
+   uuid bigint not null auto_increment,
+   create_date datetime,
+   update_date datetime,
+   create_by bigint,
+   modified_by bigint,
+   subject varchar(255),
+   body text,
+   is_authored bit,
+   is_anonymous bit,
    FORUM bigint,
    parent bigint,
-   primary key (UUID)
+   primary key (uuid)
 );
-alter table tl_lafrum11_attachment add index FK389AD9A29EAD680D (forum), add constraint FK389AD9A29EAD680D foreign key (forum) references tl_lafrum11_forum (UUID);
-alter table tl_lafrum11_message add index FK4A6067E8F7440FBC (parent), add constraint FK4A6067E8F7440FBC foreign key (parent) references tl_lafrum11_message (UUID);
-alter table tl_lafrum11_message add index FK4A6067E89EAD680D (FORUM), add constraint FK4A6067E89EAD680D foreign key (FORUM) references tl_lafrum11_forum (UUID);
+create table tl_lafrum11_tool_session (
+   uuid bigint not null auto_increment,
+   sessionEndDate datetime,
+   sessionStartDate datetime,
+   status integer,
+   toolContentId bigint,
+   toolSessionId bigint,
+   primary key (uuid)
+);
+alter table tl_lafrum11_attachment add index FK389AD9A29EAD680D (forum), add constraint FK389AD9A29EAD680D foreign key (forum) references tl_lafrum11_forum (uuid);
+alter table tl_lafrum11_message add index FK4A6067E8F7440FBC (parent), add constraint FK4A6067E8F7440FBC foreign key (parent) references tl_lafrum11_message (uuid);
+alter table tl_lafrum11_message add index FK4A6067E89EAD680D (FORUM), add constraint FK4A6067E89EAD680D foreign key (FORUM) references tl_lafrum11_forum (uuid);
