IF  EXISTS (SELECT * FROM dbo.sysobjects 
					WHERE id = object_id(N'TTS.UserEnabledColumns') 
						AND OBJECTPROPERTY(id, N'IsTable') = 1)
		DROP TABLE TTS.UserEnabledColumns
	GO
			CREATE TABLE [TTS].[UserEnabledColumns](
			[EnabledColumnId] [int] IDENTITY(1,1) NOT NULL,
			[UserName] [varchar](200) NULL,
			[Columname] [varchar](200) NULL,
			[IsActive] [bit] NOT NULL,
			[CreatedDate] [datetime] NOT NULL,
			[ModifiedDate] [datetime] 
			) 
	GO


-----------------------------------------------------------------------------------------
USE [TroxlerTS_DEV]
GO

INSERT INTO [TTS].[UserEnabledColumns]
           ([UserName],[Columname],[IsActive],[CreatedDate])
     VALUES
           ('tts1','CompanyName',1,GETDATE()),
		   ('tts1','ContactLastName',1,GETDATE()),
		   ('tts1','TicketType',0,GETDATE()),
		   ('tts1','TicketTopic',1,GETDATE()),
		   ('tts1','Age',1,GETDATE()),
		   ('tts1','DueDate',1,GETDATE()),
		   ('tts1','Owner',1,GETDATE()),
		   ('tts1','Followings',0,GETDATE())
GO

-----------------------------------------------------------------------------------------


IF  EXISTS (SELECT * FROM dbo.sysobjects 
					WHERE id = object_id(N'MasterData.UserDefaultColumns') 
						AND OBJECTPROPERTY(id, N'IsTable') = 1)
		DROP TABLE MasterData.UserDefaultColumns
	GO
			CREATE TABLE [MasterData].[UserDefaultColumns](
			[DefaultColumnId] [int] IDENTITY(1,1) NOT NULL,
			[DefaultColumname] [varchar](200) NULL,
			[IsActive] [bit] NOT NULL,
			[CreatedDate] [datetime] NOT NULL,
			[ModifiedDate] [datetime] 
			) 
	GO

USE [TroxlerTS_DEV]
GO

INSERT INTO [MasterData].[UserDefaultColumns]
           ([DefaultColumname],[IsActive],[CreatedDate])
     VALUES
           ('TicketNumber',1,GETDATE()),
		   ('Status',1,GETDATE()),
		   ('Owner',1,GETDATE())
GO