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

START TRANSACTION;



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

--
-- Table structure for table `admin_roles`
--

CREATE TABLE `admin_roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1: Super user, 0: General User',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_roles`
--

INSERT INTO `admin_roles` (`id`, `title`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 1, '2019-02-26 21:28:03', NULL),
(2, 'Admin', 0, '2019-02-26 21:28:03', NULL);

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

--
-- Table structure for table `admin_role_admin_user`
--

CREATE TABLE `admin_role_admin_user` (
  `id` int(10) UNSIGNED NOT NULL,
  `admin_role_id` int(10) UNSIGNED NOT NULL,
  `admin_user_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_role_admin_user`
--

INSERT INTO `admin_role_admin_user` (`id`, `admin_role_id`, `admin_user_id`, `created_at`, `updated_at`) VALUES
(1, 2, 1, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(2, 1, 2, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(3, 2, 3, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(4, 1, 4, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(5, 2, 5, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(6, 1, 6, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(7, 1, 7, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(8, 1, 8, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(9, 2, 9, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(10, 1, 10, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(11, 1, 11, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(12, 2, 12, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(13, 1, 13, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(14, 2, 14, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(15, 2, 15, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(16, 2, 16, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(17, 2, 17, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(18, 1, 18, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(19, 2, 19, '2019-02-26 21:28:06', '2019-02-26 21:28:06'),
(20, 2, 20, '2019-02-26 21:28:06', '2019-02-26 21:28:06');

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

--
-- Table structure for table `email_hooks`
--

CREATE TABLE `email_hooks` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=active, 0=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `email_preferences`
--

CREATE TABLE `email_preferences` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `layout_html` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_preferences`
--

INSERT INTO `email_preferences` (`id`, `title`, `layout_html`, `created_at`, `updated_at`) VALUES
(1, 'Main Layout', '<html>\r\n<head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /></head>\r\n<body><div>\r\n<table align=\"center\" cellpadding=\"0\" cellspacing=\"0\" style=\"border:1px solid #dddddd;\" width=\"650\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<table cellpadding=\"0\" cellspacing=\"0\" style=\"background:#ffffff; border-bottom:1px solid #dddddd; padding:15px;\" width=\"100%\">\r\n				<tbody>\r\n					<tr>\r\n						<td><a href=\"##BASE_URL##\" target=\"_blank\"><img alt=\"\" border=\"0\" src=\"##SYSTEM_LOGO##\" /></a></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"background:#ffffff; padding:15px;\">\r\n			<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n				<tbody>\r\n					<tr>\r\n						<td style=\"font-family:\'Trebuchet MS\', Arial, Helvetica, sans-serif; color:#000000; font-size:16px;\">\r\n							##EMAIL_CONTENT##\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"font-family:\'Trebuchet MS\', Arial, Helvetica, sans-serif; color:#043f8d; font-size:16px; vertical-align:middle; text-align:left; padding-top:20px;\">\r\n						##EMAIL_FOOTER##\r\n						</td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"background:#043f8d; border-top:1px solid #dddddd; text-align:center; font-family:\'Trebuchet MS\', Arial, Helvetica, sans-serif; color:#ffffff; padding:12px; font-size:12px; text-transform:uppercase; font-weight:normal;\">##COPYRIGHT_TEXT##</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n</body>\r\n</head>\r\n</html>', '2019-02-27 00:05:47', '2019-02-27 00:05:47');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int(10) UNSIGNED NOT NULL,
  `email_hook_id` int(10) UNSIGNED NOT NULL,
  `subject` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_preference_id` int(10) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=active, 0=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `email_hook_id`, `subject`, `description`, `footer_text`, `email_preference_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '##USER_NAME##, a very warm welcome to the ##SYSTEM_APPLICATION_NAME##', '<p>We&rsquo;re so happy to have you with us.</p>\r\n\r\n<p>Please click on the button below to confirm we got the right email address.</p>\r\n\r\n<p><a href=\"##VERIFY_LINK##\">VERIFY MY EMAIL</a></p>\r\n\r\n<p>Or copy and paste the link below.</p>\r\n\r\n<p>##VERIFY_LINK##</p>', 'Thanks and Regards,\r\n##SYSTEM_APPLICATION_NAME##', 1, 1, '2019-02-27 00:20:47', '2019-10-02 08:27:45'),
(2, 2, 'Reset Password Notification', '<h1 style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #2F3133; font-size: 19px; font-weight: bold; margin-top: 0; text-align: left;\">Hello!</h1>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\">You are receiving this email because we received a password reset request for your account.</p>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\"><a href=\"##RESET_PASSWORD_URL##\">Reset Password</a></p>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\">This password reset link will expire in 60 minutes.</p>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\">If you did not request a password reset, no further action is required.</p>', 'Thanks & Regards,\r\n##SYSTEM_APPLICATION_NAME##', 1, 1, '2019-02-27 00:21:52', '2019-02-27 00:21:52'),
(3, 5, 'New Password Notification', '<p>Hi ##USER_NAME##,</p>\r\n\r\n<p><br />\r\nYour New Password is ##PASSWORD##.</p>\r\n\r\n<p>Please use this password to login in the mobile app.</p>', 'Thanks & Regards,\r\n##SYSTEM_APPLICATION_NAME##', 1, 1, '2019-02-27 00:21:52', '2019-10-03 00:27:36'),
(4, 6, '##USER_NAME##, a very warm welcome to the ##SYSTEM_APPLICATION_NAME##', '<p>We&rsquo;re so happy to have you with us.</p>\r\n\r\n<p>Please click on the button below to confirm we got the right email address.</p>\r\n\r\n<p><a href=\"##VERIFY_LINK##\">VERIFY MY EMAIL</a></p>\r\n\r\n<p>Your auto generated password to login in mobile app is ##PASSWORD## </p>', 'Thanks and Regards,\r\n##SYSTEM_APPLICATION_NAME##', 1, 1, '2019-02-27 00:20:47', '2019-10-02 08:27:45'),
(5, 7, '##INQUIRY_SUBJECT##', '<p>Name : ##INQUIRY_NAME##<br />\r\nEmail : ##INQUIRY_EMAIL##<br />\r\nPhone : ##INQUIRY_PHONE##<br />\r\n<br />\r\nInquiry Message:<br />\r\n##INQUIRY_MESSAGE##</p>', 'Thanks and Regards,\r\n##SYSTEM_APPLICATION_NAME##', 1, 1, '2019-02-27 00:20:47', '2019-10-04 03:05:19');

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

--
-- Table structure for table `enquiries`
--

CREATE TABLE `enquiries` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `enquiries`
--

INSERT INTO `enquiries` (`id`, `name`, `email_address`, `mobile`, `message`, `created_at`, `updated_at`) VALUES
(1, 'asdasd', 'abc@yopmail.com', 'asdasd', 'asdasd', '2019-09-17 07:45:38', '2019-09-17 07:45:38'),
(2, 'asdasd', 'a@yopmail.com', NULL, 'asdasdasd', '2019-09-17 07:45:50', '2019-09-17 07:45:50'),
(3, 'asdadsasd', 'asdasd@yopmail.com', NULL, 'asdasdasd', '2019-09-17 07:49:18', '2019-09-17 07:49:18'),
(4, 'shyam', 'dadhich@yopmail.com', NULL, 'hii user', '2019-09-17 08:00:59', '2019-09-17 08:00:59');

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(10) UNSIGNED NOT NULL,
  `heading` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0=active, 1=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `heading`, `description`, `status`, `created_at`, `updated_at`) VALUES
(26, 'Lorem ipsum dolor sit amet, gubergren elaboraret eos ne, bonorum volumus interpretaris per ad.', '<p>Civibus quaerendum sit ei, usu errem quidam definitionem ut, pro quod scaevola inimicus cu. Ut integre legendos incorrupte ius. Sea saperet prodesset posidonium te, usu in numquam erroribus similique. Qui facilisi scribentur dissentiunt no, prima atomorum vulputate an vim, ei eam tale assueverit.</p>', 1, '2019-09-17 00:06:40', '2019-09-17 00:06:40'),
(27, 'Cum falli expetenda in, ad nam inani discere, ludus nominavi ea eum. Sed dico timeam scriptorem ne, mei veritus platonem interpretaris te, pro ne saepe copiosae facilisis.', '<p>Offendit vituperatoribus vix ne, postea dicunt tamquam mel no. Eum et docendi epicuri abhorreant, usu ea essent gloriatur necessitatibus, id ius solet graecis corpora. No nominavi interpretaris ius.</p>\r\n\r\n<p>Cum altera disputando at, ut augue ceteros democritum nam, malis cotidieque vel no. Cetero necessitatibus duo an, id fastidii epicurei abhorreant sit.</p>', 1, '2019-09-17 00:07:48', '2019-09-17 00:07:48'),
(28, 'Qui at ipsum efficiendi, nec nullam deseruisse reformidans eu. Vim erant dolorem ut, nec ut vide ludus.', '<p>Ut praesent salutandi est, eu mazim lobortis vel, ad eos errem nonumy luptatum. No duo ludus labitur volutpat. Ei eum dicant delicata, noster copiosae ei vim. No sea augue definiebas, et periculis temporibus vix. Saepe quidam percipitur ei vim, per conceptam neglegentur id. Has eu ridens appetere deseruisse, essent luptatum eu per. Mea viris invenire no, vel et meliore epicuri vulputate, at viderer lobortis vulputate sea.</p>', 1, '2019-09-17 00:08:08', '2019-09-17 00:08:08'),
(29, 'Mea id consul contentiones, in essent minimum adolescens vim. Ea eam stet iusto, sea an quaeque utroque percipitur, ea debet vocent mei. Sit audiam legimus deseruisse ea, ne mea appetere aliquando.', '<p><br />\r\nUt praesent salutandi est, eu mazim lobortis vel, ad eos errem nonumy luptatum. No duo ludus labitur volutpat. Ei eum dicant delicata, noster copiosae ei vim. No sea augue definiebas, et periculis temporibus vix. Saepe quidam percipitur ei vim, per conceptam neglegentur id. Has eu ridens appetere deseruisse, essent luptatum eu per. Mea viris invenire no, vel et meliore epicuri vulputate, at viderer lobortis vulputate sea.</p>', 1, '2019-09-17 00:08:36', '2019-09-17 00:08:36'),
(30, 'sdfsdf', '<p>sdfsdf</p>', 1, '2019-10-03 01:27:54', '2019-10-03 01:27:54');

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

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('01a28ffaebcf029660f84885b64ef83667c9807cbb27e121de093367b8bc036e609debe039ac05b0', 2, 1, 'Maxminpower', '[]', 0, '2019-09-30 08:57:42', '2019-09-30 08:57:42', '2020-09-30 14:27:42'),
('12f73060ad57ca2381669f43e94388c4aa9ef02aa84929423c1dd133512d6d471af45016a0a90c38', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:03:59', '2019-10-01 01:03:59', '2020-10-01 06:33:59'),
('1e29e6e57370f47868a103025ba66c8d0f613b494ad48101a8dfacb057441345f7a359a2c9cadf55', 2, 1, 'Maxminpower', '[]', 0, '2019-12-09 01:01:48', '2019-12-09 01:01:48', '2020-12-09 06:31:48'),
('1f407ad514d93724c99f63c9e3a8d1bac0c3923041a36698baf725441d026db3bac023d92eced550', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:10:52', '2019-10-01 01:10:52', '2020-10-01 06:40:52'),
('2059a209306282437b31f6491e5b01aa931de7447a0b27f623028dbc6a54f2a6728a62905871cf97', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 01:10:07', '2019-12-06 01:10:07', '2020-12-06 06:40:07'),
('27d901c11edbe58569b92fbf9a865109d5e253dc1a4f08046979ea01eb3b664be09aa47a0fa27a55', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:02:17', '2019-10-01 01:02:17', '2020-10-01 06:32:17'),
('301993d337e3e35190f33862da52d01f0a9f8fda0b90b7c2d23bccb3aca1116b6250568403002b3b', 2, 1, 'Maxminpower', '[]', 0, '2019-12-05 23:52:04', '2019-12-05 23:52:04', '2020-12-06 05:22:04'),
('3300652b7c738a6057cb0b4068d290ee9e9d965a8a19aae725955aae964c0e30a951488299ecea58', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:01:22', '2019-10-01 01:01:22', '2020-10-01 06:31:22'),
('3c76a10f2babff31810fd946bf5fad7ff969ba14a3b3939213186b329bbe0e347c1a93ed4aad1f73', 2, 1, 'Maxminpower', '[]', 0, '2019-10-01 04:25:17', '2019-10-01 04:25:17', '2020-10-01 09:55:17'),
('3ffd941db0d04cd410c29db9c414c4cf69409a89a0159a23b96dd9752f3384f8f1751d14c5fd348b', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 01:13:45', '2019-12-06 01:13:45', '2020-12-06 06:43:45'),
('41075ea153796fc761f4072ea05b556bf01a945d5fe7bb115aa31c1f3a8a136f1e0d0cbf43dedd28', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:00:22', '2019-10-01 01:00:22', '2020-10-01 06:30:22'),
('4ad460d7cec1457a263011503d8db8803f7ad52a9d9da8ad8d82018ad514e0d05c9c6153276c56d3', 2, 1, 'Maxminpower', '[]', 0, '2019-12-05 23:57:33', '2019-12-05 23:57:33', '2020-12-06 05:27:33'),
('62b15f9be81d284318125cf3cf5a884fde85f604e25cbd0567e40a2c0c0f74c1cda0c4511753609e', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:03:42', '2019-10-01 01:03:42', '2020-10-01 06:33:42'),
('7cd764213384abd0d05e92eb0fa027f64e18609ce25c7543aec0db743ec0a641fae812ffb5e92739', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:05:43', '2019-10-01 01:05:43', '2020-10-01 06:35:43'),
('7df8c5289a0ce353739ee002457dbbe0665158d86540450028ca48557caf6a2dce2742c49d2ce451', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 00:15:43', '2019-12-06 00:15:43', '2020-12-06 05:45:43'),
('7e0bc88a4548b7fba23abe581bff5d0e6dc26d7b6878b38adfc096a138866a05ff9e262e335612b8', 2, 1, 'Maxminpower', '[]', 0, '2019-12-09 00:54:59', '2019-12-09 00:54:59', '2020-12-09 06:24:59'),
('81f23e4c0b36afd65f9cdcdaf263563444f23225a90fd262c787b5a08df287f698d39b5dbfe3d1f2', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 00:41:35', '2019-12-06 00:41:35', '2020-12-06 06:11:35'),
('9e6851710f35324d29c197879b98a1e157499807842233a283ff01e617cef74ba27ea39306c5b412', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:00:46', '2019-10-01 01:00:46', '2020-10-01 06:30:46'),
('ab0af5b584a8de827b527a0ea05fb2f719b90f53bff7243eb329079fabbcdc4056466630dbb330f3', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:10:47', '2019-10-01 01:10:47', '2020-10-01 06:40:47'),
('bbdcf07e7c25d87f2b074492a83e9d3f2d66f9228dea5fd0f91d38700d86c440894178684793e921', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 00:45:39', '2019-12-06 00:45:39', '2020-12-06 06:15:39'),
('dc8ff78f7de17e248d9020ac6289552addf400ae76a078973b42f946d8ebb746b67f90a25c1e2bc6', 29, 1, 'Maxminpower', '[]', 0, '2019-10-01 01:03:54', '2019-10-01 01:03:54', '2020-10-01 06:33:54'),
('df754d428a4fcb263dc194f193033f1f034a34f7a88227dfebf92c97e01cc45886e34f8f6b4da5f5', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 00:14:16', '2019-12-06 00:14:16', '2020-12-06 05:44:16'),
('edd885b562c132b898c7a29fa39f6100a825abf8eb88ccc5bcd87768e4549fd716b8694764cc5374', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 00:24:50', '2019-12-06 00:24:50', '2020-12-06 05:54:50'),
('fd8c8e0a3c2c6c7568bc57950dedf5c2e4e2e8222834a8ece42de6935844fd74518cfc1c7f1aecce', 2, 1, 'Maxminpower', '[]', 0, '2019-12-06 00:02:18', '2019-12-06 00:02:18', '2020-12-06 05:32:18');

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2019-09-27 08:32:09', '2019-09-27 08:32:09');

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_title` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `banner` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_keyword` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=active, 0=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `sub_title`, `slug`, `short_description`, `description`, `banner`, `meta_title`, `meta_keyword`, `meta_description`, `status`, `created_at`, `updated_at`) VALUES
(6, 'Monthly', 'Monthly', 'monthly-2', 'Monthly', '<p>Monthly</p>', NULL, 'Monthly', 'Monthly', 'Monthly', 0, '2019-09-03 04:48:41', '2019-09-03 04:48:41'),
(7, 'Frequently Answer Question', 'faq', 'faq', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>', NULL, 'faq', 'faq', 'faq', 1, '2019-09-16 09:08:59', '2019-10-03 01:48:42'),
(8, 'Terms and Conditions', 'Terms and Conditions', 'terms-conditions', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>', NULL, 'Terms and Conditions', 'Terms and Conditions', 'Terms and Conditions', 1, '2019-09-16 23:30:36', '2019-10-03 01:48:28'),
(9, 'test test', 'test', 'test', 'test', '<p>test</p>', NULL, 'test', 'test', 'test', 0, '2019-09-17 01:52:34', '2019-09-17 01:52:34'),
(10, 'test test', 'test test', 'test-test', 'test test', '<p>test test</p>', NULL, 'test test', 'test test', 'test test', 0, '2019-09-17 01:53:26', '2019-09-17 01:53:26'),
(11, 'Contact Us', 'Contact Us', 'contact-us', 'Contact Us', '<p>Contact Us</p>', NULL, 'Contact Us', 'Contact Us', 'Contact Us', 1, '2019-09-17 01:54:17', '2019-09-17 01:54:17'),
(12, 'About Us', 'About Us', 'about-us', 'About Us', '<div>\r\n<h2>What is Lorem Ipsum?</h2>\r\n\r\n<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n</div>\r\n\r\n<div>\r\n<h2>Why do we use it?</h2>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for &#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n</div>\r\n\r\n<p>&nbsp;</p>', NULL, 'About Us', 'About Us', 'About Us', 1, '2019-09-17 23:31:58', '2019-10-03 01:11:35');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `config_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `manager` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
  `id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `address` varchar(200) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sites`
--

INSERT INTO `sites` (`id`, `title`, `address`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Dotsquares Parking', 'Dotsquares jhalana office, near door darshan kentra jaipur', '1', '2019-12-06 04:07:53', '2019-12-06 06:06:52'),
(3, 'Albert Hall', 'Albert Hall parking jaipur', '1', '2019-12-06 04:47:34', '2019-12-09 00:05:03');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(10) UNSIGNED NOT NULL,
  `author` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=active, 1=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `author`, `designation`, `description`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Govind Singh', 'Software Developer', '<p>Software DeveloperSoftware DeveloperSoftware DeveloperSoftware DeveloperSoftware Developer</p>', NULL, 1, '2019-09-03 07:15:42', '2019-09-03 07:15:42'),
(2, 'Govind Singh', 'Software Developer', '<p>Software Developer 1221</p>', 'author-1567517895.png', 0, '2019-09-03 07:15:58', '2019-09-03 08:08:15'),
(3, 'Govind Singh', 'Software Developer', '<p>tester</p>', NULL, 1, '2019-09-03 07:19:28', '2019-09-03 07:19:28'),
(4, 'weewe', 'ewewee', '<p>wewe</p>', 'author-1567517882.png', 1, '2019-09-03 08:05:54', '2019-09-03 08:08:02'),
(5, 'wwwwwwww', 'wwwwwwww', '<p>wwwwwwwwwwww</p>', 'author-1567518322.png', 1, '2019-09-03 08:15:22', '2019-09-03 08:15:22'),
(6, 'test', 'testimg', '<p>test</p>', 'author-1567658355.jpg', 1, '2019-09-04 23:09:15', '2019-09-04 23:09:15'),
(7, 'tet', 'test', '<p>rtyrty</p>', 'author-1568093618.jpg', 0, '2019-09-10 00:03:38', '2019-09-10 00:03:38');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL,
  `vehical_no` varchar(20) NOT NULL,
  `description` longtext,
  `status` enum('0','1') NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` (`id`, `user_id`, `site_id`, `vehical_no`, `description`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 1, 'RJ14GS2003', 'bike stand in without permission', '1', '2019-12-06 06:59:55', '2019-12-06 12:49:09', NULL),
(2, 0, 3, 'RJ14GS2001', 'parking car without permission', '1', '2019-12-06 07:18:45', '2019-12-06 07:18:45', NULL),
(8, 0, 1, 'Multi', 'Multi Image', '1', '2019-12-07 00:53:49', '2019-12-07 00:53:49', NULL),
(9, 0, 1, 'asdfs', 'sdfasdfds', '0', '2019-12-07 02:44:26', '2019-12-07 02:44:26', NULL),
(10, 0, 1, 'edsfadf', 'sdafsdf', '1', '2019-12-09 00:05:20', '2019-12-09 00:05:20', NULL),
(11, 2, 3, 'RJ14GS2003', 'vehical stand on illigal parking', '0', '2019-12-09 01:20:17', '2019-12-09 01:20:17', NULL),
(12, 2, 3, 'RJ14GS2003', 'vehical stand on illigal parking', '0', '2019-12-09 01:21:01', '2019-12-09 01:21:01', NULL),
(13, 2, 3, 'RJ14GS2003', 'vehical stand on illigal parking', '0', '2019-12-09 01:32:46', '2019-12-09 01:32:46', NULL),
(14, 2, 3, 'RJ14GS2003', 'vehical stand on illigal parking', '0', '2019-12-09 01:59:37', '2019-12-09 01:59:37', NULL);

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

--
-- Table structure for table `ticket_images`
--

CREATE TABLE `ticket_images` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `image_title` longtext NOT NULL,
  `image` longtext NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ticket_images`
--

INSERT INTO `ticket_images` (`id`, `user_id`, `ticket_id`, `image_title`, `image`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 0, 7, 'Hydrangeas', 'Hydrangeas', '0', '2019-12-07 06:20:02', NULL, NULL),
(21, 0, 8, 'Chrysanthemum', 'Chrysanthemum-1575706365.jpg', '1', '2019-12-07 08:12:45', NULL, NULL),
(22, 0, 8, 'Desert', 'Desert-1575706365.jpg', '1', '2019-12-07 08:12:45', NULL, NULL),
(23, 0, 8, 'Hydrangeas', 'Hydrangeas-1575706365.jpg', '1', '2019-12-07 08:12:45', NULL, NULL),
(24, 0, 8, 'Jellyfish', 'Jellyfish-1575706365.jpg', '1', '2019-12-07 08:12:45', NULL, NULL),
(25, 0, 9, 'Chrysanthemum', 'Chrysanthemum-1575706466.jpg', '1', '2019-12-07 08:14:26', NULL, NULL),
(26, 0, 9, 'Desert', 'Desert-1575706466.jpg', '1', '2019-12-07 08:14:26', NULL, NULL),
(27, 0, 9, 'Hydrangeas', 'Hydrangeas-1575706466.jpg', '1', '2019-12-07 08:14:26', NULL, NULL),
(28, 0, 9, 'Jellyfish', 'Jellyfish-1575706466.jpg', '1', '2019-12-07 08:14:26', NULL, NULL),
(29, 0, 10, 'Koala', 'Koala-1575869720.jpg', '1', '2019-12-09 05:35:20', NULL, NULL),
(30, 0, 10, 'Lighthouse', 'Lighthouse-1575869720.jpg', '1', '2019-12-09 05:35:20', NULL, NULL),
(31, 0, 10, 'Penguins', 'Penguins-1575869720.jpg', '1', '2019-12-09 05:35:20', NULL, NULL),
(32, 2, 14, 'Penguins', 'Penguins-1575876577.jpg', '1', '2019-12-09 01:59:37', '2019-12-09 01:59:37', NULL);

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

--
-- Indexes for table `admin_role_admin_user`
--
ALTER TABLE `admin_role_admin_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_role_admin_user_admin_role_id_foreign` (`admin_role_id`),
  ADD KEY `admin_role_admin_user_admin_user_id_foreign` (`admin_user_id`);

--
-- Indexes for table `email_hooks`
--
ALTER TABLE `email_hooks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email_hooks_slug_unique` (`slug`);

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

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `email_templates_email_hook_id_foreign` (`email_hook_id`),
  ADD KEY `email_templates_email_preference_id_foreign` (`email_preference_id`);

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

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

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

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

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`);

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_slug_unique` (`slug`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_roles`
--
ALTER TABLE `admin_roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `admin_role_admin_user`
--
ALTER TABLE `admin_role_admin_user`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `email_hooks`
--
ALTER TABLE `email_hooks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `email_preferences`
--
ALTER TABLE `email_preferences`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `enquiries`
--
ALTER TABLE `enquiries`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `password_resets`
--
ALTER TABLE `password_resets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

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

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_role_admin_user`
--
ALTER TABLE `admin_role_admin_user`
  ADD CONSTRAINT `admin_role_admin_user_admin_role_id_foreign` FOREIGN KEY (`admin_role_id`) REFERENCES `admin_roles` (`id`),
  ADD CONSTRAINT `admin_role_admin_user_admin_user_id_foreign` FOREIGN KEY (`admin_user_id`) REFERENCES `admin_users` (`id`);

--
-- Constraints for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD CONSTRAINT `email_templates_email_hook_id_foreign` FOREIGN KEY (`email_hook_id`) REFERENCES `email_hooks` (`id`),
  ADD CONSTRAINT `email_templates_email_preference_id_foreign` FOREIGN KEY (`email_preference_id`) REFERENCES `email_preferences` (`id`);
COMMIT;

