Xaraya / Postnuke CVS Notices - Message

Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites

Directory filter : [ all ] / postnuke_official / html / install [ view in CVS ]

Date	Directory [filter]	File(s) [view]	Author [filter]
04 Aug 2002 14:39:51	postnuke_official/html/install	pn71.php,NONE,1.4.2.1	John Cox
	First of many changes for the 71 upgrade. Table changes in this one to start.

Update of /home/cvsroot/postnuke_official/html/install
In directory ns7.hostnuke.net:/tmp/cvs-serv7809/html/install

Added Files:
      Tag: PostNuke_71
	pn71.php 
Log Message:
First of many changes for the 71 upgrade.  Table changes in this one to start.


--- NEW FILE: pn71.php ---
<?php
// $Id: pn71.php,v 1.4.2.1 2002/08/04 14:39:49 niceguyeddie Exp $
// Upgrade from PostNuke .71 to PostNuke .72
//
// Note that this is upgrade script uses ADODB instead
// of raw mysql

global $dbconn, $pntable, $prefix;
include_once 'install/pntables71.php';


// Table structure changes first

$dbconn->Execute("ALTER TABLE $pntable[users] CHANGE pn_ublock pn_ublock text NOT NULL");


$dbconn->Execute("ALTER TABLE $pntable[faqanswer] CHANGE pn_id pn_id int(6) NOT NULL auto_increment, pn_id_cat pn_id_cat int(6) default NULL, pn_question pn_question text default NULL");
$dbconn->Execute("ALTER TABLE $pntable[faqcategories] CHANGE pn_id_cat pn_id_cat int(6) NOT NULL auto_increment, pn_parent_id pn_parent_id int(6) NOT NULL default '0',");


$dbconn->Execute("ALTER TABLE $pntable[links_links] CHANGE pn_url pn_url varchar(255) NOT NULL default");
$dbconn->Execute("ALTER TABLE $pntable[links_modrequest] CHANGE pn_url pn_url varchar(255) NOT NULL default");
$dbconn->Execute("ALTER TABLE $pntable[links_newlink] CHANGE pn_url pn_url varchar(255) NOT NULL default");

$dbconn->Execute("ALTER TABLE $pntable[autonews] CHANGE pn_topic pn_topic tinyint(4) NOT NULL default '1'");
$dbconn->Execute("ALTER TABLE $pntable[stories] CHANGE pn_topic pn_topic tinyint(4) NOT NULL default '1'");
$dbconn->Execute("ALTER TABLE $pntable[topics] CHANGE pn_topic pn_topic tinyint(4) NOT NULL default '1'");


?>

View Statistics - Next Notice - Previous Notice