xref: /plugin/struct/db/update0003.sql (revision 1edf6e46bf5ccbff2cab3b71d69ef4cf5f20a379)
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