-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 30, 2025 at 09:33 PM
-- Server version: 10.11.11-MariaDB
-- PHP Version: 8.3.19

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `wwwbattech_amethystdentalblogDB`
--

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `link`, `image`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'Banner One For Footer', 'https://www.google.com', '1666679560.jpg', 1, '2022-09-23 06:36:32', '2022-10-25 06:32:40');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_popular` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `is_popular`, `created_at`, `updated_at`) VALUES
(18, 'Driving License', 'driving-license', 1, '2024-07-02 15:06:27', '2024-07-02 15:06:27'),
(19, 'Defensive Driving', 'defensive-driving', 1, '2024-07-02 15:06:43', '2024-07-02 15:06:43'),
(20, 'Curriculum', 'curriculum', 1, '2024-07-02 15:06:54', '2024-07-02 15:06:54'),
(21, 'Brake & Avoid', 'brake-avoid', 1, '2024-07-02 15:07:07', '2024-07-02 15:07:07');

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

--
-- Table structure for table `category_setting`
--

CREATE TABLE `category_setting` (
  `id` int(11) NOT NULL,
  `setting_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `category_setting`
--

INSERT INTO `category_setting` (`id`, `setting_id`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2022-09-23 14:23:02', '2022-09-23 14:23:02');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `post_id` int(10) UNSIGNED NOT NULL,
  `body` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `body` text NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `is_popular` tinyint(1) NOT NULL DEFAULT 0,
  `is_trending` tinyint(1) NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `title`, `slug`, `image`, `body`, `user_id`, `category_id`, `is_popular`, `is_trending`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'Driving License', 'global-warmiong', '1719998662.jpg', '<h3>Getting your Driving License</h3>\r\n\r\n<p>In the province of Ontario, you need to be at least 16 years old in order to get a license. Beginning in April of 1994, the province of Ontario implemented graduated licensing. There are three steps that you need to do in order to get your license.<br />\r\n<br />\r\nin the beginning of the process, you will get a Driver&#39;s Handbook, which can be found in any bookstore, convenience shop, or MTO facility, in addition to several other places. After that, you may travel to the Ministry of Transportation office that is closest to you and take a theoretical G1 test on or after your sixteenth birthday, provided that you have read the handbook. You are needed to bring a total of $125.00 and two pieces of identification with you. If you are successful in passing the examination, you will be awarded a G1 license, and twelve months from that date, you will be qualified to take a practical road test.</p>\r\n\r\n<ul>\r\n	<li>You are need to fulfill a number of requirements in order to get a G1 license, all of which are intended to assist you in gaining experience prior to taking your road test.</li>\r\n	<li>Each and every time you are behind the wheel, you are required to be accompanied by a driver who has a minimum of four years of experience driving a G class vehicle.</li>\r\n	<li>Between the hours of twelve and five in the morning, you are not permitted to operate a motor vehicle.</li>\r\n	<li>Unless you are accompanied by a qualified driving teacher, you are not permitted to drive on any highways that have posted speed restrictions of 80 kilometers or more, including any of the 400 series highways. This restricts your ability to drive on these routes.</li>\r\n	<li>At all times, you are required to keep your blood alcohol level at a level of 0.00%.</li>\r\n	<li>You are not allowed to have more people in your vehicle than the number of seat belts for them.</li>\r\n	<li>The waiting time for your first road test may be reduced from 12 months to 8 months if you attend an authorized driving school like ours after you have obtained a G1 permit. This reduction is available to you if you complete the course. Following the conclusion of this time of waiting, you will be able to take your first road test.</li>\r\n</ul>', 1, 18, 1, 1, 1, '2022-08-15 12:26:33', '2024-07-03 13:24:22'),
