Index: lams_tool_sbmt/db/sql/table-schema.sql =================================================================== diff -u -re7f9f5772bf6f3cf2786a65e78d7de441d348c37 -ra01292ae06e058ffcc16aaeec6d61959a7b69273 --- lams_tool_sbmt/db/sql/table-schema.sql (.../table-schema.sql) (revision e7f9f5772bf6f3cf2786a65e78d7de441d348c37) +++ lams_tool_sbmt/db/sql/table-schema.sql (.../table-schema.sql) (revision a01292ae06e058ffcc16aaeec6d61959a7b69273) @@ -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, 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 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 bigint, date_marks_released datetime, primary key (report_id)); +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)); 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));