--
-- Host: localhost    Database: CampaignTracker
-- ------------------------------------------------------


--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) NOT NULL,
  `campaign_id` varchar(50) NOT NULL,
  `related_database_name` varchar(50) NOT NULL,
  `company_name` varchar(100) NOT NULL,
  `company_address` text NOT NULL,
  `company_email` varchar(30) NOT NULL,
  `company_phoneno` varchar(30) NOT NULL,
  `date_of_registration` timestamp NOT NULL DEFAULT current_timestamp(),
  `date_of_modification` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `i_status` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` VALUES (1,2224,'BLENDEDINBOUND','ensembler','Ensembler','New Delhi','info@alliance-infotech.com','9878987878','2024-12-26 11:26:09','2025-01-03 08:52:23',1),(14,2225,'BLENDEDINBOUNDNEW','ensembler_2225','Evoipstore','GK,New Delhi','info@evoipstore.com','8933288222','2025-01-02 07:22:39','2025-01-03 08:52:32',1),(15,2226,'BAIDCAMP','ensembler_2226','Baid\'s Group','Noida, India','baid@gmail.com','9876776765','2025-01-03 09:12:47','2025-01-18 06:58:19',0),(16,2227,'SUDHASINGHCAMP','ensembler_2227','Sudha Singh Tour Consultant','Sarita Vihar New Delhi','sudhasingh@gmail.com','8287007554','2025-01-03 09:33:25','2025-01-03 10:02:33',0),(17,2228,'BLENDEDARADHYA','ensembler_2228','ARADHYA CONSULTANT','SARITA VIHAR OLD DELHI','aradhy2312@gmail.com','8767897867','2025-01-03 10:06:07','2025-01-06 12:09:29',0),(18,2229,'BLENDEDKEOSHA','ensembler_2229','Keosha Fabric','Shahpur jat ','keosha23@gmail.com','8756784567','2025-01-03 11:39:20','2025-01-06 12:09:29',0),(19,2230,'BLENDEDSCOT','ensembler_2230','Scot Technologies ','Nehru Place','scot123@gmail.com','9822367876','2025-01-03 14:08:47','2025-01-06 12:09:29',0),(20,2231,'BLENDEDMAPHIES','ensembler_2231','Maphies Technology','Greater Kailash','maphies@gmail.com','942364232342','2025-01-04 07:23:28','2025-01-06 12:09:29',0),(21,2232,'BLENDEDDEMO','ensembler_2232','Demo','Demo','demo','41411111124124124','2025-01-04 09:37:30','2025-01-04 09:40:05',0),(22,2233,'BLENDEDLENS','ensembler_2233','Lenskart','New Delhi','info@lenskart.com','9877898878','2025-01-06 11:22:58','2025-01-06 12:09:29',0),(23,2234,'BLENDEDINBOUND2233','ensembler_2234','Test','New Delhi','info@alliance-infote','8933288222','2025-01-06 12:06:13','2025-01-06 12:09:29',0),(24,1122,'BLENDEDNF','ensembler_1122','North Face','Noida, India','nf@gmail.com','9876543456','2025-01-06 12:10:26','2025-01-06 12:12:51',0),(25,1120,'BLENDEDINBOUNDNF','ensembler_1120','The North Face','Gurugram, Haryana','thenf@info.com','9787889876','2025-01-06 12:14:59','2025-01-06 12:18:37',0),(26,1121,'BLENDEDSUP','ensembler_1121','Supreme','GK,New Delhi','info@supereme.com','8933288277','2025-01-06 12:16:41','2025-01-06 12:18:37',0),(27,1126,'BLENDEDBAIDS','ensembler_1126','New Baid\'s Pvt Ltd','New Delhi','baidgrp@info.com','8786443212','2025-01-06 12:22:24','2025-01-08 18:15:27',0),(28,2239,'BLENDEDRUSSY','ensembler_2239','Russy Firm','GK','singhkewal954@gmail.com','928432842348','2025-02-19 06:09:16','2025-02-19 06:16:42',1),(29,2240,'BLENDEDNOISE','ensembler_2240','Noise','Pune','kavesh@gmail.com','923748243824','2025-02-19 06:20:35','2025-02-19 09:03:07',0);


