From 909818164f0c5ddec1458ac8159c7a08191d2c7d Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Wed, 18 Feb 2009 14:35:53 +0000 Subject: [PATCH] ebl tweak JobHisto index git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@8471 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/patches/testing/next-beta.patch | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/bacula/patches/testing/next-beta.patch b/bacula/patches/testing/next-beta.patch index bf7a355c9a..9078c826e6 100644 --- a/bacula/patches/testing/next-beta.patch +++ b/bacula/patches/testing/next-beta.patch @@ -210,7 +210,7 @@ Index: src/cats/make_sqlite3_tables.in + HasBase TINYINT DEFAULT 0 ); -CREATE INDEX inx61 ON JobHistory (Name); -+CREATE INDEX inx61 ON JobHisto (Name); ++CREATE INDEX inx61 ON JobHisto (StartTime); CREATE TABLE Location ( LocationId INTEGER, @@ -507,7 +507,7 @@ Index: src/cats/update_sqlite3_tables.in + PurgedFiles TINYINT DEFAULT 0, + HasBase TINYINT DEFAULT 0 + ); -+CREATE INDEX inx61 ON JobHisto (Name); ++CREATE INDEX inx61 ON JobHisto (StartTime); + END-OF-DATA Index: src/cats/make_postgresql_tables.in @@ -799,7 +799,7 @@ Index: src/cats/update_sqlite_tables.in + PurgedFiles TINYINT DEFAULT 0, + HasBase TINYINT DEFAULT 0 + ); -+CREATE INDEX inx61 ON JobHisto (Name); ++CREATE INDEX inx61 ON JobHisto (StartTime); + END-OF-DATA Index: src/cats/update_mysql_tables.in @@ -908,7 +908,7 @@ Index: src/cats/make_sqlite_tables.in + HasBase TINYINT DEFAULT 0 ); -CREATE INDEX inx61 ON JobHistory (Name); -+CREATE INDEX inx61 ON JobHisto (Name); ++CREATE INDEX inx61 ON JobHisto (StartTime); CREATE TABLE Location ( LocationId INTEGER, -- 2.39.5