From a5a258c91c5dc78897d16627b8092385ceb4c4d2 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 22 Nov 2004 18:20:21 +0000 Subject: promo codes and separate signup addresses for hdn --- httemplate/docs/upgrade10.html | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'httemplate/docs/upgrade10.html') 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: -- cgit v1.2.1