1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
the following is necessary to upgrade from 1.4.0pre11 to 1.4.0pre12
if you're upgrading from before 1.4.0pre12 see README.1.4.0pre11 first!
if you're upgrading from 1.3.1 follow the instructions in
httemplate/docs/upgrade8.html instead
----
install HTML-Widgets-SelectLayers from CPAN or http://www.420.am/selectlayers
install the FS perl modules and httemplate as per install.html or upgrade8.html
ALTER TABLE cust_bill_event ADD status varchar(80);
ALTER TABLE cust_bill_event ADD statustext text NULL;
UPDATE cust_bill_event SET status = 'done';
DROP INDEX cust_bill_event1;
CREATE TABLE radius_usergroup (
usergroupnum int primary key,
svcnum int not null,
groupname varchar(80) not null
);
CREATE INDEX radius_usergroup1 ON radius_usergroup ( svcnum );
CREATE INDEX radius_usergroup2 ON radius_usergroup ( groupname );
ALTER TABLE svc_acct ADD sec_phrase varchar(80) NULL;
CREATE TABLE msgcat (
msgnum int primary key,
msgcode varchar(80) not null,
locale varchar(16) not null,
msg text not null
);
CREATE INDEX msgcat1 ON msgcat ( msgcode, locale );
CREATE TABLE export_svc (
exportsvcnum int primary key,
exportnum int not null,
svcpart int not null
);
CREATE UNIQUE INDEX export_svc1 ON export_svc ( exportnum, svcpart );
CREATE INDEX export_svc2 ON export_svc ( exportnum );
CREATE INDEX export_svc3 ON export_svc ( svcpart );
ALTER TABLE part_export RENAME svcpart TO deprecated;
ALTER TABLE part_pkg ADD taxclass varchar(80) NULL;
CREATE TABLE cust_tax_exempt (
exemptnum int primary key,
custnum int not null,
taxnum int not null,
year int not null,
month int not null,
amount decimal(10,2)
);
CREATE UNIQUE INDEX cust_tax_exempt1 ON cust_tax_exempt ( custnum, taxnum, year, month );
ALTER TABLE cust_main_county ADD taxclass varchar(80) NULL;
ALTER TABLE cust_main_county ADD exempt_amount decimal(10,2);
Run bin/dbdef-create
Run bin/create-history-tables
Run bin/dbdef-create again
Run bin/populate-msgcat
Set the `locale' configuration option to `en_US'.
the mxmachines, nsmachines, arecords and cnamerecords configuration values have been deprecated. Use the defaultrecords configuration value instead.
New export code has landed! If you were using the icradiusmachines,
icradius_mysqldest, icradius_mysqlsource, or icradius_secrets files, see
the "sqlradius" export instead. Use MySQL replication
<http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication>
or point the "sqlradius" export directly at your external ICRADIUS or
FreeRADIUS (or through an SSL-encrypting proxy...)
Arrange for freeside-expiration-alerter to be run daily, if desired.
Restart Apache and freeside-queued
|
