# +----------------------------------------------------------------------+
# | Copyright (c) 2004-2011 Advisto SAS, service PEEL - contact@peel.fr  |
# +----------------------------------------------------------------------+
# | This file is part of PEEL Modules 6.0,  which is subject to an       |
# | opensource commercial license: you are allowed to customize the code |
# | for your own needs, but you are NOT entitled to distribute this file |
# | More information: http://www.peel.fr/lire/licence-commerciale-71.html|
# +----------------------------------------------------------------------+
# | Author: Advisto SAS, RCS 479 205 452, France, http://www.peel.fr/    |
# +----------------------------------------------------------------------+
# $Id: peel_premium.sql 13370 2011-01-01 21:22:20Z gboussin $
#



--
-- Structure de la table `peel_affiliation`
--

CREATE TABLE IF NOT EXISTS `peel_affiliation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre_fr` varchar(255) NOT NULL default '',
  `texte_fr` mediumtext NOT NULL,
  `date_insere` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_maj` datetime NOT NULL default '0000-00-00 00:00:00',
  `titre_en` varchar(255) NOT NULL default '',
  `texte_en` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Contenu de la table `peel_affiliation`
--

INSERT INTO `peel_affiliation` (`id`, `titre_fr`, `texte_fr`, `date_insere`, `date_maj`, `titre_en`, `texte_en`) VALUES
(1, 'Conditions d''affiliation', 'A remplir par le commerçant', '0000-00-00 00:00:00', '2010-05-24 22:55:37', 'Affiliate condition', 'Please, fill your affiliate condition');

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

--
-- Structure de la table `peel_alertes`
--

CREATE TABLE IF NOT EXISTS `peel_alertes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_produit` int(11) NOT NULL default '0',
  `id_utilisateur` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `nom_produit` varchar(255) NOT NULL default '',
  `datestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Contenu de la table `peel_alertes`
--

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

--
-- Structure de la table `peel_cadeaux`
--

CREATE TABLE IF NOT EXISTS `peel_cadeaux` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference` varchar(255) NOT NULL default '',
  `titre_fr` varchar(255) NOT NULL default '',
  `texte_fr` mediumtext NOT NULL,
  `titre_en` varchar(255) NOT NULL default '',
  `texte_en` mediumtext NOT NULL,
  `image1` varchar(255) NOT NULL default '',
  `on_special` tinyint(4) NOT NULL default '0',
  `date_insere` date NOT NULL default '0000-00-00',
  `date_maj` date NOT NULL default '0000-00-00',
  `lang` varchar(2) NOT NULL default '',
  `points` int(11) NOT NULL default '0',
  `etat` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `name` (`titre_fr`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Contenu de la table `peel_cadeaux`
--

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

-- Ajout de champs spécifiques à PEEL Modules
ALTER TABLE `peel_categories` ADD `promotion` FLOAT( 15, 5 ) NOT NULL ;

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

-- Ajout de champs spécifiques à PEEL Modules
ALTER TABLE `peel_commandes_articles` ADD `listcadeaux_owner` int(8);

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

--
-- Structure de la table `peel_commandes_cadeaux`
--

CREATE TABLE IF NOT EXISTS `peel_commandes_cadeaux` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL default '0',
  `nom_cadeau` varchar(255) NOT NULL default '',
  `points_cadeau` int(11) NOT NULL default '0',
  `adresse_client` varchar(255) NOT NULL,
  `date_commande` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(2) NOT NULL default '',
  `site_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Contenu de la table `peel_commandes_cadeaux`
--

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

--
-- Contenu de la table `peel_devises`
--

INSERT INTO `peel_devises` (`id`, `devise`, `conversion`, `symbole`, `symbole_place`, `code`, `etat`) VALUES
(2, 'CH Fr. Suisse', 1.41987, 'Fr', 1, 'CHF', 0),
(3, 'US Dollar', 1.21553, '$', 0, 'USD', 0),
(4, 'CA Dollar', 1.27708, '$', 0, 'CAD', 0),
(5, 'JP Yen', 110.56900, '¥', 1, 'JPY', 0),
(6, 'GB Pound', 0.83554, '£', 1, 'GBP', 0);

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

--
-- Structure de la table `peel_download`
--

