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