Update create.sql and add a migration script

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