mirror of
https://github.com/cosmocode/dokuwiki-plugin-struct.git
synced 2025-07-29 11:59:24 +00:00
706e7c4b4f
for columns that store multiple values (multi = true), we store a NULL in the data_* table and put all the values in the multivals table. The row column acts as a simple counter so values can be stored and retrieved in the correct order.
12 lines
307 B
SQL
12 lines
307 B
SQL
-- stores multi values for all tables, we might split this later into one multival
|
|
-- table per data table
|
|
CREATE TABLE multivals (
|
|
tbl NOT NULL,
|
|
colref INTEGER NOT NULL,
|
|
pid NOT NULL,
|
|
rev INTEGER NOT NULL,
|
|
row INTEGER NOT NULL,
|
|
value,
|
|
PRIMARY KEY(tbl, colref, pid, rev, row)
|
|
);
|