CREATE TABLE [dbo].[CoCompanies]
(
[CompanyID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CompanyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EIN] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBTypeID] [int] NOT NULL CONSTRAINT [DF_CoCompanies_DBTypeID] DEFAULT ((1)),
[Locks] [int] NOT NULL CONSTRAINT [DF_CoCompanies_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_CoCompanies_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_CoCompanies_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[Address_MapPoint] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City_MapPoint] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State_MapPoint] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip_MapPoint] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AnalyticsServer] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AnalyticsDatabase] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaskEngineSuspended] [bit] NOT NULL CONSTRAINT [DF_CoCompanies_TaskEngineSuspended] DEFAULT ((1)),
[ADSEnabled] [bit] NOT NULL CONSTRAINT [DF_CoCompanies_ADSEnabled] DEFAULT ((1)),
[ADSEndpoint] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ADSLastContact] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TRIGGER [dbo].[tdCoCompanies] ON [dbo].[CoCompanies]
FOR DELETE
AS
BEGIN
IF EXISTS(SELECT 1 FROM deleted WHERE Locks > 0)
BEGIN
RAISERROR('Attempt to delete row from CoCompanies where Locks is greater than zero.', 11, 2)
ROLLBACK TRANSACTION
RETURN
END
END
GO
ALTER TABLE [dbo].[CoCompanies] ADD CONSTRAINT [PK_CoCompanies] PRIMARY KEY CLUSTERED ([CompanyID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoCompanies] ADD CONSTRAINT [FK_CoCompanies_DBTypeID_CoDBTypes] FOREIGN KEY ([DBTypeID]) REFERENCES [dbo].[CoDBTypes] ([DBTypeID])
GO