4 install DBIx::DBSchema 0.21
6 install NetAddr::IP and Chart::Base
8 CREATE TABLE cust_bill_pkg_detail (
13 PRIMARY KEY (detailnum)
15 CREATE INDEX cust_bill_pkg_detail1 ON cust_bill_pkg_detail ( pkgnum, invnum );
19 routername varchar(80),
21 PRIMARY KEY (routernum)
24 CREATE TABLE part_svc_router (
26 routernum int NOT NULL
29 CREATE TABLE part_router_field (
30 routerfieldpart serial,
35 PRIMARY KEY (routerfieldpart)
38 CREATE TABLE router_field (
39 routerfieldpart int NOT NULL,
40 routernum int NOT NULL,
43 CREATE UNIQUE INDEX router_field1 ON router_field ( routerfieldpart, routernum );
45 CREATE TABLE addr_block (
47 routernum int NOT NULL,
48 ip_gateway varchar(15) NOT NULL,
49 ip_netmask int NOT NULL,
50 PRIMARY KEY (blocknum)
52 CREATE UNIQUE INDEX addr_block1 ON addr_block ( blocknum, routernum );
54 CREATE TABLE part_sb_field (
57 name varchar(80) NOT NULL,
59 check_block text NULL,
60 list_source text NULL,
61 PRIMARY key (sbfieldpart)
63 CREATE UNIQUE INDEX part_sb_field1 ON part_sb_field ( sbfieldpart, svcpart );
65 CREATE TABLE sb_field (
66 sbfieldpart int NOT NULL,
70 CREATE UNIQUE INDEX sb_field1 ON sb_field ( sbfieldpart, svcnum );
72 CREATE TABLE svc_broadband (
74 blocknum int NOT NULL,
75 speed_up int NOT NULL,
76 speed_down int NOT NULL,
81 DELETE INDEX cust_bill_pkg1;
83 ALTER TABLE cust_bill_pkg ADD itemdesc varchar(80) NULL;
84 ALTER TABLE h_cust_bill_pkg ADD itemdesc varchar(80) NULL;
85 ALTER TABLE cust_main_county ADD taxname varchar(80) NULL;
86 ALTER TABLE h_cust_main_county ADD taxname varchar(80) NULL;
87 ALTER TABLE cust_pkg ADD last_bill int NULL;
88 ALTER TABLE h_cust_pkg ADD last_bill int NULL;
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
103 CREATE INDEX cust_main6 ON cust_main ( daytime );
104 CREATE INDEX cust_main7 ON cust_main ( night );
105 CREATE INDEX cust_main8 ON cust_main ( fax );
106 CREATE INDEX cust_main9 ON cust_main ( ship_daytime );
107 CREATE INDEX cust_main10 ON cust_main ( ship_night );
108 CREATE INDEX cust_main11 ON cust_main ( ship_fax );
114 dbdef-create username
115 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
116 dbdef-create username