[platal.git] / upgrade / 0.9.1 / newsleter_cat.sql

-- -----------------------------------------------------------------------------
-- newsletter categories
--
create table newsletter_cat (
    cid tinyint unsigned not null auto_increment,
    pos tinyint unsigned not null,
    titre varchar(128) not null,
    PRIMARY KEY (cid),
    INDEX (pos)
);
insert into newsletter_cat values(1,1,'Flash Info');
insert into newsletter_cat values(2,2,'Communications institutionnelles');
insert into newsletter_cat values(3,3,'Groupes X');
insert into newsletter_cat values(4,4,'Activit�s polytechniciennes');
--
-- -----------------------------------------------------------------------------
Commit	Line	Data
0337d704	1	-- -----------------------------------------------------------------------------
	2	-- newsletter categories
	3	--
	4	create table newsletter_cat (
	5	cid tinyint unsigned not null auto_increment,
	6	pos tinyint unsigned not null,
	7	titre varchar(128) not null,
	8	PRIMARY KEY (cid),
	9	INDEX (pos)
	10	);
	11	insert into newsletter_cat values(1,1,'Flash Info');
	12	insert into newsletter_cat values(2,2,'Communications institutionnelles');
	13	insert into newsletter_cat values(3,3,'Groupes X');
	14	insert into newsletter_cat values(4,4,'Activit�s polytechniciennes');
	15	--
	16	-- -----------------------------------------------------------------------------