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