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)
);
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;