| 1 | use groupex; |
| 2 | alter table evenements add column accept_nonmembre tinyint(1) not null default 0; |
| 3 | alter table evenements add column archive tinyint(1) not null default 0; |
| 4 | |
| 5 | create table announces ( |
| 6 | id smallint(4) unsigned not null auto_increment, |
| 7 | user_id smallint(4) unsigned not null default 0, |
| 8 | asso_id smallint(4) unsigned not null default 0, |
| 9 | create_date timestamp(14) default null, |
| 10 | titre varchar(255) not null, |
| 11 | texte mediumtext not null, |
| 12 | contacts mediumtext not null, |
| 13 | peremption date not null default '0000-00-00', |
| 14 | promo_min smallint(4) unsigned not null default 0, |
| 15 | promo_max smallint(4) unsigned not null default 0, |
| 16 | flags set('public') not null default '', |
| 17 | |
| 18 | primary key (id) |
| 19 | ); |
| 20 | |
| 21 | create table announces_read ( |
| 22 | announce_id smallint(4) unsigned not null default 0, |
| 23 | user_id smallint(4) unsigned not null default 0, |
| 24 | primary key (announce_id, user_id) |
| 25 | ); |
| 26 | |
| 27 | use x4dat; |