-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 22, 2025 at 11:28 AM
-- 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: `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');

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `user_type` varchar(20) NOT NULL,
  `createdOn` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `name`, `mobile`, `password`, `user_type`, `createdOn`) VALUES
(1, 'Nasreen', '9360500657', 'ayaan@123', 'Admin', '2025-05-20 06:37:52'),
(2, 'TamilSelvan', '8098986868', 'Admin@123', 'Admin', '2025-05-20 06:39:04'),
(3, 'KesavKumar', '9842876308', 'Admin@123', 'User', '2025-05-20 06:39:59');

--
-- 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`);

--
-- Indexes for table `login`
--
ALTER TABLE `login`
  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;

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