CREATE TABLE `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',
  `city` varchar(255) NOT NULL default '',
  `region` int(11) NOT NULL default '0',
  `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 '',
  `tags` varchar(255) NOT NULL default '',
  `moderated` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `regions` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

INSERT INTO `regions` VALUES (1,'Alsace');
INSERT INTO `regions` VALUES (2,'Aquitaine');
INSERT INTO `regions` VALUES (3,'Auvergne');
INSERT INTO `regions` VALUES (4,'Basse-Normandie');
INSERT INTO `regions` VALUES (5,'Bourgogne');
INSERT INTO `regions` VALUES (6,'Bretagne');
INSERT INTO `regions` VALUES (7,'Centre');
INSERT INTO `regions` VALUES (8,'Champagne-Ardenne');
INSERT INTO `regions` VALUES (9,'Corse');
INSERT INTO `regions` VALUES (10,'Franche-Comté');
INSERT INTO `regions` VALUES (11,'Haute-Normandie');
INSERT INTO `regions` VALUES (12,'Île-de-France');
INSERT INTO `regions` VALUES (13,'Languedoc-Roussillon');
INSERT INTO `regions` VALUES (14,'Limousin');
INSERT INTO `regions` VALUES (15,'Lorraine');
INSERT INTO `regions` VALUES (16,'Midi-Pyrénées');
INSERT INTO `regions` VALUES (17,'Nord-Pas-de-Calais');
INSERT INTO `regions` VALUES (18,'Pays de la Loire');
INSERT INTO `regions` VALUES (19,'Picardie');
INSERT INTO `regions` VALUES (20,'Poitou-Charentes');
INSERT INTO `regions` VALUES (21,'Provence-Alpes-Côte d\'Azur');
INSERT INTO `regions` VALUES (22,'Rhône-Alpes');
INSERT INTO `regions` VALUES (23,'Guadeloupe');
INSERT INTO `regions` VALUES (24,'Guyane');
INSERT INTO `regions` VALUES (25,'Martinique');
INSERT INTO `regions` VALUES (26,'Réunion');
INSERT INTO `regions` VALUES (27,'Autre pays');

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `firstname` varchar(255) NOT NULL default '',
  `lastname` 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 ;