--- bacula-1.34.1/updatedb/update_mysql_tables_4_to_5.update 2004-02-18 22:23:04.000000000 +0100 +++ bacula-1.34.1/updatedb/update_mysql_tables_4_to_5 2004-04-18 19:50:30.000000000 +0200 @@ -37,7 +37,8 @@ 'Busy', 'Used') NOT NULL; ALTER TABLE Media CHANGE VolMaxBytes MaxVolBytes BIGINT UNSIGNED NOT NULL; -UPDATE Version SET VersionId=5; +DELETE FROM Version; +INSERT INTO Version (VersionId) VALUES (5); END-OF-DATA then --- bacula-1.34.1/updatedb/update_mysql_tables_5_to_6.update 2004-02-18 22:23:04.000000000 +0100 +++ bacula-1.34.1/updatedb/update_mysql_tables_5_to_6 2004-04-18 19:50:38.000000000 +0200 @@ -86,7 +86,8 @@ PRIMARY KEY (Counter(128)) ); -UPDATE Version SET VersionId=6; +DELETE FROM Version; +INSERT INTO Version (VersionId) VALUES (6); END-OF-DATA then --- bacula-1.34.1/updatedb/update_sqlite_tables_4_to_5.update 2004-02-18 22:23:04.000000000 +0100 +++ bacula-1.34.1/updatedb/update_sqlite_tables_4_to_5 2004-04-18 19:53:10.000000000 +0200 @@ -9,9 +9,9 @@ echo " " # The location of the sqlite program -bindir=/usr/lib/sqlite +bindir=/usr/bin # The location of your bacula working directory -cd /var/bacula +cd /var/lib/bacula if [ -s bacula.db ];then DB_VER=`echo "select * from Version;" | $bindir/sqlite bacula.db | tail -n 1 2>/dev/null` @@ -140,6 +140,7 @@ DROP TABLE Pool_backup; COMMIT; -UPDATE Version SET VersionId=5; +DELETE FROM Version; +INSERT INTO Version (VersionId) VALUES (5); END-OF-DATA --- bacula-1.34.1/updatedb/update_sqlite_tables_5_to_6.update 2004-02-18 22:23:04.000000000 +0100 +++ bacula-1.34.1/updatedb/update_sqlite_tables_5_to_6 2004-04-18 19:53:25.000000000 +0200 @@ -9,9 +9,9 @@ echo " " # The location of the sqlite program -bindir=/usr/lib/sqlite +bindir=/usr/bin # The location of your bacula working directory -cd /var/bacula +cd /var/lib/bacula if [ -s bacula.db ];then DB_VER=`echo "select * from Version;" | $bindir/sqlite bacula.db | tail -n 1 2>/dev/null` @@ -170,6 +170,7 @@ PRIMARY KEY (Counter) ); -UPDATE Version SET VersionId=6; +DELETE FROM Version; +INSERT INTO Version (VersionId) VALUES (6); END-OF-DATA --- bacula-1.34.1/updatedb/update_sqlite_tables_6_to_7.update 2004-04-09 18:59:25.000000000 +0200 +++ bacula-1.34.1/updatedb/update_sqlite_tables_6_to_7 2004-04-18 19:53:43.000000000 +0200 @@ -9,9 +9,9 @@ echo " " # The location of the sqlite program -bindir=/usr/lib/sqlite +bindir=/usr/bin # The location of your bacula working directory -cd /var/bacula +cd /var/lib/bacula if [ -s bacula.db ];then DB_VER=`echo "select * from Version;" | $bindir/sqlite bacula.db | tail -n 1 2>/dev/null`