/*
   Sunday, March 11, 20182:02:00 PM
   User: 
   Server: localhost\SQLEXPRESS
   Database: Tango
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.USERS
	DROP CONSTRAINT FK_USERS_ADDRESSES
GO
ALTER TABLE dbo.ADDRESSES SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
select Has_Perms_By_Name(N'dbo.ADDRESSES', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.ADDRESSES', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.ADDRESSES', 'Object', 'CONTROL') as Contr_Per BEGIN TRANSACTION
GO
ALTER TABLE dbo.USERS
	DROP CONSTRAINT FK_USERS_CONTACTS
GO
ALTER TABLE dbo.CONTACTS SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
select Has_Perms_By_Name(N'dbo.CONTACTS', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.CONTACTS', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.CONTACTS', 'Object', 'CONTROL') as Contr_Per BEGIN TRANSACTION
GO
ALTER TABLE dbo.USERS ADD CONSTRAINT
	FK_USERS_ADDRESSES FOREIGN KEY
	(
	ADDRESS_GUID
	) REFERENCES dbo.ADDRESSES
	(
	GUID
	) ON UPDATE  NO ACTION 
	 ON DELETE  CASCADE 
	
GO
ALTER TABLE dbo.USERS ADD CONSTRAINT
	FK_USERS_CONTACTS FOREIGN KEY
	(
	CONTACT_GUID
	) REFERENCES dbo.CONTACTS
	(
	GUID
	) ON UPDATE  NO ACTION 
	 ON DELETE  CASCADE 
	
GO
ALTER TABLE dbo.USERS SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
select Has_Perms_By_Name(N'dbo.USERS', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.USERS', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.USERS', 'Object', 'CONTROL') as Contr_Per