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

START TRANSACTION;



--
-- Database: `nexprism`
--

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `product` varchar(50) NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `qty` int(2) NOT NULL,
  `image` varchar(150) NOT NULL,
  `discount` int(2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `product`, `price`, `qty`, `image`, `discount`, `created_at`) VALUES
(5, 'Carrot', '49.00', 49, 'a4ea1af1d5dd29d2f594aced6805cb811685514302043.jpg', 10, '2023-05-31 07:00:06'),
(6, 'Cauliflower', '30.00', 10, '45234fa1627923aa813126d82b76d8141685516728211.jpg', 20, '2023-05-31 07:07:28'),
(7, 'Capcicum', '39.00', 1, '2597fc4c53c843f546b2fc26c1c4dff31685516922787.jpg', 40, '2023-05-31 07:08:42'),
(8, 'Potato', '20.00', 10, '128d94a1acdc2c9381bca2b60371626c1685516979705.jpg', 12, '2023-05-31 07:09:39'),
(10, 'Onien', '25.00', 1, '8bf702f195d254566bd01d01f533f8881685517038971.jpg', 19, '2023-05-31 07:10:38'),
(11, 'Mashroom', '85.00', 1, '240508b35481b7a9f61b2f4dcb8dd29a1685517104192.jpg', 25, '2023-05-31 07:11:44');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

