blob: 872d30ac3a84798caf794324bee7b679ae2ee234 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
this is ONLY for people upgrading from CVS snapshots after march 12th who
have most of the changes in README.1.5.7 already.
if you're upgrading from 1.5.0pre6, see README.1.5.7 instead.
if you're upgrading from 1.4.x, see httemplate/docs/upgrade10.html instead.
ALTER TABLE rate_detail ADD COLUMN ratedetailnum int;
ALTER TABLE rate_detail ALTER COLUMN ratedetailnum SET DEFAULT nextval('public.rate_detail_ratedetailnum_seq'::text);
CREATE SEQUENCE rate_detail_ratedetailnum_seq;
UPDATE rate_detail SET ratedetailnum = nextval('public.rate_detail_ratedetailnum_seq'::text) WHERE ratedetailnum IS NULL;
ALTER TABLE rate_detail ALTER ratedetailnum SET NOT NULL;
ALTER TABLE rate_detail ADD PRIMARY KEY (ratedetailnum);
ALTER TABLE h_rate_detail ADD COLUMN ratedetailnum int;
ALTER TABLE type_pkgs ADD typepkgnum int;
ALTER TABLE type_pkgs ALTER COLUMN typepkgnum SET DEFAULT nextval('public.type_pkgs_typepkgnum_seq'::text);
CREATE SEQUENCE type_pkgs_typepkgnum_seq;
UPDATE type_pkgs SET typepkgnum = nextval('public.type_pkgs_typepkgnum_seq'::text) WHERE typepkgnum IS NULL;
ALTER TABLE type_pkgs ALTER typepkgnum SET NOT NULL;
ALTER TABLE type_pkgs ADD PRIMARY KEY (typepkgnum);
ALTER TABLE h_type_pkgs ADD typepkgnum int;
ALTER TABLE cust_bill_pkg ADD billpkgnum int;
ALTER TABLE cust_bill_pkg ALTER COLUMN billpkgnum SET DEFAULT nextval('public.cust_bill_pkg_billpkgnum_seq'::text);
CREATE SEQUENCE cust_bill_pkg_billpkgnum_seq;
UPDATE cust_bill_pkg SET billpkgnum = nextval('public.cust_bill_pkg_billpkgnum_seq'::text) WHERE billpkgnum IS NULL;
ALTER TABLE cust_bill_pkg ALTER billpkgnum SET NOT NULL;
ALTER TABLE cust_bill_pkg ADD PRIMARY KEY (billpkgnum);
ALTER TABLE h_cust_bill_pkg ADD billpkgnum int;
ALTER TABLE pkg_svc ADD pkgsvcnum int;
ALTER TABLE pkg_svc ALTER COLUMN pkgsvcnum SET DEFAULT nextval('public.pkg_svc_pkgsvcnum_seq'::text);
CREATE SEQUENCE pkg_svc_pkgsvcnum_seq;
UPDATE pkg_svc SET pkgsvcnum = nextval('public.pkg_svc_pkgsvcnum_seq'::text) WHERE pkgsvcnum IS NULL;
ALTER TABLE pkg_svc ALTER pkgsvcnum SET NOT NULL;
ALTER TABLE pkg_svc ADD PRIMARY KEY (pkgsvcnum);
ALTER TABLE h_pkg_svc ADD pkgsvcnum int;
ALTER TABLE part_svc_router ADD svcrouternum int;
ALTER TABLE part_svc_router ALTER COLUMN svcrouternum SET DEFAULT nextval('public.part_svc_router_svcrouternum_seq'::text);
CREATE SEQUENCE part_svc_router_svcrouternum_seq;
UPDATE part_svc_router SET svcrouternum = nextval('public.part_svc_router_svcrouternum_seq'::text) WHERE svcrouternum IS NULL;
ALTER TABLE part_svc_router ALTER svcrouternum SET NOT NULL;
ALTER TABLE part_svc_router ADD PRIMARY KEY (svcrouternum);
ALTER TABLE h_part_svc_router ADD svcrouternum int;
ALTER TABLE reg_code_pkg ADD codepkgnum int;
ALTER TABLE reg_code_pkg ALTER COLUMN codepkgnum SET DEFAULT nextval('public.reg_code_pkg_codepkgnum_seq'::text);
CREATE SEQUENCE reg_code_pkg_codepkgnum_seq;
UPDATE reg_code_pkg SET codepkgnum = nextval('public.reg_code_pkg_codepkgnum_seq'::text) WHERE codepkgnum IS NULL;
ALTER TABLE reg_code_pkg ALTER codepkgnum SET NOT NULL;
ALTER TABLE reg_code_pkg ADD PRIMARY KEY (codepkgnum);
ALTER TABLE h_reg_code_pkg ADD codepkgnum int;
ALTER TABLE virtual_field ADD vfieldnum int;
ALTER TABLE virtual_field ALTER COLUMN vfieldnum SET DEFAULT nextval('public.virtual_field_vfieldnum_seq'::text);
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 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;
|
