Show
Ignore:
Timestamp:
06/20/07 20:42:52 (6 years ago)
Author:
p_lindheimer
Message:

Merged revisions 4102 via svnmerge from
https://amportal.svn.sourceforge.net/svnroot/amportal/modules/branches/2.3

........

r4102 | p_lindheimer | 2007-06-20 17:32:18 -0700 (Wed, 20 Jun 2007) | 1 line


#1736 change findmefollow and ringgroup alertinfo fields to varchar(255) to accomodate URLs

........

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • modules/branches/2.2

    • Property svnmerge-integrated changed from /modules/branches/2.1:1-2166,2289,2414,2419,2424,2430,2449,2458,2462,2476 /modules/branches/2.3:1-3256 to /modules/branches/2.1:1-2166,2289,2414,2419,2424,2430,2449,2458,2462,2476 /modules/branches/2.3:1-3256,4102

  • modules/branches/2.2/ringgroups/install.php

    r2094 r4104  
    3333if(DB::IsError($check)) { 
    3434  // add new field 
    35     $sql = "ALTER TABLE ringgroups ADD alertinfo VARCHAR( 35 ) NULL ;"; 
     35    $sql = "ALTER TABLE ringgroups ADD alertinfo VARCHAR( 255 ) NULL ;"; 
    3636    $result = $db->query($sql); 
    3737    if(DB::IsError($result)) { 
    …… 
    3939    } 
    4040} 
     41// increase size for older installs 
     42$db->query("ALTER TABLE ringgroups CHANGE alertinfo alertinfo VARCHAR( 255 ) NULL"); 
    4143 
    4244// Version 2.0 upgrade. Yeah. 2.0 baby!  

  • modules/branches/2.2/ringgroups/install.sql

    r2073 r4104  
    1 CREATE TABLE IF NOT EXISTS `ringgroups` ( `grpnum` BIGINT( 11 ) NOT NULL , `strategy` VARCHAR( 50 ) NOT NULL , `grptime` SMALLINT NOT NULL , `grppre` VARCHAR( 100 ) NULL , `grplist` VARCHAR( 255 ) NOT NULL , `annmsg` VARCHAR( 255 ) NULL , `postdest` VARCHAR( 255 ) NULL , `description` VARCHAR( 35 ) NOT NULL , `alertinfo` VARCHAR ( 50 ) NULL , remotealert VARCHAR ( 80 ), needsconf VARCHAR ( 10 ), toolate VARCHAR ( 80 ), PRIMARY KEY  (`grpnum`) ) TYPE = MYISAM ;  
     1CREATE TABLE IF NOT EXISTS `ringgroups` ( `grpnum` BIGINT( 11 ) NOT NULL , `strategy` VARCHAR( 50 ) NOT NULL , `grptime` SMALLINT NOT NULL , `grppre` VARCHAR( 100 ) NULL , `grplist` VARCHAR( 255 ) NOT NULL , `annmsg` VARCHAR( 255 ) NULL , `postdest` VARCHAR( 255 ) NULL , `description` VARCHAR( 35 ) NOT NULL , `alertinfo` VARCHAR ( 255 ) NULL , remotealert VARCHAR ( 80 ), needsconf VARCHAR ( 10 ), toolate VARCHAR ( 80 ), PRIMARY KEY  (`grpnum`) ) TYPE = MYISAM ;