3 # shell script to update SQLite from version 2.0 to 3.0
6 echo "This script will update a Bacula SQLite database from version 10 to 11"
7 echo " which is needed to convert from Bacula version 2.0.x to 3.0.x or higher"
8 echo "Depending on the size of your database,"
9 echo "this script may take several minutes to run."
17 ${bindir}/${sqlite} $* ${db_name}.db <<END-OF-DATA
20 -- Create a table like Job for long term statistics
21 CREATE TABLE jobstat (LIKE job);
23 UPDATE Version SET VersionId=11;