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 15:29:22	postnuke_official/html/install	pn71.php,1.4.2.2,1.4.2.3	John Cox
	Slight changes make the world of difference. Table changes and mod_vars update now.

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

Modified Files:
      Tag: PostNuke_71
	pn71.php 
Log Message:
Slight changes make the world of difference.  Table changes and mod_vars update now.


Index: pn71.php
===================================================================
RCS file: /home/cvsroot/postnuke_official/html/install/Attic/pn71.php,v
retrieving revision 1.4.2.2
retrieving revision 1.4.2.3
diff -C2 -d -r1.4.2.2 -r1.4.2.3
*** pn71.php	4 Aug 2002 14:51:43 -0000	1.4.2.2
--- pn71.php	4 Aug 2002 15:29:19 -0000	1.4.2.3
***************
*** 14,29 ****
  $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'");
  
  //Now lets get the module_vars up to date.
--- 14,31 ----
  $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");
+ $dbconn->Execute("ALTER TABLE $pntable[faqanswer] CHANGE pn_id_cat pn_id_cat int(6) default NULL");
+ $dbconn->Execute("ALTER TABLE $pntable[faqanswer] CHANGE 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");
! $dbconn->Execute("ALTER TABLE $pntable[faqcategories] CHANGE 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_topicid pn_topicid tinyint(4) NOT NULL default '1'");
  
  //Now lets get the module_vars up to date.

View Statistics - Next Notice - Previous Notice