Commit | Line | Data |
---|---|---|
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, | |
9 | state set('active') not null default 'active', | |
10 | ||
11 | primary key (id) | |
12 | ); | |
13 | ||
14 | # vim:set syntax=mysql: |