X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade10.html;h=2f2c2daa66e8550a067114c4404c4cf9e7e4cafb;hb=b8cfd0780aa40bb07f3215bf9cb58011f5e32a35;hp=dc60865a5feea750855d4059296ab077dd9da381;hpb=326123622b3e60db0d6893f076b3a082f4e2a44a;p=freeside.git 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;