-- http://www.phpmyadmin.net
--




--
-- Database: `sps`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_vehicle_types`()
BEGIN
  SELECT id, type FROM sps_vehicle_types;
END$$

DELIMITER ;

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

--
-- Table structure for table `sps_access_rights`
--

CREATE TABLE IF NOT EXISTS `sps_access_rights` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NOT NULL,
  `menu_id` bigint(20) NOT NULL,
  `action_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `combo` (`role_id`,`menu_id`,`action_id`),
  KEY `role_id` (`role_id`),
  KEY `menu_id` (`menu_id`),
  KEY `action_id` (`action_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=292 ;

--
-- Dumping data for table `sps_access_rights`
--

INSERT INTO `sps_access_rights` (`id`, `role_id`, `menu_id`, `action_id`, `created_by`, `updated_at`, `deleted_at`, `location_id`, `area_id`, `updated_by`, `created_at`) VALUES
(1, 1, 1, 1, 0, '2017-02-06 04:02:30', NULL, 0, 0, 0, '2017-02-06 04:02:30'),
(6, 1, 3, 1, 0, '2017-02-06 04:02:40', NULL, 0, 0, 0, '2017-02-06 04:02:40'),
(7, 1, 4, 1, 0, '2017-02-06 04:02:42', NULL, 0, 0, 0, '2017-02-06 04:02:42'),
(10, 1, 13, 1, 0, '2017-02-06 04:02:48', NULL, 0, 0, 0, '2017-02-06 04:02:48'),
(11, 1, 20, 1, 0, '2017-02-06 04:02:50', NULL, 0, 0, 0, '2017-02-06 04:02:50'),
(12, 1, 21, 1, 0, '2017-02-06 04:02:51', NULL, 0, 0, 0, '2017-02-06 04:02:51'),
(13, 1, 8, 1, 0, '2017-02-06 04:02:53', NULL, 0, 0, 0, '2017-02-06 04:02:53'),
(14, 1, 9, 1, 0, '2017-02-06 04:02:55', NULL, 0, 0, 0, '2017-02-06 04:02:55'),
(15, 1, 18, 1, 0, '2017-02-06 04:02:56', NULL, 0, 0, 0, '2017-02-09 11:20:07'),
(16, 1, 18, 2, 0, '2017-02-06 04:02:58', NULL, 0, 0, 0, '2017-02-09 11:20:12'),
(17, 1, 18, 3, 0, '2017-02-06 04:02:59', NULL, 0, 0, 0, '2017-02-09 11:20:16'),
(18, 1, 18, 4, 0, '2017-02-06 04:03:02', NULL, 0, 0, 0, '2017-02-09 11:20:20'),
(20, 1, 4, 2, 0, '2017-02-06 04:03:05', NULL, 0, 0, 0, '2017-02-06 04:03:05'),
(21, 1, 6, 2, 0, '2017-02-06 04:03:10', NULL, 0, 0, 0, '2017-02-10 06:54:41'),
(24, 1, 13, 2, 0, '2017-02-06 04:03:12', NULL, 0, 0, 0, '2017-02-06 04:03:12'),
(26, 1, 4, 3, 0, '2017-02-06 04:03:19', NULL, 0, 0, 0, '2017-02-06 04:03:19'),
(28, 1, 7, 3, 0, '2017-02-06 04:03:26', NULL, 0, 0, 0, '2017-02-06 04:03:26'),
(31, 1, 4, 4, 0, '2017-02-06 04:03:36', NULL, 0, 0, 0, '2017-02-06 04:03:36'),
(34, 1, 13, 4, 0, '2017-02-06 04:03:47', NULL, 0, 0, 0, '2017-02-06 04:03:47'),
(37, 1, 12, 1, 0, '2017-02-06 04:26:13', NULL, 0, 0, 0, '2017-02-06 04:26:13'),
(38, 1, 22, 1, 0, '2017-02-06 04:26:15', NULL, 0, 0, 0, '2017-02-06 04:26:15'),
(39, 1, 19, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-06 10:10:21'),
(41, 2, 1, 1, 0, '2017-02-06 23:51:46', NULL, 0, 0, 0, '2017-02-06 23:51:46'),
(42, 2, 11, 1, 0, '2017-02-06 23:51:48', NULL, 0, 0, 0, '2017-02-06 23:51:48'),
(43, 2, 2, 1, 0, '2017-02-06 23:51:49', NULL, 0, 0, 0, '2017-02-06 23:51:49'),
(44, 2, 3, 1, 0, '2017-02-06 23:51:50', NULL, 0, 0, 0, '2017-02-06 23:51:50'),
(45, 2, 4, 1, 0, '2017-02-06 23:51:51', NULL, 0, 0, 0, '2017-02-06 23:51:51'),
(46, 2, 6, 1, 0, '2017-02-06 23:51:51', NULL, 0, 0, 0, '2017-02-06 23:51:51'),
(47, 2, 13, 1, 0, '2017-02-06 23:51:55', NULL, 0, 0, 0, '2017-02-06 23:51:55'),
(48, 2, 18, 1, 0, '2017-02-06 23:52:00', NULL, 0, 0, 0, '2017-02-09 11:20:24'),
(49, 2, 8, 1, 0, '2017-02-06 23:52:02', NULL, 0, 0, 0, '2017-02-06 23:52:02'),
(50, 2, 22, 1, 0, '2017-02-06 23:52:05', NULL, 0, 0, 0, '2017-02-06 23:52:05'),
(51, 2, 12, 1, 0, '2017-02-06 23:52:06', NULL, 0, 0, 0, '2017-02-06 23:52:06'),
(52, 2, 9, 1, 0, '2017-02-06 23:52:08', NULL, 0, 0, 0, '2017-02-06 23:52:08'),
(53, 3, 1, 1, 0, '2017-02-07 07:30:07', NULL, 0, 0, 0, '2017-02-07 07:30:07'),
(54, 3, 3, 1, 0, '2017-02-07 07:30:10', NULL, 0, 0, 0, '2017-02-07 07:30:10'),
(55, 3, 11, 1, 0, '2017-02-07 07:30:13', NULL, 0, 0, 0, '2017-02-07 07:30:13'),
(56, 3, 2, 1, 0, '2017-02-07 07:30:14', NULL, 0, 0, 0, '2017-02-07 07:30:14'),
(57, 3, 2, 2, 0, '2017-02-07 07:30:15', NULL, 0, 0, 0, '2017-02-07 07:30:15'),
(58, 3, 2, 3, 0, '2017-02-07 07:30:16', NULL, 0, 0, 0, '2017-02-07 07:30:16'),
(59, 3, 2, 4, 0, '2017-02-07 07:30:17', NULL, 0, 0, 0, '2017-02-07 07:30:17'),
(60, 2, 2, 2, 0, '2017-02-07 07:30:31', NULL, 0, 0, 0, '2017-02-10 07:02:22'),
(70, 1, 17, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-09 11:20:38'),
(72, 1, 23, 1, 0, '2017-02-06 04:03:09', NULL, 0, 0, 0, '2017-02-06 04:03:09'),
(73, 1, 24, 1, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-06 04:02:46'),
(74, 1, 7, 1, 0, '2017-02-13 01:55:13', NULL, 0, 0, 0, '2017-02-13 01:55:13'),
(75, 1, 26, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-13 10:39:58'),
(76, 1, 27, 1, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(77, 1, 28, 1, 0, '2017-02-14 06:58:22', NULL, 0, 0, 0, '2017-02-14 06:58:22'),
(78, 1, 28, 2, 0, '2017-02-14 06:58:23', NULL, 0, 0, 0, '2017-02-14 06:58:23'),
(79, 1, 28, 3, 0, '2017-02-14 06:58:25', NULL, 0, 0, 0, '2017-02-14 06:58:25'),
(80, 1, 28, 4, 0, '2017-02-14 06:58:27', NULL, 0, 0, 0, '2017-02-14 06:58:27'),
(81, 1, 29, 1, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(83, 1, 29, 2, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(84, 1, 29, 3, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(85, 1, 29, 4, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(86, 1, 29, 5, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(87, 1, 30, 1, 0, '2017-02-15 04:19:27', NULL, 0, 0, 0, '2017-02-15 04:19:27'),
(88, 1, 30, 2, 0, '2017-02-15 04:19:31', NULL, 0, 0, 0, '2017-02-15 04:19:31'),
(89, 1, 27, 2, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(91, 1, 27, 4, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(92, 1, 27, 5, 0, '2017-02-06 04:02:46', NULL, 0, 0, 0, '2017-02-13 07:22:05'),
(93, 1, 30, 3, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-20 10:10:27'),
(94, 1, 30, 4, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-20 10:10:50'),
(95, 1, 31, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:48:33'),
(96, 1, 31, 4, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:48:54'),
(97, 1, 32, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:15'),
(98, 1, 32, 2, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:29'),
(99, 1, 32, 3, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:40'),
(101, 1, 33, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:15'),
(102, 1, 33, 2, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:29'),
(103, 1, 33, 3, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:40'),
(104, 1, 33, 4, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(105, 1, 31, 2, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 11:30:58'),
(110, 3, 6, 1, 0, '2017-03-16 01:35:28', NULL, 0, 0, 0, '2017-03-16 01:35:28'),
(111, 3, 13, 1, 0, '2017-03-16 01:35:31', NULL, 0, 0, 0, '2017-03-16 01:35:31'),
(112, 3, 7, 1, 0, '2017-03-16 01:35:33', NULL, 0, 0, 0, '2017-03-16 01:35:33'),
(113, 1, 38, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-03-02 10:46:22'),
(114, 1, 39, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(115, 1, 39, 2, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(116, 1, 39, 3, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(117, 1, 39, 4, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(118, 1, 40, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(119, 1, 40, 2, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(120, 1, 40, 3, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(121, 1, 40, 4, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(122, 1, 40, 5, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-02-21 05:49:58'),
(123, 1, 41, 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '2017-03-24 10:01:49'),
(124, 1, 42, 1, 0, '2017-03-25 04:09:35', NULL, 0, 0, 0, '2017-03-25 04:09:35'),
(125, 1, 42, 2, 0, '2017-03-25 04:09:37', NULL, 0, 0, 0, '2017-03-25 04:09:37'),
(126, 1, 42, 3, 0, '2017-03-25 04:09:37', NULL, 0, 0, 0, '2017-03-25 04:09:37'),
(127, 1, 42, 4, 0, '2017-03-25 04:09:38', NULL, 0, 0, 0, '2017-03-25 04:09:38'),
(128, 1, 42, 5, 0, '2017-03-25 04:09:40', NULL, 0, 0, 0, '2017-03-25 04:09:40'),
(129, 1, 8, 4, 0, '2017-03-25 04:09:51', '2017-03-25 04:09:51', 0, 0, 0, '2017-03-25 09:39:51'),
(135, 1, 32, 4, 0, '2017-03-28 00:35:26', NULL, 0, 0, 0, '2017-03-28 00:35:26'),
(136, 1, 7, 4, 0, '2017-03-28 06:03:29', NULL, 0, 0, 0, '2017-03-28 06:03:29'),
(139, 1, 43, 1, 0, '2017-04-03 08:47:37', NULL, 0, 0, 0, '2017-04-03 08:47:37'),
(140, 1, 43, 2, 0, '2017-04-03 08:47:38', NULL, 0, 0, 0, '2017-04-03 08:47:38'),
(141, 1, 43, 3, 0, '2017-04-03 08:47:39', NULL, 0, 0, 0, '2017-04-03 08:47:39'),
(142, 1, 43, 4, 0, '2017-04-03 08:47:40', NULL, 0, 0, 0, '2017-04-03 08:47:40'),
(143, 1, 44, 2, 0, '2017-04-06 01:13:07', NULL, 0, 0, 0, '2017-04-06 01:13:07'),
(144, 1, 44, 4, 0, '2017-04-06 01:13:09', NULL, 0, 0, 0, '2017-04-06 01:13:09'),
(145, 1, 45, 1, 0, '2017-04-07 06:56:19', NULL, 0, 0, 0, '2017-04-07 06:56:19'),
(146, 1, 45, 2, 0, '2017-04-07 06:56:21', NULL, 0, 0, 0, '2017-04-07 06:56:21'),
(147, 1, 45, 3, 0, '2017-04-07 06:56:22', NULL, 0, 0, 0, '2017-04-07 06:56:22'),
(148, 1, 45, 4, 0, '2017-04-07 06:56:24', NULL, 0, 0, 0, '2017-04-07 06:56:24'),
(149, 1, 2, 1, 0, '2017-04-08 02:52:03', NULL, 0, 0, 0, '2017-04-08 02:52:03'),
(150, 1, 2, 3, 0, '2017-04-08 02:52:40', NULL, 0, 0, 0, '2017-04-08 02:52:40'),
(152, 1, 2, 2, 0, '2017-04-08 02:53:30', NULL, 0, 0, 0, '2017-04-08 02:53:30'),
(157, 1, 33, 5, 0, '2017-04-10 02:35:10', NULL, 0, 0, 0, '2017-04-10 02:35:10'),
(158, 1, 2, 4, 0, '2017-04-13 01:06:55', NULL, 0, 0, 0, '2017-04-13 01:06:55'),
(159, 1, 46, 1, 0, '2017-04-13 01:23:16', NULL, 0, 0, 0, '2017-04-13 01:23:16'),
(160, 1, 34, 1, 0, '2017-04-13 01:23:18', NULL, 0, 0, 0, '2017-04-13 01:23:18'),
(161, 1, 47, 1, 0, '2017-04-13 01:23:20', NULL, 0, 0, 0, '2017-04-13 01:23:20'),
(162, 1, 47, 6, 0, '2017-04-13 01:23:22', NULL, 0, 0, 0, '2017-04-13 01:23:22'),
(163, 1, 48, 1, 0, '2017-04-13 04:23:06', NULL, 0, 0, 0, '2017-04-13 04:23:06'),
(165, 1, 49, 1, 0, '2017-04-13 04:25:49', NULL, 0, 0, 0, '2017-04-13 04:25:49'),
(166, 1, 49, 6, 0, '2017-04-13 04:25:50', NULL, 0, 0, 0, '2017-04-13 04:25:50'),
(167, 1, 50, 1, 0, '2017-04-13 05:29:11', NULL, 0, 0, 0, '2017-04-13 05:29:11'),
(168, 1, 50, 6, 0, '2017-04-13 05:29:13', NULL, 0, 0, 0, '2017-04-13 05:29:13'),
(170, 1, 51, 1, 0, '2017-04-14 06:09:47', NULL, 0, 0, 0, '2017-04-14 06:09:47'),
(171, 1, 51, 2, 0, '2017-04-14 06:09:49', NULL, 0, 0, 0, '2017-04-14 06:09:49'),
(172, 1, 51, 3, 0, '2017-04-14 06:09:51', NULL, 0, 0, 0, '2017-04-14 06:09:51'),
(173, 1, 51, 4, 0, '2017-04-14 06:09:52', NULL, 0, 0, 0, '2017-04-14 06:09:52'),
(174, 1, 53, 1, 0, '2017-04-17 05:16:13', NULL, 0, 0, 0, '2017-04-17 05:16:13'),
(175, 1, 52, 1, 0, '2017-04-17 05:16:14', NULL, 0, 0, 0, '2017-04-17 05:16:14'),
(176, 1, 52, 2, 0, '2017-04-18 07:31:47', NULL, 0, 0, 0, '2017-04-18 07:31:47'),
(177, 1, 54, 1, 0, '2017-04-18 08:39:36', NULL, 0, 0, 0, '2017-04-18 08:39:36'),
(178, 1, 55, 1, 0, '2017-04-19 04:40:42', NULL, 0, 0, 0, '2017-04-19 04:40:42'),
(179, 1, 56, 1, 0, '2017-04-19 04:40:45', NULL, 0, 0, 0, '2017-04-19 04:40:45'),
(180, 1, 56, 2, 0, '2017-04-19 04:40:45', NULL, 0, 0, 0, '2017-04-19 04:40:45'),
(181, 1, 27, 3, 0, '2017-04-19 04:40:49', NULL, 0, 0, 0, '2017-04-19 04:40:49'),
(182, 1, 56, 3, 0, '2017-04-19 04:40:50', NULL, 0, 0, 0, '2017-04-19 04:40:50'),
(183, 1, 56, 4, 0, '2017-04-19 04:40:52', NULL, 0, 0, 0, '2017-04-19 04:40:52'),
(184, 1, 57, 1, 0, '2017-04-20 00:32:41', NULL, 0, 0, 0, '2017-04-20 00:32:41'),
(185, 1, 58, 1, 0, '2017-04-20 07:17:45', NULL, 0, 0, 0, '2017-04-20 07:17:45'),
(186, 1, 59, 1, 0, '2017-04-20 07:22:13', NULL, 0, 0, 0, '2017-04-20 07:22:13'),
(187, 1, 60, 1, 0, '2017-04-20 07:22:17', NULL, 0, 0, 0, '2017-04-20 07:22:17'),
(188, 1, 40, 6, 0, '2017-04-27 01:19:26', NULL, 0, 0, 0, '2017-04-27 01:19:26'),
(189, 1, 61, 1, 0, '2017-05-12 05:04:44', NULL, 0, 0, 0, '2017-05-12 05:04:44'),
(193, 1, 62, 1, 0, '2017-05-19 10:02:16', NULL, 0, 0, 0, '2017-05-19 10:02:16'),
(194, 1, 63, 1, 0, '2017-05-19 10:02:18', NULL, 0, 0, 0, '2017-05-19 10:02:18'),
(195, 1, 64, 1, 0, '2017-05-19 10:02:19', NULL, 0, 0, 0, '2017-05-19 10:02:19'),
(196, 1, 62, 2, 0, '2017-05-19 10:02:21', NULL, 0, 0, 0, '2017-05-19 10:02:21'),
(197, 1, 64, 2, 0, '2017-05-19 10:02:22', NULL, 0, 0, 0, '2017-05-19 10:02:22'),
(198, 1, 64, 3, 0, '2017-05-19 10:02:23', NULL, 0, 0, 0, '2017-05-19 10:02:23'),
(199, 1, 63, 3, 0, '2017-05-19 10:02:24', NULL, 0, 0, 0, '2017-05-19 10:02:24'),
(200, 1, 62, 4, 0, '2017-05-19 10:02:25', NULL, 0, 0, 0, '2017-05-19 10:02:25'),
(201, 1, 63, 4, 0, '2017-05-19 10:02:26', NULL, 0, 0, 0, '2017-05-19 10:02:26'),
(202, 1, 64, 4, 0, '2017-05-19 10:02:28', NULL, 0, 0, 0, '2017-05-19 10:02:28'),
(203, 1, 64, 5, 0, '2017-05-19 10:02:29', NULL, 0, 0, 0, '2017-05-19 10:02:29'),
(204, 1, 63, 5, 0, '2017-05-19 10:02:30', NULL, 0, 0, 0, '2017-05-19 10:02:30'),
(205, 1, 62, 5, 0, '2017-05-19 10:02:31', NULL, 0, 0, 0, '2017-05-19 10:02:31'),
(206, 1, 62, 6, 0, '2017-05-19 10:02:32', NULL, 0, 0, 0, '2017-05-19 10:02:32'),
(207, 1, 63, 6, 0, '2017-05-19 10:02:32', NULL, 0, 0, 0, '2017-05-19 10:02:32'),
(208, 1, 64, 6, 0, '2017-05-19 10:02:33', NULL, 0, 0, 0, '2017-05-19 10:02:33'),
(210, 1, 63, 2, 0, '2017-05-19 10:06:00', NULL, 0, 0, 0, '2017-05-19 10:06:00'),
(211, 1, 62, 3, 0, '2017-05-19 10:06:01', NULL, 0, 0, 0, '2017-05-19 10:06:01'),
(212, 1, 67, 1, 0, '2017-05-19 10:07:58', NULL, 0, 0, 0, '2017-05-19 10:07:58'),
(213, 1, 67, 6, 0, '2017-05-19 10:08:06', NULL, 0, 0, 0, '2017-05-19 10:08:06'),
(214, 1, 66, 1, 0, '2017-05-20 12:57:35', NULL, 0, 0, 0, '2017-05-20 12:57:35'),
(215, 1, 66, 2, 0, '2017-05-20 12:57:36', NULL, 0, 0, 0, '2017-05-20 12:57:36'),
(216, 1, 66, 3, 0, '2017-05-20 12:57:37', NULL, 0, 0, 0, '2017-05-20 12:57:37'),
(217, 1, 66, 4, 0, '2017-05-20 12:57:38', NULL, 0, 0, 0, '2017-05-20 12:57:38'),
(218, 1, 68, 1, 0, '2017-05-20 12:57:39', NULL, 0, 0, 0, '2017-05-20 12:57:39'),
(220, 1, 14, 1, 0, '2017-05-26 05:43:43', NULL, 0, 0, 0, '2017-05-26 05:43:43'),
(221, 1, 36, 1, 0, '2017-05-26 05:44:20', NULL, 0, 0, 0, '2017-05-26 05:44:20'),
(222, 1, 37, 1, 0, '2017-05-26 05:44:20', NULL, 0, 0, 0, '2017-05-26 05:44:20'),
(224, 1, 35, 1, 0, '2017-05-26 05:44:46', NULL, 0, 0, 0, '2017-05-26 05:44:46'),
(225, 1, 25, 1, 0, '2017-06-09 10:52:46', NULL, 0, 0, 0, '2017-06-09 10:52:46'),
(226, 1, 69, 1, 0, '2017-06-09 10:53:04', NULL, 0, 0, 0, '2017-06-09 10:53:04'),
(228, 1, 69, 6, 0, '2017-06-09 12:45:41', NULL, 0, 0, 0, '2017-06-09 12:45:41'),
(229, 1, 48, 6, 0, '2017-06-13 13:35:16', NULL, 0, 0, 0, '2017-06-13 13:35:16'),
(230, 1, 33, 6, 0, '2017-06-14 07:30:14', NULL, 0, 0, 0, '2017-06-14 07:30:14'),
(231, 1, 71, 1, 0, '2017-06-14 07:30:18', NULL, 0, 0, 0, '2017-06-14 07:30:18'),
(232, 1, 71, 6, 0, '2017-06-14 07:30:20', NULL, 0, 0, 0, '2017-06-14 07:30:20'),
(233, 1, 70, 1, 0, '2017-06-14 07:30:21', NULL, 0, 0, 0, '2017-06-14 07:30:21'),
(234, 1, 70, 6, 0, '2017-06-14 07:30:22', NULL, 0, 0, 0, '2017-06-14 07:30:22'),
(235, 1, 72, 1, 0, '2017-06-14 07:31:40', NULL, 0, 0, 0, '2017-06-14 07:31:40'),
(236, 1, 72, 6, 0, '2017-06-14 07:31:42', NULL, 0, 0, 0, '2017-06-14 07:31:42'),
(237, 1, 80, 1, 0, '2017-06-15 05:39:01', NULL, 0, 0, 0, '2017-06-15 05:39:01'),
(238, 1, 80, 5, 0, '2017-06-15 05:39:02', NULL, 0, 0, 0, '2017-06-15 05:39:02'),
(239, 1, 80, 6, 0, '2017-06-15 05:39:03', NULL, 0, 0, 0, '2017-06-15 05:39:03'),
(240, 1, 73, 1, 0, '2017-06-15 11:20:49', NULL, 0, 0, 0, '2017-06-15 11:20:49'),
(241, 1, 73, 6, 0, '2017-06-15 11:20:50', NULL, 0, 0, 0, '2017-06-15 11:20:50'),
(242, 1, 87, 1, 0, '2017-06-16 05:58:16', NULL, 0, 0, 0, '2017-06-16 05:58:16'),
(243, 1, 87, 6, 0, '2017-06-16 05:58:17', NULL, 0, 0, 0, '2017-06-16 05:58:17'),
(244, 1, 88, 1, 0, '2017-06-18 12:21:32', NULL, 0, 0, 0, '2017-06-18 12:21:32'),
(245, 1, 89, 1, 0, '2017-06-18 12:21:34', NULL, 0, 0, 0, '2017-06-18 12:21:34'),
(246, 1, 90, 1, 0, '2017-06-18 12:21:36', NULL, 0, 0, 0, '2017-06-18 12:21:36'),
(247, 1, 89, 6, 0, '2017-06-18 12:21:39', NULL, 0, 0, 0, '2017-06-18 12:21:39'),
(248, 1, 90, 6, 0, '2017-06-18 12:21:41', NULL, 0, 0, 0, '2017-06-18 12:21:41'),
(250, 1, 88, 6, 0, '2017-06-18 12:38:38', NULL, 0, 0, 0, '2017-06-18 12:38:38'),
(251, 1, 91, 1, 0, '2017-06-19 05:39:14', NULL, 0, 0, 0, '2017-06-19 05:39:14'),
(252, 1, 91, 5, 0, '2017-06-19 05:39:15', NULL, 0, 0, 0, '2017-06-19 05:39:15'),
(253, 1, 91, 6, 0, '2017-06-19 05:39:16', NULL, 0, 0, 0, '2017-06-19 05:39:16'),
(254, 1, 86, 1, 0, '2017-06-19 05:39:18', NULL, 0, 0, 0, '2017-06-19 05:39:18'),
(255, 1, 86, 5, 0, '2017-06-19 05:39:18', NULL, 0, 0, 0, '2017-06-19 05:39:18'),
(256, 1, 86, 6, 0, '2017-06-19 05:39:20', NULL, 0, 0, 0, '2017-06-19 05:39:20'),
(257, 1, 83, 1, 0, '2017-06-19 05:39:29', NULL, 0, 0, 0, '2017-06-19 05:39:29'),
(258, 1, 83, 5, 0, '2017-06-19 05:39:29', NULL, 0, 0, 0, '2017-06-19 05:39:29'),
(259, 1, 83, 6, 0, '2017-06-19 05:39:30', NULL, 0, 0, 0, '2017-06-19 05:39:30'),
(261, 1, 93, 1, 0, '2017-06-19 07:27:08', NULL, 0, 0, 0, '2017-06-19 07:27:08'),
(262, 1, 93, 6, 0, '2017-06-19 07:27:09', NULL, 0, 0, 0, '2017-06-19 07:27:09'),
(263, 1, 84, 1, 0, '2017-06-19 11:27:19', NULL, 0, 0, 0, '2017-06-19 11:27:19'),
(264, 1, 84, 6, 0, '2017-06-19 11:27:20', NULL, 0, 0, 0, '2017-06-19 11:27:20'),
(265, 1, 94, 1, 0, '2017-06-21 11:01:15', NULL, 0, 0, 0, '2017-06-21 11:01:15'),
(266, 1, 95, 1, 0, '2017-06-21 11:01:16', NULL, 0, 0, 0, '2017-06-21 11:01:16'),
(267, 1, 96, 1, 0, '2017-06-21 11:01:17', NULL, 0, 0, 0, '2017-06-21 11:01:17'),
(268, 1, 94, 6, 0, '2017-06-21 11:01:18', NULL, 0, 0, 0, '2017-06-21 11:01:18'),
(269, 1, 95, 6, 0, '2017-06-21 11:01:19', NULL, 0, 0, 0, '2017-06-21 11:01:19'),
(270, 1, 96, 6, 0, '2017-06-21 11:01:20', NULL, 0, 0, 0, '2017-06-21 11:01:20'),
(271, 1, 92, 1, 0, '2017-06-21 11:01:23', NULL, 0, 0, 0, '2017-06-21 11:01:23'),
(272, 1, 92, 6, 0, '2017-06-21 11:01:25', NULL, 0, 0, 0, '2017-06-21 11:01:25'),
(279, 1, 51, 6, 0, '2017-07-06 11:51:22', NULL, 0, 0, 0, '2017-07-06 11:51:22'),
(280, 1, 98, 1, 0, '2017-07-18 07:14:15', NULL, 0, 0, 0, '2017-07-18 07:14:15'),
(281, 1, 98, 2, 0, '2017-07-18 07:14:16', NULL, 0, 0, 0, '2017-07-18 07:14:16'),
(282, 1, 98, 3, 0, '2017-07-18 07:14:16', NULL, 0, 0, 0, '2017-07-18 07:14:16'),
(283, 1, 98, 4, 0, '2017-07-18 07:14:17', NULL, 0, 0, 0, '2017-07-18 07:14:17'),
(284, 1, 11, 1, 0, '2017-07-20 08:47:04', NULL, 0, 0, 0, '2017-07-20 08:47:04'),
(287, 1, 6, 3, 0, '2017-07-24 07:31:59', NULL, 0, 0, 0, '2017-07-24 07:31:59'),
(288, 1, 6, 1, 0, '2017-07-24 07:32:06', NULL, 0, 0, 0, '2017-07-24 07:32:06'),
(289, 1, 7, 2, 0, '2017-07-24 07:32:07', NULL, 0, 0, 0, '2017-07-24 07:32:07'),
(290, 1, 97, 1, 0, '2017-07-25 06:57:42', NULL, 0, 0, 0, '2017-07-25 06:57:42'),
(291, 1, 99, 1, 0, '2017-09-07 12:24:12', NULL, 0, 0, 0, '2017-09-07 12:24:12');

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

--
-- Table structure for table `sps_actions`
--

CREATE TABLE IF NOT EXISTS `sps_actions` (
  `id` bigint(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `sps_actions`
--

INSERT INTO `sps_actions` (`id`, `name`, `created_by`, `location_id`, `area_id`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'View', 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'Add', 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 'Edit', 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(4, 'Delete', 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(5, 'Print', 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(6, 'Export', 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);

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

--
-- Table structure for table `sps_additional_charges`
--

CREATE TABLE IF NOT EXISTS `sps_additional_charges` (
  `addtional_charge_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `transaction_id` bigint(20) NOT NULL,
  `additional_tariff_id` bigint(20) NOT NULL,
  `additional_tariff_amount` float(10,2) NOT NULL,
  `area_id` tinyint(4) NOT NULL,
  `location_id` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` tinyint(4) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by` tinyint(4) NOT NULL,
  `sync_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`addtional_charge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_area`
--

CREATE TABLE IF NOT EXISTS `sps_area` (
  `area_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `area_name` varchar(55) NOT NULL,
  `status` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`area_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `sps_area`
--

INSERT INTO `sps_area` (`area_id`, `area_name`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'AA1', 1, 1, 1, '2017-03-18 10:44:19', '0000-00-00 00:00:00', NULL),
(2, 'AA2', 1, 1, 1, '2017-03-18 10:44:19', '0000-00-00 00:00:00', NULL),
(3, 'AA3', 1, 1, 1, '2017-03-18 10:44:44', '0000-00-00 00:00:00', NULL),
(4, 'AA4', 1, 1, 1, '2017-03-18 10:44:44', '0000-00-00 00:00:00', NULL);

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

--
-- Table structure for table `sps_bank_deposit`
--

CREATE TABLE IF NOT EXISTS `sps_bank_deposit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cashier_input` int(11) NOT NULL,
  `membership_income` int(11) NOT NULL DEFAULT '0',
  `voucher_income` int(10) unsigned DEFAULT NULL,
  `system_generated_voucher_cash` float DEFAULT '0',
  `date_of_input` datetime NOT NULL,
  `settlement_status` tinyint(4) NOT NULL,
  `difference_status` tinyint(4) NOT NULL,
  `difference_amount` float NOT NULL,
  `membership_difference` float NOT NULL DEFAULT '0',
  `voucher_difference` int(10) unsigned NOT NULL DEFAULT '0',
  `system_cash` float NOT NULL DEFAULT '0',
  `membership_cash` float NOT NULL DEFAULT '0',
  `reason` text NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `update_by` bigint(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_barrier_count`
--

CREATE TABLE IF NOT EXISTS `sps_barrier_count` (
  `barrier_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `barrier_open` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `barrier_close` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `gate_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `location_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `area_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`barrier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_barrier_loop_count`
--

CREATE TABLE IF NOT EXISTS `sps_barrier_loop_count` (
  `barrier_loop_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `loop_a` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `loop_b` tinyint(3) NOT NULL DEFAULT '0',
  `gate_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `location_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `area_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`barrier_loop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_bays`
--

CREATE TABLE IF NOT EXISTS `sps_bays` (
  `bay_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bay_name` varchar(45) NOT NULL DEFAULT '',
  `zone_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `level_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `location_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `area_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `updated_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`bay_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_blocked_vehicles`
--

CREATE TABLE IF NOT EXISTS `sps_blocked_vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vehicle_no` varchar(50) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_card_vehicle_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_card_vehicle_mapping` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `vehicle_type` bigint(11) NOT NULL,
  `validity` int(11) NOT NULL,
  `value` int(11) NOT NULL,
  `complementary` int(11) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vehicle_type` (`vehicle_type`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `sps_card_vehicle_mapping`
--

INSERT INTO `sps_card_vehicle_mapping` (`id`, `vehicle_type`, `validity`, `value`, `complementary`, `area_id`, `location_id`) VALUES
(1, 98, 123456789, 123456789, 123456789, 0, 0),
(2, 97, 123456789, 123456789, 123456789, 0, 0),
(3, 99, 123456789, 123456789, 123456789, 0, 0),
(4, 100, 123456789, 123456789, 123456789, 0, 0),
(5, 101, 123456789, 123456789, 123456789, 0, 0),
(6, 103, 123456789, 123456789, 123456789, 0, 0);

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

--
-- Table structure for table `sps_cashiers_log`
--

CREATE TABLE IF NOT EXISTS `sps_cashiers_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `gate_id` bigint(20) NOT NULL,
  `shift_id` bigint(20) NOT NULL,
  `login_time` datetime NOT NULL,
  `logout_time` datetime DEFAULT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_code_timeslot_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_code_timeslot_mapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `peak_slot_id` int(11) NOT NULL,
  `slot_start` int(11) NOT NULL,
  `slot_end` int(11) NOT NULL,
  `comparision` varchar(10) NOT NULL,
  `slot_description` varchar(100) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_corporates`
--

CREATE TABLE IF NOT EXISTS `sps_corporates` (
  `corporate_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone_number` varchar(20) NOT NULL,
  `fax` varchar(20) NOT NULL,
  `member_resv_total` int(11) NOT NULL,
  `vip_resv_total` int(11) NOT NULL,
  `member_resv_left` int(11) NOT NULL,
  `vip_resv_left` int(11) NOT NULL,
  `notes` varchar(255) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`corporate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_discounts`
--

CREATE TABLE IF NOT EXISTS `sps_discounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `discount_code` varchar(50) NOT NULL,
  `no_of_visits` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `discount_type` int(11) NOT NULL,
  `value` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `vehicle_type` int(11) NOT NULL,
  `gate` varchar(255) NOT NULL,
  `day_type` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_eod_report_select`
--

CREATE TABLE IF NOT EXISTS `sps_eod_report_select` (
  `eod_report_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `eod_report_name` varchar(45) NOT NULL DEFAULT '',
  `status` bigint(20) unsigned NOT NULL DEFAULT '0',
  `area_id` bigint(20) unsigned NOT NULL DEFAULT '1',
  `location_id` bigint(20) unsigned NOT NULL DEFAULT '1',
  `created_by` bigint(20) unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`eod_report_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

--
-- Dumping data for table `sps_eod_report_select`
--

INSERT INTO `sps_eod_report_select` (`eod_report_id`, `eod_report_name`, `status`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'recap_vehicle_quantity', 1, 1, 1, 1, 0, '2017-06-29 07:07:51', '2017-08-07 19:32:59', '0000-00-00 00:00:00'),
(2, 'recap_of_parking_income', 1, 1, 1, 1, 0, '2017-06-29 07:08:31', '2017-08-07 19:33:02', '0000-00-00 00:00:00'),
(3, 'recap_of_cashier_shift', 1, 1, 1, 1, 0, '2017-06-29 07:09:30', '2017-08-08 07:57:45', '0000-00-00 00:00:00'),
(4, 'recap_of_cashier_income', 1, 1, 1, 1, 0, '2017-06-29 07:10:10', '2017-08-08 07:57:45', '0000-00-00 00:00:00'),
(5, 'recap_if_cashier_ticket_status', 1, 1, 1, 1, 0, '2017-06-29 07:13:00', '2017-08-08 07:57:53', '0000-00-00 00:00:00'),
(6, 'statistic_of_parking_duration', 0, 1, 1, 1, 0, '2017-06-29 07:13:00', '2017-08-06 12:12:12', '0000-00-00 00:00:00'),
(7, 'bank_deposit_report', 0, 1, 1, 1, 0, '2017-06-29 07:13:00', '2017-08-06 10:35:41', '0000-00-00 00:00:00'),
(8, 'card_membership_blocked_report', 0, 1, 1, 1, 0, '2017-06-29 07:13:00', '2017-06-29 11:32:31', '0000-00-00 00:00:00'),
(9, 'overnight_vehicle_report', 0, 1, 1, 1, 0, '2017-06-29 07:13:00', '2017-08-06 10:35:43', '0000-00-00 00:00:00'),
(10, 'membership_per_product_report', 0, 1, 1, 1, 0, '2017-06-29 07:13:00', '2017-08-06 10:35:45', '0000-00-00 00:00:00'),
(11, 'extending_memebership_card_per_product', 0, 1, 1, 1, 0, '2017-06-29 07:13:29', '2017-08-06 10:35:46', '0000-00-00 00:00:00'),
(12, 'prepaid_top_up_report', 0, 1, 1, 1, 0, '2017-06-29 07:14:19', '2017-08-06 10:35:48', '0000-00-00 00:00:00'),
(13, 'sticker_membership_per_product_report', 0, 1, 1, 1, 0, '2017-06-29 07:14:46', '2017-08-06 10:35:49', '0000-00-00 00:00:00'),
(14, 'extending_sticker_member_report', 0, 1, 1, 1, 0, '2017-06-29 07:16:05', '2017-08-06 10:35:50', '0000-00-00 00:00:00'),
(15, 'sticker_membership_cancellation_report', 0, 1, 1, 1, 0, '2017-06-29 07:16:05', '2017-08-06 10:35:52', '0000-00-00 00:00:00'),
(16, 'sticker_member_vehicle_deletion_report', 0, 1, 1, 1, 0, '2017-06-29 07:16:05', '2017-08-06 10:35:53', '0000-00-00 00:00:00'),
(17, 'memberships_vehicle_number_change_report', 0, 1, 1, 1, 0, '2017-06-29 07:17:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 'product_change_report', 0, 1, 1, 1, 0, '2017-06-29 07:17:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 'sticker_vehicle_addtion_number_report', 0, 1, 1, 1, 0, '2017-06-29 07:17:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 'deletion_vehicle_report', 0, 1, 1, 1, 0, '2017-06-29 07:19:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 'transaction_cancellation_report', 0, 1, 1, 1, 0, '2017-06-29 07:19:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 'login_history_report', 0, 1, 1, 1, 0, '2017-06-29 07:19:04', '2017-08-08 07:58:04', '0000-00-00 00:00:00'),
(23, 'cashier_not_settlement_yet_report', 0, 1, 1, 1, 0, '2017-06-29 07:19:04', '2017-06-29 12:08:23', '0000-00-00 00:00:00'),
(24, 'recap_of_barrier_loop_and_barrier_count', 0, 1, 1, 1, 0, '2017-07-01 07:30:16', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 'reprint_ticket_count', 0, 1, 1, 1, 0, '2017-07-01 07:36:57', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 'membership_blocked_report', 0, 1, 1, 1, 0, '2017-07-01 07:46:26', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, 'rfid_member_vehicle_deletion_report', 0, 1, 1, 1, 0, '2017-07-01 08:06:10', '2017-08-06 10:36:07', '0000-00-00 00:00:00'),
(28, 'rfid_vehicle_addition_number_report', 0, 1, 1, 1, 0, '2017-07-01 08:08:43', '2017-08-06 10:36:08', '0000-00-00 00:00:00'),
(29, 'rfid_membership_blocked_report', 0, 1, 1, 1, 0, '2017-07-03 06:48:45', '2017-08-06 10:36:04', '0000-00-00 00:00:00'),
(30, 'rfid_vehicle_addtion_number_report', 0, 1, 1, 1, 0, '2017-07-03 06:48:45', '2017-08-06 10:36:02', '0000-00-00 00:00:00'),
(31, 'extending_rfid_member_report', 0, 1, 1, 1, 0, '2017-07-03 06:48:45', '2017-08-06 10:36:01', '0000-00-00 00:00:00');

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

--
-- Table structure for table `sps_foc_approvers`
--

CREATE TABLE IF NOT EXISTS `sps_foc_approvers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_foc_reasons`
--

CREATE TABLE IF NOT EXISTS `sps_foc_reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reason` varchar(255) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_f_eight_reason`
--

CREATE TABLE IF NOT EXISTS `sps_f_eight_reason` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `reason` varchar(50) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_gate_configurations`
--

CREATE TABLE IF NOT EXISTS `sps_gate_configurations` (
  `gate_id` bigint(255) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `gate_name` varchar(255) NOT NULL,
  `gate_ip` varchar(255) NOT NULL,
  `serial_no` varchar(11) NOT NULL,
  `reset_serial_no` tinyint(1) NOT NULL,
  `gate_type` varchar(255) NOT NULL,
  `payment_modes` varchar(255) NOT NULL,
  `standard_nested` enum('Standard','Nested') NOT NULL,
  `pass_through_gates` varchar(255) NOT NULL,
  `time_duration` varchar(255) NOT NULL,
  `is_full` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `discount_additional` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `percentage_flat` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` bigint(20) NOT NULL DEFAULT '1',
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`gate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_gate_equipments_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_gate_equipments_mapping` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `gate_id` bigint(20) NOT NULL,
  `equipment_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_gate_monitoring`
--

CREATE TABLE IF NOT EXISTS `sps_gate_monitoring` (
  `monitoring_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `gate_id` bigint(20) NOT NULL,
  `equipment_id` bigint(20) NOT NULL,
  `status` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`monitoring_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_gate_payments_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_gate_payments_mapping` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `gate_id` bigint(20) NOT NULL,
  `payment_mode` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_gate_type`
--

CREATE TABLE IF NOT EXISTS `sps_gate_type` (
  `gt_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `gt_name` varchar(55) NOT NULL,
  `status` bigint(20) NOT NULL DEFAULT '1',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`gt_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `sps_gate_type`
--

INSERT INTO `sps_gate_type` (`gt_id`, `gt_name`, `status`, `area_id`, `location_id`, `created_by`, `updated_by`, `updated_at`, `deleted_at`, `created_at`) VALUES
(1, 'Man Entry', 1, 0, 0, 1, 0, '2017-01-25 11:30:07', NULL, '2017-01-24 18:30:00'),
(2, 'Man Exit', 1, 0, 0, 1, 0, '2017-01-25 11:30:07', NULL, '2017-01-24 18:30:00'),
(3, 'Manless Entry', 1, 0, 0, 1, 0, '2017-01-25 11:30:07', NULL, '2017-01-24 18:30:00'),
(4, 'Manless Exit', 1, 0, 0, 1, 0, '2017-01-25 11:30:07', NULL, '2017-01-24 18:30:00'),
(5, 'CPS', 1, 0, 0, 1, 0, '2017-01-25 11:30:07', NULL, '2017-01-24 18:30:00');

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

--
-- Table structure for table `sps_gate_vehicles_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_gate_vehicles_mapping` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `gate_id` bigint(20) NOT NULL,
  `vehicle_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_images`
--

CREATE TABLE IF NOT EXISTS `sps_images` (
  `image_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `module` varchar(20) NOT NULL,
  `module_id` bigint(20) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_ip_address`
--

CREATE TABLE IF NOT EXISTS `sps_ip_address` (
  `ip_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(255) NOT NULL,
  `status` bigint(20) NOT NULL DEFAULT '1',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL COMMENT 'NULL',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `unique_ip_id` (`ip_id`),
  KEY `index_ip_id` (`ip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_levels`
--

CREATE TABLE IF NOT EXISTS `sps_levels` (
  `level_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `level_name` varchar(45) NOT NULL DEFAULT '',
  `zone_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `location_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `area_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `updated_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_location`
--

CREATE TABLE IF NOT EXISTS `sps_location` (
  `location_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `location_name` varchar(55) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `status` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7270 ;

--
-- Dumping data for table `sps_location`
--

INSERT INTO `sps_location` (`location_id`, `location_name`, `area_id`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'LOCATION1', 1, 1, 1, 1, '2017-03-18 10:45:31', '0000-00-00 00:00:00', NULL),
(2, 'LOCATION2', 3, 1, 1, 1, '2017-03-18 10:45:31', '0000-00-00 00:00:00', NULL),
(3, 'LOCATION3', 2, 1, 1, 1, '2017-03-18 10:46:00', '0000-00-00 00:00:00', NULL),
(7269, 'LOCATION4', 4, 1, 1, 1, '2017-03-18 10:46:00', '0000-00-00 00:00:00', NULL);

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

--
-- Table structure for table `sps_master_payment_modes`
--

CREATE TABLE IF NOT EXISTS `sps_master_payment_modes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `master_payment_mode` varchar(255) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `master_payment_description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `sps_master_payment_modes`
--

INSERT INTO `sps_master_payment_modes` (`id`, `master_payment_mode`, `location_id`, `area_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`, `master_payment_description`) VALUES
(1, 'Cash', 1, 1, 1, 0, '2017-03-06 14:16:19', '0000-00-00 00:00:00', NULL, 'It will accept money in cash'),
(2, 'Bank card', 1, 1, 1, 0, '2017-03-06 14:16:19', '0000-00-00 00:00:00', NULL, 'It will accept all bank cards'),
(3, 'Smart card', 1, 1, 1, 0, '2017-03-06 14:17:09', '0000-00-00 00:00:00', NULL, 'It will accept smart cards only'),
(4, 'E wallet', 1, 1, 1, 0, '2017-03-06 14:17:09', '0000-00-00 00:00:00', NULL, 'It will accept all e wallet transactions'),
(5, 'Vouchers', 1, 1, 1, 0, '2017-03-06 14:17:09', '0000-00-00 00:00:00', NULL, 'It will accept all Vouchers'),
(6, 'Cheque', 1, 1, 0, 0, '2017-04-20 06:59:48', '0000-00-00 00:00:00', NULL, '');

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

--
-- Table structure for table `sps_members`
--

CREATE TABLE IF NOT EXISTS `sps_members` (
  `member_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `employee_id` varchar(20) NOT NULL,
  `member_name` varchar(255) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `driving_license` varchar(20) NOT NULL,
  `office_address` varchar(255) NOT NULL,
  `residential_address` varchar(255) NOT NULL,
  `corporate_id` bigint(20) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_membership`
--

CREATE TABLE IF NOT EXISTS `sps_membership` (
  `membership_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `card_no_prefix` bigint(20) NOT NULL,
  `card_no` bigint(20) NOT NULL,
  `card_type` bigint(20) NOT NULL,
  `membership_product` varchar(255) NOT NULL,
  `membership_start_date` date NOT NULL,
  `tolerance` bigint(20) NOT NULL,
  `period_from` date NOT NULL,
  `period_to` date NOT NULL,
  `extended_card_fee` double(20,2) DEFAULT NULL,
  `extended_period_to` date DEFAULT NULL,
  `extended_period_from` date DEFAULT NULL,
  `from_time` time NOT NULL,
  `to_time` time NOT NULL,
  `card_deposite_fee` double(10,2) NOT NULL,
  `payment_mode` bigint(20) NOT NULL,
  `membership_no` bigint(20) NOT NULL,
  `reciept` varchar(55) NOT NULL,
  `use_card` bigint(20) NOT NULL,
  `balance` double(10,2) NOT NULL,
  `status` bigint(20) NOT NULL,
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sync_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`membership_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_membership_location`
--

CREATE TABLE IF NOT EXISTS `sps_membership_location` (
  `mem_location_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `rfid_membership_id` bigint(20) NOT NULL,
  `sticker_membership_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`mem_location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_membership_log`
--

CREATE TABLE IF NOT EXISTS `sps_membership_log` (
  `membership_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rfid_membership_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `sticker_membership_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `membership_type` bigint(20) unsigned NOT NULL DEFAULT '0',
  `member_id` bigint(20) NOT NULL,
  `card_no_prefix` bigint(20) NOT NULL,
  `card_no` bigint(20) NOT NULL,
  `card_type` bigint(20) NOT NULL DEFAULT '0',
  `membership_product` varchar(255) NOT NULL,
  `membership_start_date` date NOT NULL,
  `tolerance` bigint(20) NOT NULL,
  `period_from` date NOT NULL,
  `period_to` date NOT NULL,
  `extended_period_from` date DEFAULT NULL,
  `extended_period_to` date DEFAULT NULL,
  `extended_card_fee` double(20,2) DEFAULT NULL,
  `from_time` time NOT NULL,
  `to_time` time NOT NULL,
  `card_deposite_fee` double(10,2) NOT NULL,
  `payment_mode` bigint(20) NOT NULL,
  `membership_no` bigint(20) NOT NULL,
  `reciept` varchar(55) NOT NULL,
  `vehicle_1` varchar(45) DEFAULT NULL,
  `existing_vehicle_1` varchar(45) DEFAULT NULL,
  `vehicle_2` varchar(45) DEFAULT NULL,
  `existing_vehicle_2` varchar(45) DEFAULT NULL,
  `vehicle_3` varchar(45) DEFAULT NULL,
  `existing_vehicle_3` varchar(45) DEFAULT NULL,
  `vehicle_4` varchar(45) DEFAULT NULL,
  `existing_vehicle_4` varchar(45) DEFAULT NULL,
  `vehicle_5` varchar(45) DEFAULT NULL,
  `existing_vehicle_5` varchar(45) DEFAULT NULL,
  `vehicle_6` varchar(45) DEFAULT NULL,
  `existing_vehicle_6` varchar(45) DEFAULT NULL,
  `use_card` bigint(20) NOT NULL DEFAULT '0',
  `status` bigint(20) NOT NULL,
  `membership_action` tinyint(4) NOT NULL,
  `reason` varchar(245) NOT NULL DEFAULT '',
  `reason_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`membership_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_membership_sticker`
--

CREATE TABLE IF NOT EXISTS `sps_membership_sticker` (
  `sticker_membership_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `member_id` bigint(20) NOT NULL,
  `card_type` bigint(20) NOT NULL,
  `membership_product` varchar(255) NOT NULL,
  `tariff_name` varchar(100) NOT NULL,
  `period_length` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `membership_start_date` date NOT NULL,
  `tolerance` bigint(20) NOT NULL,
  `period_from` date NOT NULL,
  `period_to` date NOT NULL,
  `extended_period_from` date DEFAULT NULL,
  `extended_period_to` date DEFAULT NULL,
  `extended_card_fee` double(20,2) DEFAULT NULL,
  `from_time` time NOT NULL,
  `to_time` time NOT NULL,
  `card_deposite_fee` double(10,2) NOT NULL,
  `payment_mode` bigint(20) NOT NULL,
  `membership_no` varchar(100) NOT NULL,
  `reciept` varchar(55) NOT NULL,
  `status` bigint(20) NOT NULL,
  `use_card` bigint(20) NOT NULL,
  `balance` double(10,2) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sticker_membership_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_member_vehicles`
--

CREATE TABLE IF NOT EXISTS `sps_member_vehicles` (
  `members_vehicles_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `member_id` bigint(20) NOT NULL,
  `membership_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `vehicle_no` varchar(100) NOT NULL,
  `vehicle_priority` bigint(20) NOT NULL DEFAULT '0',
  `status` bigint(20) NOT NULL DEFAULT '1',
  `membership_type` varchar(50) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`members_vehicles_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_menu`
--

CREATE TABLE IF NOT EXISTS `sps_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `menu_item` varchar(255) NOT NULL,
  `menu_url` varchar(255) NOT NULL,
  `menu_class` varchar(255) DEFAULT NULL,
  `parent_menu_id` bigint(20) NOT NULL,
  `action` varchar(255) NOT NULL,
  `order` float(10,2) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_by` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=100 ;

--
-- Dumping data for table `sps_menu`
--

INSERT INTO `sps_menu` (`id`, `menu_item`, `menu_url`, `menu_class`, `parent_menu_id`, `action`, `order`, `status`, `location_id`, `area_id`, `created_by`, `created_at`, `updated_at`, `deleted_at`, `updated_by`) VALUES
(1, 'dashboard', 'admin', '', 0, '1', 1.00, 1, 0, 0, 0, '2016-12-22 07:13:46', '2017-02-02 07:59:54', NULL, 0),
(2, 'equipment_type', 'admin/equipment', 'menu', 11, '', 2.01, 1, 0, 0, 0, '2016-12-22 08:18:13', '2017-04-13 01:06:00', NULL, 0),
(3, 'vehicle_type', 'admin/vehicle', 'menu', 11, '', 2.02, 1, 0, 0, 0, '2016-12-22 08:18:13', '2017-04-13 01:06:03', NULL, 0),
(4, 'user_role', 'admin/user_role', 'menu', 17, '1,2,3,4', 3.02, 1, 0, 0, 0, '2016-12-22 08:18:13', '2017-04-10 07:22:17', NULL, 0),
(5, 'menu_access', 'admin/menu_access', 'menu', 11, '0', 0.00, 0, 0, 0, 0, '0000-00-00 00:00:00', '2017-03-14 05:48:53', NULL, 0),
(6, 'payment_mode', 'admin/payment', 'menu', 11, '', 2.03, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:06:17', NULL, 0),
(7, 'gate_configuration', 'admin/gate', 'menu', 11, '', 2.04, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:06:20', NULL, 0),
(8, 'transactions_entry', 'admin/transaction/view_entries', 'menu', 12, '1', 4.02, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:22:30', NULL, 0),
(9, 'transactions_exit', 'admin/transaction/view_exits', 'menu', 12, '1', 4.03, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:22:34', NULL, 0),
(11, 'configuration_management', '', '', 0, '1', 2.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-02-16 08:14:14', NULL, 0),
(12, 'transactions', '', '', 0, '1', 4.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-07 06:54:37', NULL, 0),
(13, 'ipaddress', 'admin/ipaddress', 'menu', 11, '', 2.05, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:06:24', NULL, 0),
(14, 'holidays', '', '', 11, '1', 2.08, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:22:46', NULL, 0),
(17, 'users_management', '', '', 0, '1', 3.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-07 06:54:06', NULL, 0),
(18, 'user_create', 'admin/user_create', 'menu', 17, '1,2,3,4', 3.01, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:22:53', NULL, 0),
(19, 'access_rights', 'admin/access_rights', 'menu', 17, '0', 3.03, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:22:59', NULL, 0),
(20, 'weekdays_weekends', 'admin/weekdays_weekends', 'menu', 14, '1', 2.08, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:04', NULL, 0),
(21, 'specialdays', 'admin/special_days', 'menu', 14, '1', 2.08, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:24', NULL, 0),
(22, 'gate_monitoring', 'admin/gate_monitoring', 'menu', 0, '1', 12.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-07 06:56:27', NULL, 0),
(23, 'shift_management', '', '', 0, '1', 0.00, 0, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:10:11', NULL, 0),
(24, 'user_shift', '', '', 23, '1', 0.00, 0, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:10:15', NULL, 0),
(25, 'active_users', 'admin/active_users', 'menu', 12, '1', 4.06, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:32', NULL, 0),
(26, 'tariff_management', '', '', 0, '1', 6.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-07 06:56:40', NULL, 0),
(27, 'casual_tariff', 'admin/tariff', 'menu', 26, '1,2,3,4', 6.01, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:36', NULL, 0),
(28, 'service_type', 'admin/service_type', 'menu', 11, '1,2,3,4', 2.06, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:42', NULL, 0),
(29, 'overnight_tariff', 'admin/overnight_tariff', 'menu', 26, '1,2,3,4', 6.02, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:44', NULL, 0),
(30, 'additional_tariff', 'admin/additional_tariff', 'menu', 26, '1,2,3,4', 6.03, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:49', NULL, 0),
(31, 'voucher_management', 'admin/voucher', 'menu', 0, '', 9.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:28:28', NULL, 0),
(32, 'member_tariff', 'admin/member_tariff', 'menu', 26, '1,2,3,4', 6.04, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:52', NULL, 0),
(33, 'corporate', 'admin/corporate', 'menu', 38, '', 8.01, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:23:59', NULL, 0),
(34, 'site_settings', 'admin/site_settings', 'menu', 0, '', 14.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-07 07:02:31', NULL, 0),
(35, 'settlements', '', '', 12, '', 4.07, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:27:35', NULL, 0),
(36, 'input_settlements', 'admin/input_settlements', 'menu', 35, '', 4.07, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:27:39', NULL, 0),
(37, 'info_settlements', 'admin/info_settlements', 'menu', 35, '', 4.07, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:27:42', NULL, 0),
(38, 'member_management', '', '', 0, '', 8.00, 1, 0, 0, 0, '2017-03-15 13:00:00', '2017-04-07 06:57:57', NULL, 0),
(39, 'member_customer', 'admin/member', 'menu', 38, '', 8.02, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:07:32', NULL, 0),
(40, 'membership', 'admin/membership', 'menu', 38, '', 8.03, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:07:28', NULL, 0),
(41, 'read_card', 'admin/member/open_read_card', 'menu', 38, '', 8.05, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:24:47', NULL, 0),
(42, 'sticker_membership', 'admin/sticker_membership', 'menu', 38, '', 8.04, 1, 0, 0, 0, '2017-03-25 04:00:00', '2017-04-10 07:24:51', NULL, 0),
(43, 'ticket_layout', 'admin/ticket_layout', 'menu', 11, '1,2,3,4', 2.09, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:24:56', NULL, 0),
(44, 'blocked_vehicles', 'admin/blocked_vehicles', 'menu', 11, '', 2.10, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-07 07:01:10', NULL, 0),
(45, 'discount', 'admin/discount', 'menu', 0, '', 7.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:28:33', NULL, 0),
(46, 'reports', '', '', 0, '', 11.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-02-13 01:53:05', NULL, 0),
(47, 'duplicate_ticket', 'admin/reports/duplicate_ticket', 'menu', 46, '', 11.03, 1, 0, 0, 0, '2017-04-13 01:15:53', '0000-00-00 00:00:00', NULL, 0),
(48, 'corporate_report', 'admin/corporate/?report=1', 'menu', 46, '', 11.06, 1, 0, 0, 0, '2017-04-13 01:15:53', '0000-00-00 00:00:00', NULL, 0),
(49, 'membership', 'admin/reports/membership', 'menu', 46, '', 11.05, 1, 0, 0, 0, '2017-04-13 01:15:53', '0000-00-00 00:00:00', NULL, 0),
(50, 'offline_ticket', 'admin/reports/offline_ticket', 'menu', 46, '', 11.04, 1, 0, 0, 0, '2017-04-13 05:24:41', '0000-00-00 00:00:00', NULL, 0),
(51, 'configure_statistic_list', 'admin/reports/statistics_list', 'menu', 46, '', 11.07, 1, 0, 0, 0, '2017-04-14 06:07:10', '0000-00-00 00:00:00', NULL, 0),
(52, 'generate_report', 'admin/reports/generate_report', 'menu', 99, '', 10.02, 1, 0, 0, 0, '2017-04-13 01:15:53', '0000-00-00 00:00:00', NULL, 0),
(53, 'configure_report', 'admin/reports/configure_report', 'menu', 46, '', 11.02, 0, 0, 0, 0, '2017-04-13 01:15:53', '0000-00-00 00:00:00', NULL, 0),
(54, 'manual_entry', 'admin/transaction/manual_entry', 'menu', 12, '1', 4.01, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:22:30', NULL, 0),
(55, 'master', 'admin/master', '', 0, '', 5.00, 1, 0, 0, 0, '2017-04-19 04:25:07', '0000-00-00 00:00:00', NULL, 0),
(56, 'f8_reason', 'admin/f8_reason', 'menu', 55, '', 5.01, 1, 0, 0, 0, '2017-04-19 04:36:56', '0000-00-00 00:00:00', NULL, 0),
(57, 'upload_transaction', 'admin/transaction/upload_transaction', 'menu', 12, '', 4.04, 1, 0, 0, 0, '2017-04-20 00:26:47', '0000-00-00 00:00:00', NULL, 0),
(58, 'bank_deposit', '', '', 12, '', 4.08, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-10-31 06:37:38', NULL, 0),
(59, 'bank_deposit_input', 'admin/bank_deposit_input', 'menu', 58, '', 4.07, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:27:39', NULL, 0),
(60, 'bank_deposit_info', 'admin/bank_deposit_info', 'menu', 58, '', 4.07, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-10 07:27:39', NULL, 0),
(61, 'bay_management', '', '', 0, '', 13.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-07 07:02:31', NULL, 0),
(62, 'zones', 'admin/zone', 'menu', 61, '', 13.01, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:07:28', NULL, 0),
(63, 'levels', 'admin/level', 'menu', 61, '', 13.02, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:07:28', NULL, 0),
(64, 'bays', 'admin/bay', 'menu', 61, '', 13.03, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-04-13 01:07:28', NULL, 0),
(65, 'offline_transaction', 'admin/transaction/offline_transaction', 'menu', 12, '', 4.05, 0, 0, 0, 0, '2017-04-20 00:26:47', '0000-00-00 00:00:00', NULL, 0),
(66, 'f3_reason', 'admin/f3_reason', 'menu', 55, '', 5.02, 1, 0, 0, 0, '2017-05-12 04:41:40', '0000-00-00 00:00:00', NULL, 0),
(67, 'overnight_vehicle', 'admin/overnight_vehicle', 'menu', 46, '', 11.08, 1, 0, 0, 0, '2017-04-13 05:24:41', '0000-00-00 00:00:00', NULL, 0),
(68, 'foc_approvers', 'admin/foc_approvers', 'menu', 55, '', 5.03, 1, 0, 0, 0, '2017-05-16 08:22:16', '0000-00-00 00:00:00', NULL, 0),
(69, 'trans_cancellation', 'admin/reports/trans_cancellation', 'menu', 46, '', 11.09, 1, 0, 0, 0, '2017-04-13 01:15:53', '0000-00-00 00:00:00', NULL, 0),
(70, 'login_history', 'admin/reports/login_history', 'menu', 46, '', 11.10, 1, 0, 0, 0, '2017-04-13 07:15:53', '0000-00-00 00:00:00', NULL, 0),
(71, 'overnight_report', 'admin/reports/overnight_report', 'menu', 46, '', 11.11, 1, 0, 0, 0, '2017-04-13 07:15:53', '0000-00-00 00:00:00', NULL, 0),
(72, 'maturity_report', 'admin/reports/maturity_report', 'menu', 46, '', 11.12, 1, 0, 0, 0, '2017-04-13 07:15:53', '0000-00-00 00:00:00', NULL, 0),
(73, 'logged_in_cashier', 'admin/reports/logged_in_cashier', 'menu', 46, '', 11.13, 1, 0, 0, 0, '2017-04-14 07:15:53', '0000-00-00 00:00:00', NULL, 0),
(80, 'member_activity', 'admin/member_activity', 'menu', 46, '', 11.14, 1, 3, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(83, 'user_pershift_recap_report', 'admin/user_pershift_recap_report', 'menu', 46, '', 11.15, 1, 3, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(84, 'manual_report', 'admin/reports/manual_report', 'menu', 46, '', 11.16, 1, 0, 0, 0, '2017-04-13 07:15:53', '0000-00-00 00:00:00', NULL, 0),
(86, 'vehicle_activity', 'admin/vehicle_activity', 'menu', 46, '', 11.17, 1, 3, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(87, 'transactions_entry_report', 'admin/reports/transactions_entry', 'menu', 46, '', 11.18, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(88, 'tariff_report', 'admin/reports/tariff', 'menu', 46, '', 11.19, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(89, 'additionalTariff_report', 'admin/additional_tariff/?report=1', 'menu', 46, '', 11.20, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(90, 'overnightTariff_report', 'admin/overnight_tariff/?report=1', 'menu', 46, '', 11.21, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(91, 'vehicle_number_change', 'admin/vehicle_number_change', 'menu', 46, '', 11.22, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(92, 'voucher_consumption', 'admin/voucher_consumption', 'menu', 46, '', 11.23, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(93, 'membershipProduct_report', 'admin/member_tariff/?report=1', 'menu', 46, '', 11.24, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(94, 'lost_ticket_report', 'admin/reports/lost_ticket', 'menu', 46, '', 11.25, 1, 0, 0, 0, '2017-04-13 07:15:53', '0000-00-00 00:00:00', NULL, 0),
(95, 'questioned_tickets', 'admin/questioned_tickets', 'menu', 46, '', 11.26, 1, 3, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(96, 'card_transaction', 'admin/reports/card_transaction', 'menu', 46, '', 11.27, 1, 1, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(97, 'eod_report_select', 'admin/reports/eod_report_select', 'menu', 99, '', 10.01, 1, 3, 1, 1, '2017-06-07 06:51:00', '2017-06-07 06:51:00', NULL, 1),
(98, 'tax', 'admin/tax', 'menu', 55, '', 5.04, 1, 1, 0, 0, '2017-07-18 07:08:44', '0000-00-00 00:00:00', NULL, 0),
(99, 'eod', '', '', 0, '', 10.00, 1, 0, 0, 0, '0000-00-00 00:00:00', '2017-02-13 01:53:05', NULL, 0);

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

--
-- Table structure for table `sps_menu_action_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_menu_action_mapping` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `menu_id` bigint(20) NOT NULL,
  `action_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menu_id` (`menu_id`,`action_id`),
  KEY `menu_id_2` (`menu_id`),
  KEY `action_id` (`action_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=230 ;

--
-- Dumping data for table `sps_menu_action_mapping`
--

INSERT INTO `sps_menu_action_mapping` (`id`, `menu_id`, `action_id`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 0, 0, 0, 0, '2017-02-17 02:06:37', '0000-00-00 00:00:00', NULL),
(2, 11, 1, 0, 0, 0, 0, '2017-02-17 02:07:10', '0000-00-00 00:00:00', NULL),
(3, 12, 1, 0, 0, 0, 0, '2017-02-17 02:07:40', '0000-00-00 00:00:00', NULL),
(4, 17, 1, 0, 0, 0, 0, '2017-02-17 02:07:52', '0000-00-00 00:00:00', NULL),
(5, 23, 1, 0, 0, 0, 0, '2017-02-17 02:08:09', '0000-00-00 00:00:00', NULL),
(6, 26, 1, 0, 0, 0, 0, '2017-02-17 02:08:18', '0000-00-00 00:00:00', NULL),
(7, 2, 1, 0, 0, 0, 0, '2017-02-17 02:09:25', '0000-00-00 00:00:00', NULL),
(8, 2, 2, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(9, 2, 3, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(10, 2, 4, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(11, 3, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(15, 4, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(16, 4, 2, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(17, 4, 3, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(18, 4, 4, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(19, 6, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(20, 6, 2, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(21, 6, 3, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(22, 6, 4, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(23, 7, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(24, 7, 2, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(25, 7, 3, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(26, 7, 4, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(27, 8, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(28, 9, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(29, 13, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(30, 13, 2, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(31, 13, 3, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(32, 13, 4, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(33, 18, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(34, 18, 2, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(35, 18, 3, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(36, 18, 4, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(37, 14, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(38, 20, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(39, 21, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(40, 22, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(41, 25, 1, 0, 0, 0, 0, '2017-02-17 02:09:40', '0000-00-00 00:00:00', NULL),
(47, 27, 1, 0, 0, 0, 0, '2017-02-17 02:32:39', '0000-00-00 00:00:00', NULL),
(48, 27, 2, 0, 0, 0, 0, '2017-02-17 02:32:51', '0000-00-00 00:00:00', NULL),
(49, 27, 3, 0, 0, 0, 0, '2017-02-17 02:32:51', '0000-00-00 00:00:00', NULL),
(50, 27, 4, 0, 0, 0, 0, '2017-02-17 02:32:51', '0000-00-00 00:00:00', NULL),
(51, 28, 1, 0, 0, 0, 0, '2017-02-17 02:32:51', '0000-00-00 00:00:00', NULL),
(52, 28, 2, 0, 0, 0, 0, '2017-02-17 02:32:51', '0000-00-00 00:00:00', NULL),
(53, 28, 3, 0, 0, 0, 0, '2017-02-17 02:32:51', '0000-00-00 00:00:00', NULL),
(54, 28, 4, 0, 0, 0, 0, '2017-02-17 02:32:51', '0000-00-00 00:00:00', NULL),
(55, 29, 1, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(56, 29, 2, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(57, 29, 3, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(58, 29, 4, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(59, 30, 1, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(60, 30, 2, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(61, 30, 3, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(62, 30, 4, 0, 0, 0, 0, '2017-02-17 02:34:09', '0000-00-00 00:00:00', NULL),
(63, 31, 1, 0, 0, 0, 0, '2017-02-20 08:07:27', '0000-00-00 00:00:00', NULL),
(64, 31, 4, 0, 0, 0, 0, '2017-02-20 08:07:52', '0000-00-00 00:00:00', NULL),
(65, 32, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(66, 32, 2, 0, 0, 0, 0, '2017-02-21 00:17:22', '0000-00-00 00:00:00', NULL),
(67, 32, 3, 0, 0, 0, 0, '2017-02-21 00:17:31', '0000-00-00 00:00:00', NULL),
(68, 32, 4, 0, 0, 0, 0, '2017-02-21 00:17:40', '0000-00-00 00:00:00', NULL),
(69, 33, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(70, 33, 2, 0, 0, 0, 0, '2017-02-21 00:17:22', '0000-00-00 00:00:00', NULL),
(71, 33, 3, 0, 0, 0, 0, '2017-02-21 00:17:31', '0000-00-00 00:00:00', NULL),
(72, 33, 4, 0, 0, 0, 0, '2017-02-21 00:17:40', '0000-00-00 00:00:00', NULL),
(73, 31, 2, 0, 0, 0, 0, '2017-02-21 06:00:41', '0000-00-00 00:00:00', NULL),
(74, 34, 1, 0, 0, 0, 0, '2017-02-27 00:20:47', '0000-00-00 00:00:00', NULL),
(75, 5, 1, 0, 0, 0, 0, '2017-03-02 05:15:24', '0000-00-00 00:00:00', NULL),
(76, 36, 1, 0, 0, 0, 0, '2017-03-02 05:15:35', '0000-00-00 00:00:00', NULL),
(77, 37, 1, 0, 0, 0, 0, '2017-03-02 05:15:47', '0000-00-00 00:00:00', NULL),
(79, 19, 1, 0, 0, 0, 0, '2017-03-14 05:49:54', '0000-00-00 00:00:00', NULL),
(80, 35, 1, 0, 0, 0, 0, '2017-03-16 01:15:07', '0000-00-00 00:00:00', NULL),
(83, 38, 1, 0, 0, 0, 0, '2017-03-02 05:15:35', '0000-00-00 00:00:00', NULL),
(84, 39, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(85, 39, 2, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(86, 39, 3, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(87, 39, 4, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(88, 8, 4, 0, 0, 0, 0, '2017-03-16 06:16:51', '0000-00-00 00:00:00', NULL),
(89, 40, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(90, 40, 2, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(91, 40, 3, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(92, 40, 4, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(93, 40, 5, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(94, 41, 1, 0, 0, 0, 0, '2017-03-24 04:31:06', '0000-00-00 00:00:00', NULL),
(95, 42, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(96, 42, 3, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(97, 42, 2, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(98, 42, 4, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(99, 42, 5, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(100, 43, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(101, 43, 2, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(102, 43, 3, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(103, 43, 4, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(104, 44, 2, 0, 0, 0, 0, '2017-04-06 01:11:53', '0000-00-00 00:00:00', NULL),
(105, 44, 4, 0, 0, 0, 0, '2017-04-06 01:12:03', '0000-00-00 00:00:00', NULL),
(106, 45, 1, 0, 0, 0, 0, '2017-04-07 06:43:29', '0000-00-00 00:00:00', NULL),
(107, 45, 2, 0, 0, 0, 0, '2017-04-07 06:43:36', '0000-00-00 00:00:00', NULL),
(108, 45, 3, 0, 0, 0, 0, '2017-04-07 06:43:45', '0000-00-00 00:00:00', NULL),
(109, 45, 4, 0, 0, 0, 0, '2017-04-07 06:43:59', '0000-00-00 00:00:00', NULL),
(110, 33, 5, 0, 0, 0, 0, '2017-04-09 23:32:47', '0000-00-00 00:00:00', NULL),
(111, 33, 6, 0, 0, 0, 0, '2017-04-09 23:32:55', '0000-00-00 00:00:00', NULL),
(112, 46, 1, 0, 0, 0, 0, '2017-04-13 01:13:27', '0000-00-00 00:00:00', NULL),
(113, 47, 1, 0, 0, 0, 0, '2017-04-13 01:16:59', '0000-00-00 00:00:00', NULL),
(114, 47, 6, 0, 0, 0, 0, '2017-04-13 01:17:46', '0000-00-00 00:00:00', NULL),
(115, 48, 1, 0, 0, 0, 0, '2017-04-13 01:16:59', '0000-00-00 00:00:00', NULL),
(116, 48, 6, 0, 0, 0, 0, '2017-04-13 01:17:46', '0000-00-00 00:00:00', NULL),
(117, 49, 1, 0, 0, 0, 0, '2017-04-13 01:16:59', '0000-00-00 00:00:00', NULL),
(118, 49, 6, 0, 0, 0, 0, '2017-04-13 01:17:46', '0000-00-00 00:00:00', NULL),
(119, 50, 1, 0, 0, 0, 0, '2017-04-13 05:28:43', '0000-00-00 00:00:00', NULL),
(120, 50, 6, 0, 0, 0, 0, '2017-04-13 05:28:54', '0000-00-00 00:00:00', NULL),
(121, 40, 6, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(122, 51, 1, 0, 0, 0, 0, '2017-04-14 06:07:52', '0000-00-00 00:00:00', NULL),
(123, 51, 2, 0, 0, 0, 0, '2017-04-14 06:08:02', '0000-00-00 00:00:00', NULL),
(124, 51, 3, 0, 0, 0, 0, '2017-04-14 06:08:09', '0000-00-00 00:00:00', NULL),
(125, 51, 4, 0, 0, 0, 0, '2017-04-14 06:08:18', '0000-00-00 00:00:00', NULL),
(126, 52, 1, 0, 0, 0, 0, '2017-04-14 06:08:18', '0000-00-00 00:00:00', NULL),
(127, 53, 1, 0, 0, 0, 0, '2017-04-14 06:08:18', '0000-00-00 00:00:00', NULL),
(128, 52, 2, 0, 0, 0, 0, '2017-04-14 06:08:18', '0000-00-00 00:00:00', NULL),
(129, 54, 1, 0, 0, 0, 0, '2017-04-14 06:08:18', '0000-00-00 00:00:00', NULL),
(130, 55, 1, 0, 0, 0, 0, '2017-04-19 04:37:38', '0000-00-00 00:00:00', NULL),
(131, 56, 1, 0, 0, 0, 0, '2017-04-19 04:37:48', '0000-00-00 00:00:00', NULL),
(132, 56, 2, 0, 0, 0, 0, '2017-04-19 04:37:54', '0000-00-00 00:00:00', NULL),
(133, 56, 3, 0, 0, 0, 0, '2017-04-19 04:38:01', '0000-00-00 00:00:00', NULL),
(134, 56, 4, 0, 0, 0, 0, '2017-04-19 04:38:12', '0000-00-00 00:00:00', NULL),
(135, 57, 1, 0, 0, 0, 0, '2017-04-20 00:27:49', '0000-00-00 00:00:00', NULL),
(136, 58, 1, 0, 0, 0, 0, '2017-04-20 00:27:49', '0000-00-00 00:00:00', NULL),
(137, 59, 1, 0, 0, 0, 0, '2017-04-20 00:27:49', '0000-00-00 00:00:00', NULL),
(138, 60, 1, 0, 0, 0, 0, '2017-04-20 00:27:49', '0000-00-00 00:00:00', NULL),
(140, 61, 1, 0, 0, 0, 0, '2017-04-14 06:08:18', '0000-00-00 00:00:00', NULL),
(144, 62, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(145, 62, 2, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(146, 62, 3, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(147, 62, 4, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(150, 63, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(151, 63, 2, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(152, 63, 3, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(153, 63, 4, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(156, 64, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(157, 64, 2, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(158, 64, 3, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(159, 64, 4, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(162, 65, 1, 0, 0, 0, 0, '2017-02-21 00:17:12', '0000-00-00 00:00:00', NULL),
(163, 66, 1, 0, 0, 0, 0, '2017-05-12 04:47:29', '0000-00-00 00:00:00', NULL),
(164, 66, 2, 0, 0, 0, 0, '2017-05-12 04:47:40', '0000-00-00 00:00:00', NULL),
(165, 66, 3, 0, 0, 0, 0, '2017-05-12 04:47:51', '0000-00-00 00:00:00', NULL),
(166, 66, 4, 0, 0, 0, 0, '2017-05-12 04:48:00', '0000-00-00 00:00:00', NULL),
(167, 67, 1, 0, 0, 0, 0, '2017-04-13 05:28:43', '0000-00-00 00:00:00', NULL),
(168, 67, 6, 0, 0, 0, 0, '2017-04-13 05:28:43', '0000-00-00 00:00:00', NULL),
(169, 68, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(170, 69, 1, 0, 0, 0, 0, '2017-06-09 10:49:44', '0000-00-00 00:00:00', NULL),
(171, 69, 6, 0, 0, 0, 0, '2017-06-09 12:42:37', '0000-00-00 00:00:00', NULL),
(172, 70, 1, 0, 0, 0, 0, '2017-06-13 07:20:06', '0000-00-00 00:00:00', NULL),
(173, 70, 6, 0, 0, 0, 0, '2017-06-13 07:21:11', '0000-00-00 00:00:00', NULL),
(174, 71, 1, 0, 0, 0, 0, '2017-06-13 07:21:11', '0000-00-00 00:00:00', NULL),
(175, 71, 6, 0, 0, 0, 0, '2017-06-13 07:21:11', '0000-00-00 00:00:00', NULL),
(176, 72, 1, 0, 0, 0, 0, '2017-06-13 07:21:11', '0000-00-00 00:00:00', NULL),
(177, 72, 6, 0, 0, 0, 0, '2017-06-13 07:21:11', '0000-00-00 00:00:00', NULL),
(181, 73, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(182, 73, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(187, 80, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(189, 80, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(190, 83, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(192, 83, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(193, 84, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(194, 84, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(195, 86, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(197, 86, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(199, 87, 1, 0, 0, 0, 0, '2017-06-16 05:56:07', '0000-00-00 00:00:00', NULL),
(200, 87, 6, 0, 0, 0, 0, '2017-06-16 05:56:17', '0000-00-00 00:00:00', NULL),
(201, 88, 1, 0, 0, 0, 0, '2017-06-17 11:03:15', '0000-00-00 00:00:00', NULL),
(202, 88, 6, 0, 0, 0, 0, '2017-06-17 11:03:15', '0000-00-00 00:00:00', NULL),
(203, 89, 1, 0, 0, 0, 0, '2017-06-17 11:03:36', '0000-00-00 00:00:00', NULL),
(204, 89, 6, 0, 0, 0, 0, '2017-06-17 11:03:36', '0000-00-00 00:00:00', NULL),
(205, 90, 1, 0, 0, 0, 0, '2017-06-17 11:03:54', '0000-00-00 00:00:00', NULL),
(206, 90, 6, 0, 0, 0, 0, '2017-06-17 11:03:54', '0000-00-00 00:00:00', NULL),
(207, 91, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(209, 91, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(210, 92, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(212, 92, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(213, 93, 1, 0, 0, 0, 0, '2017-06-19 07:26:19', '0000-00-00 00:00:00', NULL),
(214, 93, 6, 0, 0, 0, 0, '2017-06-19 07:26:19', '0000-00-00 00:00:00', NULL),
(215, 94, 1, 0, 0, 0, 0, '2017-06-19 11:38:37', '0000-00-00 00:00:00', NULL),
(216, 94, 6, 0, 0, 0, 0, '2017-06-19 11:38:37', '0000-00-00 00:00:00', NULL),
(217, 95, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(219, 95, 6, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(220, 96, 1, 0, 0, 0, 0, '2017-06-20 10:42:57', '0000-00-00 00:00:00', NULL),
(221, 96, 6, 0, 0, 0, 0, '2017-06-20 10:42:57', '0000-00-00 00:00:00', NULL),
(222, 97, 1, 0, 0, 0, 0, '2017-05-16 08:23:29', '0000-00-00 00:00:00', NULL),
(223, 51, 6, 0, 0, 0, 0, '2017-07-06 11:42:25', '0000-00-00 00:00:00', NULL),
(225, 98, 1, 0, 0, 0, 0, '2017-07-18 07:12:21', '0000-00-00 00:00:00', NULL),
(226, 98, 2, 0, 0, 0, 0, '2017-07-18 07:12:29', '0000-00-00 00:00:00', NULL),
(227, 98, 3, 0, 0, 0, 0, '2017-07-18 07:12:41', '0000-00-00 00:00:00', NULL),
(228, 98, 4, 0, 0, 0, 0, '2017-07-18 07:12:41', '0000-00-00 00:00:00', NULL),
(229, 99, 1, 0, 0, 0, 0, '2017-04-13 01:13:27', '0000-00-00 00:00:00', NULL);

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

--
-- Table structure for table `sps_nested_log`
--

CREATE TABLE IF NOT EXISTS `sps_nested_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `transaction_id` bigint(20) NOT NULL,
  `in_gate` bigint(20) DEFAULT NULL,
  `out_gate` bigint(20) DEFAULT NULL,
  `in_datetime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `out_datetime` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_payment_modes`
--

CREATE TABLE IF NOT EXISTS `sps_payment_modes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `payment_mode` varchar(255) NOT NULL,
  `master_id` bigint(20) NOT NULL,
  `parent_id` tinyint(4) DEFAULT '0',
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `payment_description` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_peak_hours_list`
--

CREATE TABLE IF NOT EXISTS `sps_peak_hours_list` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_reports`
--

CREATE TABLE IF NOT EXISTS `sps_reports` (
  `report_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date_of_report` datetime NOT NULL,
  `filename` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sps_reports`
--

INSERT INTO `sps_reports` (`report_id`, `date_of_report`, `filename`, `status`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, '2017-10-29 21:30:16', 'EOD20171030093014.pdf', 1, 0, 0, 0, 0, '2017-10-30 21:30:16', '2017-10-30 21:30:16'),
(2, '2017-10-29 21:31:10', 'EOD20171030093109.pdf', 1, 0, 0, 0, 0, '2017-10-30 21:31:10', '2017-10-30 21:31:10'),
(3, '2017-10-30 12:10:03', 'EOD20171031121002.pdf', 1, 0, 0, 0, 0, '2017-10-31 12:10:03', '2017-10-31 12:10:03');

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

--
-- Table structure for table `sps_service_type`
--

CREATE TABLE IF NOT EXISTS `sps_service_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_settlement`
--

CREATE TABLE IF NOT EXISTS `sps_settlement` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `shift_id` bigint(20) NOT NULL,
  `gate_id` bigint(20) NOT NULL,
  `systems_cash` double(20,2) DEFAULT NULL,
  `actual_income` double(20,2) NOT NULL DEFAULT '0.00',
  `quantity_problem` bigint(20) NOT NULL,
  `amount_problem` double(20,2) NOT NULL,
  `settlement_status` tinyint(4) NOT NULL,
  `difference_status` tinyint(4) NOT NULL,
  `settlement_amount` float NOT NULL DEFAULT '0',
  `amount_recovered` float NOT NULL DEFAULT '0',
  `difference_reason` text NOT NULL,
  `lost_ticket_qty` int(11) DEFAULT '0',
  `lost_ticket_penalty` float(10,2) DEFAULT '0.00',
  `f_eight_ticket_qty` int(11) DEFAULT '0',
  `f_eight_ticket_charges` float(10,2) DEFAULT '0.00',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_shift_gate_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_shift_gate_mapping` (
  `sg_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `shift_id` bigint(20) NOT NULL,
  `gate_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`sg_id`),
  KEY `shift_id` (`shift_id`),
  KEY `gate_id` (`gate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_shift_management`
--

CREATE TABLE IF NOT EXISTS `sps_shift_management` (
  `sr_no` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `user_type` tinyint(4) NOT NULL,
  `shift_start` datetime NOT NULL,
  `shift_end` datetime DEFAULT NULL,
  `first_login_time` datetime DEFAULT NULL,
  `end_shift_status` tinyint(4) NOT NULL DEFAULT '0',
  `shift_login_status` tinyint(4) NOT NULL DEFAULT '0',
  `shift_activate_status` tinyint(4) NOT NULL DEFAULT '0',
  `shift_settlement_status` tinyint(4) DEFAULT '0',
  `difference_status` tinyint(4) NOT NULL,
  `settlement_id` bigint(20) DEFAULT NULL,
  `float_amount` int(11) DEFAULT '0',
  `accept_float` tinytext NOT NULL,
  `f_eight_used` int(11) NOT NULL,
  `f_eight_granted` int(11) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sr_no`),
  KEY `user_id` (`user_id`),
  KEY `settlement_id` (`settlement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_special_days`
--

CREATE TABLE IF NOT EXISTS `sps_special_days` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `special_day` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `sps_special_days`
--

INSERT INTO `sps_special_days` (`id`, `special_day`, `date`, `location_id`, `area_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'diwali', '2017-06-20', 0, 0, 0, 0, '2017-06-15 11:13:35', '2017-06-15 11:13:40', '2017-06-15 11:13:40'),
(2, 'Diwali1', '2017-06-20', 0, 0, 0, 0, '2017-06-15 11:13:51', '2017-06-15 11:36:43', '2017-06-15 11:36:43'),
(3, 'holi', '2017-06-23', 0, 0, 0, 0, '2017-06-15 11:32:54', '2017-06-15 11:33:03', '2017-06-15 11:33:03'),
(4, 'a as1', '2017-06-22', 0, 0, 0, 0, '2017-06-15 11:36:10', '2017-06-15 11:36:28', '2017-06-15 11:36:28'),
(5, 'womens day', '2017-06-15', 0, 0, 0, 0, '2017-06-15 11:55:10', '2017-06-15 12:06:39', '2017-06-15 12:06:39'),
(6, 'gt', '2017-06-15', 0, 0, 0, 0, '2017-06-15 13:02:47', '2017-06-21 15:18:04', '2017-06-21 15:18:04'),
(7, 'test', '2017-06-21', 0, 0, 0, 0, '2017-06-20 18:58:48', '2017-06-20 18:58:48', NULL),
(8, 'womens day', '2017-06-22', 0, 0, 0, 0, '2017-06-21 15:18:57', '2017-06-21 15:18:57', NULL),
(9, 'check', '2017-06-22', 0, 0, 0, 0, '2017-06-21 15:20:14', '2017-06-21 15:20:14', NULL),
(10, '232424', '2017-06-22', 0, 0, 0, 0, '2017-06-21 15:20:28', '2017-06-21 15:22:18', '2017-06-21 15:22:18'),
(11, 'kgmhghf vg', '2017-06-22', 0, 0, 0, 0, '2017-06-21 15:21:38', '2017-06-21 15:21:38', NULL),
(12, 'd', '2017-06-23', 0, 0, 0, 0, '2017-06-21 15:22:10', '2017-06-21 15:22:10', NULL),
(13, 'wdsdf jkl jkhk', '2017-06-23', 0, 0, 0, 0, '2017-06-21 15:39:11', '2017-06-21 15:39:11', NULL),
(14, 'jop', '2017-06-22', 0, 0, 0, 0, '2017-06-21 15:39:22', '2017-06-21 15:39:22', NULL),
(15, 'lobhhkl', '2017-06-22', 0, 0, 0, 0, '2017-06-21 15:39:29', '2017-06-21 15:39:29', NULL),
(16, 'womens day', '2017-06-22', 0, 0, 0, 0, '2017-06-21 15:39:41', '2017-06-21 15:39:41', NULL),
(17, 'bngn', '2017-06-30', 0, 0, 0, 0, '2017-06-21 15:40:00', '2017-06-21 15:40:00', NULL),
(18, 'check', '2017-07-05', 0, 0, 0, 0, '2017-06-21 15:40:11', '2017-06-21 15:40:11', NULL),
(19, 'Testing Day', '2017-08-03', 0, 0, 0, 0, '2017-08-03 15:55:24', '2017-08-03 16:24:24', '2017-08-03 16:24:24'),
(20, 'Special', '2017-08-03', 0, 0, 0, 0, '2017-08-03 17:31:59', '2017-08-03 17:31:59', NULL),
(21, 'Rick special day', '2017-08-05', 0, 0, 0, 0, '2017-08-05 17:25:04', '2017-08-05 19:17:04', '2017-08-05 19:17:04');

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

--
-- Table structure for table `sps_tariff`
--

CREATE TABLE IF NOT EXISTS `sps_tariff` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tariff_code` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `start_time` tinytext NOT NULL,
  `end_time` tinytext NOT NULL,
  `tariff_unit` tinyint(4) NOT NULL,
  `day_type` tinyint(4) NOT NULL,
  `vehicle_type` bigint(20) NOT NULL,
  `start_tolerance` smallint(4) NOT NULL DEFAULT '0',
  `end_tolerance` smallint(4) NOT NULL DEFAULT '0',
  `lost_ticket_charge` int(11) NOT NULL DEFAULT '0',
  `penalty_duration` int(11) NOT NULL DEFAULT '0',
  `penalty_charge` int(11) NOT NULL DEFAULT '0',
  `flat_tariff_charge` int(11) NOT NULL DEFAULT '0',
  `max_charge` int(11) NOT NULL DEFAULT '0',
  `pay_once` tinyint(1) NOT NULL DEFAULT '0',
  `payment_at_entry` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_tariff_additionals`
--

CREATE TABLE IF NOT EXISTS `sps_tariff_additionals` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `day_type` tinytext NOT NULL,
  `service_type` bigint(20) NOT NULL,
  `vehicle_type` varchar(255) NOT NULL,
  `gate` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `additional_tariff` int(11) NOT NULL DEFAULT '0',
  `start_limit` time NOT NULL,
  `end_limit` time NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `service_type` (`service_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_tariff_location`
--

CREATE TABLE IF NOT EXISTS `sps_tariff_location` (
  `tariff_location_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_tariff_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`tariff_location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_tariff_member`
--

CREATE TABLE IF NOT EXISTS `sps_tariff_member` (
  `member_tariff_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `tariff_member_code` varchar(255) NOT NULL,
  `tariff_name` varchar(100) NOT NULL,
  `started_date` date NOT NULL,
  `type_member` bigint(20) NOT NULL,
  `vehicle_type` bigint(20) NOT NULL,
  `day_type` varchar(255) NOT NULL,
  `group` bigint(20) NOT NULL,
  `period_length` bigint(20) NOT NULL,
  `period_type` bigint(20) NOT NULL,
  `tolerance` bigint(20) NOT NULL,
  `tariff` int(11) NOT NULL DEFAULT '0',
  `police_change_charge` int(11) NOT NULL,
  `new_card_charge` int(11) NOT NULL,
  `area_tariff` int(11) NOT NULL,
  `rfid_options` tinyint(4) NOT NULL,
  `min_tariff` int(11) NOT NULL,
  `no_of_trips` int(11) DEFAULT NULL,
  `no_of_hours` int(11) DEFAULT NULL,
  `change_card_charge` int(11) NOT NULL,
  `proposal_1` int(11) NOT NULL,
  `proposal_2` int(11) NOT NULL,
  `proposal_3` int(11) NOT NULL,
  `proposal_4` int(11) NOT NULL,
  `proposal_5` int(11) NOT NULL,
  `proposal_6` int(11) NOT NULL,
  `valet_charge` tinyint(4) DEFAULT NULL,
  `notes` text NOT NULL,
  `full_jam` tinyint(4) NOT NULL,
  `duration_type` tinyint(11) NOT NULL,
  `period_jam_from` time NOT NULL,
  `period_jam_to` time NOT NULL,
  `duration` int(11) NOT NULL,
  `administration_discount` int(11) NOT NULL,
  `status` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`member_tariff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_tariff_overnight`
--

CREATE TABLE IF NOT EXISTS `sps_tariff_overnight` (
  `overnight_tariff_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `code` varchar(255) NOT NULL,
  `valid_start_date` date NOT NULL,
  `vehicle_type` bigint(20) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `overnight_duration` bigint(20) NOT NULL,
  `tariff_unit` bigint(20) NOT NULL,
  `tariff` int(11) NOT NULL DEFAULT '0',
  `max_tariff` int(11) NOT NULL DEFAULT '0',
  `subscriber_tariff` bigint(20) NOT NULL DEFAULT '0',
  `duration_of_tolerance` bigint(20) NOT NULL DEFAULT '0',
  `tariff_calculation` bigint(20) NOT NULL,
  `started_time` bigint(20) NOT NULL,
  `started_duration` bigint(20) NOT NULL,
  `tariff_has_included` bigint(20) NOT NULL,
  `status` tinyint(1) DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `sync_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`overnight_tariff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_tariff_tier`
--

CREATE TABLE IF NOT EXISTS `sps_tariff_tier` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tariff_id` bigint(20) NOT NULL,
  `tier_type` tinyint(4) NOT NULL,
  `tier_unit` bigint(20) NOT NULL,
  `tier_charge` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tariff_id` (`tariff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_tariff_vehicle_type_mapping`
--

CREATE TABLE IF NOT EXISTS `sps_tariff_vehicle_type_mapping` (
  `tariff_vehicle_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tariff_id` bigint(20) NOT NULL,
  `vehicle_type_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  PRIMARY KEY (`tariff_vehicle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_tax`
--

CREATE TABLE IF NOT EXISTS `sps_tax` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `label` varchar(100) NOT NULL,
  `percentage` int(11) NOT NULL,
  `calculation_base` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `old_id` bigint(20) NOT NULL,
  `superadmin` tinyint(4) NOT NULL,
  `sync_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_ticket_layouts`
--

CREATE TABLE IF NOT EXISTS `sps_ticket_layouts` (
  `layout_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `gate_type` tinyint(4) NOT NULL,
  `ticket_type` tinyint(4) NOT NULL,
  `up_line` int(11) NOT NULL,
  `bottom_line` int(11) NOT NULL,
  `left_margin` int(11) NOT NULL,
  `right_margin` int(11) NOT NULL,
  `header_a` varchar(255) NOT NULL,
  `header_b` varchar(255) NOT NULL,
  `header_c` varchar(255) NOT NULL,
  `header_a_align` varchar(10) NOT NULL,
  `header_b_align` varchar(10) NOT NULL,
  `header_c_align` varchar(10) NOT NULL,
  `common_a` varchar(255) NOT NULL,
  `common_b` varchar(255) NOT NULL,
  `common_c` varchar(255) NOT NULL,
  `common_a_align` varchar(10) NOT NULL,
  `common_b_align` varchar(10) NOT NULL,
  `common_c_align` varchar(10) NOT NULL,
  `footer_a` varchar(255) NOT NULL,
  `footer_b` varchar(255) NOT NULL,
  `footer_c` varchar(255) NOT NULL,
  `footer_a_align` varchar(10) NOT NULL,
  `footer_b_align` varchar(10) NOT NULL,
  `footer_c_align` varchar(10) NOT NULL,
  `parking_provider` varchar(255) NOT NULL,
  `logo_position` varchar(11) NOT NULL,
  `logo` varchar(512) DEFAULT NULL,
  `logo_b` varchar(512) DEFAULT NULL,
  `logo_align` varchar(11) NOT NULL,
  `logo_b_position` varchar(11) NOT NULL,
  `logo_b_align` varchar(11) NOT NULL,
  `tax_notes` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `sync_at` timestamp NULL DEFAULT NULL,
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`layout_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_ticket_options`
--

CREATE TABLE IF NOT EXISTS `sps_ticket_options` (
  `option_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `layout_id` bigint(20) NOT NULL,
  `option_name` varchar(255) NOT NULL,
  `option_label` varchar(256) NOT NULL,
  `label` varchar(45) NOT NULL DEFAULT '',
  `option_value` varchar(255) NOT NULL,
  `order` int(11) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  PRIMARY KEY (`option_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=267 ;

--
-- Dumping data for table `sps_ticket_options`
--

INSERT INTO `sps_ticket_options` (`option_id`, `layout_id`, `option_name`, `option_label`, `label`, `option_value`, `order`, `location_id`, `area_id`) VALUES
(1, 13, 'location_name', 'Location Name', 'L01', '1', 1, 0, 0),
(2, 13, 'vehicle_type', 'Vehicle Type', 'L02', '1', 2, 0, 0),
(3, 13, 'entry_operator', 'Entry Operator', 'L06', '1', 3, 0, 0),
(4, 13, 'entry_gate', 'Entry Gate', 'L05', '1', 4, 0, 0),
(5, 13, 'entry_date', 'Entry Date', '', '0', 0, 0, 0),
(6, 13, 'entry_hour', 'Entry Hour', '', '0', 0, 0, 0),
(7, 13, 'exit_date', 'Exit Date', '', '0', 0, 0, 0),
(8, 13, 'exit_hour', 'Exit Hour', '', '0', 0, 0, 0),
(9, 13, 'exit_gate', 'Exit Gate', '', '0', 0, 0, 0),
(10, 13, 'exit_operator', 'Exit Operator', '', '0', 0, 0, 0),
(11, 13, 'duration', 'Duration', '', '0', 0, 0, 0),
(12, 13, 'service_type', 'Service Type', '', '0', 0, 0, 0),
(13, 13, 'customer_name', 'Customer Name', '', '0', 0, 0, 0),
(14, 13, 'print_when_it_is_free', 'Print When It Is Free', '', '0', 0, 0, 0),
(15, 13, 'print_the_operator_name', 'Print The Operator Name', '', '0', 0, 0, 0),
(16, 13, 'payment_mode', 'Payment Mode', '', '0', 0, 0, 0),
(17, 13, 'ticket_bifurcation', 'Ticket Bifurcation', '', '0', 0, 0, 0),
(18, 13, 'tariff_has_included', 'Tariff Has Included', '', '0', 0, 0, 0),
(19, 13, 'tax_bifurcation', 'Tax Bifurcation', '', '0', 0, 0, 0),
(77, 14, 'vehicle_type', 'Vehicle Type', 'L02', '1', 1, 0, 0),
(78, 14, 'location_name', 'Location Name', 'L01', '1', 2, 0, 0),
(79, 14, 'entry_date', 'Entry Date', 'L03', '1', 3, 0, 0),
(80, 14, 'entry_hour', 'Entry Hour', 'L04', '1', 4, 0, 0),
(81, 14, 'ticket_bifurcation', 'Ticket Bifurcation', 'L14', '1', 5, 0, 0),
(82, 14, 'tax_bifurcation', 'Tax Bifurcation', 'L19', '1', 6, 0, 0),
(83, 14, 'entry_gate', 'Entry Gate', 'L05', '1', 7, 0, 0),
(84, 14, 'entry_operator', 'Entry Operator', 'L06', '1', 8, 0, 0),
(85, 14, 'exit_date', 'Exit Date', 'L07', '0', 0, 0, 0),
(86, 14, 'exit_hour', 'Exit Hour', 'L08', '0', 0, 0, 0),
(87, 14, 'exit_gate', 'Exit Gate', 'L09', '0', 0, 0, 0),
(88, 14, 'exit_operator', 'Exit Operator', 'L10', '0', 0, 0, 0),
(89, 14, 'duration', 'Duration', 'L11', '0', 0, 0, 0),
(90, 14, 'service_type', 'Service Type', 'L12', '0', 0, 0, 0),
(91, 14, 'customer_name', 'Customer Name', 'L13', '0', 0, 0, 0),
(92, 14, 'print_when_it_is_free', 'Print When It Is Free', 'L16', '0', 0, 0, 0),
(93, 14, 'print_the_operator_name', 'Print The Operator Name', 'L17', '0', 0, 0, 0),
(94, 14, 'payment_mode', 'Payment Mode', 'L15', '0', 0, 0, 0),
(95, 14, 'tariff_has_included', 'Tariff Has Included', 'L18', '0', 0, 0, 0),
(229, 15, 'vehicle_type', 'Vehicle Type', 'L02', '1', 1, 0, 0),
(230, 15, 'entry_date', 'Entry Date', 'L03', '1', 2, 0, 0),
(231, 15, 'exit_date', 'Exit Date', 'L07', '1', 3, 0, 0),
(232, 15, 'entry_operator', 'Entry Operator', 'L06', '1', 4, 0, 0),
(233, 15, 'entry_gate', 'Entry Gate', 'L05', '1', 5, 0, 0),
(234, 15, 'exit_gate', 'Exit Gate', 'L09', '1', 6, 0, 0),
(235, 15, 'location_name', 'Location Name', 'L01', '1', 7, 0, 0),
(236, 15, 'duration', 'Duration', 'L11', '1', 8, 0, 0),
(237, 15, 'exit_operator', 'Exit Operator', 'L10', '1', 9, 0, 0),
(238, 15, 'print_the_operator_name', 'Print The Operator Name', 'L17', '1', 10, 0, 0),
(239, 15, 'tax_bifurcation', 'Tax Bifurcation', 'L19', '1', 11, 0, 0),
(240, 15, 'tariff_has_included', 'Tariff Has Included', 'L18', '1', 12, 0, 0),
(241, 15, 'print_when_it_is_free', 'Print When It Is Free', 'L16', '1', 13, 0, 0),
(242, 15, 'customer_name', 'Customer Name', 'L13', '1', 14, 0, 0),
(243, 15, 'ticket_bifurcation', 'Ticket Bifurcation', 'L14', '1', 15, 0, 0),
(244, 15, 'payment_mode', 'Payment Mode', 'L15', '1', 16, 0, 0),
(245, 15, 'service_type', 'Service Type', 'L12', '1', 17, 0, 0),
(246, 15, 'exit_hour', 'Exit Hour', 'L08', '1', 18, 0, 0),
(247, 15, 'entry_hour', 'Entry Hour', 'L04', '1', 19, 0, 0),
(248, 16, 'vehicle_type', 'Vehicle Type', 'L02', '1', 1, 0, 0),
(249, 16, 'entry_date', 'Entry Date', 'L03', '1', 2, 0, 0),
(250, 16, 'exit_date', 'Exit Date', 'L07', '1', 3, 0, 0),
(251, 16, 'entry_gate', 'Entry Gate', 'L05', '1', 4, 0, 0),
(252, 16, 'exit_gate', 'Exit Gate', 'L09', '1', 5, 0, 0),
(253, 16, 'entry_operator', 'Entry Operator', 'L06', '1', 6, 0, 0),
(254, 16, 'duration', 'Duration', 'L11', '1', 7, 0, 0),
(255, 16, 'exit_hour', 'Exit Hour', 'L08', '1', 8, 0, 0),
(256, 16, 'entry_hour', 'Entry Hour', 'L04', '1', 9, 0, 0),
(257, 16, 'payment_mode', 'Payment Mode', 'L15', '1', 10, 0, 0),
(258, 16, 'exit_operator', 'Exit Operator', 'L10', '1', 11, 0, 0),
(259, 16, 'ticket_bifurcation', 'Ticket Bifurcation', 'L14', '1', 12, 0, 0),
(260, 16, 'tax_bifurcation', 'Tax Bifurcation', 'L19', '1', 13, 0, 0),
(261, 16, 'location_name', 'Location Name', 'L01', '0', 0, 0, 0),
(262, 16, 'service_type', 'Service Type', 'L12', '0', 0, 0, 0),
(263, 16, 'customer_name', 'Customer Name', 'L13', '0', 0, 0, 0),
(264, 16, 'print_when_it_is_free', 'Print When It Is Free', 'L16', '0', 0, 0, 0),
(265, 16, 'print_the_operator_name', 'Print The Operator Name', 'L17', '0', 0, 0, 0),
(266, 16, 'tariff_has_included', 'Tariff Has Included', 'L18', '0', 0, 0, 0);

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

--
-- Table structure for table `sps_timezone`
--

CREATE TABLE IF NOT EXISTS `sps_timezone` (
  `zone_id` int(10) NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(35) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`zone_id`),
  KEY `idx_zone_name` (`zone_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=425 ;

--
-- Dumping data for table `sps_timezone`
--

INSERT INTO `sps_timezone` (`zone_id`, `zone_name`) VALUES
(1, 'Europe/Andorra'),
(2, 'Asia/Dubai'),
(3, 'Asia/Kabul'),
(4, 'America/Antigua'),
(5, 'America/Anguilla'),
(6, 'Europe/Tirane'),
(7, 'Asia/Yerevan'),
(8, 'Africa/Luanda'),
(9, 'Antarctica/McMurdo'),
(10, 'Antarctica/Casey'),
(11, 'Antarctica/Davis'),
(12, 'Antarctica/DumontDUrville'),
(13, 'Antarctica/Mawson'),
(14, 'Antarctica/Palmer'),
(15, 'Antarctica/Rothera'),
(16, 'Antarctica/Syowa'),
(17, 'Antarctica/Troll'),
(18, 'Antarctica/Vostok'),
(19, 'America/Argentina/Buenos_Aires'),
(20, 'America/Argentina/Cordoba'),
(21, 'America/Argentina/Salta'),
(22, 'America/Argentina/Jujuy'),
(23, 'America/Argentina/Tucuman'),
(24, 'America/Argentina/Catamarca'),
(25, 'America/Argentina/La_Rioja'),
(26, 'America/Argentina/San_Juan'),
(27, 'America/Argentina/Mendoza'),
(28, 'America/Argentina/San_Luis'),
(29, 'America/Argentina/Rio_Gallegos'),
(30, 'America/Argentina/Ushuaia'),
(31, 'Pacific/Pago_Pago'),
(32, 'Europe/Vienna'),
(33, 'Australia/Lord_Howe'),
(34, 'Antarctica/Macquarie'),
(35, 'Australia/Hobart'),
(36, 'Australia/Currie'),
(37, 'Australia/Melbourne'),
(38, 'Australia/Sydney'),
(39, 'Australia/Broken_Hill'),
(40, 'Australia/Brisbane'),
(41, 'Australia/Lindeman'),
(42, 'Australia/Adelaide'),
(43, 'Australia/Darwin'),
(44, 'Australia/Perth'),
(45, 'Australia/Eucla'),
(46, 'America/Aruba'),
(47, 'Europe/Mariehamn'),
(48, 'Asia/Baku'),
(49, 'Europe/Sarajevo'),
(50, 'America/Barbados'),
(51, 'Asia/Dhaka'),
(52, 'Europe/Brussels'),
(53, 'Africa/Ouagadougou'),
(54, 'Europe/Sofia'),
(55, 'Asia/Bahrain'),
(56, 'Africa/Bujumbura'),
(57, 'Africa/Porto-Novo'),
(58, 'America/St_Barthelemy'),
(59, 'Atlantic/Bermuda'),
(60, 'Asia/Brunei'),
(61, 'America/La_Paz'),
(62, 'America/Kralendijk'),
(63, 'America/Noronha'),
(64, 'America/Belem'),
(65, 'America/Fortaleza'),
(66, 'America/Recife'),
(67, 'America/Araguaina'),
(68, 'America/Maceio'),
(69, 'America/Bahia'),
(70, 'America/Sao_Paulo'),
(71, 'America/Campo_Grande'),
(72, 'America/Cuiaba'),
(73, 'America/Santarem'),
(74, 'America/Porto_Velho'),
(75, 'America/Boa_Vista'),
(76, 'America/Manaus'),
(77, 'America/Eirunepe'),
(78, 'America/Rio_Branco'),
(79, 'America/Nassau'),
(80, 'Asia/Thimphu'),
(81, 'Africa/Gaborone'),
(82, 'Europe/Minsk'),
(83, 'America/Belize'),
(84, 'America/St_Johns'),
(85, 'America/Halifax'),
(86, 'America/Glace_Bay'),
(87, 'America/Moncton'),
(88, 'America/Goose_Bay'),
(89, 'America/Blanc-Sablon'),
(90, 'America/Toronto'),
(91, 'America/Nipigon'),
(92, 'America/Thunder_Bay'),
(93, 'America/Iqaluit'),
(94, 'America/Pangnirtung'),
(95, 'America/Atikokan'),
(96, 'America/Winnipeg'),
(97, 'America/Rainy_River'),
(98, 'America/Resolute'),
(99, 'America/Rankin_Inlet'),
(100, 'America/Regina'),
(101, 'America/Swift_Current'),
(102, 'America/Edmonton'),
(103, 'America/Cambridge_Bay'),
(104, 'America/Yellowknife'),
(105, 'America/Inuvik'),
(106, 'America/Creston'),
(107, 'America/Dawson_Creek'),
(108, 'America/Fort_Nelson'),
(109, 'America/Vancouver'),
(110, 'America/Whitehorse'),
(111, 'America/Dawson'),
(112, 'Indian/Cocos'),
(113, 'Africa/Kinshasa'),
(114, 'Africa/Lubumbashi'),
(115, 'Africa/Bangui'),
(116, 'Africa/Brazzaville'),
(117, 'Europe/Zurich'),
(118, 'Africa/Abidjan'),
(119, 'Pacific/Rarotonga'),
(120, 'America/Santiago'),
(121, 'America/Punta_Arenas'),
(122, 'Pacific/Easter'),
(123, 'Africa/Douala'),
(124, 'Asia/Shanghai'),
(125, 'Asia/Urumqi'),
(126, 'America/Bogota'),
(127, 'America/Costa_Rica'),
(128, 'America/Havana'),
(129, 'Atlantic/Cape_Verde'),
(130, 'America/Curacao'),
(131, 'Indian/Christmas'),
(132, 'Asia/Nicosia'),
(133, 'Asia/Famagusta'),
(134, 'Europe/Prague'),
(135, 'Europe/Berlin'),
(136, 'Europe/Busingen'),
(137, 'Africa/Djibouti'),
(138, 'Europe/Copenhagen'),
(139, 'America/Dominica'),
(140, 'America/Santo_Domingo'),
(141, 'Africa/Algiers'),
(142, 'America/Guayaquil'),
(143, 'Pacific/Galapagos'),
(144, 'Europe/Tallinn'),
(145, 'Africa/Cairo'),
(146, 'Africa/El_Aaiun'),
(147, 'Africa/Asmara'),
(148, 'Europe/Madrid'),
(149, 'Africa/Ceuta'),
(150, 'Atlantic/Canary'),
(151, 'Africa/Addis_Ababa'),
(152, 'Europe/Helsinki'),
(153, 'Pacific/Fiji'),
(154, 'Atlantic/Stanley'),
(155, 'Pacific/Chuuk'),
(156, 'Pacific/Pohnpei'),
(157, 'Pacific/Kosrae'),
(158, 'Atlantic/Faroe'),
(159, 'Europe/Paris'),
(160, 'Africa/Libreville'),
(161, 'Europe/London'),
(162, 'America/Grenada'),
(163, 'Asia/Tbilisi'),
(164, 'America/Cayenne'),
(165, 'Europe/Guernsey'),
(166, 'Africa/Accra'),
(167, 'Europe/Gibraltar'),
(168, 'America/Godthab'),
(169, 'America/Danmarkshavn'),
(170, 'America/Scoresbysund'),
(171, 'America/Thule'),
(172, 'Africa/Banjul'),
(173, 'Africa/Conakry'),
(174, 'America/Guadeloupe'),
(175, 'Africa/Malabo'),
(176, 'Europe/Athens'),
(177, 'Atlantic/South_Georgia'),
(178, 'America/Guatemala'),
(179, 'Pacific/Guam'),
(180, 'Africa/Bissau'),
(181, 'America/Guyana'),
(182, 'Asia/Hong_Kong'),
(183, 'America/Tegucigalpa'),
(184, 'Europe/Zagreb'),
(185, 'America/Port-au-Prince'),
(186, 'Europe/Budapest'),
(187, 'Asia/Jakarta'),
(188, 'Asia/Pontianak'),
(189, 'Asia/Makassar'),
(190, 'Asia/Jayapura'),
(191, 'Europe/Dublin'),
(192, 'Asia/Jerusalem'),
(193, 'Europe/Isle_of_Man'),
(194, 'Asia/Kolkata'),
(195, 'Indian/Chagos'),
(196, 'Asia/Baghdad'),
(197, 'Asia/Tehran'),
(198, 'Atlantic/Reykjavik'),
(199, 'Europe/Rome'),
(200, 'Europe/Jersey'),
(201, 'America/Jamaica'),
(202, 'Asia/Amman'),
(203, 'Asia/Tokyo'),
(204, 'Africa/Nairobi'),
(205, 'Asia/Bishkek'),
(206, 'Asia/Phnom_Penh'),
(207, 'Pacific/Tarawa'),
(208, 'Pacific/Enderbury'),
(209, 'Pacific/Kiritimati'),
(210, 'Indian/Comoro'),
(211, 'America/St_Kitts'),
(212, 'Asia/Pyongyang'),
(213, 'Asia/Seoul'),
(214, 'Asia/Kuwait'),
(215, 'America/Cayman'),
(216, 'Asia/Almaty'),
(217, 'Asia/Qyzylorda'),
(218, 'Asia/Aqtobe'),
(219, 'Asia/Aqtau'),
(220, 'Asia/Atyrau'),
(221, 'Asia/Oral'),
(222, 'Asia/Vientiane'),
(223, 'Asia/Beirut'),
(224, 'America/St_Lucia'),
(225, 'Europe/Vaduz'),
(226, 'Asia/Colombo'),
(227, 'Africa/Monrovia'),
(228, 'Africa/Maseru'),
(229, 'Europe/Vilnius'),
(230, 'Europe/Luxembourg'),
(231, 'Europe/Riga'),
(232, 'Africa/Tripoli'),
(233, 'Africa/Casablanca'),
(234, 'Europe/Monaco'),
(235, 'Europe/Chisinau'),
(236, 'Europe/Podgorica'),
(237, 'America/Marigot'),
(238, 'Indian/Antananarivo'),
(239, 'Pacific/Majuro'),
(240, 'Pacific/Kwajalein'),
(241, 'Europe/Skopje'),
(242, 'Africa/Bamako'),
(243, 'Asia/Yangon'),
(244, 'Asia/Ulaanbaatar'),
(245, 'Asia/Hovd'),
(246, 'Asia/Choibalsan'),
(247, 'Asia/Macau'),
(248, 'Pacific/Saipan'),
(249, 'America/Martinique'),
(250, 'Africa/Nouakchott'),
(251, 'America/Montserrat'),
(252, 'Europe/Malta'),
(253, 'Indian/Mauritius'),
(254, 'Indian/Maldives'),
(255, 'Africa/Blantyre'),
(256, 'America/Mexico_City'),
(257, 'America/Cancun'),
(258, 'America/Merida'),
(259, 'America/Monterrey'),
(260, 'America/Matamoros'),
(261, 'America/Mazatlan'),
(262, 'America/Chihuahua'),
(263, 'America/Ojinaga'),
(264, 'America/Hermosillo'),
(265, 'America/Tijuana'),
(266, 'America/Bahia_Banderas'),
(267, 'Asia/Kuala_Lumpur'),
(268, 'Asia/Kuching'),
(269, 'Africa/Maputo'),
(270, 'Africa/Windhoek'),
(271, 'Pacific/Noumea'),
(272, 'Africa/Niamey'),
(273, 'Pacific/Norfolk'),
(274, 'Africa/Lagos'),
(275, 'America/Managua'),
(276, 'Europe/Amsterdam'),
(277, 'Europe/Oslo'),
(278, 'Asia/Kathmandu'),
(279, 'Pacific/Nauru'),
(280, 'Pacific/Niue'),
(281, 'Pacific/Auckland'),
(282, 'Pacific/Chatham'),
(283, 'Asia/Muscat'),
(284, 'America/Panama'),
(285, 'America/Lima'),
(286, 'Pacific/Tahiti'),
(287, 'Pacific/Marquesas'),
(288, 'Pacific/Gambier'),
(289, 'Pacific/Port_Moresby'),
(290, 'Pacific/Bougainville'),
(291, 'Asia/Manila'),
(292, 'Asia/Karachi'),
(293, 'Europe/Warsaw'),
(294, 'America/Miquelon'),
(295, 'Pacific/Pitcairn'),
(296, 'America/Puerto_Rico'),
(297, 'Asia/Gaza'),
(298, 'Asia/Hebron'),
(299, 'Europe/Lisbon'),
(300, 'Atlantic/Madeira'),
(301, 'Atlantic/Azores'),
(302, 'Pacific/Palau'),
(303, 'America/Asuncion'),
(304, 'Asia/Qatar'),
(305, 'Indian/Reunion'),
(306, 'Europe/Bucharest'),
(307, 'Europe/Belgrade'),
(308, 'Europe/Kaliningrad'),
(309, 'Europe/Moscow'),
(310, 'Europe/Simferopol'),
(311, 'Europe/Volgograd'),
(312, 'Europe/Kirov'),
(313, 'Europe/Astrakhan'),
(314, 'Europe/Saratov'),
(315, 'Europe/Ulyanovsk'),
(316, 'Europe/Samara'),
(317, 'Asia/Yekaterinburg'),
(318, 'Asia/Omsk'),
(319, 'Asia/Novosibirsk'),
(320, 'Asia/Barnaul'),
(321, 'Asia/Tomsk'),
(322, 'Asia/Novokuznetsk'),
(323, 'Asia/Krasnoyarsk'),
(324, 'Asia/Irkutsk'),
(325, 'Asia/Chita'),
(326, 'Asia/Yakutsk'),
(327, 'Asia/Khandyga'),
(328, 'Asia/Vladivostok'),
(329, 'Asia/Ust-Nera'),
(330, 'Asia/Magadan'),
(331, 'Asia/Sakhalin'),
(332, 'Asia/Srednekolymsk'),
(333, 'Asia/Kamchatka'),
(334, 'Asia/Anadyr'),
(335, 'Africa/Kigali'),
(336, 'Asia/Riyadh'),
(337, 'Pacific/Guadalcanal'),
(338, 'Indian/Mahe'),
(339, 'Africa/Khartoum'),
(340, 'Europe/Stockholm'),
(341, 'Asia/Singapore'),
(342, 'Atlantic/St_Helena'),
(343, 'Europe/Ljubljana'),
(344, 'Arctic/Longyearbyen'),
(345, 'Europe/Bratislava'),
(346, 'Africa/Freetown'),
(347, 'Europe/San_Marino'),
(348, 'Africa/Dakar'),
(349, 'Africa/Mogadishu'),
(350, 'America/Paramaribo'),
(351, 'Africa/Juba'),
(352, 'Africa/Sao_Tome'),
(353, 'America/El_Salvador'),
(354, 'America/Lower_Princes'),
(355, 'Asia/Damascus'),
(356, 'Africa/Mbabane'),
(357, 'America/Grand_Turk'),
(358, 'Africa/Ndjamena'),
(359, 'Indian/Kerguelen'),
(360, 'Africa/Lome'),
(361, 'Asia/Bangkok'),
(362, 'Asia/Dushanbe'),
(363, 'Pacific/Fakaofo'),
(364, 'Asia/Dili'),
(365, 'Asia/Ashgabat'),
(366, 'Africa/Tunis'),
(367, 'Pacific/Tongatapu'),
(368, 'Europe/Istanbul'),
(369, 'America/Port_of_Spain'),
(370, 'Pacific/Funafuti'),
(371, 'Asia/Taipei'),
(372, 'Africa/Dar_es_Salaam'),
(373, 'Europe/Kiev'),
(374, 'Europe/Uzhgorod'),
(375, 'Europe/Zaporozhye'),
(376, 'Africa/Kampala'),
(377, 'Pacific/Midway'),
(378, 'Pacific/Wake'),
(379, 'America/New_York'),
(380, 'America/Detroit'),
(381, 'America/Kentucky/Louisville'),
(382, 'America/Kentucky/Monticello'),
(383, 'America/Indiana/Indianapolis'),
(384, 'America/Indiana/Vincennes'),
(385, 'America/Indiana/Winamac'),
(386, 'America/Indiana/Marengo'),
(387, 'America/Indiana/Petersburg'),
(388, 'America/Indiana/Vevay'),
(389, 'America/Chicago'),
(390, 'America/Indiana/Tell_City'),
(391, 'America/Indiana/Knox'),
(392, 'America/Menominee'),
(393, 'America/North_Dakota/Center'),
(394, 'America/North_Dakota/New_Salem'),
(395, 'America/North_Dakota/Beulah'),
(396, 'America/Denver'),
(397, 'America/Boise'),
(398, 'America/Phoenix'),
(399, 'America/Los_Angeles'),
(400, 'America/Anchorage'),
(401, 'America/Juneau'),
(402, 'America/Sitka'),
(403, 'America/Metlakatla'),
(404, 'America/Yakutat'),
(405, 'America/Nome'),
(406, 'America/Adak'),
(407, 'Pacific/Honolulu'),
(408, 'America/Montevideo'),
(409, 'Asia/Samarkand'),
(410, 'Asia/Tashkent'),
(411, 'Europe/Vatican'),
(412, 'America/St_Vincent'),
(413, 'America/Caracas'),
(414, 'America/Tortola'),
(415, 'America/St_Thomas'),
(416, 'Asia/Ho_Chi_Minh'),
(417, 'Pacific/Efate'),
(418, 'Pacific/Wallis'),
(419, 'Pacific/Apia'),
(420, 'Asia/Aden'),
(421, 'Indian/Mayotte'),
(422, 'Africa/Johannesburg'),
(423, 'Africa/Lusaka'),
(424, 'Africa/Harare');

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

--
-- Table structure for table `sps_transactions`
--

CREATE TABLE IF NOT EXISTS `sps_transactions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `barcode` varchar(256) DEFAULT NULL,
  `ticket_no` varchar(245) DEFAULT NULL,
  `in_time` datetime NOT NULL,
  `out_time` datetime NOT NULL,
  `total_time` smallint(4) DEFAULT NULL,
  `vehicle_type` bigint(20) DEFAULT NULL,
  `vehicle_number` varchar(255) DEFAULT NULL,
  `in_shift_id` bigint(20) DEFAULT NULL,
  `in_type` tinyint(3) NOT NULL,
  `in_type_id` varchar(512) DEFAULT NULL,
  `in_gate` bigint(20) NOT NULL,
  `in_user_id` bigint(20) NOT NULL,
  `in_payment_mode` tinyint(4) DEFAULT NULL,
  `in_master_payment_mode` tinyint(4) DEFAULT NULL,
  `in_day_type` bigint(20) NOT NULL,
  `in_tariff_code` varchar(256) DEFAULT NULL,
  `in_foc_difference` bigint(20) NOT NULL,
  `in_foc` tinyint(4) DEFAULT NULL,
  `in_foc_reason` bigint(20) DEFAULT NULL,
  `in_foc_approval` bigint(20) DEFAULT NULL,
  `in_foc_note` mediumtext,
  `in_foc_approved` tinyint(2) DEFAULT NULL,
  `in_membership_payment_amount` double(10,2) NOT NULL,
  `in_payment_referance_number` bigint(20) NOT NULL,
  `in_payment_amount` float(10,2) DEFAULT NULL,
  `out_shift_id` bigint(20) NOT NULL,
  `out_type` tinyint(4) NOT NULL,
  `out_type_id` varchar(512) NOT NULL,
  `out_gate` bigint(20) DEFAULT NULL,
  `out_user_id` bigint(20) NOT NULL,
  `out_payment_mode` bigint(20) NOT NULL,
  `out_master_payment_mode` tinyint(3) NOT NULL,
  `out_day_type` bigint(20) NOT NULL,
  `out_tariff_code` varchar(256) DEFAULT NULL,
  `out_foc_difference` bigint(20) NOT NULL,
  `out_membership_payment_amount` double(10,2) NOT NULL,
  `out_payment_reference_number` bigint(20) NOT NULL,
  `out_payment_amount` float(10,2) NOT NULL,
  `total_payment_amount` float(10,2) DEFAULT NULL,
  `penalty_charge` float(10,2) DEFAULT NULL,
  `overnight_charges` float(10,2) DEFAULT NULL,
  `additional_charges` float(10,2) DEFAULT NULL,
  `lost_ticket` tinyint(3) DEFAULT NULL,
  `lost_ticket_penalty` float(10,2) DEFAULT NULL,
  `manuel_ticket` tinyint(3) DEFAULT NULL,
  `offline_ticket` tinyint(3) DEFAULT NULL,
  `reprint_count` tinyint(3) DEFAULT NULL,
  `f_eight` tinyint(3) DEFAULT NULL,
  `f_eight_reason` bigint(20) DEFAULT NULL,
  `f_eight_notes` mediumtext,
  `out_foc` tinyint(3) DEFAULT NULL,
  `out_foc_reason` bigint(20) DEFAULT NULL,
  `out_foc_approval` int(20) DEFAULT NULL,
  `out_foc_note` mediumtext,
  `out_foc_approved` tinyint(2) DEFAULT NULL,
  `is_cps` tinyint(3) DEFAULT NULL,
  `is_nested` tinyint(3) DEFAULT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `notes` text NOT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `sync_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vehicle_type` (`vehicle_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_transactions_cps`
--

CREATE TABLE IF NOT EXISTS `sps_transactions_cps` (
  `cps_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cps_barcode` varchar(256) DEFAULT NULL,
  `cps_out_time` datetime NOT NULL,
  `cps_total_time` smallint(4) DEFAULT NULL,
  `cps_vehicle_type` bigint(20) DEFAULT NULL,
  `cps_vehicle_number` varchar(255) DEFAULT NULL,
  `cps_shift_id` bigint(20) NOT NULL,
  `cps_out_type` tinyint(4) NOT NULL,
  `cps_out_type_id` varchar(512) NOT NULL,
  `cps_gate` bigint(20) NOT NULL,
  `cps_user_id` bigint(20) NOT NULL,
  `cps_payment_mode` bigint(20) NOT NULL,
  `cps_master_payment_mode` tinyint(3) NOT NULL,
  `cps_day_type` bigint(20) unsigned NOT NULL DEFAULT '0',
  `cps_tariff_code` varchar(256) NOT NULL DEFAULT 'NULL',
  `cps_payment_discount_type` tinyint(3) NOT NULL,
  `cps_payment_discount` float(10,2) NOT NULL,
  `cps_payment_amount` float(10,2) NOT NULL,
  `cps_total_payment_amount` float(10,2) DEFAULT NULL,
  `cps_penalty_charge` float(10,2) DEFAULT NULL,
  `cps_overnight_charges` float(10,2) DEFAULT NULL,
  `cps_additional_charges` float(10,2) DEFAULT NULL,
  `cps_lost_ticket` tinyint(3) DEFAULT NULL,
  `cps_lost_ticket_penalty` float(10,2) DEFAULT NULL,
  `cps_manuel_ticket` tinyint(3) DEFAULT NULL,
  `cps_offline_ticket` tinyint(3) DEFAULT NULL,
  `cps_reprint_count` tinyint(3) DEFAULT NULL,
  `cps_f_eight` tinyint(3) DEFAULT NULL,
  `cps_f_eight_reason` bigint(20) DEFAULT NULL,
  `cps_foc` tinyint(3) DEFAULT NULL,
  `cps_foc_reason` bigint(20) DEFAULT NULL,
  `cps_foc_aproval` bigint(20) DEFAULT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `notes` text NOT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`cps_id`),
  KEY `vehicle_type` (`cps_vehicle_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_transaction_additional_charges`
--

CREATE TABLE IF NOT EXISTS `sps_transaction_additional_charges` (
  `additional_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `additional_tariff_id` bigint(20) NOT NULL,
  `additional_tariff_amount` double(10,2) NOT NULL,
  `addtional_charges_at` enum('ENTRY','EXIT') NOT NULL,
  `gate_id` bigint(20) NOT NULL,
  `status` int(11) NOT NULL,
  `area_id` tinyint(4) NOT NULL,
  `location_id` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sync_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`additional_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_transaction_discount`
--

CREATE TABLE IF NOT EXISTS `sps_transaction_discount` (
  `discount_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `transaction_id` bigint(20) NOT NULL,
  `discount_type` int(11) NOT NULL,
  `discount_type_id` int(11) NOT NULL,
  `discount_value_type` varchar(256) NOT NULL,
  `discount_value` int(11) NOT NULL,
  `discount_amount` float(10,2) NOT NULL,
  `discount_at` enum('ENTRY','EXIT') DEFAULT NULL,
  `gate_id` bigint(11) NOT NULL,
  `area_id` tinyint(4) NOT NULL,
  `location_id` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` tinyint(4) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by` tinyint(4) NOT NULL,
  `sync_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`discount_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_transaction_tax_breakup`
--

CREATE TABLE IF NOT EXISTS `sps_transaction_tax_breakup` (
  `tax_breakup_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `tax_value` double(10,2) NOT NULL,
  `tax_id` varchar(100) NOT NULL,
  `tax_breakup_at` enum('ENTRY','EXIT') NOT NULL,
  `gate_id` bigint(20) NOT NULL,
  `status` int(11) NOT NULL,
  `area_id` tinyint(4) NOT NULL,
  `location_id` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` tinyint(4) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by` tinyint(4) NOT NULL,
  `sync_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`tax_breakup_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_user_role`
--

CREATE TABLE IF NOT EXISTS `sps_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role` varchar(255) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=100 ;

--
-- Dumping data for table `sps_user_role`
--

INSERT INTO `sps_user_role` (`id`, `role`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', 0, 0, 1, 0, '0000-00-00 00:00:00', '2017-02-09 01:04:06', NULL),
(92, 'Cashier', 1, 3, 0, 0, '2017-05-23 06:51:52', '2017-05-23 06:51:52', NULL),
(93, 'Supervisor', 1, 3, 0, 0, '2017-05-23 06:51:58', '2017-05-23 06:51:58', NULL),
(94, 'Auditor', 1, 3, 0, 0, '2017-05-23 06:52:05', '2017-05-23 06:52:05', NULL),
(95, 'CPM', 1, 3, 0, 0, '2017-05-23 06:52:10', '2017-05-23 06:52:10', NULL),
(96, 'Asst CPM', 1, 3, 0, 0, '2017-05-23 06:52:19', '2017-05-23 06:52:19', NULL),
(97, 'ITAdmin', 1, 3, 0, 0, '2017-05-23 06:52:28', '2017-05-23 06:52:28', NULL),
(98, 'CTO', 1, 3, 0, 0, '2017-05-23 06:52:33', '2017-05-30 07:34:10', NULL),
(99, 'Super Admin', 23, 7269, 0, 0, '2017-07-25 05:10:17', '2017-07-25 05:10:17', NULL);

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

--
-- Table structure for table `sps_vehicle_types`
--

CREATE TABLE IF NOT EXISTS `sps_vehicle_types` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `shortcut_keycode` varchar(20) DEFAULT NULL,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `location_id` bigint(20) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_vouchers`
--

CREATE TABLE IF NOT EXISTS `sps_vouchers` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `old_id` bigint(20) NOT NULL DEFAULT '0',
  `superadmin` tinyint(4) NOT NULL DEFAULT '0',
  `sync_at` timestamp NULL DEFAULT NULL,
  `voucher_title` varchar(255) NOT NULL,
  `voucher_barcode` varchar(245) NOT NULL DEFAULT '',
  `voucher_code` varchar(100) NOT NULL DEFAULT '',
  `vouchers` tinyint(1) NOT NULL DEFAULT '1',
  `voucher_plan` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `voucher_value` bigint(20) unsigned NOT NULL DEFAULT '0',
  `payment_mode` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `receipt_number` varchar(145) NOT NULL DEFAULT '',
  `payment_amount` float NOT NULL DEFAULT '0',
  `voucher_type` tinyint(1) NOT NULL,
  `count` int(11) NOT NULL,
  `time_duration` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `duration` smallint(4) NOT NULL DEFAULT '0',
  `start_time` time NOT NULL DEFAULT '00:00:00',
  `end_time` time NOT NULL DEFAULT '00:00:00',
  `start_date` date NOT NULL,
  `expiry_date` date NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_vouchers_generated`
--

CREATE TABLE IF NOT EXISTS `sps_vouchers_generated` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `voucher_id` bigint(20) NOT NULL,
  `voucher_code` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `expiry_date` date NOT NULL,
  `status` tinyint(1) NOT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sps_zones`
--

CREATE TABLE IF NOT EXISTS `sps_zones` (
  `zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(45) NOT NULL DEFAULT '',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `location_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `area_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `updated_by` bigint(20) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

