diff options
| -rw-r--r-- | db/create.sql | 1 | ||||
| -rw-r--r-- | scripts/db_update-20151013.sql | 4 |
2 files changed, 5 insertions, 0 deletions
diff --git a/db/create.sql b/db/create.sql index 4abdb33..c0e95fa 100644 --- a/db/create.sql +++ b/db/create.sql @@ -34,6 +34,7 @@ create table codeq_user ( date_joined timestamp not null, last_login timestamp not null, gui_lang varchar(2), + robot_address varchar(30), constraint codeq_user_pk primary key (id), constraint codeq_user_uq1 unique (username) ); diff --git a/scripts/db_update-20151013.sql b/scripts/db_update-20151013.sql new file mode 100644 index 0000000..fd37e4c --- /dev/null +++ b/scripts/db_update-20151013.sql @@ -0,0 +1,4 @@ +alter table problem drop column name; +alter table language drop column name; +alter table problem_group drop column name; +alter table codeq_user add column robot_address varchar(30); |