DROP TABLE IF EXISTS assocs;
CREATE TABLE assocs (
  id int NOT NULL auto_increment,
  identity CHAR(255),
  handle CHAR(255),
  secret TINYTEXT, # http://sql-info.de/mysql/gotchas.html#1_6
  issued DATETIME,
  lifetime INT,
  PRIMARY KEY(id)
);