update SiteCollectionRepository set [Type] = 1

ALTER TABLE SiteCollectionRepository
ALTER COLUMN [Type] int not null

exec sp_rename 'SiteCollectionRepository', 'SiteRepository'
exec sp_rename 'SiteCollectionRepositorySite', 'SiteRepositoryWebsite'

