X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.5.7.lastbit;h=872d30ac3a84798caf794324bee7b679ae2ee234;hp=be6326b9d1abc3f094314159901873b42daef428;hb=50f25b285b2caf77d267ed66f03e56924ad7229f;hpb=59dffd575f6871ae0cf42589bff1e88458a2e475 diff --git a/README.1.5.7.lastbit b/README.1.5.7.lastbit index be6326b9d..872d30ac3 100644 --- a/README.1.5.7.lastbit +++ b/README.1.5.7.lastbit @@ -60,5 +60,10 @@ CREATE SEQUENCE virtual_field_vfieldnum_seq; UPDATE virtual_field SET vfieldnum = nextval('public.virtual_field_vfieldnum_seq'::text) WHERE vfieldnum IS NULL; ALTER TABLE virtual_field ALTER vfieldnum SET NOT NULL; ALTER TABLE virtual_field ADD PRIMARY KEY (vfieldnum); -ALTER TABLE h_virtual_field ADD vfieldnum int; +-- ALTER TABLE h_virtual_field ADD vfieldnum int; + +ALTER TABLE cust_pay_batch RENAME COLUMN cardnum TO payinfo; +ALTER TABLE cust_pay_batch ALTER COLUMN payinfo varchar(512) NULL; +ALTER TABLE h_cust_pay_batch RENAME COLUMN cardnum TO payinfo; +ALTER TABLE h_cust_pay_batch ALTER COLUMN payinfo varchar(512) NULL;