From 86cb6d3882df9bcf8076558d597383da30ae0786 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 22 Aug 2006 12:09:25 +0000 Subject: [PATCH] removing old upgrade instructions... can always get the out of the Attic --- README.1.5.0pre6 | 46 ------------ README.1.5.7 | 199 --------------------------------------------------- README.1.5.7.lastbit | 69 ------------------ README.1.5.8 | 68 ------------------ 4 files changed, 382 deletions(-) delete mode 100644 README.1.5.0pre6 delete mode 100644 README.1.5.7 delete mode 100644 README.1.5.7.lastbit delete mode 100644 README.1.5.8 diff --git a/README.1.5.0pre6 b/README.1.5.0pre6 deleted file mode 100644 index f2ee7e20f..000000000 --- a/README.1.5.0pre6 +++ /dev/null @@ -1,46 +0,0 @@ -CREATE TABLE cust_pay_refund ( - payrefundnum serial NOT NULL, - paynum int NOT NULL, - refundnum int NOT NULL, - _date int NOT NULL, - amount decimal(10,2) NOT NULL, - PRIMARY KEY (payrefundnum) -); -CREATE INDEX cust_pay_refund1 ON cust_pay_refund(paynum); -CREATE INDEX cust_pay_refund2 ON cust_pay_refund(refundnum); - -CREATE TABLE cust_pay_void ( - paynum int NOT NULL, - custnum int NOT NULL, - paid decimal(10,2) NOT NULL, - _date int, - payby char(4) NOT NULL, - payinfo varchar(80), - paybatch varchar(80), - closed char(1), - void_date int, - reason varchar(80), - otaker varchar(32) NOT NULL, - PRIMARY KEY (paynum) -); -CREATE INDEX cust_pay_void1 ON cust_pay_void(custnum); - -alter table svc_external alter column id drop not null; -alter table h_svc_external alter column id drop not null; - -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' ); - -CREATE TABLE part_pkg_option ( - optionnum int primary key, - pkgpart int not null, - optionname varchar(80) not null, - optionvalue text NULL -); -CREATE INDEX part_pkg_option1 ON part_pkg_option ( pkgpart ); -CREATE INDEX part_pkg_option2 ON part_pkg_option ( optionname ); - -dbdef-create username -create-history-tables username cust_pay_refund cust_pay_void part_pkg_option -dbdef-create username - diff --git a/README.1.5.7 b/README.1.5.7 deleted file mode 100644 index e890f01bc..000000000 --- a/README.1.5.7 +++ /dev/null @@ -1,199 +0,0 @@ -NOTE: Version numbering has been simplified. 1.5.7 is the version after -1.5.0pre6. It is still a development version - releases with odd numbered -middle parts (NN in x.NN.x) are development versions, like Perl or Linux. - -install DBIx::DBSchema 0.26 - -CREATE TABLE rate ( - ratenum serial NOT NULL, - ratename varchar(80) NOT NULL, - PRIMARY KEY (ratenum) -); - -CREATE TABLE rate_detail ( - ratedetailnum serial NOT NULL, - ratenum int NOT NULL, - orig_regionnum int NULL, - dest_regionnum int NOT NULL, - min_included int NOT NULL, - min_charge decimal(10,2) NOT NULL, - sec_granularity int NOT NULL -); -CREATE UNIQUE INDEX rate_detail1 ON rate_detail ( ratenum, orig_regionnum, dest_regionnum ); - -CREATE TABLE rate_region ( - regionnum serial NOT NULL, - regionname varchar(80) NOT NULL, - PRIMARY KEY (regionnum) -); - -CREATE TABLE rate_prefix ( - prefixnum serial NOT NULL, - regionnum int NOT NULL, - countrycode varchar(3) NOT NULL, - npa varchar(6) NULL, - nxx varchar(3) NULL, - PRIMARY KEY (prefixnum) -); -CREATE INDEX rate_prefix1 ON rate_prefix ( countrycode ); -CREATE INDEX rate_prefix2 ON rate_prefix ( regionnum ); - -CREATE TABLE reg_code ( - codenum serial NOT NULL, - code varchar(80) NOT NULL, - agentnum int NOT NULL, - PRIMARY KEY (codenum) -); -CREATE UNIQUE INDEX reg_code1 ON reg_code ( agentnum, code ); -CREATE INDEX reg_code2 ON reg_code ( agentnum ); - -CREATE TABLE reg_code_pkg ( - codepkgnum serial, - codenum int NOT NULL, - pkgpart int NOT NULL, - PRIMARY KEY (codepkgnum) -); -CREATE UNIQUE INDEX reg_code_pkg1 ON reg_code_pkg ( codenum, pkgpart ); -CREATE INDEX reg_code_pkg2 ON reg_code_pkg ( codenum ); - -CREATE TABLE clientapi_session ( - sessionnum serial NOT NULL, - sessionid varchar(80) NOT NULL, - namespace varchar(80) NOT NULL, - PRIMARY KEY (sessionnum) -); -CREATE UNIQUE INDEX clientapi_session1 ON clientapi_session ( sessionid, namespace ); - -CREATE TABLE clientapi_session_field ( - fieldnum serial NOT NULL, - sessionnum int NOT NULL, - fieldname varchar(80) NOT NULL, - fieldvalue text NULL, - PRIMARY KEY (fieldnum) -); -CREATE UNIQUE INDEX clientapi_session_field1 ON clientapi_session_field ( sessionnum, fieldname ); - -ALTER TABLE part_pkg ADD promo_code varchar(80) NULL; -ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL; -CREATE INDEX part_pkg2 ON part_pkg ( promo_code ); -CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code ); - -ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL; -ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL; - -ALTER TABLE prepay_credit ADD agentnum integer NULL; -ALTER TABLE h_prepay_credit ADD agentnum integer NULL; - -On current (7.3? definitely 7.4+) Pg: - - ALTER TABLE type_pkgs ADD typepkgnum int; - ALTER TABLE type_pkgs ALTER COLUMN typepkgnum SET DEFAULT nextval('public.type_pkgs_typepkgnum_seq'::text); - CREATE SEQUENCE type_pkgs_typepkgnum_seq; - UPDATE type_pkgs SET typepkgnum = nextval('public.type_pkgs_typepkgnum_seq'::text) WHERE typepkgnum IS NULL; - ALTER TABLE type_pkgs ALTER typepkgnum SET NOT NULL; - ALTER TABLE type_pkgs ADD PRIMARY KEY (typepkgnum); - ALTER TABLE h_type_pkgs ADD typepkgnum int; - - ALTER TABLE cust_bill_pkg ADD billpkgnum int; - ALTER TABLE cust_bill_pkg ALTER COLUMN billpkgnum SET DEFAULT nextval('public.cust_bill_pkg_billpkgnum_seq'::text); - CREATE SEQUENCE cust_bill_pkg_billpkgnum_seq; - UPDATE cust_bill_pkg SET billpkgnum = nextval('public.cust_bill_pkg_billpkgnum_seq'::text) WHERE billpkgnum IS NULL; - ALTER TABLE cust_bill_pkg ALTER billpkgnum SET NOT NULL; - ALTER TABLE cust_bill_pkg ADD PRIMARY KEY (billpkgnum); - ALTER TABLE h_cust_bill_pkg ADD billpkgnum int; - - ALTER TABLE pkg_svc ADD pkgsvcnum int; - ALTER TABLE pkg_svc ALTER COLUMN pkgsvcnum SET DEFAULT nextval('public.pkg_svc_pkgsvcnum_seq'::text); - CREATE SEQUENCE pkg_svc_pkgsvcnum_seq; - UPDATE pkg_svc SET pkgsvcnum = nextval('public.pkg_svc_pkgsvcnum_seq'::text) WHERE pkgsvcnum IS NULL; - ALTER TABLE pkg_svc ALTER pkgsvcnum SET NOT NULL; - ALTER TABLE pkg_svc ADD PRIMARY KEY (pkgsvcnum); - ALTER TABLE h_pkg_svc ADD pkgsvcnum int; - - ALTER TABLE part_svc_router ADD svcrouternum int; - ALTER TABLE part_svc_router ALTER COLUMN svcrouternum SET DEFAULT nextval('public.part_svc_router_svcrouternum_seq'::text); - CREATE SEQUENCE part_svc_router_svcrouternum_seq; - UPDATE part_svc_router SET svcrouternum = nextval('public.part_svc_router_svcrouternum_seq'::text) WHERE svcrouternum IS NULL; - ALTER TABLE part_svc_router ALTER svcrouternum SET NOT NULL; - ALTER TABLE part_svc_router ADD PRIMARY KEY (svcrouternum); - ALTER TABLE h_part_svc_router ADD svcrouternum int; - -Or on very old Pg (7.2 and earlier (eek), 7.3?): - - ALTER TABLE type_pkgs ADD typepkgnum int; - ALTER TABLE type_pkgs ALTER COLUMN typepkgnum SET DEFAULT nextval('type_pkgs_typepkgnum_seq'::text); - CREATE SEQUENCE type_pkgs_typepkgnum_seq; - UPDATE type_pkgs SET typepkgnum = nextval('type_pkgs_typepkgnum_seq'::text) WHERE typepkgnum IS NULL; - UPDATE pg_attribute SET attnotnull = TRUE WHERE attname = 'typepkgnum' AND attrelid = ( SELECT oid FROM pg_class WHERE relname = 'type_pkgs'); - ALTER TABLE type_pkgs ADD PRIMARY KEY (typepkgnum); - ALTER TABLE h_type_pkgs ADD typepkgnum int; - - ALTER TABLE cust_bill_pkg ADD billpkgnum int; - ALTER TABLE cust_bill_pkg ALTER COLUMN billpkgnum SET DEFAULT nextval('cust_bill_pkg_billpkgnum_seq'::text); - CREATE SEQUENCE cust_bill_pkg_billpkgnum_seq; - UPDATE cust_bill_pkg SET billpkgnum = nextval('cust_bill_pkg_billpkgnum_seq'::text) WHERE billpkgnum IS NULL; - UPDATE pg_attribute SET attnotnull = TRUE WHERE attname = 'billpkgnum' AND attrelid = ( SELECT oid FROM pg_class WHERE relname = 'cust_bill_pkg'); - ALTER TABLE cust_bill_pkg ADD PRIMARY KEY (billpkgnum); - ALTER TABLE h_cust_bill_pkg ADD billpkgnum int; - - ALTER TABLE pkg_svc ADD pkgsvcnum int; - ALTER TABLE pkg_svc ALTER COLUMN pkgsvcnum SET DEFAULT nextval('pkg_svc_pkgsvcnum_seq'::text); - CREATE SEQUENCE pkg_svc_pkgsvcnum_seq; - UPDATE pkg_svc SET pkgsvcnum = nextval('pkg_svc_pkgsvcnum_seq'::text) WHERE pkgsvcnum IS NULL; - UPDATE pg_attribute SET attnotnull = TRUE WHERE attname = 'pkgsvcnum' AND attrelid = ( SELECT oid FROM pg_class WHERE relname = 'pkg_svc'); - ALTER TABLE pkg_svc ADD PRIMARY KEY (pkgsvcnum); - ALTER TABLE h_pkg_svc ADD pkgsvcnum int; - - ALTER TABLE part_svc_router ADD svcrouternum int; - ALTER TABLE part_svc_router ALTER COLUMN svcrouternum SET DEFAULT nextval('part_svc_router_svcrouternum_seq'::text); - CREATE SEQUENCE part_svc_router_svcrouternum_seq; - UPDATE part_svc_router SET svcrouternum = nextval('part_svc_router_svcrouternum_seq'::text) WHERE svcrouternum IS NULL; - UPDATE pg_attribute SET attnotnull = TRUE WHERE attname = 'svcrouternum' AND attrelid = ( SELECT oid FROM pg_class WHERE relname = 'part_svc_router'); - ALTER TABLE part_svc_router ADD PRIMARY KEY (svcrouternum); - ALTER TABLE h_part_svc_router ADD svcrouternum int; - -Installs w/integrated RT: - CREATE SEQUENCE attributes_id_seq; - - CREATE TABLE Attributes ( - id INTEGER DEFAULT nextval('attributes_id_seq'), - Name varchar(255) NOT NULL , - Description varchar(255) NULL , - Content text, - ContentType varchar(16), - ObjectType varchar(64), - ObjectId integer, -- foreign key to anything - Creator integer NOT NULL DEFAULT 0 , - Created TIMESTAMP NULL , - LastUpdatedBy integer NOT NULL DEFAULT 0 , - LastUpdated TIMESTAMP NULL , - PRIMARY KEY (id) - - ); - - CREATE INDEX Attributes1 on Attributes(Name); - CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); - - Add these lines to /opt/rt3/etc/RT_SiteConfig.pm (before the "1;"): - $RT::URI::freeside::IntegrationType = 'Internal'; - $RT::URI::freeside::URL = 'http://path/to/your/freeside/'; - Set($DatabaseHost , ''); - -(End of Installs w/integrated RT) - - -(make sure you have upgraded DBIx::DBSchema to 0.26) -dbdef-create username -create-history-tables username rate rate_detail rate_region rate_prefix reg_code reg_code_pkg -dbdef-create username - -install Text::CSV_XS, Spreadsheet::WriteExcel, IO-stringy (IO::Scalar), -Frontier::RPC (Frontier::RPC2), MIME::Entity (MIME-tools) and IPC::Run3 - -afterwords (for installs w/integrated RT): -install HTML::Scrubber, Text::Quoted and Tree::Simple -make configure-rt -make deploy -/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.15 -/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.1.17 - diff --git a/README.1.5.7.lastbit b/README.1.5.7.lastbit deleted file mode 100644 index 872d30ac3..000000000 --- a/README.1.5.7.lastbit +++ /dev/null @@ -1,69 +0,0 @@ -this is ONLY for people upgrading from CVS snapshots after march 12th who -have most of the changes in README.1.5.7 already. - -if you're upgrading from 1.5.0pre6, see README.1.5.7 instead. - -if you're upgrading from 1.4.x, see httemplate/docs/upgrade10.html instead. - - -ALTER TABLE rate_detail ADD COLUMN ratedetailnum int; -ALTER TABLE rate_detail ALTER COLUMN ratedetailnum SET DEFAULT nextval('public.rate_detail_ratedetailnum_seq'::text); -CREATE SEQUENCE rate_detail_ratedetailnum_seq; -UPDATE rate_detail SET ratedetailnum = nextval('public.rate_detail_ratedetailnum_seq'::text) WHERE ratedetailnum IS NULL; -ALTER TABLE rate_detail ALTER ratedetailnum SET NOT NULL; -ALTER TABLE rate_detail ADD PRIMARY KEY (ratedetailnum); -ALTER TABLE h_rate_detail ADD COLUMN ratedetailnum int; - -ALTER TABLE type_pkgs ADD typepkgnum int; -ALTER TABLE type_pkgs ALTER COLUMN typepkgnum SET DEFAULT nextval('public.type_pkgs_typepkgnum_seq'::text); -CREATE SEQUENCE type_pkgs_typepkgnum_seq; -UPDATE type_pkgs SET typepkgnum = nextval('public.type_pkgs_typepkgnum_seq'::text) WHERE typepkgnum IS NULL; -ALTER TABLE type_pkgs ALTER typepkgnum SET NOT NULL; -ALTER TABLE type_pkgs ADD PRIMARY KEY (typepkgnum); -ALTER TABLE h_type_pkgs ADD typepkgnum int; - -ALTER TABLE cust_bill_pkg ADD billpkgnum int; -ALTER TABLE cust_bill_pkg ALTER COLUMN billpkgnum SET DEFAULT nextval('public.cust_bill_pkg_billpkgnum_seq'::text); -CREATE SEQUENCE cust_bill_pkg_billpkgnum_seq; -UPDATE cust_bill_pkg SET billpkgnum = nextval('public.cust_bill_pkg_billpkgnum_seq'::text) WHERE billpkgnum IS NULL; -ALTER TABLE cust_bill_pkg ALTER billpkgnum SET NOT NULL; -ALTER TABLE cust_bill_pkg ADD PRIMARY KEY (billpkgnum); -ALTER TABLE h_cust_bill_pkg ADD billpkgnum int; - -ALTER TABLE pkg_svc ADD pkgsvcnum int; -ALTER TABLE pkg_svc ALTER COLUMN pkgsvcnum SET DEFAULT nextval('public.pkg_svc_pkgsvcnum_seq'::text); -CREATE SEQUENCE pkg_svc_pkgsvcnum_seq; -UPDATE pkg_svc SET pkgsvcnum = nextval('public.pkg_svc_pkgsvcnum_seq'::text) WHERE pkgsvcnum IS NULL; -ALTER TABLE pkg_svc ALTER pkgsvcnum SET NOT NULL; -ALTER TABLE pkg_svc ADD PRIMARY KEY (pkgsvcnum); -ALTER TABLE h_pkg_svc ADD pkgsvcnum int; - -ALTER TABLE part_svc_router ADD svcrouternum int; -ALTER TABLE part_svc_router ALTER COLUMN svcrouternum SET DEFAULT nextval('public.part_svc_router_svcrouternum_seq'::text); -CREATE SEQUENCE part_svc_router_svcrouternum_seq; -UPDATE part_svc_router SET svcrouternum = nextval('public.part_svc_router_svcrouternum_seq'::text) WHERE svcrouternum IS NULL; -ALTER TABLE part_svc_router ALTER svcrouternum SET NOT NULL; -ALTER TABLE part_svc_router ADD PRIMARY KEY (svcrouternum); -ALTER TABLE h_part_svc_router ADD svcrouternum int; - -ALTER TABLE reg_code_pkg ADD codepkgnum int; -ALTER TABLE reg_code_pkg ALTER COLUMN codepkgnum SET DEFAULT nextval('public.reg_code_pkg_codepkgnum_seq'::text); -CREATE SEQUENCE reg_code_pkg_codepkgnum_seq; -UPDATE reg_code_pkg SET codepkgnum = nextval('public.reg_code_pkg_codepkgnum_seq'::text) WHERE codepkgnum IS NULL; -ALTER TABLE reg_code_pkg ALTER codepkgnum SET NOT NULL; -ALTER TABLE reg_code_pkg ADD PRIMARY KEY (codepkgnum); -ALTER TABLE h_reg_code_pkg ADD codepkgnum int; - -ALTER TABLE virtual_field ADD vfieldnum int; -ALTER TABLE virtual_field ALTER COLUMN vfieldnum SET DEFAULT nextval('public.virtual_field_vfieldnum_seq'::text); -CREATE SEQUENCE virtual_field_vfieldnum_seq; -UPDATE virtual_field SET vfieldnum = nextval('public.virtual_field_vfieldnum_seq'::text) WHERE vfieldnum IS NULL; -ALTER TABLE virtual_field ALTER vfieldnum SET NOT NULL; -ALTER TABLE virtual_field ADD PRIMARY KEY (vfieldnum); --- ALTER TABLE h_virtual_field ADD vfieldnum int; - -ALTER TABLE cust_pay_batch RENAME COLUMN cardnum TO payinfo; -ALTER TABLE cust_pay_batch ALTER COLUMN payinfo varchar(512) NULL; -ALTER TABLE h_cust_pay_batch RENAME COLUMN cardnum TO payinfo; -ALTER TABLE h_cust_pay_batch ALTER COLUMN payinfo varchar(512) NULL; - diff --git a/README.1.5.8 b/README.1.5.8 deleted file mode 100644 index 4335a5677..000000000 --- a/README.1.5.8 +++ /dev/null @@ -1,68 +0,0 @@ - -install JSON -install Term::ReadKey - -install DBIx::DBSchema 0.27 (or later) - (if you are running Pg version 7.2.x or earlier, install at least - DBIx::DBSchema 0.29) -install HTML::Widgets:SelectLayers 0.05 (or later) -install Business::CreditCard 0.28 (or later) - -ALTER TABLE cust_pay_batch ADD COLUMN batchnum int; -ALTER TABLE cust_pay_batch ALTER COLUMN batchnum SET NOT NULL; -ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512); -UPDATE cust_pay_batch SET payinfo = cardnum; -ALTER TABLE cust_pay_batch DROP COLUMN cardnum; -ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512); -UPDATE h_cust_pay_batch SET payinfo = cardnum; -ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum; - -make install-perl-modules -run "freeside-upgrade username" to uprade your database schema - -(if freeside-upgrade hangs, try stopping Apache, all Freeside processes, and - anything else connected to your database, especially on older Pg versions) - -Optional: -CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart ); - -CREATE INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum ); -CREATE INDEX cust_main9 ON cust_main ( county ); -CREATE INDEX cust_main10 ON cust_main ( state ); -CREATE INDEX cust_main11 ON cust_main ( country ); -CREATE INDEX cust_main_county1 ON cust_main_county ( county ); -CREATE INDEX cust_main_county2 ON cust_main_county ( state ); -CREATE INDEX cust_main_county3 ON cust_main_county ( country ); - -Optional for better VoIP performance: -CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum ); - ------ - -Installs w/integrated RT: - Install Module::Versions::Report - - chmod a+r /opt/rt3/etc/RT*Config.pm - cd rt - su freeside - - /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.0 - /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.0 - /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.0 - - /opt/rt3/sbin/rt-setup-database --action schema --datadir etc/upgrade/3.3.11 - /opt/rt3/sbin/rt-setup-database --action acl --datadir etc/upgrade/3.3.11 - /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.3.11 - - run "dbdef-create username" - - make configure-rt - ------- - -make install-docs - (or "make deploy" if you've got everything setup in the Makefile) - -(errors? try "make clean" then "make install-perl-modules", then - "make install-docs" or "make deploy" again) - -- 2.11.0