3 # Shell script to update PostgreSQL tables from version 1.38 to 1.39
6 echo "This script will update a Bacula PostgreSQL database from version 9 to 9"
7 echo "Depending on the size of your database,"
8 echo "this script may take several minutes to run."
12 if $bindir/psql -f - -d bacula $* <<END-OF-DATA
14 ALTER TABLE media ADD COLUMN DeviceId integer;
15 UPDATE media SET DeviceId=0;
16 ALTER TABLE media ADD COLUMN MediaTypeId integer;
17 UPDATE media SET MediaTypeId=0;
18 ALTER TABLE media ADD COLUMN LocationId integer;
19 UPDATE media SET LocationId=0;
20 ALTER TABLE media ADD COLUMN RecycleCount integer;
21 UPDATE media SET RecycleCount=0;
22 ALTER TABLE media ADD COLUMN InitialWrite timestamp without time zone;
23 UPDATE media SET InitialWrite=0;
24 ALTER TABLE media ADD COLUMN scratchpoolid integer;
25 UPDATE media SET scratchpoolid=0;
26 ALTER TABLE media ADD COLUMN recyclepoolid integer;
27 UPDATE media SET recyclepoolid=0;
28 ALTER TABLE media ADD COLUMN enabled integer;
29 UPDATE media SET enabled=1;
31 ALTER TABLE job ADD COLUMN RealEndTime timestamp without time zone;
32 UPDATE job SET RealEndTime=0;
33 ALTER TABLE job ADD COLUMN PriorJobId integer;
34 UPDATE job SET PriorJobId=0;
36 ALTER TABLE jobmedia DROP COLUMN Stripe;
38 CREATE TABLE Location (
39 LocationId SERIAL NOT NULL,
40 Location TEXT NOT NULL,
41 Cost integer not null default 0,
42 PRIMARY KEY (LocationId)
47 INSERT INTO version (versionId) VALUES (10);
53 echo "Update of Bacula PostgreSQL tables succeeded."
55 echo "Update of Bacula PostgreSQL tables failed."