diff options
author | ivan <ivan> | 2003-06-03 07:54:57 +0000 |
---|---|---|
committer | ivan <ivan> | 2003-06-03 07:54:57 +0000 |
commit | a618738fb37939ef95ac70e8b90fe298450c215b (patch) | |
tree | ad5bf456a2a8a768526ac1a5fe557093f0da459f /httemplate | |
parent | dcf30bca55c04f22b752deab57a70ee710f2fd32 (diff) |
upgrade docs
Diffstat (limited to 'httemplate')
-rw-r--r-- | httemplate/docs/upgrade10.html | 12 |
1 files changed, 5 insertions, 7 deletions
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index ce1eed416..1035510db 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -1,7 +1,9 @@ <pre> this is incomplete -install NetAddr::IP and Chart +install DBIx::DBSchema 0.21 + +install NetAddr::IP and Chart::Base CREATE TABLE cust_bill_pkg_detail ( detailnum serial, @@ -64,7 +66,7 @@ CREATE TABLE sb_field ( sbfieldpart int NOT NULL, svcnum int NOT NULL, value varchar(128) -) +); CREATE UNIQUE INDEX sb_field1 ON sb_field ( sbfieldpart, svcnum ); CREATE TABLE svc_broadband ( @@ -74,6 +76,7 @@ CREATE TABLE svc_broadband ( speed_down int NOT NULL, ip_addr varchar(15), PRIMARY KEY (svcnum) +); DELETE INDEX cust_bill_pkg1; @@ -84,9 +87,6 @@ ALTER TABLE h_cust_main_county ADD taxname varchar(80) NULL; ALTER TABLE cust_pkg ADD last_bill int NULL; ALTER TABLE h_cust_pkg ADD last_bill int NULL; -DROP TABLE svc_acct_sm -DROP TABLE h_svc_acct_sm - dump database, edit: - cust_main: increase otaker from 8 to 32 - cust_main: change ss from char(11) to varchar(11) @@ -98,8 +98,6 @@ dump database, edit: - domain_record: increase recdata from 80 to 255 then reload -create all of the new broadband tables - optionally: CREATE INDEX cust_main6 ON cust_main ( daytime ); |