update-a2billing-v1.0.0-to-v1.0.2-mysql.sql

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

--
-- A2Billing database - update database schema - v1.0.0 to update to v1.0.2 
--

/* 

To create the database : 

mysql -u root -p"root password" < UPDATE-a2billing-v1.0.0-to-v1.0.2-mysql.sql

*/


 
ALTER TABLE ui_authen RENAME TO cc_ui_authen;
ALTER TABLE call RENAME TO cc_call;
ALTER TABLE templatemail RENAME TO cc_templatemail;
ALTER TABLE logrefill RENAME TO cc_logrefill;
ALTER TABLE logpayment RENAME TO cc_logpayment;
ALTER TABLE trunk RENAME TO cc_trunk;