-- https://www.phpmyadmin.net/
--
-- Hôte : nj151-003.eu.clouddb.ovh.net:35649
-- Généré le : dim. 29 juin 2025 à 14:56
-- Version du serveur : 8.0.41-32
-- Version de PHP : 8.1.32

START TRANSACTION;



--
-- Base de données : `aef`
--

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

--
-- Structure de la table `alert`
--

CREATE TABLE `alert` (
  `id` int NOT NULL,
  `profile_id` int DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `keyword` varchar(128) DEFAULT NULL,
  `keyword_culture` varchar(5) DEFAULT 'fr_FR',
  `item_category_id` int DEFAULT NULL,
  `item_style_id` int DEFAULT NULL,
  `item_period_id` int DEFAULT NULL,
  `item_material_id` int DEFAULT NULL,
  `item_origin_id` int DEFAULT NULL,
  `is_active` tinyint DEFAULT '1',
  `frequency` varchar(128) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Structure de la table `annonce`
--

CREATE TABLE `annonce` (
  `id` int NOT NULL,
  `geo_region_id` int DEFAULT NULL,
  `annonce_category_id` int DEFAULT NULL,
  `annonce_cible_id` int DEFAULT NULL,
  `annonce_source_id` int DEFAULT NULL,
  `profile_id` int DEFAULT NULL,
  `member_id` int DEFAULT NULL,
  `member_group_id` int DEFAULT NULL,
  `syndic_id` int DEFAULT NULL,
  `fair_owner_id` int DEFAULT NULL,
  `picture` varchar(255) NOT NULL,
  `published` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `expires_at` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `annonce_category`
--

CREATE TABLE `annonce_category` (
  `id` int NOT NULL,
  `category` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `annonce_cible`
--

CREATE TABLE `annonce_cible` (
  `id` int NOT NULL,
  `cible` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `annonce_i18n`
--

CREATE TABLE `annonce_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `annonce_image`
--

CREATE TABLE `annonce_image` (
  `id` int NOT NULL,
  `annonce_id` int NOT NULL DEFAULT '1',
  `is_default` tinyint DEFAULT '0',
  `filename` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `annonce_source`
--

CREATE TABLE `annonce_source` (
  `id` int NOT NULL,
  `source` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `command`
--

CREATE TABLE `command` (
  `id` int NOT NULL,
  `profile_id` int NOT NULL,
  `member_id` int NOT NULL,
  `shipping_type_id` int NOT NULL,
  `buyer_email` varchar(128) NOT NULL,
  `buyer_phone` varchar(32) DEFAULT NULL,
  `shipping_name` varchar(128) NOT NULL,
  `shipping_address1` varchar(128) NOT NULL,
  `shipping_address2` varchar(128) NOT NULL,
  `shipping_zip` varchar(128) NOT NULL,
  `shipping_city` varchar(128) NOT NULL,
  `shipping_state` varchar(128) NOT NULL,
  `shipping_country` varchar(128) NOT NULL,
  `member_email` varchar(128) NOT NULL,
  `member_phone` varchar(32) DEFAULT NULL,
  `member_rcs` varchar(128) NOT NULL,
  `member_society` varchar(128) NOT NULL,
  `member_address` varchar(128) NOT NULL,
  `member_zip` varchar(128) NOT NULL,
  `member_city` varchar(128) NOT NULL,
  `member_country` varchar(128) NOT NULL,
  `item_id` varchar(128) NOT NULL,
  `item_title` varchar(128) NOT NULL,
  `item_amount` varchar(128) NOT NULL,
  `shipping_amount` varchar(128) NOT NULL,
  `remise_amount` varchar(128) NOT NULL,
  `payment_status` varchar(64) NOT NULL,
  `shipping_status` varchar(64) NOT NULL,
  `selling_status` varchar(128) NOT NULL,
  `key` varchar(128) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `expense`
--

CREATE TABLE `expense` (
  `id` int NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `reference_at` date DEFAULT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `amount_ht` float DEFAULT NULL,
  `amount_tva` float DEFAULT NULL,
  `amount_ttc` float DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `fair`
--

CREATE TABLE `fair` (
  `id` int NOT NULL,
  `profile_id` int DEFAULT NULL,
  `highlighted` tinyint DEFAULT '0',
  `geo_country_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_departement_id` int NOT NULL,
  `geo_city_id` int NOT NULL,
  `fair_frequency_id` int NOT NULL,
  `fair_type_id` int NOT NULL,
  `fair_owner_id` int DEFAULT NULL,
  `mag_id` int DEFAULT NULL,
  `sncao` tinyint DEFAULT '0',
  `date_begin` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `confirm_key` varchar(255) DEFAULT NULL,
  `valid` tinyint DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `fair_frequency`
--

CREATE TABLE `fair_frequency` (
  `id` int NOT NULL,
  `frequency` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `fair_i18n`
--

CREATE TABLE `fair_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `date_text` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `content` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `fair_owner`
--

CREATE TABLE `fair_owner` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `geo_city_id` int NOT NULL,
  `geo_district_id` int NOT NULL,
  `geo_departement_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `gsm` varchar(15) DEFAULT NULL,
  `url` varchar(128) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `fair_owner_i18n`
--

CREATE TABLE `fair_owner_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(128) DEFAULT NULL,
  `baseline` varchar(255) DEFAULT NULL,
  `content` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `fair_type`
--

CREATE TABLE `fair_type` (
  `id` int NOT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `fair_type_i18n`
--

CREATE TABLE `fair_type_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `type` varchar(64) DEFAULT NULL,
  `normalized_type` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_city`
--

CREATE TABLE `geo_city` (
  `id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_departement_id` int NOT NULL,
  `geo_district_id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `cp` varchar(10) DEFAULT NULL,
  `insee` varchar(64) DEFAULT NULL,
  `lgt` varchar(32) DEFAULT NULL,
  `lat` varchar(32) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_city_i18n`
--

CREATE TABLE `geo_city_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `city` varchar(64) NOT NULL,
  `normalized_city` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_country`
--

CREATE TABLE `geo_country` (
  `id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_country_i18n`
--

CREATE TABLE `geo_country_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `country` varchar(100) DEFAULT NULL,
  `normalized_country` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_departement`
--

CREATE TABLE `geo_departement` (
  `id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `insee` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_departement_i18n`
--

CREATE TABLE `geo_departement_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `departement` varchar(64) NOT NULL,
  `normalized_departement` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_district`
--

CREATE TABLE `geo_district` (
  `id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_departement_id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `cp` varchar(10) DEFAULT NULL,
  `insee` varchar(10) DEFAULT NULL,
  `lgt` varchar(32) DEFAULT NULL,
  `lat` varchar(32) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_district_i18n`
--

CREATE TABLE `geo_district_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `district` varchar(64) NOT NULL,
  `normalized_district` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_region`
--

CREATE TABLE `geo_region` (
  `id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `insee` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `geo_region_i18n`
--

CREATE TABLE `geo_region_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `region` varchar(64) NOT NULL,
  `normalized_region` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item`
--

CREATE TABLE `item` (
  `id` int NOT NULL,
  `highlighted` tinyint DEFAULT '0',
  `member_id` int NOT NULL DEFAULT '1',
  `geo_country_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_city_id` int NOT NULL,
  `ref` varchar(255) DEFAULT NULL,
  `price` int DEFAULT NULL,
  `shipping_price` int DEFAULT NULL,
  `shipping_free` tinyint NOT NULL DEFAULT '0',
  `nb_view` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `display` tinyint NOT NULL DEFAULT '1',
  `item_style_id` int DEFAULT NULL,
  `item_period_id` int DEFAULT NULL,
  `origine` varchar(64) DEFAULT NULL,
  `epoque` varchar(64) DEFAULT NULL,
  `longueur` varchar(64) DEFAULT NULL,
  `largeur` varchar(64) DEFAULT NULL,
  `hauteur` varchar(64) DEFAULT NULL,
  `profondeur` varchar(64) DEFAULT NULL,
  `diametre` varchar(64) DEFAULT NULL,
  `pending` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_abuse`
--

CREATE TABLE `item_abuse` (
  `id` int NOT NULL,
  `profile_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `comment` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_buying`
--

CREATE TABLE `item_buying` (
  `id` int NOT NULL,
  `item_id` int DEFAULT '1',
  `profile_id` int NOT NULL,
  `buyer_first_name` varchar(255) DEFAULT NULL,
  `buyer_last_name` varchar(255) DEFAULT NULL,
  `buyer_adress1` varchar(255) DEFAULT NULL,
  `buyer_adress2` varchar(255) DEFAULT NULL,
  `buyer_zip` varchar(255) DEFAULT NULL,
  `buyer_city` varchar(255) DEFAULT NULL,
  `buyer_state` varchar(255) DEFAULT NULL,
  `buyer_country` varchar(255) DEFAULT NULL,
  `buyer_tel` varchar(20) DEFAULT NULL,
  `buyer_email` varchar(255) DEFAULT NULL,
  `member_id` int DEFAULT '1',
  `member_rcs` varchar(255) DEFAULT NULL,
  `member_society` varchar(255) DEFAULT NULL,
  `member_address` varchar(255) DEFAULT NULL,
  `member_cp` varchar(10) DEFAULT NULL,
  `member_city` varchar(255) DEFAULT NULL,
  `item_title` varchar(255) DEFAULT NULL,
  `item_price` varchar(255) DEFAULT NULL,
  `shipping_price` varchar(255) DEFAULT NULL,
  `total_price` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_category`
--

CREATE TABLE `item_category` (
  `id` int NOT NULL,
  `linked_category_id` int DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `twenga_category` varchar(255) DEFAULT NULL,
  `merchants_category` varchar(255) DEFAULT NULL,
  `shopping_category` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_category_i18n`
--

CREATE TABLE `item_category_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `category` varchar(64) NOT NULL,
  `normalized_category` varchar(64) NOT NULL,
  `meta_title` varchar(128) NOT NULL,
  `intro` mediumtext NOT NULL,
  `outro` mediumtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Structure de la table `item_deleted`
--

CREATE TABLE `item_deleted` (
  `id` int NOT NULL,
  `item_id` int DEFAULT NULL,
  `item_category_id` int DEFAULT NULL,
  `item_style_id` int DEFAULT NULL,
  `item_period_id` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_favorite`
--

CREATE TABLE `item_favorite` (
  `id` int NOT NULL,
  `profile_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_i18n`
--

CREATE TABLE `item_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Structure de la table `item_image`
--

CREATE TABLE `item_image` (
  `id` int NOT NULL,
  `item_id` int NOT NULL DEFAULT '1',
  `rank` int DEFAULT NULL,
  `is_default` tinyint DEFAULT '0',
  `filename` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_image_i18n`
--

CREATE TABLE `item_image_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_material`
--

CREATE TABLE `item_material` (
  `id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_material_i18n`
--

CREATE TABLE `item_material_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `origin` varchar(64) DEFAULT NULL,
  `normalized_material` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_origin`
--

CREATE TABLE `item_origin` (
  `id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_origin_i18n`
--

CREATE TABLE `item_origin_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `origin` varchar(64) DEFAULT NULL,
  `normalized_origin` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_period`
--

CREATE TABLE `item_period` (
  `id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_period_i18n`
--

CREATE TABLE `item_period_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `period` varchar(64) DEFAULT NULL,
  `normalized_period` varchar(64) DEFAULT NULL,
  `meta_title` varchar(128) NOT NULL,
  `intro` longtext NOT NULL,
  `outro` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Structure de la table `item_seo`
--

CREATE TABLE `item_seo` (
  `id` int NOT NULL,
  `item_category_id` int DEFAULT NULL,
  `item_style_id` int DEFAULT NULL,
  `item_period_id` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_seo_i18n`
--

CREATE TABLE `item_seo_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(128) DEFAULT NULL,
  `subtitle` varchar(128) DEFAULT NULL,
  `intro` mediumtext,
  `outro` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Structure de la table `item_signature`
--

CREATE TABLE `item_signature` (
  `id` int NOT NULL,
  `signature` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_status`
--

CREATE TABLE `item_status` (
  `id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_status_i18n`
--

CREATE TABLE `item_status_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `status` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_style`
--

CREATE TABLE `item_style` (
  `id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `item_style_i18n`
--

CREATE TABLE `item_style_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `style` varchar(64) DEFAULT NULL,
  `normalized_style` varchar(64) DEFAULT NULL,
  `meta_title` varchar(128) NOT NULL,
  `intro` longtext NOT NULL,
  `outro` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Structure de la table `keyword`
--

CREATE TABLE `keyword` (
  `id` int NOT NULL,
  `culture` varchar(7) DEFAULT NULL,
  `keyword` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `links_category`
--

CREATE TABLE `links_category` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `links_category_i18n`
--

CREATE TABLE `links_category_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `normalized_category` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `links_site`
--

CREATE TABLE `links_site` (
  `id` int NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `url_back` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `links_category_id` int NOT NULL,
  `confirm_key` varchar(255) DEFAULT NULL,
  `valid` tinyint DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `mag`
--

CREATE TABLE `mag` (
  `id` int NOT NULL,
  `highlighted` tinyint DEFAULT '0',
  `mag_category_id` int DEFAULT NULL,
  `source_id` int DEFAULT NULL,
  `member_id` int DEFAULT NULL,
  `member_group_id` int DEFAULT NULL,
  `syndic_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `published` tinyint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `mag_category`
--

CREATE TABLE `mag_category` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `mag_category_i18n`
--

CREATE TABLE `mag_category_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `category` varchar(64) NOT NULL,
  `normalized_category` varchar(64) NOT NULL,
  `description` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `mag_i18n`
--

CREATE TABLE `mag_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `baseline` varchar(255) DEFAULT NULL,
  `content` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `mass_mailing_template`
--

CREATE TABLE `mass_mailing_template` (
  `label` varchar(75) DEFAULT NULL,
  `content` text,
  `id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member`
--

CREATE TABLE `member` (
  `id` int NOT NULL,
  `member_pro_type_id` int NOT NULL,
  `login` varchar(255) DEFAULT NULL,
  `email` varchar(128) NOT NULL,
  `mc_rate` varchar(10) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `facebook_url` varchar(255) DEFAULT NULL,
  `twitter_url` varchar(255) DEFAULT NULL,
  `google_plus_url` varchar(255) DEFAULT NULL,
  `sncao` varchar(255) DEFAULT NULL,
  `society` varchar(255) DEFAULT NULL,
  `rcs` varchar(15) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `geo_city_id` int NOT NULL,
  `geo_district_id` int NOT NULL,
  `geo_departement_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `gsm` varchar(15) DEFAULT NULL,
  `googlemap` varchar(255) DEFAULT NULL,
  `lgt` varchar(32) DEFAULT NULL,
  `lat` varchar(32) DEFAULT NULL,
  `cap` int DEFAULT NULL,
  `syndic_id` int DEFAULT '0',
  `group_id` int DEFAULT '0',
  `confirm_key` varchar(255) DEFAULT NULL,
  `valid` tinyint NOT NULL DEFAULT '0',
  `pending` tinyint NOT NULL DEFAULT '0',
  `op_id` int NOT NULL DEFAULT '1',
  `customer` tinyint NOT NULL DEFAULT '0',
  `gallery` tinyint NOT NULL DEFAULT '0',
  `member_type_id` int NOT NULL DEFAULT '1',
  `max_items` int DEFAULT '0',
  `translation_credits` int DEFAULT '0',
  `send_me_email` tinyint DEFAULT '1',
  `mail_open_date` date DEFAULT NULL,
  `mail_click_date` date DEFAULT NULL,
  `last_visite_date` date DEFAULT NULL,
  `last_connection_date` date DEFAULT NULL,
  `last_contact_date` date DEFAULT NULL,
  `next_contact_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `proantic` tinyint DEFAULT '0',
  `anticstore` tinyint DEFAULT '0',
  `password` varchar(32) NOT NULL,
  `member_culture` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_group`
--

CREATE TABLE `member_group` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `geo_city_id` int NOT NULL,
  `geo_district_id` int NOT NULL,
  `geo_departement_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `gsm` varchar(15) DEFAULT NULL,
  `url` varchar(128) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_group_i18n`
--

CREATE TABLE `member_group_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `baseline` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_description` varchar(255) NOT NULL,
  `meta_keywords` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_i18n`
--

CREATE TABLE `member_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `baseline` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Structure de la table `member_paypal`
--

CREATE TABLE `member_paypal` (
  `id` int NOT NULL,
  `member_id` int NOT NULL DEFAULT '1',
  `paypal_active` tinyint NOT NULL DEFAULT '0',
  `paypal_email` varchar(255) DEFAULT NULL,
  `seller_name` varchar(255) NOT NULL,
  `seller_address` varchar(255) NOT NULL,
  `seller_zip` varchar(255) NOT NULL,
  `seller_city` varchar(255) NOT NULL,
  `seller_country` varchar(255) NOT NULL,
  `terms_of_use` tinyint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_pro_type`
--

CREATE TABLE `member_pro_type` (
  `id` int NOT NULL,
  `type` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_speciality`
--

CREATE TABLE `member_speciality` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_speciality_i18n`
--

CREATE TABLE `member_speciality_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `speciality` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `normalized_speciality` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_stat`
--

CREATE TABLE `member_stat` (
  `id` int NOT NULL,
  `member_id` int NOT NULL,
  `referer` varchar(64) NOT NULL DEFAULT 'unknown',
  `type_stat` varchar(64) NOT NULL DEFAULT 'unknown',
  `month_01` int DEFAULT NULL,
  `month_02` int DEFAULT NULL,
  `month_03` int DEFAULT NULL,
  `month_04` int DEFAULT NULL,
  `month_05` int DEFAULT NULL,
  `month_06` int DEFAULT NULL,
  `month_07` int DEFAULT NULL,
  `month_08` int DEFAULT NULL,
  `month_09` int DEFAULT NULL,
  `month_10` int DEFAULT NULL,
  `month_11` int DEFAULT NULL,
  `month_12` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_type`
--

CREATE TABLE `member_type` (
  `id` int NOT NULL,
  `name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `member_type_i18n`
--

CREATE TABLE `member_type_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `type` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `message_archive`
--

CREATE TABLE `message_archive` (
  `id` int NOT NULL,
  `member_id` int NOT NULL DEFAULT '1',
  `message_from` varchar(255) DEFAULT NULL,
  `message_subject` varchar(255) DEFAULT NULL,
  `message_body` text,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int NOT NULL,
  `batch_id` varchar(255) NOT NULL,
  `is_private` tinyint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `newsletter_i18n`
--

CREATE TABLE `newsletter_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `news_post`
--

CREATE TABLE `news_post` (
  `id` int NOT NULL,
  `is_private` tinyint NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `published_at` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `news_post_country`
--

CREATE TABLE `news_post_country` (
  `id` int NOT NULL,
  `geo_country_id` int NOT NULL DEFAULT '1',
  `news_id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `news_post_i18n`
--

CREATE TABLE `news_post_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `private_content` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `news_subscriber`
--

CREATE TABLE `news_subscriber` (
  `id` int NOT NULL,
  `geo_country_id` int DEFAULT NULL,
  `culture` varchar(7) NOT NULL DEFAULT 'fr_FR',
  `name` varchar(255) DEFAULT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `confirm_key` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `op`
--

CREATE TABLE `op` (
  `id` int NOT NULL,
  `login` varchar(32) DEFAULT NULL,
  `pass` varchar(64) NOT NULL,
  `culture` varchar(6) DEFAULT NULL,
  `name` varchar(64) NOT NULL,
  `surname` varchar(64) NOT NULL,
  `email` varchar(64) NOT NULL,
  `portable` varchar(12) DEFAULT NULL,
  `tel_remote` varchar(12) DEFAULT NULL,
  `tel_local` varchar(12) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `op_comment`
--

CREATE TABLE `op_comment` (
  `id` int NOT NULL,
  `op_id` int NOT NULL,
  `member_id` int NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `order_duration`
--

CREATE TABLE `order_duration` (
  `id` int NOT NULL,
  `duration` int DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `order_invoice`
--

CREATE TABLE `order_invoice` (
  `id` int NOT NULL,
  `order_item_id` int DEFAULT NULL,
  `order_payment_id` int DEFAULT NULL,
  `tax_free_unit_amount` float DEFAULT NULL,
  `tax_unit_amount` float DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `order_item`
--

CREATE TABLE `order_item` (
  `id` int NOT NULL,
  `previous_item_id` int DEFAULT NULL,
  `member_id` int DEFAULT NULL,
  `offer_duration_id` int DEFAULT NULL,
  `traduction_offer_id` int DEFAULT NULL,
  `beginned_at` date DEFAULT NULL,
  `ended_at` date DEFAULT NULL,
  `started_at` date DEFAULT NULL,
  `antiquaire_date` date DEFAULT NULL,
  `status` varchar(3) DEFAULT NULL,
  `is_upgrade` tinyint NOT NULL DEFAULT '0',
  `dynamic_label` varchar(255) DEFAULT NULL,
  `hidden` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Doublure de structure pour la vue `order_item_view`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `order_item_view` (
`beginned_at` date
,`customer` tinyint
,`ended_at` date
,`id` int
,`member_id` int
,`offer_label` varchar(50)
,`order_item_id` int
,`order_payment_type_id` int
,`society` varchar(255)
);

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

--
-- Structure de la table `order_member_rib`
--

CREATE TABLE `order_member_rib` (
  `id` int NOT NULL,
  `member_id` int DEFAULT NULL,
  `order_item_id` int DEFAULT NULL,
  `titulaire` varchar(255) NOT NULL,
  `domiciliation` varchar(255) NOT NULL,
  `code_banque` varchar(20) NOT NULL,
  `code_guichet` varchar(20) NOT NULL,
  `code_compte` varchar(20) NOT NULL,
  `code_cle` varchar(2) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Doublure de structure pour la vue `order_member_view`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `order_member_view` (
`beginned_at` date
,`customer` tinyint
,`ended_at` date
,`id` int
,`member_id` int
,`next_item_id` int
,`offer_label` varchar(50)
,`order_item_id` int
,`order_payment_type_id` int
,`society` varchar(255)
);

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

--
-- Structure de la table `order_offer`
--

CREATE TABLE `order_offer` (
  `id` int NOT NULL,
  `label` varchar(50) DEFAULT NULL,
  `description` text,
  `excludeVATPrice` int DEFAULT NULL,
  `type` varchar(5) DEFAULT NULL,
  `gallery` tinyint NOT NULL DEFAULT '0',
  `site` tinyint NOT NULL DEFAULT '0',
  `items` int NOT NULL DEFAULT '0',
  `translations` int NOT NULL DEFAULT '0',
  `hidden` tinyint NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `order_offer_duration`
--

CREATE TABLE `order_offer_duration` (
  `id` int NOT NULL,
  `offer_id` int NOT NULL,
  `duration_id` int NOT NULL,
  `member_type_id` int NOT NULL,
  `enabled` tinyint NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `order_payment`
--

CREATE TABLE `order_payment` (
  `id` int NOT NULL,
  `order_item_id` int DEFAULT NULL,
  `payment_type_id` int NOT NULL,
  `status` varchar(3) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `avoir` float DEFAULT '0',
  `message` varchar(150) DEFAULT NULL,
  `transaction_id` varchar(6) DEFAULT NULL,
  `payment_certificate` varchar(12) DEFAULT NULL,
  `authorization_id` varchar(10) DEFAULT NULL,
  `card_number` varchar(7) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `order_payment_type`
--

CREATE TABLE `order_payment_type` (
  `id` int NOT NULL,
  `code` varchar(6) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `description` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `organic_csv`
--

CREATE TABLE `organic_csv` (
  `keyword` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `previous_position` varchar(255) DEFAULT NULL,
  `search_volume` varchar(255) DEFAULT NULL,
  `cpc` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `organic_table`
--

CREATE TABLE `organic_table` (
  `id` int NOT NULL,
  `keyword` varchar(255) DEFAULT NULL,
  `search_volume` int DEFAULT NULL,
  `aef_position` int DEFAULT NULL,
  `aef_previous_position` int DEFAULT NULL,
  `aef_change` int DEFAULT NULL,
  `aef_url` varchar(255) DEFAULT NULL,
  `anticstore_position` int DEFAULT NULL,
  `anticstore_previous_position` int DEFAULT NULL,
  `anticstore_change` int DEFAULT NULL,
  `anticstore_url` varchar(255) DEFAULT NULL,
  `proantic_position` int DEFAULT NULL,
  `proantic_previous_position` int DEFAULT NULL,
  `proantic_change` int DEFAULT NULL,
  `proantic_url` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `paypal_payment`
--

CREATE TABLE `paypal_payment` (
  `id` int NOT NULL,
  `command_id` int NOT NULL,
  `item_name` varchar(128) NOT NULL,
  `item_number` varchar(128) NOT NULL,
  `payment_status` varchar(128) NOT NULL,
  `mc_gross` varchar(128) NOT NULL,
  `mc_currency` varchar(128) NOT NULL,
  `txn_id` varchar(128) NOT NULL,
  `receiver_email` varchar(128) NOT NULL,
  `payer_email` varchar(128) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `buyer_id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `rel_fair_date`
--

CREATE TABLE `rel_fair_date` (
  `id` int NOT NULL,
  `fair_id` int NOT NULL,
  `fair_date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `rel_item_category`
--

CREATE TABLE `rel_item_category` (
  `item_id` int NOT NULL,
  `item_category_id` int DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `rel_member_fair`
--

CREATE TABLE `rel_member_fair` (
  `member_id` int NOT NULL,
  `fair_id` int DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `rel_member_speciality`
--

CREATE TABLE `rel_member_speciality` (
  `member_id` int NOT NULL,
  `member_speciality_id` int DEFAULT NULL,
  `rank` int DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Doublure de structure pour la vue `reporting_commandes`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `reporting_commandes` (
`amount` double
,`month` varchar(2)
,`year` int
);

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

--
-- Doublure de structure pour la vue `reporting_depenses`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `reporting_depenses` (
`amount` double
,`month` varchar(2)
,`year` int
);

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

--
-- Doublure de structure pour la vue `reporting_depenses_test`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `reporting_depenses_test` (
`amount` double
,`month` varchar(2)
,`tva` double
,`year` int
);

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

--
-- Structure de la table `semrush`
--

CREATE TABLE `semrush` (
  `keyword` varchar(255) DEFAULT NULL,
  `position` int DEFAULT NULL,
  `versus_position` int DEFAULT NULL,
  `search_volume` varchar(255) DEFAULT NULL,
  `cpc` varchar(255) DEFAULT NULL,
  `competition` varchar(255) DEFAULT NULL,
  `number_of_results` varchar(255) DEFAULT NULL,
  `trends` int DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_group`
--

CREATE TABLE `sf_guard_group` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_group_permission`
--

CREATE TABLE `sf_guard_group_permission` (
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_permission`
--

CREATE TABLE `sf_guard_permission` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_remember_key`
--

CREATE TABLE `sf_guard_remember_key` (
  `user_id` int NOT NULL,
  `remember_key` varchar(32) DEFAULT NULL,
  `ip_address` varchar(50) NOT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_user`
--

CREATE TABLE `sf_guard_user` (
  `id` int NOT NULL,
  `username` varchar(128) NOT NULL,
  `algorithm` varchar(128) NOT NULL DEFAULT 'sha1',
  `salt` varchar(128) NOT NULL,
  `password` varchar(128) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `is_super_admin` tinyint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_user_group`
--

CREATE TABLE `sf_guard_user_group` (
  `user_id` int NOT NULL,
  `group_id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_user_permission`
--

CREATE TABLE `sf_guard_user_permission` (
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sf_guard_user_profile`
--

CREATE TABLE `sf_guard_user_profile` (
  `id` int NOT NULL,
  `culture` varchar(5) DEFAULT 'fr_FR',
  `email` varchar(128) NOT NULL,
  `user_id` int NOT NULL,
  `ismember` int NOT NULL DEFAULT '0',
  `member_id` int DEFAULT NULL,
  `member_group_id` int DEFAULT NULL,
  `syndic_id` int DEFAULT NULL,
  `fair_owner_id` int DEFAULT NULL,
  `society` varchar(128) DEFAULT NULL,
  `first_name` varchar(128) DEFAULT NULL,
  `last_name` varchar(128) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `city` varchar(128) DEFAULT NULL,
  `state` varchar(128) DEFAULT NULL,
  `country` varchar(128) DEFAULT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `gsm` varchar(15) DEFAULT NULL,
  `mail_news_hebdo` tinyint NOT NULL DEFAULT '0',
  `mail_mag_mensu` tinyint NOT NULL DEFAULT '0',
  `mail_info_trim` tinyint NOT NULL DEFAULT '0',
  `mail_usage_note` tinyint NOT NULL DEFAULT '0',
  `mail_in_error` tinyint NOT NULL DEFAULT '0',
  `mail_in_error_code` varchar(15) DEFAULT NULL,
  `mail_in_error_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `shipping_type`
--

CREATE TABLE `shipping_type` (
  `id` int NOT NULL,
  `price` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `shipping_type_i18n`
--

CREATE TABLE `shipping_type_i18n` (
  `id` int NOT NULL,
  `culture` varchar(7) NOT NULL,
  `title` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `syndic`
--

CREATE TABLE `syndic` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `geo_city_id` int NOT NULL,
  `geo_district_id` int NOT NULL,
  `geo_departement_id` int NOT NULL,
  `geo_region_id` int NOT NULL,
  `geo_country_id` int NOT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `gsm` varchar(15) DEFAULT NULL,
  `url` varchar(128) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `syndic_i18n`
--

CREATE TABLE `syndic_i18n` (
  `id` int NOT NULL,
  `culture` varchar(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `baseline` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_description` varchar(255) NOT NULL,
  `meta_keywords` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `translation`
--

CREATE TABLE `translation` (
  `type` varchar(255) DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `member_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `id` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `wishlist`
--

CREATE TABLE `wishlist` (
  `id` int NOT NULL,
  `geo_country_id` int NOT NULL DEFAULT '1',
  `name` varchar(255) DEFAULT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `tel` varchar(32) DEFAULT NULL,
  `fax` varchar(32) DEFAULT NULL,
  `gsm` varchar(32) DEFAULT NULL,
  `message` text,
  `confirm_key` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la vue `order_item_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`aef`@`%` SQL SECURITY DEFINER VIEW `order_item_view`  AS SELECT `OI`.`id` AS `id`, `M`.`id` AS `member_id`, `M`.`society` AS `society`, `M`.`customer` AS `customer`, `OO`.`label` AS `offer_label`, `OI`.`id` AS `order_item_id`, `OI`.`beginned_at` AS `beginned_at`, `OI`.`ended_at` AS `ended_at`, `OPT`.`id` AS `order_payment_type_id` FROM (((((`order_item` `OI` join `member` `M` on((`M`.`id` = `OI`.`member_id`))) join `order_offer_duration` `OOD` on((`OOD`.`id` = `OI`.`offer_duration_id`))) join `order_offer` `OO` on((`OO`.`id` = `OOD`.`offer_id`))) join `order_payment` `OP` on((`OP`.`order_item_id` = `OI`.`id`))) join `order_payment_type` `OPT` on((`OPT`.`id` = `OP`.`payment_type_id`))) WHERE ((`OI`.`offer_duration_id` is not null) AND (`OP`.`status` = _latin1'OK')) ;

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

--
-- Structure de la vue `order_member_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`aef`@`%` SQL SECURITY DEFINER VIEW `order_member_view`  AS SELECT `M`.`id` AS `id`, `M`.`id` AS `member_id`, `M`.`society` AS `society`, `M`.`customer` AS `customer`, `OO`.`label` AS `offer_label`, `OI`.`id` AS `order_item_id`, `OI`.`beginned_at` AS `beginned_at`, `OI`.`ended_at` AS `ended_at`, `OPT`.`id` AS `order_payment_type_id`, `OI2`.`id` AS `next_item_id` FROM ((((((`member` `M` join `order_item` `OI` on((`M`.`id` = `OI`.`member_id`))) left join `order_item` `OI2` on((`OI2`.`previous_item_id` = `OI`.`id`))) join `order_offer_duration` `OOD` on((`OOD`.`id` = `OI`.`offer_duration_id`))) join `order_offer` `OO` on((`OO`.`id` = `OOD`.`offer_id`))) join `order_payment` `OP` on((`OP`.`order_item_id` = `OI`.`id`))) join `order_payment_type` `OPT` on((`OPT`.`id` = `OP`.`payment_type_id`))) WHERE ((`OI`.`offer_duration_id` is not null) AND (`OP`.`status` = _latin1'OK') AND (`OI`.`status` = _latin1'OK') AND ((`OI2`.`status` = _latin1'OK') OR (`OI2`.`status` is null))) GROUP BY `M`.`id` ORDER BY `M`.`id` ASC ;

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

--
-- Structure de la vue `reporting_commandes`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`aef`@`%` SQL SECURITY DEFINER VIEW `reporting_commandes`  AS SELECT year(`OI`.`created_at`) AS `year`, date_format(`OI`.`created_at`,'%m') AS `month`, sum(`OP`.`amount`) AS `amount` FROM (`order_payment` `OP` join `order_item` `OI` on((`OI`.`id` = `OP`.`order_item_id`))) WHERE ((`OI`.`status` = 'OK') OR (`OI`.`status` = 'PEN')) GROUP BY year(`OI`.`created_at`), date_format(`OI`.`created_at`,'%m') ;

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

--
-- Structure de la vue `reporting_depenses`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`aef`@`%` SQL SECURITY DEFINER VIEW `reporting_depenses`  AS SELECT year(`expense`.`reference_at`) AS `year`, date_format(`expense`.`reference_at`,'%m') AS `month`, sum(`expense`.`amount_ttc`) AS `amount` FROM `expense` GROUP BY year(`expense`.`reference_at`), date_format(`expense`.`reference_at`,'%m') ;

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

--
-- Structure de la vue `reporting_depenses_test`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`aef`@`%` SQL SECURITY DEFINER VIEW `reporting_depenses_test`  AS SELECT year(`expense`.`reference_at`) AS `year`, date_format(`expense`.`reference_at`,'%m') AS `month`, sum(`expense`.`amount_ttc`) AS `amount`, sum(`expense`.`amount_tva`) AS `tva` FROM `expense` GROUP BY year(`expense`.`reference_at`), date_format(`expense`.`reference_at`,'%m') ;

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `alert`
--
ALTER TABLE `alert`
  ADD PRIMARY KEY (`id`),
  ADD KEY `alert_FI_1` (`profile_id`),
  ADD KEY `alert_FI_2` (`item_category_id`),
  ADD KEY `alert_FI_3` (`item_style_id`),
  ADD KEY `alert_FI_4` (`item_period_id`),
  ADD KEY `alert_FI_5` (`item_material_id`),
  ADD KEY `alert_FI_6` (`item_origin_id`);

--
-- Index pour la table `annonce`
--
ALTER TABLE `annonce`
  ADD PRIMARY KEY (`id`),
  ADD KEY `annonce_FI_1` (`geo_region_id`),
  ADD KEY `annonce_FI_2` (`annonce_category_id`),
  ADD KEY `annonce_FI_3` (`annonce_cible_id`),
  ADD KEY `annonce_FI_4` (`annonce_source_id`),
  ADD KEY `annonce_FI_5` (`profile_id`),
  ADD KEY `annonce_FI_6` (`member_id`),
  ADD KEY `annonce_FI_7` (`member_group_id`),
  ADD KEY `annonce_FI_8` (`syndic_id`),
  ADD KEY `annonce_FI_9` (`fair_owner_id`);

--
-- Index pour la table `annonce_category`
--
ALTER TABLE `annonce_category`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `annonce_cible`
--
ALTER TABLE `annonce_cible`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `annonce_i18n`
--
ALTER TABLE `annonce_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `annonce_image`
--
ALTER TABLE `annonce_image`
  ADD PRIMARY KEY (`id`),
  ADD KEY `annonce_image_FI_1` (`annonce_id`);

--
-- Index pour la table `annonce_source`
--
ALTER TABLE `annonce_source`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `command`
--
ALTER TABLE `command`
  ADD PRIMARY KEY (`id`),
  ADD KEY `command_FI_1` (`profile_id`),
  ADD KEY `command_FI_2` (`member_id`),
  ADD KEY `command_FI_3` (`shipping_type_id`);

--
-- Index pour la table `expense`
--
ALTER TABLE `expense`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `fair`
--
ALTER TABLE `fair`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fair_FI_1` (`profile_id`),
  ADD KEY `fair_FI_2` (`geo_country_id`),
  ADD KEY `fair_FI_3` (`geo_region_id`),
  ADD KEY `fair_FI_4` (`geo_departement_id`),
  ADD KEY `fair_FI_5` (`geo_city_id`),
  ADD KEY `fair_FI_6` (`fair_frequency_id`),
  ADD KEY `fair_FI_7` (`fair_type_id`),
  ADD KEY `fair_FI_8` (`fair_owner_id`),
  ADD KEY `fair_FI_9` (`mag_id`);

--
-- Index pour la table `fair_frequency`
--
ALTER TABLE `fair_frequency`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `fair_i18n`
--
ALTER TABLE `fair_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `fair_owner`
--
ALTER TABLE `fair_owner`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fair_owner_FI_1` (`geo_city_id`),
  ADD KEY `fair_owner_FI_2` (`geo_district_id`),
  ADD KEY `fair_owner_FI_3` (`geo_departement_id`),
  ADD KEY `fair_owner_FI_4` (`geo_region_id`),
  ADD KEY `fair_owner_FI_5` (`geo_country_id`);

--
-- Index pour la table `fair_owner_i18n`
--
ALTER TABLE `fair_owner_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `fair_type`
--
ALTER TABLE `fair_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `fair_type_i18n`
--
ALTER TABLE `fair_type_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `geo_city`
--
ALTER TABLE `geo_city`
  ADD PRIMARY KEY (`id`),
  ADD KEY `geo_city_FI_1` (`geo_country_id`),
  ADD KEY `geo_city_FI_2` (`geo_region_id`),
  ADD KEY `geo_city_FI_3` (`geo_departement_id`),
  ADD KEY `geo_city_FI_4` (`geo_district_id`);

--
-- Index pour la table `geo_city_i18n`
--
ALTER TABLE `geo_city_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `geo_country`
--
ALTER TABLE `geo_country`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `geo_country_i18n`
--
ALTER TABLE `geo_country_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `geo_departement`
--
ALTER TABLE `geo_departement`
  ADD PRIMARY KEY (`id`),
  ADD KEY `geo_departement_FI_1` (`geo_country_id`),
  ADD KEY `geo_departement_FI_2` (`geo_region_id`);

--
-- Index pour la table `geo_departement_i18n`
--
ALTER TABLE `geo_departement_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `geo_district`
--
ALTER TABLE `geo_district`
  ADD PRIMARY KEY (`id`),
  ADD KEY `geo_district_FI_1` (`geo_country_id`),
  ADD KEY `geo_district_FI_2` (`geo_region_id`),
  ADD KEY `geo_district_FI_3` (`geo_departement_id`);

--
-- Index pour la table `geo_district_i18n`
--
ALTER TABLE `geo_district_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `geo_region`
--
ALTER TABLE `geo_region`
  ADD PRIMARY KEY (`id`),
  ADD KEY `geo_region_FI_1` (`geo_country_id`);

--
-- Index pour la table `geo_region_i18n`
--
ALTER TABLE `geo_region_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `item`
--
ALTER TABLE `item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_FI_1` (`member_id`),
  ADD KEY `item_FI_2` (`geo_country_id`),
  ADD KEY `item_FI_3` (`geo_region_id`),
  ADD KEY `item_FI_4` (`geo_city_id`),
  ADD KEY `item_FI_5` (`status`),
  ADD KEY `item_FI_6` (`item_style_id`),
  ADD KEY `item_FI_7` (`item_period_id`),
  ADD KEY `id` (`id`),
  ADD KEY `member_id` (`member_id`);

--
-- Index pour la table `item_abuse`
--
ALTER TABLE `item_abuse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_abuse_FI_1` (`profile_id`),
  ADD KEY `item_abuse_FI_2` (`item_id`);

--
-- Index pour la table `item_buying`
--
ALTER TABLE `item_buying`
  ADD PRIMARY KEY (`id`,`profile_id`),
  ADD KEY `item_buying_FI_1` (`profile_id`);

--
-- Index pour la table `item_category`
--
ALTER TABLE `item_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_category_FI_1` (`linked_category_id`),
  ADD KEY `id` (`id`),
  ADD KEY `linked_category_id` (`linked_category_id`),
  ADD KEY `idx_linked_category_id` (`linked_category_id`);

--
-- Index pour la table `item_category_i18n`
--
ALTER TABLE `item_category_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`),
  ADD KEY `culture` (`culture`),
  ADD KEY `idx_culture_category` (`culture`,`category`);

--
-- Index pour la table `item_deleted`
--
ALTER TABLE `item_deleted`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_deleted_FI_1` (`item_id`),
  ADD KEY `item_deleted_FI_2` (`item_category_id`),
  ADD KEY `item_deleted_FI_3` (`item_style_id`),
  ADD KEY `item_deleted_FI_4` (`item_period_id`);

--
-- Index pour la table `item_favorite`
--
ALTER TABLE `item_favorite`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_favorite_FI_1` (`profile_id`),
  ADD KEY `item_favorite_FI_2` (`item_id`);

--
-- Index pour la table `item_i18n`
--
ALTER TABLE `item_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `item_image`
--
ALTER TABLE `item_image`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_image_FI_1` (`item_id`),
  ADD KEY `id` (`id`),
  ADD KEY `item_id` (`item_id`);

--
-- Index pour la table `item_image_i18n`
--
ALTER TABLE `item_image_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `item_material`
--
ALTER TABLE `item_material`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `item_material_i18n`
--
ALTER TABLE `item_material_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `item_origin`
--
ALTER TABLE `item_origin`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `item_origin_i18n`
--
ALTER TABLE `item_origin_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `item_period`
--
ALTER TABLE `item_period`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `item_period_i18n`
--
ALTER TABLE `item_period_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`),
  ADD KEY `culture` (`culture`);

--
-- Index pour la table `item_seo`
--
ALTER TABLE `item_seo`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_seo_FI_1` (`item_category_id`),
  ADD KEY `item_seo_FI_2` (`item_style_id`),
  ADD KEY `item_seo_FI_3` (`item_period_id`);

--
-- Index pour la table `item_seo_i18n`
--
ALTER TABLE `item_seo_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `item_signature`
--
ALTER TABLE `item_signature`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `item_status`
--
ALTER TABLE `item_status`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `item_status_i18n`
--
ALTER TABLE `item_status_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `item_style`
--
ALTER TABLE `item_style`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `item_style_i18n`
--
ALTER TABLE `item_style_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`),
  ADD KEY `culture` (`culture`);

--
-- Index pour la table `keyword`
--
ALTER TABLE `keyword`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `links_category`
--
ALTER TABLE `links_category`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `links_category_i18n`
--
ALTER TABLE `links_category_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `links_site`
--
ALTER TABLE `links_site`
  ADD PRIMARY KEY (`id`),
  ADD KEY `links_site_FI_1` (`links_category_id`);

--
-- Index pour la table `mag`
--
ALTER TABLE `mag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mag_FI_1` (`mag_category_id`),
  ADD KEY `mag_FI_2` (`source_id`),
  ADD KEY `mag_FI_3` (`member_id`),
  ADD KEY `mag_FI_4` (`member_group_id`),
  ADD KEY `mag_FI_5` (`syndic_id`),
  ADD KEY `mag_category_id` (`mag_category_id`);

--
-- Index pour la table `mag_category`
--
ALTER TABLE `mag_category`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `mag_category_i18n`
--
ALTER TABLE `mag_category_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `mag_i18n`
--
ALTER TABLE `mag_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`);

--
-- Index pour la table `mass_mailing_template`
--
ALTER TABLE `mass_mailing_template`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `member`
--
ALTER TABLE `member`
  ADD PRIMARY KEY (`id`),
  ADD KEY `member_FI_1` (`member_pro_type_id`),
  ADD KEY `member_FI_2` (`geo_city_id`),
  ADD KEY `member_FI_3` (`geo_district_id`),
  ADD KEY `member_FI_4` (`geo_departement_id`),
  ADD KEY `member_FI_5` (`geo_region_id`),
  ADD KEY `member_FI_6` (`geo_country_id`),
  ADD KEY `member_FI_7` (`syndic_id`),
  ADD KEY `member_FI_8` (`group_id`),
  ADD KEY `member_FI_9` (`op_id`),
  ADD KEY `member_FI_10` (`member_type_id`);

--
-- Index pour la table `member_group`
--
ALTER TABLE `member_group`
  ADD PRIMARY KEY (`id`),
  ADD KEY `member_group_FI_1` (`geo_city_id`),
  ADD KEY `member_group_FI_2` (`geo_district_id`),
  ADD KEY `member_group_FI_3` (`geo_departement_id`),
  ADD KEY `member_group_FI_4` (`geo_region_id`),
  ADD KEY `member_group_FI_5` (`geo_country_id`);

--
-- Index pour la table `member_group_i18n`
--
ALTER TABLE `member_group_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `member_i18n`
--
ALTER TABLE `member_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `member_paypal`
--
ALTER TABLE `member_paypal`
  ADD PRIMARY KEY (`id`),
  ADD KEY `member_paypal_FI_1` (`member_id`);

--
-- Index pour la table `member_pro_type`
--
ALTER TABLE `member_pro_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `member_speciality`
--
ALTER TABLE `member_speciality`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`),
  ADD KEY `id_2` (`id`);

--
-- Index pour la table `member_speciality_i18n`
--
ALTER TABLE `member_speciality_i18n`
  ADD PRIMARY KEY (`id`,`culture`),
  ADD KEY `id` (`id`),
  ADD KEY `culture` (`culture`),
  ADD KEY `id_2` (`id`);

--
-- Index pour la table `member_stat`
--
ALTER TABLE `member_stat`
  ADD PRIMARY KEY (`id`,`member_id`,`referer`,`type_stat`),
  ADD KEY `member_stat_FI_1` (`member_id`);

--
-- Index pour la table `member_type`
--
ALTER TABLE `member_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `member_type_i18n`
--
ALTER TABLE `member_type_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `message_archive`
--
ALTER TABLE `message_archive`
  ADD PRIMARY KEY (`id`),
  ADD KEY `message_archive_FI_1` (`member_id`);

--
-- Index pour la table `newsletter`
--
ALTER TABLE `newsletter`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `newsletter_i18n`
--
ALTER TABLE `newsletter_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `news_post`
--
ALTER TABLE `news_post`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `news_post_country`
--
ALTER TABLE `news_post_country`
  ADD PRIMARY KEY (`id`),
  ADD KEY `news_post_country_FI_1` (`geo_country_id`),
  ADD KEY `news_post_country_FI_2` (`news_id`);

--
-- Index pour la table `news_post_i18n`
--
ALTER TABLE `news_post_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `news_subscriber`
--
ALTER TABLE `news_subscriber`
  ADD PRIMARY KEY (`id`),
  ADD KEY `news_subscriber_FI_1` (`geo_country_id`);

--
-- Index pour la table `op`
--
ALTER TABLE `op`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `op_comment`
--
ALTER TABLE `op_comment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `op_comment_FI_1` (`op_id`),
  ADD KEY `op_comment_FI_2` (`member_id`);

--
-- Index pour la table `order_duration`
--
ALTER TABLE `order_duration`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `order_invoice`
--
ALTER TABLE `order_invoice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_invoice_FI_1` (`order_item_id`),
  ADD KEY `order_invoice_FI_2` (`order_payment_id`);

--
-- Index pour la table `order_item`
--
ALTER TABLE `order_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_item_FI_1` (`previous_item_id`),
  ADD KEY `order_item_FI_2` (`offer_duration_id`),
  ADD KEY `order_item_FI_3` (`traduction_offer_id`);

--
-- Index pour la table `order_member_rib`
--
ALTER TABLE `order_member_rib`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `order_offer`
--
ALTER TABLE `order_offer`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `order_offer_duration`
--
ALTER TABLE `order_offer_duration`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_offer_duration_FI_1` (`offer_id`),
  ADD KEY `order_offer_duration_FI_2` (`duration_id`),
  ADD KEY `order_offer_duration_FI_3` (`member_type_id`);

--
-- Index pour la table `order_payment`
--
ALTER TABLE `order_payment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_payment_FI_1` (`order_item_id`),
  ADD KEY `order_payment_FI_2` (`payment_type_id`);

--
-- Index pour la table `order_payment_type`
--
ALTER TABLE `order_payment_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `organic_csv`
--
ALTER TABLE `organic_csv`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `organic_table`
--
ALTER TABLE `organic_table`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `paypal_payment`
--
ALTER TABLE `paypal_payment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `paypal_payment_FI_1` (`command_id`);

--
-- Index pour la table `rel_fair_date`
--
ALTER TABLE `rel_fair_date`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_fair_date_FI_1` (`fair_id`),
  ADD KEY `fair_id` (`fair_id`);

--
-- Index pour la table `rel_item_category`
--
ALTER TABLE `rel_item_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_item_category_FI_1` (`item_id`),
  ADD KEY `rel_item_category_FI_2` (`item_category_id`),
  ADD KEY `item_id` (`item_id`),
  ADD KEY `item_category_id` (`item_category_id`);

--
-- Index pour la table `rel_member_fair`
--
ALTER TABLE `rel_member_fair`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_member_fair_FI_1` (`member_id`),
  ADD KEY `rel_member_fair_FI_2` (`fair_id`),
  ADD KEY `fair_id` (`fair_id`),
  ADD KEY `member_id` (`member_id`);

--
-- Index pour la table `rel_member_speciality`
--
ALTER TABLE `rel_member_speciality`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel_member_speciality_FI_1` (`member_id`),
  ADD KEY `rel_member_speciality_FI_2` (`member_speciality_id`),
  ADD KEY `member_speciality_id` (`member_speciality_id`),
  ADD KEY `member_id` (`member_id`);

--
-- Index pour la table `semrush`
--
ALTER TABLE `semrush`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `sf_guard_group`
--
ALTER TABLE `sf_guard_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sf_guard_group_U_1` (`name`);

--
-- Index pour la table `sf_guard_group_permission`
--
ALTER TABLE `sf_guard_group_permission`
  ADD PRIMARY KEY (`group_id`,`permission_id`),
  ADD KEY `sf_guard_group_permission_FI_2` (`permission_id`);

--
-- Index pour la table `sf_guard_permission`
--
ALTER TABLE `sf_guard_permission`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sf_guard_permission_U_1` (`name`);

--
-- Index pour la table `sf_guard_remember_key`
--
ALTER TABLE `sf_guard_remember_key`
  ADD PRIMARY KEY (`user_id`,`ip_address`);

--
-- Index pour la table `sf_guard_user`
--
ALTER TABLE `sf_guard_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sf_guard_user_U_1` (`username`);

--
-- Index pour la table `sf_guard_user_group`
--
ALTER TABLE `sf_guard_user_group`
  ADD PRIMARY KEY (`user_id`,`group_id`),
  ADD KEY `sf_guard_user_group_FI_2` (`group_id`);

--
-- Index pour la table `sf_guard_user_permission`
--
ALTER TABLE `sf_guard_user_permission`
  ADD PRIMARY KEY (`user_id`,`permission_id`),
  ADD KEY `sf_guard_user_permission_FI_2` (`permission_id`);

--
-- Index pour la table `sf_guard_user_profile`
--
ALTER TABLE `sf_guard_user_profile`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sf_guard_user_profile_FI_1` (`user_id`),
  ADD KEY `sf_guard_user_profile_FI_2` (`ismember`),
  ADD KEY `sf_guard_user_profile_FI_3` (`member_id`),
  ADD KEY `sf_guard_user_profile_FI_4` (`member_group_id`),
  ADD KEY `sf_guard_user_profile_FI_5` (`syndic_id`),
  ADD KEY `sf_guard_user_profile_FI_6` (`fair_owner_id`);

--
-- Index pour la table `shipping_type`
--
ALTER TABLE `shipping_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `shipping_type_i18n`
--
ALTER TABLE `shipping_type_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `syndic`
--
ALTER TABLE `syndic`
  ADD PRIMARY KEY (`id`),
  ADD KEY `syndic_FI_1` (`geo_city_id`),
  ADD KEY `syndic_FI_2` (`geo_district_id`),
  ADD KEY `syndic_FI_3` (`geo_departement_id`),
  ADD KEY `syndic_FI_4` (`geo_region_id`),
  ADD KEY `syndic_FI_5` (`geo_country_id`);

--
-- Index pour la table `syndic_i18n`
--
ALTER TABLE `syndic_i18n`
  ADD PRIMARY KEY (`id`,`culture`);

--
-- Index pour la table `translation`
--
ALTER TABLE `translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `translation_FI_1` (`item_id`),
  ADD KEY `translation_FI_2` (`member_id`);

--
-- Index pour la table `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wishlist_FI_1` (`geo_country_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `alert`
--
ALTER TABLE `alert`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `annonce`
--
ALTER TABLE `annonce`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `annonce_category`
--
ALTER TABLE `annonce_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `annonce_cible`
--
ALTER TABLE `annonce_cible`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `annonce_image`
--
ALTER TABLE `annonce_image`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `annonce_source`
--
ALTER TABLE `annonce_source`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `command`
--
ALTER TABLE `command`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `expense`
--
ALTER TABLE `expense`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `fair`
--
ALTER TABLE `fair`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `fair_frequency`
--
ALTER TABLE `fair_frequency`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `fair_owner`
--
ALTER TABLE `fair_owner`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `fair_type`
--
ALTER TABLE `fair_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `geo_city`
--
ALTER TABLE `geo_city`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `geo_country`
--
ALTER TABLE `geo_country`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `geo_departement`
--
ALTER TABLE `geo_departement`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `geo_district`
--
ALTER TABLE `geo_district`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `geo_region`
--
ALTER TABLE `geo_region`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item`
--
ALTER TABLE `item`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_abuse`
--
ALTER TABLE `item_abuse`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_buying`
--
ALTER TABLE `item_buying`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_category`
--
ALTER TABLE `item_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_deleted`
--
ALTER TABLE `item_deleted`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_favorite`
--
ALTER TABLE `item_favorite`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_image`
--
ALTER TABLE `item_image`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_material`
--
ALTER TABLE `item_material`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_origin`
--
ALTER TABLE `item_origin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_period`
--
ALTER TABLE `item_period`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_seo`
--
ALTER TABLE `item_seo`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_signature`
--
ALTER TABLE `item_signature`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_status`
--
ALTER TABLE `item_status`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `item_style`
--
ALTER TABLE `item_style`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `keyword`
--
ALTER TABLE `keyword`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `links_category`
--
ALTER TABLE `links_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `links_site`
--
ALTER TABLE `links_site`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `mag`
--
ALTER TABLE `mag`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `mag_category`
--
ALTER TABLE `mag_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `mass_mailing_template`
--
ALTER TABLE `mass_mailing_template`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `member`
--
ALTER TABLE `member`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `member_group`
--
ALTER TABLE `member_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `member_paypal`
--
ALTER TABLE `member_paypal`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `member_pro_type`
--
ALTER TABLE `member_pro_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `member_speciality`
--
ALTER TABLE `member_speciality`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `member_stat`
--
ALTER TABLE `member_stat`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `member_type`
--
ALTER TABLE `member_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `message_archive`
--
ALTER TABLE `message_archive`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `newsletter`
--
ALTER TABLE `newsletter`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `news_post`
--
ALTER TABLE `news_post`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `news_post_country`
--
ALTER TABLE `news_post_country`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `news_subscriber`
--
ALTER TABLE `news_subscriber`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `op`
--
ALTER TABLE `op`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `op_comment`
--
ALTER TABLE `op_comment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_duration`
--
ALTER TABLE `order_duration`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_invoice`
--
ALTER TABLE `order_invoice`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_item`
--
ALTER TABLE `order_item`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_member_rib`
--
ALTER TABLE `order_member_rib`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_offer`
--
ALTER TABLE `order_offer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_offer_duration`
--
ALTER TABLE `order_offer_duration`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_payment`
--
ALTER TABLE `order_payment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `order_payment_type`
--
ALTER TABLE `order_payment_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `organic_csv`
--
ALTER TABLE `organic_csv`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `organic_table`
--
ALTER TABLE `organic_table`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `paypal_payment`
--
ALTER TABLE `paypal_payment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `rel_fair_date`
--
ALTER TABLE `rel_fair_date`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `rel_item_category`
--
ALTER TABLE `rel_item_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `rel_member_fair`
--
ALTER TABLE `rel_member_fair`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `rel_member_speciality`
--
ALTER TABLE `rel_member_speciality`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `semrush`
--
ALTER TABLE `semrush`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `sf_guard_group`
--
ALTER TABLE `sf_guard_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `sf_guard_permission`
--
ALTER TABLE `sf_guard_permission`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `sf_guard_user`
--
ALTER TABLE `sf_guard_user`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `sf_guard_user_profile`
--
ALTER TABLE `sf_guard_user_profile`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `shipping_type`
--
ALTER TABLE `shipping_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `syndic`
--
ALTER TABLE `syndic`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `translation`
--
ALTER TABLE `translation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `wishlist`
--
ALTER TABLE `wishlist`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

