PhpMyNewsLetter 2.0

X-Firefox-Spdy: h2
access-control-allow-origin: *
cache-control: no-store, no-cache, must-revalidate
content-type: application/json
date: Sun, 08 Dec 2019 18:15:52 GMT
expires: Thu, 19 Nov 1981 08:52:00 GMT
pragma: no-cache
server: nginx
vary: Host
x-powered-by: PHP/7.1.33

Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Encoding: gzip, deflate, br
Accept-Language: fr,fr-FR;q=0.8,en-US;q=0.5,en;q=0.3
Connection: keep-alive
DNT: 1
Host: numismativy.fr
Referer: https://numismativy.fr/newsletter/index.php?page=compose&token=e3c6eb640de6c38ac28662c5cc12c6efbad73d8f9a5f300a785e71626f2c84affd288849c81a1bcf1dec02270f871c3dfda6ae72809b939faaf2a5ddd2351cde&list_id=14&op=init
TE: Trailers
Upgrade-Insecure-Requests: 1
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:71.0) Gecko/20100101 Firefox/71.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;