X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade10.html;h=1035510db3eef17429d97e1966dd7592625e8adb;hp=ce1eed416db94b05b1b0a6a8d096a6024b28039e;hb=a618738fb37939ef95ac70e8b90fe298450c215b;hpb=dcf30bca55c04f22b752deab57a70ee710f2fd32 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 @@
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 );