[Stack-cvs] stack-1-0/scripts/install stackUpdateDatabase.php,1.3,1.4

[pkiddie <pk...@us...>]

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

Modified Files:
	stackUpdateDatabase.php 
Log Message:
Merging of Paul Kiddie's work into main STACK HEAD branch

Index: stackUpdateDatabase.php
===================================================================
RCS file: /cvsroot/stack/stack-1-0/scripts/install/stackUpdateDatabase.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** stackUpdateDatabase.php	18 Jul 2005 12:09:12 -0000	1.3
--- stackUpdateDatabase.php	25 Aug 2005 16:06:17 -0000	1.4
***************
*** 6,13 ****
  
  <?php
- require_once('stackstd.php');
  
! /** This PHP script simply adds new fields to mySQL for metadata. This affects both questions and quizzes
  */
  $addQuestionColumnQuery = '
  ALTER TABLE stackQuestion
--- 6,18 ----
  
  <?php
  
! //<PDK>fresh installation fails to load stackstd, solved in new version
! require_once("{$stack_root}/stackstd.php");
! 
! /** This PHP script simply adds new fields to STACK database for question and quiz metadata, 
! *   and refines some existing fields
  */
+ // v1.1 - Changed questionUserLastEdited, quizUserLastEdited field to text type
+ // v1.0 - initial - added metadata fields
  $addQuestionColumnQuery = '
  ALTER TABLE stackQuestion
***************
*** 23,28 ****
      ADD COLUMN questionTimeAllocated time NULL,
      ADD COLUMN questionExcerciseType tinytext NULL,
!     ADD COLUMN questionDateLastEdited datetime NULL, 
!     DROP COLUMN questionDateLastEdited;';
      
  $addQuizColumnQuery = '
--- 28,33 ----
      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 = '
***************
*** 30,35 ****
      ADD COLUMN quizGUID varchar(22) NULL,
      ADD COLUMN quizKeywords tinytext NULL,
!     ADD COLUMN quizUserLastEdited int NULL,
!     ADD COLUMN quizDateLastEdited datetime NULL,
      ADD COLUMN quizPublisher tinytext NULL,
      ADD COLUMN type tinytext NULL,
--- 35,40 ----
      ADD COLUMN quizGUID varchar(22) NULL,
      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,