?? update-a2billing-v1.1.0-to-v1.2.0-mysql.sql
字號:
---- 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;
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -