#31 Provide 7.0.0 Upgrade sql file for PostgreSQL

[Robert Oschwald]

A sql patch file to upgrade from 5.x to 7.0.0 on PostgreSQL would be great and would make live much easier for your users. Now everyone need to translate your upgrade.txt statements from MySQL to PostgreSQL on their own which is error prone and could be much easier done.

Other systems (like Bacula itself) provide upgrade sql scripts which you simply execute and I think this is a good way to streamline the upgrades.

[Robert Oschwald]

Here is the script for PostgreSQL 9.3.
Note that one index and webacula_jobdesc.short_desc already exist in my 5.5.2 db.

ALTER TABLE webacula_users ALTER COLUMN pwd TYPE varchar(256);
ALTER TABLE webacula_users ALTER COLUMN pwd SET NOT NULL;
ALTER TABLE webacula_users ALTER COLUMN last_ip TYPE varchar(40);
ALTER TABLE webacula_users ALTER COLUMN last_ip SET DEFAULT NULL;
ALTER TABLE webacula_php_session ALTER COLUMN id TYPE char(64);

INSERT INTO webacula_dt_commands (id, name, description) VALUES (295, 'stop',        'Stop a job');
INSERT INTO webacula_dt_commands (id, name, description) VALUES (305, 'setbandwidth','Sets bandwidth');
INSERT INTO webacula_dt_commands (id, name, description) VALUES (355, 'truncate',    'Truncate one or more Volumes');

/* Note: This column already exists in 5.5.2 */
/* 
ALTER TABLE webacula_jobdesc ADD COLUMN short_desc VARCHAR(128);
ALTER TABLE webacula_jobdesc ADD COLUMN short_desc SET NOT NULL;
*/

/* Note: This index already exists in 5.5.2 */
-- CREATE INDEX webacula_idx3 ON webacula_jobdesc (name_job);
CREATE INDEX webacula_idx4 ON webacula_jobdesc (short_desc);

-- Recreate index "UNIQUE INDEX (name, role_id)" from table "webacula_where_acl" :
REINDEX INDEX webacula_where_acl_idx1;