upgrade docs

1 files changed, 5 insertions, 7 deletions

diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html
index ce1eed4..1035510 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 );