﻿
-- ebbe kerülnek majd a 2KB-nál nagyobb értékek (1 sec)
IF OBJECT_ID('dbo.T_ENTITYBLOBVALUES', 'U') IS NULL
    CREATE TABLE dbo.T_ENTITYBLOBVALUES(
        C_ENTITYATTRIBUTEHISTORYID INT NOT NULL,
        C_ORIGINALVALUE NVARCHAR(MAX) NULL,
        C_CURRENTVALUE NVARCHAR(MAX) NULL,
        CONSTRAINT PK_EntityBLOBValues PRIMARY KEY CLUSTERED (C_ENTITYATTRIBUTEHISTORYID),
        CONSTRAINT FK_EntityBLOBValues FOREIGN KEY (C_ENTITYATTRIBUTEHISTORYID) REFERENCES dbo.T_ENTITYATTRIBUTEHISTORY(ID)
    );

