From c5c0ba135749164ec8ba75d18f76c29625e1bc7e Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 29 Jan 2002 17:42:46 +0000 Subject: weight, plan and plandata fields in part_bill_event --- httemplate/docs/man/FS/cust_main.html | 2 +- httemplate/docs/man/FS/cust_pay.html | 2 +- httemplate/docs/man/FS/cust_pkg.html | 2 +- httemplate/docs/man/FS/cust_svc.html | 2 +- httemplate/docs/man/FS/svc_acct.html | 2 +- httemplate/docs/schema.html | 3 +++ httemplate/docs/upgrade8.html | 7 +++++-- 7 files changed, 13 insertions(+), 7 deletions(-) (limited to 'httemplate/docs') diff --git a/httemplate/docs/man/FS/cust_main.html b/httemplate/docs/man/FS/cust_main.html index 86e659ad0..1fb339124 100644 --- a/httemplate/docs/man/FS/cust_main.html +++ b/httemplate/docs/man/FS/cust_main.html @@ -393,7 +393,7 @@ the error, otherwise returns false.


VERSION

-

$Id: cust_main.html,v 1.2 2002-01-29 16:33:15 ivan Exp $

+

$Id: cust_main.html,v 1.3 2002-01-29 17:42:46 ivan Exp $


BUGS

diff --git a/httemplate/docs/man/FS/cust_pay.html b/httemplate/docs/man/FS/cust_pay.html index ce057f068..a8c481fc0 100644 --- a/httemplate/docs/man/FS/cust_pay.html +++ b/httemplate/docs/man/FS/cust_pay.html @@ -107,7 +107,7 @@ paid minus all payment applications (see th


VERSION

-

$Id: cust_pay.html,v 1.2 2002-01-29 16:33:15 ivan Exp $

+

$Id: cust_pay.html,v 1.3 2002-01-29 17:42:46 ivan Exp $


BUGS

diff --git a/httemplate/docs/man/FS/cust_pkg.html b/httemplate/docs/man/FS/cust_pkg.html index 9f1005da7..76cb9e786 100644 --- a/httemplate/docs/man/FS/cust_pkg.html +++ b/httemplate/docs/man/FS/cust_pkg.html @@ -191,7 +191,7 @@ newly-created cust_pkg objects.


VERSION

-

$Id: cust_pkg.html,v 1.2 2002-01-29 16:33:15 ivan Exp $

+

$Id: cust_pkg.html,v 1.3 2002-01-29 17:42:46 ivan Exp $


BUGS

diff --git a/httemplate/docs/man/FS/cust_svc.html b/httemplate/docs/man/FS/cust_svc.html index 97a299c52..55c90e28e 100644 --- a/httemplate/docs/man/FS/cust_svc.html +++ b/httemplate/docs/man/FS/cust_svc.html @@ -119,7 +119,7 @@ where svcdb is not ``svc_acct''.


VERSION

-

$Id: cust_svc.html,v 1.2 2002-01-29 16:33:16 ivan Exp $

+

$Id: cust_svc.html,v 1.3 2002-01-29 17:42:46 ivan Exp $


BUGS

diff --git a/httemplate/docs/man/FS/svc_acct.html b/httemplate/docs/man/FS/svc_acct.html index 9c41db3f0..93483f67d 100644 --- a/httemplate/docs/man/FS/svc_acct.html +++ b/httemplate/docs/man/FS/svc_acct.html @@ -251,7 +251,7 @@ See the FS::session manpage


VERSION

-

$Id: svc_acct.html,v 1.2 2002-01-29 16:33:16 ivan Exp $

+

$Id: svc_acct.html,v 1.3 2002-01-29 17:42:46 ivan Exp $


BUGS

diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 21da3ecf6..bdf3a500e 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -40,6 +40,9 @@
  • event - event name
  • eventcode - event action
  • seconds - how long after the invoice date (cust_bill._date) events of this type are triggered +
  • weight - ordering for events with identical seconds +
  • plan - eventcode plan +
  • plandata - additional plan data
  • disabled - Disabled flag, empty or `Y'
  • cust_bill_pkg - Invoice line items diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index bbb528cda..c4d023a58 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -128,7 +128,7 @@ CREATE TABLE cust_bill_event ( eventnum int primary key, invnum int not null, eventpart int not null, - _date int not null, + _date int not null ); CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum ); CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum ); @@ -139,7 +139,10 @@ CREATE TABLE part_bill_event ( event varchar(80) not null, eventcode text null, seconds int null, - disabled char(1) null, + weight int not null, + plan varchar(80) null, + plandata text null, + disabled char(1) null ); CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); -- cgit v1.2.1