[Devel] r148 - trunk

[thomas at lolut.utbm.info]

Author: thomas
Date: 2006-02-05 14:50:38 +0100 (Sun, 05 Feb 2006)
New Revision: 148

Modified:
   trunk/schema.sql
Log:
Ajout de la table lugs dans le schema SQL.

Modified: trunk/schema.sql
===================================================================
--- trunk/schema.sql	2006-02-05 13:42:09 UTC (rev 147)
+++ trunk/schema.sql	2006-02-05 13:50:38 UTC (rev 148)
@@ -54,3 +54,12 @@
   `email` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM;
+
+CREATE TABLE lugs (
+  id int(11) NOT NULL auto_increment,
+  region int(11) NOT NULL default '0',
+  department int(11) NOT NULL default '0',
+  name varchar(255) NOT NULL default '',
+  url varchar(255) NOT NULL default '',
+  PRIMARY KEY  (id)
+) TYPE=MyISAM AUTO_INCREMENT=2 ;