home/autoph/public_html/projects/api/tmp/db/Dump20220715 (1).sql 0000644 00000015146 15025024253 0017605 0 ustar 00 -- MySQL dump 10.13 Distrib 8.0.24, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: autoph_api
-- ------------------------------------------------------
-- Server version 8.0.29
/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `api_key_access_uris`
--
DROP TABLE IF EXISTS `api_key_access_uris`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `api_key_access_uris` (
`id` bigint NOT NULL AUTO_INCREMENT,
`api_key_id` bigint DEFAULT NULL,
`uri` text,
`title` varchar(45) DEFAULT NULL,
`description` text,
`status` tinyint DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `api_key_access_uris_fk1_idx` (`api_key_id`),
CONSTRAINT `api_key_access_uris_fk1` FOREIGN KEY (`api_key_id`) REFERENCES `api_keys` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `api_key_access_uris`
--
LOCK TABLES `api_key_access_uris` WRITE;
/*!40000 ALTER TABLE `api_key_access_uris` DISABLE KEYS */;
INSERT INTO `api_key_access_uris` VALUES (1,1,'/v1/qr/',NULL,NULL,1),(2,1,'/v1/sms/golf/',NULL,NULL,1),(3,1,'/v1/mail/',NULL,NULL,1),(4,1,'/v1/sms/default/',NULL,NULL,1);
/*!40000 ALTER TABLE `api_key_access_uris` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `api_keys`
--
DROP TABLE IF EXISTS `api_keys`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `api_keys` (
`id` bigint NOT NULL AUTO_INCREMENT,
`api_key` varchar(245) DEFAULT NULL,
`title` varchar(45) DEFAULT NULL,
`description` text,
`status` tinyint DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `api_keys`
--
LOCK TABLES `api_keys` WRITE;
/*!40000 ALTER TABLE `api_keys` DISABLE KEYS */;
INSERT INTO `api_keys` VALUES (1,'1a08ff7af875429ab2ebc03678b6a5ab','Default','Default API Key',1);
/*!40000 ALTER TABLE `api_keys` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `api_logs`
--
DROP TABLE IF EXISTS `api_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `api_logs` (
`id` bigint NOT NULL AUTO_INCREMENT,
`api_key_access_uri_id` bigint DEFAULT NULL,
`ip_address` varchar(95) DEFAULT NULL,
`user_agent` text,
`description` text,
`timestamp` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `api_logs_fk1_idx` (`api_key_access_uri_id`),
CONSTRAINT `api_logs_fk1` FOREIGN KEY (`api_key_access_uri_id`) REFERENCES `api_key_access_uris` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `api_logs`
--
LOCK TABLES `api_logs` WRITE;
/*!40000 ALTER TABLE `api_logs` DISABLE KEYS */;
INSERT INTO `api_logs` VALUES (1,1,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36',NULL,'2022-07-15 14:36:37'),(2,1,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36',NULL,'2022-07-15 14:36:43');
/*!40000 ALTER TABLE `api_logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` bigint NOT NULL AUTO_INCREMENT,
`firstname` varchar(95) DEFAULT NULL,
`middlename` varchar(95) DEFAULT NULL,
`lastname` varchar(95) DEFAULT NULL,
`mobile` varchar(45) DEFAULT NULL,
`email` varchar(95) DEFAULT NULL,
`other_mobile` varchar(45) DEFAULT NULL,
`other_email` varchar(95) DEFAULT NULL,
`username` varchar(45) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`is_admin` tinyint DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`active` tinyint DEFAULT NULL,
`status` tinyint DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Clarence','Acedera','Andaya','9389592854','clarenceandaya8@gmail.com',NULL,NULL,'clrkz','$2y$10$WllXm6G1LKwuzyocGyjrWe04DmUbRGXDnsyH3Fmt.IYawAHVZdmuW',1,NULL,NULL,NULL,1,1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_login_session_token`
--
DROP TABLE IF EXISTS `users_login_session_token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users_login_session_token` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint DEFAULT NULL,
`token` varchar(95) DEFAULT NULL,
`status` tinyint DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id_UNIQUE` (`user_id`),
KEY `login_token_fk1_idx` (`user_id`),
CONSTRAINT `login_token_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_login_session_token`
--
LOCK TABLES `users_login_session_token` WRITE;
/*!40000 ALTER TABLE `users_login_session_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_login_session_token` 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 2022-07-15 14:37:23