Da

✏️ Editing: caprecvd_bhr.sql

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

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

--
-- Current Database: `caprecvd_bhr`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `caprecvd_bhr` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `caprecvd_bhr`;

--
-- Table structure for table `RiskScore`
--

DROP TABLE IF EXISTS `RiskScore`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `RiskScore` (
  `RiskScoreID` int(4) NOT NULL AUTO_INCREMENT,
  `ID` varchar(50) NOT NULL,
  `Age` int(4) NOT NULL,
  `Gender` int(4) NOT NULL,
  `Smoking` int(4) NOT NULL,
  `SystolicBloodPressure` int(4) NOT NULL,
  `TotalCholesterol` int(4) NOT NULL,
  `ElevatedBloodLipids` tinyint(1) NOT NULL DEFAULT 0,
  `HeartAttackStroke` tinyint(1) NOT NULL DEFAULT 0,
  `HDL` tinyint(1) NOT NULL DEFAULT 0,
  `Triglyceride` tinyint(1) NOT NULL DEFAULT 0,
  `HbA1C` tinyint(1) NOT NULL DEFAULT 0,
  `TestResultDate` datetime NOT NULL,
  `RiskScoreValueID` int(4) NOT NULL,
  `CreateDate` datetime NOT NULL DEFAULT current_timestamp(),
  `CreateBy` int(4) NOT NULL,
  `UpdateDate` datetime DEFAULT NULL,
  `UpdateBy` int(4) DEFAULT NULL,
  PRIMARY KEY (`RiskScoreID`),
  KEY `CreateBy` (`CreateBy`),
  KEY `UpdateBy` (`UpdateBy`),
  KEY `Ndx_ID_TestResultDate` (`ID`,`TestResultDate`),
  KEY `Ndx_TestResultDate` (`TestResultDate`),
  CONSTRAINT `RiskScore_ibfk_1` FOREIGN KEY (`CreateBy`) REFERENCES `User` (`UserID`),
  CONSTRAINT `RiskScore_ibfk_2` FOREIGN KEY (`UpdateBy`) REFERENCES `User` (`UserID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `RiskScore`
--

LOCK TABLES `RiskScore` WRITE;
/*!40000 ALTER TABLE `RiskScore` DISABLE KEYS */;
INSERT INTO `RiskScore` VALUES (1,'1001',55,3,6,120,100,1,1,1,1,1,'2018-11-09 00:00:00',2,'2018-11-09 15:03:22',1,'2018-11-14 09:50:05',1),(5,'2001',65,4,5,120,230,1,0,1,0,1,'2018-12-31 00:00:00',4,'2018-11-13 16:56:48',1,'2018-11-14 09:48:59',1);
/*!40000 ALTER TABLE `RiskScore` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Session`
--

DROP TABLE IF EXISTS `Session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Session` (
  `SessionId` varchar(30) NOT NULL,
  `UserID` int(4) NOT NULL,
  `CreateDate` datetime(6) NOT NULL,
  `LastUse` datetime(6) NOT NULL,
  `Active` char(1) NOT NULL,
  PRIMARY KEY (`SessionId`),
  KEY `UserID` (`UserID`),
  CONSTRAINT `Session_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `User` (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Session`
--

LOCK TABLES `Session` WRITE;
/*!40000 ALTER TABLE `Session` DISABLE KEYS */;
INSERT INTO `Session` VALUES ('2F2q0K2lJupkOTNtS0gKyq9ZA',1,'2018-11-12 08:48:48.000000','2018-11-12 08:54:14.000000',''),('40Jz8VSyGuJegsi9miiIB4mL4',1,'2018-11-13 12:26:53.000000','2018-11-13 12:26:53.000000',''),('4uFFck41zIe3zi9vx5M4N4mJx',1,'2018-11-12 19:50:56.000000','2018-11-12 20:03:40.000000',''),('6UykDXdtxSP7EyGArvjUogOhE',1,'2018-11-15 12:26:40.000000','2018-11-15 12:26:55.000000',''),('7pFE3aqvAibbt2U3UMy80XBDP',1,'2018-11-13 15:22:22.000000','2018-11-13 15:22:22.000000',''),('B5Y89638fm8Li8mwRXRrD2oGq',1,'2018-11-11 08:42:14.000000','2018-11-11 08:42:33.000000',''),('bb6jPLRtdMBUDDqIoCv2bkdpc',1,'2018-11-19 16:12:38.000000','2018-11-19 16:22:35.000000',''),('BNPTJFGJsxPmYWa2bqz9V3C1F',1,'2018-11-09 10:10:38.000000','2018-11-09 10:11:16.000000',''),('Bo6PX0tfYAj203ntqGVHVY4MF',1,'2018-11-12 15:24:10.000000','2018-11-12 15:30:14.000000',''),('CFxhVtwefwEAmV531ymVFmVTc',1,'2018-11-13 07:12:22.000000','2018-11-13 07:13:19.000000',''),('cHoRugcetvib1KI2ny4wWlrJp',1,'2018-11-22 15:39:56.000000','2018-11-22 15:40:02.000000',''),('eezG6anJGGusIWWIX1cBBVJdk',1,'2018-11-12 20:16:54.000000','2018-11-12 20:27:21.000000',''),('eyQYtPObnbLz9goXzqFReA77w',1,'2018-11-13 21:05:48.000000','2018-11-13 21:05:55.000000',''),('fFXvRvJSCtxCKfDbzn1VSNDeH',1,'2018-11-22 08:40:33.000000','2018-11-22 08:57:33.000000',''),('FtGpUS7TpTgVebCrbfLennZwX',1,'2018-11-14 09:49:10.000000','2018-11-14 09:50:20.000000',''),('H97gV8BtpMX4VNXVqsS7NqsXh',1,'2018-11-13 16:28:39.000000','2018-11-13 16:28:39.000000',''),('hbjLOUObmwdrM20NcVQK0v3jo',1,'2018-11-14 10:49:07.000000','2018-11-14 10:49:30.000000',''),('HEW69ySLoty5Ld3qu4VZY1DA3',1,'2018-11-13 11:11:54.000000','2018-11-13 11:15:12.000000',''),('hiS3nINPW5blLh5G9uXgQEaOb',1,'2018-11-12 09:08:55.000000','2018-11-12 09:13:49.000000',''),('hW7Lz45rMgzLWi07nneFmfPmi',1,'2018-11-12 15:58:15.000000','2018-11-12 16:10:22.000000',''),('HYCvKpKhYhK2yFyjQPDcJKQIw',1,'2018-11-12 11:09:21.000000','2018-11-12 11:10:34.000000',''),('iJ1EcSacp3MN4U3bUAKoDP6cw',1,'2018-11-12 16:50:30.000000','2018-11-12 16:52:48.000000',''),('iOTd8zL4HII70MAx5DFTwmEnh',1,'2018-11-12 08:19:09.000000','2018-11-12 08:19:09.000000',''),('iqfqOgRBHB8dhlQccI7lmnL6t',1,'2018-11-12 09:15:46.000000','2018-11-12 09:18:07.000000',''),('JAeLkvpzr59Y5yGDwTfFOpx83',1,'2018-11-19 14:56:13.000000','2018-11-19 14:56:13.000000',''),('jdpmsyTiBZjurO3207nCOVD2h',1,'2018-11-12 09:01:00.000000','2018-11-12 09:04:26.000000',''),('JfQx18AYcw0dtIEb0FfpmUCCS',1,'2018-11-09 07:55:05.000000','2018-11-09 07:56:17.000000',''),('KqemPWBUZNOgu1Gvnt0yuSdv3',1,'2018-11-09 15:02:32.000000','2018-11-09 15:08:44.000000',''),('kZkxUyPg8adydY4ibRLUwz9Rq',1,'2018-11-12 19:29:04.000000','2018-11-12 19:43:28.000000',''),('LGvZnTObgZ7kSxkFYu0p2BuAa',1,'2018-11-13 07:28:07.000000','2018-11-13 07:30:28.000000',''),('MJXZQbcLkWrZQW7dqsR1VuO5L',1,'2018-11-12 09:04:58.000000','2018-11-12 09:06:54.000000',''),('Mq8374HeKykOkqFbbFY75WTjN',1,'2018-11-09 11:10:53.000000','2018-11-09 11:12:39.000000',''),('NFngxrZkbzpjRWG0qSEhH59Am',1,'2018-11-12 08:33:01.000000','2018-11-12 08:45:02.000000',''),('NnOHLghcsW2jRCubkoS9S8fyG',1,'2018-11-19 16:11:24.000000','2018-11-19 16:11:28.000000',''),('nODu0NcFx7WzGoAtpfq5aQFfa',1,'2018-11-13 10:50:35.000000','2018-11-13 10:54:43.000000',''),('oKA1s3jH7MFbtWCIy3pH0i5Av',1,'2018-11-12 15:39:36.000000','2018-11-12 15:49:59.000000',''),('PsrBck1DPo88VaZxH4lGsA00z',1,'2018-12-06 16:05:45.000000','2018-12-06 16:05:46.000000',''),('qhQTU03IqFIsPVppX4un1uBWw',1,'2018-11-12 08:01:11.000000','2018-11-12 08:01:11.000000',''),('QYBgpJd43wJpQpCsgcarrwZQz',1,'2018-11-12 08:18:22.000000','2018-11-12 08:18:22.000000',''),('RC8QcfZOGRNkyekMCNGXkidHU',1,'2018-11-13 16:47:57.000000','2018-11-13 16:57:22.000000',''),('RVGXLfPJrAQYdeG73KI0AxJaN',1,'2018-11-09 09:04:05.000000','2018-11-09 09:05:00.000000',''),('s77P7qam2C4CqVVjDwgTpqK2k',1,'2018-11-12 17:47:04.000000','2018-11-12 17:51:36.000000',''),('SLfFwHIGrkO3dDP1UtH3EBoWU',1,'2018-11-13 11:16:07.000000','2018-11-13 11:29:07.000000',''),('sT54PAoQf6iOUCMn7I0SETFv5',1,'2018-11-19 14:51:27.000000','2018-11-19 14:51:27.000000',''),('u5zXUuCZ9fo9ex6kprwoyeGTg',1,'2018-11-10 14:58:44.000000','2018-11-10 14:58:44.000000',''),('UpsoCEbBcC4kIo6zv1uLTExTa',1,'2018-11-13 16:01:37.000000','2018-11-13 16:02:07.000000',''),('utKaZ1Vu66Yptj6CxtQC3391G',1,'2018-11-12 07:45:10.000000','2018-11-12 07:45:52.000000',''),('UX5R4FzI9057Dy1w4dyNi6kTf',1,'2018-11-12 08:13:31.000000','2018-11-12 08:34:29.000000',''),('VKOX28iI2E3t9mDM29bhUyJ5x',1,'2018-11-12 08:16:27.000000','2018-11-12 08:16:39.000000',''),('VN3JjalDfy7DFkUKasU0rivCK',1,'2018-11-12 09:16:51.000000','2018-11-12 09:42:29.000000',''),('vnWAoPfefcfbslfl0ib0MAS4F',3,'2018-11-13 06:52:40.000000','2018-11-13 06:53:41.000000',''),('WCKcgSsskOvp0RwGwyUqHfj3H',1,'2018-11-13 06:36:35.000000','2018-11-13 06:45:47.000000',''),('xCuyR2Em26Q7G9gJMT81YWSqh',1,'2018-11-14 09:27:37.000000','2018-11-14 09:52:14.000000',''),('XdNtZtqcMmG67FPMRUoyIKDYQ',1,'2018-11-22 16:18:45.000000','2018-11-22 16:22:40.000000',''),('xkokFX7R5JUPwxaKPlesSdSZ6',1,'2018-11-12 08:23:44.000000','2018-11-12 08:28:42.000000',''),('xRA4d9A8BABVOn6UstphwOmCG',1,'2018-11-13 16:47:58.000000','2018-11-13 16:58:03.000000',''),('XYioH21iHk0FqRxV9Y19TXXer',1,'2018-11-12 09:10:52.000000','2018-11-12 09:13:02.000000',''),('Y66m5hYvW3S14VwJopiYI0e6k',1,'2018-11-16 09:10:09.000000','2018-11-16 09:10:17.000000',''),('yF3j8HxJwWZPWakR8A1nxios5',1,'2018-11-11 18:39:01.000000','2018-11-11 18:39:24.000000',''),('ZCjsGI6G5mFcOYX6SRFu6jGi8',1,'2018-11-13 10:24:04.000000','2018-11-13 10:26:03.000000',''),('zp66QCNvO2OyaWxd7TH5WE6BI',1,'2018-11-27 15:30:27.000000','2018-11-27 15:30:27.000000','');
/*!40000 ALTER TABLE `Session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `User`
--

DROP TABLE IF EXISTS `User`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `User` (
  `UserID` int(4) NOT NULL AUTO_INCREMENT,
  `LoginID` varchar(50) NOT NULL,
  `AccessTypeID` int(4) NOT NULL,
  `FirstName` varchar(50) CHARACTER SET utf8 COLLATE utf8_thai_520_w2 NOT NULL,
  `LastName` varchar(50) CHARACTER SET utf8 COLLATE utf8_thai_520_w2 NOT NULL,
  `Password` varchar(255) NOT NULL,
  `IsEnable` tinyint(1) NOT NULL DEFAULT 0,
  `LastLogin` datetime DEFAULT NULL,
  `LastPasswordChange` datetime DEFAULT NULL,
  `CreateDate` datetime NOT NULL,
  `UpdateDate` datetime NOT NULL,
  PRIMARY KEY (`UserID`),
  UNIQUE KEY `Ndx_LoginID` (`LoginID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `User`
--

LOCK TABLES `User` WRITE;
/*!40000 ALTER TABLE `User` DISABLE KEYS */;
INSERT INTO `User` VALUES (1,'admin',7,'admin','admin','$2y$10$vRq4OgSgYLD3hZ.pqe9c4OL3YdD/1blaGNG9lhJ/YwLBEr9JkAg/2',1,NULL,'2018-11-27 15:30:13','2018-11-08 20:06:30','2018-11-13 07:13:12'),(3,'user',8,'User','User','$2y$10$9pE1gEkq9cPJxPRnBSVYIu41EY3FLEQ77qQmaxjaMo8FBe75LseKO',1,NULL,NULL,'2018-11-13 06:51:50','2018-11-13 06:51:50'),(4,'1800',7,'Jane','Doe','$2y$10$cq.Lducav/5W96FbRGqg2eo4M1naIEOjN6RCaa.wsORZgp2p0kB/y',2,NULL,NULL,'2018-11-14 09:46:20','2018-11-27 15:36:57');
/*!40000 ALTER TABLE `User` 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-10-26 21:34:38

📁 Sid Gifari File Manager