soc.sql

/* prod */
TRUNCATE TABLE [SIX_SOC_Calculator].[dbo].[Options];

DELETE FROM [SIX_SOC_Calculator].[dbo].[Settings]
DBCC CHECKIDENT ('SIX_SOC_Calculator.dbo.Products',RESEED, 0);

DELETE FROM [SIX_SOC_Calculator].[dbo].[Products]
DBCC CHECKIDENT ('SIX_SOC_Calculator.dbo.Settings',RESEED, 0);

/* dev */
TRUNCATE TABLE SIX_SOC_Calculator_DEV.[dbo].[Options];

DELETE FROM SIX_SOC_Calculator_DEV.[dbo].[Settings]
DBCC CHECKIDENT ('SIX_SOC_Calculator_DEV.dbo.Products',RESEED, 0);

DELETE FROM SIX_SOC_Calculator_DEV.[dbo].[Products]
DBCC CHECKIDENT ('SIX_SOC_Calculator_DEV.dbo.Settings',RESEED, 0);

UPDATE [SIX_SOC_Calculator_DEV].[dbo].[Settings]
SET [Name] = 'Number of SIX Playbooks'
WHERE [Id] = 32;


UPDATE [SIX_SOC_Calculator_DEV].[dbo].[Settings]
SET [Name] = 'Number of Customer Playbooks'
WHERE [Id] = 33;