X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.5.0pre6;h=f2ee7e20f914915e49acd439b8e1e2ff879de819;hp=bd5e39b9481aedadf4f04c3d63b83ff912ed033c;hb=673b9a458d9138523026963df6fa3b4683e09bae;hpb=cfe85e45bcba97089988b4dc22a895aec687f2c3 diff --git a/README.1.5.0pre6 b/README.1.5.0pre6 index bd5e39b94..f2ee7e20f 100644 --- a/README.1.5.0pre6 +++ b/README.1.5.0pre6 @@ -25,7 +25,22 @@ CREATE TABLE cust_pay_void ( ); CREATE INDEX cust_pay_void1 ON cust_pay_void(custnum); +alter table svc_external alter column id drop not null; +alter table h_svc_external alter column id drop not null; + +INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 20, 'svc_external-id', 'en_US', 'External ID' ); +INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 21, 'svc_external-title', 'en_US', 'Title' ); + +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_pkg_option ( pkgpart ); +CREATE INDEX part_pkg_option2 ON part_pkg_option ( optionname ); + dbdef-create username -create-history-tables username cust_pay_refund cust_pay_void +create-history-tables username cust_pay_refund cust_pay_void part_pkg_option dbdef-create username