CREATE TABLE [dbo].[LMLS]
(
[LeaseID] [int] NOT NULL IDENTITY(1, 1),
[LeaseType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Feature] [int] NOT NULL,
[CreateTime] [datetime] NOT NULL CONSTRAINT [DF_LMLS_CREATETIME] DEFAULT (getdate()),
[ExpireTime] [datetime] NULL,
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_LMLS_LASTUPDATE] DEFAULT (getdate()),
[IP] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UniqueID] [varchar] (4096) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserLock] [bit] NOT NULL CONSTRAINT [DF_LMLS_UserLock] DEFAULT ((0)),
[TimeStamp] [int] NULL,
[CompanyID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LMLS_COMPANYID] DEFAULT (''),
[ClientRef] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_LMLS_ACTIVE] DEFAULT ((1))
) ON [PRIMARY]
GO
CREATE TRIGGER [dbo].[tdLMLS_History] ON [dbo].[LMLS]
FOR DELETE
AS
BEGIN
UPDATE h
SET h.DeleteTime = GETDATE(),
h.LastUpdate = d.LastUpdate
FROM LMLS_History h
INNER JOIN deleted d ON d.LeaseID = h.LeaseID
END
GO
CREATE TRIGGER [dbo].[tiLMLS_History] ON [dbo].[LMLS]
FOR INSERT
AS
BEGIN
INSERT INTO LMLS_History(HistoryID, LeaseID, LeaseType, Feature, CreateTime, LastUpdate, IP, UniqueID, UserID, CompanyID)
SELECT LeaseID, LeaseID, LeaseType, Feature, CreateTime, LastUpdate, IP, UniqueID, UserID, CompanyID
FROM inserted
END
GO
ALTER TABLE [dbo].[LMLS] ADD CONSTRAINT [PK_LMLS] PRIMARY KEY CLUSTERED ([LeaseID]) ON [PRIMARY]
GO