summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorTimotej Lazar <timotej.lazar@fri.uni-lj.si>2016-02-28 15:52:09 +0100
committerTimotej Lazar <timotej.lazar@fri.uni-lj.si>2016-02-28 16:01:00 +0100
commit441bca2319f66a7fd79f350e45fdc5f018e9f2e7 (patch)
treec4369deb2d68bc2684e64515a7026f49c0b14191 /db
parent3072efb05b460f8edcf1d9187a92e98e513ca421 (diff)
Add experiments column to codeq_user
This JSON column holds an array of experiment objects, for example: [{'id': 'prolog_hints', 'group': 'manual_hints'}]. To include users in an experiment, just add appropriate objects to their records. Not the cleanest design from the DB point of view, but enough for the single current use case.
Diffstat (limited to 'db')
-rw-r--r--db/create.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/create.sql b/db/create.sql
index 5d2af79..43d275e 100644
--- a/db/create.sql
+++ b/db/create.sql
@@ -52,6 +52,7 @@ create table codeq_user (
gui_lang varchar(2),
robot_address varchar(30),
gui_layout varchar(30),
+ experiments jsonb,
constraint codeq_user_pk primary key (id),
constraint codeq_user_uq1 unique (username)
);