X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.12%2F01_xnet.sql;h=28fd09d80240d12276522613307b6a09613936a7;hb=9a13e83f4b39c7feaba924b724fd43497109481b;hp=81b87e04efd78fb697048676140c610300ec58bf;hpb=062e5f97a730e126a1c623ddbc297b4bd91f7a15;p=platal.git

diff --git a/upgrade/0.9.12/01_xnet.sql b/upgrade/0.9.12/01_xnet.sql
index 81b87e0..28fd09d 100644
--- a/upgrade/0.9.12/01_xnet.sql
+++ b/upgrade/0.9.12/01_xnet.sql
@@ -1,3 +1,27 @@
 use groupex;
-alter table evenements add accept_nonmembre tinyint(1) default 0;
+alter table evenements add column accept_nonmembre tinyint(1) not null default 0;
+alter table evenements add column archive tinyint(1) not null default 0;
+
+create table announces (
+    id smallint(4) unsigned not null auto_increment,
+    user_id smallint(4) unsigned not null default 0,
+    asso_id smallint(4) unsigned not null default 0,
+    create_date timestamp(14) default null,
+    titre varchar(255) not null,
+    texte mediumtext not null,
+    contacts mediumtext not null,
+    peremption date not null default '0000-00-00',
+    promo_min smallint(4) unsigned not null default 0,
+    promo_max smallint(4) unsigned not null default 0,
+    flags set('public') not null default '',
+
+    primary key (id)
+);
+
+create table announces_read (
+    announce_id smallint(4) unsigned not null default 0,
+    user_id smallint(4) unsigned not null default 0,
+    primary key (announce_id, user_id)
+);
+
 use x4dat;