-- Rev number (Mandatory)
SET @revNum = 505;
SET @issue = "issue-31b-es";

-- ------------------------------------------------
-- Begin SQL
-- ------------------------------------------------
-- COTE SITES WEB FR SEULEMENT !!!!!
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


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

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

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

--
-- Structure de la table `vz_assurance_produits`
--

-- Note: When no specification, columns are NULL DEFAULT NULL by default
CREATE TABLE `vz_assurance_produits` (
  `uid` int(11) NOT NULL,
  `parent_uid` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `parent_class` varchar(50) NOT NULL DEFAULT '',
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `hidden` tinyint(1) NOT NULL DEFAULT 0,
  `sorting` int(11) NOT NULL DEFAULT 0,
  `creation_date` datetime(6) NOT NULL,
  `modification_date` datetime(6) NOT NULL,
  `creator_uid` int(11) DEFAULT 0,
  `creator_class` varchar(50) NOT NULL DEFAULT '',
  `modificator_uid` int(11) DEFAULT 0,
  `modificator_class` varchar(50) DEFAULT NULL,
  `edit_lock` int(11) NOT NULL DEFAULT 0,
  `editor_uid` int(11) DEFAULT 0,
  `editor_class` varchar(50) DEFAULT NULL,
  `edit_start_time` datetime DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `language` varchar(5) NOT NULL,
  `alt_language` tinytext DEFAULT NULL,
  `history_last` mediumblob DEFAULT '',
  `history_past` longblob DEFAULT '',
  `title` VARCHAR(255) DEFAULT '',
  `subtitle` TEXT,
  `taux_achat` FLOAT,
  `taux_vente` FLOAT,
  `min_vente` FLOAT COMMENT 'EURO, minimum prix de vente',
  `id_assureur` SMALLINT UNSIGNED NOT NULL DEFAULT 1,
  `code_produit_assureur` VARCHAR(255),
  `code_formule_assureur` VARCHAR(255),
  `fichier_contrat` TEXT,
  `texte` TEXT,
  `enabled_date_from` date COMMENT 'date de début de validité',
  `enabled_date_to` date COMMENT 'date de fin de validité',
  `disp_ord` SMALLINT UNSIGNED NOT NULL DEFAULT 10,
  `ex_ref` VARCHAR(255)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Index pour la table `vz_assurance_produits`
--
ALTER TABLE `vz_assurance_produits`
  ADD PRIMARY KEY (`uid`),
  ADD KEY `k_dbrecord_language` (`language`),
  ADD KEY `k_dbrecord_cdate` (`creation_date`),
  ADD KEY `k_dbrecord_mdate` (`modification_date`),
  ADD KEY `k_dbrecord_deleted` (`deleted`),
  ADD KEY `k_dbrecord_sorting` (`sorting`),
  ADD KEY `k_dbrecord_parent` (`parent_uid`),
  ADD KEY `k_dbrecord_creator` (`creator_uid`);

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



--
-- AUTO_INCREMENT pour la table `vz_assurance_produits`
--
ALTER TABLE `vz_assurance_produits`
  MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;


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

-- ------------------------------------------------
-- End SQL
-- ------------------------------------------------

INSERT INTO `db_version` (`uid`, `major_version`, `minor_version`, `revision`, `Comment`, `date`)
 VALUES (NULL, '1', '1', @revNum, @issue, CURRENT_TIME());
COMMIT;
