Commit | Line | Data |
---|---|---|
dc767839 | 1 | create table tips ( |
2 | id smallint(4) unsigned not null auto_increment, | |
3 | titre varchar(64) not null, | |
4 | text mediumtext not null, | |
5 | priorite tinyint(2) unsigned not null default 127, | |
6 | peremption date not null default '0000-00-00', | |
7 | promo_min smallint(4) unsigned not null default 0, | |
8 | promo_max smallint(4) unsigned not null default 0, | |
9fc2d0d2 | 9 | state set('active') not null default 'active', |
dc767839 | 10 | |
11 | primary key (id) | |
12 | ); | |
13 | ||
14 | # vim:set syntax=mysql: |