Changeset 4103

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

#1736 change incoming alertinfo fields to varchar(255) to accomodate URLs

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • freepbx/trunk/SQL/newinstall.sql

    r4074 r4103  
    281281  `wait` int(2) default NULL, 
    282282  `privacyman` tinyint(1) default NULL, 
    283   `alertinfo` varchar(32) default NULL, 
     283  `alertinfo` varchar(255) default NULL, 
    284284  `channel` varchar(20) default NULL, 
    285285  `ringing` varchar(20) default NULL, 

  • freepbx/trunk/SQL/newinstall.sqlite3.sql

    r4074 r4103  
    269269  `wait` int(2) default NULL, 
    270270  `privacyman` tinyint(1) default NULL, 
    271   `alertinfo` varchar(32) default NULL, 
     271  `alertinfo` varchar(255) default NULL, 
    272272  `channel` varchar(20) default NULL, 
    273273  `ringing` varchar(20) default NULL 

  • freepbx/trunk/upgrades/2.3.0alpha/tables.php

    r4062 r4103  
    172172} 
    173173 
    174 outn("Alter tables sip, iax, zap to increase field length.. "); 
     174outn("Alter tables sip, iax, zap, incoming to increase field length.. "); 
    175175$db->query("ALTER TABLE sip CHANGE data data VARCHAR( 255 ) NOT NULL"); 
    176176$db->query("ALTER TABLE iax CHANGE data data VARCHAR( 255 ) NOT NULL"); 
    177177$db->query("ALTER TABLE zap CHANGE data data VARCHAR( 255 ) NOT NULL"); 
     178$db->query("ALTER TABLE incoming CHANGE alertinfo alertinfo VARCHAR( 255 ) NULL"); 
    178179out("Altered"); 
    179180