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




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

--
-- 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 table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`id`);

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

