X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fcats%2Fmake_mysql_tables.in;h=e92952bdcd53293e598d2f47aee19b862f34d447;hb=9e9a7171fe27ae6a8c2c39d1bef901347766859e;hp=ef2efffa41e10192e093df51959c33d6938780b7;hpb=fcd0402aa5ca4621b80125ce726fcf6b9a67efec;p=bacula%2Fbacula diff --git a/bacula/src/cats/make_mysql_tables.in b/bacula/src/cats/make_mysql_tables.in index ef2efffa41..e92952bdcd 100644 --- 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 (