...

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.22-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: robisear_ngatha
-- ------------------------------------------------------
-- Server version	10.6.22-MariaDB-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `announcement`
--

DROP TABLE IF EXISTS `announcement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `announcement` (
  `ann_id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` varchar(50) NOT NULL,
  `category` int(11) NOT NULL,
  `member` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ann_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `announcement`
--

LOCK TABLES `announcement` WRITE;
/*!40000 ALTER TABLE `announcement` DISABLE KEYS */;
/*!40000 ALTER TABLE `announcement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `awards`
--

DROP TABLE IF EXISTS `awards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `awards` (
  `award_id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) NOT NULL,
  `person_id` int(11) NOT NULL,
  `status` varchar(50) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`award_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `awards`
--

LOCK TABLES `awards` WRITE;
/*!40000 ALTER TABLE `awards` DISABLE KEYS */;
INSERT INTO `awards` VALUES (1,1,1,'Awarded','2019-02-14 18:46:49');
/*!40000 ALTER TABLE `awards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expense`
--

DROP TABLE IF EXISTS `expense`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense` (
  `expe_id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`expe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expense`
--

LOCK TABLES `expense` WRITE;
/*!40000 ALTER TABLE `expense` DISABLE KEYS */;
/*!40000 ALTER TABLE `expense` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `members`
--

DROP TABLE IF EXISTS `members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `members` (
  `member_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) NOT NULL,
  `middle_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `id_number` int(11) NOT NULL,
  `location` int(11) NOT NULL,
  `password` varchar(100) NOT NULL,
  `status` varchar(15) NOT NULL,
  `role` int(11) NOT NULL,
  `dor` date NOT NULL,
  PRIMARY KEY (`member_id`),
  UNIQUE KEY `id_number` (`id_number`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `members`
--

LOCK TABLES `members` WRITE;
/*!40000 ALTER TABLE `members` DISABLE KEYS */;
INSERT INTO `members` VALUES (1,'Leah','Wanjiru','Muchai','Female','wanjiruleah21@yahoo.com','+254724360875',24305020,47,'$2y$10$EBjg.7rAO6Cvd3XW8NSiUu.mev19hronTqZmbcwGWJPgEQnWdp2PS','Active',2,'2019-01-29'),(2,'Poleen','Waithira','Mwangi','Female','Waithirawahilary@gmail.com','+254720546369',11535736,47,'$2y$10$SlxX36Yh5RssMmLJOifZfuQ9eok70YsjdlOFAcPdC4XWxxGb42vpy','Active',2,'2019-02-13'),(3,'Lucy','Waithira','Wachu','Female','wachulucy@gmail.com','+254721440665',11317803,47,'$2y$10$7vjf5qBWRG4zshDsEoXsv./3/wRRbXiJeWbulHg6jklcltiwWc4em','Active',2,'2019-02-13'),(4,'Johnstone','Muchai','Muthanga','Male','muchastone@gmail.com','+254725330299',21052113,47,'$2y$10$Ft/RhOadndGbmynrv8dDdOkyj3RpZWUSKVKIzn0.xdQb2jm.f/wwi','Active',1,'2019-02-14'),(5,'Stellah','Murugi','Gatimu','Female','murugistellah@gmail.com','+254714673701',996422,34,'$2y$10$uprgh1qGbXafNOBHUBDwmuC7pZaPWHWIiY2Rm7leyJ2qvb8I6oCLu','Active',1,'2019-02-14'),(6,'Shem ','Kariuki','Muchai','Male','shemmito9@gmail.com','+254789054632',35466760,47,'$2y$10$/6NPJGk0jvlwpJPnAvA8ButQ.W9Gmo6cwIKcjYdTfbY2vWsmpiNTu','Active',1,'2019-02-14'),(7,'Diana ','Njeri','Murugi','Female','diananjeri@gmail.com','+254724421082',31593740,34,'$2y$10$n5/gvXrCJv2pDLcDck2eJuM8D9Co3G0t6089ILBKhQ/bEHk4YpdSS','Active',1,'2019-02-14'),(8,'Margaret','Mithiri','Orango','Female','companyjoek@gmail.com','+254700776935',23464433,47,'$2y$10$vapS9J8.orx.rNTs6iPA1ueY60zvVwohNdx2rWxPE7zEuY8lfuXDy','Active',1,'2019-02-16'),(9,'Miriam','Muthoni','Kariuki','Female','msonmiriam@gmail.com','+254723382568',24185192,22,'$2y$10$x/1LLwjacl9Zr1zzzF684.1/Uy1h.eY6jL2vSr3DyTLbRKEnSleyW','Active',1,'2019-02-17'),(10,'esther','nyokabi','wanja','Female','esthernyokabimwendia@gmail.com','+254711880001',23444420,22,'$2y$10$SludizOE1aNPiO.QEqWMCuwKLsj39ogqNzGZp3vYSODzFrM6Xq8Dy','Active',1,'2019-02-17'),(11,'Yvonne','Wachu','Kanyotu','Female','wachyvonne@gmail.com','+254746257474',35646272,22,'$2y$10$K7npokCFYPXfMhTimYE5mOHNeZgQdXeI.EevmWhS6S2MVXmt7Hpla','Active',1,'2019-02-25'),(12,'Catherine','','Mugo','Female','cathymugo1@gmail.com','+254722649308',4669513,22,'$2y$10$RxNgQz.klJu/RNiWKaOH9.xJHfekVHfQ39/82nNetE/y7IGWVIgFG','Active',1,'2019-02-25'),(13,'Hannah','Wachu','Mbote','Female','','+254720174105',4914685,22,'$2y$10$qlEpwSVGTvA6Wk4aC/SXCe10YLOEWJ0xdLS16XKz21ShTAweegsme','Active',1,'2019-02-25'),(14,'Antony','Muchoki','Magenda','Male','antony.magenda@gmail.com','+254716724853',28780263,22,'$2y$10$mQWZWhc9fGtCTzRlzZu/eOyLwegglu7eUvpLA4w0B9EI/N8YOS.fu','Active',1,'2019-02-25'),(15,'Loise ','Njeri','Mbugua','Female','mbugualoise@gmail.com','+254720588807',24809432,22,'$2y$10$D9T3XDaWUJ2gFvyX7AeFAu7JNAZXPY3hFK6KcED6qyZf7lUPU0K9.','Active',1,'2019-02-27'),(16,'Caroline','Nyokabi','Mwaniki','Female','carolynemwaniki575@gmail.com','+254722982424',22532398,22,'$2y$10$HuH2R3H64BjlDxuv6oM29OZOXyqdZSuLZaEHWZPR4Gk1rjDMyIdXe','Active',1,'2019-02-27'),(17,'Joseph ','Maina','Ikiro','Male','','+254702824557',22516286,22,'$2y$10$Jwp9kbAoVlWllyEn/gSj6u7/.7DTHl74uTzk5fWzw4mboDjNhxoZW','Active',1,'2019-02-27'),(18,'Francis','Kamau','Kaigo','Male','','+254740125405',30488159,22,'$2y$10$K1qVRqcanEOMQtLioHSuZ.TtfVuwVVlnn3nvnsU0m9nEN2zOon3li','Active',1,'2019-02-27'),(19,'Mary','waithira','Irungu','Female','Kimedy 20001@yahoo.com','0729708345',0,0,'$2y$10$1jdmzXTOvEYC09qbnjLpCOurxbg7dTKZ/PXOz59MaPdsDMqTFWXi.','Inactive',1,'2019-03-09'),(20,'Peris ','wairimu','miriti','~~Select Gender~~','wamercywanelly@gmail.com','+254722697504',9589934,47,'$2y$10$ndWxCE0BASbuX.Fk14HlWOdkNSeepyJNvpBB96ykz0Bs1qUr2Unna','Inactive',1,'2019-03-11'),(21,'Dorcas','Njoki','Guchini','Female','','0720236384',22524600,22,'$2y$10$E9RxTE.rSIF97MdOuCxnLerRXXwHfcJN/zEqOoVhQq3xXcjytztP6','Inactive',1,'2019-03-12'),(22,'Redrick','Munyao','Muia','Male','redrickmunyao865@gmail.com','+254798770510',36500258,47,'$2y$10$if9WQvUPa5dc3lFpO5VQZem9dwhy8eMhnN8eFpqCdv/V870sVORZe','Inactive',1,'2019-03-13'),(23,'Jackline ','Karimi','Gituma','Female','jacklinegituma@gmail.com','0726675021',23208138,22,'$2y$10$sNw57fbDXpbF13gH5QeYWucOolVKMlM5VlRfL5aSnqiw5W7Qk79..','Inactive',1,'2019-03-13'),(24,'Caroline','Wairimu','Mwangi','Female','cmwangi@sisipharmaciuticals.co.ke','0725211044',22091520,22,'$2y$10$zaHnhjKAtYkv4nszkXiHDOBZVmP/HHaNud7.0Oo2oa5cpjO7MebF6','Active',1,'2019-03-14'),(25,'Nelly','Njeri','Njuguna','Male','','+254700618378',103921181,22,'$2y$10$xKsdPDaViQwIlnSi9iRzeexp7iW8nA8Lz/xHiS45P2GrnN/5/JOUy','Active',1,'2019-03-20'),(26,'Emanuel','Parsimei','Nkoitiko','Male','','0720981529',23305000,22,'$2y$10$bTFn.XwBz3SLm9q9HqHMZeDO6etG2WNUxH1w1JHBAXYdqI5RZ//DK','Active',0,'2019-04-01'),(27,'Mary','Wangari','Mbagiru','Female','','+254722464494',26201522,21,'$2y$10$52/PS84.kVQqxV.fXXqfluP5TpKGeykxcx.O8hQBP5hrL3FLsaBwW','Inactive',1,'2019-05-10');
/*!40000 ALTER TABLE `members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `next_of_kin`
--

DROP TABLE IF EXISTS `next_of_kin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `next_of_kin` (
  `kin_id` int(11) NOT NULL AUTO_INCREMENT,
  `member` int(11) NOT NULL,
  `full_name` varchar(50) NOT NULL,
  `kin_email` varchar(50) NOT NULL,
  `kin_phone` varchar(50) NOT NULL,
  `kin_id_number` int(11) NOT NULL,
  `relationship` varchar(50) NOT NULL,
  `kin_created_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`kin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `next_of_kin`
--

LOCK TABLES `next_of_kin` WRITE;
/*!40000 ALTER TABLE `next_of_kin` DISABLE KEYS */;
INSERT INTO `next_of_kin` VALUES (1,1,'Johnstone Muchai','','0723330299',24305020,'Husband','2019-02-14 15:27:38'),(2,1,'Stellah Murugi','','0714673710',0,'Mother','2019-02-14 15:28:55');
/*!40000 ALTER TABLE `next_of_kin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `packages`
--

DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `packages` (
  `package_id` int(11) NOT NULL AUTO_INCREMENT,
  `package_name` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `packages`
--

LOCK TABLES `packages` WRITE;
/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
INSERT INTO `packages` VALUES (1,'KARIBU PACKAGE','2200','2019-02-10 17:38:34'),(2,'JAMII PACKAGE','7200','2019-02-10 17:38:34'),(3,'BIASHARA PACKAGE','85000','2019-02-10 17:38:34'),(4,'AFYA PACKAGE','207000','2019-02-10 17:38:34'),(5,'UFALME PACKAGE','1800000','2019-02-10 17:38:34'),(6,'TABLE BANKING','','2019-02-10 17:38:34');
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment`
--

DROP TABLE IF EXISTS `payment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment` (
  `payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `paid_by` int(11) NOT NULL,
  `moth` varchar(10) NOT NULL,
  `year` int(11) NOT NULL,
  `pay_mode` varchar(15) NOT NULL,
  `amount` varchar(15) NOT NULL,
  `transaction_code` varchar(50) NOT NULL,
  `pay_status` varchar(15) NOT NULL,
  `payment_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`payment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment`
--

LOCK TABLES `payment` WRITE;
/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
INSERT INTO `payment` VALUES (1,1,'Feb',2019,'CASH','750','','Approved','2019-02-08 10:19:59'),(2,2,'Feb',2019,'CASH','750','','Approved','2019-02-13 09:03:26'),(3,3,'Feb',2019,'CASH','750','','Approved','2019-02-13 09:28:39'),(4,4,'Feb',2019,'CASH','750','','Approved','2019-02-14 14:11:01'),(5,5,'Feb',2019,'CASH','750','','Approved','2019-02-14 14:25:00'),(6,6,'Feb',2019,'CASH','750','','Approved','2019-02-14 14:30:19'),(7,7,'Feb',2019,'CASH','750','','Approved','2019-02-14 14:36:39'),(8,8,'Feb',2019,'CASH','750','','Approved','2019-02-16 13:05:35'),(9,9,'Feb',2019,'CASH','750','','Approved','2019-02-17 15:37:02'),(10,10,'Feb',2019,'CASH','750','','Approved','2019-02-17 17:54:34'),(11,11,'Feb',2019,'CASH','750','','Approved','2019-02-25 14:05:46'),(12,12,'Feb',2019,'CASH','750','','Approved','2019-02-25 14:12:08'),(13,13,'Feb',2019,'CASH','750','','Approved','2019-02-25 14:19:15'),(14,14,'Feb',2019,'CASH','750','','Approved','2019-02-25 14:54:54'),(15,15,'Feb',2019,'CASH','750','','Approved','2019-02-27 10:07:43'),(16,16,'Feb',2019,'MPESA','750','NBQ252FM00','Approved','2019-02-27 10:12:18'),(17,17,'Feb',2019,'CASH','750','','Approved','2019-02-27 10:23:33'),(18,18,'Feb',2019,'CASH','750','','Approved','2019-02-27 20:40:41'),(19,24,'Mar',2019,'CASH','750','','Approved','2019-03-14 15:45:26'),(20,25,'Mar',2019,'MPESA','750','NC18LLNHHY','Approved','2019-03-20 10:17:58'),(21,26,'Apr',2019,'MPESA','','','Approved','2019-04-01 22:57:37');
/*!40000 ALTER TABLE `payment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `referrals`
--

DROP TABLE IF EXISTS `referrals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `referrals` (
  `ref_id` int(11) NOT NULL AUTO_INCREMENT,
  `referred_person` int(11) NOT NULL,
  `referred_by` int(11) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ref_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `referrals`
--

LOCK TABLES `referrals` WRITE;
/*!40000 ALTER TABLE `referrals` DISABLE KEYS */;
INSERT INTO `referrals` VALUES (1,1,0,'2019-02-08 10:22:04'),(2,2,1,'2019-02-13 09:03:26'),(3,3,1,'2019-02-13 09:28:38'),(4,4,1,'2019-02-14 14:11:01'),(5,5,1,'2019-02-14 14:25:00'),(6,6,1,'2019-02-14 14:30:19'),(7,7,2,'2019-02-14 14:36:39'),(8,8,2,'2019-02-16 13:05:34'),(9,9,3,'2019-02-17 15:37:02'),(10,10,3,'2019-02-17 17:54:34'),(11,11,3,'2019-02-25 14:05:46'),(12,12,3,'2019-02-25 14:12:08'),(13,13,3,'2019-02-25 14:19:15'),(14,14,3,'2019-02-25 14:54:54'),(15,15,11,'2019-02-27 10:07:43'),(16,16,11,'2019-02-27 10:12:17'),(17,17,11,'2019-02-27 10:23:32'),(18,18,11,'2019-02-27 20:40:41'),(19,24,2,'2019-03-14 15:45:26'),(20,25,11,'2019-03-20 10:17:57'),(21,26,13,'2019-04-01 22:57:37');
/*!40000 ALTER TABLE `referrals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_county`
--

DROP TABLE IF EXISTS `tbl_county`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_county` (
  `county_id` int(11) NOT NULL AUTO_INCREMENT,
  `county_name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`county_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_county`
--

LOCK TABLES `tbl_county` WRITE;
/*!40000 ALTER TABLE `tbl_county` DISABLE KEYS */;
INSERT INTO `tbl_county` VALUES (1,'Mombasa'),(2,'Kwale'),(3,'Kilifi'),(4,'Tana River'),(5,'Lamu'),(6,'Taita-Taveta'),(7,'Garissa'),(8,'wajir'),(9,'Mandera'),(10,'Marsabit'),(11,'Isiolo'),(12,'Meru'),(13,'Tharaka-Nithi'),(14,'Embu'),(15,'Kitui'),(16,'Machakos'),(17,'Makueni'),(18,'Nyandarua'),(19,'Nyeri'),(20,'Kirinyaga'),(21,'Murang\'a'),(22,'Kiambu'),(23,'Turkana'),(24,'West Pokot'),(25,'Samburu'),(26,'Trans Nzoia'),(27,'Uasin Gishu'),(28,'Elgeyo-Marakwet'),(29,'Nandi'),(30,'Baringo'),(31,'Laikipia'),(32,'Nakuru'),(33,'Narok'),(34,'Kajiado'),(35,'Kericho'),(36,'Bomet'),(37,'Kakamega'),(38,'Vihiga'),(39,'Bungoma'),(40,'Busia'),(41,'Siaya'),(42,'Kisumu'),(43,'Homa Bay'),(44,'Migori'),(45,'Kisii'),(46,'Nyamira'),(47,'Nairobi City');
/*!40000 ALTER TABLE `tbl_county` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_comments`
--

DROP TABLE IF EXISTS `user_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_comments` (
  `com_id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`com_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_comments`
--

LOCK TABLES `user_comments` WRITE;
/*!40000 ALTER TABLE `user_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_comments` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-06-30 18:31:16