From 9203276ce88b584a41b40e2583e815d928f35645 Mon Sep 17 00:00:00 2001 From: Timotej Lazar Date: Tue, 13 Oct 2015 16:05:14 +0200 Subject: Update create.sql and add a migration script --- db/create.sql | 1 + scripts/db_update-20151013.sql | 4 ++++ 2 files changed, 5 insertions(+) create mode 100644 scripts/db_update-20151013.sql 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); -- cgit v1.2.1