Print block errors once + add RunAfterFailedJob + improve db_find_job_start_time...

[bacula/bacula] / bacula / src / cats / make_mysql_tables.in

diff --git a/bacula/src/cats/make_mysql_tables.in b/bacula/src/cats/make_mysql_tables.in
index e9b63202f0ec9b9596cc96e4ecbfeb2cd3e7d21f..1ce0d6aadcab7d5c15fdce62bb6a4701ab40647a 100644 (file)
--- a/bacula/src/cats/make_mysql_tables.in
+++ b/bacula/src/cats/make_mysql_tables.in
@@ -177,11 +177,11 @@ INSERT INTO Version (VersionId) VALUES (6);
 
 CREATE TABLE Counters (
    Counter TINYBLOB NOT NULL,
-   PoolId INTEGER UNSIGNED NOT NULL REFERENCES Pool,
    MinValue INTEGER,
    MaxValue INTEGER,
    CurrentValue INTEGER,
-   WrapCounter TINYBLOB NOT NULL
+   WrapCounter TINYBLOB NOT NULL,
+   PRIMARY KEY (Counter(128))
    );