-- $Id: create_lams_tool_behaviourComposer.sql,v 1.21 2006/08/17 02:16:08 steven Exp $

SET FOREIGN_KEY_CHECKS=0;
drop table if exists tl_kkbc10_content;
drop table if exists tl_kkbc10_instruction_files;
drop table if exists tl_kkbc10_report;
drop table if exists tl_kkbc10_session;
drop table if exists tl_kkbc10_session_learners;
drop table if exists tl_kkbc10_submission_details;
create table tl_kkbc10_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,
   primary key (content_id)
);
create table tl_kkbc10_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_kkbc10_report (
   report_id bigint not null auto_increment,
   comments varchar(250),
   marks bigint,
   date_marks_released datetime,
   primary key (report_id)
);
create table tl_kkbc10_session (
   session_id bigint not null,
   status integer not null,
   content_id bigint,
   session_name varchar(250),
   primary key (session_id)
);
create table tl_kkbc10_session_learners (
   learner_id bigint not null auto_increment,
   user_id bigint,
   finished bit,
   session_id bigint,
   primary key (learner_id)
);
create table tl_kkbc10_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)
);
alter table tl_kkbc10_instruction_files add index (content_id), add constraint foreign key (content_id) references tl_kkbc10_content (content_id);
alter table tl_kkbc10_session add index  (content_id), add constraint foreign key (content_id) references tl_kkbc10_content (content_id);
alter table tl_kkbc10_session_learners add index  (session_id), add constraint foreign key (session_id) references tl_kkbc10_session (session_id);
alter table tl_kkbc10_submission_details add index  (session_id), add constraint foreign key (session_id) references tl_kkbc10_session (session_id);
alter table tl_kkbc10_submission_details add index  (learner_id), add constraint foreign key (learner_id) references tl_kkbc10_session_learners (learner_id);

INSERT INTO `tl_kkbc10_content` (content_id,title,instruction,define_later,run_offline,content_in_use,lock_on_finished) values(${default_content_id},"BehaviourComposer files","Upload your files below...",0,0,0,0);
SET FOREIGN_KEY_CHECKS=1;