--
-- Host: localhost    Database: eatfish_db
-- ------------------------------------------------------

DELIMITER ;;;
DELIMITER ;

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `category_type` enum('fresh','tried fish','buy products') NOT NULL,
  `description` text,
  `file_url` varchar(255) DEFAULT NULL,
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Live Products','fresh',NULL,'/uploads/category/LiveProducts.jpeg',1,'2025-03-26 11:22:25','2025-04-02 09:46:27'),(2,'Value-Added Products','fresh',NULL,'/uploads/category/Value-Added Products.jpeg',1,'2025-03-26 11:22:52','2025-04-02 09:46:28'),(3,'Home Decor','fresh',NULL,'/uploads/category/HomeDecor.jpeg',1,'2025-03-31 07:31:56','2025-04-02 11:00:17'),(4,'Jewellery','fresh',NULL,'/uploads/category/Jewellery.jpeg',1,'2025-03-31 07:32:02','2025-04-02 11:00:18');

--
-- Table structure for table `city_master`
--

CREATE TABLE `city_master` (
  `city_id` int NOT NULL AUTO_INCREMENT,
  `city_name` varchar(255) NOT NULL,
  `district_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint DEFAULT '1',
  PRIMARY KEY (`city_id`),
  KEY `district_id` (`district_id`),
  CONSTRAINT `city_master_ibfk_1` FOREIGN KEY (`district_id`) REFERENCES `district_master` (`district_id`)
) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `city_master`
--

INSERT INTO `city_master` VALUES (1,'Ariyalur',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(2,'Udayarpalayam',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(3,'Jayankondam',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(4,'Andimadam',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(5,'Kunnam',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(6,'Sendurai',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(7,'Gangaikondan',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(8,'T. Palur',1,'2025-03-03 06:49:03','2025-03-03 06:49:03',1),(10,'Ambattur',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(11,'Adyar',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(12,'Alandur',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(13,'Anna Nagar',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(14,'Arumbakkam',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(15,'Ashok Nagar',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(16,'Besant Nagar',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(17,'Egmore',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(18,'Guindy',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(19,'Iyyappanthangal',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(20,'Kathipara',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(21,'Kodambakkam',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(22,'Kolathur',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(23,'Mambalam',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(24,'Manali',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(25,'Mylapore',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(26,'Nungambakkam',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(27,'Perambur',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(28,'Purasawalkam',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(29,'Royapettah',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(30,'Saidapet',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(31,'Sholinganallur',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(32,'T. Nagar',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(33,'Tambaram',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(34,'Thiruvanmiyur',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(35,'Tondiarpet',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(36,'Velachery',2,'2025-03-03 07:01:48','2025-03-03 07:01:48',1),(38,'Pollachi',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(39,'Mettupalayam',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(40,'Kinathukadavu',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(41,'Sulur',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(42,'Valparai',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(43,'Tiruppur',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(44,'Podanur',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(45,'Avinashi',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(46,'Sirumugai',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(47,'Perur',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(48,'Peelamedu',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(49,'Karamadai',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(50,'Thudiyalur',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(51,'Pappampatti',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(52,'Annur',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(53,'Kurichi',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(54,'Vadavalli',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(55,'Selvapuram',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(56,'Singanallur',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(57,'Lakshmi Mills Colony',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(58,'Gandhipuram',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(59,'R.S. Puram',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(60,'Sathyamangalam',3,'2025-03-03 07:04:24','2025-03-03 07:04:24',1),(61,'Parangipettai',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(62,'Chidambaram',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(63,'Neyveli',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(64,'Bhuvanagiri',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(65,'Vriddhachalam',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(66,'Kattumannarkoil',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(67,'Panruti',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(68,'Kurinjipadi',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(69,'Melpattampakkam',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(70,'Nellikuppam',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(71,'Alapakkam',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(72,'Vadalur',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(73,'Tittakudi',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(74,'Karungulam',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(75,'Chidambaram Town',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(76,'Cuddalore New Town',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(77,'Thirupadiripuliyur',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(78,'Sethiathope',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(79,'Villianur',4,'2025-03-03 07:06:13','2025-03-03 07:06:13',1),(80,'Srirangam',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(81,'Lalgudi',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(82,'Perambalur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(83,'Thuraiyur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(84,'Manachanallur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(85,'Tiruppur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(86,'Pudukkottai',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(87,'Karaikudi',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(88,'Kulithalai',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(89,'Senthalai',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(90,'Musiri',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(91,'Sathiyamangalam',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(92,'Kottur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(93,'Nathakadaiyur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(94,'Pudukkottai',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(95,'Viralimalai',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(96,'Tiruvanaikoil',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(97,'Ponnanayakanpatti',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(98,'Ariyalur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(99,'Alundur',26,'2025-03-03 07:07:44','2025-03-03 07:07:44',1),(100,'Nagercoil',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(101,'Palayamkottai',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(102,'Tenkasi',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(103,'Sankarankovil',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(104,'Vikramasingapuram',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(105,'Kallidaikurichi',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(106,'Rajapalayam',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(107,'Puliangudi',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(108,'Shenkottai',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(109,'Nazareth',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(110,'Surandai',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(111,'Aruvakurichi',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(112,'Keelapavoor',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(113,'Papanasam',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(114,'Melekallur',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(115,'Kuruvikulam',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(116,'Eral',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(117,'Kadayam',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(118,'Cheranmahadevi',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(119,'Kottar',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(120,'Muthulapuram',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(121,'Muthur',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(122,'Tiruvengadam',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(123,'Alangulam',27,'2025-03-03 07:08:59','2025-03-03 07:08:59',1),(124,'Harur',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(125,'Palacode',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(126,'Pappireddipatti',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(127,'Bhavani',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(128,'Tirupattur',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(129,'Berijam',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(130,'Mettur',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(131,'Sathyamangalam',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(132,'Nallampalli',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(133,'Kaveripattinam',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(134,'Vellalapalli',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(135,'Thoppur',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(136,'Peddampalli',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(137,'Agarakattu',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(138,'Kottaiyur',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(139,'Alapur',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(140,'Bommidi',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(141,'Veppanapalli',5,'2025-03-03 07:19:22','2025-03-03 07:19:22',1),(142,'Natham',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(143,'Vedasandur',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(144,'Panchampatti',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(145,'Athoor',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(146,'Kodaikanal',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(147,'Palani',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(148,'Batlagundu',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(149,'Chinnalapatti',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(150,'Gandhigram',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(151,'Kundumalar',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(152,'Vadamadurai',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(153,'Oddanchatram',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(154,'Kottampatti',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(155,'Idappadi',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(156,'Sembatti',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(157,'Bodinayakanur',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(158,'Sundarapandiam',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(159,'Muthupatti',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(160,'Kollam',6,'2025-03-03 07:21:30','2025-03-03 07:21:30',1),(161,'Tiruchendur',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(162,'Srivaikuntam',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(163,'Sathankulam',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(164,'Eral',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(165,'Kovilpatti',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(166,'Ottapidaram',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(167,'Vilathikulam',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(168,'Tirunelveli',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(169,'Pudur',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(170,'Alwarthirunagari',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(171,'Kadambur',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(172,'Azhikode',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(173,'Melapalayam',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(174,'Sankarankovil',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(175,'Uvari',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(176,'Kallikulam',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(177,'Pudukkottai',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(178,'Vallioor',25,'2025-03-03 09:09:33','2025-03-03 09:09:33',1),(179,'Perundurai',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(180,'Bhavani',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(181,'Modakurichi',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(182,'Tiruchengode',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(183,'Kodumudi',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(184,'Nambiyur',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(185,'Koduvai',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(186,'Sathyamangalam',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(187,'Chennimalai',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(188,'Kangayam',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(189,'Vellalapatti',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(190,'Pudupalayam',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(191,'Vellakovil',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(192,'Kunnathur',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(193,'Sivagiri',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(194,'Arachalur',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(195,'Jambai',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(196,'Cauvery',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(197,'Veppampalayam',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(198,'Elumathur',7,'2025-03-03 09:10:08','2025-03-03 09:10:08',1),(199,'Keela vaipaar',25,'2025-05-31 05:42:18','2025-05-31 05:42:18',1),(200,'Vembar',25,'2025-05-31 05:42:45','2025-05-31 05:42:45',1),(201,'Amalinagar',25,'2025-05-31 05:43:36','2025-05-31 05:43:36',1),(202,'Periyathaalai',25,'2025-05-31 05:43:36','2025-05-31 05:43:36',1),(203,'Manappadu',25,'2025-05-31 05:43:51','2025-05-31 05:43:51',1),(204,'Komputhurai',25,'2025-05-31 05:44:01','2025-05-31 05:44:01',1),(205,'Punnakayal',25,'2025-05-31 05:44:14','2025-05-31 05:44:14',1),(206,'Rameswaram',18,'2025-05-31 05:52:09','2025-05-31 05:52:09',1),(207,'Pamban',18,'2025-05-31 05:52:09','2025-05-31 05:52:09',1),(208,'Mandapam North',18,'2025-05-31 05:52:10','2025-05-31 05:52:10',1),(209,'Mandapam south',18,'2025-05-31 05:52:10','2025-05-31 05:52:10',1),(210,'Thangachimadam',18,'2025-05-31 06:44:38','2025-05-31 06:44:38',1);

--
-- Table structure for table `country_master`
--

CREATE TABLE `country_master` (
  `country_id` int NOT NULL AUTO_INCREMENT,
  `country_name` varchar(255) NOT NULL,
  `country_code` varchar(10) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint DEFAULT '1',
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `country_master`
--

INSERT INTO `country_master` VALUES (1,'India','IND','2025-02-25 09:38:47','2025-02-25 12:34:18',1);

--
-- Table structure for table `district_master`
--

CREATE TABLE `district_master` (
  `district_id` int NOT NULL AUTO_INCREMENT,
  `district_name` varchar(255) NOT NULL,
  `state_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint DEFAULT '1',
  PRIMARY KEY (`district_id`),
  KEY `state_id` (`state_id`),
  CONSTRAINT `district_master_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `state_master` (`state_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `district_master`
--

INSERT INTO `district_master` VALUES (1,'Ariyalur',1,'2025-03-03 06:25:20','2025-05-31 03:01:54',1),(2,'Chennai',1,'2025-03-03 06:25:20','2025-05-31 03:01:54',1),(3,'Coimbatore',1,'2025-03-03 06:25:20','2025-05-31 03:01:54',1),(4,'Cuddalore',1,'2025-03-03 06:25:20','2025-05-31 03:01:54',1),(5,'Dharmapuri',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(6,'Dindigul',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(7,'Erode',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(8,'Kanchipuram',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(9,'Kanyakumari',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(10,'Karur',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(11,'Krishnagiri',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(12,'Madurai',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(13,'Mayiladuthurai',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(14,'Nagapattinam',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(15,'Nilgiris',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(16,'Perambalur',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(17,'Pudukkottai',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(18,'Ramanathapuram',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(19,'Ranipet',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(20,'Salem',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(21,'Sivaganga',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(22,'Tenkasi',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(23,'Thanjavur',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(24,'Theni',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(25,'Thoothukudi',1,'2025-03-03 06:25:20','2025-03-04 17:03:48',1),(26,'Tiruchirappalli',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(27,'Tirunelveli',1,'2025-03-03 06:25:20','2025-05-31 03:01:55',1),(28,'Tirupattur',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(29,'Tiruppur',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(30,'Tiruvallur',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(31,'Tiruvannamalai',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(32,'Tiruvarur',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(33,'Vellore',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(34,'Viluppuram',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(35,'Virudhunagar',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(36,'Chengalpattu',1,'2025-03-03 06:25:20','2025-05-31 03:01:56',1),(37,'Kallakurichi',1,'2025-03-03 06:26:26','2025-05-31 03:01:56',1),(38,'Namakkal',1,'2025-03-03 06:28:16','2025-05-31 03:01:56',1);
DELIMITER ;;;
DELIMITER ;

--
-- Table structure for table `fisherman_sale_products`
--

CREATE TABLE `fisherman_sale_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `fisherman_id` int NOT NULL,
  `total_quantity` int NOT NULL,
  `available_quantity` int DEFAULT NULL,
  `price_per_kg` decimal(10,2) DEFAULT NULL,
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `fm_product_dec` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fisherman_sale_products`
--

INSERT INTO `fisherman_sale_products` VALUES (1,1,1,5454,5454,5488.00,0,'2025-05-22 13:22:54',NULL),(2,18,1,5889,5889,5588.00,1,'2025-05-22 13:28:14',NULL),(3,1,5,100,80,150.00,1,'2025-05-25 06:29:43',NULL),(4,1,123,50,50,200.00,1,'2025-05-25 06:31:09',NULL),(5,18,8,5,5,200.00,1,'2025-05-25 10:19:34',NULL),(6,19,8,10,10,100.00,1,'2025-05-25 10:20:25',NULL),(7,34,9,15,15,250.00,1,'2025-05-25 10:41:12',NULL),(8,18,9,250,250,255.00,1,'2025-05-25 10:42:49',NULL),(9,20,1,5588,5588,585.00,1,'2025-05-25 21:51:23',NULL),(10,1,1,100,50,50.00,1,'2025-05-26 06:38:52','test product'),(11,39,1,66,66,555.00,1,'2025-05-26 06:58:51','vvvvvvvvbb'),(12,1,1,100,50,50.00,1,'2025-05-26 07:02:29','test product'),(13,34,1,666,666,6669.00,1,'2025-05-26 07:12:11','fghhgjuggvvbb ghv'),(14,19,1,6454,6454,6499.00,1,'2025-05-26 07:22:14','babbhaa vvshasbs. hahsb. hshshahahs hshshaha. hssshshshs bshshshab hshhssh. hshshshsh.  hshshshshs. sbsb'),(15,34,8,10,10,100.00,1,'2025-05-26 10:00:24','Delicious, Tasty, '),(16,4,11,10,10,500.00,1,'2025-05-28 16:07:01','No description provided'),(17,6,30,5,5,1000.00,1,'2025-06-02 14:43:07','all over tamilnadu ');

--
-- Table structure for table `fishing_place`
--

CREATE TABLE `fishing_place` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fishing_place` varchar(255) NOT NULL,
  `district_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fishing_place`
--

INSERT INTO `fishing_place` VALUES (1,'Tharavaikulam',25,'2025-03-04 10:55:18','2025-03-04 10:55:18',1),(2,'Threspuram',25,'2025-03-04 10:55:29','2025-03-04 10:55:29',1),(3,'Tuticorin Harbour',25,'2025-03-04 10:55:40','2025-03-04 10:55:40',1),(4,'Inigo nagar',25,'2025-03-04 10:55:58','2025-03-04 10:55:58',1),(5,'Keela vaipaar',25,'2025-05-31 05:45:05','2025-05-31 05:45:05',1),(6,'Vembar',25,'2025-05-31 05:45:05','2025-05-31 05:45:05',1),(7,'Amalinagar',25,'2025-05-31 05:45:05','2025-05-31 05:45:05',1),(8,'Periyathaalai',25,'2025-05-31 05:45:20','2025-05-31 05:45:20',1),(9,'Manappadu',25,'2025-05-31 05:45:31','2025-05-31 05:45:31',1),(10,'Komputhurai',25,'2025-05-31 05:45:52','2025-05-31 05:45:52',1),(11,'Punnakayal',25,'2025-05-31 05:46:05','2025-05-31 05:46:05',1),(12,'Rameswaram',18,'2025-05-31 05:53:29','2025-05-31 05:53:29',1),(13,'Pamban',18,'2025-05-31 05:53:30','2025-05-31 05:53:30',1),(14,'Mandapam North',18,'2025-05-31 05:53:32','2025-05-31 05:53:32',1),(15,'Mandapam south',18,'2025-05-31 05:53:32','2025-05-31 05:53:32',1),(16,'Thangachimadam',18,'2025-05-31 06:44:59','2025-05-31 06:44:59',1);

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `payment_id` int NOT NULL AUTO_INCREMENT,
  `subscription_id` int NOT NULL,
  `user_id` int NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(100) NOT NULL,
  `payment_status` tinyint NOT NULL DEFAULT '0' COMMENT '0 = Pending, 1 = Paid, 2 = Failed',
  `transaction_id` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`payment_id`),
  KEY `subscription_id` (`subscription_id`),
  CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`subscription_id`) REFERENCES `subscription` (`subscription_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `pre_order_products`
--

CREATE TABLE `pre_order_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) NOT NULL,
  `product_tamil_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_id` int NOT NULL,
  `subcategory_id` int NOT NULL,
  `file_url` varchar(255) NOT NULL,
  `product_price` decimal(10,2) NOT NULL DEFAULT '400.00',
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pre_order_products`
--

INSERT INTO `pre_order_products` VALUES (1,'Red Crab','சிவப்பு நண்டு','நண்டுகள் மூளை வளர்ச்சிக்கு உதவுகின்றன, நரம்பு மண்டல செயல்பாட்டை மேம்படுத்துகின்றன, மேலும் வைட்டமின் ஏ சத்துக்கள் கண் பார்வையை மேம்படுத்துகின்றன',1,3,'/uploads/products/red_craps.jpeg',400.00,1,'2025-03-27 06:06:50','2025-04-24 12:41:25'),(2,'Sardines','பொடி மீன்/மத்தி','மத்தி மீன், ஒமேகா-3 கொழுப்பு அமிலங்களின் ஒரு சிறந்த மூலம், இது இதய ஆரோக்கியம், மூளை செயல்பாடு மற்றும் எலும்பு வலிமைக்கு பல நன்மைகளை வழங்குகிறது.',1,2,'/uploads/products/SARDINES.png',400.00,1,'2025-03-27 06:06:56','2025-04-02 07:39:07'),(3,'Mackerel','அயலா மீன்/கடல் சூரா','',1,2,'/uploads/products/MACKEREL.png',400.00,1,'2025-03-29 17:12:24','2025-04-02 09:53:25'),(4,'Trevally','கோறா மீன்','',1,2,'/uploads/products/Trevally.jpeg',400.00,1,'2025-03-29 17:13:32','2025-04-02 06:40:04'),(5,'Pink Perch','வான் மீன்','',1,2,'/uploads/products/PinkPerch.jpg',400.00,1,'2025-03-29 17:17:19','2025-04-02 06:40:18'),(6,'Seer Fish','வஞ்ஞிரம் மீன்','',1,2,'/uploads/products/SEER-FISH.png',400.00,1,'2025-03-29 17:18:47','2025-04-02 09:52:48'),(7,'Black Pomfret','கருத்த ஆவளி/கருப்பு வாவலி','',1,2,'/uploads/products/BlackPomfret.jpeg',400.00,1,'2025-03-29 17:18:47','2025-04-02 06:40:46'),(8,'White Pomfret','வெள்ளை ஆவளி/வெள்ளை வாவலி','',1,2,'/uploads/products/POMFRET.png',400.00,1,'2025-03-29 17:18:47','2025-04-02 09:52:14'),(9,'Barracuda','வரா மீன்','',1,2,'/uploads/products/BARRACUDA.png',400.00,1,'2025-03-29 17:21:20','2025-04-02 07:37:06'),(10,'Emperor','வேம்பாளி மீன்/கோழி மீன்','',1,2,'/uploads/products/Emperor.jpeg',400.00,1,'2025-03-29 17:21:20','2025-04-02 06:41:11'),(11,'Lady Fish','ஆசாரி மீன்','',1,2,'/uploads/products/LadyFish.jpeg',400.00,1,'2025-03-29 17:21:20','2025-04-02 06:41:22'),(12,'King Fish','வஞ்ஞிரம் மீன்/ஸீர் மீன்','',1,2,'/uploads/products/KING-FISH.png',400.00,1,'2025-03-29 17:21:20','2025-04-02 09:53:12'),(13,'Red Snapper','சங்கரா மீன்','',1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:22'),(14,'Mahi Mahiame','பர்லா மீன்','',1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:22'),(15,'Tuna','Soorai','',1,2,'/uploads/products/TUNA.png',400.00,1,'2025-03-31 07:18:15','2025-04-02 07:38:43'),(16,'Reef Cod','Kalava','',1,2,'/uploads/products/REED-COD.png',400.00,1,'2025-03-31 07:18:48','2025-04-02 07:37:29'),(17,'Tilapia','Jilapi','',1,2,'/uploads/products/TILAPIA.png',400.00,1,'2025-03-31 07:19:20','2025-04-02 07:38:55'),(18,'Tiger Prawns','டைகர் பிரான்ஸ்\n','',1,1,'/uploads/products/Tiger-Prawn.png',400.00,1,'2025-03-31 08:52:21','2025-04-02 10:42:05'),(19,'White Prawns','வெள்ளை இறால்கள்\n','',1,1,'/uploads/products/White-Prawn.png',400.00,1,'2025-03-31 08:52:21','2025-04-02 10:42:19'),(20,'Pink Prawns','பிங்க் பிரான்ஸ்\n','',1,1,'/uploads/products/Pink-Prawn.png',400.00,1,'2025-03-31 08:52:21','2025-04-02 10:42:27'),(21,'Vannamei Prawns','வன்னமி இறால்கள்\n','',1,1,'/uploads/products/Vannamei-Prawn.png',400.00,1,'2025-03-31 08:52:21','2025-04-02 10:42:37'),(22,'Scampi','Jinga','',1,1,'/uploads/products/Scampi.png',400.00,1,'2025-03-31 08:52:21','2025-04-02 10:42:48'),(23,'Blue Crab','Nandu','',1,3,'/uploads/products/Blue-crab.png',400.00,1,'2025-03-31 08:58:31','2025-04-02 07:29:15'),(24,'Mud Crab','Aattu Nandu','',1,3,'/uploads/products/Mud-crab.png',400.00,1,'2025-03-31 08:58:31','2025-04-02 07:30:03'),(25,'Soft Shell Crab','மெல்லிசை நண்டு','',1,3,'/uploads/products/Soft-shellcrab.png',400.00,1,'2025-03-31 08:58:31','2025-04-02 07:31:26'),(26,'Rock Lobster','சிங்கி இறால்','',1,3,'/uploads/products/Rock-Crab.png',400.00,1,'2025-03-31 08:58:31','2025-04-02 07:32:02'),(27,'Indian Lobster','சிங்கி இறால்','',1,3,'/uploads/products/IndianLobster.png',400.00,1,'2025-03-31 08:58:31','2025-04-02 07:32:19'),(28,'Oysters','Live and Shelled','',1,4,'/uploads/products/Rectangle-24434.png',400.00,1,'2025-03-31 09:08:49','2025-04-02 11:05:48'),(29,'Mussels','Kallumakai','',1,4,'/uploads/products/Mussels.png',400.00,1,'2025-03-31 09:08:49','2025-04-02 11:04:06'),(30,'Clams','Shell and Meat','',1,4,'/uploads/products/clams.png',400.00,1,'2025-03-31 09:08:49','2025-04-02 11:03:53'),(31,'Scallops','நெருஞ்சி','',1,4,'/uploads/products/Scallops.png',400.00,1,'2025-03-31 09:08:49','2025-04-02 11:03:54'),(32,'Squid','Kanava','',1,4,'/uploads/products/Squid.png',400.00,1,'2025-03-31 09:08:49','2025-04-02 11:03:56'),(33,'Cuttlefish','வெட்டுமீன்','',1,4,'/uploads/products/Cuttlefish.png',400.00,1,'2025-03-31 09:08:49','2025-04-02 11:03:20'),(34,'Dried Anchovies','Nethili Karuvadu','',2,5,'/uploads/products/DriedAnchovies.png',400.00,1,'2025-03-31 09:14:08','2025-04-02 11:38:22'),(35,'Dried Sardines','Mathi Karuvadu','',2,5,'/uploads/products/DriedSardines.png',400.00,1,'2025-03-31 09:14:08','2025-04-02 11:39:06'),(36,'Dried Prawns','இறால் கருவாடு','',2,5,'/uploads/products/DriedPrawn.png',400.00,1,'2025-03-31 09:14:08','2025-04-02 11:38:57'),(37,'Dried Mackerel','அயிலை மீன் கருவாடு','',2,5,'/uploads/products/DriedMackerel.png',400.00,1,'2025-03-31 09:14:08','2025-04-02 11:38:48'),(38,'Dried Tuna','Soorai Karuvadu','',2,5,'/uploads/products/Driedtuna.png',400.00,1,'2025-03-31 09:14:08','2025-04-02 11:39:26'),(39,'Dried Shark Meat','Sura Karuvadu','',2,5,'/uploads/products/DriedSharkMeat.png',400.00,1,'2025-03-31 09:14:08','2025-04-02 11:39:18'),(40,'Dried Bombil','Bombay Duck','',2,5,'/uploads/products/Driedbombil.png',400.00,1,'2025-03-31 09:14:08','2025-04-02 11:38:39'),(41,'Fish Pickle','மீன் ஊறுகாய்','',2,6,'/uploads/products/Fish-Pickle.png',400.00,1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(42,'Prawn Pickle','இறா ஊறுகாய்','',2,6,'/uploads/products/Prawn-Pickle.png',400.00,1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(43,'Crab Pickle','நண்டு ஊறுகாய்','',2,6,'/uploads/products/Crab-pickle.png',400.00,1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(44,'Fish Samosa','மீன் சமோசா','',2,6,'/uploads/products/Fish-Samosa.png',400.00,1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(45,'Fish Cutlets','மீன் கட்லெட்','',2,6,'/uploads/products/Fish-Cutlets.png',400.00,1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(46,'Fish Cakes','மீன் வடை','',2,6,'/uploads/products/Fish-Cakes.png',400.00,1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(47,'Crab Soup Powder','நண்டு சூப்','',2,6,'/uploads/products/Crab-soup-Powder.png',400.00,1,'2025-03-31 09:23:07','2025-04-02 12:43:15'),(48,'Dried Fish Powder','கருவாட்டுப் பொடி','',2,6,'/uploads/products/Dried-Fish-powder.png',400.00,1,'2025-03-31 09:23:07','2025-04-02 12:43:15'),(49,'Marinated Fish Fillets','மசாலா மீன் துண்டுகள்','',2,7,'/uploads/products/Marinated-Fish-Fillets.png',400.00,1,'2025-03-31 09:27:11','2025-04-02 11:57:29'),(50,'Marinated Prawns','ஊறவைத்த இறால்கள்','',2,7,'/uploads/products/marinated-Prawns.png',400.00,1,'2025-03-31 09:27:11','2025-04-02 11:57:30'),(51,'Marinated Squid Rings','மரினேட் செய்யப்பட்ட ஸ்க்விட் வளையங்கள்','',2,7,'/uploads/products/Marinated-Squid-Rings.png',400.00,1,'2025-03-31 09:27:11','2025-04-02 11:57:31'),(52,'Ready-to-Cook Fish Curry Mix','சமைக்கத் தயாராக உள்ள மீன் கறி கலவை','',2,7,'/uploads/products/Ready-to-cook-fish-curry-mix.png',400.00,1,'2025-03-31 09:27:11','2025-04-02 11:57:31'),(53,'Fish Fry Masala Mix','மீன் வறுவல் மசாலா கலவை','',2,7,'/uploads/products/Fishfrymasalamix.png',400.00,1,'2025-03-31 09:27:11','2025-04-02 11:57:32'),(54,'Frozen Crab Meat','உறைந்த நண்டு இறைச்சி','',2,7,'/uploads/products/FrozenCrabmeat.png',400.00,1,'2025-03-31 09:27:11','2025-04-02 11:57:32'),(55,'Frozen Lobster Tails','உறைந்த இரால் வால்கள்','',2,7,'/uploads/products/Frozenlobstertails.png',400.00,1,'2025-03-31 09:27:11','2025-04-02 11:57:33'),(56,'Shell Wind Chimes','','',3,8,'',400.00,1,'2025-04-02 10:27:37','2025-04-02 10:27:37'),(57,'Sea Shell Wall Hangings','','',3,8,'',400.00,1,'2025-04-02 10:27:56','2025-04-02 10:27:56'),(58,'Shell Mirrors','','',3,8,'',400.00,1,'2025-04-02 10:28:14','2025-04-02 10:28:14'),(59,'Shell Photo Frames','','',3,8,'',400.00,1,'2025-04-02 10:28:40','2025-04-02 10:28:40'),(60,'Shell Flower Vases','','',3,8,'',400.00,1,'2025-04-02 10:28:41','2025-04-02 10:28:41'),(61,'Driftwood Sculptures','','',3,9,'/uploads/products/Driftwood-Sculptures.png',400.00,1,'2025-04-02 10:30:16','2025-04-02 11:33:59'),(62,'Coral Centerpieces','','',3,9,'/uploads/products/Coral-centerpieces.png',400.00,1,'2025-04-02 10:30:17','2025-04-02 11:33:07'),(63,'Fish Bone Ornaments','','',3,9,'/uploads/products/Fishbone-Ornaments.png',400.00,1,'2025-04-02 10:30:18','2025-04-02 11:33:59'),(64,'Ocean Resin Art','','',3,9,'/uploads/products/Ocean-Resin-Art.png',400.00,1,'2025-04-02 10:30:19','2025-04-02 11:33:59'),(65,'Sea Glass Bottles & Lamps','','',3,9,'/uploads/products/Sea-glass-Bottles.png',400.00,1,'2025-04-02 10:30:20','2025-04-02 11:33:59'),(66,'Sea Glass Wall Art','','',3,10,'',400.00,1,'2025-04-02 10:32:46','2025-04-02 10:32:46'),(67,'Sea Glass Pendants','','',3,10,'',400.00,1,'2025-04-02 10:32:47','2025-04-02 10:32:47'),(68,'Sea Glass Candle Holders','','',3,10,'',400.00,1,'2025-04-02 10:32:47','2025-04-02 10:32:47'),(69,'Sea Glass Coasters','','',3,10,'',400.00,1,'2025-04-02 10:32:48','2025-04-02 10:32:48'),(70,'Chank Bangles','','',4,11,'',400.00,1,'2025-04-02 10:38:27','2025-04-02 10:38:27'),(71,'Chank Necklaces','','',4,11,'',400.00,1,'2025-04-02 10:38:28','2025-04-02 10:38:28'),(72,'Chank Earrings','','',4,11,'',400.00,1,'2025-04-02 10:38:29','2025-04-02 10:38:29'),(73,'Chank Pendants','','',4,11,'',400.00,1,'2025-04-02 10:38:30','2025-04-02 10:38:30'),(74,'Chank Bracelets','','',4,11,'',400.00,1,'2025-04-02 10:38:31','2025-04-02 10:38:31');

--
-- Table structure for table `pre_order_products_bk`
--

CREATE TABLE `pre_order_products_bk` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) NOT NULL,
  `product_tamil_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_id` int NOT NULL,
  `subcategory_id` int NOT NULL,
  `file_url` varchar(255) NOT NULL,
  `product_price` decimal(10,2) NOT NULL,
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pre_order_products_bk`
--

INSERT INTO `pre_order_products_bk` VALUES (2,'Red Crab','சிவப்பு நண்டு','நண்டுகள் மூளை வளர்ச்சிக்கு உதவுகின்றன, நரம்பு மண்டல செயல்பாட்டை மேம்படுத்துகின்றன, மேலும் வைட்டமின் ஏ சத்துக்கள் கண் பார்வையை மேம்படுத்துகின்றன',1,2,'',400.00,1,'2025-03-27 06:06:50','2025-04-02 12:52:37'),(3,'Sardines','பொடி மீன்/மத்தி','மத்தி மீன், ஒமேகா-3 கொழுப்பு அமிலங்களின் ஒரு சிறந்த மூலம், இது இதய ஆரோக்கியம், மூளை செயல்பாடு மற்றும் எலும்பு வலிமைக்கு பல நன்மைகளை வழங்குகிறது.',1,2,'',400.00,1,'2025-03-27 06:06:56','2025-03-31 07:17:49'),(4,'Mackerel','அயலா மீன்/கடல் சூரா',NULL,1,2,'',400.00,1,'2025-03-29 17:12:24','2025-03-31 08:52:21'),(5,'Trevally','கோறா மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:13:32','2025-03-29 17:13:32'),(6,'Pink Perch','வான் மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:17:19','2025-03-29 17:17:19'),(7,'Seer Fish','வஞ்ஞிரம் மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:18:47','2025-03-31 08:52:21'),(8,'Black Pomfret','கருத்த ஆவளி/கருப்பு வாவலி',NULL,1,2,'',400.00,1,'2025-03-29 17:18:47','2025-03-31 08:52:21'),(9,'White Pomfret','வெள்ளை ஆவளி/வெள்ளை வாவலி',NULL,1,2,'',400.00,1,'2025-03-29 17:18:47','2025-03-31 08:52:21'),(10,'Barracuda','வரா மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:21'),(11,'Emperor','வேம்பாளி மீன்/கோழி மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:21'),(12,'Lady Fish','ஆசாரி மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:21'),(13,'King Fish','வஞ்ஞிரம் மீன்/ஸீர் மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:22'),(14,'Red Snapper','சங்கரா மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:22'),(15,'Mahi Mahiame','பர்லா மீன்',NULL,1,2,'',400.00,1,'2025-03-29 17:21:20','2025-03-31 08:52:22'),(16,'Tuna','Soorai',NULL,1,2,'',400.00,1,'2025-03-31 07:18:15','2025-03-31 08:52:22'),(17,'Reef Cod','Kalava',NULL,1,2,'',400.00,1,'2025-03-31 07:18:48','2025-03-31 08:52:22'),(18,'Tilapia','Jilapi',NULL,1,2,'',400.00,1,'2025-03-31 07:19:20','2025-03-31 08:52:22'),(19,'Tiger Prawns','டைகர் பிரான்ஸ்\n',NULL,1,1,'',400.00,1,'2025-03-31 08:52:21','2025-03-31 08:56:38'),(20,'White Prawns','வெள்ளை இறால்கள்\n',NULL,1,1,'',400.00,1,'2025-03-31 08:52:21','2025-03-31 08:56:38'),(21,'Pink Prawns','பிங்க் பிரான்ஸ்\n',NULL,1,1,'',400.00,1,'2025-03-31 08:52:21','2025-03-31 08:56:38'),(22,'Vannamei Prawns','வன்னமி இறால்கள்\n',NULL,1,1,'',400.00,1,'2025-03-31 08:52:21','2025-03-31 08:56:38'),(23,'Scampi','Jinga',NULL,1,1,'',400.00,1,'2025-03-31 08:52:21','2025-03-31 08:52:58'),(24,'Blue Crab','Nandu',NULL,1,3,'',400.00,1,'2025-03-31 08:58:31','2025-03-31 08:59:36'),(25,'Mud Crab','Aattu Nandu',NULL,1,3,'',400.00,1,'2025-03-31 08:58:31','2025-03-31 08:59:36'),(26,'Soft Shell Crab','மெல்லிசை நண்டு',NULL,1,3,'',400.00,1,'2025-03-31 08:58:31','2025-03-31 08:59:36'),(27,'Rock Lobster','சிங்கி இறால்',NULL,1,3,'',400.00,1,'2025-03-31 08:58:31','2025-03-31 08:59:37'),(28,'Indian Lobster','சிங்கி இறால்',NULL,1,3,'',400.00,1,'2025-03-31 08:58:31','2025-03-31 08:59:37'),(29,'Oysters','Live and Shelled',NULL,1,4,'',450.00,1,'2025-03-31 09:08:49','2025-03-31 09:08:49'),(30,'Mussels','Kallumakai',NULL,1,4,'',400.00,1,'2025-03-31 09:08:49','2025-03-31 09:08:49'),(31,'Clams','Shell and Meat',NULL,1,4,'',500.00,1,'2025-03-31 09:08:49','2025-03-31 09:08:49'),(32,'Scallops','நெருஞ்சி',NULL,1,4,'',430.00,1,'2025-03-31 09:08:49','2025-03-31 09:08:49'),(33,'Squid','Kanava',NULL,1,4,'',430.00,1,'2025-03-31 09:08:49','2025-03-31 09:08:49'),(34,'Cuttlefish','வெட்டுமீன்',NULL,1,4,'',450.00,1,'2025-03-31 09:08:49','2025-03-31 09:08:49'),(35,'Dried Anchovies','Nethili Karuvadu',NULL,2,5,'',400.00,1,'2025-03-31 09:14:08','2025-03-31 09:14:08'),(36,'Dried Sardines','Mathi Karuvadu',NULL,2,5,'',350.00,1,'2025-03-31 09:14:08','2025-03-31 09:14:08'),(37,'Dried Prawns','இறால் கருவாடு',NULL,2,5,'',450.00,1,'2025-03-31 09:14:08','2025-03-31 09:14:52'),(38,'Dried Mackerel','அயிலை மீன் கருவாடு',NULL,2,5,'',400.00,1,'2025-03-31 09:14:08','2025-03-31 09:14:52'),(39,'Dried Tuna','Soorai Karuvadu',NULL,2,5,'',350.00,1,'2025-03-31 09:14:08','2025-03-31 09:14:08'),(40,'Dried Shark Meat','Sura Karuvadu',NULL,2,5,'',370.00,1,'2025-03-31 09:14:08','2025-03-31 09:14:08'),(41,'Dried Bombil','Bombay Duck',NULL,2,5,'',400.00,1,'2025-03-31 09:14:08','2025-03-31 09:14:08'),(42,'Fish Pickle','மீன் ஊறுகாய்',NULL,2,6,'',500.00,1,'2025-03-31 09:23:06','2025-03-31 09:23:06'),(43,'Prawn Pickle','இறா ஊறுகாய்',NULL,2,6,'',500.00,1,'2025-03-31 09:23:06','2025-03-31 09:23:06'),(44,'Crab Pickle','நண்டு ஊறுகாய்',NULL,2,6,'',500.00,1,'2025-03-31 09:23:06','2025-03-31 09:23:06'),(45,'Fish Samosa','மீன் சமோசா',NULL,2,6,'',450.00,1,'2025-03-31 09:23:06','2025-03-31 09:23:06'),(46,'Fish Cutlets','மீன் கட்லெட்',NULL,2,6,'',450.00,1,'2025-03-31 09:23:06','2025-03-31 09:23:06'),(47,'Fish Cakes','மீன் வடை',NULL,2,6,'',450.00,1,'2025-03-31 09:23:06','2025-03-31 09:23:06'),(48,'Crab Soup Powder','நண்டு சூப்',NULL,2,6,'',450.00,1,'2025-03-31 09:23:07','2025-03-31 09:23:07'),(49,'Dried Fish Powder','கருவாட்டுப் பொடி',NULL,2,6,'',350.00,1,'2025-03-31 09:23:07','2025-03-31 09:23:07'),(50,'Marinated Fish Fillets','மசாலா மீன் துண்டுகள்',NULL,2,7,'',250.00,1,'2025-03-31 09:27:11','2025-03-31 09:27:11'),(51,'Marinated Prawns','ஊறவைத்த இறால்கள்',NULL,2,7,'',250.00,1,'2025-03-31 09:27:11','2025-03-31 09:27:11'),(52,'Marinated Squid Rings','மரினேட் செய்யப்பட்ட ஸ்க்விட் வளையங்கள்',NULL,2,7,'',300.00,1,'2025-03-31 09:27:11','2025-03-31 09:27:11'),(53,'Ready-to-Cook Fish Curry Mix','சமைக்கத் தயாராக உள்ள மீன் கறி கலவை',NULL,2,7,'',250.00,1,'2025-03-31 09:27:11','2025-03-31 09:27:11'),(54,'Fish Fry Masala Mix','மீன் வறுவல் மசாலா கலவை',NULL,2,7,'',300.00,1,'2025-03-31 09:27:11','2025-03-31 09:27:11'),(55,'Frozen Crab Meat','உறைந்த நண்டு இறைச்சி',NULL,2,7,'',350.00,1,'2025-03-31 09:27:11','2025-03-31 09:27:11'),(56,'Frozen Lobster Tails','உறைந்த இரால் வால்கள்',NULL,2,7,'',320.00,1,'2025-03-31 09:27:11','2025-03-31 09:27:11');

--
-- Table structure for table `pre_orders`
--

CREATE TABLE `pre_orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_no` varchar(20) NOT NULL,
  `customer_id` int DEFAULT NULL,
  `product_id` varchar(255) NOT NULL,
  `quantity` int NOT NULL,
  `approx_price_per_kg` decimal(10,2) DEFAULT NULL,
  `total_price` decimal(10,2) DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `order_status` varchar(50) DEFAULT 'pending',
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pre_orders`
--

INSERT INTO `pre_orders` VALUES (1,'1',0,'1',1,400.00,400.00,'2025-05-26','cash','pending',1,'2025-05-25 13:17:39');
DELIMITER ;;;
DELIMITER ;

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) NOT NULL,
  `product_tamil_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_id` int NOT NULL,
  `subcategory_id` int NOT NULL,
  `file_url` varchar(255) DEFAULT NULL,
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'Red Crab','சிவப்பு நண்டு','நண்டுகள் மூளை வளர்ச்சிக்கு உதவுகின்றன, நரம்பு மண்டல செயல்பாட்டை மேம்படுத்துகின்றன, மேலும் வைட்டமின் ஏ சத்துக்கள் கண் பார்வையை மேம்படுத்துகின்றன',1,3,'/uploads/products/red_craps.jpeg',1,'2025-03-27 06:06:50','2025-04-24 12:41:02'),(2,'Sardines','பொடி மீன்/மத்தி','மத்தி மீன், ஒமேகா-3 கொழுப்பு அமிலங்களின் ஒரு சிறந்த மூலம், இது இதய ஆரோக்கியம், மூளை செயல்பாடு மற்றும் எலும்பு வலிமைக்கு பல நன்மைகளை வழங்குகிறது.',1,2,'/uploads/products/SARDINES.png',1,'2025-03-27 06:06:56','2025-04-02 07:39:07'),(3,'Mackerel','அயலா மீன்/கடல் சூரா',NULL,1,2,'/uploads/products/MACKEREL.png',1,'2025-03-29 17:12:24','2025-04-02 09:53:25'),(4,'Trevally','கோறா மீன்',NULL,1,2,'/uploads/products/Trevally.jpeg',1,'2025-03-29 17:13:32','2025-04-02 06:40:04'),(5,'Pink Perch','வான் மீன்',NULL,1,2,'/uploads/products/PinkPerch.jpg',1,'2025-03-29 17:17:19','2025-04-02 06:40:18'),(6,'Seer Fish','வஞ்ஞிரம் மீன்',NULL,1,2,'/uploads/products/SEER-FISH.png',1,'2025-03-29 17:18:47','2025-04-02 09:52:48'),(7,'Black Pomfret','கருத்த ஆவளி/கருப்பு வாவலி',NULL,1,2,'/uploads/products/BlackPomfret.jpeg',1,'2025-03-29 17:18:47','2025-04-02 06:40:46'),(8,'White Pomfret','வெள்ளை ஆவளி/வெள்ளை வாவலி',NULL,1,2,'/uploads/products/POMFRET.png',1,'2025-03-29 17:18:47','2025-04-02 09:52:14'),(9,'Barracuda','வரா மீன்',NULL,1,2,'/uploads/products/BARRACUDA.png',1,'2025-03-29 17:21:20','2025-04-02 07:37:06'),(10,'Emperor','வேம்பாளி மீன்/கோழி மீன்',NULL,1,2,'/uploads/products/Emperor.jpeg',1,'2025-03-29 17:21:20','2025-04-02 06:41:11'),(11,'Lady Fish','ஆசாரி மீன்',NULL,1,2,'/uploads/products/LadyFish.jpeg',1,'2025-03-29 17:21:20','2025-04-02 06:41:22'),(12,'King Fish','வஞ்ஞிரம் மீன்/ஸீர் மீன்',NULL,1,2,'/uploads/products/KING-FISH.png',1,'2025-03-29 17:21:20','2025-04-02 09:53:12'),(13,'Red Snapper','சங்கரா மீன்',NULL,1,2,NULL,1,'2025-03-29 17:21:20','2025-03-31 08:52:22'),(14,'Mahi Mahiame','பர்லா மீன்',NULL,1,2,NULL,1,'2025-03-29 17:21:20','2025-03-31 08:52:22'),(15,'Tuna','Soorai',NULL,1,2,'/uploads/products/TUNA.png',1,'2025-03-31 07:18:15','2025-04-02 07:38:43'),(16,'Reef Cod','Kalava',NULL,1,2,'/uploads/products/REED-COD.png',1,'2025-03-31 07:18:48','2025-04-02 07:37:29'),(17,'Tilapia','Jilapi',NULL,1,2,'/uploads/products/TILAPIA.png',1,'2025-03-31 07:19:20','2025-04-02 07:38:55'),(18,'Tiger Prawns','டைகர் பிரான்ஸ்\n',NULL,1,1,'/uploads/products/Tiger-Prawn.png',1,'2025-03-31 08:52:21','2025-04-02 10:42:05'),(19,'White Prawns','வெள்ளை இறால்கள்\n',NULL,1,1,'/uploads/products/White-Prawn.png',1,'2025-03-31 08:52:21','2025-04-02 10:42:19'),(20,'Pink Prawns','பிங்க் பிரான்ஸ்\n',NULL,1,1,'/uploads/products/Pink-Prawn.png',1,'2025-03-31 08:52:21','2025-04-02 10:42:27'),(21,'Vannamei Prawns','வன்னமி இறால்கள்\n',NULL,1,1,'/uploads/products/Vannamei-Prawn.png',1,'2025-03-31 08:52:21','2025-04-02 10:42:37'),(22,'Scampi','Jinga',NULL,1,1,'/uploads/products/Scampi.png',1,'2025-03-31 08:52:21','2025-04-02 10:42:48'),(23,'Blue Crab','Nandu',NULL,1,3,'/uploads/products/Blue-crab.png',1,'2025-03-31 08:58:31','2025-04-02 07:29:15'),(24,'Mud Crab','Aattu Nandu',NULL,1,3,'/uploads/products/Mud-crab.png',1,'2025-03-31 08:58:31','2025-04-02 07:30:03'),(25,'Soft Shell Crab','மெல்லிசை நண்டு',NULL,1,3,'/uploads/products/Soft-shellcrab.png',1,'2025-03-31 08:58:31','2025-04-02 07:31:26'),(26,'Rock Lobster','சிங்கி இறால்',NULL,1,3,'/uploads/products/Rock-Crab.png',1,'2025-03-31 08:58:31','2025-04-02 07:32:02'),(27,'Indian Lobster','சிங்கி இறால்',NULL,1,3,'/uploads/products/IndianLobster.png',1,'2025-03-31 08:58:31','2025-04-02 07:32:19'),(28,'Oysters','Live and Shelled',NULL,1,4,'/uploads/products/Rectangle-24434.png',1,'2025-03-31 09:08:49','2025-04-02 11:05:48'),(29,'Mussels','Kallumakai',NULL,1,4,'/uploads/products/Mussels.png',1,'2025-03-31 09:08:49','2025-04-02 11:04:06'),(30,'Clams','Shell and Meat',NULL,1,4,'/uploads/products/clams.png',1,'2025-03-31 09:08:49','2025-04-02 11:03:53'),(31,'Scallops','நெருஞ்சி',NULL,1,4,'/uploads/products/Scallops.png',1,'2025-03-31 09:08:49','2025-04-02 11:03:54'),(32,'Squid','Kanava',NULL,1,4,'/uploads/products/Squid.png',1,'2025-03-31 09:08:49','2025-04-02 11:03:56'),(33,'Cuttlefish','வெட்டுமீன்',NULL,1,4,'/uploads/products/Cuttlefish.png',1,'2025-03-31 09:08:49','2025-04-02 11:03:20'),(34,'Dried Anchovies','Nethili Karuvadu',NULL,2,5,'/uploads/products/DriedAnchovies.png',1,'2025-03-31 09:14:08','2025-04-02 11:38:22'),(35,'Dried Sardines','Mathi Karuvadu',NULL,2,5,'/uploads/products/DriedSardines.png',1,'2025-03-31 09:14:08','2025-04-02 11:39:06'),(36,'Dried Prawns','இறால் கருவாடு',NULL,2,5,'/uploads/products/DriedPrawn.png',1,'2025-03-31 09:14:08','2025-04-02 11:38:57'),(37,'Dried Mackerel','அயிலை மீன் கருவாடு',NULL,2,5,'/uploads/products/DriedMackerel.png',1,'2025-03-31 09:14:08','2025-04-02 11:38:48'),(38,'Dried Tuna','Soorai Karuvadu',NULL,2,5,'/uploads/products/Driedtuna.png',1,'2025-03-31 09:14:08','2025-04-02 11:39:26'),(39,'Dried Shark Meat','Sura Karuvadu',NULL,2,5,'/uploads/products/DriedSharkMeat.png',1,'2025-03-31 09:14:08','2025-04-02 11:39:18'),(40,'Dried Bombil','Bombay Duck',NULL,2,5,'/uploads/products/Driedbombil.png',1,'2025-03-31 09:14:08','2025-04-02 11:38:39'),(41,'Fish Pickle','மீன் ஊறுகாய்',NULL,2,6,'/uploads/products/Fish-Pickle.png',1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(42,'Prawn Pickle','இறா ஊறுகாய்',NULL,2,6,'/uploads/products/Prawn-Pickle.png',1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(43,'Crab Pickle','நண்டு ஊறுகாய்',NULL,2,6,'/uploads/products/Crab-pickle.png',1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(44,'Fish Samosa','மீன் சமோசா',NULL,2,6,'/uploads/products/Fish-Samosa.png',1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(45,'Fish Cutlets','மீன் கட்லெட்',NULL,2,6,'/uploads/products/Fish-Cutlets.png',1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(46,'Fish Cakes','மீன் வடை',NULL,2,6,'/uploads/products/Fish-Cakes.png',1,'2025-03-31 09:23:06','2025-04-02 12:43:14'),(47,'Crab Soup Powder','நண்டு சூப்',NULL,2,6,'/uploads/products/Crab-soup-Powder.png',1,'2025-03-31 09:23:07','2025-04-02 12:43:15'),(48,'Dried Fish Powder','கருவாட்டுப் பொடி',NULL,2,6,'/uploads/products/Dried-Fish-powder.png',1,'2025-03-31 09:23:07','2025-04-02 12:43:15'),(49,'Marinated Fish Fillets','மசாலா மீன் துண்டுகள்',NULL,2,7,'/uploads/products/Marinated-Fish-Fillets.png',1,'2025-03-31 09:27:11','2025-04-02 11:57:29'),(50,'Marinated Prawns','ஊறவைத்த இறால்கள்',NULL,2,7,'/uploads/products/marinated-Prawns.png',1,'2025-03-31 09:27:11','2025-04-02 11:57:30'),(51,'Marinated Squid Rings','மரினேட் செய்யப்பட்ட ஸ்க்விட் வளையங்கள்',NULL,2,7,'/uploads/products/Marinated-Squid-Rings.png',1,'2025-03-31 09:27:11','2025-04-02 11:57:31'),(52,'Ready-to-Cook Fish Curry Mix','சமைக்கத் தயாராக உள்ள மீன் கறி கலவை',NULL,2,7,'/uploads/products/Ready-to-cook-fish-curry-mix.png',1,'2025-03-31 09:27:11','2025-04-02 11:57:31'),(53,'Fish Fry Masala Mix','மீன் வறுவல் மசாலா கலவை',NULL,2,7,'/uploads/products/Fishfrymasalamix.png',1,'2025-03-31 09:27:11','2025-04-02 11:57:32'),(54,'Frozen Crab Meat','உறைந்த நண்டு இறைச்சி',NULL,2,7,'/uploads/products/FrozenCrabmeat.png',1,'2025-03-31 09:27:11','2025-04-02 11:57:32'),(55,'Frozen Lobster Tails','உறைந்த இரால் வால்கள்',NULL,2,7,'/uploads/products/Frozenlobstertails.png',1,'2025-03-31 09:27:11','2025-04-02 11:57:33'),(56,'Shell Wind Chimes',NULL,NULL,3,8,NULL,1,'2025-04-02 10:27:37','2025-04-02 10:27:37'),(57,'Sea Shell Wall Hangings',NULL,NULL,3,8,NULL,1,'2025-04-02 10:27:56','2025-04-02 10:27:56'),(58,'Shell Mirrors',NULL,NULL,3,8,NULL,1,'2025-04-02 10:28:14','2025-04-02 10:28:14'),(59,'Shell Photo Frames',NULL,NULL,3,8,NULL,1,'2025-04-02 10:28:40','2025-04-02 10:28:40'),(60,'Shell Flower Vases',NULL,NULL,3,8,NULL,1,'2025-04-02 10:28:41','2025-04-02 10:28:41'),(61,'Driftwood Sculptures',NULL,NULL,3,9,'/uploads/products/Driftwood-Sculptures.png',1,'2025-04-02 10:30:16','2025-04-02 11:33:59'),(62,'Coral Centerpieces',NULL,NULL,3,9,'/uploads/products/Coral-centerpieces.png',1,'2025-04-02 10:30:17','2025-04-02 11:33:07'),(63,'Fish Bone Ornaments',NULL,NULL,3,9,'/uploads/products/Fishbone-Ornaments.png',1,'2025-04-02 10:30:18','2025-04-02 11:33:59'),(64,'Ocean Resin Art',NULL,NULL,3,9,'/uploads/products/Ocean-Resin-Art.png',1,'2025-04-02 10:30:19','2025-04-02 11:33:59'),(65,'Sea Glass Bottles & Lamps',NULL,NULL,3,9,'/uploads/products/Sea-glass-Bottles.png',1,'2025-04-02 10:30:20','2025-04-02 11:33:59'),(66,'Sea Glass Wall Art',NULL,NULL,3,10,NULL,1,'2025-04-02 10:32:46','2025-04-02 10:32:46'),(67,'Sea Glass Pendants',NULL,NULL,3,10,NULL,1,'2025-04-02 10:32:47','2025-04-02 10:32:47'),(68,'Sea Glass Candle Holders',NULL,NULL,3,10,NULL,1,'2025-04-02 10:32:47','2025-04-02 10:32:47'),(69,'Sea Glass Coasters',NULL,NULL,3,10,NULL,1,'2025-04-02 10:32:48','2025-04-02 10:32:48'),(70,'Chank Bangles',NULL,NULL,4,11,NULL,1,'2025-04-02 10:38:27','2025-04-02 10:38:27'),(71,'Chank Necklaces',NULL,NULL,4,11,NULL,1,'2025-04-02 10:38:28','2025-04-02 10:38:28'),(72,'Chank Earrings',NULL,NULL,4,11,NULL,1,'2025-04-02 10:38:29','2025-04-02 10:38:29'),(73,'Chank Pendants',NULL,NULL,4,11,NULL,1,'2025-04-02 10:38:30','2025-04-02 10:38:30'),(74,'Chank Bracelets',NULL,NULL,4,11,NULL,1,'2025-04-02 10:38:31','2025-04-02 10:38:31');

--
-- Table structure for table `role_master`
--

CREATE TABLE `role_master` (
  `roleId` int NOT NULL AUTO_INCREMENT,
  `roleName` varchar(255) NOT NULL,
  `roleDescription` text,
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint DEFAULT '1',
  `type` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`roleId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `role_master`
--

INSERT INTO `role_master` VALUES (1,'Fisher Man','Responsible for catching and supplying fish to markets and restaurants','2025-02-26 05:07:44','2025-02-26 05:08:22',1,'app'),(2,'Assured Store','Handles inventory, order processing, and customer service for assured products','2025-02-26 05:07:44','2025-02-26 05:08:30',1,'app'),(3,'Merchant','Sells products on the platform, responsible for product listing and order fulfillment','2025-02-26 05:07:44','2025-02-26 05:08:30',1,'app'),(4,'Customer','End user who purchases products from merchants on the platform','2025-02-26 05:07:44','2025-04-01 09:44:47',1,'app');

--
-- Table structure for table `state_master`
--

CREATE TABLE `state_master` (
  `state_id` int NOT NULL AUTO_INCREMENT,
  `state_name` varchar(255) NOT NULL,
  `country_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint DEFAULT '1',
  PRIMARY KEY (`state_id`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `state_master_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `country_master` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `state_master`
--

INSERT INTO `state_master` VALUES (1,'Tamil Nadu',1,'2025-02-25 12:34:46','2025-02-26 05:19:24',1);

--
-- Table structure for table `subcategories`
--

CREATE TABLE `subcategories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL,
  `subcategory_name` varchar(255) NOT NULL,
  `description` text,
  `file_url` varchar(255) DEFAULT NULL,
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `subcategories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subcategories`
--

INSERT INTO `subcategories` VALUES (1,1,'Prawns & Shrimps','','/uploads/products/Tiger-Prawn.png',1,'2025-03-26 14:09:14','2025-04-02 10:42:58'),(2,1,'Fish','','/uploads/products/KingFish.jpg',1,'2025-03-26 14:09:59','2025-04-02 10:43:10'),(3,1,'Crabs & Lobsters','','/uploads/products/Blue-crab.png',1,'2025-03-26 14:10:43','2025-04-02 10:43:44'),(4,1,'Shellfish & Mollusks',NULL,'/uploads/products/Cuttlefish.png',1,'2025-03-31 07:30:12','2025-04-02 11:09:42'),(5,2,'Dry Fish Varieties',NULL,'/uploads/products/DriedSharkMeat.png',1,'2025-03-31 08:49:57','2025-04-02 11:37:29'),(6,2,'Ready-to-Eat Seafood',NULL,'/uploads/products/Fish-Cutlets.png',1,'2025-03-31 08:49:58','2025-04-02 12:43:29'),(7,2,'Frozen & Marinated Items',NULL,'/uploads/products/FrozenCrabmeat.png',1,'2025-03-31 08:50:20','2025-04-02 11:57:58'),(8,3,'Shell Art & Décor',NULL,'/uploads/products/Sea-glass-Bottles.png\n',1,'2025-04-02 10:10:53','2025-04-02 11:34:58'),(9,3,'Ocean-Inspired Crafts',NULL,NULL,1,'2025-04-02 10:11:20','2025-04-02 10:11:20'),(10,3,'Sea Glass Artworks',NULL,NULL,1,'2025-04-02 10:11:35','2025-04-02 10:11:35'),(11,4,'Chank Jewellery',NULL,NULL,1,'2025-04-02 10:11:59','2025-04-02 10:11:59'),(12,4,'Sea Shell Ornaments',NULL,NULL,1,'2025-04-02 10:25:17','2025-04-02 10:25:17'),(13,4,'Pearl & Coral Pieces',NULL,NULL,1,'2025-04-02 10:25:29','2025-04-02 10:25:29');

--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `subscription_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `plan_id` int NOT NULL,
  `start_date` varchar(10) NOT NULL,
  `end_date` varchar(10) NOT NULL,
  `status` tinyint DEFAULT '1' COMMENT '1 = Active, 0 = Inactive (canceled, expired)',
  `payment_status` tinyint DEFAULT '0' COMMENT '0 = Pending, 1 = Paid',
  `amount` decimal(10,2) NOT NULL,
  `payment_date` varchar(10) DEFAULT NULL,
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `userRole` int DEFAULT NULL,
  `payment_url` varchar(100) DEFAULT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `phone` varchar(100) NOT NULL,
  PRIMARY KEY (`subscription_id`),
  KEY `plan_id` (`plan_id`),
  CONSTRAINT `subscription_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `subscription_plans` (`plan_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription`
--

INSERT INTO `subscription` VALUES (1,1,1,'2025-04-01','2025-05-31',1,1,100.00,'2025-04-03','2025-04-03 10:44:22','2025-04-03 13:23:39',NULL,NULL,NULL,''),(2,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 06:13:31','2025-05-29 06:13:31',NULL,'',NULL,''),(3,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 06:17:19','2025-05-29 06:17:19',NULL,'',NULL,''),(4,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 06:21:05','2025-05-29 06:21:05',NULL,'/uploads/subscriptions/0df19bccb21c7c6d26a08a6a0981f0b8.jpg',NULL,''),(5,1,5,'2025-05-29','2026-04-29',1,1,100000.00,'2025-05-29','2025-05-29 07:55:12','2025-05-29 07:55:12',NULL,'/uploads/subscriptions/1000074799.jpg',NULL,''),(6,1,5,'2025-05-29','2026-04-29',1,1,100000.00,'2025-05-29','2025-05-29 08:04:02','2025-05-29 08:04:02',NULL,'/uploads/subscriptions/1000074799.jpg',NULL,''),(7,1,5,'2025-05-29','2026-04-29',1,1,100000.00,'2025-05-29','2025-05-29 08:06:04','2025-05-29 08:06:04',NULL,'/uploads/subscriptions/1000074799.jpg',NULL,''),(8,26,5,'2025-05-29','2026-04-29',1,1,100000.00,'2025-05-29','2025-05-29 09:03:58','2025-05-31 12:51:36',NULL,'/uploads/subscriptions/1000270099.jpg',NULL,'8148217352'),(9,26,5,'2025-05-29','2026-04-29',1,1,100000.00,'2025-05-29','2025-05-29 11:28:54','2025-05-29 11:28:54',NULL,'/uploads/subscriptions/1000270219.jpg',NULL,''),(10,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 11:30:22','2025-05-29 11:30:22',NULL,'/uploads/subscriptions/Screenshot from 2025-05-29 14-59-16.png',NULL,''),(11,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 12:10:49','2025-05-29 12:10:49',1,'/uploads/subscriptions/Screenshot from 2025-05-29 14-59-16.png',NULL,''),(12,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 13:15:53','2025-05-29 13:15:53',1,'/uploads/subscriptions/Screenshot from 2025-05-29 14-59-16.png',NULL,'8148217351'),(15,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 14:36:45','2025-05-29 14:36:45',1,'/uploads/subscriptions/Screenshot 2025-05-26 193444.png',NULL,'8148217351'),(19,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 14:52:05','2025-05-29 14:52:05',1,'/uploads/subscriptions/Screenshot 2025-05-26 193444.png',NULL,'8148217351'),(21,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 15:12:11','2025-05-29 15:12:11',1,'/uploads/subscriptions/scaled_1000074799.jpg',NULL,'8148217351'),(26,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 15:34:47','2025-05-29 15:34:47',1,'/uploads/subscriptions/Screenshot 2025-05-26 193444.png',NULL,'8148217351'),(27,2,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 15:35:03','2025-05-29 15:35:03',1,'/uploads/subscriptions/Screenshot 2025-05-26 193444.png',NULL,'8148217351'),(31,2,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 15:39:51','2025-05-29 15:39:51',1,'/uploads/subscriptions/Screenshot 2025-05-26 193444.png',NULL,'8148217'),(32,1,5,'2025-05-01','2025-12-31',1,1,12500.00,'2025-05-29','2025-05-29 15:41:01','2025-05-29 15:41:01',1,'/uploads/subscriptions/scaled_1000074805.jpg',NULL,'8148217351'),(37,2,5,'2025-05-29','2026-04-29',1,1,1000.00,'2025-05-29','2025-05-29 15:56:03','2025-05-29 15:56:03',1,'/uploads/subscriptions/scaled_1000074799.jpg',NULL,'1111111111'),(38,1,5,'2025-05-29','2026-04-29',1,1,1000.00,'2025-05-29','2025-05-29 16:04:30','2025-06-02 09:14:18',1,'/uploads/subscriptions/scaled_1000074805.jpg',NULL,'7488212629'),(39,1,5,'2025-05-29','2026-04-29',1,1,1000.00,'2025-05-29','2025-05-29 16:05:40','2025-06-02 09:14:20',1,'/uploads/subscriptions/scaled_1000074805.jpg',NULL,'7488212629'),(40,1,5,'2025-05-30','2026-04-30',1,1,1000.00,'2025-05-30','2025-05-30 09:11:56','2025-05-30 09:11:56',1,'/uploads/subscriptions/scaled_1000074812.jpg',NULL,'null'),(41,1,5,'2025-05-30','2026-04-30',1,1,1000.00,'2025-05-30','2025-05-30 11:46:00','2025-05-30 11:46:00',1,'/uploads/subscriptions/scaled_1000074812.jpg',NULL,'null'),(42,1,6,'2025-05-30','2025-06-29',1,1,1250.00,'2025-05-30','2025-05-30 11:47:16','2025-05-30 11:47:16',2,'/uploads/subscriptions/scaled_1000074812.jpg',NULL,''),(43,1,6,'2025-05-30','2025-06-29',1,1,1250.00,'2025-05-30','2025-05-30 11:47:16','2025-05-30 11:47:16',2,'/uploads/subscriptions/scaled_1000074812.jpg',NULL,''),(44,1,6,'2025-05-30','2025-06-29',1,1,1250.00,'2025-05-30','2025-05-30 11:47:17','2025-05-30 11:47:17',2,'/uploads/subscriptions/scaled_1000074812.jpg',NULL,''),(45,1,7,'2025-05-30','2025-06-29',1,1,1000.00,'2025-05-30','2025-05-30 12:44:41','2025-05-30 12:44:41',2,'/uploads/subscriptions/scaled_1000074805.jpg',NULL,''),(46,1,5,'2025-05-30','2026-04-30',1,1,1000.00,'2025-05-30','2025-05-30 12:45:27','2025-05-30 12:45:27',1,'/uploads/subscriptions/scaled_1000074805.jpg',NULL,'null'),(47,27,5,'2025-05-30','2026-04-30',1,1,1000.00,'2025-05-30','2025-05-30 15:09:01','2025-05-30 15:09:01',1,'/uploads/subscriptions/scaled_1000271074.jpg',NULL,'+919962157255'),(48,1,6,'2025-06-02','2025-07-02',1,1,1000.00,'2025-06-02','2025-06-02 08:54:15','2025-06-02 08:54:15',2,'/uploads/subscriptions/scaled_1000075553.jpg',NULL,''),(49,6,5,'2025-06-02','2026-05-03',1,1,1000.00,'2025-06-02','2025-06-02 08:55:03','2025-06-02 08:55:03',1,'/uploads/subscriptions/scaled_1000075553.jpg',NULL,'null'),(50,2,5,'2025-06-02','2026-05-03',1,1,1000.00,'2025-06-02','2025-06-02 11:29:13','2025-06-02 11:29:13',1,'/uploads/subscriptions/scaled_1000075562.jpg',NULL,'null'),(51,2,5,'2025-06-02','2026-05-03',1,1,1000.00,'2025-06-02','2025-06-02 11:29:56','2025-06-02 11:29:56',1,'/uploads/subscriptions/scaled_1000075572.jpg',NULL,'null'),(52,2,5,'2025-06-02','2026-05-03',1,1,1000.00,'2025-06-02','2025-06-02 11:30:06','2025-06-02 11:30:06',1,'/uploads/subscriptions/scaled_1000075572.jpg',NULL,'null'),(53,3,5,'2025-06-02','2026-05-03',1,1,1000.00,'2025-06-02','2025-06-02 12:22:40','2025-06-02 12:22:40',1,'/uploads/subscriptions/scaled_1000075579.jpg',NULL,'1111111111'),(54,2,7,'2025-06-02','2025-07-02',1,1,1000.00,'2025-06-02','2025-06-02 12:44:36','2025-06-02 12:44:36',2,'/uploads/subscriptions/scaled_1000075579.jpg',NULL,'9661708070'),(55,1,7,'2025-06-02','2025-07-02',1,1,1000.00,'2025-06-02','2025-06-02 12:59:07','2025-06-02 12:59:07',2,'/uploads/subscriptions/scaled_1000075579.jpg',NULL,'9661708070');

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `plan_id` int NOT NULL AUTO_INCREMENT,
  `plan_name` varchar(100) NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `description_data` text,
  `price` decimal(10,2) NOT NULL,
  `duration` int NOT NULL COMMENT 'Duration in days (e.g., 30, 60, 90)',
  `status` int DEFAULT '1',
  `plan_type` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`plan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription_plans`
--

INSERT INTO `subscription_plans` VALUES (1,'Starter Plan Up to 20 Kgs/Month','Ideal for small families,individual seafood lovers and occasional buyers',NULL,1000.00,335,1,'user'),(2,'Family Feast Up to 50 Kgs/Month','Ideal for large families,seafood enthusiasts and small restaurants',NULL,2500.00,335,1,'user'),(3,'Seafood Pro Up to 100 Kgs/Month','Ideal for Hotesl,caterers,seafood sellers and large-scale buyers',NULL,5000.00,335,1,'user'),(4,'Bulk Plus Above 100 Kgs/Month','Ideal for large-scale seafood traders,wholesalers and buy bulk buyers',NULL,10000.00,335,1,'user'),(5,'Catch & Earn Plan','List your catch daily. Connect with assured buyers and bulk orders instantly',NULL,1000.00,335,1,'fm'),(6,'Tidal Start ','Store Promotion,Store Visibility through Eatfish App,Eatfish Direct Supplies Cash & Carry,Connect with Other Fisherman\'s through Eatfish,Eatfish Customer Base ',NULL,1000.00,30,1,'store'),(7,'Eatfish Starter','Purchase Quantity,Avg Cost(500),Eatfish Suppliers(Fisherman),Coastal Regions Covered','500 kgs/Week,250000,6 Elite Suppliers,4 Coastal Regions',1000.00,30,1,'store'),(8,'Eatfish Growth Pack','Purchase Quantity,Avg Cost(500),Eatfish Suppliers(Fisherman),Coastal Regions Covered','1500 kgs/Week,3000000,15 Elite Suppliers,8 Coastal Regions',3000.00,30,1,'store');


