Index: lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql,v
diff -u -r1.23 -r1.24
--- lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	4 Sep 2006 02:20:04 -0000	1.23
+++ lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	5 Sep 2006 04:04:59 -0000	1.24
@@ -5,7 +5,7 @@
 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_user;
 drop table if exists tl_lasbmt11_submission_details;
 create table tl_lasbmt11_content (
    content_id bigint not null,
@@ -19,8 +19,25 @@
    lock_on_finished smallint,
    reflect_instructions varchar(255), 
    reflect_on_activity smallint, 
+   limit_upload smallint, 
+   limit_upload_number integer,
+   created datetime, 
+   created_by bigint, 
+   updated datetime,
    primary key (content_id)
 )TYPE=InnoDB;
+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)
+)TYPE=InnoDB;
+
 create table tl_lasbmt11_instruction_files (
    uid bigint not null auto_increment,
    uuid bigint,
@@ -44,16 +61,6 @@
    session_name varchar(250),
    primary key (session_id)
 )TYPE=InnoDB;
-create table tl_lasbmt11_session_learners (
-   learner_id bigint not null auto_increment,
-   user_id bigint,
-   finished smallint,
-   session_id bigint,
-   first_name varchar(255), 
-   login_name varchar(255), 
-   last_name varchar(255), 
-   primary key (learner_id)
-)TYPE=InnoDB;
 create table tl_lasbmt11_submission_details (
    submission_id bigint not null auto_increment,
    filePath varchar(250),
@@ -65,11 +72,13 @@
    learner_id bigint,
    primary key (submission_id)
 )TYPE=InnoDB;
+
+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_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 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);
-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);
 
-INSERT INTO `tl_lasbmt11_content` (content_id,title,instruction,define_later,run_offline,content_in_use,lock_on_finished,reflect_on_activity) values(${default_content_id},"Submit files","Upload your files below...",0,0,0,0,0);
+
+INSERT INTO `tl_lasbmt11_content` (content_id,title,instruction,define_later,run_offline,content_in_use,lock_on_finished,reflect_on_activity,limit_upload,limit_upload_number) values(${default_content_id},"Submit files","Upload your files below...",0,0,0,0,0,0,1);
 SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file