upgrade/0.9.13/04_axletter.sql

   1 CREATE TABLE axletter (
   2     id int(11) unsigned NOT NULL auto_increment,
   3     shortname varchar(16) default NULL default '',
   4     subject varchar(255) NOT NULL default '',
   5     title varchar(255) NOT NULL default '',
   6     body mediumtext NOT NULL default '',
   7     signature mediumtext NOT NULL default '',
   8     promo_min smallint(4) NOT NULL default 0,
   9     promo_max smallint(4) NOT NULL default 0,
  10     echeance datetime NOT NULL default 0,
  11     date date NOT NULL default 0,
  12     bits set('new', 'sent', 'invalid') NOT NULL default 'new',
  13
  14     PRIMARY KEY(id),
  15     UNIQUE KEY(shortname)
  16 );
  17 CREATE TABLE axletter_ins (
  18     user_id smallint(4) NOT NULL default 0,
  19     email varchar(255) default NULL,
  20     flag set('femme') default '',
  21     prenom varchar(32) default NULL,
  22     nom varchar(255) default NULL,
  23     promo smallint(4) default 0,
  24     last int(11) NOT NULL default 0,
  25     hash varchar(32) default NULL,
  26
  27     PRIMARY KEY(user_id, email),
  28     KEY(last)
  29 );
  30 CREATE TABLE axletter_rights (
  31     user_id smallint(4) NOT NULL default 0,
  32     PRIMARY KEY(user_id)
  33 );
  34 # vim:set syntax=mysql: