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.20 -r1.21
--- lams_tool_sbmt/db/sql/table-schema.sql	3 Sep 2008 02:11:21 -0000	1.20
+++ lams_tool_sbmt/db/sql/table-schema.sql	30 Jul 2012 18:54:54 -0000	1.21
@@ -9,9 +9,9 @@
 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 tinyint DEFAULT 0, file_submit_notify tinyint DEFAULT 0, primary key (content_id));
+create table tl_lasbmt11_content (content_id bigint not null, title varchar(64) not null, instruction longtext, define_later bit not null, run_offline bit not null, offline_instruction longtext, online_instruction longtext, 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, submission_deadline datetime, mark_release_notify bit, file_submit_notify bit, 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_report (report_id bigint not null auto_increment, comments longtext, marks float, date_marks_released datetime, mark_file_uuid bigint, mark_file_name varchar(255), mark_file_version_id bigint, 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_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));
