[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Bacula-devel] small mysql patch2


Hi

This patch you must approve ;)
Double-created index of the same field PoolId. See attach.

CREATE TABLE Media (
...
   PRIMARY KEY(MediaId),
   INDEX (PoolId)
);

CREATE INDEX inx8 ON Media (PoolId);


-- 
with best regards
Index: bacula/src/cats/make_mysql_tables.in
===================================================================
--- bacula/src/cats/make_mysql_tables.in	(revision 7537)
+++ bacula/src/cats/make_mysql_tables.in	(working copy)
@@ -213,7 +213,6 @@
    INDEX (PoolId)
    );
 
-CREATE INDEX inx8 ON Media (PoolId);
 
 
 
Index: bacula/src/win32/cats/make_mysql_tables.sql
===================================================================
--- bacula/src/win32/cats/make_mysql_tables.sql	(revision 7537)
+++ bacula/src/win32/cats/make_mysql_tables.sql	(working copy)
@@ -203,7 +203,6 @@
    INDEX (PoolId)
    );
 
-CREATE INDEX inx8 ON Media (PoolId);
 
 
 
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.