0337d704 |
1 | ALTER TABLE virtual CHANGE `type` `type` ENUM('user', 'list', 'dom', 'evt') DEFAULT 'user' NOT NULL; |
2 | |
3 | ALTER TABLE groupex.asso ADD `pub` ENUM( 'public', 'private' ) DEFAULT 'public' NOT NULL AFTER `ax` ; |
4 | INSERT INTO virtual_domains VALUES ('evts.polytechnique.org'); |
5 | |
6 | use groupex; |
7 | |
8 | DROP TABLE IF EXISTS groupex.evenements; |
9 | CREATE TABLE groupex.evenements ( |
10 | `eid` int unsigned NOT NULL auto_increment, |
11 | `asso_id` int unsigned NOT NULL default '0', |
12 | `organisateur_uid` int unsigned NOT NULL default '0', |
13 | `intitule` varchar(100) NOT NULL default '', |
14 | `short_name` varchar(30) NOT NULL default '', |
15 | `paiement_id` int unsigned default NULL, |
16 | `descriptif` text NOT NULL, |
17 | `debut` datetime NOT NULL default '0000-00-00 00:00:00', |
18 | `fin` datetime default NULL, |
19 | `membres_only` tinyint(1) NOT NULL default '0', |
20 | `advertise` tinyint(1) NOT NULL default '0', |
21 | `show_participants` tinyint(1) NOT NULL default '0', |
22 | PRIMARY KEY (`eid`) |
23 | ); |
24 | |
25 | drop table IF EXISTS evenements_items; |
26 | CREATE TABLE evenements_items ( |
27 | `eid` int unsigned NOT NULL default '0', |
28 | `item_id` int unsigned NOT NULL default '0', |
29 | `titre` varchar(100) NOT NULL default '', |
30 | `details` text NOT NULL, |
31 | `montant` decimal(10,2) NOT NULL default '0.00', |
32 | PRIMARY KEY (`eid`,`item_id`) |
33 | ); |
34 | |
35 | drop table IF EXISTS evenements_participants; |
36 | CREATE TABLE evenements_participants ( |
37 | `eid` int unsigned NOT NULL default '0', |
38 | `uid` int unsigned NOT NULL default '0', |
39 | `item_id` int NOT NULL default '0', |
40 | `nb` int NOT NULL default '0', |
41 | `paid` float NOT NULL default '0', |
42 | PRIMARY KEY (`eid`,`item_id`,`uid`) |
43 | ); |
44 | |