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

START TRANSACTION;



--
-- Database: `hook_and_hanger`
--

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

--
-- Table structure for table `barcode`
--

CREATE TABLE `barcode` (
  `b_id` int(11) NOT NULL,
  `invid` int(11) NOT NULL,
  `custid` int(11) NOT NULL,
  `b_val` varchar(60) NOT NULL,
  `service` varchar(50) NOT NULL,
  `product` varchar(50) NOT NULL,
  `status` enum('0','1') NOT NULL COMMENT '0:active,1:cancle',
  `remarks` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `barcode`
--

INSERT INTO `barcode` (`b_id`, `invid`, `custid`, `b_val`, `service`, `product`, `status`, `remarks`) VALUES
(207, 21, 4, '23-1', 'spa', 'formal- shoes', '1', ''),
(208, 21, 4, '23-2', 'spa', 'formal- shoes', '1', ''),
(209, 21, 4, '23-3', 'spa', 'formal- shoes', '1', ''),
(210, 21, 4, '23-4', 'spa', 'formal- shoes', '1', ''),
(211, 21, 4, '23-5', 'spa', 'formal- shoes', '1', ''),
(212, 30, 3, '30-1', 'dryclean', 'cousion', '0', ''),
(213, 30, 3, '30-2', 'dryclean', 'cousion', '0', ''),
(221, 33, 2, '33-1', 'spa', 'boot', '0', ''),
(222, 33, 2, '33-2', 'spa', 'boot', '0', ''),
(223, 33, 2, '33-3', 'spa', 'boot', '0', ''),
(224, 33, 2, '33-4', 'spa', 'boot', '0', ''),
(225, 33, 2, '33-5', 'spa', 'boot', '0', ''),
(226, 33, 2, '33-6', 'spa', 'boot', '0', ''),
(227, 33, 2, '33-7', 'spa', 'boot', '0', ''),
(228, 33, 2, '33-8', 'spa', 'boot', '0', ''),
(229, 33, 2, '33-9', 'spa', 'boot', '0', ''),
(230, 33, 2, '33-10', 'spa', 'boot', '0', ''),
(231, 33, 2, '33-11', 'spa', 'boot', '0', ''),
(232, 33, 2, '33-12', 'spa', 'boot', '0', ''),
(233, 33, 2, '33-13', 'spa', 'boot', '0', ''),
(234, 33, 2, '33-14', 'spa', 'boot', '0', ''),
(235, 33, 2, '33-15', 'spa', 'boot', '0', ''),
(236, 33, 2, '33-16', 'spa', 'boot', '0', ''),
(237, 33, 2, '33-17', 'spa', 'boot', '0', ''),
(238, 33, 2, '33-18', 'spa', 'boot', '0', ''),
(239, 33, 2, '33-19', 'spa', 'boot', '0', ''),
(240, 33, 2, '33-20', 'spa', 'boot', '0', ''),
(241, 33, 2, '33-21', 'spa', 'boot', '0', ''),
(242, 33, 2, '33-22', 'spa', 'boot', '0', ''),
(243, 33, 2, '33-23', 'spa', 'boot', '0', ''),
(244, 34, 2, '34-1', 'wash-iron', 'cousion', '0', ''),
(245, 34, 2, '34-2', 'wash-iron', 'cousion', '0', ''),
(246, 34, 2, '34-3', 'wash-iron', 'cousion', '0', ''),
(247, 34, 2, '34-4', 'wash-iron', 'cousion', '0', ''),
(248, 34, 2, '34-5', 'wash-iron', 'cousion', '0', ''),
(249, 34, 2, '34-6', 'wash-iron', 'cousion', '0', ''),
(250, 34, 2, '34-7', 'wash-iron', 'cousion', '0', ''),
(251, 34, 2, '34-8', 'wash-iron', 'cousion', '0', ''),
(252, 34, 2, '34-9', 'wash-iron', 'cousion', '0', ''),
(253, 34, 2, '34-10', 'wash-iron', 'cousion', '0', ''),
(254, 34, 2, '34-11', 'wash-iron', 'cousion', '0', ''),
(255, 34, 2, '34-12', 'wash-iron', 'cousion', '0', ''),
(256, 34, 2, '34-13', 'wash-iron', 'cousion', '0', ''),
(257, 34, 2, '34-14', 'wash-iron', 'cousion', '0', ''),
(258, 34, 2, '34-15', 'wash-iron', 'cousion', '0', ''),
(259, 34, 2, '34-16', 'wash-iron', 'cousion', '0', ''),
(260, 34, 2, '34-17', 'wash-iron', 'cousion', '0', ''),
(290, 35, 2, '35-1', 'dryclean', 'shirt', '0', ''),
(291, 35, 2, '35-2', 'dryclean', 'shirt', '0', ''),
(292, 35, 2, '35-3', 'dryclean', 'shirt', '0', ''),
(293, 35, 2, '35-4', 'dryclean', 'shirt', '0', ''),
(294, 35, 2, '35-5', 'dryclean', 'shirt', '0', ''),
(295, 35, 2, '35-6', 'dryclean', 'shirt', '0', ''),
(296, 35, 2, '35-7', 'dryclean', 'shirt', '0', ''),
(297, 35, 2, '35-8', 'dryclean', 'shirt', '0', ''),
(298, 35, 2, '35-9', 'dryclean', 'shirt', '0', ''),
(299, 35, 2, '35-10', 'dryclean', 'shirt', '0', ''),
(303, 32, 2, '32-1', 'steam-iron', 'Tshirt', '0', ''),
(304, 32, 2, '32-2', 'steam-iron', 'Tshirt', '0', ''),
(305, 32, 2, '32-3', 'steam-iron', 'Tshirt', '0', ''),
(306, 36, 1, '36-1', 'steam-iron', 'shirt', '0', ''),
(307, 36, 1, '36-2', 'steam-iron', 'shirt', '0', ''),
(308, 36, 1, '36-3', 'steam-iron', 'shirt', '0', ''),
(309, 36, 1, '36-4', 'steam-iron', 'shirt', '0', ''),
(310, 36, 1, '36-5', 'steam-iron', 'shirt', '0', ''),
(311, 36, 1, '36-6', 'steam-iron', 'shirt', '0', ''),
(312, 36, 1, '36-7', 'steam-iron', 'shirt', '0', ''),
(313, 36, 1, '36-8', 'steam-iron', 'shirt', '0', ''),
(314, 36, 1, '36-9', 'steam-iron', 'shirt', '0', ''),
(315, 36, 1, '36-10', 'steam-iron', 'shirt', '0', ''),
(325, 37, 20, '37-1', 'spa', 'boot', '0', 'ASD'),
(326, 37, 20, '37-2', 'spa', 'boot', '0', 'ASD'),
(327, 38, 3, '38-1', 'wash-iron', 'shirt', '0', ''),
(328, 38, 3, '38-2', 'wash-iron', 'shirt', '0', ''),
(329, 38, 3, '38-3', 'wash-iron', 'shirt', '0', ''),
(330, 38, 3, '38-4', 'wash-iron', 'shirt', '0', ''),
(331, 38, 3, '38-5', 'wash-iron', 'shirt', '0', ''),
(332, 38, 3, '38-6', 'wash-iron', 'cousion', '0', 'Hard Press'),
(333, 38, 3, '38-7', 'wash-iron', 'cousion', '0', 'Hard Press'),
(334, 38, 3, '38-8', 'wash-iron', 'cousion', '0', 'Hard Press'),
(335, 38, 3, '38-9', 'wash-iron', 'cousion', '0', 'Hard Press'),
(336, 38, 3, '38-10', 'wash-iron', 'cousion', '0', 'Hard Press'),
(337, 39, 2, '39-1', 'steam-iron', 'shirt', '0', ''),
(338, 39, 2, '39-2', 'steam-iron', 'shirt', '0', ''),
(339, 39, 2, '39-3', 'steam-iron', 'shirt', '0', ''),
(340, 39, 2, '39-4', 'steam-iron', 'shirt', '0', ''),
(341, 39, 2, '39-5', 'steam-iron', 'shirt', '0', ''),
(356, 64, 22, '64-1', 'wash-iron', 'shirt', '0', ' '),
(357, 64, 22, '64-2', 'wash-iron', 'shirt', '0', ' '),
(358, 64, 22, '64-3', 'wash-iron', 'shirt', '0', ' '),
(359, 64, 22, '64-4', 'wash-iron', 'shirt', '0', ' '),
(360, 64, 22, '64-5', 'wash-iron', 'shirt', '0', ' '),
(361, 64, 22, '64-6', 'steam-iron', 'shirt', '0', ''),
(362, 64, 22, '64-7', 'steam-iron', 'shirt', '0', ''),
(382, 65, 30, '65-1', 'dryclean', 'cousion', '1', ''),
(383, 65, 30, '65-2', 'spa', 'shoes', '1', 'H2'),
(384, 65, 30, '65-3', 'dryclean', 'shirt', '1', 'H1'),
(395, 66, 31, '66-1', 'wash-iron', 'shirt', '0', ''),
(396, 66, 31, '66-2', 'wash-iron', 'shirt', '0', ''),
(397, 66, 31, '66-3', 'wash-iron', 'shirt', '0', ''),
(398, 66, 31, '66-4', 'wash-iron', 'shirt', '0', ''),
(399, 66, 31, '66-5', 'wash-iron', 'shirt', '0', ''),
(400, 66, 31, '66-6', 'dryclean', 'shirt', '0', ''),
(401, 66, 31, '66-7', 'dryclean', 'shirt', '0', ''),
(402, 66, 31, '66-8', 'dryclean', 'shirt', '0', ''),
(403, 66, 31, '66-9', 'dryclean', 'shirt', '0', ''),
(404, 66, 31, '66-10', 'dryclean', 'shirt', '0', ''),
(405, 67, 31, '67-1', 'wash-iron', 'shirt', '0', ' '),
(406, 67, 31, '67-2', 'wash-iron', 'shirt', '0', ' '),
(407, 67, 31, '67-3', 'wash-iron', 'shirt', '0', ' '),
(408, 67, 31, '67-4', 'wash-iron', 'shirt', '0', ' '),
(409, 67, 31, '67-5', 'wash-iron', 'shirt', '0', ' '),
(415, 68, 31, '68-1', 'dryclean', 'cousion', '1', '');

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

--
-- Table structure for table `customer_detail`
--

CREATE TABLE `customer_detail` (
  `id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `mobile_no` bigint(10) NOT NULL,
  `address` varchar(100) NOT NULL,
  `location` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `pincode` mediumint(10) NOT NULL,
  `dob` date NOT NULL,
  `membership_id` int(11) NOT NULL,
  `otp` mediumint(10) NOT NULL,
  `service` int(10) NOT NULL,
  `status` enum('0','1') NOT NULL COMMENT '0:in-active,1:active',
  `cust_type` enum('1','2') NOT NULL COMMENT '1:store,2:mobile',
  `createAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `customer_detail`
--

INSERT INTO `customer_detail` (`id`, `name`, `mobile_no`, `address`, `location`, `email`, `pincode`, `dob`, `membership_id`, `otp`, `service`, `status`, `cust_type`, `createAt`) VALUES
(1, 'US1', 7894561230, '211 Main Street US1', 'Landmark 55', 'test11@yopmail.com', 357951, '2011-02-20', 1, 0, 3, '1', '1', '2020-07-01 09:15:06'),
(2, 'name', 7894561244, 'update', 'loc', 'yoyo@yopmail.com', 789456, '2011-11-21', 0, 0, 3, '1', '2', '2020-07-08 09:15:13'),
(3, 'US3', 7894561250, 'Address US3', 'Landmark 77', 'test33@opmail.comm', 123460, '2011-09-11', 0, 0, 3, '1', '1', '2020-09-01 09:15:27'),
(4, 'US4', 7894561260, '211 Main Street US4', 'Landmark 88', 'test44@yopmail.com', 357951, '2011-02-20', 0, 0, 3, '1', '2', '2020-10-02 08:49:22'),
(5, 'US5', 7894561270, 'Address US5', 'Landmark 99', 'test55@opmail.comm', 123460, '2011-09-11', 0, 0, 3, '0', '2', '2020-10-16 08:49:22'),
(15, 'US6', 7016524442, 'Location 56', 'Landmark 89', 'hello@yopmail.com', 380001, '2010-02-20', 0, 0, 3, '1', '1', '2020-11-04 09:25:08'),
(16, 'US66', 7894561280, 'LOcation', 'Address', 'uio@yopmail.com', 123456, '2020-10-11', 0, 0, 3, '1', '1', '2020-11-04 09:36:47'),
(18, 'NM', 7894561290, '77', '77', '55@yopmail.com', 123456, '1985-08-05', 0, 0, 3, '1', '1', '2020-11-09 14:18:02'),
(19, 'KK', 8956237845, 'ASD88', 'Loc88', '88@yopmail.com', 123456, '1998-11-02', 0, 0, 3, '1', '1', '2020-11-09 14:20:08'),
(20, 'SS', 4567891230, 'SS88', 'FF88', 'test23@yopmail.com', 789456, '1995-09-05', 0, 0, 3, '1', '1', '2020-11-09 14:22:30'),
(22, 'Hello', 1234567890, 'add', 'locaion 55', 'yop1@yopmail.com', 789456, '1998-09-09', 0, 0, 3, '1', '2', '2020-11-17 13:32:53'),
(23, 'ASD', 7016524444, 'Addd', '', 'hello1@yopmail.com', 0, '0000-00-00', 0, 0, 0, '0', '1', '2020-11-19 09:13:28'),
(24, 'name', 7894561233, 'add', '', 'yop@yopmail.com', 0, '0000-00-00', 0, 0, 0, '0', '1', '2020-11-20 06:45:36'),
(25, 'ASD', 7016524445, 'Addd', '', 'hello2@yopmail.com', 0, '0000-00-00', 0, 0, 0, '0', '1', '2020-11-20 06:46:56'),
(26, 'name', 7894561234, 'add', '', 'yop11@yopmail.com', 0, '0000-00-00', 0, 3954, 3, '1', '2', '2020-11-20 09:48:20'),
(27, 'name', 7016524441, 'add', '', 'yop12@yopmail.com', 0, '0000-00-00', 0, 3134, 3, '1', '2', '2020-11-20 09:51:10'),
(28, 'name', 7894561236, 'add', '', 'yop13@yopmail.com', 0, '0000-00-00', 0, 7523, 3, '1', '2', '2020-11-20 09:53:53'),
(29, 'name', 7894561255, 'add', '', 'yop123@yopmail.com', 0, '0000-00-00', 0, 9778, 3, '1', '2', '2020-11-20 10:38:51'),
(30, 'name1', 7894561266, 'add', '', 'yop125@yopmail.com', 0, '0000-00-00', 0, 1738, 3, '1', '2', '2020-11-20 11:22:33'),
(31, 'hooks', 789456321, 'ASD', 'LOcation 553', 'yopmailtest@yopmail.com', 789456, '1999-11-24', 0, 0, 3, '1', '1', '2020-11-27 09:22:03');

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

--
-- Table structure for table `customer_membership`
--

CREATE TABLE `customer_membership` (
  `cmbsp_id` int(11) NOT NULL,
  `custid` int(11) NOT NULL,
  `ms_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `ex_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `avl_price` int(11) NOT NULL,
  `avl_point` int(11) NOT NULL,
  `day_ex` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `customer_membership`
--

INSERT INTO `customer_membership` (`cmbsp_id`, `custid`, `ms_id`, `date`, `ex_date`, `avl_price`, `avl_point`, `day_ex`) VALUES
(1, 1, 1, '2020-11-09 19:46:35', '2020-11-10 07:46:43', 2000, 200, 90),
(2, 2, 2, '2020-11-09 19:49:36', '2021-02-08 07:49:41', 0, 0, 90),
(3, 15, 4, '2020-11-09 22:21:34', '2021-02-08 10:21:48', 0, 0, 0),
(4, 20, 1, '2020-11-13 06:41:39', '2021-02-11 06:42:21', 0, 0, 0),
(5, 20, 2, '2020-11-12 21:35:06', '2021-02-11 09:35:18', 0, 0, 0);

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `inv_id` int(11) NOT NULL,
  `cust_id` int(11) NOT NULL,
  `total_pic` smallint(10) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `due_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `price` int(11) NOT NULL,
  `discount` int(11) NOT NULL,
  `net` int(11) NOT NULL,
  `payment_due` int(11) NOT NULL,
  `paid` int(11) NOT NULL,
  `payment_type` enum('0','1','2','3','4','5','6') NOT NULL COMMENT '0:pandding,1:cash,2:card,3:bank,4:gpay,5:Price,6:Point\r\n',
  `payment_status` enum('0','1') NOT NULL COMMENT '0:unpaid,1:paid',
  `cancle` enum('0','1') NOT NULL COMMENT '0:no,1:yes',
  `status` enum('0','1','2','3') NOT NULL COMMENT '0:unprocces 1:inprogress,2:ready,3:deliverd',
  `m_price` int(11) NOT NULL,
  `m_point` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` (`inv_id`, `cust_id`, `total_pic`, `date`, `due_date`, `price`, `discount`, `net`, `payment_due`, `paid`, `payment_type`, `payment_status`, `cancle`, `status`, `m_price`, `m_point`) VALUES
(21, 4, 5, '2020-11-04 01:58:17', '2020-11-05 03:40:00', 750, 12, 738, 738, 0, '0', '0', '1', '1', 0, 0),
(30, 3, 2, '2020-11-06 00:07:38', '2020-11-06 06:30:00', 100, 0, 100, 100, 0, '0', '0', '0', '0', 0, 0),
(32, 2, 3, '2020-11-10 02:23:11', '2020-11-10 06:30:00', 15, 0, 15, 15, 0, '0', '0', '0', '0', 0, 0),
(33, 2, 23, '2020-11-11 05:56:37', '2020-11-11 06:30:00', 3450, 0, 3450, 0, 3450, '5', '1', '0', '0', 3450, 0),
(34, 2, 17, '2020-11-11 06:06:44', '2020-11-11 06:30:00', 425, 0, 425, 0, 425, '5', '1', '0', '0', 425, 0),
(35, 2, 10, '2020-11-11 06:08:14', '2020-11-11 06:30:00', 500, 0, 500, 0, 500, '6', '1', '0', '0', 0, 500),
(36, 1, 10, '2020-11-10 20:22:41', '2020-11-11 06:30:00', 60, 0, 60, 60, 0, '0', '0', '0', '0', 0, 0),
(37, 20, 2, '2020-11-10 23:32:51', '2020-11-11 06:30:00', 300, 0, 300, 300, 0, '0', '0', '0', '0', 0, 0),
(38, 3, 10, '2020-11-18 20:48:35', '2020-11-19 06:30:00', 250, 0, 250, 0, 250, '0', '1', '0', '0', 0, 0),
(39, 2, 5, '2020-11-18 21:07:21', '2020-11-19 06:30:00', 35, 0, 35, 0, 35, '2', '1', '0', '0', 0, 0),
(64, 22, 7, '2020-11-22 23:09:00', '2010-02-10 18:30:00', 135, 0, 135, 0, 135, '0', '1', '0', '0', 0, 0),
(65, 30, 3, '2020-11-23 20:06:52', '2020-11-24 06:30:00', 250, 0, 250, 250, 0, '0', '0', '1', '0', 0, 0),
(66, 31, 10, '2020-11-26 21:24:43', '2020-11-27 06:30:00', 375, 0, 375, 375, 0, '0', '0', '0', '0', 0, 0),
(67, 31, 7, '2020-12-01 23:37:08', '2010-02-10 18:30:00', 135, 0, 135, 135, 0, '0', '0', '0', '0', 0, 0),
(68, 31, 1, '2020-12-01 23:37:43', '2010-02-10 18:30:00', 50, 0, 50, 50, 0, '0', '0', '1', '0', 0, 0);

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

--
-- Table structure for table `iteam_price`
--

CREATE TABLE `iteam_price` (
  `ip_id` int(11) NOT NULL,
  `type` varchar(15) NOT NULL,
  `service` varchar(50) NOT NULL,
  `cloth_type` varchar(15) NOT NULL,
  `price` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `iteam_price`
--

INSERT INTO `iteam_price` (`ip_id`, `type`, `service`, `cloth_type`, `price`) VALUES
(1, 'men', 'steam-iron', 'Tshirt', '7'),
(2, 'men', 'wash-iron', 'Tshirt', '25'),
(3, 'men', 'dryclean', 'Tshirt', '50'),
(4, 'woman', 'steam-iron', 'Tshirt', '7'),
(5, 'woman', 'wash-iron', 'Tshirt', '25'),
(6, 'woman', 'dryclean', 'Tshirt', '50'),
(7, 'kids', 'steam-iron', 'Tshirt', '5'),
(8, 'kids', 'wash-iron', 'Tshirt', '25'),
(9, 'kids', 'dryclean', 'Tshirt', '50'),
(10, 'shoes-spa', 'spa', 'shoes', '150'),
(11, 'shoes-spa', 'spa', 'formal- shoes', '150'),
(12, 'household', 'steam-iron', 'bedsheet', '15'),
(13, 'household', 'wash-iron', 'bedsheet', '50'),
(14, 'household', 'dryclean', 'bedsheet', '90'),
(15, 'men', 'steam-iron', 'shirt', '7'),
(16, 'men', 'wash-iron', 'shirt', '25'),
(17, 'men', 'dryclean', 'shirt', '50'),
(18, 'woman', 'steam-iron', 'shirt', '7'),
(19, 'woman', 'wash-iron', 'shirt', '25'),
(20, 'woman', 'dryclean', 'shirt', '50'),
(21, 'kids', 'steam-iron', 'shirt', '5'),
(22, 'kids', 'wash-iron', 'shirt', '25'),
(23, 'kids', 'dryclean', 'shirt', '50'),
(24, 'shoes-spa', 'spa', 'boot', '150'),
(25, 'shoes-spa', 'spa', 'sandal', '150'),
(26, 'household', 'steam-iron', 'cousion', '7'),
(27, 'household', 'wash-iron', 'cousion', '25'),
(28, 'household', 'dryclean', 'cousion', '50');

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

--
-- Table structure for table `membership`
--

CREATE TABLE `membership` (
  `mbs_id` int(11) NOT NULL,
  `mbsp_amount` int(11) NOT NULL,
  `validity` varchar(50) NOT NULL,
  `price` int(11) NOT NULL,
  `point` int(11) NOT NULL,
  `service` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `membership`
--

INSERT INTO `membership` (`mbs_id`, `mbsp_amount`, `validity`, `price`, `point`, `service`) VALUES
(1, 2000, '3-month', 2000, 200, '2200'),
(2, 4000, '3-month', 4000, 500, '4500'),
(3, 6000, '3-month', 6000, 800, '6800'),
(4, 8000, '3-month', 8000, 1500, '9500');

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

--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base', 1602412342),
('m010101_100001_init_notifications', 1606304540),
('m130524_201442_init', 1602412347),
('m151008_162401_create_notification_table', 1606393594),
('m160509_211405_add_flashed_to_notification', 1606393594),
('m160516_095943_init', 1602943074),
('m160921_171124_alter_notification_table', 1606393595),
('m161109_124936_rename_cart_table', 1602943074),
('m161119_153348_alter_cart_data', 1602943076),
('m190124_110200_add_verification_token_column_to_user_table', 1602412347);

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `key` varchar(255) NOT NULL,
  `key_id` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `seen` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `flashed` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `key`, `key_id`, `type`, `user_id`, `seen`, `created_at`, `flashed`) VALUES
(1, 'key', '123', '123', 20, 0, '2020-11-19 18:44:32', 0);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `class` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `route` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT 0,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` int(11) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `class`, `key`, `message`, `route`, `seen`, `read`, `user_id`, `created_at`) VALUES
(12, 'account', 'reset_password', 'Instructions to reset the password', 'a:2:{i:0;s:11:\"/users/edit\";s:2:\"id\";i:2;}', 1, 0, 2, 1606736769),
(41, 'account', 'request_pickup', 'Send person for pickup ', 'a:2:{i:0;s:21:\"/customer-detail/view\";s:2:\"id\";i:31;}', 1, 0, 1, 1606907118),
(42, 'account', 'order_add', 'Order added by customer', 'a:2:{i:0;s:13:\"/invoice/view\";s:2:\"id\";s:2:\"68\";}', 1, 0, 1, 1606909064),
(43, 'account', 'order_update', 'Order update by customer ', 'a:2:{i:0;s:13:\"/invoice/view\";s:2:\"id\";s:2:\"68\";}', 1, 0, 1, 1606909339),
(44, 'account', 'order_delete', 'Order cancle by customer', 'a:2:{i:0;s:13:\"/invoice/view\";s:2:\"id\";s:2:\"68\";}', 1, 0, 1, 1606909424),
(45, 'account', 'request_pickup', 'Send person for pickup ', 'a:2:{i:0;s:21:\"/customer-detail/view\";s:2:\"id\";i:19;}', 1, 0, 1, 1606912728),
(46, 'account', 'request_pickup', 'Send person for pickup ', 'a:2:{i:0;s:21:\"/customer-detail/view\";s:2:\"id\";i:19;}', 1, 0, 1, 1606915620),
(47, 'account', 'request_pickup', 'Send person for pickup ', 'a:2:{i:0;s:21:\"/customer-detail/view\";s:2:\"id\";i:19;}', 1, 0, 1, 1606917095);

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

--
-- Table structure for table `notificationss`
--

CREATE TABLE `notificationss` (
  `n_id` int(11) NOT NULL,
  `type` enum('1','2') NOT NULL COMMENT '1:birthday,2:order',
  `receivear` int(11) NOT NULL,
  `content` varchar(255) NOT NULL,
  `status` enum('0','1') NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notificationss`
--

INSERT INTO `notificationss` (`n_id`, `type`, `receivear`, `content`, `status`, `date`) VALUES
(1, '2', 0, 'You got a email notification', '0', '2020-11-25 07:10:54'),
(2, '2', 0, 'Your account has been blocked', '0', '2020-11-25 07:10:54'),
(3, '2', 0, 'Your account has been blocked', '0', '2020-11-25 07:32:00'),
(4, '2', 0, 'You got a email notification', '0', '2020-11-25 07:32:00');

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

--
-- Table structure for table `order_detail`
--

CREATE TABLE `order_detail` (
  `oid` int(11) NOT NULL,
  `custid` int(11) NOT NULL,
  `invid` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `service` varchar(50) NOT NULL,
  `product` varchar(30) NOT NULL,
  `price` int(11) NOT NULL,
  `no_iteam` smallint(10) NOT NULL,
  `total_price` mediumint(30) NOT NULL,
  `ip_id` int(11) NOT NULL,
  `remarks` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `order_detail`
--

INSERT INTO `order_detail` (`oid`, `custid`, `invid`, `type`, `service`, `product`, `price`, `no_iteam`, `total_price`, `ip_id`, `remarks`) VALUES
(44, 4, 21, 'shoes-spa', 'spa', 'formal shoes', 150, 5, 750, 11, ''),
(48, 3, 30, 'household', 'dryclean', 'cousion', 50, 2, 100, 28, ''),
(50, 2, 32, 'kids', 'steam-iron', 'Tshirt', 5, 3, 15, 7, ''),
(51, 2, 33, 'shoes-spa', 'spa', 'boot', 150, 23, 3450, 24, ''),
(52, 2, 34, 'household', 'wash-iron', 'cousion', 25, 17, 425, 27, ''),
(53, 2, 35, 'men', 'dryclean', 'shirt', 50, 10, 500, 17, ''),
(54, 1, 36, 'men', 'steam-iron', 'shirt', 7, 5, 35, 15, '123'),
(55, 1, 36, 'kids', 'steam-iron', 'shirt', 5, 5, 25, 21, ''),
(56, 20, 37, 'shoes-spa', 'spa', 'boot', 150, 2, 300, 24, 'ASD'),
(57, 3, 38, 'kids', 'wash-iron', 'shirt', 25, 5, 125, 22, ''),
(58, 3, 38, 'household', 'wash-iron', 'cousion', 25, 5, 125, 27, 'Hard Press'),
(59, 2, 39, 'men', 'steam-iron', 'shirt', 7, 5, 35, 15, ''),
(74, 22, 64, 'men', 'wash-iron', 'shirt', 25, 5, 125, 16, ' '),
(75, 22, 64, 'kids', 'steam-iron', 'shirt', 5, 2, 10, 21, ''),
(76, 30, 65, 'household', 'dryclean', 'cousion', 50, 1, 50, 28, ''),
(77, 30, 65, 'shoes-spa', 'spa', 'shoes', 150, 1, 150, 10, 'H2'),
(78, 30, 65, 'kids', 'dryclean', 'shirt', 50, 1, 50, 23, 'H1'),
(79, 31, 66, 'woman', 'wash-iron', 'shirt', 25, 5, 125, 19, ''),
(80, 31, 66, 'men', 'dryclean', 'shirt', 50, 5, 250, 17, ''),
(81, 31, 67, 'men', 'wash-iron', 'shirt', 25, 5, 125, 16, ' '),
(82, 31, 68, 'household', 'dryclean', 'cousion', 50, 1, 50, 28, '');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT 10,
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `verification_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `created_at`, `updated_at`, `verification_token`) VALUES
(1, 'Hooks&Hangers', 'nqs3q-RDokrg6OWX6tIvPwGHyyVENeNI', '$2y$13$lTKP1HR2vSFPd4o9osnsIeTLW9Fr.P0ypXUlynMVYxNvbtSKYg.jq', NULL, 'test@yopmail.com', 10, 1605104458, 1605104458, 'nqOgiHq7xu-W1VZ8Xla7eQGZEhU0Tk4T_1605104457'),
(2, 'Mk72', 'FMMkvBg2cF8E2L8Wvk1M5oXwYcvLMhMy', '$2y$13$NBUvK7dAmHXgt.BXWPRvu.iw.hJ1dIbfYtjQG0ZJ2yaHkVa5IRAuW', NULL, 'yop@yopmail.com', 10, 1605159794, 1606552445, 'l5su657sAmTWTnJVY63soF6fMmUshSyo_1605159794'),
(5, 'ASD', 'MY92peJ5pGMGtUqniWI-ST21iIoWEw-M', '$2y$13$RgprMx6PoaF8wlpXY8DucuYT6HB/XXVcUg4QJ.iPpMnZ9g2.8gm1q', NULL, 'asd@yopmail.com', 9, 1605678406, 1605678406, 'OjzJ2XrXp_U7XXAo7a0JT9HYIz7Kmkar_1605678406'),
(6, 'JK', 'VsrfCgzdrSGEd9dDfH10LGKJI16qSJ7a', '$2y$13$S7pvATJ5rqxprXIhRDlnCOw2VxfOXDKCGD31PYsbpkgdNw./FjeXC', NULL, 'jk@yopmail.com', 9, 1605678536, 1605678536, 'eRv5fVZwri0dsIu1xK8ezJPYVSU4kK1P_1605678536'),
(8, 'MM', 'v0QFqVgcylVCtCiZ2eesZzgDkFmsHbks', '$2y$13$I5XvsYBlR6lP7xHtw6YsPeyv.8MAEaHvs9ozz4pRFERcIl2l7iZdi', NULL, 'mm@yopmail.com', 9, 1605679343, 1605679343, 'V-xxKaCF0GIM_8sbOvyPOaSzBbcmeLpC_1605679343'),
(9, 'ABC', 'NpWERFG3bFeGHRHzwM8fEZhY3NdbTPHN', '$2y$13$T7ecBSCR3pl1faAW7./CR.IoIJQ0xbaK3Q1DwF9BOuSep3BV7sHKu', NULL, 'abc@yopmail.com', 10, 1606308153, 1606308345, 'RRce5VpXEcvYpIUJ-3HDrw6ys-zZB2us_1606308152'),
(10, 'QWE', 'h5uWmsE-err5K1BlcHrgZOGT_HA3LVu4', '$2y$13$Z/xiYHWHnFCY.31FUdf1SO9Ql0VrKdFIvf1Fvm4KYEsq1LoBXd6.S', NULL, 'abd@yopmail.com', 9, 1606381533, 1606381533, '1hoeGLJPeEF6Lino45i2Wij6iYjT-JwF_1606381533');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `barcode`
--
ALTER TABLE `barcode`
  ADD PRIMARY KEY (`b_id`),
  ADD KEY `custid` (`custid`),
  ADD KEY `barcode_ibfk_1` (`invid`);

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

--
-- Indexes for table `customer_membership`
--
ALTER TABLE `customer_membership`
  ADD PRIMARY KEY (`cmbsp_id`),
  ADD KEY `custid` (`custid`),
  ADD KEY `ms_id` (`ms_id`);

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`inv_id`),
  ADD KEY `invoice_ibfk_1` (`cust_id`);

--
-- Indexes for table `iteam_price`
--
ALTER TABLE `iteam_price`
  ADD PRIMARY KEY (`ip_id`);

--
-- Indexes for table `membership`
--
ALTER TABLE `membership`
  ADD PRIMARY KEY (`mbs_id`);

--
-- Indexes for table `migration`
--
ALTER TABLE `migration`
  ADD PRIMARY KEY (`version`);

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `index_2` (`user_id`),
  ADD KEY `index_3` (`created_at`),
  ADD KEY `index_4` (`seen`);

--
-- Indexes for table `notificationss`
--
ALTER TABLE `notificationss`
  ADD PRIMARY KEY (`n_id`);

--
-- Indexes for table `order_detail`
--
ALTER TABLE `order_detail`
  ADD PRIMARY KEY (`oid`),
  ADD KEY `custid` (`custid`),
  ADD KEY `ip_id` (`ip_id`),
  ADD KEY `order_detail_ibfk_2` (`invid`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `password_reset_token` (`password_reset_token`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `barcode`
--
ALTER TABLE `barcode`
  MODIFY `b_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=416;

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

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

--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
  MODIFY `inv_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `iteam_price`
--
ALTER TABLE `iteam_price`
  MODIFY `ip_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

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

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

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

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

--
-- AUTO_INCREMENT for table `order_detail`
--
ALTER TABLE `order_detail`
  MODIFY `oid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `barcode`
--
ALTER TABLE `barcode`
  ADD CONSTRAINT `barcode_ibfk_1` FOREIGN KEY (`invid`) REFERENCES `invoice` (`inv_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `barcode_ibfk_2` FOREIGN KEY (`custid`) REFERENCES `customer_detail` (`id`);

--
-- Constraints for table `customer_membership`
--
ALTER TABLE `customer_membership`
  ADD CONSTRAINT `customer_membership_ibfk_1` FOREIGN KEY (`custid`) REFERENCES `customer_detail` (`id`),
  ADD CONSTRAINT `customer_membership_ibfk_2` FOREIGN KEY (`ms_id`) REFERENCES `membership` (`mbs_id`);

--
-- Constraints for table `invoice`
--
ALTER TABLE `invoice`
  ADD CONSTRAINT `invoice_ibfk_1` FOREIGN KEY (`cust_id`) REFERENCES `customer_detail` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_detail`
--
ALTER TABLE `order_detail`
  ADD CONSTRAINT `order_detail_ibfk_1` FOREIGN KEY (`custid`) REFERENCES `customer_detail` (`id`),
  ADD CONSTRAINT `order_detail_ibfk_2` FOREIGN KEY (`invid`) REFERENCES `invoice` (`inv_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_detail_ibfk_3` FOREIGN KEY (`ip_id`) REFERENCES `iteam_price` (`ip_id`);
COMMIT;

