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 );
17 CREATE TABLE part_virtual_field (
18 vfieldpart int NOT NULL,
19 dbtable varchar(32) NOT NULL,
20 name varchar(32) NOT NULL,
25 PRIMARY KEY (vfieldpart)
28 CREATE TABLE virtual_field (
29 recnum integer NOT NULL,
30 vfieldpart integer NOT NULL,
31 value varchar(128) NOT NULL,
32 PRIMARY KEY (vfieldpart, recnum)
37 routername varchar(80),
39 PRIMARY KEY (routernum)
42 CREATE TABLE part_svc_router (
44 routernum int NOT NULL
47 CREATE TABLE addr_block (
49 routernum int NOT NULL,
50 ip_gateway varchar(15) NOT NULL,
51 ip_netmask int NOT NULL,
52 PRIMARY KEY (blocknum)
54 CREATE UNIQUE INDEX addr_block1 ON addr_block ( blocknum, routernum );
56 CREATE TABLE svc_broadband (
58 blocknum int NOT NULL,
59 speed_up int NOT NULL,
60 speed_down int NOT NULL,
65 DELETE INDEX cust_bill_pkg1;
67 ALTER TABLE cust_bill_pkg ADD itemdesc varchar(80) NULL;
68 ALTER TABLE h_cust_bill_pkg ADD itemdesc varchar(80) NULL;
69 ALTER TABLE cust_main_county ADD taxname varchar(80) NULL;
70 ALTER TABLE h_cust_main_county ADD taxname varchar(80) NULL;
71 ALTER TABLE cust_pkg ADD last_bill int NULL;
72 ALTER TABLE h_cust_pkg ADD last_bill int NULL;
75 - cust_main: increase otaker from 8 to 32
76 - cust_main: change ss from char(11) to varchar(11)
77 - cust_credit: increase otaker from 8 to 32
78 - cust_pkg: increase otaker from 8 to 32
79 - cust_refund: increase otaker from 8 to 32
80 - domain_record: increase reczone from 80 to 255
81 - domain_record: change rectype from char to varchar
82 - domain_record: increase recdata from 80 to 255
87 CREATE INDEX cust_main6 ON cust_main ( daytime );
88 CREATE INDEX cust_main7 ON cust_main ( night );
89 CREATE INDEX cust_main8 ON cust_main ( fax );
90 CREATE INDEX cust_main9 ON cust_main ( ship_daytime );
91 CREATE INDEX cust_main10 ON cust_main ( ship_night );
92 CREATE INDEX cust_main11 ON cust_main ( ship_fax );
99 create-history-tables username cust_bill_pkg_detail router part_svc_router addr_block svc_broadband
100 dbdef-create username
102 apache - fix <Files> sections to include .html also