-- https://www.phpmyadmin.net/
--




--
-- Database: `travelshift_microsite`
--

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

--
-- Table structure for table `access_tokens`
--

CREATE TABLE `access_tokens` (
  `id` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `token` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `sent` int(11) NOT NULL,
  `used` tinyint(1) NOT NULL,
  `created_time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `access_tokens`
--

INSERT INTO `access_tokens` (`id`, `active`, `token`, `email`, `sent`, `used`, `created_time`) VALUES
(16, 0, '490238c838acf786ac7da5f2d8b599f3', 'simon.bruno.77@gmail.com', 0, 0, 1564408529),
(17, 0, '96c878da6a7d791f3406dda31c707c92', 'simon.bruno.77@gmail.com', 1, 0, 1564410680),
(18, 1, '6ecb1ebb1b150cc4087fb41ceb8d56dd', 'simon.bruno.77@gmail.com', 0, 1, 1564419638),
(19, 1, '61a1ad12eb83858013f3511eb38d0dd4', 'simon.bruno.77@gmail.com', 1, 0, 1564419641),
(20, 1, '669dc08c8e0fc560d950eb560497a553', 'simon.bruno.77@gmail.com', 1, 0, 1564419966),
(21, 1, '0c5ecd130c3091a954ecd049c45103fc', 'simon.bruno.77@gmail.com', 1, 0, 1564482695),
(22, 1, 'bf7149d1faccd3cb71f3971170655d56', 'simon.bruno.77@gmail.com', 1, 0, 1564494378),
(23, 1, 'f51354a88157bdaf31c60a185dcda033', 'simon.bruno.77@gmail.com', 0, 0, 1564494392),
(24, 1, '4b4972152aa37f7739b813ce0e67cf60', 'simon.bruno.77@gmail.com', 0, 0, 1564494403),
(25, 1, 'e780cb247c39fbb30dcce554cd9b31a4', 'simon.bruno.77@gmail.com', 1, 0, 1564501747),
(26, 1, '4ea9bc1f93f9aad15b2a38d46e7f8e95', 'simon.bruno.77@gmail.com', 1, 0, 1564501796),
(27, 1, 'c41c86ebd57b5dc720fc12803391b050', 'simon.bruno.77@gmail.com', 1, 0, 1564501803),
(28, 1, 'f5095431a5d83854ec848d71b3e9581c', 'simon.bruno.77@gmail.com', 1, 0, 1564501872),
(29, 1, 'd7aa75dca1c60db4aaa0edad76cef67b', 'simon.bruno.77@gmail.com', 1, 0, 1564501918),
(30, 1, '7317bc99ef26dc400c37500ae85b758f', 'simon.bruno.77@gmail.com', 1, 0, 1564501928),
(31, 1, '1717af1123d0952d2821dafffc87b7f9', 'simon.bruno.77@gmail.com', 1, 0, 1564501980),
(32, 1, 'ed3789c8e78e2cb2a7ad8da06eb6ec44', 'damien@immersive-g.com', 0, 0, 1564667617),
(33, 1, '560a478bdbb60030993aa2d2dac25a7e', 'simon.bruno.77@gmail.com', 1, 0, 1564667767),
(34, 1, '1340de2683737dc2117c3fe1e80acb1b', 'simon.bruno.77@gmail.com', 1, 0, 1564667787);

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

--
-- Table structure for table `cookie_tokens`
--

CREATE TABLE `cookie_tokens` (
  `id` int(11) NOT NULL,
  `id_access_token` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `token` varchar(255) NOT NULL,
  `used_count` int(11) NOT NULL,
  `created_time` int(11) NOT NULL,
  `last_used_time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cookie_tokens`
--

INSERT INTO `cookie_tokens` (`id`, `id_access_token`, `active`, `token`, `used_count`, `created_time`, `last_used_time`) VALUES
(2, 21, 1, 'd99b1411ed9ccda6e26878b3cb1340d0', 7, 1564489473, 0),
(3, 21, 1, '77cb5fd91eaf33c682927c95c6b73e92', 0, 1564489475, 0),
(4, 21, 1, 'f12ecde4b3427c7eee221b8335754d74', 0, 1564489475, 0),
(5, 21, 1, 'dc326c9a35d665cedb9acba30d2f15b2', 0, 1564489476, 0),
(6, 21, 1, '5c56464775de87a8d54a907466847ca0', 0, 1564489577, 0),
(7, 16, 0, '8a436319c3ac873703d4681d92434160', 11, 1564490274, 1564493178),
(8, 17, 1, '92350727e38e9b8ca3d54400676d74a9', 0, 1564491884, 0),
(9, 18, 1, 'c3a5066115ffe93d82c7fa40763be0fa', 0, 1564491916, 0);

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` int(11) NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8 NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `value` text CHARACTER SET utf8 NOT NULL,
  `legend` text CHARACTER SET utf8 NOT NULL,
  `priority` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`id`, `slug`, `type`, `name`, `value`, `legend`, `priority`) VALUES
(1, 'invitation_email_template', 'textarea', 'Invitation email template', 'Hello,\r\n\r\nHere\'s your invitation to the TravelShift microsite:\r\n<a href=\"[link]\">[link]</a>', '[link] will be replaced by the invitation link', 9),
(2, 'sender_email', 'email', 'Sender email', 'bruno@immersive-g.com', 'Will be used as sender email for invitation emails', 5),
(3, 'sender_name', 'text', 'Sender name', 'Bruno SIMON', 'Will be used as sender name for invitation emails', 4),
(4, 'invitation_email_subject', 'text', 'Invitation email subject', 'Invitation', '', 10),
(5, 'request_email_subject', 'text', 'Request email subject', 'Request', '', 8),
(6, 'request_email_template', 'textarea', 'Request email template', 'Hello,\r\n\r\nSome users request access to the TravelShift microsite:\r\n\r\n[emails]', '[emails] will be replaced by the emails list', 7);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `access_tokens`
--
ALTER TABLE `access_tokens`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cookie_tokens`
--
ALTER TABLE `cookie_tokens`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `access_tokens`
--
ALTER TABLE `access_tokens`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `cookie_tokens`
--
ALTER TABLE `cookie_tokens`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `options`
--
ALTER TABLE `options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