CREATE TABLE IF NOT EXISTS `peel_download` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cle_acceptation` varchar(128) NOT NULL default '',
  `nom_fichier` varchar(64) NOT NULL default '',
  `o_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `a_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `commande_id` int(11) NOT NULL default '0',
  `produit_id` int(11) NOT NULL default '0',
  `etat` int(11) NOT NULL default '0',
  `on_delete` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Contenu de la table `peel_download`
--

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

--
-- Structure de la table `peel_faq`
--

CREATE TABLE IF NOT EXISTS `peel_faq` (
 `id` INT(11) NOT NULL AUTO_INCREMENT,
 `question_fr` mediumtext NOT NULL ,
 `question_en` mediumtext NOT NULL ,
 `answer_fr` mediumtext NOT NULL ,
 `answer_en` mediumtext NOT NULL ,
 `etat` TINYINT(1) NOT NULL,
 `position` INT(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


--
-- Contenu de la table `peel_faq`
--

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

--
-- Structure de la table `peel_forums`
--

CREATE TABLE IF NOT EXISTS `peel_forums` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL DEFAULT '',
  `corps` mediumtext NOT NULL,
  `id_cat` smallint(5) unsigned NOT NULL DEFAULT '0',
  `id_sujet` int(11) unsigned NOT NULL DEFAULT '0',
  `id_membre` int(11) unsigned NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `compteur` mediumint(7) unsigned NOT NULL DEFAULT '0',
  `post_it` enum('TRUE','FALSE') NOT NULL DEFAULT 'FALSE',
  `verrouillage` enum('TRUE','FALSE') NOT NULL DEFAULT 'FALSE',
  PRIMARY KEY (`id`),
  KEY `id_cat` (`id_cat`),
  KEY `id_sujet` (`id_sujet`),
  KEY `date_modif` (`date_modif`),
  KEY `id_membre` (`id_membre`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


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

--
-- Structure de la table `peel_forums_cat`
--

CREATE TABLE IF NOT EXISTS `peel_forums_cat` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `poids` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `id_cat2` smallint(5) unsigned NOT NULL DEFAULT '0',
  `nb_sujets` int(11) unsigned NOT NULL DEFAULT '0',
  `nb_reponses` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_cat2` (`id_cat2`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


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

--
-- Structure de la table `peel_forums_cat2`
--

CREATE TABLE IF NOT EXISTS `peel_forums_cat2` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


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

--
-- Structure de la table `peel_forums_suivis`
--

CREATE TABLE IF NOT EXISTS `peel_forums_suivis` (
  `id_forum` int(11) unsigned NOT NULL DEFAULT '0',
  `id_sujet` int(11) unsigned NOT NULL DEFAULT '0',
  `id_membre` int(11) unsigned NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY `id_sujet` (`id_sujet`,`id_membre`),
  KEY `id_membre` (`id_membre`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `peel_groupes`
--

CREATE TABLE IF NOT EXISTS `peel_groupes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) NOT NULL default '',
  `remise` float(10,2) NOT NULL default '0.00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Contenu de la table `peel_groupes`
--


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

--
-- Structure de la table `peel_lexique`
--

CREATE TABLE IF NOT EXISTS `peel_lexique` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `word_fr` VARCHAR( 255 ) NOT NULL ,
  `word_en` VARCHAR( 255 ) NOT NULL ,
  `definition_fr` mediumtext NOT NULL ,
  `definition_en` mediumtext NOT NULL ,
  `meta_title_fr` VARCHAR( 255 ) NOT NULL ,
  `meta_title_en` VARCHAR( 255 ) NOT NULL ,
  `meta_definition_fr` mediumtext NOT NULL ,
  `meta_definition_en` mediumtext NOT NULL ,
  `etat` TINYINT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


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

--
-- Structure de la table `peel_listecadeau`
--

CREATE TABLE IF NOT EXISTS `peel_listecadeau` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_produit` int(11) NOT NULL default '0',
  `id_utilisateur` int(11) NOT NULL default '0',
  `date_insertion` date NOT NULL default '0000-00-00',
  `quantite` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


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

--
-- Structure de la table `peel_parrain`
--

CREATE TABLE IF NOT EXISTS `peel_parrain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre_fr` varchar(255) NOT NULL default '',
  `texte_fr` mediumtext NOT NULL,
  `date_insere` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_maj` datetime NOT NULL default '0000-00-00 00:00:00',
  `titre_en` varchar(255) NOT NULL default '',
  `texte_en` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Contenu de la table `peel_parrain`
--

INSERT INTO `peel_parrain` (`id`, `titre_fr`, `texte_fr`, `date_insere`, `date_maj`, `titre_en`, `texte_en`) VALUES
(1, 'Conditions de parrainage', 'A remplir par le commerçant', '0000-00-00 00:00:00', '2010-05-20 20:21:21', 'Sponsorship condition', 'Please, fill your sponsorship condition');

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

--
-- Structure de la table `peel_pensebete`
--

CREATE TABLE IF NOT EXISTS `peel_pensebete` (
	`id` int(11) NOT NULL AUTO_INCREMENT ,
	`id_produit` int(11) NOT NULL ,
	`id_utilisateur` int(11) NOT NULL ,
	`date_insertion` date NOT NULL ,
	PRIMARY KEY ( `id` )
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
--
-- Contenu de la table `peel_pensebete`
--

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

--
-- Structure de la table `peel_stocks`
--

CREATE TABLE IF NOT EXISTS `peel_stocks` (
  `produit_id` int(11) NOT NULL default '0',
  `taille_id` int(11) NOT NULL default '0',
  `couleur_id` int(11) NOT NULL default '0',
  `stock` int(11) NOT NULL default '0'
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Contenu de la table `peel_stocks`
--

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

--
-- Structure de la table `peel_stocks_temp`
--

CREATE TABLE IF NOT EXISTS `peel_stocks_temp` (
  `produit_id` int(11) NOT NULL default '0',
  `taille_id` int(11) NOT NULL default '0',
  `couleur_id` int(11) NOT NULL default '0',
  `stock` int(11) NOT NULL default '0',
  `o_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `produit_id` (`produit_id`),
  KEY `taille_id` (`taille_id`),
  KEY `couleur_id` (`couleur_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Contenu de la table `peel_stocks_temp`
--


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

-- Ajout de champs spécifiques à PEEL Modules
ALTER TABLE `peel_utilisateurs` ADD `giftlistname` VARCHAR(255);

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

-- FAIT après la version 5.71 :
# ALTER TABLE `peel_commandes_cadeaux` CHANGE `adresse_client` `adresse_client` VARCHAR( 255 ) NOT NULL ;
# ALTER TABLE `peel_affiliation` CHANGE `texte_fr` `texte_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_affiliation` CHANGE `texte_en` `texte_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_articles` CHANGE `texte_fr` `texte_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_articles` CHANGE `texte_en` `texte_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_categories` CHANGE `description_fr` `description_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_cgv` CHANGE `texte_fr` `texte_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_cgv` CHANGE `texte_en` `texte_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_contacts` CHANGE `texte_fr` `texte_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_contacts` CHANGE `texte_en` `texte_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_faq` CHANGE `answer_fr` `answer_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_faq` CHANGE `answer_en` `answer_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_legal` CHANGE `texte_fr` `texte_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_legal` CHANGE `texte_en` `texte_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_marques` CHANGE `description_fr` `description_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_marques` CHANGE `description_en` `description_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_parrain` CHANGE `texte_fr` `texte_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_parrain` CHANGE `texte_en` `texte_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_produits` CHANGE `descriptif_fr` `descriptif_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_produits` CHANGE `descriptif_en` `descriptif_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_produits` CHANGE `description_fr` `description_fr` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_produits` CHANGE `description_en` `description_en` MEDIUMTEXT NOT NULL ;
# ALTER TABLE `peel_rubriques` CHANGE `description_fr` `description_fr` MEDIUMTEXT NOT NULL ,
# ALTER TABLE `peel_rubriques` CHANGE `description_en` `description_en` MEDIUMTEXT NOT NULL ,
# ALTER TABLE `peel_sites` ADD `tag_analytics` TEXT NOT NULL default '' ;
# ALTER TABLE `peel_sites` ADD `site_suspended` ENUM('TRUE','FALSE') NOT NULL DEFAULT 'FALSE';
# ALTER TABLE `peel_sites` ADD `module_forum` tinyint(4) NOT NULL default '0';
# ALTER TABLE `peel_sites` ADD `module_giftlist` tinyint(4)  NOT NULL default '0';
# ALTER TABLE `peel_sites` ADD `allow_add_product_with_no_stock_in_cart` tinyint(4)  NOT NULL default '0';
# ALTER TABLE `peel_utilisateurs` ADD `giftlistname` VARCHAR(255);
# ALTER TABLE `peel_commandes_articles` ADD `listcadeaux_owner` int(8);
# ALTER TABLE `peel_categories` CHANGE `alpha` `alpha_fr` CHAR( 1 ) NOT NULL ;
# ALTER TABLE `peel_categories` ADD `alpha_en` CHAR( 1 ) NOT NULL AFTER `alpha_fr` ;
# ALTER TABLE `peel_categories` CHANGE `image` `image_fr` VARCHAR( 255 ) NOT NULL ;
# ALTER TABLE `peel_categories` ADD `image_en` VARCHAR( 255 ) NOT NULL AFTER `image_fr` ;
# ALTER TABLE `peel_produits` ADD `default_image` VARCHAR( 255 ) NOT NULL AFTER `description_en` ;
# ALTER TABLE `peel_produits` ADD `tab1_html_fr` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab2_html_fr` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab3_html_fr` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab4_html_fr` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab5_html_fr` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab6_html_fr` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab1_html_en` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab2_html_en` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab3_html_en` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab4_html_en` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab5_html_en` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab6_html_en` mediumtext NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab1_title_fr` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab2_title_fr` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab3_title_fr` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab4_title_fr` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab5_title_fr` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab6_title_fr` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab1_title_en` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab2_title_en` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab3_title_en` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab4_title_en` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab5_title_en` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `tab6_title_en` varchar(255) NOT NULL;
# ALTER TABLE `peel_produits` ADD `youtube_code` text NOT NULL AFTER `image10` ;
# ALTER TABLE `peel_produits_couleurs` ADD `default_image` VARCHAR( 255 ) NOT NULL AFTER `couleur_id` ;
# ALTER TABLE `peel_produits` ADD `youtube_code` TEXT NOT NULL ;
# ALTER TABLE `peel_sites` ADD `display_nb_product` TINYINT( 1 ) NOT NULL ;
# ALTER TABLE `peel_sites` ADD `module_captcha` TINYINT( 4 ) NOT NULL DEFAULT '0' AFTER `module_lot` ;
# ALTER TABLE `peel_sites` ADD `module_socolissimo` tinyint(4) NOT NULL default '0';
# CREATE TABLE IF NOT EXISTS `peel_forums` (
#  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
#  `titre` varchar(255) NOT NULL DEFAULT '',
#  `corps` text NOT NULL,
#  `id_cat` smallint(5) unsigned NOT NULL DEFAULT '0',
#  `id_sujet` int(11) unsigned NOT NULL DEFAULT '0',
#  `id_membre` int(11) unsigned NOT NULL DEFAULT '0',
#  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
#  `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
# `compteur` mediumint(7) unsigned NOT NULL DEFAULT '0',
#  `post_it` enum('TRUE','FALSE') NOT NULL DEFAULT 'FALSE',
#  `verrouillage` enum('TRUE','FALSE') NOT NULL DEFAULT 'FALSE',
#  PRIMARY KEY (`id`),
#  KEY `id_cat` (`id_cat`),
#  KEY `id_sujet` (`id_sujet`),
#  KEY `date_modif` (`date_modif`),
#  KEY `id_membre` (`id_membre`)
#  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
# CREATE TABLE IF NOT EXISTS `peel_forums_cat` (
#  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
#  `nom` varchar(255) NOT NULL DEFAULT '',
#  `description` varchar(255) NOT NULL DEFAULT '',
#  `poids` tinyint(4) unsigned NOT NULL DEFAULT '0',
#  `id_cat2` smallint(5) unsigned NOT NULL DEFAULT '0',
#  `nb_sujets` int(11) unsigned NOT NULL DEFAULT '0',
#  `nb_reponses` int(11) unsigned NOT NULL DEFAULT '0',
#  PRIMARY KEY (`id`),
#  KEY `id_cat2` (`id_cat2`)
#  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
# CREATE TABLE IF NOT EXISTS `peel_forums_cat2` (
#  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
#  `nom` varchar(255) NOT NULL DEFAULT '',
#  PRIMARY KEY (`id`)
#  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
# CREATE TABLE IF NOT EXISTS `peel_forums_suivis` (
#  `id_forum` int(11) unsigned NOT NULL DEFAULT '0',
#  `id_sujet` int(11) unsigned NOT NULL DEFAULT '0',
#  `id_membre` int(11) unsigned NOT NULL DEFAULT '0',
#  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
#  KEY `id_sujet` (`id_sujet`,`id_membre`),
#  KEY `id_membre` (`id_membre`)
#  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
# CREATE TABLE IF NOT EXISTS `peel_listecadeau` (
#  `id` int(11) NOT NULL auto_increment,
#  `id_produit` int(11) NOT NULL default '0',
#  `id_utilisateur` int(11) NOT NULL default '0',
#  `date_insertion` date NOT NULL default '0000-00-00',
#  `quantite` int(11) NOT NULL default '0',
#  PRIMARY KEY  (`id`)
#  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
# CREATE TABLE IF NOT EXISTS `peel_lexique` (
#	`id` INT( 11 ) NOT NULL ,
#	`word_fr` VARCHAR( 255 ) NOT NULL ,
#	`word_en` VARCHAR( 255 ) NOT NULL ,
#	`definition_fr` TEXT NOT NULL ,
#	`definition_en` TEXT NOT NULL ,
#	`meta_title_fr` VARCHAR( 255 ) NOT NULL ,
#	`meta_title_en` VARCHAR( 255 ) NOT NULL ,
#	`meta_definition_fr` mediumtext NOT NULL ,
#	`meta_definition_en` mediumtext NOT NULL ,
#	`etat` TINYINT( 4 ) NOT NULL DEFAULT '0'
#  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
# CREATE TABLE IF NOT EXISTS `peel_security_codes` (
#	`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
#	`code` varchar(5) NOT NULL DEFAULT '',
#	`time` int(11) unsigned NOT NULL DEFAULT '0',
#	PRIMARY KEY (`id`)
#  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
#CREATE TABLE IF NOT EXISTS `peel_modules` (
#  `id` int(11) NOT NULL,
#  `technical_code` VARCHAR( 255 ) NOT NULL,
#  `location` enum('G','D') NOT NULL,
#  `position` int(11) NOT NULL,
#  `etat` tinyint(1) NOT NULL
#) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


#INSERT INTO `peel_modules` (`id`, `technical_code`, `location`, `position`, `etat`) VALUES
#(1, 'G', 'G', 1, 1),
#(2, 'G', 'G', 2, 1),
#(3, 'G', 'G', 3, 1),
#(4, 'G', 'G', 4, 1),
#(5, 'G', 'D', 1, 1),
#(6, 'G', 'D', 2, 1),
#(7, 'G', 'D', 3, 1),
#(8, 'G', 'D', 4, 1),
#(9, 'G', 'D', 5, 1);



# ALTER TABLE `peel_marques` ADD `meta_titre_fr` VARCHAR( 255 ) NOT NULL ,
#  ADD `meta_titre_en` VARCHAR( 255 ) NOT NULL ,
#  ADD `meta_desc_fr` mediumtext NOT NULL ,
#  ADD `meta_desc_en` mediumtext NOT NULL ,
#  ADD `meta_key_fr` mediumtext NOT NULL ,
#  ADD `meta_key_en` mediumtext NOT NULL;
# ALTER TABLE `peel_marques` ADD `promotion` FLOAT( 15, 5 ) NOT NULL ,
#  ADD `promotion_type` TINYINT( 4 ) NOT NULL DEFAULT '0';
# ALTER TABLE `peel_categories` ADD `on_child` TINYINT( 4 ) NOT NULL ;
# ALTER TABLE `peel_sites` ADD `nb_on_top` INT( 11 ) NOT NULL DEFAULT '0',
#  ADD `act_on_top` TINYINT( 4 ) NOT NULL DEFAULT '0';
# ALTER TABLE `peel_paiement` ADD `technical_code` VARCHAR( 255 ) NOT NULL AFTER `module_lot` ;

# CREATE TABLE IF NOT EXISTS `peel_email_template` (
# `id` int(11) NOT NULL AUTO_INCREMENT,
#  `name` varchar(60) NOT NULL,
#  `subject` varchar(255) NOT NULL,
#  `text` text NOT NULL,
#  `lang` varchar(2) NOT NULL,
#  `active` enum('TRUE','FALSE') NOT NULL DEFAULT 'TRUE',
#  `id_cat` int(11) NOT NULL DEFAULT '0',
#  PRIMARY KEY (`id`)
# ) ENGINE=MyISAM  DEFAULT CHARSET=utf8  AUTO_INCREMENT=1;

#CREATE TABLE IF NOT EXISTS `peel_email_template_cat` (
#  `id` int(11) NOT NULL AUTO_INCREMENT,
#  `name_fr` varchar(255) NOT NULL,
#  `name_en` varchar(255) NOT NULL,
#  PRIMARY KEY (`id`)
#) ENGINE=MyISAM  DEFAULT CHARSET=utf8  AUTO_INCREMENT=1;


# ALTER TABLE `peel_sites` ADD `small_order_limit` FLOAT( 15, 5 ) NOT NULL DEFAULT '0',
#  ADD `small_order_overcost_amount` FLOAT( 15, 5 ) NOT NULL DEFAULT '0',
#  ADD `tva_percent` FLOAT( 5, 2 ) NOT NULL DEFAULT '0';

# ALTER TABLE `peel_commandes` ADD `small_order_overcost_amount` FLOAT( 15, 5 ) NOT NULL DEFAULT '0';

# CREATE TABLE IF NOT EXISTS `peel_import_field` (
#  `champs` varchar(255) NOT NULL,
#  `etat` tinyint(4) NOT NULL,
#  `texte` varchar(255) NOT NULL
# ) ENGINE=MyISAM DEFAULT CHARSET=utf8;