8da0d3c1 |
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, |
4e25428d |
23 | promo smallint(4) default 0, |
8da0d3c1 |
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: |