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,
|
