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