DotNetNukeŽ Silverlight Album

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {objectQualifier}  *****/
/*****                                                  *****/
/************************************************************/
 
 
if not exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}SilverlightAlbum_Pictures') and OBJECTPROPERTY(id, N'IsTable') = 1)
 
CREATE TABLE {databaseOwner}{objectQualifier}SilverlightAlbum_Pictures (
    [PictureID] [int] IDENTITY(1,1) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [Picture] [nvarchar](100) NOT NULL
) ON [PRIMARY]
 
GO
 
if not exists (select * from dbo.sysobjects where id = object_id(N'PK_{objectQualifier}SilverlightAlbum_Pictures') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1)
ALTER TABLE {databaseOwner}{objectQualifier}SilverlightAlbum_Pictures ADD CONSTRAINT
    PK_{objectQualifier}SilverlightAlbum_Pictures PRIMARY KEY CLUSTERED 
    (
    PictureID
    ) ON [PRIMARY]
 
 
/************************************************************/
/*****              SqlDataProvider                     *****/
/************************************************************/