<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,
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 (
speed_down int NOT NULL,
ip_addr varchar(15),
PRIMARY KEY (svcnum)
+);
DELETE INDEX cust_bill_pkg1;
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)
- 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 );