Changeset 880

Show
Ignore:
Timestamp:
07/10/08 09:51:02 (3 months ago)
Author:
areski
Message:

little change for backward sql update

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/DataBase/mysql-5.x/a2billing-mysql-schema-MYSQL.5.X-v1.3.0.sql

    r572 r880  
    528528INSERT INTO cc_ui_authen VALUES (1, 'root', 'myroot', 0, 32767, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-02-26 20:33:27.691314-05'); 
    529529 
    530 INSERT INTO cc_templatemail VALUES ('signup', 'info@call-labs.com', 'Call-Labs', 'SIGNUP CONFIRMATION', ' 
     530INSERT INTO cc_templatemail (mailtype, fromemail, fromname,  subject, messagetext, messagehtml) VALUES ('signup', 'info@call-labs.com', 'Call-Labs', 'SIGNUP CONFIRMATION', ' 
    531531Thank you for registering with us 
    532532 
     
    543543Call Labs 
    544544', ''); 
    545 INSERT INTO cc_templatemail VALUES ('reminder', 'info@call-labs.com', 'Call-Labs', 'REMINDER', ' 
     545INSERT INTO cc_templatemail (mailtype, fromemail, fromname,  subject, messagetext, messagehtml) VALUES ('reminder', 'info@call-labs.com', 'Call-Labs', 'REMINDER', ' 
    546546Our record indicates that you have less than $min_credit usd in your "$card_gen" account. 
    547547 
     
    563563', ''); 
    564564 
    565 INSERT INTO cc_templatemail VALUES ('forgetpassword', 'info@call-labs.com', 'Call-Labs', 'Login Information', 'Your login information is as below: 
     565INSERT INTO cc_templatemail (mailtype, fromemail, fromname,  subject, messagetext, messagehtml) VALUES ('forgetpassword', 'info@call-labs.com', 'Call-Labs', 'Login Information', 'Your login information is as below: 
    566566 
    567567Your account is $card_gen 
     
    577577', ''); 
    578578 
    579 INSERT INTO cc_templatemail VALUES ('signupconfirmed', 'info@call-labs.com', 'Call-Labs', 'SIGNUP CONFIRMATION', 'Thank you for registering with us 
     579INSERT INTO cc_templatemail (mailtype, fromemail, fromname,  subject, messagetext, messagehtml) VALUES ('signupconfirmed', 'info@call-labs.com', 'Call-Labs', 'SIGNUP CONFIRMATION', 'Thank you for registering with us 
    580580 
    581581Please make sure you active your account by making payment to us either by 
     
    594594', ''); 
    595595 
    596 INSERT INTO cc_templatemail VALUES ('epaymentverify', 'info@call-labs.com', 'Call-Labs', 'Epayment Gateway Security Verification Failed', 'Dear Administrator 
     596INSERT INTO cc_templatemail (mailtype, fromemail, fromname,  subject, messagetext, messagehtml) VALUES ('epaymentverify', 'info@call-labs.com', 'Call-Labs', 'Epayment Gateway Security Verification Failed', 'Dear Administrator 
    597597 
    598598Please check the Epayment Log, System has logged a Epayment Security failure. that may be a possible attack on epayment processing. 
     
    609609 
    610610 
    611 INSERT INTO cc_templatemail VALUES ('payment', 'info@call-labs.com', 'Call-Labs', 'PAYMENT CONFIRMATION', 'Thank you for shopping at Call-Labs. 
     611INSERT INTO cc_templatemail (mailtype, fromemail, fromname,  subject, messagetext, messagehtml) VALUES ('payment', 'info@call-labs.com', 'Call-Labs', 'PAYMENT CONFIRMATION', 'Thank you for shopping at Call-Labs. 
    612612 
    613613Shopping details is as below. 
     
    624624', ''); 
    625625 
    626 INSERT INTO cc_templatemail VALUES ('invoice', 'info@call-labs.com', 'Call-Labs', 'A2BILLING INVOICE', 'Dear Customer. 
     626INSERT INTO cc_templatemail (mailtype, fromemail, fromname,  subject, messagetext, messagehtml) VALUES ('invoice', 'info@call-labs.com', 'Call-Labs', 'A2BILLING INVOICE', 'Dear Customer. 
    627627 
    628628Attached is the invoice. 


Google