[Devel] r430 - branches/dui

[svn AT agendadulibre.org]

Author: ldayot
Date: Sun Mar  1 18:40:26 2009
New Revision: 430

Log:
Ajout de champs pour adresse et geolocalisation des evenements et des lugs.

Modified:
   branches/dui/UPGRADE
   branches/dui/schema.sql

Modified: branches/dui/UPGRADE
==============================================================================
--- branches/dui/UPGRADE        Sun Mar  1 18:39:36 2009        (r429)
+++ branches/dui/UPGRADE        Sun Mar  1 18:40:26 2009        (r430)
@@ -156,7 +156,7 @@
 Revisions lower than 412 - 2008-12-07
 =====================================
 
-# Add coordonates tu lugs and events
+# Add coordonates to lugs and events
 # and more informations on lugs
 
 ALTER TABLE `lugs` ADD `address` VARCHAR( 255 ) NULL ,
@@ -176,3 +176,12 @@
 ALTER TABLE `events` ADD `address` VARCHAR( 255 ) NULL AFTER `end_time` ;
 ALTER TABLE `events` ADD `department` INT NULL AFTER `city` ;
 ALTER TABLE `events` ADD INDEX ( `department` ) ;
+
+Revision lower than 416 - 2009-01-04
+=====================================
+
+# Add coordonates to events
+
+ALTER TABLE `events` ADD `postalcode` INT NULL AFTER `region` ,
+ADD `latitude` FLOAT NULL AFTER `postalcode` ,
+ADD `longitude` FLOAT NULL AFTER `latitude` ;

Modified: branches/dui/schema.sql
==============================================================================
--- branches/dui/schema.sql     Sun Mar  1 18:39:36 2009        (r429)
+++ branches/dui/schema.sql     Sun Mar  1 18:40:26 2009        (r430)
@@ -1,28 +1,31 @@
-CREATE TABLE `events` (
+CREATE TABLE IF NOT EXISTS `events` (
   `id` int(11) NOT NULL auto_increment,
   `title` varchar(255) NOT NULL default '',
   `description` text NOT NULL,
   `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
   `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `address` VARCHAR( 255 ) NULL,
+  `address` varchar(255) default NULL,
   `city` varchar(255) NOT NULL default '',
-  `department` INT NULL,
+  `department` int(11) default NULL,
   `region` int(11) NOT NULL default '0',
+  `postalcode` int(11) default NULL,
+  `latitude` float default NULL,
+  `longitude` float default NULL,
   `locality` int(11) NOT NULL default '0',
   `url` varchar(255) NOT NULL default '',
   `contact` varchar(255) NOT NULL default '',
   `submitter` varchar(255) NOT NULL default '',
-  `secret` varchar(255) NOT NULL default '',
-  `decision_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
-  `submission_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `moderated` int(11) NOT NULL default '0',
+  `secret` varchar(255) NOT NULL default '',
+  `decision_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `submission_time` datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`id`),
-  INDEX (`region`),
-  INDEX (`department`),
-  INDEX (`moderated`),
-  INDEX (`start_time`),
-  INDEX (`end_time`)
-) TYPE=MyISAM;
+  KEY `start_time` (`start_time`),
+  KEY `region` (`region`),
+  KEY `moderated` (`moderated`),
+  KEY `department` (`department`),
+  KEY `end_time` (`end_time`)
+) TYPE=MyISAM CHARSET=utf8;
 
 CREATE TABLE `regions` (
   `id` int(11) NOT NULL auto_increment,
@@ -77,13 +80,13 @@
   `url` varchar(255) NOT NULL default '',
   `city` varchar(255) NOT NULL default '',
   `address` varchar(255) default NULL,
+  `latitude` float default NULL,
+  `longitude` float default NULL,
+  `postalcode` int(11) default NULL,
   `contact` varchar(255) default NULL,
   `phone` varchar(255) default NULL,
   `mail` varchar(255) default NULL,
   `comment` text,
-  `latitude` float default NULL,
-  `longitude` float default NULL,
-  `postalcode` int(11) default NULL,
   PRIMARY KEY  (`id`),
   KEY `region` (`region`),
   KEY `department` (`department`)