4c144957bcddc98ce6f1afb31238b37dc076a186
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',
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 last int(11) NOT NULL default 0,
24 hash
varchar(32) default NULL,
26 PRIMARY KEY(user_id
, email
),
29 CREATE TABLE axletter_rights (
30 user_id
smallint(4) NOT NULL default 0,
33 # vim
:set syntax
=mysql
: