-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 26, 2025 at 06:38 AM
-- Server version: 8.0.37
-- PHP Version: 8.1.29

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: `mydevsystems_ritikretool`
--

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `company_id` int NOT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `address_line_1` varchar(255) DEFAULT NULL,
  `address_line_2` varchar(255) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `postcode` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'Pending',
  `approved_by` varchar(100) DEFAULT NULL,
  `approved_on` datetime DEFAULT NULL,
  `created_by` varchar(100) DEFAULT NULL,
  `created_on` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`company_id`, `company_name`, `address_line_1`, `address_line_2`, `city`, `state`, `country`, `postcode`, `phone`, `website`, `status`, `approved_by`, `approved_on`, `created_by`, `created_on`) VALUES
(99, 'Beta Innovations', '45 Beta Lane', NULL, 'Mumbai', 'Maharashtra', 'India', '400001', '9223456780', 'https://www.betainnovations.com', 'Pending', 'Supervisor', '2024-06-10 00:00:00', 'Meera', '2024-06-10 00:00:00'),
(100, 'CyberEdge Systems', '789 Cyber Blvd', '3rd Floor', 'Kolkata', 'West Bengal', 'India', '700019', '9345671234', 'https://www.cyberedge.com', 'Pending', 'CTO', '2024-02-15 00:00:00', 'Shyam', '2024-02-15 00:00:00'),
(101, 'Delta Solutions', '231 Delta Street', NULL, 'New Delhi', 'Delhi', 'India', '110001', '9988776655', 'https://www.deltasolutions.com', 'Active', 'Director', '2024-04-12 00:00:00', 'Anita', '2024-04-12 00:00:00'),
(102, 'Echo Networks', '105 Echo Plaza', 'Level 1', 'Gurgaon', 'Haryana', 'India', '122001', '9876543210', 'https://www.echonetworks.com', 'Pending', 'HR Head', '2024-05-25 00:00:00', 'Vikram', '2024-05-25 00:00:00'),
(103, 'Falcon Dynamics', '77 Falcon Drive', NULL, 'Ahmedabad', 'Gujarat', 'India', '380001', '9845671234', 'https://www.falcondynamics.com', 'Approved', 'CEO', '2024-06-05 00:00:00', 'Priya', '2024-06-05 00:00:00'),
(104, 'Gamma Corp', '50 Gamma Rd', 'Tower A', 'Jaipur', 'Rajasthan', 'India', '302001', '9754321089', 'https://www.gammacorp.com', 'Active', 'COO', '2024-07-19 00:00:00', 'Rajesh', '2024-07-19 00:00:00'),
(105, 'Horizon Enterprises', '19 Horizon Blvd', '4th Floor', 'Lucknow', 'Uttar Pradesh', 'India', '226001', '9123450987', 'https://www.horizon.com', 'Active', 'Supervisor', '2024-05-02 00:00:00', 'Kiran', '2024-05-02 00:00:00'),
(106, 'Infinity Tech', '32 Infinity Way', NULL, 'Chandigarh', 'Chandigarh', 'India', '160001', '9234567890', 'https://www.infinitytech.com', 'Approved', 'CTO', '2024-03-30 00:00:00', 'Vivek', '2024-03-30 00:00:00'),
(107, 'Jupiter Systems', '67 Jupiter Blvd', 'Ground Floor', 'Bhopal', 'Madhya Pradesh', 'India', '462001', '9998887776', 'https://www.jupitersystems.com', 'Active', 'Director', '2024-06-18 00:00:00', 'Radhika', '2024-06-18 00:00:00'),
(108, 'Krypton IT', '85 Krypton St', NULL, 'Nagpur', 'Maharashtra', 'India', '440001', '9776655443', 'https://www.kryptonit.com', 'Pending', 'CEO', '2024-02-20 00:00:00', 'Ankur', '2024-02-20 00:00:00'),
(109, 'Lunar Technologies', '44 Lunar Ave', 'Suite 500', 'Patna', 'Bihar', 'India', '800001', '9345670987', 'https://www.lunartech.com', 'Approved', 'Manager', '2024-04-22 00:00:00', 'Manish', '2024-04-22 00:00:00'),
(110, 'Nova Innovations', '210 Nova Lane', 'Floor 8', 'Thiruvananthapuram', 'Kerala', 'India', '695001', '9876543201', 'https://www.novainnovations.com', 'Pending', 'HR Head', '2024-05-10 00:00:00', 'Nisha', '2024-05-10 00:00:00'),
(111, 'Omega Enterprises', '87 Omega Rd', 'Golden', 'Indore', 'Madhya Pradesh', 'India', '452001', '9123409876', 'https://www.omega.com', 'Pending', 'Supervisor', '2024-07-11 00:00:00', 'Rakesh', '2024-07-11 00:00:00'),
(112, 'Pinnacle Solutions', '456 Pinnacle Blvd', 'Suite 2B', 'Coimbatore', 'Tamil Nadu', 'India', '641001', '9223412345', 'https://www.pinnaclesolutions.com', 'Pending', 'Director', '2024-06-22 00:00:00', 'Aarti', '2024-06-22 00:00:00'),
(113, 'Quantum Systems', '23 Quantum Rd', 'Level 9', 'Noida', 'Uttar Pradesh', 'India', '201301', '9345612345', 'https://www.quantumsystems.com', 'Approved', 'CEO', '2024-05-15 00:00:00', 'Sagar', '2024-05-15 00:00:00'),
(116, 'Vertex Solutions', '90 Vertex Way', 'Suite 300', 'Vishakhapatnam', 'Andhra Pradesh', 'India', '530001', '9234598765', 'https://www.vertexsolutions.com', 'Active', 'HR Head', '2024-05-30 00:00:00', 'Ritika', '2024-05-30 00:00:00'),
(118, 'Paresh Sirrrrr', 'Golden Next', 'MIra Road', 'Mumbai', 'Maharashtra', 'Option 1', '2345678', '3456789', 'retool.comm', 'Active', NULL, NULL, NULL, '2024-11-20 07:08:47');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `contact_id` int NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `designation` varchar(100) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'Pending',
  `approved_by` varchar(100) DEFAULT NULL,
  `approved_on` datetime DEFAULT NULL,
  `created_by` varchar(100) DEFAULT NULL,
  `created_on` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`contact_id`, `title`, `first_name`, `last_name`, `email`, `phone`, `designation`, `department`, `status`, `approved_by`, `approved_on`, `created_by`, `created_on`) VALUES
