28fd09d80240d12276522613307b6a09613936a7
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;
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 '',
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
)