Difference between revisions of "Freeside talk:1.7:Documentation:Upgrading"

From Freeside
Jump to: navigation, search
(bigger _password fields for weird LDAP encodings)
Line 84: Line 84:
  
 
<pre>
 
<pre>
ALTER TABLE svc_acct ADD _password_new varchar(512);
+
ALTER TABLE svc_acct ADD _password_new varchar(512) NOT NULL;
 
UPDATE svc_acct SET _password_new = _password;
 
UPDATE svc_acct SET _password_new = _password;
 
ALTER TABLE svc_acct DROP _password;
 
ALTER TABLE svc_acct DROP _password;
 
ALTER TABLE svc_acct RENAME _password_new TO _password;
 
ALTER TABLE svc_acct RENAME _password_new TO _password;
  
ALTER TABLE h_svc_acct ADD _password_new varchar(512);
+
ALTER TABLE h_svc_acct ADD _password_new varchar(512) NOT NULL;
 
UPDATE h_svc_acct SET _password_new = _password;
 
UPDATE h_svc_acct SET _password_new = _password;
 
ALTER TABLE h_svc_acct DROP _password;
 
ALTER TABLE h_svc_acct DROP _password;
 
ALTER TABLE h_svc_acct RENAME _password_new TO _password;
 
ALTER TABLE h_svc_acct RENAME _password_new TO _password;
 
</pre>
 
</pre>

Revision as of 03:31, 21 February 2007

int->bigint for the byte counting stuff

clear; t=svc_acct; for c in upbytes upbytes_threshold downbytes downbytes_threshold totalbytes totalbytes_threshold; do echo "ALTER TABLE $t ADD COLUMN ${c}_new bigint; UPDATE $t SET ${c}_new = CAST($c AS bigint); ALTER TABLE $t DROP COLUMN $c;

ALTER TABLE $t RENAME COLUMN ${c}_new TO $c; "; done

clear; t=prepay_credit; for c in upbytes downbytes totalbytes; do echo "ALTER TABLE $t ADD COLUMN ${c}_new bigint; UPDATE $t SET ${c}_new = CAST($c AS bigint); ALTER TABLE $t DROP COLUMN $c; ALTER TABLE $t RENAME COLUMN ${c}_new TO $c; "; done

bigger payinfo fields for encryption

ALTER TABLE cust_main ADD payinfo_new varchar(512);
UPDATE cust_main SET payinfo_new = payinfo;
ALTER TABLE cust_main DROP payinfo;
ALTER TABLE cust_main RENAME payinfo_new TO payinfo;

ALTER TABLE cust_main ADD paycvv_new varchar(512);
UPDATE cust_main SET paycvv_new = paycvv;
ALTER TABLE cust_main DROP paycvv;
ALTER TABLE cust_main RENAME paycvv_new TO paycvv;

ALTER TABLE h_cust_main ADD payinfo_new varchar(512);
UPDATE h_cust_main SET payinfo_new = payinfo;
ALTER TABLE h_cust_main DROP payinfo;
ALTER TABLE h_cust_main RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_main ADD paycvv_new varchar(512);
UPDATE h_cust_main SET paycvv_new = paycvv;
ALTER TABLE h_cust_main DROP paycvv;
ALTER TABLE h_cust_main RENAME paycvv_new TO paycvv;

ALTER TABLE cust_pay ADD payinfo_new varchar(512);
UPDATE cust_pay SET payinfo_new = payinfo;
ALTER TABLE cust_pay DROP payinfo;
ALTER TABLE cust_pay RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_pay ADD payinfo_new varchar(512);
UPDATE h_cust_pay SET payinfo_new = payinfo;
ALTER TABLE h_cust_pay DROP payinfo;
ALTER TABLE h_cust_pay RENAME payinfo_new TO payinfo;


ALTER TABLE cust_pay_void ADD payinfo_new varchar(512);
UPDATE cust_pay_void SET payinfo_new = payinfo;
ALTER TABLE cust_pay_void DROP payinfo;
ALTER TABLE cust_pay_void RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_pay_void ADD payinfo_new varchar(512);
UPDATE h_cust_pay_void SET payinfo_new = payinfo;
ALTER TABLE h_cust_pay_void DROP payinfo;
ALTER TABLE h_cust_pay_void RENAME payinfo_new TO payinfo;


ALTER TABLE cust_pay_batch ADD payinfo_new varchar(512);
UPDATE cust_pay_batch SET payinfo_new = payinfo;
ALTER TABLE cust_pay_batch DROP payinfo;
ALTER TABLE cust_pay_batch RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_pay_batch ADD payinfo_new varchar(512);
UPDATE h_cust_pay_batch SET payinfo_new = payinfo;
ALTER TABLE h_cust_pay_batch DROP payinfo;
ALTER TABLE h_cust_pay_batch RENAME payinfo_new TO payinfo;


ALTER TABLE cust_refund ADD payinfo_new varchar(512);
UPDATE cust_refund SET payinfo_new = payinfo;
ALTER TABLE cust_refund DROP payinfo;
ALTER TABLE cust_refund RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_refund ADD payinfo_new varchar(512);
UPDATE h_cust_refund SET payinfo_new = payinfo;
ALTER TABLE h_cust_refund DROP payinfo;
ALTER TABLE h_cust_refund RENAME payinfo_new TO payinfo;

bigger _password fields for weird LDAP encodings

ALTER TABLE svc_acct ADD _password_new varchar(512) NOT NULL;
UPDATE svc_acct SET _password_new = _password;
ALTER TABLE svc_acct DROP _password;
ALTER TABLE svc_acct RENAME _password_new TO _password;

ALTER TABLE h_svc_acct ADD _password_new varchar(512) NOT NULL;
UPDATE h_svc_acct SET _password_new = _password;
ALTER TABLE h_svc_acct DROP _password;
ALTER TABLE h_svc_acct RENAME _password_new TO _password;