[Stack-cvs] stack-1-0/scripts/install stackUpdateDatabase.php,1.6,1.7

[Chris S. <san...@us...>]

Update of /cvsroot/stack/stack-1-0/scripts/install
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25899/scripts/install

Modified Files:
	stackUpdateDatabase.php 
Log Message:


Index: stackUpdateDatabase.php
===================================================================
RCS file: /cvsroot/stack/stack-1-0/scripts/install/stackUpdateDatabase.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** stackUpdateDatabase.php	29 Aug 2005 18:41:03 -0000	1.6
--- stackUpdateDatabase.php	30 Aug 2005 14:29:25 -0000	1.7
***************
*** 7,11 ****
  <?php
  
! require_once("{$stack_root}/stackConfig.php");
  
  /** This PHP script simply adds new fields to STACK database for question and quiz metadata, 
--- 7,12 ----
  <?php
  
! require_once("../../stackConfig.php");
! require_once("../../stackLib.php");
  
  /** This PHP script simply adds new fields to STACK database for question and quiz metadata, 
***************
*** 27,32 ****
      ADD COLUMN questionTimeAllocated time NULL,
      ADD COLUMN questionExcerciseType tinytext NULL,
!     CHANGE questionDateLastEdited questionDateLastEdited TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
!     CHANGE questionUserLastEdited questionUserLastEdited TEXT NULL;';
      
  $addQuizColumnQuery = '
--- 28,33 ----
      ADD COLUMN questionTimeAllocated time NULL,
      ADD COLUMN questionExcerciseType tinytext NULL,
!     CHANGE COLUMN questionDateLastEdited questionDateLastEdited TIMESTAMP NULL,
!     CHANGE COLUMN questionUserLastEdited questionUserLastEdited TEXT NULL;';
      
  $addQuizColumnQuery = '
***************
*** 35,39 ****
      ADD COLUMN quizKeywords tinytext NULL,
      ADD COLUMN quizUserLastEdited TEXT NULL,
!     ADD COLUMN quizDateLastEdited TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
      ADD COLUMN quizPublisher tinytext NULL,
      ADD COLUMN type tinytext NULL,
--- 36,40 ----
      ADD COLUMN quizKeywords tinytext NULL,
      ADD COLUMN quizUserLastEdited TEXT NULL,
!     ADD COLUMN quizDateLastEdited TIMESTAMP NULL,
      ADD COLUMN quizPublisher tinytext NULL,
      ADD COLUMN type tinytext NULL,