SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- --------------------------------------------------------

--
-- Structure de la table `icibackup`
--

CREATE TABLE IF NOT EXISTS `icibackup` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `postal_code` varchar(5) NOT NULL DEFAULT '0',
  `relay_id` varchar(8) NOT NULL DEFAULT '',
  `sort_order` int(2) DEFAULT NULL,
  `distance` bigint(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28575 ;

-- --------------------------------------------------------

--
-- Structure de la table `icirelais`
--

CREATE TABLE IF NOT EXISTS `icirelais` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `file_id` int(8) unsigned NOT NULL,
  `relay_id` varchar(8) NOT NULL DEFAULT '',
  `insee` varchar(5) DEFAULT NULL,
  `owner_name` varchar(40) DEFAULT NULL,
  `adresse_1` varchar(40) DEFAULT NULL,
  `adresse_2` varchar(40) DEFAULT NULL,
  `adresse_3` varchar(40) DEFAULT NULL,
  `postal_code` varchar(5) NOT NULL DEFAULT '0',
  `city` varchar(30) NOT NULL,
  `shop_name` varchar(50) DEFAULT NULL,
  `coord_lat` double DEFAULT NULL,
  `coord_long` double DEFAULT NULL,
  `pda_equipment` varchar(1) DEFAULT NULL,
  `start_validity_date` varchar(10) DEFAULT NULL,
  `end_validity_date` varchar(10) DEFAULT NULL,
  `last_shippment_date` varchar(10) DEFAULT NULL,
  `new_shippment_date` varchar(10) DEFAULT NULL,
  `text` varchar(40) DEFAULT NULL,
  `monday_opening_hours` varchar(23) DEFAULT NULL,
  `tuesday_opening_hours` varchar(23) DEFAULT NULL,
  `wednesday_opening_hours` varchar(23) DEFAULT NULL,
  `thursday_opening_hours` varchar(23) DEFAULT NULL,
  `friday_opening_hours` varchar(23) DEFAULT NULL,
  `saturday_opening_hours` varchar(23) DEFAULT NULL,
  `sunday_opening_hours` varchar(23) DEFAULT NULL,
  `closing_period_start_date_1` varchar(10) DEFAULT NULL,
  `closing_period_end_date_1` varchar(10) DEFAULT NULL,
  `closing_period_start_date_2` varchar(10) DEFAULT NULL,
  `closing_period_end_date_2` varchar(10) DEFAULT NULL,
  `closing_period_start_date_3` varchar(10) DEFAULT NULL,
  `closing_period_end_date_3` varchar(10) DEFAULT NULL,
  `required_time` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3026 ;