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.17 -r1.18
--- lams_tool_sbmt/db/sql/table-schema.sql	1 Sep 2006 06:45:16 -0000	1.17
+++ lams_tool_sbmt/db/sql/table-schema.sql	5 Sep 2006 04:05:23 -0000	1.18
@@ -1,20 +1,22 @@
+alter table tl_lasbmt11_content drop foreign key FKAEF329AC172BC670;
 alter table tl_lasbmt11_instruction_files drop foreign key FKA75538F9785A173A;
 alter table tl_lasbmt11_session drop foreign key FKEC8C77C9785A173A;
-alter table tl_lasbmt11_submission_details drop foreign key FK1411A53C10BBAB1B;
+alter table tl_lasbmt11_submission_details drop foreign key FK1411A53CFFD5A38B;
 alter table tl_lasbmt11_submission_details drop foreign key FK1411A53C93C861A;
 drop table if exists tl_lasbmt11_content;
 drop table if exists tl_lasbmt11_instruction_files;
 drop table if exists tl_lasbmt11_report;
 drop table if exists tl_lasbmt11_session;
-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, instruction text, define_later bit not null, run_offline bit not null, offline_instruction text, online_instruction text, content_in_use bit, lock_on_finished bit, reflect_instructions varchar(255), reflect_on_activity bit, primary key (content_id));
+drop table if exists tl_lasbmt11_user;
+create table tl_lasbmt11_content (content_id bigint not null, title varchar(64) not null, instruction text, define_later bit not null, run_offline bit not null, offline_instruction text, online_instruction text, content_in_use bit, lock_on_finished bit, reflect_instructions varchar(255), reflect_on_activity bit, limit_upload bit, limit_upload_number integer, created datetime, created_by bigint, updated datetime, primary key (content_id));
 create table tl_lasbmt11_instruction_files (uid bigint not null auto_increment, uuid bigint, version_id bigint, type varchar(20), name varchar(255), content_id bigint, primary key (uid));
 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, status integer not null, content_id bigint, session_name varchar(250), primary key (session_id));
-create table tl_lasbmt11_session_learners (learner_id bigint not null auto_increment, user_id integer, finished bit, session_id bigint, first_name varchar(255), login_name varchar(255), last_name varchar(255), primary key (learner_id));
 create table tl_lasbmt11_submission_details (submission_id bigint not null auto_increment, filePath varchar(250), fileDescription varchar(250), date_of_submission datetime, uuid bigint, version_id bigint, session_id bigint, learner_id bigint, primary key (submission_id));
+create table tl_lasbmt11_user (uid bigint not null auto_increment, user_id integer, finished bit, session_id bigint, first_name varchar(255), login_name varchar(255), last_name varchar(255), content_id bigint, primary key (uid));
+alter table tl_lasbmt11_content add index FKAEF329AC172BC670 (created_by), add constraint FKAEF329AC172BC670 foreign key (created_by) references tl_lasbmt11_user (uid);
 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_submission_details add index FK1411A53C10BBAB1B (learner_id), add constraint FK1411A53C10BBAB1B foreign key (learner_id) references tl_lasbmt11_session_learners (learner_id);
+alter table tl_lasbmt11_submission_details add index FK1411A53CFFD5A38B (learner_id), add constraint FK1411A53CFFD5A38B foreign key (learner_id) references tl_lasbmt11_user (uid);
 alter table tl_lasbmt11_submission_details add index FK1411A53C93C861A (session_id), add constraint FK1411A53C93C861A foreign key (session_id) references tl_lasbmt11_session (session_id);