DROP TABLE IF EXISTS assocs;
CREATE TABLE assocs (
  id int NOT NULL auto_increment,
  url CHAR(255),
  handle CHAR(255),
  secret CHAR(255),
  issued DATETIME,
  expires_in INT,
  PRIMARY KEY(id)
);