X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.12%2F01_xnet.sql;h=28fd09d80240d12276522613307b6a09613936a7;hb=9db0a440bf858bced7bd14064a9197adca66b2e6;hp=62cf0759fe63e15465a2e35cccd9c23d0ecd5972;hpb=f02eefd4d0eabc353e9020150c4692b70450c54e;p=platal.git

diff --git a/upgrade/0.9.12/01_xnet.sql b/upgrade/0.9.12/01_xnet.sql
index 62cf075..28fd09d 100644
--- a/upgrade/0.9.12/01_xnet.sql
+++ b/upgrade/0.9.12/01_xnet.sql
@@ -1,4 +1,27 @@
 use groupex;
 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;