062e5f97 |
1 | use groupex; |
f02eefd4 |
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; |
24bcf50c |
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 | |
062e5f97 |
27 | use x4dat; |