1340255 - Deploy Splice 2.1.25 to stage

Status: RESOLVED FIXED

(Firefox :: New Tab Page, defect)

Description

[Nan Jiang [:nanj]]

This deploy fixes some issues that we've found in 2.1.24, i.e.

1) Renamed the "raw" field to "raw_ping" to avoid keyword collision
2) Added a new filed "release_channel" to a-s mobiles tables

Note that it didn't create a new database migration, instead, it modified the DDL sql file in place. So there is *no* need to run "manage.py db upgrade" in stage after the deploy. Please just execute the "ddl/migrations/redshift/1487106710.sql" (it'll drop the existing tables in stage first), and grant the permissions listed below. 

To all those new tables, please grant the write permission for "infernyx", and the read permission for "read_only".

Thank you!

Comment 1

[Jon Buckley [:jbuck]]

Deployed successfully to stage. Migrations run:

$ psql < ddl/migrations/redshift/1487106710.sql
BEGIN
DROP TABLE
DROP TABLE
DROP TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
COMMIT
$ psql
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only;
GRANT
tiles=> GRANT INSERT ON ALL TABLES IN SCHEMA public TO infernyx;
GRANT