?? update-a2billing-v1.2.2-to-v1.2.3-mysql.sql
字號:
---- A2Billing database - update database schema - v1.2.2 to update to v1.2.3--/* To create the database : mysql -u root -p"root password" < UPDATE-a2billing-v1.2.2-to-v1.2.3-mysql.sql*/ -- inital balance : it would be used by the cron in order to refill automatically each monthALTER TABLE cc_card ADD COLUMN initialbalance DECIMAL(15,5);ALTER TABLE cc_card ALTER COLUMN initialbalance SET DEFAULT 0;UPDATE cc_card SET initialbalance = '0';-- invoiceday : day of the month when the customer invoice need to be created ALTER TABLE cc_card ADD COLUMN invoiceday INT;ALTER TABLE cc_card ALTER COLUMN invoiceday SET DEFAULT 1;UPDATE cc_card SET invoiceday = '1';-- autorefill : define if the automatic refill will be permorfed on this cardALTER TABLE cc_card ADD COLUMN autorefill INT;ALTER TABLE cc_card ALTER COLUMN autorefill SET DEFAULT 0;UPDATE cc_card SET autorefill = '0';-- Auto Refill Report Table CREATE TABLE cc_autorefill_report ( id BIGINT NOT NULL AUTO_INCREMENT, daterun TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, totalcardperform INT, totalcredit DECIMAL(15,5), PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;-- Add Buying cost into the reportingALTER TABLE cc_call ADD COLUMN buyrate DECIMAL(15,5);ALTER TABLE cc_call ALTER COLUMN buyrate SET DEFAULT 0;ALTER TABLE cc_call ADD COLUMN buycost DECIMAL(15,5);ALTER TABLE cc_call ALTER COLUMN buycost SET DEFAULT 0;ALTER TABLE cc_card ADD COLUMN loginkey CHAR(40);ALTER TABLE cc_card ADD COLUMN activatedbyuser char(1) DEFAULT 'f' NOT NULL;INSERT INTO cc_templatemail VALUES ('forgetpassword', 'info@call-labs.com', 'Call-Labs', 'Login Information', 'Your login information is as below:Your account is $card_genYour password is $passwordYour cardalias is $cardaliashttp://call-labs.com/A2BCustomer_UI/Kind regards,Call Labs', '');INSERT INTO cc_templatemail VALUES ('signupconfirmed', 'info@call-labs.com', 'Call-Labs', 'SIGNUP CONFIRMATION', 'Thank you for registering with usPlease make sure you active your account by making payment to us either bycredit card, wire transfer, money order, cheque, and western union moneytransfer, money Gram, and Pay pal.Your account is $card_genYour password is $passwordTo go to your account :http://call-labs.com/A2BCustomer_UI/Kind regards,Call Labs', '');
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -