X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.4.0pre8;h=7ddd7e2922500b23fc1c063baa6aef4bc5604f45;hp=a6f591b931869d62531c17308b1f3df71c09bdaa;hb=ab33e906a196646c5351c21848b5d6f63b4400dd;hpb=cf65a8e43320c5db6aa147a14cef1b310c0628b1 diff --git a/README.1.4.0pre8 b/README.1.4.0pre8 index a6f591b93..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 ( exportnum ); -CREATE INDEX part_export_option2 ON part_export ( option ); +CREATE INDEX part_export_option1 ON part_export_option ( exportnum ); +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.