xref: /plugin/struct/db/update0003.sql (revision b33b89f494aeb1cd28e95a567fd71ca645f9d483)
1-- stores multi values for all tables, we might split this later into one multival
2-- table per data table
3CREATE TABLE multivals (
4    tbl NOT NULL,
5    colref INTEGER NOT NULL,
6    pid NOT NULL,
7    rev INTEGER NOT NULL,
8    row INTEGER NOT NULL,
9    value,
10    PRIMARY KEY(tbl, colref, pid, rev, row)
11);
12