[Devel] r355 - trunk

[svn AT agendadulibre.org]

Author: thomas
Date: Sun Jul 13 10:35:51 2008
New Revision: 355

Log:
Nouveau champ dans la table 'lugs', pour stocker le nom de la ville où
le GULL est situé.



Modified:
   trunk/UPGRADE
   trunk/schema.sql

Modified: trunk/UPGRADE
==============================================================================
--- trunk/UPGRADE       (original)
+++ trunk/UPGRADE       Sun Jul 13 10:35:51 2008
@@ -66,4 +66,12 @@
  ./extract-cities-coordinates.sh
  cat ville.sql | mysql -u user -p bdd
 
+Revisions lower than 354
+========================
 
+If you have an installation of the Agenda du Libre software of
+revision lower than 354 and you want to upgrade to a more recent
+version, then you must change the database schema. In order to do
+that, use the following SQL commands:
+
+ alter table lugs add city varchar(255) not null default '';

Modified: trunk/schema.sql
==============================================================================
--- trunk/schema.sql    (original)
+++ trunk/schema.sql    Sun Jul 13 10:35:51 2008
@@ -66,6 +66,7 @@
   department int(11) NOT NULL default '0',
   name varchar(255) NOT NULL default '',
   url varchar(255) NOT NULL default '',
+  city varchar(255) NOT NULL default '',
   PRIMARY KEY  (id)
 ) TYPE=MyISAM AUTO_INCREMENT=2 ;