From: Bharat M. <bh...@us...> - 2005-09-29 08:31:50
|
Update of /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31424/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql Modified Files: GalleryAccessSubscriberMap.sql GalleryEntity.sql GalleryItemAttributesMap.sql GalleryMaintenanceMap.sql GalleryPluginParameterMap.sql Log Message: Minor refactors of the database xml generation template and code to clean up the template. Index: GalleryMaintenanceMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryMaintenanceMap.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- GalleryMaintenanceMap.sql 27 Sep 2005 01:21:32 -0000 1.4 +++ GalleryMaintenanceMap.sql 29 Sep 2005 08:31:42 -0000 1.5 @@ -4,8 +4,8 @@ DB_COLUMN_PREFIXtimestamp int(11), DB_COLUMN_PREFIXsuccess int(1), DB_COLUMN_PREFIXdetails text, - INDEX DB_TABLE_PREFIXMaintenanceMap_21687(DB_COLUMN_PREFIXtaskId), - PRIMARY KEY(DB_COLUMN_PREFIXrunId) + PRIMARY KEY(DB_COLUMN_PREFIXrunId), + INDEX DB_TABLE_PREFIXMaintenanceMap_21687(DB_COLUMN_PREFIXtaskId) ) TYPE=DB_TABLE_TYPE; INSERT INTO DB_TABLE_PREFIXSchema ( Index: GalleryEntity.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryEntity.sql,v retrieving revision 1.17 retrieving revision 1.18 diff -u -d -r1.17 -r1.18 --- GalleryEntity.sql 27 Sep 2005 01:21:32 -0000 1.17 +++ GalleryEntity.sql 29 Sep 2005 08:31:42 -0000 1.18 @@ -7,11 +7,11 @@ DB_COLUMN_PREFIXserialNumber int(11) NOT NULL, DB_COLUMN_PREFIXentityType varchar(32) NOT NULL, DB_COLUMN_PREFIXonLoadHandlers varchar(128), + PRIMARY KEY(DB_COLUMN_PREFIXid), INDEX DB_TABLE_PREFIXEntity_76255(DB_COLUMN_PREFIXcreationTimestamp), INDEX DB_TABLE_PREFIXEntity_35978(DB_COLUMN_PREFIXisLinkable), INDEX DB_TABLE_PREFIXEntity_63025(DB_COLUMN_PREFIXmodificationTimestamp), - INDEX DB_TABLE_PREFIXEntity_60702(DB_COLUMN_PREFIXserialNumber), - PRIMARY KEY(DB_COLUMN_PREFIXid) + INDEX DB_TABLE_PREFIXEntity_60702(DB_COLUMN_PREFIXserialNumber) ) TYPE=DB_TABLE_TYPE; INSERT INTO DB_TABLE_PREFIXSchema ( Index: GalleryAccessSubscriberMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryAccessSubscriberMap.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- GalleryAccessSubscriberMap.sql 27 Sep 2005 01:21:32 -0000 1.4 +++ GalleryAccessSubscriberMap.sql 29 Sep 2005 08:31:42 -0000 1.5 @@ -1,8 +1,8 @@ CREATE TABLE DB_TABLE_PREFIXAccessSubscriberMap( DB_COLUMN_PREFIXitemId int(11) NOT NULL, DB_COLUMN_PREFIXaccessListId int(11) NOT NULL, - INDEX DB_TABLE_PREFIXAccessSubscriberMap_83732(DB_COLUMN_PREFIXaccessListId), - PRIMARY KEY(DB_COLUMN_PREFIXitemId) + PRIMARY KEY(DB_COLUMN_PREFIXitemId), + INDEX DB_TABLE_PREFIXAccessSubscriberMap_83732(DB_COLUMN_PREFIXaccessListId) ) TYPE=DB_TABLE_TYPE; INSERT INTO DB_TABLE_PREFIXSchema ( Index: GalleryItemAttributesMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryItemAttributesMap.sql,v retrieving revision 1.10 retrieving revision 1.11 diff -u -d -r1.10 -r1.11 --- GalleryItemAttributesMap.sql 27 Sep 2005 01:21:32 -0000 1.10 +++ GalleryItemAttributesMap.sql 29 Sep 2005 08:31:42 -0000 1.11 @@ -3,8 +3,8 @@ DB_COLUMN_PREFIXviewCount int(11), DB_COLUMN_PREFIXorderWeight int(11), DB_COLUMN_PREFIXparentSequence varchar(255) NOT NULL, - INDEX DB_TABLE_PREFIXItemAttributesMap_95270(DB_COLUMN_PREFIXparentSequence), - PRIMARY KEY(DB_COLUMN_PREFIXitemId) + PRIMARY KEY(DB_COLUMN_PREFIXitemId), + INDEX DB_TABLE_PREFIXItemAttributesMap_95270(DB_COLUMN_PREFIXparentSequence) ) TYPE=DB_TABLE_TYPE; INSERT INTO DB_TABLE_PREFIXSchema ( Index: GalleryPluginParameterMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryPluginParameterMap.sql,v retrieving revision 1.9 retrieving revision 1.10 diff -u -d -r1.9 -r1.10 --- GalleryPluginParameterMap.sql 27 Sep 2005 01:21:32 -0000 1.9 +++ GalleryPluginParameterMap.sql 29 Sep 2005 08:31:42 -0000 1.10 @@ -5,8 +5,8 @@ DB_COLUMN_PREFIXparameterName varchar(128) NOT NULL, DB_COLUMN_PREFIXparameterValue text NOT NULL, UNIQUE KEY(DB_COLUMN_PREFIXpluginType, DB_COLUMN_PREFIXpluginId, DB_COLUMN_PREFIXitemId, DB_COLUMN_PREFIXparameterName), - INDEX DB_TABLE_PREFIXPluginParameterMap_12808(DB_COLUMN_PREFIXpluginType, DB_COLUMN_PREFIXpluginId, DB_COLUMN_PREFIXitemId), - INDEX DB_TABLE_PREFIXPluginParameterMap_80596(DB_COLUMN_PREFIXpluginType) + INDEX DB_TABLE_PREFIXPluginParameterMap_80596(DB_COLUMN_PREFIXpluginType), + INDEX DB_TABLE_PREFIXPluginParameterMap_12808(DB_COLUMN_PREFIXpluginType, DB_COLUMN_PREFIXpluginId, DB_COLUMN_PREFIXitemId) ) TYPE=DB_TABLE_TYPE; INSERT INTO DB_TABLE_PREFIXSchema ( |