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

START TRANSACTION;



--
-- Database: `api-project`
--

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) NOT NULL,
  `address1` text NOT NULL,
  `address2` text NOT NULL,
  `cityname` varchar(250) NOT NULL,
  `clientname` varchar(250) NOT NULL,
  `companyname` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `faxnumber` varchar(250) NOT NULL,
  `mobilenumber` varchar(250) NOT NULL,
  `phonenumber` varchar(250) NOT NULL,
  `postcode` varchar(250) NOT NULL,
  `province` varchar(250) NOT NULL,
  `timezone` varchar(250) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `courtesycard`
--

CREATE TABLE `courtesycard` (
  `id` int(15) NOT NULL,
  `card_no` varchar(15) NOT NULL,
  `customer_id` varchar(50) NOT NULL,
  `calls` varchar(15) NOT NULL,
  `card_type` varchar(50) NOT NULL,
  `card_vaild` varchar(15) NOT NULL,
  `status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `courtesycard`
--

INSERT INTO `courtesycard` (`id`, `card_no`, `customer_id`, `calls`, `card_type`, `card_vaild`, `status`, `created_at`, `updated_at`) VALUES
(8, '285003', '37', '10', 'Monthly', '1', 1, '2021-10-07 02:26:16', '2021-10-07 02:26:16'),
(9, '285004', '37', '10', 'Monthly', '1', 1, '2021-10-07 02:26:36', '2021-10-29 08:03:21'),
(10, '285005', '37', '10', 'Monthly', '1', 1, '2021-10-07 02:26:52', '2021-10-07 02:26:52'),
(11, '285006', '38', '10', 'Monthly', '1', 1, '2021-10-07 02:27:12', '2021-10-07 02:27:12'),
(12, '285007', '38', '6', 'Weekly', '1', 1, '2021-10-07 02:27:36', '2021-11-23 01:21:37');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `managepage`
--

CREATE TABLE `managepage` (
  `id` bigint(20) NOT NULL,
  `page_content` longtext NOT NULL,
  `pheader` text NOT NULL,
  `ptitle` longtext NOT NULL,
  `slug` varchar(250) NOT NULL,
  `ch_main_menu` tinyint(4) NOT NULL DEFAULT 0,
  `main_menu_name` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL,
  `deleted_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `managepage`
--

INSERT INTO `managepage` (`id`, `page_content`, `pheader`, `ptitle`, `slug`, `ch_main_menu`, `main_menu_name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(3, '<p><strong>2. Narrative Type of Paragraph</strong>: In simple words, this type of paragraph narrates a story that includes a sequence of topic sentences like a clear start, middle of the topic, an end to the paragraph.</p>', 'manage faq', 'header page', 'tuytu', 1, 'ytutyuty', '2021-10-21 05:54:32', '2021-10-29 13:34:59', '2021-10-21 11:24:32'),
(4, '<h4>1. Topic Sentence</h4><ul><li><strong>What is the topic sentence?</strong> The topic sentence is the first sentence in a paragraph.</li><li><strong>What does it do?</strong> It introduces the main idea of the paragraph.</li><li><strong>How do I write one?</strong>', 'markating123', 'footer page', '', 0, '', '2021-10-21 05:55:45', '2021-10-21 13:43:42', '2021-10-21 11:25:45'),
(5, '<ul><li><strong>What is the closing sentence?</strong> The closing sentence is the last sentence in a paragraph.</li><li><strong>What does it do?</strong> It restates the main idea of your paragraph.</li><li><strong>How do I write one?</strong> Restate the main idea of the paragraph using different words.</li></ul>', 'first test', 'middle page', '', 0, '', '2021-10-21 08:03:25', '2021-10-21 13:33:25', '2021-10-21 13:33:25'),
(6, '<h4>1. Topic Sentence</h4><ul><li><strong>What is the topic sentence?</strong> The topic sentence is the first sentence in a paragraph.</li><li><strong>What does it do?</strong> It introduces the main idea of the paragraph.</li><li><strong>How do I write one?</strong> Summarize the main idea of your paragraph. Make clear what your Paragraph will be about.</li></ul><h4>2. Supporting Details</h4><ul><li><strong>What are the supporting sentences?</strong> They come after the topic sentence, making up the body of a paragraph.</li><li><strong>What do they do?</strong> They give details to develop and support the main idea of the paragraph.</li><li><strong>How do I write them?</strong> You should give supporting facts, details, and examples</li></ul><h4>3. Closing Sentence</h4><ul><li><strong>What is the closing sentence?</strong> The closing sentence is the last sentence in a paragraph.</li><li><strong>What does it do?</strong> It restates the main idea of your paragraph.</li><li><strong>How do I write one?</strong> Restate the main idea of the paragraph using different words.</li></ul>', 'test all case', 'content', '', 0, '', '2021-10-21 08:22:45', '2021-10-21 13:52:45', '2021-10-21 13:52:45'),
(7, '<h2><strong>test case</strong></h2>', '12112', 'sfdsfsf', '', 0, '', '2021-10-21 09:42:26', '2021-10-21 15:12:26', '2021-10-21 15:12:26'),
(8, 'sdfsdfsdfd', 'retret', 'ertertert', '', 0, '', '2021-10-22 00:18:13', '2021-10-22 05:48:13', '2021-10-22 05:48:13'),
(9, '<p>hhhhhhh</p>', 'fffffffff', 'ggggggggggg', '', 0, '', '2021-10-22 02:18:25', '2021-10-22 07:48:25', '2021-10-22 07:48:25'),
(10, '<p>A paragraph is a series of sentences that are organized and coherent, and are all related to a single topic. Almost every piece of writing you do that is longer than a few sentences should be organized into paragraphs</p>', 'overview', 'overview page', 'http://www.overview', 1, 'overview manu', '2021-10-22 09:20:53', '2021-10-22 14:50:53', '2021-10-22 14:50:53'),
(11, 'qweqweqweqwe', 'weqweqweqw', 'qqweqwewqe', 'qweqwe', 1, ' ', '2021-10-22 09:50:10', '2021-10-22 15:44:08', '2021-10-22 15:20:10');

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

--
-- Table structure for table `manage_faq`
--

CREATE TABLE `manage_faq` (
  `id` bigint(20) NOT NULL,
  `faq_answer` text DEFAULT NULL,
  `faq_question` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `manage_faq`
--

INSERT INTO `manage_faq` (`id`, `faq_answer`, `faq_question`, `created_at`, `updated_at`) VALUES
(10, 'ewrewr232', 'ewrwer', '2021-10-28 06:36:48', '2021-10-28 06:36:48'),
(11, 'ewrewr232', 'ewrwer', '2021-10-28 06:36:48', '2021-10-28 06:36:48'),
(12, '33333333', 'aaaaaaa22', '2021-10-28 06:36:48', '2021-10-28 06:36:48'),
(13, '33333333', 'aaaaaaa22', '2021-10-28 06:36:48', '2021-10-28 06:36:48'),
(14, 'aaaaaa1111', 'aaaaaa222', '2021-10-28 06:38:37', '2021-10-28 06:38:37'),
(15, 'aaaaaa1111', 'aaaaaa222', '2021-10-28 06:38:37', '2021-10-28 06:38:37'),
(16, 'qqqqqqqqq', 'asasasaaaaaaaaaaaaaaaaa', '2021-10-28 06:38:37', '2021-10-28 07:45:54'),
(17, 'zzzzzzzzzzzzzzzzz', 'aaaaaaaaa', '2021-10-28 06:38:37', '2021-10-28 07:41:15'),
(18, '33333333333', '2222222', '2021-10-28 08:21:33', '2021-10-28 08:21:33'),
(19, '111222', '1111', '2021-10-28 14:42:17', '2021-10-28 14:42:17'),
(20, '333333', '2222222', '2021-10-28 14:42:17', '2021-10-28 14:42:17'),
(21, '555555', '55555', '2021-10-28 14:42:56', '2021-10-28 14:42:56'),
(22, '666666666', '6666666', '2021-10-28 14:42:56', '2021-10-28 14:42:56'),
(23, '888', '88888', '2021-10-28 14:47:55', '2021-10-28 14:47:55'),
(24, '99999999', '99999999', '2021-10-28 14:47:55', '2021-10-28 14:47:55'),
(25, '1111111111100000000000', '11111110000000', '2021-10-28 14:47:55', '2021-10-28 09:18:22'),
(26, '56565656', '56565656', '2021-10-28 15:03:31', '2021-10-28 15:03:31'),
(27, '6767676', '6767676', '2021-10-28 15:03:31', '2021-10-28 15:03:31'),
(28, 'gfhfgh', 'dfghfgh', '2021-10-29 13:37:14', '2021-10-29 13:37:14'),
(29, 'gfhfgh', 'dfghfgh', '2021-10-29 13:37:23', '2021-10-29 13:37:23'),
(30, 'trytry45', 'hfghfgh', '2021-10-29 13:37:23', '2021-10-29 13:37:23'),
(31, '4444444444', '55555', '2021-11-05 14:56:12', '2021-11-05 14:56:12'),
(32, '4333333333', '66666', '2021-11-05 14:56:37', '2021-11-05 14:56:37');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2021_09_01_233439_create_students_table', 1);

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `client` varchar(250) NOT NULL,
  `invoice_no` varchar(50) NOT NULL,
  `cheque` varchar(250) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `paid_status` varchar(250) NOT NULL,
  `date` varchar(250) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `client`, `invoice_no`, `cheque`, `amount`, `paid_status`, `date`, `created_at`, `updated_at`) VALUES
(1, 'petor', '10203', '5874', '1000', 'paid', '2021-10-15', '2021-10-15 11:16:35', '2021-10-15 09:19:35'),
(2, 'john', '10220', '5421', '2000', 'paid', '', '2021-10-15 11:38:28', '2021-10-15 11:38:28');

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

--
-- Table structure for table `permit_type`
--

CREATE TABLE `permit_type` (
  `id` int(11) NOT NULL,
  `user_id` int(15) NOT NULL,
  `lot_no` int(50) NOT NULL,
  `thirtyday` varchar(50) DEFAULT NULL,
  `month_permit` varchar(50) DEFAULT NULL,
  `twentyfourhour` varchar(50) DEFAULT NULL,
  `day_permit` varchar(50) DEFAULT NULL,
  `hourly` varchar(50) DEFAULT NULL,
  `hourly_permit` varchar(50) DEFAULT NULL,
  `allday` varchar(50) DEFAULT NULL,
  `allday_permit_amount` varchar(50) DEFAULT NULL,
  `allday_permit` varchar(50) DEFAULT NULL,
  `alldaytime` varchar(50) DEFAULT NULL,
  `overnight` varchar(50) DEFAULT NULL,
  `overnight_permit_amount` varchar(50) DEFAULT NULL,
  `overnight_permit` varchar(50) DEFAULT NULL,
  `overnighttime` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `permit_type`
--

INSERT INTO `permit_type` (`id`, `user_id`, `lot_no`, `thirtyday`, `month_permit`, `twentyfourhour`, `day_permit`, `hourly`, `hourly_permit`, `allday`, `allday_permit_amount`, `allday_permit`, `alldaytime`, `overnight`, `overnight_permit_amount`, `overnight_permit`, `overnighttime`, `created_at`, `updated_at`) VALUES
(1, 33, 77777777, '30 Days', '567567', 'false', NULL, NULL, 'fdgdfg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-09-20 09:44:42', '2021-09-20 09:44:42'),
(2, 33, 77777777, '30 Days', '567567', 'false', NULL, NULL, 'dfgdfgdfg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-09-21 00:01:57', '2021-09-21 00:01:57'),
(4, 34, 88888, '30 Days', '4564', '24 Hours Permit', '456546', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`id`, `name`) VALUES
(1, 'admin'),
(2, 'user');

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) 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 `students`
--

INSERT INTO `students` (`id`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, 'aaaaaaa', 'bbbbbbbbbbb', '2021-09-06 02:32:26', '2021-09-06 02:32:26');

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

--
-- Table structure for table `viewpermit`
--

CREATE TABLE `viewpermit` (
  `id` int(11) NOT NULL,
  `lot_no` int(50) NOT NULL,
  `permit_type` varchar(250) NOT NULL,
  `payment_type` varchar(250) NOT NULL,
  `permit_no` varchar(50) NOT NULL,
  `plate_no` varchar(50) NOT NULL,
  `Address‎` text NOT NULL,
  `Phone No` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `viewpermit`
--

INSERT INTO `viewpermit` (`id`, `lot_no`, `permit_type`, `payment_type`, `permit_no`, `plate_no`, `Address‎`, `Phone No`, `created_at`, `updated_at`) VALUES
(1, 10200, 'OverNight', 'SC927533', '4566', '96352', '2584 RUGBY ROAD, MISSISSAUGA', '98745632102', '2021-10-13 13:19:13', '2021-10-13 13:19:13'),
(2, 10201, 'OverNight', 'SC927544', '3453', '2343', '2584 RUGBY ROAD', '6857412453', '2021-10-13 13:19:13', '2021-10-13 13:19:13');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

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

--
-- Indexes for table `viewpermit`
--
ALTER TABLE `viewpermit`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `lot_no` (`lot_no`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `managepage`
--
ALTER TABLE `managepage`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `manage_faq`
--
ALTER TABLE `manage_faq`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

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

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

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

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

