819506 - please deploy persona 0.2012.12.07.1 to staging environment

Status: RESOLVED DUPLICATE of bug 819850

(Cloud Services :: Operations: Deployment Requests - DEPRECATED, task)

Description

[John Morrison [:jrgm]]

This is a preliminary request to deploy train-2012.12.07 to the staging environment, so gene can add the new table. The final sha is not yet determined.

I believe the sql to create the new table is 
https://github.com/mozilla/browserid/blob/dev/lib/db/mysql.js#L91

lloyd or ozten, can you confirm that is the final version?

  "CREATE TABLE IF NOT EXISTS idp (" +
  "id BIGINT AUTO_INCREMENT PRIMARY KEY," +
  "domain VARCHAR(255) UNIQUE NOT NULL," +
  "lastSeen TIMESTAMP DEFAULT 0 NOT NULL" +
  ") ENGINE=InnoDB;"

Comment 1

[John Morrison [:jrgm]]

ozten says that is the correct sql.

Comment 2

[Gene Wood [:gene]]

CREATE TABLE IF NOT EXISTS idp (id BIGINT AUTO_INCREMENT PRIMARY KEY,domain VARCHAR(255) UNIQUE NOT NULL,lastSeen TIMESTAMP DEFAULT 0 NOT NULL) ENGINE=InnoDB;

Comment 3

[Gene Wood [:gene]]

Ok, I've added the table to the master, this should replicate to the slaves :

# On db1.iddb.scl2.stage.svc.mozilla.com
echo "CREATE TABLE IF NOT EXISTS idp (id BIGINT AUTO_INCREMENT PRIMARY KEY,domain VARCHAR(255) UNIQUE NOT NULL,lastSeen TIMESTAMP DEFAULT 0 NOT NULL) ENGINE=InnoDB;" | sudo mysql browserid

Comment 4

[John Morrison [:jrgm]]

Closing this in favour of duplicate bug 819850, which has the commit sha for deployment on stage.