projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
if enabled, show taxclass on package definition browse
[freeside.git]
/
httemplate
/
docs
/
upgrade10.html
diff --git
a/httemplate/docs/upgrade10.html
b/httemplate/docs/upgrade10.html
index
1d09964
..
dc60865
100644
(file)
--- a/
httemplate/docs/upgrade10.html
+++ b/
httemplate/docs/upgrade10.html
@@
-10,6
+10,9
@@
install Net::SSH 0.08
install NetAddr::IP, Chart::Base, IPC::ShareLite and Locale::SubCountry
install NetAddr::IP, Chart::Base, IPC::ShareLite and Locale::SubCountry
+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 cust_bill_pkg_detail (
detailnum serial,
pkgnum int NOT NULL,
CREATE TABLE cust_bill_pkg_detail (
detailnum serial,
pkgnum int NOT NULL,
@@
-80,7
+83,7
@@
CREATE INDEX acct_snarf1 ON acct_snarf ( svcnum );
CREATE TABLE svc_external (
svcnum int NOT NULL,
CREATE TABLE svc_external (
svcnum int NOT NULL,
- id int
NOT NULL
,
+ id int,
title varchar(80),
PRIMARY KEY (svcnum)
);
title varchar(80),
PRIMARY KEY (svcnum)
);
@@
-162,6
+165,22
@@
CREATE TABLE cust_pay_refund (
CREATE INDEX cust_pay_refund1 ON cust_pay_refund(paynum);
CREATE INDEX cust_pay_refund2 ON cust_pay_refund(refundnum);
CREATE INDEX cust_pay_refund1 ON cust_pay_refund(paynum);
CREATE INDEX cust_pay_refund2 ON cust_pay_refund(refundnum);
+CREATE TABLE cust_pay_void (
+ paynum int NOT NULL,
+ custnum int NOT NULL,
+ paid decimal(10,2) NOT NULL,
+ _date int,
+ payby char(4) NOT NULL,
+ payinfo varchar(80),
+ paybatch varchar(80),
+ closed char(1),
+ void_date int,
+ reason varchar(80),
+ otaker varchar(32) NOT NULL,
+ PRIMARY KEY (paynum)
+);
+CREATE INDEX cust_pay_void1 ON cust_pay_void(custnum);
+
DROP INDEX cust_bill_pkg1;
ALTER TABLE cust_bill_pkg ADD itemdesc varchar(80) NULL;
DROP INDEX cust_bill_pkg1;
ALTER TABLE cust_bill_pkg ADD itemdesc varchar(80) NULL;
@@
-228,7
+247,7
@@
optionally:
mandatory again:
dbdef-create username
mandatory again:
dbdef-create username
-create-history-tables username cust_bill_pkg_detail router part_svc_router addr_block svc_broadband acct_snarf svc_external
+create-history-tables username cust_bill_pkg_detail router part_svc_router addr_block svc_broadband acct_snarf svc_external
cust_pay_refund cust_pay_void
dbdef-create username
apache - fix <Files> sections to include .html also
dbdef-create username
apache - fix <Files> sections to include .html also