(27, 'Brake & Avoid', 'brake-avoid', '1720000840.jpg', '<p>At Driving Educators in North York, Downtown Toronto and Etobicoke - we feel it is our responsibility to make sure that our students get the highest possible level of instruction throughout their time spent on the road for emergency and avoidant situations. Here&rsquo;s what we cover in this course:<br />\r\n&nbsp;</p>\r\n\r\n<p>Gravel Shoulder</p>\r\n\r\n<p>In the event that the car slides into a gravel shoulder, the student is required to understand how to recover and maintain control of the vehicle.<br />\r\n&nbsp;</p>\r\n\r\n<p>Avoiding Head-On Contact</p>\r\n\r\n<p>In this move, the students are taught how to avoid cars moving from the other lane into their lane. This technique is completely identical to the one described before. The learner will be able to prevent and avoid a contact with the head as a result of this.<br />\r\n&nbsp;</p>\r\n\r\n<p>The Avoidance of Rear Crash</p>\r\n\r\n<p>Students are instructed on how to react appropriately if they are going to be struck by a vehicle coming from behind. Additionally, they are encouraged to be mindful of their blind spots and to steer with their hands rather than their feet.<br />\r\n&nbsp;</p>\r\n\r\n<p>Attempts to Avoid Swerving</p>\r\n\r\n<p>When a student is taught how to react appropriately to an item that has just fallen into their path at a speed of forty kilometers per hour! There is a strong emphasis put on accurate steering and eyes ahead, with drivers always gazing into their space on the road and the direction in which they want to travel.<br />\r\n&nbsp;</p>\r\n\r\n<p>Emergency Stop with Threshold Braking and Anti-lock Braking System</p>\r\n\r\n<p>The goal of the method is to ensure that the student comes to a complete stop as quickly as possible by using the most effective braking technique without the brakes being locked. When you avoid locking the brakes, you will not only prevent the vehicle from skidding, but you will also be able to bring it to a stop more quickly and effectively.<br />\r\n<br />\r\nWhen performing this maneuver, students continue to use the threshold braking method. However, they are now approaching the object pylons at a quicker speed (60 kilometers per hour), and they will not be able to stop in time. As a result, in order to avoid colliding with the object, they must choose an escape route that is available at the moment (either left or right) and swerve.<br />\r\n<br />\r\nEvery one of our sessions is taught by a trained specialist. Even though the majority of the lesson will be taught in a parking lot with pylons serving as barriers in the path of drivers, the recovery of the gravel shoulder will only be done via the road when it is safe to do so.<br />\r\n<br />\r\nWe emphasize that every student should give serious consideration to the possibility of investing more time and money to acquire these processes since it has the potential to assist them in becoming a more careful driver.</p>', 1, 21, 1, 1, 1, '2024-07-03 14:00:40', '2024-07-03 14:00:49'),
(26, 'Defensive Driving', 'tst', '1719999457.jpg', '<p>The following is a concise synopsis of the major subjects that are addressed in the classroom theoretical component of all of our Full Defensive Driver Training Courses.</p>\r\n\r\n<p>1. Introduction and Fundamentals</p>\r\n\r\n<p>This section addresses several misunderstandings that are often held about driving in general and the daily scenarios that include traffic. Following the completion of this introductory portion, students should be familiar with all of the important material about the acquisition of a learner&#39;s license, as well as the fundamental foundation for the Smith System of Defensive Driving.<br />\r\n&nbsp;</p>\r\n\r\n<p>2. Safety</p>\r\n\r\n<p>In this discussion, we will cover safety measures like as seat belts, kid seats, airbags, and other safety equipment that, when utilized regularly, save lives.<br />\r\n&nbsp;</p>\r\n\r\n<p>3. The Smith System</p>\r\n\r\n<p>When it comes to defensive driver training programs, the Smith System is considered to be the industry standard. The &quot;Five Keys to Space Cushion Driving&quot; are the components that make up this. Enhancing driver perception to produce safer drivers, maintaining space around your car (no more &quot;traffic roulette&quot;), establishing excellent driving practices, developing good seeing habits, and enhancing driver visibility are all topics that are covered in this program which aims to improve driver visibility. Recognition, Perception, and Management of Hazards: Students learn to recognize hazards and explore strategies to control them so that they are no longer a threat to them while they are driving.<br />\r\n&nbsp;</p>\r\n\r\n<p>4. City Driving</p>\r\n\r\n<p>Merging and switching lanes, rights of way, uncontrolled junctions, pedestrian hazards, buses, parking, signaling, traffic congestion, traffic tempo, one-way streets, and traffic patterns are some of the topics that are discussed. In addition, the students examine and talk about a wide variety of other risks associated with driving in the neighborhood. Driving with gasoline economy: In the spirit of raising awareness about the environment, a conversation will be held about ways to drive cheaply and areas in which students may increase their economy in relation to their tires, brakes, gasoline, and various moving components can be discussed.<br />\r\n&nbsp;</p>\r\n\r\n<p>5. Roads Signs &amp; Traffic Controls</p>\r\n\r\n<p>The purpose of this lesson is to acquaint students with the many categories of road signs by providing them with an explanation of the forms and colors of road signs, as well as a thorough discussion of each individual sign and a brief video presentation. A discussion is also held on the repercussions that result from disobeying certain traffic signs.<br />\r\n&nbsp;</p>\r\n\r\n<p>6. Toxic Driving Conditions</p>\r\n\r\n<p>Students may learn how to drive more safely and successfully in a variety of settings, including weather, road conditions, night driving, and other scenarios, via discussion and instruction. Not only that, but we also go over techniques to handle unexpected emergencies that may arise while you are behind the wheel.<br />\r\n&nbsp;</p>\r\n\r\n<p>7. Driving on Freeways and Highways</p>\r\n\r\n<p>Entering and exiting freeways and highways in a secure manner are discussed for drivers. The usage of high-occupancy vehicle lanes is discussed in this section.<br />\r\n&nbsp;</p>\r\n\r\n<p>8. Driving While Impaired</p>\r\n\r\n<p>In addition to the duties that drivers have as road users, the impact of alcohol and drugs on a driver&#39;s skills, response times, and decision-making abilities are also taken into consideration.<br />\r\n&nbsp;</p>\r\n\r\n<p>9. Avoid Collisions</p>\r\n\r\n<p>The tactics for avoiding collisions and the abilities that are required to prevent placing yourself in a situation where you are at risk of being involved in a collision will be discussed in a lecture presentation and discussion. The students are taught to be proactive in their driving and to practice the See-Think-Do procedures, which are designed to keep them out of trouble in the first place.<br />\r\n&nbsp;</p>\r\n\r\n<p>10. Opinions of Drivers</p>\r\n\r\n<p>Students get an understanding of how their attitudes about driving are shaped by external factors such as peer pressure, advertising, and other factors, and they examine solutions to improve their driving attitudes.<br />\r\n&nbsp;</p>\r\n\r\n<p>11. The Road Test</p>\r\n\r\n<p>When it comes to the government road test, being prepared and feeling confident is essential. Every single one of the prerequisites for achieving achievement the very first time is met by us.<br />\r\n<br />\r\nWe teach a number of principles that might potentially save lives, trust in Driving Educators in the GTA to ensure your Defensive Driving training is impeccable and up to standard.</p>', 1, 19, 1, 0, 1, '2024-07-02 20:37:18', '2024-07-03 13:52:48');

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

