| 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 | |