Update of /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22679/platform/oracle Modified Files: GalleryChildEntity.sql GalleryDerivative.sql GalleryDerivativePreferencesMap.sql GalleryEntity.sql GalleryFileSystemEntity.sql GalleryGroup.sql GalleryItem.sql GalleryItemAttributesMap.sql GalleryItemPropertiesMap.sql GalleryPermissionMap.sql GalleryPermissionSetMap.sql GalleryPluginParameterMap.sql GalleryToolkitOperationMap.sql GalleryToolkitOperationMimeTypeMap.sql GalleryToolkitOperationParameterMap.sql GalleryToolkitPropertyMap.sql GalleryToolkitPropertyMimeTypeMap.sql GalleryUser.sql GalleryUserGroupMap.sql Log Message: Rebuild schema files to include table renames and Oracle updates. Index: GalleryToolkitPropertyMimeTypeMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryToolkitPropertyMimeTypeMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryToolkitPropertyMimeTypeMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryToolkitPropertyMimeTypeMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -3,7 +3,7 @@ -- why it looks so ugly. Editing it by hand would be a bad idea. -- - CREATE TABLE DB_TABLE_PREFIXToolkitPropertyMimeTypeMap ( + CREATE TABLE DB_TABLE_PREFIXTkPropertyMimeTypeMap ( DB_COLUMN_PREFIXpropertyName VARCHAR2( @@ -36,13 +36,13 @@ ); - CREATE INDEX ToolkitPropertyMimeTypeMap_propertyName - ON DB_TABLE_PREFIXToolkitPropertyMimeTypeMap + CREATE INDEX TkPropertyMimeTypeMap_I1 + ON DB_TABLE_PREFIXTkPropertyMimeTypeMap (DB_COLUMN_PREFIXpropertyName); - CREATE INDEX ToolkitPropertyMimeTypeMap_mimeType - ON DB_TABLE_PREFIXToolkitPropertyMimeTypeMap + CREATE INDEX TkPropertyMimeTypeMap_I2 + ON DB_TABLE_PREFIXTkPropertyMimeTypeMap (DB_COLUMN_PREFIXmimeType); @@ -52,7 +52,7 @@ DB_COLUMN_PREFIXmajor, DB_COLUMN_PREFIXminor ) VALUES ( - 'ToolkitPropertyMimeTypeMap', + 'TkPropertyMimeTypeMap', 1, 0 ); Index: GalleryEntity.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryEntity.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryEntity.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryEntity.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -50,22 +50,22 @@ ); - CREATE INDEX Entity_creationTimestamp + CREATE INDEX Entity_I1 ON DB_TABLE_PREFIXEntity (DB_COLUMN_PREFIXcreationTimestamp); - CREATE INDEX Entity_isLinkable + CREATE INDEX Entity_I2 ON DB_TABLE_PREFIXEntity (DB_COLUMN_PREFIXisLinkable); - CREATE INDEX Entity_modificationTimestamp + CREATE INDEX Entity_I3 ON DB_TABLE_PREFIXEntity (DB_COLUMN_PREFIXmodificationTimestamp); - CREATE INDEX Entity_serialNumber + CREATE INDEX Entity_I4 ON DB_TABLE_PREFIXEntity (DB_COLUMN_PREFIXserialNumber); Index: GalleryToolkitOperationMimeTypeMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryToolkitOperationMimeTypeMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryToolkitOperationMimeTypeMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryToolkitOperationMimeTypeMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -3,7 +3,7 @@ -- why it looks so ugly. Editing it by hand would be a bad idea. -- - CREATE TABLE DB_TABLE_PREFIXToolkitOperationMimeTypeMap ( + CREATE TABLE DB_TABLE_PREFIXTkOperationMimeTypeMap ( DB_COLUMN_PREFIXoperationName VARCHAR2( @@ -42,13 +42,13 @@ ); - CREATE INDEX ToolkitOperationMimeTypeMap_operationName - ON DB_TABLE_PREFIXToolkitOperationMimeTypeMap + CREATE INDEX TkOperationMimeTypeMap_I1 + ON DB_TABLE_PREFIXTkOperationMimeTypeMap (DB_COLUMN_PREFIXoperationName); - CREATE INDEX ToolkitOperationMimeTypeMap_mimeType - ON DB_TABLE_PREFIXToolkitOperationMimeTypeMap + CREATE INDEX TkOperationMimeTypeMap_I2 + ON DB_TABLE_PREFIXTkOperationMimeTypeMap (DB_COLUMN_PREFIXmimeType); @@ -58,7 +58,7 @@ DB_COLUMN_PREFIXmajor, DB_COLUMN_PREFIXminor ) VALUES ( - 'ToolkitOperationMimeTypeMap', + 'TkOperationMimeTypeMap', 1, 0 ); Index: GalleryToolkitPropertyMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryToolkitPropertyMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryToolkitPropertyMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryToolkitPropertyMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -3,7 +3,7 @@ -- why it looks so ugly. Editing it by hand would be a bad idea. -- - CREATE TABLE DB_TABLE_PREFIXToolkitPropertyMap ( + CREATE TABLE DB_TABLE_PREFIXTkPropertyMap ( DB_COLUMN_PREFIXname VARCHAR2( @@ -42,7 +42,7 @@ DB_COLUMN_PREFIXmajor, DB_COLUMN_PREFIXminor ) VALUES ( - 'ToolkitPropertyMap', + 'TkPropertyMap', 1, 0 ); Index: GalleryItemAttributesMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryItemAttributesMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryItemAttributesMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryItemAttributesMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -25,12 +25,10 @@ ) - NOT NULL - ); - CREATE INDEX ItemAttributesMap_parentSequence + CREATE INDEX ItemAttributesMap_I1 ON DB_TABLE_PREFIXItemAttributesMap (DB_COLUMN_PREFIXparentSequence); Index: GalleryToolkitOperationMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryToolkitOperationMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryToolkitOperationMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryToolkitOperationMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -3,7 +3,7 @@ -- why it looks so ugly. Editing it by hand would be a bad idea. -- - CREATE TABLE DB_TABLE_PREFIXToolkitOperationMap ( + CREATE TABLE DB_TABLE_PREFIXTkOperationMap ( DB_COLUMN_PREFIXname VARCHAR2( @@ -42,7 +42,7 @@ ); - ALTER TABLE DB_TABLE_PREFIXToolkitOperationMap + ALTER TABLE DB_TABLE_PREFIXTkOperationMap ADD PRIMARY KEY (DB_COLUMN_PREFIXname); @@ -51,7 +51,7 @@ DB_COLUMN_PREFIXmajor, DB_COLUMN_PREFIXminor ) VALUES ( - 'ToolkitOperationMap', + 'TkOperationMap', 1, 0 ); Index: GalleryPermissionSetMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryPermissionSetMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryPermissionSetMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryPermissionSetMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -46,7 +46,7 @@ ); - CREATE UNIQUE INDEX PermissionSetMap_permission + CREATE UNIQUE INDEX PermissionSetMap_U1 ON DB_TABLE_PREFIXPermissionSetMap (DB_COLUMN_PREFIXpermission); Index: GalleryPluginParameterMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryPluginParameterMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryPluginParameterMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryPluginParameterMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -47,12 +47,10 @@ ) - NOT NULL - ); - CREATE INDEX PluginParameterMap_pluginType_pluginId_itemId + CREATE INDEX PluginParameterMap_I1 ON DB_TABLE_PREFIXPluginParameterMap (DB_COLUMN_PREFIXpluginType , @@ -61,12 +59,12 @@ DB_COLUMN_PREFIXitemId); - CREATE INDEX PluginParameterMap_pluginType + CREATE INDEX PluginParameterMap_I2 ON DB_TABLE_PREFIXPluginParameterMap (DB_COLUMN_PREFIXpluginType); - CREATE UNIQUE INDEX PluginParameterMap_pluginType_pluginId_itemId_parameterName + CREATE UNIQUE INDEX PluginParameterMap_U1 ON DB_TABLE_PREFIXPluginParameterMap (DB_COLUMN_PREFIXpluginType , Index: GalleryItem.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryItem.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- GalleryItem.sql 26 Aug 2004 08:30:09 -0000 1.2 +++ GalleryItem.sql 31 Aug 2004 21:41:46 -0000 1.3 @@ -17,7 +17,7 @@ , DB_COLUMN_PREFIXdescription - LONG + VARCHAR2(4000) , DB_COLUMN_PREFIXkeywords @@ -82,22 +82,22 @@ ); - CREATE INDEX Item_keywords + CREATE INDEX Item_I1 ON DB_TABLE_PREFIXItem (DB_COLUMN_PREFIXkeywords); - CREATE INDEX Item_ownerId + CREATE INDEX Item_I2 ON DB_TABLE_PREFIXItem (DB_COLUMN_PREFIXownerId); - CREATE INDEX Item_summary + CREATE INDEX Item_I3 ON DB_TABLE_PREFIXItem (DB_COLUMN_PREFIXsummary); - CREATE INDEX Item_title + CREATE INDEX Item_I4 ON DB_TABLE_PREFIXItem (DB_COLUMN_PREFIXtitle); @@ -116,4 +116,4 @@ 0 ); - + \ No newline at end of file Index: GalleryChildEntity.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryChildEntity.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryChildEntity.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryChildEntity.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -18,7 +18,7 @@ ); - CREATE INDEX ChildEntity_parentId + CREATE INDEX ChildEntity_I1 ON DB_TABLE_PREFIXChildEntity (DB_COLUMN_PREFIXparentId); Index: GalleryUser.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryUser.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryUser.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryUser.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -57,7 +57,7 @@ ALTER TABLE DB_TABLE_PREFIXUser ADD PRIMARY KEY (DB_COLUMN_PREFIXid); - CREATE UNIQUE INDEX User_userName + CREATE UNIQUE INDEX User_U2 ON DB_TABLE_PREFIXUser (DB_COLUMN_PREFIXuserName); Index: GalleryUserGroupMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryUserGroupMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryUserGroupMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryUserGroupMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -18,12 +18,12 @@ ); - CREATE INDEX UserGroupMap_userId + CREATE INDEX UserGroupMap_I1 ON DB_TABLE_PREFIXUserGroupMap (DB_COLUMN_PREFIXuserId); - CREATE INDEX UserGroupMap_groupId + CREATE INDEX UserGroupMap_I2 ON DB_TABLE_PREFIXUserGroupMap (DB_COLUMN_PREFIXgroupId); Index: GalleryItemPropertiesMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryItemPropertiesMap.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- GalleryItemPropertiesMap.sql 26 Aug 2004 08:30:09 -0000 1.2 +++ GalleryItemPropertiesMap.sql 31 Aug 2004 21:41:46 -0000 1.3 @@ -21,7 +21,7 @@ , DB_COLUMN_PREFIXvalue - LONG + VARCHAR2(4000) ); @@ -37,4 +37,4 @@ 0 ); - + \ No newline at end of file Index: GalleryDerivativePreferencesMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryDerivativePreferencesMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryDerivativePreferencesMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryDerivativePreferencesMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -3,7 +3,7 @@ -- why it looks so ugly. Editing it by hand would be a bad idea. -- - CREATE TABLE DB_TABLE_PREFIXDerivativePreferencesMap ( + CREATE TABLE DB_TABLE_PREFIXDerivativePrefsMap ( DB_COLUMN_PREFIXitemId INTEGER @@ -26,8 +26,8 @@ ); - CREATE INDEX DerivativePreferencesMap_itemId - ON DB_TABLE_PREFIXDerivativePreferencesMap + CREATE INDEX DerivativePrefsMap_I1 + ON DB_TABLE_PREFIXDerivativePrefsMap (DB_COLUMN_PREFIXitemId); @@ -37,7 +37,7 @@ DB_COLUMN_PREFIXmajor, DB_COLUMN_PREFIXminor ) VALUES ( - 'DerivativePreferencesMap', + 'DerivativePrefsMap', 1, 0 ); Index: GalleryPermissionMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryPermissionMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryPermissionMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryPermissionMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -26,17 +26,17 @@ ); - CREATE INDEX PermissionMap_itemId + CREATE INDEX PermissionMap_I1 ON DB_TABLE_PREFIXPermissionMap (DB_COLUMN_PREFIXitemId); - CREATE INDEX PermissionMap_userId + CREATE INDEX PermissionMap_I2 ON DB_TABLE_PREFIXPermissionMap (DB_COLUMN_PREFIXuserId); - CREATE INDEX PermissionMap_groupId + CREATE INDEX PermissionMap_I3 ON DB_TABLE_PREFIXPermissionMap (DB_COLUMN_PREFIXgroupId); Index: GalleryToolkitOperationParameterMap.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryToolkitOperationParameterMap.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryToolkitOperationParameterMap.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryToolkitOperationParameterMap.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -3,7 +3,7 @@ -- why it looks so ugly. Editing it by hand would be a bad idea. -- - CREATE TABLE DB_TABLE_PREFIXToolkitOperationParameterMap ( + CREATE TABLE DB_TABLE_PREFIXTkOperationParameterMap ( DB_COLUMN_PREFIXoperationName VARCHAR2( @@ -40,8 +40,8 @@ ); - CREATE INDEX ToolkitOperationParameterMap_operationName - ON DB_TABLE_PREFIXToolkitOperationParameterMap + CREATE INDEX TkOperationParameterMap_I1 + ON DB_TABLE_PREFIXTkOperationParameterMap (DB_COLUMN_PREFIXoperationName); @@ -51,7 +51,7 @@ DB_COLUMN_PREFIXmajor, DB_COLUMN_PREFIXminor ) VALUES ( - 'ToolkitOperationParameterMap', + 'TkOperationParameterMap', 1, 0 ); Index: GalleryGroup.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryGroup.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryGroup.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryGroup.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -29,7 +29,7 @@ ALTER TABLE DB_TABLE_PREFIXGroup ADD PRIMARY KEY (DB_COLUMN_PREFIXid); - CREATE UNIQUE INDEX Group_groupName + CREATE UNIQUE INDEX Group_U2 ON DB_TABLE_PREFIXGroup (DB_COLUMN_PREFIXgroupName); Index: GalleryDerivative.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryDerivative.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryDerivative.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryDerivative.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -54,17 +54,17 @@ ); - CREATE INDEX Derivative_derivativeSourceId + CREATE INDEX Derivative_I1 ON DB_TABLE_PREFIXDerivative (DB_COLUMN_PREFIXderivativeSourceId); - CREATE INDEX Derivative_derivativeOrder + CREATE INDEX Derivative_I2 ON DB_TABLE_PREFIXDerivative (DB_COLUMN_PREFIXderivativeOrder); - CREATE INDEX Derivative_derivativeType + CREATE INDEX Derivative_I3 ON DB_TABLE_PREFIXDerivative (DB_COLUMN_PREFIXderivativeType); Index: GalleryFileSystemEntity.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryFileSystemEntity.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- GalleryFileSystemEntity.sql 24 Aug 2004 22:19:57 -0000 1.1 +++ GalleryFileSystemEntity.sql 31 Aug 2004 21:41:46 -0000 1.2 @@ -20,7 +20,7 @@ ); - CREATE INDEX FileSystemEntity_pathComponent + CREATE INDEX FileSystemEntity_I1 ON DB_TABLE_PREFIXFileSystemEntity (DB_COLUMN_PREFIXpathComponent); |