4 install NetAddr::IP and Chart
6 CREATE TABLE cust_bill_pkg_detail (
11 PRIMARY KEY (detailnum)
13 CREATE INDEX cust_bill_pkg_detail1 ON cust_bill_pkg_detail ( pkgnum, invnum );
17 routername varchar(80),
19 PRIMARY KEY (routernum)
22 CREATE TABLE part_svc_router (
24 routernum int NOT NULL
27 CREATE TABLE part_router_field (
28 routerfieldpart serial,
33 PRIMARY KEY (routerfieldpart)
36 CREATE TABLE router_field (
37 routerfieldpart int NOT NULL,
38 routernum int NOT NULL,
41 CREATE UNIQUE INDEX router_field1 ON router_field ( routerfieldpart, routernum );
43 CREATE TABLE addr_block (
45 routernum int NOT NULL,
46 ip_gateway varchar(15) NOT NULL,
47 ip_netmask int NOT NULL,
48 PRIMARY KEY (blocknum)
50 CREATE UNIQUE INDEX addr_block1 ON addr_block ( blocknum, routernum );
52 CREATE TABLE part_sb_field (
55 name varchar(80) NOT NULL,
57 check_block text NULL,
58 list_source text NULL,
59 PRIMARY key (sbfieldpart)
61 CREATE UNIQUE INDEX part_sb_field1 ON part_sb_field ( sbfieldpart, svcpart );
63 CREATE TABLE sb_field (
64 sbfieldpart int NOT NULL,
68 CREATE UNIQUE INDEX sb_field1 ON sb_field ( sbfieldpart, svcnum );
70 CREATE TABLE svc_broadband (
72 blocknum int NOT NULL,
73 speed_up int NOT NULL,
74 speed_down int NOT NULL,
78 DELETE INDEX cust_bill_pkg1;
80 ALTER TABLE cust_bill_pkg ADD itemdesc varchar(80) NULL;
81 ALTER TABLE h_cust_bill_pkg ADD itemdesc varchar(80) NULL;
82 ALTER TABLE cust_main_county ADD taxname varchar(80) NULL;
83 ALTER TABLE h_cust_main_county ADD taxname varchar(80) NULL;
84 ALTER TABLE cust_pkg ADD last_bill int NULL;
85 ALTER TABLE h_cust_pkg ADD last_bill int NULL;
87 DROP TABLE svc_acct_sm
88 DROP TABLE h_svc_acct_sm
91 - cust_main: increase otaker from 8 to 32
92 - cust_main: change ss from char(11) to varchar(11)
93 - cust_credit: increase otaker from 8 to 32
94 - cust_pkg: increase otaker from 8 to 32
95 - cust_refund: increase otaker from 8 to 32
96 - domain_record: increase reczone from 80 to 255
97 - domain_record: change rectype from char to varchar
98 - domain_record: increase recdata from 80 to 255
101 create all of the new broadband tables
105 CREATE INDEX cust_main6 ON cust_main ( daytime );
106 CREATE INDEX cust_main7 ON cust_main ( night );
107 CREATE INDEX cust_main8 ON cust_main ( fax );
108 CREATE INDEX cust_main9 ON cust_main ( ship_daytime );
109 CREATE INDEX cust_main10 ON cust_main ( ship_night );
110 CREATE INDEX cust_main11 ON cust_main ( ship_fax );
116 dbdef-create username
117 create-history-tables username cust_bill_pkg_detail router part_svc_router part_router_field router_field addr_block part_sb_field sb_field svc_broadband
118 dbdef-create username