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]
09 Aug 2002 16:39:31	postnuke_official/html/install	newtables.php,1.40.2.7,1.40.2.8	John Robeson
	changing all pn_url fields to varchar(255) and a couple titles to 150 .. please checkover them..

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

Modified Files:
      Tag: PostNuke_71
	newtables.php 
Log Message:
changing all pn_url fields to varchar(255) and a couple titles to 150 .. please checkover them..


Index: newtables.php
===================================================================
RCS file: /home/cvsroot/postnuke_official/html/install/Attic/newtables.php,v
retrieving revision 1.40.2.7
retrieving revision 1.40.2.8
diff -C2 -d -r1.40.2.7 -r1.40.2.8
*** newtables.php	3 Aug 2002 16:12:44 -0000	1.40.2.7
--- newtables.php	9 Aug 2002 16:39:29 -0000	1.40.2.8
***************
*** 124,128 ****
    pn_name varchar(60) NOT NULL default '',
    pn_email varchar(60) default NULL,
!   pn_url varchar(60) default NULL,
    pn_host_name varchar(60) default NULL,
    pn_subject varchar(85) NOT NULL default '',
--- 124,128 ----
    pn_name varchar(60) NOT NULL default '',
    pn_email varchar(60) default NULL,
!   pn_url varchar(255) default NULL,
    pn_host_name varchar(60) default NULL,
    pn_subject varchar(85) NOT NULL default '',
***************
*** 163,167 ****
    pn_sid int(11) NOT NULL default '0',
    pn_title varchar(100) NOT NULL default '',
!   pn_url varchar(100) NOT NULL default '',
    pn_description text NOT NULL,
    pn_date datetime default NULL,
--- 163,167 ----
    pn_sid int(11) NOT NULL default '0',
    pn_title varchar(100) NOT NULL default '',
!   pn_url varchar(255) NOT NULL default '',
    pn_description text NOT NULL,
    pn_date datetime default NULL,
***************
*** 202,206 ****
    pn_sid int(11) NOT NULL default '0',
    pn_title varchar(100) NOT NULL default '',
!   pn_url varchar(100) NOT NULL default '',
    pn_description text NOT NULL,
    pn_modifysubmitter varchar(60) NOT NULL default '',
--- 202,206 ----
    pn_sid int(11) NOT NULL default '0',
    pn_title varchar(100) NOT NULL default '',
!   pn_url varchar(255) NOT NULL default '',
    pn_description text NOT NULL,
    pn_modifysubmitter varchar(60) NOT NULL default '',
***************
*** 223,227 ****
    pn_sid int(11) NOT NULL default '0',
    pn_title varchar(100) NOT NULL default '',
!   pn_url varchar(100) NOT NULL default '',
    pn_description text NOT NULL,
    pn_name varchar(100) NOT NULL default '',
--- 223,227 ----
    pn_sid int(11) NOT NULL default '0',
    pn_title varchar(100) NOT NULL default '',
!   pn_url varchar(255) NOT NULL default '',
    pn_description text NOT NULL,
    pn_name varchar(100) NOT NULL default '',
***************
*** 588,592 ****
    pn_name varchar(60) NOT NULL default '',
    pn_email varchar(60) default NULL,
!   pn_url varchar(60) default NULL,
    pn_host_name varchar(60) default NULL,
    pn_subject varchar(60) NOT NULL default '',
--- 588,592 ----
    pn_name varchar(60) NOT NULL default '',
    pn_email varchar(60) default NULL,
!   pn_url varchar(255) default NULL,
    pn_host_name varchar(60) default NULL,
    pn_subject varchar(60) NOT NULL default '',
***************
*** 659,663 ****
  CREATE TABLE ".$prefix."_referer (
    pn_rid int(11) NOT NULL auto_increment,
!   pn_url varchar(100) NOT NULL default '',
    pn_frequency int(15) default NULL,
    PRIMARY KEY  (pn_rid)
--- 659,663 ----
  CREATE TABLE ".$prefix."_referer (
    pn_rid int(11) NOT NULL auto_increment,
!   pn_url varchar(255) NOT NULL default '',
    pn_frequency int(15) default NULL,
    PRIMARY KEY  (pn_rid)
***************
*** 672,676 ****
    pn_tid int(11) NOT NULL default '0',
    pn_name varchar(30) NOT NULL default '',
!   pn_url varchar(200) NOT NULL default '',
    PRIMARY KEY  (pn_rid)
  )
--- 672,676 ----
    pn_tid int(11) NOT NULL default '0',
    pn_name varchar(30) NOT NULL default '',
!   pn_url varchar(255) NOT NULL default '',
    PRIMARY KEY  (pn_rid)
  )
***************
*** 689,694 ****
    pn_score int(11) NOT NULL default '0',
    pn_cover varchar(100) NOT NULL default '',
!   pn_url varchar(100) NOT NULL default '',
!   pn_url_title varchar(50) NOT NULL default '',
    pn_hits int(11) NOT NULL default '0',
    pn_language varchar(30) NOT NULL default '',
--- 689,694 ----
    pn_score int(11) NOT NULL default '0',
    pn_cover varchar(100) NOT NULL default '',
!   pn_url varchar(255) NOT NULL default '',
!   pn_url_title varchar(150) NOT NULL default '',
    pn_hits int(11) NOT NULL default '0',
    pn_language varchar(30) NOT NULL default '',
***************
*** 708,713 ****
    pn_email varchar(60) default NULL,
    pn_score int(11) NOT NULL default '0',
!   pn_url varchar(100) NOT NULL default '',
!   pn_url_title varchar(50) NOT NULL default '',
    pn_language varchar(30) NOT NULL default '',
    PRIMARY KEY  (pn_id)
--- 708,713 ----
    pn_email varchar(60) default NULL,
    pn_score int(11) NOT NULL default '0',
!   pn_url varchar(255) NOT NULL default '',
!   pn_url_title varchar(150) NOT NULL default '',
    pn_language varchar(30) NOT NULL default '',
    PRIMARY KEY  (pn_id)
***************
*** 926,930 ****
    pn_email varchar(60) NOT NULL default '',
    pn_femail varchar(60) NOT NULL default '',
!   pn_url varchar(100) NOT NULL default '',
    pn_user_avatar varchar(30) default NULL,
    pn_user_regdate varchar(20) NOT NULL default '',
--- 926,930 ----
    pn_email varchar(60) NOT NULL default '',
    pn_femail varchar(60) NOT NULL default '',
!   pn_url varchar(255) NOT NULL default '',
    pn_user_avatar varchar(30) default NULL,
    pn_user_regdate varchar(20) NOT NULL default '',

View Statistics - Next Notice - Previous Notice