Index: lams_tool_sbmt/db/sql/table-schema.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/db/sql/table-schema.sql,v
diff -u -r1.8 -r1.9
--- lams_tool_sbmt/db/sql/table-schema.sql	3 Aug 2005 06:19:03 -0000	1.8
+++ lams_tool_sbmt/db/sql/table-schema.sql	3 Nov 2005 00:41:49 -0000	1.9
@@ -1,20 +1,14 @@
-alter table tl_lasbmt11_instruction_files drop foreign key FKA75538F9FC4BEA1;
-alter table tl_lasbmt11_submission_details drop foreign key FK1411A53C630DDF64;
-alter table tl_lasbmt11_submission_details drop foreign key FK1411A53C3A4D8629;
-alter table tl_lasbmt11_session drop foreign key FKEC8C77C9FC4BEA1;
-drop table if exists tl_lasbmt11_report;
+alter table tl_lasbmt11_instruction_files drop foreign key FKA75538F9785A173A;
+alter table tl_lasbmt11_session drop foreign key FKEC8C77C9785A173A;
+alter table tl_lasbmt11_session_learners drop foreign key FKC56CD05893C861A;
+alter table tl_lasbmt11_submission_details drop foreign key FK1411A53C93C861A;
+alter table tl_lasbmt11_submission_details drop foreign key FK1411A53C10BBAB1B;
 drop table if exists tl_lasbmt11_content;
-drop table if exists tl_lasbmt11_session_learners;
 drop table if exists tl_lasbmt11_instruction_files;
-drop table if exists tl_lasbmt11_submission_details;
+drop table if exists tl_lasbmt11_report;
 drop table if exists tl_lasbmt11_session;
-create table tl_lasbmt11_report (
-   report_id bigint not null auto_increment,
-   comments varchar(250),
-   marks bigint,
-   date_marks_released datetime,
-   primary key (report_id)
-);
+drop table if exists tl_lasbmt11_session_learners;
+drop table if exists tl_lasbmt11_submission_details;
 create table tl_lasbmt11_content (
    content_id bigint not null,
    title varchar(64) not null,
@@ -28,13 +22,6 @@
    lock_on_finished bit,
    primary key (content_id)
 );
-create table tl_lasbmt11_session_learners (
-   learner_id bigint not null auto_increment,
-   user_id bigint,
-   finished bit,
-   session_id bigint,
-   primary key (learner_id)
-);
 create table tl_lasbmt11_instruction_files (
    file_id bigint not null auto_increment,
    uuid bigint,
@@ -44,6 +31,26 @@
    content_id bigint,
    primary key (file_id)
 );
+create table tl_lasbmt11_report (
+   report_id bigint not null auto_increment,
+   comments varchar(250),
+   marks bigint,
+   date_marks_released datetime,
+   primary key (report_id)
+);
+create table tl_lasbmt11_session (
+   session_id bigint not null auto_increment,
+   status integer not null,
+   content_id bigint,
+   primary key (session_id)
+);
+create table tl_lasbmt11_session_learners (
+   learner_id bigint not null auto_increment,
+   user_id bigint,
+   finished bit,
+   session_id bigint,
+   primary key (learner_id)
+);
 create table tl_lasbmt11_submission_details (
    submission_id bigint not null auto_increment,
    filePath varchar(250),
@@ -55,13 +62,8 @@
    learner_id bigint,
    primary key (submission_id)
 );
-create table tl_lasbmt11_session (
-   session_id bigint not null auto_increment,
-   status integer not null,
-   content_id bigint,
-   primary key (session_id)
-);
-alter table tl_lasbmt11_instruction_files add index FKA75538F9FC4BEA1 (content_id), add constraint FKA75538F9FC4BEA1 foreign key (content_id) references tl_lasbmt11_content (content_id);
-alter table tl_lasbmt11_submission_details add index FK1411A53C630DDF64 (session_id), add constraint FK1411A53C630DDF64 foreign key (session_id) references tl_lasbmt11_session (session_id);
-alter table tl_lasbmt11_submission_details add index FK1411A53C3A4D8629 (learner_id), add constraint FK1411A53C3A4D8629 foreign key (learner_id) references tl_lasbmt11_session_learners (learner_id);
-alter table tl_lasbmt11_session add index FKEC8C77C9FC4BEA1 (content_id), add constraint FKEC8C77C9FC4BEA1 foreign key (content_id) references tl_lasbmt11_content (content_id);
+alter table tl_lasbmt11_instruction_files add index FKA75538F9785A173A (content_id), add constraint FKA75538F9785A173A foreign key (content_id) references tl_lasbmt11_content (content_id);
+alter table tl_lasbmt11_session add index FKEC8C77C9785A173A (content_id), add constraint FKEC8C77C9785A173A foreign key (content_id) references tl_lasbmt11_content (content_id);
+alter table tl_lasbmt11_session_learners add index FKC56CD05893C861A (session_id), add constraint FKC56CD05893C861A foreign key (session_id) references tl_lasbmt11_session (session_id);
+alter table tl_lasbmt11_submission_details add index FK1411A53C93C861A (session_id), add constraint FK1411A53C93C861A foreign key (session_id) references tl_lasbmt11_session (session_id);
+alter table tl_lasbmt11_submission_details add index FK1411A53C10BBAB1B (learner_id), add constraint FK1411A53C10BBAB1B foreign key (learner_id) references tl_lasbmt11_session_learners (learner_id);