Remove bad index tips on mysql creation script

[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 ef2efffa41e10192e093df51959c33d6938780b7..e92952bdcd53293e598d2f47aee19b862f34d447 100644 (file)
--- a/bacula/src/cats/make_mysql_tables.in
+++ b/bacula/src/cats/make_mysql_tables.in
@@ -46,11 +46,12 @@ CREATE TABLE File (
    );
 
 CREATE TABLE RestoreObject (
-   RestoreObjectId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT;
+   RestoreObjectId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
    Fname BLOB NOT NULL,
    Path BLOB NOT NULL,
    RestoreObject BLOB NOT NULL,
    PluginName TINYBLOB NOT NULL,
+   ObjectLength INTEGER DEFAULT 0,
    ObjectIndex INTEGER DEFAULT 0,
    ObjectType INTEGER DEFAULT 0,
    FileIndex INTEGER UNSIGNED DEFAULT 0,
@@ -67,8 +68,6 @@ CREATE TABLE RestoreObject (
 #
 #  INDEX (PathId),
 #  INDEX (FilenameId),
-#  INDEX (FilenameId, PathId)
-#  INDEX (JobId),
 #
 
 CREATE TABLE MediaType (