[platal.git] / upgrade / 0.9.13 / 01_tips.sql

create table tips (
    id smallint(4) unsigned not null auto_increment,
    titre varchar(64) not null,
    text mediumtext not null,
    priorite tinyint(2) unsigned not null default 127,
    peremption date not null default '0000-00-00',
    promo_min smallint(4) unsigned not null default 0,
    promo_max smallint(4) unsigned not null default 0,

    primary key (id)
);

# vim:set syntax=mysql:
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,
	9
	10	primary key (id)
	11	);
	12
	13	# vim:set syntax=mysql: