upgrade/0.9.1/newsleter_cat.sql

   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 -- -----------------------------------------------------------------------------