Apache::ASP | Mason |
---|---|
|
|
$ cd FS/ $ perl Makefile.PL $ make $ su # make install UNINST=1
CREATE TABLE svc_forward ( svcnum int NOT NULL, srcsvc int NOT NULL, dstsvc int NOT NULL, dst varchar(80), PRIMARY KEY (svcnum) ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer; ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL; ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_domain__catchall integer NULL; ALTER TABLE part_svc ADD svc_domain__catchall_flag char(1) NULL; ALTER TABLE part_svc ADD svc_forward__srcsvc integer NULL; ALTER TABLE part_svc ADD svc_forward__srcsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_forward__dstsvc integer NULL; ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_forward__dst integer NULL; ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL;
CREATE UNIQUE INDEX agent_pkey ON agent ( agentnum ); CREATE UNIQUE INDEX agent_type_pkey agent_type ( typenum ); CREATE UNIQUE INDEX cust_bill_pkey ON cust_bill ( invnum ); CREATE UNIQUE INDEX cust_credit_pkey ON cust_credit ( crednum ); CREATE UNIQUE INDEX cust_main_pkey ON cust_main ( custnum ); CREATE UNIQUE INDEX cust_main_county_pkey ON cust_main_county ( taxnum ); CREATE UNIQUE INDEX cust_main_invoice_pkey ON cust_main_invoice ( destnum ); CREATE UNIQUE INDEX cust_pay_pkey ON cust_pay ( paynum ); CREATE UNIQUE INDEX cust_pkg_pkey ON cust_pkg ( pkgnum ); CREATE UNIQUE INDEX cust_refund_pkey ON cust_refund ( refundnum ); CREATE UNIQUE INDEX cust_svc_pkey ON cust_svc ( svcnum ); CREATE UNIQUE INDEX domain_record_pkey ON domain_record ( recnum ); CREATE UNIQUE INDEX nas_pkey ON nas ( nasnum ); CREATE UNIQUE INDEX part_pkg_pkey ON part_pkg ( pkgpart ); CREATE UNIQUE INDEX part_referral_pkey ON part_referral ( refnum ); CREATE UNIQUE INDEX part_svc_pkey ON part_svc ( svcpart ); CREATE UNIQUE INDEX port_pkey ON port ( portnum ); CREATE UNIQUE INDEX prepay_credit_pkey ON prepay_credit ( prepaynum ); CREATE UNIQUE INDEX session_pkey ON session ( sessionnum ); CREATE UNIQUE INDEX svc_acct_pkey ON svc_acct ( svcnum ); CREATE UNIQUE INDEX svc_acct_pop_pkey ON svc_acct_pop ( popnum ); CREATE UNIQUE INDEX svc_acct_sm_pkey ON svc_acct_sm ( svcnum ); CREATE UNIQUE INDEX svc_domain_pkey ON svc_domain ( svcnum ); CREATE UNIQUE INDEX svc_www_pkey ON svc_www ( svcnum ); CREATE UNIQUE INDEX type_pkgs_pkey ON type_pkgs ( typenum );
ALTER TABLE cust_main ADD COLUMN ship_last varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_first varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_company varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_address1 varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_address2 varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_city varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_county varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_state varchar(80) NULL; ALTER TABLE cust_main ADD COLUMN ship_zip varchar(10) NULL; ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL; ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL; CREATE INDEX cust_main1 ON cust_main ( ship_last ); CREATE INDEX cust_main2 ON cust_main ( ship_company );
ALTER TABLE cust_main ADD COLUMN comments varchar NULL;