-# $Header: /cvsroot/tikiwiki/tiki/db/tiki_1.8to1.9.sql,v 1.56 2004-05-02 04:18:21 rlpowell Exp $
+# $Header: /cvsroot/tikiwiki/tiki/db/tiki_1.8to1.9.sql,v 1.57 2004-05-05 00:31:29 ggeller Exp $
 
 # The following script will update a tiki database from verion 1.8 to 1.9
 # 

  PRIMARY KEY  (id,version)
) TYPE=MyISAM;

CREATE TABLE hw_pages (
  id int(14) NOT NULL auto_increment,
  assignmentId int(14) NOT NULL default '0',
  studentName varchar(200) NOT NULL default '',

  KEY dueDate (dueDate)
) TYPE=MyISAM;

rename table hw_grading_queue to tiki_hw_grading_queue;
CREATE TABLE tiki_hw_grading_queue (
  id int(14) NOT NULL auto_increment,
  status int(4) default NULL,
  submissionDate int(14) default NULL,
