-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 19, 2025 at 03:01 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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


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

--
-- Database: `barber_baba`
--

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

--
-- Table structure for table `emailsetting`
--

CREATE TABLE `emailsetting` (
  `id` int(11) NOT NULL,
  `smtp_server` varchar(255) NOT NULL,
  `smtp_username` varchar(255) NOT NULL,
  `smtp_password` varchar(255) NOT NULL,
  `stmp_port` varchar(255) NOT NULL,
  `smtp_type` varchar(255) NOT NULL,
  `email` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `emailsetting`
--

INSERT INTO `emailsetting` (`id`, `smtp_server`, `smtp_username`, `smtp_password`, `stmp_port`, `smtp_type`, `email`) VALUES
(1, '', '', '', '', '', '');

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

--
-- Table structure for table `membership_plans`
--

CREATE TABLE `membership_plans` (
  `id` int(11) NOT NULL,
  `plan_name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `duration_days` int(11) DEFAULT NULL,
  `services_included` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_plans`
--

INSERT INTO `membership_plans` (`id`, `plan_name`, `description`, `price`, `duration_days`, `services_included`, `created_at`) VALUES
(2, 'Groom Plan', 'Groom Plan', 499.00, 2, NULL, '2025-06-09 06:44:33'),
(3, 'Basic Beauty Plan', 'Perfect for quick touch-ups and essential grooming. Ideal for clients who need routine maintenance.', 399.00, 3, NULL, '2025-06-09 06:47:15'),
(4, 'Glam Refresh Plan', 'A mid-range beauty package for a polished, fresh look with a bit of pampering.', 345.00, 1, NULL, '2025-06-09 06:48:39'),
(5, 'Luxe Makeover Plan', 'A deluxe beauty treatment ideal for full transformation or self-care weekends.', 299.00, 2, NULL, '2025-06-09 06:49:13'),
(6, ' Bridal Elegance Plan', ' Full-service bridal plan covering both trial and wedding day preparations.\r\n\r\n', 3599.00, 3, NULL, '2025-06-09 06:50:05'),
(7, 'Monthly Membership Plan', 'Perfect for clients who love regular care and exclusive discounts.', 999.00, 30, NULL, '2025-06-09 06:51:20');

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

--
-- Table structure for table `tbladmin`
--

CREATE TABLE `tbladmin` (
  `ID` int(10) NOT NULL,
  `AdminName` char(50) DEFAULT NULL,
  `UserName` char(50) DEFAULT NULL,
  `MobileNumber` varchar(100) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `Password` varchar(200) DEFAULT NULL,
  `AdminRegdate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbladmin`
--

INSERT INTO `tbladmin` (`ID`, `AdminName`, `UserName`, `MobileNumber`, `Email`, `Password`, `AdminRegdate`) VALUES
(1, 'Admin', 'mayurik', '+91 95292 30459', 'work@mayurik.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', '2025-06-18 06:21:50');

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

--
-- Table structure for table `tblappointment`
--

CREATE TABLE `tblappointment` (
  `ID` int(10) NOT NULL,
  `AptNumber` varchar(80) DEFAULT NULL,
  `Name` varchar(120) DEFAULT NULL,
  `Email` varchar(120) DEFAULT NULL,
  `PhoneNumber` bigint(11) DEFAULT NULL,
  `AptDate` varchar(120) DEFAULT NULL,
  `AptTime` varchar(120) DEFAULT NULL,
  `Services` varchar(120) DEFAULT NULL,
  `ApplyDate` timestamp NULL DEFAULT current_timestamp(),
  `Remark` varchar(250) DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `total` varchar(50) NOT NULL,
  `grand_total` varchar(50) NOT NULL,
  `payment_id` varchar(50) NOT NULL,
  `order_id` varchar(100) NOT NULL,
  `RemarkDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblappointment`
--

INSERT INTO `tblappointment` (`ID`, `AptNumber`, `Name`, `Email`, `PhoneNumber`, `AptDate`, `AptTime`, `Services`, `ApplyDate`, `Remark`, `Status`, `total`, `grand_total`, `payment_id`, `order_id`, `RemarkDate`) VALUES
(1, '406902384', '2', 'singh@gmail.com', 9861234567, '2025-06-22', '10:19', '1', '2025-06-18 05:49:20', 'booke', '1', ' 120', '132.00', '', '', '2025-06-18 06:03:43'),
(2, '838216640', '6', 'manish@gmail.com', 9879879798, '2025-06-20', '10:19', '2,4', '2025-06-18 05:49:58', 'come on time', '1', ' 1000', '1100.00', '', '', '2025-06-18 06:04:50'),
(3, '198518991', '9', 'ananya.sharma@email.com', 9876543210, '2025-06-23', '11:00', '8,10', '2025-06-18 05:51:07', 'come on time', '1', ' 4249', '4673.90', '', '', '2025-06-18 06:05:50'),
(4, '614651899', '10', 'baxiwo2548@3dboxer.com', 9823456781, '2025-06-22', '12:00', '17', '2025-06-18 05:51:49', 'come on time', '1', ' 85', '93.50', '', '', '2025-06-18 06:10:05'),
(5, '305700091', '12', 'neha.patil@email.com', 9765432198, '2025-06-24', '12:00', '18', '2025-06-18 05:52:30', 'come', '1', ' 10', '11.00', '', '', '2025-06-18 06:06:22'),
(6, '469626681', '11', 'pri.d@email.com', 989898989, '2025-06-26', '10:00', '1', '2025-06-18 06:01:07', 'booked', '1', ' 120', '132.00', '', '', '2025-06-18 06:06:55'),
(7, '931285159', '15', 'nitin@gmail.com', 9861234567, '2025-06-27', '01:00', '12', '2025-06-18 06:01:35', 'not available', '2', '', '', '', '', '2025-06-18 06:08:00'),
(8, '191691176', '16', 'nirja@gmail.com', 9861234567, '2025-06-30', '12:00', '9', '2025-06-18 06:02:07', 'not available', '2', '', '', '', '', '2025-06-18 06:08:27'),
(9, '724442498', '14', 'hrao@email.com', 9823412398, '2025-06-25', '11:00', '17', '2025-06-18 06:02:33', 'cancel', '2', '', '', '', '', '2025-06-18 06:10:49'),
(10, '700954060', '13', 'rohan.kapoor@email.com', 9832123456, '2025-06-25', '11:00', '6', '2025-06-18 06:03:12', 'booked', '1', ' 300', '330.00', '', '', '2025-06-18 06:09:09'),
(11, '316060975', '6', 'manish@gmail.com', 9879879798, '2025-06-19', '11:20', '6', '2025-06-18 17:23:55', NULL, NULL, '', '', '', '', NULL);

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

--
-- Table structure for table `tblcustomers`
--

CREATE TABLE `tblcustomers` (
  `ID` int(10) NOT NULL,
  `Name` varchar(120) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `MobileNumber` bigint(11) DEFAULT NULL,
  `Gender` enum('Female','Male','Transgender') DEFAULT NULL,
  `dob` date NOT NULL,
  `marriage_date` date NOT NULL,
  `Details` mediumtext DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT current_timestamp(),
  `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblcustomers`
--

INSERT INTO `tblcustomers` (`ID`, `Name`, `Email`, `MobileNumber`, `Gender`, `dob`, `marriage_date`, `Details`, `CreationDate`, `UpdationDate`) VALUES
(2, 'Rahul Singh', 'singh@gmail.com', 9861234567, 'Male', '1988-06-30', '1915-02-01', 'Taken haircut by him', '2023-12-08 11:10:02', '2025-06-09 09:54:03'),
(6, 'Manish patil', 'manish@gmail.com', 9879879798, 'Male', '1995-12-19', '0000-00-00', 'Hair spa every 2nd Saturday', '2023-12-08 11:10:02', '2025-06-05 12:03:11'),
(9, 'Ananya Sharma	', 'ananya.sharma@email.com', 9876543210, 'Female', '1993-05-12', '0000-00-00', 'Prefers evening appointments', '2025-06-05 11:56:48', NULL),
(10, 'Rahul Mehta	', 'baxiwo2548@3dboxer.com', 9823456781, 'Male', '1998-06-10', '1915-06-10', 'Allergic to certain hair dyes', '2025-06-05 11:58:26', '2025-06-09 09:35:35'),
(11, 'Pritam Deshmukh	', 'pri.d@email.com', 989898989, 'Female', '2000-10-03', '0000-00-00', 'Regular manicure every 15 days', '2025-06-05 11:59:36', '2025-06-18 05:59:43'),
(12, 'Suresh Nair	', 'neha.patil@email.com', 9765432198, 'Male', '1997-06-17', '0000-00-00', 'Vegan products only', '2025-06-05 12:00:36', NULL),
(13, 'Rohan Kapoor	', 'rohan.kapoor@email.com', 9832123456, 'Male', '2002-03-20', '0000-00-00', 'Monthly haircut & beard trim', '2025-06-05 12:01:36', NULL),
(14, 'Harsh Rao	', 'hrao@email.com', 9823412398, 'Female', '2002-06-19', '0000-00-00', 'Bridal makeup booked in Sept', '2025-06-05 12:04:23', '2025-06-18 05:58:58'),
(15, 'Nitin Patil', 'nitin@gmail.com', 9861234567, 'Female', '1990-01-01', '2025-05-05', 'booked before', '2025-06-18 05:47:14', '2025-06-18 06:00:28'),
(16, 'Niraj Pagar ', 'nirja@gmail.com', 9861234567, 'Female', '1991-06-02', '0000-00-00', 'working', '2025-06-18 05:48:48', '2025-06-18 05:59:19');

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

--
-- Table structure for table `tblinvoice`
--

CREATE TABLE `tblinvoice` (
  `id` int(11) NOT NULL,
  `Userid` int(11) DEFAULT NULL,
  `ServiceId` int(11) DEFAULT NULL,
  `BillingId` int(11) DEFAULT NULL,
  `staff` varchar(50) NOT NULL,
  `commision` decimal(10,2) NOT NULL,
  `tax` varchar(50) NOT NULL,
  `total` varchar(50) NOT NULL,
  `qty` varchar(100) NOT NULL,
  `payment_method` varchar(100) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `PostingDate` date DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblinvoice`
--

INSERT INTO `tblinvoice` (`id`, `Userid`, `ServiceId`, `BillingId`, `staff`, `commision`, `tax`, `total`, `qty`, `payment_method`, `type`, `PostingDate`) VALUES
(1, 2, 1, 786714662, '3', 13.20, '10', '132.00', '', '', 0, '2025-06-18'),
(2, 6, 2, 916334187, '7', 55.00, '10', '1100.00', '', '', 0, '2025-06-18'),
(3, 6, 4, 916334187, '7', 55.00, '10', '1100.00', '', '', 0, '2025-06-18'),
(4, 9, 8, 611651392, '3', 233.70, '10', '4673.90', '', '', 0, '2025-06-18'),
(5, 9, 10, 611651392, '3', 233.70, '10', '4673.90', '', '', 0, '2025-06-18'),
(6, 12, 18, 449785482, '7', 1.10, '10', '11.00', '', '', 0, '2025-06-18'),
(7, 11, 1, 266019248, '6', 13.20, '10', '132.00', '', '', 0, '2025-06-18'),
(8, 13, 6, 204305143, '4', 33.00, '10', '330.00', '', '', 0, '2025-06-18'),
(9, 10, 17, 746950582, '5', 9.35, '10', '93.50', '', '', 0, '2025-06-18'),
(10, 2, 22, 691714693, '', 0.00, '10', '2420.00', '1', '1', 1, '2025-06-18'),
(11, 2, 11, 691714693, '', 0.00, '10', '2420.00', '1', '1', 1, '2025-06-18'),
(12, 10, 25, 435735784, '', 0.00, '10', '1010.90', '1', '1', 1, '2025-06-18'),
(13, 10, 26, 435735784, '', 0.00, '10', '1010.90', '1', '1', 1, '2025-06-18'),
(14, 14, 28, 347426140, '', 0.00, '10', '5280.00', '2', '2', 1, '2025-06-18'),
(15, 14, 29, 347426140, '', 0.00, '10', '5280.00', '2', '2', 1, '2025-06-18'),
(16, 13, 24, 750091638, '', 0.00, '10', '1177.00', '1', '1', 1, '2025-06-18'),
(17, 13, 26, 750091638, '', 0.00, '10', '1177.00', '1', '1', 1, '2025-06-18'),
(18, 14, 26, 293695303, '', 0.00, '10', '682.00', '1', '1', 1, '2025-06-18'),
(19, 2, 22, 464480648, '', 0.00, '10', '3186.70', '2', '1', 1, '2025-06-18'),
(20, 2, 25, 464480648, '', 0.00, '10', '3186.70', '3', '1', 1, '2025-06-18');

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

--
-- Table structure for table `tblservices`
--

CREATE TABLE `tblservices` (
  `ID` int(10) NOT NULL,
  `ServiceName` varchar(200) DEFAULT NULL,
  `Description` mediumtext DEFAULT NULL,
  `Cost` int(10) DEFAULT NULL,
  `opening_stock` int(11) NOT NULL DEFAULT 0,
  `cate_id` varchar(50) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `CreationDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblservices`
--

INSERT INTO `tblservices` (`ID`, `ServiceName`, `Description`, `Cost`, `opening_stock`, `cate_id`, `type`, `CreationDate`) VALUES
(1, 'O3 Facial', 'Activated charcoal draws bacteria, toxins, dirt and oil from the skin.', 120, 0, '1', 2, '2023-12-05 11:22:38'),
(2, 'Fruit Facial', 'If its a peel-off mask, it also works as an excellent exfoliator, ridding the skin of dead cells.', 500, 0, '1', 2, '2023-12-05 11:22:38'),
(3, 'Charcol Facial', 'The end result is skin that is clean and clear. When used as a powder, charcoal masks can reach deep in your pores and suck out impurities with them.', 1000, 0, '1', 2, '2023-12-05 11:22:38'),
(4, 'Deluxe Menicure', 'The end result is skin that is clean and clear. When used as a powder, charcoal masks can reach deep in your pores and suck out impurities with them.', 500, 0, '1', 2, '2023-12-05 11:22:38'),
(6, 'Normal Menicure', 'A pedicure is a therapeutic treatment for your feet that removes dead skin, softens hard skin and shapes and treats your toenails.', 300, 0, '1', 2, '2023-12-05 11:22:38'),
(7, 'Normal Pedicure', 'A pedicure is a therapeutic treatment for your feet that removes dead skin, softens hard skin and shapes and treats your toenails.', 400, 0, '1', 2, '2023-12-05 11:22:38'),
(8, 'Hair Cut', 'A hairstyle, hairdo, or haircut refers to the styling of hair, usually on the human scalp. Sometimes, this could also mean an editing of facial or body hair', 250, 0, '3', 2, '2023-12-05 11:22:38'),
(9, 'Style Haircut', 'A hairstyle, hairdo, or haircut refers to the styling of hair, usually on the human scalp. Sometimes, this could also mean an editing of facial or body hair', 550, 0, '3', 2, '2023-12-05 11:22:38'),
(10, 'Hair Wash', 'A hairstyle, hairdo, or haircut refers to the styling of hair, usually on the human scalp. Sometimes, this could also mean an editing of facial or body hair', 3999, 0, '3', 2, '2023-12-05 11:22:38'),
(11, 'Loreal Hair Color(Full)', 'hgfhgj', 1200, 34, '3', 1, '2023-12-05 11:22:38'),
(12, 'Body Spa', 'It is full body spa including hair wash', 1500, 0, '1', 2, '2023-12-05 11:22:38'),
(16, 'Tradinational Cut', 'khghkhlkjlkjlkjflkrjnvoireyviutyouopyiuiosueoibvjmyruopo kjhkjhkhk kjh nkhu k iuyhiu kjhihiur', 45, 0, '3', 2, '2023-12-05 11:22:38'),
(17, 'MUSTACHE TRIM', 'Trim Trim Trim', 85, 0, '', 2, '2023-12-05 11:22:38'),
(18, 'Beard Trim', 'Beard Trim', 10, 0, '', 2, '2023-12-05 11:22:38'),
(22, 'Suncreen', 'Best use in Summer', 1000, 4, '1', 1, '2025-06-05 09:24:22'),
(23, 'Argan Repair Hair Serum', 'Lightweight serum enriched with argan oil to reduce frizz and add shine.', 550, 5, '3', 1, '2025-06-05 09:41:03'),
(24, 'Keratin Smooth Shampoo', 'Sulfate-free shampoo that deeply cleanses while preserving natural keratin.', 450, 7, '3', 1, '2025-06-05 09:44:18'),
(25, 'Vitamin C Glow Face Wash', 'Brightening cleanser with Vitamin C and orange peel extract for radiant skin.', 299, 3, '1', 1, '2025-06-05 09:45:08'),
(26, 'Hyaluronic Hydration Cream', 'Ultra-hydrating daily cream for dry and dull skin with hyaluronic acid.', 620, 17, '1', 1, '2025-06-05 09:45:54'),
(27, 'Hair Serums & Oils ', 'Hair Serums & Oils ', 1000, 30, '3', 1, '2025-06-18 06:17:41'),
(28, 'Hair Sprays & Mousse', 'for styling and volume', 1500, 13, '3', 1, '2025-06-18 06:18:11'),
(29, 'Hair Color & Dyes', 'ammonia-free, permanent, semi-permanent', 900, 8, '3', 1, '2025-06-18 06:18:52');

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

--
-- Table structure for table `tblsubscriber`
--

CREATE TABLE `tblsubscriber` (
  `ID` int(5) NOT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `DateofSub` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tblsubscriber`
--

INSERT INTO `tblsubscriber` (`ID`, `Email`, `DateofSub`) VALUES
(1, 'ani@gmail.com', '2023-12-09 07:32:33'),
(2, 'rahul@gmail.com', '2023-12-09 07:32:33'),
(3, 'ganesh@gmail.com', '2023-12-09 07:32:33');

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`id`, `name`, `status`) VALUES
(1, 'Skin', 1),
(3, 'Hair', 1);

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

--
-- Table structure for table `tbl_staff`
--

CREATE TABLE `tbl_staff` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `contact` varchar(50) NOT NULL,
  `address` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_staff`
--

INSERT INTO `tbl_staff` (`id`, `name`, `email`, `contact`, `address`) VALUES
(3, 'Priya Sharma', '12 Rosewood Apartments, MG Road, Bangalore, Karnataka', '9876543210', 'priya.sharma@example.com'),
(4, 'Rahul Mehta', '45 Green Park, Sector 14, Gurgaon, Haryana', '9123456789', 'rahul.mehta@example.com'),
(5, 'Anjali Verma', '78 Lake View Colony, Pune, Maharashtra', '9988766554', 'anjali.verma@example.com'),
(6, ' Karan Singh', '23 Palm Street, Salt Lake, Kolkata, West Bengal', '9567233445', 'karan.singh@example.com'),
(7, 'Sneha Joshi', '67 Hilltop Residency, Whitefield, Bangalore, Karnataka', '9874512345', 'sneha.joshi@example.com'),
(8, 'Amit Desai', '90 Coral Sands, Juhu, Mumbai, Maharashtra', '9876321098', 'amit.desai@example.com');

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

--
-- Table structure for table `tbl_staff_schedule`
--

CREATE TABLE `tbl_staff_schedule` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `shift_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'Scheduled',
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_staff_schedule`
--

INSERT INTO `tbl_staff_schedule` (`id`, `staff_id`, `shift_date`, `start_time`, `end_time`, `status`, `note`, `created_at`) VALUES
(1, 3, '2025-06-19', '10:00:00', '05:00:00', 'Working', NULL, '2025-06-18 06:28:10'),
(2, 4, '2025-06-04', '11:00:00', '06:00:00', 'Working', NULL, '2025-06-18 06:28:45'),
(3, 5, '2025-06-07', '10:00:00', '05:00:00', 'Day Off', NULL, '2025-06-18 06:29:29');

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

--
-- Table structure for table `tbl_tax`
--

CREATE TABLE `tbl_tax` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` varchar(100) NOT NULL,
  `delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_tax`
--

INSERT INTO `tbl_tax` (`id`, `name`, `value`, `delete_status`) VALUES
(4, 'GST', '10', 0);

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

--
-- Table structure for table `user_memberships`
--

CREATE TABLE `user_memberships` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `plan_id` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` enum('active','expired') DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_memberships`
--

INSERT INTO `user_memberships` (`id`, `user_id`, `plan_id`, `start_date`, `end_date`, `status`) VALUES
(1, 13, 4, '2025-06-09', '2025-06-10', 'active'),
(3, 12, 6, '2025-06-09', '2025-06-12', 'active'),
(4, 16, 3, '2025-06-18', '2025-06-21', 'active');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `tbladmin`
--
ALTER TABLE `tbladmin`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblappointment`
--
ALTER TABLE `tblappointment`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblcustomers`
--
ALTER TABLE `tblcustomers`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `tblservices`
--
ALTER TABLE `tblservices`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblsubscriber`
--
ALTER TABLE `tblsubscriber`
  ADD PRIMARY KEY (`ID`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `tbladmin`
--
ALTER TABLE `tbladmin`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tblappointment`
--
ALTER TABLE `tblappointment`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tblcustomers`
--
ALTER TABLE `tblcustomers`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `tblservices`
--
ALTER TABLE `tblservices`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `tblsubscriber`
--
ALTER TABLE `tblsubscriber`
  MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

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

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

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