-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 29, 2022 at 07:31 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `pos_low`
--

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

--
-- Table structure for table `barcode_print_details`
--

CREATE TABLE `barcode_print_details` (
  `bpd_id` int(11) NOT NULL,
  `bpd_user` int(11) NOT NULL,
  `bpd_barcode` varchar(20) NOT NULL,
  `bpd_qty` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `catogary_list`
--

CREATE TABLE `catogary_list` (
  `catogary_id` int(11) NOT NULL,
  `catogary_text` varchar(100) NOT NULL,
  `catogary_pin_to_pos` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `catogary_list`
--

INSERT INTO `catogary_list` (`catogary_id`, `catogary_text`, `catogary_pin_to_pos`) VALUES
(1, 'Other Category', 0);

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

--
-- Table structure for table `customer_details`
--

CREATE TABLE `customer_details` (
  `cs_id` int(11) NOT NULL,
  `cs_name` varchar(100) NOT NULL,
  `cs_pin` varchar(20) NOT NULL,
  `cs_mobile` varchar(10) NOT NULL,
  `cs_nic` varchar(20) NOT NULL,
  `cs_address` text NOT NULL,
  `cs_bill_discount` float NOT NULL,
  `cs_add_date` date NOT NULL,
  `cs_add_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `expenses_category`
--

CREATE TABLE `expenses_category` (
  `expenses_id` int(11) NOT NULL,
  `expenses_text` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `expenses_details`
--

CREATE TABLE `expenses_details` (
  `expenses_details_id` int(11) NOT NULL,
  `expenses_details_category` int(11) NOT NULL,
  `expenses_details_amount` float NOT NULL,
  `expenses_details_user` int(11) NOT NULL,
  `expenses_details_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `hold_bill_details`
--

CREATE TABLE `hold_bill_details` (
  `hbd_id` int(11) NOT NULL,
  `hbd_temp_id` varchar(20) NOT NULL,
  `hbd_name` varchar(255) NOT NULL,
  `hbd_mobile` varchar(20) NOT NULL,
  `hbd_remark` text NOT NULL,
  `hbd_add_date` date NOT NULL,
  `hbd_add_time` time NOT NULL,
  `hbd_add_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `price_details`
--

CREATE TABLE `price_details` (
  `price_id` int(11) NOT NULL,
  `price_systemid` varchar(50) NOT NULL,
  `price_name` varchar(100) NOT NULL,
  `price_buy` float NOT NULL,
  `price_sale` float NOT NULL,
  `price_wholesale` float NOT NULL,
  `price_special` float NOT NULL,
  `price_discount` float NOT NULL,
  `price_addtime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `product_affect_details`
--

CREATE TABLE `product_affect_details` (
  `pad_id` int(11) NOT NULL,
  `pad_main_product` int(11) NOT NULL,
  `pad_product_id` int(11) NOT NULL,
  `pad_qty` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `product_details`
--

CREATE TABLE `product_details` (
  `product_id` int(11) NOT NULL,
  `product_systemid` varchar(50) NOT NULL,
  `product_barcode` varchar(50) NOT NULL,
  `product_productid` varchar(50) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_name_sinhala` varchar(255) NOT NULL,
  `product_add_discount` int(11) NOT NULL,
  `product_alertqty` int(11) NOT NULL,
  `product_supplier` int(11) NOT NULL,
  `product_catagory` int(11) NOT NULL,
  `product_unit` int(11) NOT NULL,
  `product_stock_maintain` int(11) NOT NULL,
  `product_affect_stock` int(11) NOT NULL,
  `product_addtime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `quotation_details`
--

CREATE TABLE `quotation_details` (
  `qd_id` int(11) NOT NULL,
  `qd_bill_id` varchar(20) NOT NULL,
  `quotation_cus_name` varchar(255) NOT NULL,
  `quotation_mobile` varchar(20) NOT NULL,
  `quotation_remark` text NOT NULL,
  `qd_c_date` date NOT NULL,
  `qd_c_time` time NOT NULL,
  `qd_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `return_details`
--

CREATE TABLE `return_details` (
  `rd_id` int(11) NOT NULL,
  `rd_system_id` varchar(50) NOT NULL,
  `rd_user` int(11) NOT NULL,
  `rd_sale_list_id` int(11) NOT NULL,
  `rd_barcode` varchar(50) NOT NULL,
  `rd_qty` float NOT NULL,
  `rd_reson` varchar(255) NOT NULL,
  `rd_buy_price` float NOT NULL,
  `rd_sale_price` float NOT NULL,
  `rd_add_date` date NOT NULL,
  `rd_add_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `sale_details`
--

CREATE TABLE `sale_details` (
  `sale_details_id` int(11) NOT NULL,
  `sale_details_billid` varchar(20) NOT NULL,
  `sale_details_cash_payment` float NOT NULL,
  `sale_details_card_payment` float NOT NULL,
  `sale_details_cus_payment` float NOT NULL,
  `sale_details_discount` float NOT NULL,
  `sale_details_user` int(11) NOT NULL,
  `sale_details_customer` varchar(11) NOT NULL,
  `sale_details_date` date NOT NULL,
  `sale_details_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `sale_list`
--

CREATE TABLE `sale_list` (
  `sale_id` int(11) NOT NULL,
  `sale_billid` varchar(20) NOT NULL,
  `sale_barcode` varchar(20) NOT NULL,
  `sale_other_info` varchar(255) NOT NULL,
  `sale_buy_price` float NOT NULL,
  `sale_real_sale_price` float NOT NULL,
  `sale_saleprice` float NOT NULL,
  `sale_qty` float NOT NULL,
  `sale_mor_information` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `setting_id` int(11) NOT NULL,
  `setting_text` varchar(50) NOT NULL,
  `setting_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`setting_id`, `setting_text`, `setting_value`) VALUES
(1, 'bill_start_count', '1'),
(2, 'bill_pint', '1'),
(3, 'bill_title', 'online software solution'),
(4, 'bill_mobile', '0712770924, 0763119292'),
(5, 'bill_footer_text', 'Thankyou! Come Again...'),
(6, 'bill_lan', '0'),
(7, 'backup_notification', '1'),
(8, 'product_suggestions', '1'),
(9, 'bill_address', 'D/10, Alawala, Thunthota'),
(10, 'next_backup_date', '2022-12-30'),
(11, 'next_barcode', '100001'),
(12, 'bill_logo_display', '1'),
(13, 'bill_title_display', '1'),
(14, 'bill_address_display', '1'),
(15, 'bill_mobile_display', '1'),
(16, 'unit_display', '0'),
(17, 'ui_type', '1'),
(18, 'bill_font_size', '12'),
(19, 'logo_width', '50'),
(20, 'inventory_check', '0'),
(21, 'low_stock_popup', '1'),
(22, 'bill_email_display', '1'),
(23, 'bill_email', 'onlinesoftwarelk@gmail.com'),
(24, 'auto_add_item_list', '0'),
(25, 'auto_backup_status', '0'),
(26, 'bill_discount_issue', '0'),
(27, 'summery_send_phone', ''),
(28, 'auto_backup_from', ''),
(29, 'auto_backup_to', ''),
(31, 'customer_pin', '1000'),
(32, 'pos_product_edit', '0');

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

--
-- Table structure for table `start_balance_details`
--

CREATE TABLE `start_balance_details` (
  `Start_balance_id` int(11) NOT NULL,
  `Start_balance_date` date NOT NULL,
  `Start_balance_start_amount` float DEFAULT NULL,
  `Start_balance_end_amount` float DEFAULT NULL,
  `Start_balance_start_user` int(11) DEFAULT NULL,
  `Start_balance_end_time` datetime DEFAULT NULL,
  `Start_balance_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `stock_count`
--

CREATE TABLE `stock_count` (
  `sc_id` int(11) NOT NULL,
  `sc_date` date NOT NULL,
  `sc_select_cat` varchar(10) NOT NULL,
  `sc_user` int(11) NOT NULL,
  `sc_status` int(11) NOT NULL,
  `sc_c_date` date NOT NULL,
  `sc_c_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `stock_count_list`
--

CREATE TABLE `stock_count_list` (
  `scl_id` int(11) NOT NULL,
  `scl_details_id` int(11) NOT NULL,
  `scl_product` int(11) NOT NULL,
  `scl_system_qty` float NOT NULL,
  `scl_count_qty` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `stock_details`
--

CREATE TABLE `stock_details` (
  `stock_id` int(11) NOT NULL,
  `stock_systemid` varchar(50) NOT NULL,
  `stock_bill_id` varchar(20) NOT NULL,
  `stock_qty` float NOT NULL,
  `stock_type` tinyint(1) NOT NULL,
  `stock_info` varchar(255) NOT NULL,
  `stock_addtime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `supplier_bill_details`
--

CREATE TABLE `supplier_bill_details` (
  `supplier_bill_details_id` int(11) NOT NULL,
  `supplier_bill_details_system_id` varchar(20) NOT NULL,
  `supplier_bill_details_create_user` int(11) NOT NULL,
  `supplier_bill_details_supplier` int(11) NOT NULL,
  `supplier_bill_details_billnumber` varchar(20) NOT NULL,
  `supplier_bill_details_create_date` date NOT NULL,
  `supplier_bill_details_close_status` int(11) NOT NULL,
  `supplier_bill_details_due_date` date NOT NULL,
  `supplier_bill_details_close_remark` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `supplier_details`
--

CREATE TABLE `supplier_details` (
  `supplier_id` int(11) NOT NULL,
  `supplier_code` varchar(20) NOT NULL,
  `supplier_company` varchar(255) DEFAULT NULL,
  `supplier_name` varchar(100) NOT NULL,
  `supplier_contact_name` varchar(100) NOT NULL,
  `supplier_mobile` varchar(10) NOT NULL,
  `supplier_address1` text DEFAULT NULL,
  `supplier_address2` varchar(255) DEFAULT NULL,
  `supplier_address3` varchar(255) DEFAULT NULL,
  `supplier_phone1` varchar(12) DEFAULT NULL,
  `supplier_phone2` varchar(12) DEFAULT NULL,
  `supplier_phone3` varchar(12) DEFAULT NULL,
  `supplier_fax` varchar(12) DEFAULT NULL,
  `supplier_email` varchar(100) DEFAULT NULL,
  `supplier_web` varchar(100) DEFAULT NULL,
  `supplier_account` varchar(50) DEFAULT NULL,
  `supplier_branch` varchar(100) DEFAULT NULL,
  `supplier_add_user` int(11) NOT NULL,
  `supplier_add_date` date NOT NULL,
  `supplier_add_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `supplier_payment`
--

CREATE TABLE `supplier_payment` (
  `sp_id` int(11) NOT NULL,
  `sp_supplier_id` int(11) NOT NULL,
  `sp_pay_user` int(11) NOT NULL,
  `sp_payment_info` text NOT NULL,
  `sp_amount` float NOT NULL,
  `sp_add_date` date NOT NULL,
  `sp_add_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `supp_bill_list`
--

CREATE TABLE `supp_bill_list` (
  `supp_bill_id` int(11) NOT NULL,
  `supp_bill_system_id` varchar(20) NOT NULL,
  `supp_bill_product_id` varchar(50) NOT NULL,
  `supp_bill_badge_id` int(11) NOT NULL,
  `supp_bill_buy_price` float NOT NULL,
  `supp_bill_sale_price` float NOT NULL,
  `supp_bill_wholesale` float NOT NULL,
  `supp_bill_discount_price` float NOT NULL,
  `supp_bill_qty` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `unit_list`
--

CREATE TABLE `unit_list` (
  `unit_id` int(11) NOT NULL,
  `unit_text` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `unit_list`
--

INSERT INTO `unit_list` (`unit_id`, `unit_text`) VALUES
(1, 'Pcs');

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

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `user_id` int(11) NOT NULL,
  `user_username` varchar(100) NOT NULL,
  `user_password` varchar(255) NOT NULL,
  `user_fname` varchar(255) NOT NULL,
  `user_lname` varchar(255) NOT NULL,
  `user_type` int(11) NOT NULL,
  `user_reg_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` (`user_id`, `user_username`, `user_password`, `user_fname`, `user_lname`, `user_type`, `user_reg_time`) VALUES
(1, 'admin', '870528809d439efd7350cb7c660752d8', 'Malith', 'Madushan', 1, '2022-12-30 00:01:42'),
(2, 'user', '202cb962ac59075b964b07152d234b70', 'Admin', 'User', 1, '2022-12-30 00:01:42');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `barcode_print_details`
--
ALTER TABLE `barcode_print_details`
  ADD PRIMARY KEY (`bpd_id`);

--
-- Indexes for table `catogary_list`
--
ALTER TABLE `catogary_list`
  ADD PRIMARY KEY (`catogary_id`),
  ADD UNIQUE KEY `expenses_text` (`catogary_text`);

--
-- Indexes for table `customer_details`
--
ALTER TABLE `customer_details`
  ADD PRIMARY KEY (`cs_id`),
  ADD UNIQUE KEY `cs_mobile` (`cs_mobile`),
  ADD UNIQUE KEY `cs_pin` (`cs_pin`);

--
-- Indexes for table `expenses_category`
--
ALTER TABLE `expenses_category`
  ADD PRIMARY KEY (`expenses_id`),
  ADD UNIQUE KEY `expenses_text` (`expenses_text`);

--
-- Indexes for table `expenses_details`
--
ALTER TABLE `expenses_details`
  ADD PRIMARY KEY (`expenses_details_id`);

--
-- Indexes for table `hold_bill_details`
--
ALTER TABLE `hold_bill_details`
  ADD PRIMARY KEY (`hbd_id`),
  ADD UNIQUE KEY `hbd_temp_id` (`hbd_temp_id`);

--
-- Indexes for table `price_details`
--
ALTER TABLE `price_details`
  ADD PRIMARY KEY (`price_id`);

--
-- Indexes for table `product_affect_details`
--
ALTER TABLE `product_affect_details`
  ADD PRIMARY KEY (`pad_id`);

--
-- Indexes for table `product_details`
--
ALTER TABLE `product_details`
  ADD PRIMARY KEY (`product_id`),
  ADD UNIQUE KEY `product_barcode` (`product_barcode`),
  ADD UNIQUE KEY `product_systemid` (`product_systemid`);

--
-- Indexes for table `quotation_details`
--
ALTER TABLE `quotation_details`
  ADD PRIMARY KEY (`qd_id`),
  ADD UNIQUE KEY `qd_bill_id` (`qd_bill_id`);

--
-- Indexes for table `return_details`
--
ALTER TABLE `return_details`
  ADD PRIMARY KEY (`rd_id`);

--
-- Indexes for table `sale_details`
--
ALTER TABLE `sale_details`
  ADD PRIMARY KEY (`sale_details_id`),
  ADD UNIQUE KEY `sale_details_billid` (`sale_details_billid`);

--
-- Indexes for table `sale_list`
--
ALTER TABLE `sale_list`
  ADD PRIMARY KEY (`sale_id`);

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`setting_id`),
  ADD UNIQUE KEY `setting_text` (`setting_text`);

--
-- Indexes for table `start_balance_details`
--
ALTER TABLE `start_balance_details`
  ADD PRIMARY KEY (`Start_balance_id`);

--
-- Indexes for table `stock_count`
--
ALTER TABLE `stock_count`
  ADD PRIMARY KEY (`sc_id`);

--
-- Indexes for table `stock_count_list`
--
ALTER TABLE `stock_count_list`
  ADD PRIMARY KEY (`scl_id`);

--
-- Indexes for table `stock_details`
--
ALTER TABLE `stock_details`
  ADD PRIMARY KEY (`stock_id`);

--
-- Indexes for table `supplier_bill_details`
--
ALTER TABLE `supplier_bill_details`
  ADD PRIMARY KEY (`supplier_bill_details_id`),
  ADD UNIQUE KEY `supplier_bill_details_system_id` (`supplier_bill_details_system_id`);

--
-- Indexes for table `supplier_details`
--
ALTER TABLE `supplier_details`
  ADD PRIMARY KEY (`supplier_id`);

--
-- Indexes for table `supplier_payment`
--
ALTER TABLE `supplier_payment`
  ADD PRIMARY KEY (`sp_id`);

--
-- Indexes for table `supp_bill_list`
--
ALTER TABLE `supp_bill_list`
  ADD PRIMARY KEY (`supp_bill_id`);

--
-- Indexes for table `unit_list`
--
ALTER TABLE `unit_list`
  ADD PRIMARY KEY (`unit_id`),
  ADD UNIQUE KEY `expenses_text` (`unit_text`);

--
-- Indexes for table `user_details`
--
ALTER TABLE `user_details`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `user_username` (`user_username`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `barcode_print_details`
--
ALTER TABLE `barcode_print_details`
  MODIFY `bpd_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `customer_details`
--
ALTER TABLE `customer_details`
  MODIFY `cs_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses_category`
--
ALTER TABLE `expenses_category`
  MODIFY `expenses_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses_details`
--
ALTER TABLE `expenses_details`
  MODIFY `expenses_details_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hold_bill_details`
--
ALTER TABLE `hold_bill_details`
  MODIFY `hbd_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `price_details`
--
ALTER TABLE `price_details`
  MODIFY `price_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_affect_details`
--
ALTER TABLE `product_affect_details`
  MODIFY `pad_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_details`
--
ALTER TABLE `product_details`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotation_details`
--
ALTER TABLE `quotation_details`
  MODIFY `qd_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `return_details`
--
ALTER TABLE `return_details`
  MODIFY `rd_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sale_details`
--
ALTER TABLE `sale_details`
  MODIFY `sale_details_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sale_list`
--
ALTER TABLE `sale_list`
  MODIFY `sale_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `setting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `start_balance_details`
--
ALTER TABLE `start_balance_details`
  MODIFY `Start_balance_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_count`
--
ALTER TABLE `stock_count`
  MODIFY `sc_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_count_list`
--
ALTER TABLE `stock_count_list`
  MODIFY `scl_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_details`
--
ALTER TABLE `stock_details`
  MODIFY `stock_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_bill_details`
--
ALTER TABLE `supplier_bill_details`
  MODIFY `supplier_bill_details_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_details`
--
ALTER TABLE `supplier_details`
  MODIFY `supplier_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_payment`
--
ALTER TABLE `supplier_payment`
  MODIFY `sp_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supp_bill_list`
--
ALTER TABLE `supp_bill_list`
  MODIFY `supp_bill_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `user_details`
--
ALTER TABLE `user_details`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
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 */;
