ÿþ/*

Run this script on the database containing the Beta 2 version (v2.0.2807) of Gallery Server Pro 2.0.

*/

PRINT N'Renaming index [ForeignKeyIndex] to [IDX_gs_MediaObject_FKAlbumID] in table [dbo].[gs_MediaObject]'

GO

EXEC sp_rename N'[dbo].[gs_MediaObject].[ForeignKeyIndex]', N'IDX_gs_MediaObject_FKAlbumID', N'INDEX';

GO



PRINT N'Creating index [IDX_gs_MediaObjectMetadata_FKMediaObjectId] on [dbo].[gs_MediaObjectMetadata]'

GO

CREATE NONCLUSTERED INDEX [IDX_gs_MediaObjectMetadata_FKMediaObjectId] ON [dbo].[gs_MediaObjectMetadata] ([FKMediaObjectId] ASC ) ON [PRIMARY]

GO