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.19 -r1.20
--- lams_tool_sbmt/db/sql/table-schema.sql	2 Sep 2008 04:45:01 -0000	1.19
+++ lams_tool_sbmt/db/sql/table-schema.sql	3 Sep 2008 02:11:21 -0000	1.20
@@ -9,7 +9,7 @@
 drop table if exists tl_lasbmt11_session;
 drop table if exists tl_lasbmt11_submission_details;
 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, mark_release_notify bit, primary key (content_id));
+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, mark_release_notify tinyint DEFAULT 0, file_submit_notify tinyint DEFAULT 0, 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 float, 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));