From 6fe8172b11d0369d0b1274d6825ec0c57afe8001 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 26 Oct 2004 11:26:35 +0000
Subject: modular price plans!

---
 httemplate/docs/upgrade10.html | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'httemplate/docs/upgrade10.html')

diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html
index dc60865a5..2f2c2daa6 100644
--- a/httemplate/docs/upgrade10.html
+++ b/httemplate/docs/upgrade10.html
@@ -181,6 +181,15 @@ CREATE TABLE cust_pay_void (
 );
 CREATE INDEX cust_pay_void1 ON cust_pay_void(custnum);
 
+CREATE TABLE part_pkg_option (
+  optionnum int primary key,
+  pkgpart int not null,
+  optionname varchar(80) not null,
+  optionvalue text NULL
+);
+CREATE INDEX part_pkg_option1 ON part_export_option ( pkgpart );
+CREATE INDEX part_pkg_option2 ON part_export_option ( optionname );
+
 DROP INDEX cust_bill_pkg1;
 
 ALTER TABLE cust_bill_pkg ADD itemdesc varchar(80) NULL;
-- 
cgit v1.2.1