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.

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)
 );