alter table tl_lasbmt11_submission_details drop foreign key FK1411A53CEAF0A006;
drop table if exists tl_lasbmt11_report;
drop table if exists tl_lasbmt11_content;
drop table if exists tl_lasbmt11_submission_details;
drop table if exists tl_lasbmt11_session;
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_content (
   content_id bigint not null,
   title varchar(64) not null,
   instructions varchar(64),
   defineLater bit,
   runOffline bit,
   primary key (content_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,
   report_id bigint,
   user_id bigint,
   session_id bigint,
   primary key (submission_id)
);
create table tl_lasbmt11_session (
   session_id bigint not null auto_increment,
   status integer not null,
   content_id bigint,
   primary key (session_id)
);
alter table tl_lasbmt11_submission_details add index FK1411A53CEAF0A006 (report_id), add constraint FK1411A53CEAF0A006 foreign key (report_id) references tl_lasbmt11_report (report_id);
