39 lines
1.2 KiB
Transact-SQL
39 lines
1.2 KiB
Transact-SQL
CREATE TABLE [dbo].[TBEDMI_WEBPARSER_HISTORY](
|
|
[GUID] [int] IDENTITY(1,1) NOT NULL,
|
|
[REFERENCE_GUID] [varchar](250) NOT NULL,
|
|
[WEB_FILENAME] [varchar](250) NOT NULL,
|
|
[WEB_MAIL_ADRESS] [varchar](250) NOT NULL,
|
|
[WEB_LANGUAGE] [varchar](5) NOT NULL,
|
|
[PARSER_RESULT] [varchar](50) NOT NULL,
|
|
[XML_INVOICE_NUMBER] [varchar](50) NULL,
|
|
[XML_SELLER_TRADE_PARTY_NAME] [varchar](250) NULL,
|
|
[XML_SELLER_MAIL_ADRESS] [varchar](250) NULL,
|
|
[XML_SPECIFICATION] [varchar](50) NULL,
|
|
[XML_SCHEMA] [varchar](50) NULL,
|
|
[XML_FILE_TYPE] [varchar](10) NULL,
|
|
[ADDED_WHO] [varchar](50) NULL,
|
|
[ADDED_WHEN] [datetime] NULL,
|
|
[CHANGED_WHO] [varchar](50) NULL,
|
|
[CHANGED_WHEN] [datetime] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
CREATE OR ALTER TRIGGER [dbo].[TBEDMI_WEBPARSER_HISTORY_AFT_UPD] ON [dbo].[TBEDMI_WEBPARSER_HISTORY]
|
|
FOR UPDATE
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
UPDATE [TBEDMI_WEBPARSER_HISTORY]
|
|
SET [CHANGED_WHEN] = (sysdatetime())
|
|
FROM [INSERTED]
|
|
WHERE [TBEDMI_WEBPARSER_HISTORY].[GUID] = [INSERTED].[GUID];
|
|
|
|
END
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[TBEDMI_WEBPARSER_HISTORY] ADD CONSTRAINT [DF_TBEDMI_WEBPARSER_HISTORY_ADDED_WHEN] DEFAULT (getdate()) FOR [ADDED_WHEN]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[TBEDMI_WEBPARSER_HISTORY] ENABLE TRIGGER [TBEDMI_WEBPARSER_HISTORY_AFT_UPD]
|
|
GO |