Skip to content

Instantly share code, notes, and snippets.

View langemeijer's full-sized avatar

Casper Langemeijer langemeijer

View GitHub Profile

Keybase proof

I hereby claim:

  • I am langemeijer on github.
  • I am langemeijer (https://keybase.io/langemeijer) on keybase.
  • I have a public key whose fingerprint is 4E0D D0F3 62E5 0A0A 1AC6 5E14 4A78 F29A 4F65 F4BA

To claim this, I am signing this object:

@langemeijer
langemeijer / fast-2_2-3_0.mysql
Created September 17, 2014 07:44
Faster upgrade from dbmail 2.2 to 3.0
-- This script fixes the 2.1 database schema for use with 3.0
-- Running this script will drop legacy caching tables,
-- so backup your database before continuing!
-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-- This is the same as the production 2_2-3_0.mysql script
-- EXCEPT: it does not change primary keys from BIGINT(21)'s to BIGINT(20) UNSIGNED
-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!