-- 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 */;