This is the ignition database format: ``` CREATE T...
# umh-support
j
This is the ignition database format:
Copy code
CREATE TABLE sqlth_1_data (
    [tagid] [int] NOT NULL,
    [intvalue] [bigint] NULL,
    [floatvalue] [float] NULL,
    [stringvalue] [nvarchar](255) NULL,
    [datevalue] [datetime] NULL,
    [dataintegrity] [int] NULL,
    [t_stamp] [bigint] NOT NULL DEFAULT 0,    -- string conversion from '19700101' is non-deterministic
    [partition] AS MONTH(DATEADD(DAY,t_stamp/(1000*3600*24),DATEFROMPARTS(1970,01,01))) PERSISTED,
    PRIMARY KEY CLUSTERED ([tagid] ASC, [partition], [t_stamp] ASC)
) ON PS_TAGHISTORY_BY_MONTH ([partition]);
Could be made compatible with UMH through a view