Tables [dbo].[LMLS]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)2
Created11:24:30 AM Wednesday, May 9, 2018
Last Modified11:24:51 AM Wednesday, May 9, 2018
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_LMLS: LeaseIDLeaseIDint4
False
1 - 1
LeaseTypevarchar(32)32
True
Featureint4
False
CreateTimedatetime8
False
(getdate())
ExpireTimedatetime8
True
LastUpdatedatetime8
False
(getdate())
IPvarchar(64)64
True
UniqueIDvarchar(4096)4096
False
UserIDvarchar(32)32
False
UserLockbit1
False
((0))
TimeStampint4
True
CompanyIDvarchar(255)255
False
('')
ClientRefvarchar(512)512
True
Activebit1
False
((1))
KeyNameKey ColumnsUnique
Cluster Primary Key PK_LMLS: LeaseIDPK_LMLSLeaseID
True
NameANSI Nulls OnQuoted Identifier OnOn
tdLMLS_History
True
True
After Delete
tiLMLS_History
True
True
After Insert
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
  • [dbo].[Co_GetConnectionInfo_User]
  • [dbo].[Co_KillConnections_User]