supershop.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 03, 2025 at 05:59 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: `supershop`
--

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

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` int(5) NOT NULL,
  `bill_id` int(5) NOT NULL,
  `cus_name` varchar(20) NOT NULL,
  `cus_contact` varchar(11) NOT NULL,
  `cus_address` varchar(25) NOT NULL,
  `p_name` varchar(30) NOT NULL,
  `p_category` varchar(15) NOT NULL,
  `p_unit` varchar(12) NOT NULL,
  `p_price` int(8) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`id`, `bill_id`, `cus_name`, `cus_contact`, `cus_address`, `p_name`, `p_category`, `p_unit`, `p_price`, `date`) VALUES
(1, 101, 'Mehedi Hasan', '01985467745', 'Changau', 'Milk Vita Milk', 'Dairy', '1L', 85, '2025-03-02'),
(2, 102, 'Abdullah Al Noman', '01722102892', 'YKSG1', 'Nestle Kit Kat', 'Chocolate', '40gm', 50, '2025-03-05'),
(3, 103, 'S.M Minhazul Abedin', '01236714038', 'Changau', 'Cadbury Dairy Milk Chocolate', 'Chocolate', '55gm', 100, '2025-03-08'),
(4, 104, 'Md. Dipto Piyar Likh', '01985467858', 'YKSG1', 'Teer Soybean Oil', 'Cooking', '1L', 180, '2025-03-10'),
(5, 105, 'Ragib Sahariar Riyad', '01923476584', 'Changau', 'Mutton', 'Meat', '1kg', 1100, '2025-03-12'),
(6, 106, 'Md. Raihan', '01845678912', 'YKSG1', 'ACI Pure Salt', 'Grocery', '1kg', 38, '2025-03-15'),
(7, 107, 'Md. Rashedul Islam', '01902364598', 'YKSG2', 'Fresh Sugar', 'Grocery', '1kg', 90, '2025-03-18'),
(8, 108, 'Md. Tareq Hossain', '01756987412', 'YKSG1', 'Golden Harvest Chicken Nuggets', 'Frozen', '500gm', 360, '2025-03-20'),
(9, 109, 'Hasibul Hasan', '01856321458', 'YKSG2', 'Farm Eggs', 'Dairy', '1 Piece', 12, '2025-03-22'),
(10, 110, 'Farhan Rahman', '01456982347', 'Changau', 'Bashundhara Tissue', 'Household', '1 Pack', 60, '2025-03-24'),
(11, 111, 'Abdullah Al Mamun', '01236714038', 'YKSG2', 'Rupchanda Soybean Oil', 'Cooking', '1L', 185, '2025-03-25'),
(12, 112, 'Tanjid Hasan', '01978541236', 'Changau', 'Closeup Toothpaste', 'Toiletries', '100gm', 115, '2025-03-26'),
(13, 113, 'Sakib Bin Kamal', '01875631478', 'Changau', 'Horlicks', 'Health', '500gm', 550, '2025-03-27'),
(14, 114, 'Adnan Iqbal', '01459894594', 'Changau', 'Broiler Chicken', 'Meat', '1kg', 170, '2025-03-28'),
(15, 115, 'Nazir Sabbry', '01386435812', 'YKSG2', 'Fresh Potato', 'Vegetables', '1kg', 45, '2025-03-29'),
(16, 116, 'Asif Mahmud', '01784561239', 'Changau', 'Pampers Diaper', 'Baby Care', '1 Pack', 1400, '2025-03-30'),
(17, 117, 'Fahim Hasan', '01795621485', 'YKSG2', 'Nestlé Nido Milk Powder', 'Dairy', '1kg', 650, '2025-03-31'),
(18, 118, 'Md. Tanvir Islam', '01329384568', 'YKSG2', 'Lux Soap', 'Toiletries', '100gm', 45, '2025-04-01'),
(19, 119, 'Md. Shafiqul Islam', '01975621458', 'YKSG1', 'Almarai Cheese', 'Dairy', '500gm', 550, '2025-04-02'),
(20, 120, 'Nashit Ahmed', '01563478965', 'YKSG2', 'Savlon Antiseptic', 'Health', '100ml', 210, '2025-04-03');

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `eid` int(5) NOT NULL,
  `name` varchar(20) NOT NULL,
  `contact` varchar(11) NOT NULL,
  `address` varchar(30) NOT NULL,
  `djoin` date DEFAULT NULL,
  `post` varchar(25) NOT NULL,
  `salary` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`eid`, `name`, `contact`, `address`, `djoin`, `post`, `salary`) VALUES
(1, 'Abdullah Al Noman', '01725036007', 'Natore', '2025-02-01', 'Manager', 50000),
(2, 'Adnan Iqbal', '0198394750', 'Bogura', '2024-02-02', 'Salesman', 20000),
(3, 'Tanvir Islam', '01308971029', 'Bogura', '2024-02-15', 'Salesman', 20000),
(4, 'Rashedul Islam', '01710832462', 'Dupchachia', '2025-02-11', 'Salesman', 18000),
(5, 'Mehedi Hasan', '01374802693', 'Panchagarh', '2025-02-25', 'Store Keeper', 10000),
(6, 'Reduan Ahmad', '01386346905', 'Bramhanbaria', '2025-03-01', 'Assistant Manager', 40000),
(7, 'Ashraful Alam', '01903846986', 'Gazipur', '2025-03-06', 'Customer Service', 25000);

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

--
-- Table structure for table `login_info`
--

CREATE TABLE `login_info` (
  `id` int(3) NOT NULL,
  `name` varchar(20) NOT NULL,
  `username` varchar(15) NOT NULL,
  `password` varchar(15) NOT NULL,
  `type` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `login_info`
--

INSERT INTO `login_info` (`id`, `name`, `username`, `password`, `type`) VALUES
(1, 'Abdullah Al Noman', 'Noman003', '003', 'admin'),
(2, 'Rashedul Islam', 'rashed066', '111', 'salesman'),
(3, 'Adnan Iqbal', 'adnan024', '024', 'salesman');

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

--
-- Table structure for table `productlist`
--

CREATE TABLE `productlist` (
  `p_id` int(5) NOT NULL,
  `P_name` varchar(35) NOT NULL,
  `category` varchar(10) NOT NULL,
  `p_price` int(6) NOT NULL,
  `p_unit` varchar(10) NOT NULL,
  `stock` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `productlist`
--

INSERT INTO `productlist` (`p_id`, `P_name`, `category`, `p_price`, `p_unit`, `stock`) VALUES
(1, 'Miniket Rice', 'Grocery', 75, '1kg', 496),
(2, 'Nazirshail Rice', 'Grocery', 85, '1kg', 400),
(3, 'Teer Soybean Oil', 'Cooking', 180, '1L', 300),
(4, 'Rupchanda Soybean Oil', 'Cooking', 185, '1L', 250),
(5, 'ACI Pure Salt', 'Grocery', 38, '1kg', 350),
(6, 'Fresh Sugar', 'Grocery', 90, '1kg', 450),
(7, 'Broiler Chicken', 'Meat', 170, '1kg', 200),
(8, 'Beef', 'Meat', 750, '1kg', 149),
(9, 'Mutton', 'Meat', 1100, '1kg', 100),
(10, 'Farm Eggs', 'Dairy', 12, '1 Piece', 600),
(11, 'Milk Vita Milk', 'Dairy', 85, '1L', 500),
(12, 'Almarai Cheese', 'Dairy', 550, '500gm', 100),
(13, 'Nido Milk Powder', 'Dairy', 650, '1kg', 120),
(14, 'Lifebuoy Soap', 'Toiletries', 40, '100gm', 300),
(15, 'Lux Soap', 'Toiletries', 45, '100gm', 250),
(16, 'Pepsodent Toothpaste', 'Toiletries', 120, '100gm', 200),
(17, 'Closeup Toothpaste', 'Toiletries', 115, '100gm', 220),
(18, 'Meril Baby Powder', 'Baby Care', 250, '200gm', 100),
(19, 'Pampers Diaper', 'Baby Care', 1400, '1 Pack', 90),
(20, 'Savlon Antiseptic', 'Health', 210, '100ml', 150),
(21, 'Horlicks', 'Health', 550, '500gm', 179),
(22, 'Bashundhara Tissue', 'Household', 60, '1 Pack', 400),
(23, 'ACI Mosquito Spray', 'Household', 320, '300ml', 150),
(24, 'Dettol Handwash', 'Toiletries', 160, '250ml', 180),
(25, 'Fresh Potato', 'Vegetables', 45, '1kg', 500),
(26, 'Fresh Tomato', 'Vegetables', 70, '1kg', 400),
(27, 'Golden Harvest Chicken Nuggets', 'Frozen', 360, '500gm', 120),
(28, 'Igloo Vanilla Ice Cream', 'Frozen', 300, '1L', 100),
(29, 'PRAN Mango Juice', 'Beverages', 150, '1L', 200),
(30, 'Coca-Cola', 'Beverages', 45, '500ml', 500);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`eid`);

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

--
-- Indexes for table `productlist`
--
ALTER TABLE `productlist`
  ADD PRIMARY KEY (`p_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `employee`
--
ALTER TABLE `employee`
  MODIFY `eid` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `productlist`
--
ALTER TABLE `productlist`
  MODIFY `p_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
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 */;