upgrade/0.9.13/01_tips.sql

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