diff options
Diffstat (limited to 'httemplate/docs')
| -rw-r--r-- | httemplate/docs/schema.html | 7 | ||||
| -rw-r--r-- | httemplate/docs/upgrade10.html | 4 |
2 files changed, 8 insertions, 3 deletions
diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 2e78f6e9e..c5cfd5119 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -268,13 +268,14 @@ <li>pkgpart - primary key <li>pkg - package name <li>comment - non-customer visable package comment - <li>setup - setup fee expression + <li>promo_code - promotional code + <li><i>deprecated</i> setup - setup fee expression <li>freq - recurring frequency (months) - <li>recur - recurring fee expression + <li><i>deprecated</i> recur - recurring fee expression <li>setuptax - Setup fee tax exempt flag, empty or `Y' <li>recurtax - Recurring fee tax exempt flag, empty or `Y' <li>plan - price plan - <li>plandata - additional price plan data + <li><i>deprecated</i> plandata - additional price plan data <li>disabled - Disabled flag, empty or `Y' </ul> <li><a name="part_pkg_option" href="man/FS/part_pkg_option.html">part_pkg_option</a> - Package definition options diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index e17f7add3..9dacf91d8 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -250,6 +250,10 @@ ALTER TABLE pkg_svc ADD primary_svc char(1) NULL; ALTER TABLE h_pkg_svc ADD primary_svc char(1) NULL; ALTER TABLE svc_forward ADD src varchar(255) NULL; ALTER TABLE h_svc_forward ADD src varchar(255) NULL; +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 ); On recent Pg versions: |