From: ivan Date: Mon, 4 Feb 2002 17:06:18 +0000 (+0000) Subject: 1.4.0pre8! X-Git-Tag: freeside_1_4_0pre11~110 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=cf65a8e43320c5db6aa147a14cef1b310c0628b1 1.4.0pre8! --- diff --git a/Makefile b/Makefile index 6fa389355..8d46b975c 100644 --- a/Makefile +++ b/Makefile @@ -7,7 +7,6 @@ DB_USER = freeside DB_PASSWORD= TEMPLATE = asp -#mason's a bit dodgy still #TEMPLATE = mason ASP_GLOBAL = /usr/local/etc/freeside/asp-global diff --git a/README.1.4.0pre4567-8 b/README.1.4.0pre4567-8 deleted file mode 100644 index 11fc9c1db..000000000 --- a/README.1.4.0pre4567-8 +++ /dev/null @@ -1,67 +0,0 @@ -the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8 - -if you're upgrading from 1.3.1 follow the instructions in -httemplate/docs/upgrade8.html instead - -if you're upgradeing from before 1.4.0pre4, see -http://cleanwhisker.420.am/cgi-bin/cvsweb/freeside/Attic/ - ------ - -install Time::Duration and Tie::IxHash - -install the FS perl modules and httemplate as per install.html or upgrade8.html - -ALTER TABLE part_pkg ADD disabled char(1) NULL; -ALTER TABLE part_svc ADD disabled char(1) NULL; - -CREATE TABLE cust_bill_event ( - eventnum int primary key, - invnum int not null, - eventpart int not null, - _date int not null -); -CREATE UNIQUE INDEX cust_bill_events1 ON cust_bill_events ( eventpart, invnum ); -CREATE INDEX cust_bill_events2 ON cust_bill_events ( invnum ); - -CREATE TABLE part_bill_event ( - eventpart int primary key, - payby char(4) not null, - event varchar(80) not null, - eventcode text null, - seconds int null, - weight int not null, - plan varchar(80) null, - plandata text null, - disabled char(1) null -); -CREATE INDEX part_bill_events1 ON part_bill_events ( payby ); - -CREATE TABLE part_export ( - exportnum int primary key, - svcpart int not null, - machine varchar(80) not null, - exporttype varchar(80) not null, - nodomain char(1) NULL -); -CREATE INDEX part_export1 ON part_export ( machine ); -CREATE INDEX part_export2 ON part_export ( exporttype ); - -CREATE INDEX part_export_option ( - optionnum int primary key, - exportnum int not null, - option varchar(80) not null, - optionvalue text NULL -); -CREATE INDEX part_export_option1 ON part_export ( exportnum ); -CREATE INDEX part_export_option2 ON part_export ( option ); - -ALTER TABLE cust_bill ADD closed char(1) NULL; -ALTER TABLE cust_pay ADD closed char(1) NULL; -ALTER TABLE cust_credit ADD closed char(1) NULL; -ALTER TABLE cust_refund ADD closed char(1) NULL; - -Run bin/dbdef-create - -Restart Apache and freeside-queued - diff --git a/README.1.4.0pre8 b/README.1.4.0pre8 new file mode 100644 index 000000000..a6f591b93 --- /dev/null +++ b/README.1.4.0pre8 @@ -0,0 +1,73 @@ +the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8 + +if you're upgrading from 1.3.1 follow the instructions in +httemplate/docs/upgrade8.html instead + +if you're upgradeing from before 1.4.0pre4, see +http://cleanwhisker.420.am/cgi-bin/cvsweb/freeside/Attic/ + +----- + +install Time::Duration and Tie::IxHash + +install the FS perl modules and httemplate as per install.html or upgrade8.html + +ALTER TABLE part_pkg ADD disabled char(1) NULL; +ALTER TABLE part_svc ADD disabled char(1) NULL; + +CREATE TABLE cust_bill_event ( + eventnum int primary key, + invnum int not null, + eventpart int not null, + _date int not null +); +CREATE UNIQUE INDEX cust_bill_events1 ON cust_bill_events ( eventpart, invnum ); +CREATE INDEX cust_bill_events2 ON cust_bill_events ( invnum ); + +CREATE TABLE part_bill_event ( + eventpart int primary key, + payby char(4) not null, + event varchar(80) not null, + eventcode text null, + seconds int null, + weight int not null, + plan varchar(80) null, + plandata text null, + disabled char(1) null +); +CREATE INDEX part_bill_events1 ON part_bill_events ( payby ); + +CREATE TABLE part_export ( + exportnum int primary key, + svcpart int not null, + machine varchar(80) not null, + exporttype varchar(80) not null, + nodomain char(1) NULL +); +CREATE INDEX part_export1 ON part_export ( machine ); +CREATE INDEX part_export2 ON part_export ( exporttype ); + +CREATE INDEX part_export_option ( + optionnum int primary key, + exportnum int not null, + option varchar(80) not null, + optionvalue text NULL +); +CREATE INDEX part_export_option1 ON part_export ( exportnum ); +CREATE INDEX part_export_option2 ON part_export ( option ); + +ALTER TABLE cust_bill ADD closed char(1) NULL; +ALTER TABLE cust_pay ADD closed char(1) NULL; +ALTER TABLE cust_credit ADD closed char(1) NULL; +ALTER TABLE cust_refund ADD closed char(1) NULL; + +Run bin/dbdef-create + +Restart Apache and freeside-queued + +Go to the new "View/Edit Invoice events" in the web interface and add the +appropriate events. t the very least, you'll want to set some invoice events +"After 0 days": a BILL invoice event to print invoices, a CARD invoice event to +batch or run cards real-time, and a COMP invoice event to "pay" complimentary +customers. +