logicampus-cvs

[Mark K <har...@us...>]

Update of /cvsroot/logicampus/logicampus/data
In directory sc8-pr-cvs6.sourceforge.net:/tmp/cvs-serv15346/data

Modified Files:
	class_lesson_sequence.mysql.sql 
Log Message:
Updating class lesson sequence schema to include start, stop, and due times.


Index: class_lesson_sequence.mysql.sql
===================================================================
RCS file: /cvsroot/logicampus/logicampus/data/class_lesson_sequence.mysql.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** class_lesson_sequence.mysql.sql	2 Oct 2007 17:06:36 -0000	1.6
--- class_lesson_sequence.mysql.sql	27 Oct 2007 17:22:56 -0000	1.7
***************
*** 2,6 ****
  -- entity version: 0.0
  -- DB type: mysql
! -- generated on: 09.30.2007
  
  
--- 2,6 ----
  -- entity version: 0.0
  -- DB type: mysql
! -- generated on: 10.27.2007
  
  
***************
*** 19,24 ****
--- 19,27 ----
  	`not_before_seq_id` int (11), 
  	`start_offset` int (11), 
+ 	`start_time` mediumint (5) unsigned, 
  	`end_offset` int (11), 
+ 	`end_time` mediumint (5) unsigned, 
  	`due_offset` int (11), 
+ 	`due_time` mediumint (5) unsigned, 
  	`grace_period_days` int (11), 
  	`rank` integer (11) NOT NULL, 
***************
*** 28,35 ****
  );
  
! CREATE INDEX class_idx ON class_lesson_sequence (class_id);
! CREATE INDEX lesson_idx ON class_lesson_sequence (lesson_id);
! CREATE INDEX lob_class_repo_idx ON class_lesson_sequence (lob_class_repo_id);
! CREATE INDEX rank_idx ON class_lesson_sequence (rank);
! CREATE INDEX link_text_idx ON class_lesson_sequence (link_text);
  
--- 31,38 ----
  );
  
! CREATE INDEX `class_idx` ON `class_lesson_sequence` (`class_id`);
! CREATE INDEX `lesson_idx` ON `class_lesson_sequence` (`lesson_id`);
! CREATE INDEX `lob_class_repo_idx` ON `class_lesson_sequence` (`lob_class_repo_id`);
! CREATE INDEX `rank_idx` ON `class_lesson_sequence` (`rank`);
! CREATE INDEX `link_text_idx` ON `class_lesson_sequence` (`link_text`);