From 441bca2319f66a7fd79f350e45fdc5f018e9f2e7 Mon Sep 17 00:00:00 2001 From: Timotej Lazar Date: Sun, 28 Feb 2016 15:52:09 +0100 Subject: 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. --- db/create.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'db') 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) ); -- cgit v1.2.1