/* 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
DROP INDEX IX_diggs_item ON dbo.diggs
GO
ALTER TABLE dbo.diggs
	DROP CONSTRAINT PK_diggs
GO
ALTER TABLE dbo.diggs ADD CONSTRAINT
	PK_diggs PRIMARY KEY CLUSTERED 
	(
	item_id,
	user_id
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.diggs
	DROP COLUMN id
GO
DROP INDEX IX_diggs_user ON dbo.diggs
GO
CREATE NONCLUSTERED INDEX IX_diggs_user ON dbo.diggs
	(
	user_id,
	digdate DESC
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.diggs SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

DBCC DBREINDEX('dbo.diggs')
GO

/* 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
DROP INDEX IX_User_To_Friend ON dbo.friends
GO
ALTER TABLE dbo.friends
	DROP CONSTRAINT PK_friends
GO
ALTER TABLE dbo.friends ADD CONSTRAINT
	PK_friends_1 PRIMARY KEY CLUSTERED 
	(
	user_id,
	friend_id
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.friends
	DROP COLUMN id
GO
ALTER TABLE dbo.friends SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

DBCC DBREINDEX('dbo.friends')
GO