--
-- Table structure for table `post_tag`
--

CREATE TABLE `post_tag` (
  `id` int(10) UNSIGNED NOT NULL,
  `post_id` int(10) UNSIGNED NOT NULL,
  `tag_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_tag`
--

INSERT INTO `post_tag` (`id`, `post_id`, `tag_id`, `created_at`, `updated_at`) VALUES
(84, 1, 59, '2024-07-02 15:19:07', '2024-07-02 15:19:07'),
(76, 23, 55, '2023-05-26 15:21:44', '2023-05-26 15:21:44'),
(78, 21, 24, '2023-05-26 15:24:14', '2023-05-26 15:24:14'),
(77, 21, 57, '2023-05-26 15:24:14', '2023-05-26 15:24:14'),
(79, 16, 55, '2023-05-26 15:26:23', '2023-05-26 15:26:23'),
(86, 26, 60, '2024-07-03 13:37:37', '2024-07-03 13:37:37'),
(83, 25, 58, '2023-07-27 09:25:33', '2023-07-27 09:25:33'),
(82, 18, 23, '2023-05-26 15:29:49', '2023-05-26 15:29:49'),
(81, 18, 55, '2023-05-26 15:29:49', '2023-05-26 15:29:49'),
(75, 22, 57, '2023-05-26 15:20:15', '2023-05-26 15:20:15'),
(74, 22, 56, '2023-05-26 15:20:15', '2023-05-26 15:20:15'),
(87, 27, 64, '2024-07-03 14:00:40', '2024-07-03 14:00:40'),
(80, 11, 56, '2023-05-26 15:28:09', '2023-05-26 15:28:09');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `popular_title` varchar(255) NOT NULL,
  `recent_title` varchar(255) NOT NULL,
  `category_title` varchar(255) NOT NULL,
  `popular_tags_title` varchar(255) NOT NULL,
  `footer_section` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `popular_title`, `recent_title`, `category_title`, `popular_tags_title`, `footer_section`, `created_at`, `updated_at`) VALUES
