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 '',
  `moderated` int(11) NOT NULL default '0',
  `tags` 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',
  `moderator_mail_id` varchar(32) default NULL,
  `submitter_mail_id` varchar(32) default NULL,
  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 '',
  city varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

CREATE TABLE `cities` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `majname` varchar(255) NOT NULL default '',
  `postalcode` int(11) default NULL,
  `inseecode` int(11) default NULL,
  `regioncode` int(11) default NULL,
  `latitude` float default NULL,
  `longitude` float default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `notes` (
  `id` int(11) NOT NULL auto_increment,
  `contents` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `event_id` int(11) default NULL,
  `author_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;