Apply the following changes to your database:
-this is incomplete
-
-install DBIx::DBSchema 0.22
-
-install NetAddr::IP and Chart::Base
-
-CREATE TABLE cust_bill_pkg_detail (
- detailnum serial,
- pkgnum int NOT NULL,
- invnum int NOT NULL,
- detail varchar(80),
- PRIMARY KEY (detailnum)
-);
-CREATE INDEX cust_bill_pkg_detail1 ON cust_bill_pkg_detail ( pkgnum, invnum );
-
-CREATE TABLE part_virtual_field (
- vfieldpart int NOT NULL,
- dbtable varchar(32) NOT NULL,
- name varchar(32) NOT NULL,
- check_block text,
- list_source text,
- length integer,
- label varchar(80),
- PRIMARY KEY (vfieldpart)
-);
-
-CREATE TABLE virtual_field (
- recnum integer NOT NULL,
- vfieldpart integer NOT NULL,
- value varchar(128) NOT NULL,
- PRIMARY KEY (vfieldpart, recnum)
-);
-
-CREATE TABLE router (
- routernum serial,
- routername varchar(80),
- svcnum int,
- PRIMARY KEY (routernum)
-);
-
-CREATE TABLE part_svc_router (
- svcpart int NOT NULL,
- routernum int NOT NULL
-);
-
-CREATE TABLE addr_block (
- blocknum serial,
- routernum int NOT NULL,
- ip_gateway varchar(15) NOT NULL,
- ip_netmask int NOT NULL,
- PRIMARY KEY (blocknum)
-);
-CREATE UNIQUE INDEX addr_block1 ON addr_block ( blocknum, routernum );
-
-CREATE TABLE svc_broadband (
- svcnum int NOT NULL,
- blocknum int NOT NULL,
- speed_up int NOT NULL,
- speed_down int NOT NULL,
- ip_addr varchar(15),
- PRIMARY KEY (svcnum)
-);
-
-CREATE TABLE acct_snarf (
- snarfnum serial,
- svcnum int NOT NULL,
- machine varchar(255) NULL,
- protocol varchar(80) NULL,
- username varchar(80) NULL,
- _password varchar(80) NULL,
- PRIMARY KEY (snarfnum)
-);
-CREATE INDEX acct_snarf1 ON acct_snarf ( svcnum );
-
-CREATE TABLE part_pkg_temp (
- pkgpart serial NOT NULL,
- pkg varchar(80) NOT NULL,
- "comment" varchar(80) NOT NULL,
- setup text NULL,
- freq varchar(80) NOT NULL,
- recur text NULL,
- setuptax char(1) NULL,
- recurtax char(1) NULL,
- plan varchar(80) NULL,
- plandata text NULL,
- disabled char(1) NULL,
- taxclass varchar(80) NULL,
- PRIMARY KEY (pkgpart),
-);
-INSERT INTO part_pkg_temp SELECT * from part_pkg;
-DROP TABLE part_pkg;
-ALTER TABLE part_pkg_temp RENAME TO part_pkg;
-ALTER TABLE part_pkg DROP CONSTRAINT part_pkg_temp_pkey;
-ALTER TABLE part_pkg ADD PRIMARY KEY (pkgpart);
-CREATE INDEX part_pkg1 ON part_pkg(disabled);
-select setval('public.part_pkg_temp_pkgpart_seq', ( select max(pkgpart) from part_pkg) ); #?
-
-CREATE TABLE h_part_pkg_temp (
- historynum serial NOT NULL,
- history_date int,
- history_user varchar(80) NOT NULL,
- history_action varchar(80) NOT NULL,
- pkgpart int NOT NULL,
- pkg varchar(80) NOT NULL,
- "comment" varchar(80) NOT NULL,
- setup text NULL,
- freq varchar(80) NOT NULL,
- recur text NULL,
- setuptax char(1) NULL,
- recurtax char(1) NULL,
- plan varchar(80) NULL,
- plandata text NULL,
- disabled char(1) NULL,
- taxclass varchar(80) NULL,
- PRIMARY KEY (historynum)
-);
-INSERT INTO h_part_pkg_temp SELECT * from h_part_pkg;
-DROP TABLE h_part_pkg;
-ALTER TABLE h_part_pkg_temp RENAME TO h_part_pkg;
-ALTER TABLE h_part_pkg DROP CONSTRAINT h_part_pkg_temp_pkey;
-ALTER TABLE h_part_pkg ADD PRIMARY KEY (historynum);
-CREATE INDEX h_part_pkg1 ON h_part_pkg(disabled);
-select setval('public.h_part_pkg_temp_historynum_seq', ( select max(historynum) from h_part_pkg) );
-
+INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 20, 'svc_external-id', 'en_US', 'External ID' );
+INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 21, 'svc_external-title', 'en_US', 'Title' );
DROP INDEX cust_bill_pkg1;
+
-ALTER TABLE cust_bill_pkg ADD itemdesc varchar(80) NULL;
-ALTER TABLE h_cust_bill_pkg ADD itemdesc varchar(80) NULL;
-ALTER TABLE cust_main_county ADD taxname varchar(80) NULL;
-ALTER TABLE h_cust_main_county ADD taxname varchar(80) NULL;
-ALTER TABLE cust_main_county ADD setuptax char(1) NULL;
-ALTER TABLE h_cust_main_county ADD setuptax char(1) NULL;
-ALTER TABLE cust_main_county ADD recurtax char(1) NULL;
-ALTER TABLE h_cust_main_county ADD recurtax char(1) NULL;
-ALTER TABLE cust_pkg ADD last_bill int NULL;
-ALTER TABLE h_cust_pkg ADD last_bill int NULL;
-ALTER TABLE agent ADD disabled char(1) NULL;
-ALTER TABLE h_agent ADD disabled char(1) NULL;
-ALTER TABLE agent ADD username varchar(80) NULL;
-ALTER TABLE h_agent ADD username varchar(80) NULL;
-ALTER TABLE agent ADD _password varchar(80) NULL;
-ALTER TABLE h_agent ADD _password varchar(80) NULL;
-ALTER TABLE cust_main ADD paycvv varchar(4) NULL;
-ALTER TABLE h_cust_main ADD paycvv varchar(4) NULL;
-
-dump database, edit:
-- cust_main: increase otaker from 8 to 32
-- cust_main: change ss from char(11) to varchar(11)
-- cust_credit: increase otaker from 8 to 32
-- cust_pkg: increase otaker from 8 to 32
-- cust_refund: increase otaker from 8 to 32
-- domain_record: increase reczone from 80 to 255
-- domain_record: change rectype from char to varchar
-- domain_record: increase recdata from 80 to 255
-then reload
-
-optionally:
-
- CREATE INDEX cust_main6 ON cust_main ( daytime );
- CREATE INDEX cust_main7 ON cust_main ( night );
- CREATE INDEX cust_main8 ON cust_main ( fax );
- CREATE INDEX cust_main9 ON cust_main ( ship_daytime );
- CREATE INDEX cust_main10 ON cust_main ( ship_night );
- CREATE INDEX cust_main11 ON cust_main ( ship_fax );
-
- serial columns
+