rt/UPGRADING


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

UPGRADING


*******
WARNING
*******


Before making any changes to your database, always ensure that you have a 
complete current backup. If you don't have a current backup, you could 
accidentally damage your database and lose data or worse.


Look for the 


----------------------------------------------------------------------

3.0.7
=====

All Databases
-------------

If you are upgrading from versions between 3.0.0 and 3.0.7, inclusive,
you might find improved performance by adding the following index to
your database:

CREATE INDEX Links4 ON Links(Type,LocalBase);


3.0.6
=====


All Databases
-------------

If you are upgrading from versions between 3.0.0 and 3.0.6, inclusive,
you might find improved performance by adding the following indices to
your database:

   CREATE INDEX TicketCustomFieldValues1 ON TicketCustomFieldValues (CustomField,Ticket,Content); 
   CREATE INDEX TicketCustomFieldValues2 ON TicketCustomFieldValues (CustomField,Ticket); 

   CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);


Postgres
--------

If you have a Postgres database, the following changes to your
database can improve performance:

  ALTER TABLE groups rename instance to instance1;
  ALTER TABLE groups add instance int;
  UPDATE groups SET instance = instance1::text::int where btrim(instance1) <> '';
  ALTER TABLE groups drop column instance1;