update-a2billing-v1.1.0-to-v1.2.0-mysql.sql

来自「asterisk 計費模塊」· SQL 代码 · 共 36 行

--
-- A2Billing database - update database schema - v1.1.0 to update to v1.2.0
--

/* 

To create the database : 

mysql -u root -p"root password" < UPDATE-a2billing-v1.1.0-to-v1.2.0-mysql.sql

*/


 
 
 
ALTER TABLE cc_sip_buddies ADD COLUMN fullcontact varchar(80);
ALTER TABLE cc_sip_buddies ALTER COLUMN fullcontact SET default NULL;

 
ALTER TABLE cc_sip_buddies ADD COLUMN setvar varchar(80);
ALTER TABLE cc_sip_buddies ALTER COLUMN setvar SET default NULL;


ALTER TABLE cc_card ADD COLUMN nbservice INT;
ALTER TABLE cc_card ALTER COLUMN nbservice SET DEFAULT 0;
UPDATE cc_card SET nbservice = '0';


ALTER TABLE cc_card ADD COLUMN vat float;
ALTER TABLE cc_card ALTER COLUMN vat SET DEFAULT 0;
UPDATE cc_card SET vat = '0';


ALTER TABLE cc_card ADD COLUMN servicelastrun TIMESTAMP;