File manager

File manager - Edit - /home/autoph/public_html/projects/api/tmp/db/Dump20220715 (1).sql

Back
-- 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

| ver. 1.4 | . | PHP 8.0.30 | Generation time: 0 | proxy | phpinfo | Settings