X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.4.0pre8;h=7ddd7e2922500b23fc1c063baa6aef4bc5604f45;hp=6872bdd60d173a92a3a8156fed2f4a21e0ea0883;hb=d515768232afa35557496bb867f5708f279465e3;hpb=d9d79aeecc2c0d79bd1d066a702252ffd683661e diff --git a/README.1.4.0pre8 b/README.1.4.0pre8 index 6872bdd60..7ddd7e292 100644 --- a/README.1.4.0pre8 +++ b/README.1.4.0pre8 @@ -21,8 +21,8 @@ CREATE TABLE cust_bill_event ( 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 UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum ); +CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum ); CREATE TABLE part_bill_event ( eventpart int primary key, @@ -35,7 +35,7 @@ CREATE TABLE part_bill_event ( plandata text null, disabled char(1) null ); -CREATE INDEX part_bill_events1 ON part_bill_events ( payby ); +CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); CREATE TABLE part_export ( exportnum int primary key, @@ -47,14 +47,14 @@ CREATE TABLE part_export ( CREATE INDEX part_export1 ON part_export ( machine ); CREATE INDEX part_export2 ON part_export ( exporttype ); -CREATE INDEX part_export_option ( +CREATE TABLE part_export_option ( optionnum int primary key, exportnum int not null, - option varchar(80) not null, + optionname varchar(80) not null, optionvalue text NULL ); CREATE INDEX part_export_option1 ON part_export_option ( exportnum ); -CREATE INDEX part_export_option2 ON part_export_option ( option ); +CREATE INDEX part_export_option2 ON part_export_option ( optionname ); ALTER TABLE cust_bill ADD closed char(1) NULL; ALTER TABLE cust_pay ADD closed char(1) NULL; @@ -66,8 +66,9 @@ 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 +appropriate events. At 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. +customers. If you were using the -i option to freeside-bill it should be +removed.