(18, 'Ms.', 'Deepa', 'Nair', 'deepa.nair@example.com', '9345678901', 'HR Manager', 'Human Resources', 'Pending', 'HR Head', '2024-05-15 00:00:00', 'Sneha', '2024-05-15 00:00:00'),
(19, 'Dr.', 'Rajeev', 'Verma', 'rajeev.verma@example.com', '9876543210', 'Research Scientist', 'Research', 'Approved', 'CTO', '2024-04-10 00:00:00', 'Priya', '2024-04-10 00:00:00'),
(20, 'Mrs.', 'Sonal', 'Shah', 'sonal.shah@example.com', '9123498765', 'Marketing Manager', 'Marketing', 'Active', 'CEO', '2024-06-01 00:00:00', 'Nikhil', '2024-06-01 00:00:00'),
(21, 'Mr.', 'Arjun', 'Reddy', 'arjun.reddy@example.com', '8887776665', 'Product Manager', 'Product', 'Approved', 'COO', '2024-03-20 00:00:00', 'Meera', '2024-03-20 00:00:00'),
(22, 'Ms.', 'Tanya', 'Khan', 'tanya.khan@example.com', '9223344556', 'Data Analyst', 'Data Science', 'Pending', 'Manager', '2024-04-22 00:00:00', 'Vikram', '2024-04-22 00:00:00'),
(23, 'Dr.', 'Neha', 'Kapoor', 'neha.kapoor@example.com', '9876601234', 'Lead Developer', 'Development', 'Active', 'CTO', '2024-05-05 00:00:00', 'Kiran', '2024-05-05 00:00:00'),
(24, 'Mr.', 'Rohit', 'Sharma', 'rohit.sharma@example.com', '9876547890', 'Operations Manager', 'Operations', 'Pending', 'Director', '2024-05-10 00:00:00', 'Nisha', '2024-05-10 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `company`
--
ALTER TABLE `company`
  ADD PRIMARY KEY (`company_id`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`contact_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `company`
--
ALTER TABLE `company`
  MODIFY `company_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `contact_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
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 */;
