upgrade/0.9.12/01_xnet.sql

   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;