PhpMyNewsLetter 2.0

-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le :  mar. 30 oct. 2018 à 18:55
-- Version du serveur :  10.1.36-MariaDB-1~jessie
-- Version de PHP :  5.6.38-0+deb8u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Base de données :  `*xxxxmabasexxx*`
--

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

--
-- Structure de la table `pmn2_track`
--

CREATE TABLE `pmn2_track` (
  `id` int(10) UNSIGNED NOT NULL,
  `hash` varchar(40) NOT NULL DEFAULT '',
  `subject` int(9) NOT NULL,
  `date` datetime NOT NULL,
  `open_count` smallint(3) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `browser` varchar(150) NOT NULL,
  `version` varchar(150) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `useragent` text NOT NULL,
  `devicetype` varchar(10) NOT NULL,
  `lat` decimal(10,8) NOT NULL,
  `lng` decimal(11,8) UNSIGNED NOT NULL,
  `city` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `region` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Index pour la table `pmn2_track`
--
ALTER TABLE `pmn2_track`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hash` (`hash`),
  ADD KEY `subject` (`subject`),
  ADD KEY `date` (`date`),
  ADD KEY `open_count` (`open_count`),
  ADD KEY `ip` (`ip`),
  ADD KEY `browser` (`browser`),
  ADD KEY `version` (`version`),
  ADD KEY `platform` (`platform`),
  ADD KEY `devicetype` (`devicetype`),
  ADD KEY `lat` (`lat`),
  ADD KEY `lng` (`lng`),
  ADD KEY `city` (`city`),
  ADD KEY `postal_code` (`postal_code`),
  ADD KEY `region` (`region`),
  ADD KEY `country` (`country`);

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

--
-- AUTO_INCREMENT pour la table `pmn2_track`
--
ALTER TABLE `pmn2_track`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;