-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 svc_external (
- svcnum int NOT NULL,
- id int NOT NULL,
- title varchar(80),
- PRIMARY KEY (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) );