(1, 'POPULAR NEWS', 'Recent Post', 'Categories', 'Popular Tags', '<p><a href=\"https://www.allstardriving.ca/aboutus\">About Us</a> <a href=\"https://www.allstardriving.ca/defensive_driving\">Defensive Driving</a> <a href=\"https://www.allstardriving.ca/driving_license\">Driving License</a> <a href=\"https://www.allstardriving.ca/Curriculum\">Curriculum</a> <a href=\"\">Blog</a> <a href=\"https://www.allstardriving.ca/registration\">Registration</a> <a href=\"https://www.allstardriving.ca/packages\">Pricing</a> <a href=\"https://trubicars.ca/g1-practice-tests?affiliates=74&amp;acct=acct_1LgBk82EB5bTmJwm\">G1 Courses</a> <a href=\"https://www.allstardriving.ca/testimonials\">Testimonials</a> <a href=\"https://www.allstardriving.ca/schedule\">Schedule</a> <a href=\"https://www.allstardriving.ca/faq\">FAQ&#39;s</a> <a href=\"https://www.allstardriving.ca/locations\">Location</a></p>', NULL, '2023-05-26 13:40:39');

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

--
-- Table structure for table `setting_tag`
--

CREATE TABLE `setting_tag` (
  `id` int(11) NOT NULL,
  `setting_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_popular` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`id`, `name`, `slug`, `is_popular`, `created_at`, `updated_at`) VALUES
(60, 'Defensive Driving', 'defensive-driving', 1, '2024-07-02 15:07:51', '2024-07-02 15:07:51'),
(59, 'Driving License', 'driving-license', 1, '2024-07-02 15:07:40', '2024-07-02 15:07:40'),
(26, 'road safety', 'road-safety-3', 0, '2022-10-20 20:22:40', '2022-10-20 20:22:40'),
(28, 'environment', 'environment-2', 0, '2022-10-20 20:36:19', '2022-10-20 20:36:19'),
(63, 'test', 'test', 0, '2024-07-02 20:37:18', '2024-07-02 20:37:18'),
(64, 'Brake & Avoid', 'brake-avoid-2', 0, '2024-07-03 14:00:40', '2024-07-03 14:00:40'),
(33, 'new driver', 'new-driver-5', 0, '2022-10-20 20:38:45', '2022-10-20 20:38:45'),
(34, 'environment', 'environment-4', 0, '2022-10-20 20:58:07', '2022-10-20 20:58:07'),
(35, 'teen driver', 'teen-driver-6', 0, '2022-10-20 20:58:07', '2022-10-20 20:58:07'),
(36, 'car maintenance', 'car-maintenance-2', 0, '2022-10-20 20:58:07', '2022-10-20 20:58:07'),
(45, 'impaired driving', 'impaired-driving-2', 0, '2022-10-25 14:16:32', '2022-10-25 14:16:32'),
(51, 'adverse weather', 'adverse-weather-2', 0, '2022-10-28 16:47:05', '2022-10-28 16:47:05'),
(61, 'Curriculum', 'curriculum', 1, '2024-07-02 15:08:05', '2024-07-02 15:08:05'),
(62, 'Brake & Avoid', 'brake-avoid', 1, '2024-07-02 15:08:21', '2024-07-02 15:08:21');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `org_password` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `api_token` varchar(50) DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `reset_key` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `password`, `org_password`, `remember_token`, `created_at`, `updated_at`, `api_token`, `is_admin`, `reset_key`) VALUES
(1, 'Driving Educators', 'admin@admin.com', '$2y$10$H7FpPOPS.gv1VYyD0NlcleeQZ/JvXmthhhFHwLk.9mey3I5JrdfyK', 'Water@456', 'gFxAMRM0vhQVQMWCgQ1kDEjXBjgJIpBQCTp6XDum3KiGN2LtwzPh5Onqbjr2', '2022-08-15 12:21:56', '2024-07-02 14:51:04', 'Jc4nfxjHp1FDPk4axvcf9FSWb2tsVmGbHWNPzvkDJX2u51JOB5', 1, NULL),
(2, 'Sujit', 'ganguly.sugit@gmail.com', '$2y$10$nIhEW6z5NdYArQju2L3iWemnvTK4BchfKbUB.tN0s9uow.KIpCNia', 'Allstar@123', NULL, '2022-08-15 12:27:55', '2022-08-15 12:27:55', 'tBJKAXij8g4YFD0nlrS2pwPl2z7opQPMRfIlHwpUKYli7SY1hJ', 0, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`),
  ADD KEY `password_resets_token_index` (`token`);

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
