/************************************************************/

/*****              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                     *****/

/************************************************************/