Changeset 586

Show
Ignore:
Timestamp:
02/08/08 08:39:11 (10 months ago)
Author:
areski
Message:

UPDATE : SQL change for voicemail update

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • experimental_v2/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql

    r573 r586  
    731731 
    732732-- VOICEMAIL CHANGES 
     733ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
     734ALTER TABLE cc_card ADD voicemail_activated SMALLINT DEFAULT 0 NOT NULL; 
     735 
    733736 
    734737CREATE OR REPLACE VIEW voicemail_users AS ( 
     
    738741); 
    739742 
    740 ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
    741 ALTER TABLE cc_card ADD voicemail_activated SMALLINT DEFAULT 0 NOT NULL; 
    742  
    743  
     743 
     744 
     745 
  • experimental_v2/DataBase/psql/UPDATE-a2billing-v1.3.0-to-v1.4.0-pgsql.sql

    r530 r586  
    746746 
    747747-- VOICEMAIL CHANGES 
     748ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
     749ALTER TABLE cc_card ADD voicemail_activated INTEGER DEFAULT 0 NOT NULL; 
     750 
    748751 
    749752CREATE OR REPLACE VIEW voicemail_users AS ( 
     
    754757 
    755758 
    756 ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
    757 ALTER TABLE cc_card ADD voicemail_activated INTEGER DEFAULT 0 NOT NULL; 
    758  
    759  
    760  
     759 
  • trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql

    r573 r586  
    731731 
    732732-- VOICEMAIL CHANGES 
     733ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
     734ALTER TABLE cc_card ADD voicemail_activated SMALLINT DEFAULT 0 NOT NULL; 
     735 
    733736 
    734737CREATE OR REPLACE VIEW voicemail_users AS ( 
     
    738741); 
    739742 
    740 ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
    741 ALTER TABLE cc_card ADD voicemail_activated SMALLINT DEFAULT 0 NOT NULL; 
    742  
    743  
     743 
     744 
     745 
  • trunk/DataBase/psql/UPDATE-a2billing-v1.3.0-to-v1.4.0-pgsql.sql

    r530 r586  
    746746 
    747747-- VOICEMAIL CHANGES 
     748ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
     749ALTER TABLE cc_card ADD voicemail_activated INTEGER DEFAULT 0 NOT NULL; 
     750 
    748751 
    749752CREATE OR REPLACE VIEW voicemail_users AS ( 
     
    754757 
    755758 
    756 ALTER TABLE cc_card ADD voicemail_permitted INTEGER DEFAULT 0 NOT NULL; 
    757 ALTER TABLE cc_card ADD voicemail_activated INTEGER DEFAULT 0 NOT NULL; 
    758  
    759  
    760  
     759 


Google