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

START TRANSACTION;



--
-- Database: `renew_buddy`
--

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

--
-- Table structure for table `bills`
--

CREATE TABLE `bills` (
  `id` int(100) NOT NULL,
  `bill_name` varchar(100) NOT NULL,
  `expiry_date` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `createdOn` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bills`
--

INSERT INTO `bills` (`id`, `bill_name`, `expiry_date`, `amount`, `createdOn`) VALUES
(4, 'ytrs', '24-05-2025', '7654', '2025-05-22 07:10:52'),
(5, '', '29-05-2025', '1234', '2025-05-22 07:20:39'),
(6, '', '25-05-2025', '234567890', '2025-05-22 07:21:56'),
(7, 'qwe', '25-05-2025', '234567890', '2025-05-22 07:22:40'),
(8, 'qwe', '25-05-2025', '234567890', '2025-05-22 07:23:10'),
(9, 'qweawsedrfg', '25-05-2025', '234567890', '2025-05-22 07:23:15'),
(10, 'wifi', '28-05-2025', '500', '2025-05-22 07:23:46'),
(14, 'ac', '16-05-2025', '500', '2025-05-22 09:00:28');

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

--
-- Table structure for table `dashboard`
--

CREATE TABLE `dashboard` (
  `id` int(11) NOT NULL,
  `domain_name` varchar(100) NOT NULL,
  `expiry_date` varchar(50) NOT NULL,
  `type` varchar(100) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dashboard`
--

INSERT INTO `dashboard` (`id`, `domain_name`, `expiry_date`, `type`, `created_on`) VALUES
(9, 'sdf', '24-05-2025', 'office', '2025-05-21 06:53:58'),
(10, 'Nasrren', '01-05-2025', 'office', '2025-05-21 07:10:23'),
(13, 'ghjkl,', '07-05-2025', 'bank', '2025-05-21 09:48:14'),
(14, 'nasreen', '23-05-2025', 'bank', '2025-05-21 10:36:15'),
(15, 'arshaf', '08-05-2025', 'bank', '2025-05-21 10:38:02'),
(16, 'baby', '30-05-2025', 'bank', '2025-05-21 10:46:11'),
(18, 'fe', '01-05-2025', 'bank', '2025-05-22 09:23:22');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bills`
--
ALTER TABLE `bills`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

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

