125 lines
7.1 KiB
Transact-SQL
125 lines
7.1 KiB
Transact-SQL
UPDATE TBDD_MODULES SET DB_VERSION = '2.0.0.2' where UPPER(NAME) = UPPER('Clipboard-Watcher')
|
||
GO
|
||
DROP TABLE TBCW_PROF_REL_CONTROL
|
||
GO
|
||
CREATE TABLE TBCW_PROF_REL_CONTROL(
|
||
GUID INTEGER NOT NULL IDENTITY(1,1),
|
||
DESCRIPTION VARCHAR(250) NOT NULL,
|
||
WINDOW_ID INTEGER NOT NULL,
|
||
CONTROL_NAME VARCHAR(500) NOT NULL DEFAULT '',
|
||
[TOPLEFT_TOP] INTEGER NOT NULL DEFAULT 0,
|
||
[TOPLEFT_LEFT] INTEGER NOT NULL DEFAULT 0,
|
||
[TOPLEFT_RIGHT] INTEGER NOT NULL DEFAULT 0,
|
||
[TOPLEFT_BOTTOM] INTEGER NOT NULL DEFAULT 0,
|
||
[TOPRIGHT_TOP] INTEGER NOT NULL DEFAULT 0,
|
||
[TOPRIGHT_LEFT] INTEGER NOT NULL DEFAULT 0,
|
||
[TOPRIGHT_RIGHT] INTEGER NOT NULL DEFAULT 0,
|
||
[TOPRIGHT_BOTTOM] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMLEFT_TOP] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMLEFT_LEFT] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMLEFT_RIGHT] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMLEFT_BOTTOM] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMRIGHT_TOP] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMRIGHT_LEFT] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMRIGHT_RIGHT] INTEGER NOT NULL DEFAULT 0,
|
||
[BOTTOMRIGHT_BOTTOM] INTEGER NOT NULL DEFAULT 0,
|
||
SEQUENCE TINYINT NOT NULL DEFAULT 0,
|
||
ADDED_WHO VARCHAR(50) NOT NULL DEFAULT 'DEFAULT',
|
||
ADDED_WHEN DATETIME DEFAULT GETDATE(),
|
||
CHANGED_WHO VARCHAR(50),
|
||
CHANGED_WHEN DATETIME,
|
||
CONSTRAINT PK_TBCW_PROF_REL_CONTROL PRIMARY KEY (GUID),
|
||
CONSTRAINT FK_TBCW_PROF_REL_CONTROL_WINDOW_ID FOREIGN KEY (WINDOW_ID) REFERENCES TBCW_PROF_REL_WINDOW (GUID)
|
||
)
|
||
GO
|
||
CREATE TRIGGER TBCW_PROF_REL_CONTROL_AFT_UPD ON TBCW_PROF_REL_CONTROL
|
||
FOR UPDATE
|
||
AS
|
||
UPDATE TBCW_PROF_REL_CONTROL SET CHANGED_WHEN = GETDATE()
|
||
FROM INSERTED
|
||
WHERE TBCW_PROF_REL_CONTROL.GUID = INSERTED.GUID
|
||
GO
|
||
CREATE TRIGGER TBCW_PROF_REL_CONTROL_AFT_INS ON TBCW_PROF_REL_CONTROL
|
||
WITH EXECUTE AS CALLER
|
||
FOR INSERT
|
||
AS
|
||
BEGIN TRY
|
||
DECLARE @SEQUENCE TINYINT
|
||
,@MAX_SEQUENCE TINYINT
|
||
,@WINDOW_ID INT
|
||
,@GUID INTEGER
|
||
SELECT @SEQUENCE = SEQUENCE
|
||
,@WINDOW_ID = WINDOW_ID
|
||
,@GUID = GUID FROM inserted
|
||
|
||
SELECT @MAX_SEQUENCE = ISNULL(MAX(SEQUENCE),0) FROM TBCW_PROF_REL_CONTROL WHERE WINDOW_ID = @WINDOW_ID AND GUID <> @GUID
|
||
UPDATE TBCW_PROF_REL_CONTROL SET SEQUENCE = @MAX_SEQUENCE
|
||
FROM INSERTED
|
||
WHERE TBCW_PROF_REL_CONTROL.GUID = INSERTED.GUID
|
||
END TRY
|
||
BEGIN CATCH
|
||
PRINT 'ERROR IN PROCEDURE: ' + CONVERT(VARCHAR(30),ERROR_PROCEDURE())
|
||
+ ' - ERROR-MESSAGE: '
|
||
+ CONVERT(VARCHAR(500),ERROR_MESSAGE())
|
||
END CATCH
|
||
GO
|
||
|
||
ALTER VIEW [dbo].[VWCW_PROFILE_REL_WINDOW] AS
|
||
SELECT DISTINCT TOP 100 PERCENT
|
||
T.GUID
|
||
,T.PROCESS_ID
|
||
,T2.USER_ID
|
||
,T1.PROC_NAME AS PROCESS_NAME
|
||
,T1.PROFILE_ID
|
||
,T.DESCRIPTION
|
||
,T.REGEX
|
||
,T.SEQUENCE
|
||
FROM
|
||
TBCW_PROF_REL_WINDOW T
|
||
,TBCW_PROFILE_PROCESS T1
|
||
,VWCW_USER_PROFILE T2
|
||
WHERE
|
||
T.PROCESS_ID = T1.GUID AND
|
||
T1.PROFILE_ID = T2.GUID
|
||
|
||
ORDER BY T.SEQUENCE
|
||
GO
|
||
|
||
ALTER VIEW [dbo].[VWCW_PROFILE_REL_CONTROL] AS
|
||
SELECT DISTINCT TOP 100 PERCENT
|
||
T.GUID
|
||
,T1.USER_ID
|
||
,TP.PROC_NAME AS PROCESS_NAME
|
||
,T1.GUID AS PROFILE_ID
|
||
,T.WINDOW_ID
|
||
,T.DESCRIPTION
|
||
,T.SEQUENCE
|
||
,T.TOPLEFT_LEFT
|
||
,T.TOPLEFT_RIGHT
|
||
,T.TOPLEFT_TOP
|
||
,T.TOPLEFT_BOTTOM
|
||
,T.TOPRIGHT_LEFT
|
||
,T.TOPRIGHT_RIGHT
|
||
,T.TOPRIGHT_TOP
|
||
,T.TOPRIGHT_BOTTOM
|
||
,T.BOTTOMLEFT_LEFT
|
||
,T.BOTTOMLEFT_RIGHT
|
||
,T.BOTTOMLEFT_TOP
|
||
,T.BOTTOMLEFT_BOTTOM
|
||
,T.BOTTOMRIGHT_LEFT
|
||
,T.BOTTOMRIGHT_RIGHT
|
||
,T.BOTTOMRIGHT_TOP
|
||
,T.BOTTOMRIGHT_BOTTOM
|
||
FROM
|
||
TBCW_PROF_REL_CONTROL T
|
||
,TBCW_PROF_REL_WINDOW TW
|
||
,TBCW_PROFILE_PROCESS TP
|
||
,VWCW_USER_PROFILE T1
|
||
WHERE
|
||
T.WINDOW_ID = TW.GUID AND
|
||
TW.PROCESS_ID = TP.GUID AND
|
||
TP.PROFILE_ID = T1.GUID
|
||
ORDER BY T.SEQUENCE
|
||
GO
|
||
|