📄 File: davehame_your306.sql

Path: /home/davehame/www/g4i/davehame_your306.sql

Size: 5.63 KB

Permissions: 0644

-- MySQL dump 10.13  Distrib 8.0.34, for Linux (x86_64)
--
-- Host: localhost    Database: davehame_your306
-- ------------------------------------------------------
-- Server version	8.0.34-cll-lve

/*!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 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: `davehame_your306`
--


--
-- Table structure for table `yprecx_log`
--

DROP TABLE IF EXISTS `yprecx_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `yprecx_log` (
  `click_id` int NOT NULL AUTO_INCREMENT,
  `click_time` datetime NOT NULL,
  `shorturl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `referrer` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(41) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`click_id`),
  KEY `shorturl` (`shorturl`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yprecx_log`
--

LOCK TABLES `yprecx_log` WRITE;
/*!40000 ALTER TABLE `yprecx_log` DISABLE KEYS */;
INSERT INTO `yprecx_log` (`click_id`, `click_time`, `shorturl`, `referrer`, `user_agent`, `ip_address`, `country_code`) VALUES (1,'2022-12-12 20:13:15','go4it','direct','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','89.238.133.126','US');
/*!40000 ALTER TABLE `yprecx_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yprecx_options`
--

DROP TABLE IF EXISTS `yprecx_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `yprecx_options` (
  `option_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`option_id`,`option_name`),
  KEY `option_name` (`option_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yprecx_options`
--

LOCK TABLES `yprecx_options` WRITE;
/*!40000 ALTER TABLE `yprecx_options` DISABLE KEYS */;
INSERT INTO `yprecx_options` (`option_id`, `option_name`, `option_value`) VALUES (1,'version','1.9.1'),(2,'db_version','506'),(3,'next_id','4'),(4,'active_plugins','a:1:{i:0;s:34:\"bulk-import-and-shorten/plugin.php\";}'),(5,'core_version_checks','O:8:\"stdClass\":4:{s:15:\"failed_attempts\";i:0;s:12:\"last_attempt\";i:1694654227;s:11:\"last_result\";O:8:\"stdClass\":2:{s:6:\"latest\";s:5:\"1.9.2\";s:6:\"zipurl\";s:56:\"https://api.github.com/repos/YOURLS/YOURLS/zipball/1.9.2\";}s:15:\"version_checked\";s:5:\"1.9.1\";}');
/*!40000 ALTER TABLE `yprecx_options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yprecx_url`
--

DROP TABLE IF EXISTS `yprecx_url`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `yprecx_url` (
  `keyword` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(41) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `clicks` int unsigned NOT NULL,
  PRIMARY KEY (`keyword`),
  KEY `ip` (`ip`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yprecx_url`
--

LOCK TABLES `yprecx_url` WRITE;
/*!40000 ALTER TABLE `yprecx_url` DISABLE KEYS */;
INSERT INTO `yprecx_url` (`keyword`, `url`, `title`, `timestamp`, `ip`, `clicks`) VALUES ('go4it','https://go-4it.com','Go For It – My Blog','2022-12-12 19:12:52','89.238.133.126',1),('ozh','https://ozh.org/','ozh.org','2022-12-12 21:05:12','89.238.133.126',0),('yourls','https://yourls.org/','YOURLS: Your Own URL Shortener','2022-12-12 21:05:12','89.238.133.126',0),('yourlsblog','https://blog.yourls.org/','YOURLS\' Blog','2022-12-12 21:05:12','89.238.133.126',0);
/*!40000 ALTER TABLE `yprecx_url` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'davehame_your306'
--

--
-- Dumping routines for database 'davehame_your306'
--
/*!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 2023-09-14 17:21:36

← Back to Directory Edit File 🔒 Chmod