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

-- ------------------------------------------------
-- 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 */;

INSERT INTO vz_assurance_produits
(uid, parent_uid, parent_class, deleted, hidden, sorting, creation_date, modification_date, creator_uid, creator_class, modificator_uid, modificator_class, edit_lock, editor_uid, editor_class, edit_start_time, start_time, end_time, `language`, alt_language, history_last, history_past, title, subtitle, taux_achat, taux_vente, min_vente, id_assureur, code_produit_assureur, code_formule_assureur, fichier_contrat, texte, enabled_date_from, enabled_date_to, disp_ord, ex_ref)
VALUES(2, 0, '0', 0, 0, 0, '2024-02-23 15:09:50.029', '2024-02-26 14:31:40.430', 14, 'mfUser', 14, 'mfUser', 0, 0, '', '2024-02-26 13:31:07.000', NULL, NULL, 'fr', '', 0x613A303A7B7D, 0x613A303A7B7D, 'Multirisque', 'Je souscris le contrat "{title}" ({taux_vente}%):', 2.66, 4.9, 0.0, 1, '3965', '2868', 's:0:"";', 'Assistance-rapatriement + interruption séjour + bagages + annulation.', NULL, NULL, 10, 'Premium');
INSERT INTO vz_assurance_produits
(uid, parent_uid, parent_class, deleted, hidden, sorting, creation_date, modification_date, creator_uid, creator_class, modificator_uid, modificator_class, edit_lock, editor_uid, editor_class, edit_start_time, start_time, end_time, `language`, alt_language, history_last, history_past, title, subtitle, taux_achat, taux_vente, min_vente, id_assureur, code_produit_assureur, code_formule_assureur, fichier_contrat, texte, enabled_date_from, enabled_date_to, disp_ord, ex_ref)
VALUES(3, 0, '0', 0, 0, 0, '2024-02-23 15:12:56.912', '2024-02-26 14:31:54.751', 14, 'mfUser', 14, 'mfUser', 0, 0, '', '2024-02-26 13:31:41.000', NULL, NULL, 'fr', '', 0x613A303A7B7D, 0x613A303A7B7D, 'Multirisque carte bancaire', 'Je souscris le contrat "{title}" ({taux_vente}%):', 2.19, 3.5, 0.0, 1, '2513', '1926', 's:0:"";', 'Assistance + interruption séjour + bagages + annulation en complément de votre CB (uniquement pour un paiement avec une carte Mastercard de type Gold, Platinum, world Elite, ou Visa de type Premier ou Infinite. Cartes bancaires délivrées par une banque française uniquement).', NULL, NULL, 20, 'Premium_CB');
INSERT INTO vz_assurance_produits
(uid, parent_uid, parent_class, deleted, hidden, sorting, creation_date, modification_date, creator_uid, creator_class, modificator_uid, modificator_class, edit_lock, editor_uid, editor_class, edit_start_time, start_time, end_time, `language`, alt_language, history_last, history_past, title, subtitle, taux_achat, taux_vente, min_vente, id_assureur, code_produit_assureur, code_formule_assureur, fichier_contrat, texte, enabled_date_from, enabled_date_to, disp_ord, ex_ref)
VALUES(4, 0, '0', 0, 0, 0, '2024-02-23 15:15:46.392', '2024-02-26 14:32:06.268', 14, 'mfUser', 14, 'mfUser', 0, 0, '', '2024-02-26 13:31:55.000', NULL, NULL, 'fr', '', 0x613A303A7B7D, 0x613A303A7B7D, 'Multirisque + covid', 'Je souscris le contrat "{title}" ({taux_vente}%):', 3.61, 5.4, 0.0, 1, '3959', '2865', 's:0:"";', 'idem "Multirisque" + annulation ou refus d''embarquement ou refus d''entrée sur le territoire pour cause de test positif + frais hôteliers en cas de quarantaine obligatoire.', NULL, NULL, 30, 'Multi_COV');
INSERT INTO vz_assurance_produits
(uid, parent_uid, parent_class, deleted, hidden, sorting, creation_date, modification_date, creator_uid, creator_class, modificator_uid, modificator_class, edit_lock, editor_uid, editor_class, edit_start_time, start_time, end_time, `language`, alt_language, history_last, history_past, title, subtitle, taux_achat, taux_vente, min_vente, id_assureur, code_produit_assureur, code_formule_assureur, fichier_contrat, texte, enabled_date_from, enabled_date_to, disp_ord, ex_ref)
VALUES(5, 0, '0', 0, 0, 0, '2024-02-23 15:17:05.143', '2024-02-26 14:32:15.862', 14, 'mfUser', 14, 'mfUser', 0, 0, '', '2024-02-26 13:32:07.000', NULL, NULL, 'fr', '', 0x613A303A7B7D, 0x613A303A7B7D, 'Annulation + covid', 'Je souscris le contrat "{title}" ({taux_vente}%):', 2.27, 3.5, 0.0, 1, '3947', '2859', 's:0:"";', 'Idem "Multirisque + Covid" sans l''assistance-rapatriement-responsabilité civile et sans l''interruption de séjour et d''activité.', NULL, NULL, 40, 'Annulation_COV');
INSERT INTO vz_assurance_produits
(uid, parent_uid, parent_class, deleted, hidden, sorting, creation_date, modification_date, creator_uid, creator_class, modificator_uid, modificator_class, edit_lock, editor_uid, editor_class, edit_start_time, start_time, end_time, `language`, alt_language, history_last, history_past, title, subtitle, taux_achat, taux_vente, min_vente, id_assureur, code_produit_assureur, code_formule_assureur, fichier_contrat, texte, enabled_date_from, enabled_date_to, disp_ord, ex_ref)
VALUES(6, 0, '0', 0, 0, 0, '2024-02-23 15:18:38.630', '2024-02-26 14:32:27.598', 14, 'mfUser', 14, 'mfUser', 0, 0, '', '2024-02-26 13:32:17.000', NULL, NULL, 'fr', '', 0x613A303A7B7D, 0x613A303A7B7D, 'Assistance-rapatriement-responsabilité civile + Covid', 'Je souscris le contrat "{title}" ({taux_vente}%):', 1.02, 1.6, 0.0, 1, '3955', '2863', 's:0:"";', 'idem "Multirisque + Covid" sans les garanties d''annulation et sans l''interruption de séjour et d''activité.', NULL, NULL, 50, 'Rapatriement_COV');



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

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