918262 - [Remo] Update database tables for reps-dev.m.o

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Giorgos Logiotatidis [:giorgos]]

Attachment: remo.sql

Please run the attached sql on reps-dev.m.o

./manage.py dbshell < remo.sql

Comment 1

[Chris Turra [:cturra]]

complete as requested.

[[e-mail]1 remo]# ./manage.py dbshell < /home/cturra/remo.sql

[[e-mail]1 remo]# echo $?
0

Comment 2

[Giorgos Logiotatidis [:giorgos]]

Attachment: remo.sql

Works OK on dev. Can you please run the same queries on stage (reps.allizom.org) and prod (reps.mozilla.org)

Thanks!

Comment 3

[Giorgos Logiotatidis [:giorgos]]

Note that I did a minor update in the attached file.

Comment 4

[Chris Turra [:cturra]]

i have applied this change to stage. please confirm it looks as expected before we push this to prod:

[[e-mail]1 remo]# md5sum /home/cturra/remo.sql
d1ca0dddad88706b8f38321fc00bb5ab  /home/cturra/remo.sql

[[e-mail]1 remo]# ./manage.py dbshell < /home/cturra/remo.sql

[[e-mail]1 remo]# echo $?
0

Comment 5

[Giorgos Logiotatidis [:giorgos]]

Looks, OK. Let's push to prod!

Comment 6

[Chris Turra [:cturra]]

push to prod complete.

[[e-mail]1 remo]# ./manage.py dbshell < /home/cturra/remo.sql

[[e-mail]1 remo]# echo $?
0