Skip to content
Snippets Groups Projects
entry.sql 756 B
Newer Older
root's avatar
root committed
CREATE TYPE smartdata_v1.v1_1_si (
    value double,
    error tinyint,
    confidence tinyint,
    gw bigint
);

CREATE TYPE smartdata_v1.v1_1_digital (
    value blob,
    error tinyint,
    confidence tinyint,
    gw bigint
);

CREATE TYPE smartdata_v1.v1_1_si_blob (
    period int,
    gateway bigint,
    uncertainty int,
    data blob
);

root's avatar
root committed
CREATE TYPE smartdata_v1.v1_2_si (
    value double,
    error tinyint,
    confidence tinyint,
    x int,
    y int,
    z int,
    gw bigint
);

CREATE TYPE smartdata_v1.v1_2_digital (
    value blob,
    error tinyint,
    confidence tinyint,
    x int,
    y int,
    z int,
    gw bigint
);

CREATE TYPE smartdata_v1.v1_2_si_blob (
    period int,
    gateway bigint,
    uncertainty int,
    data blob
root's avatar
root committed
);