X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.5.0pre7;h=dda49a76bf1a3227f8901865faac8a5e41c96573;hb=88d681e1d80244a5116ac431b353a6a8b59e55f3;hp=04a323ca0e6b19451aace05351045af6a3b3679b;hpb=87aa7bebdd905db78a405d41b420f5ccd6756d7a;p=freeside.git diff --git a/README.1.5.0pre7 b/README.1.5.0pre7 index 04a323ca0..dda49a76b 100644 --- a/README.1.5.0pre7 +++ b/README.1.5.0pre7 @@ -24,7 +24,7 @@ CREATE TABLE rate_prefix ( prefixnum serial NOT NULL, regionnum int NOT NULL, countrycode varchar(3) NOT NULL, - npa varchar(4) NULL, + npa varchar(6) NULL, nxx varchar(3) NULL, PRIMARY KEY (prefixnum) ); @@ -36,6 +36,9 @@ ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL; CREATE INDEX part_pkg2 ON part_pkg ( promo_code ); CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code ); +ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL; +ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL; + Installs w/integrated RT: CREATE SEQUENCE attributes_id_seq;