Gecko [ www.arkitchencabinet.com ]

Name	Size	Permission	Date
images	[ DIR ]	drwxr-xr-x	2026-01-13 23:23
php53	[ DIR ]	drwxr-xr-x	2026-01-13 23:23
php56	[ DIR ]	drwxr-xr-x	2026-01-13 23:23
php71	[ DIR ]	drwxr-xr-x	2026-01-13 23:23
php81	[ DIR ]	drwxr-xr-x	2026-01-13 23:23
php82	[ DIR ]	drwxr-xr-x	2026-01-13 23:23
.htaccess	241 B	-rw-r--r--	2021-12-23 11:54
changelog.txt	2.55 KB	-rw-r--r--	2026-01-13 06:25
clone.php	3.95 KB	-rw-r--r--	2026-01-13 12:11
config.php	3.62 KB	-rw-r--r--	2026-01-13 06:25
edit.php	4.39 KB	-rw-r--r--	2026-01-13 12:11
edit.xml	433 B	-rw-r--r--	2021-12-23 11:54
fileindex.php	275 B	-rw-r--r--	2021-12-23 11:54
import.php	3.77 KB	-rw-r--r--	2026-01-13 12:11
index.php	40 B	-rw-r--r--	2021-12-23 11:54
info.xml	2.09 KB	-rw-r--r--	2026-01-13 06:25
install.js	921 B	-rw-r--r--	2021-12-23 11:54
install.php	4.22 KB	-rw-r--r--	2026-01-13 12:11
install.xml	1.27 KB	-rw-r--r--	2021-12-23 11:54
md5	3.23 KB	-rw-r--r--	2026-01-13 12:11
mod_upgrade.php	3.25 KB	-rw-r--r--	2026-01-13 06:25
notes.txt	652 B	-rw-r--r--	2025-04-04 07:44
orig_upgrade.php	3.21 KB	-rw-r--r--	2026-01-13 06:25
upgrade.php	3.97 KB	-rw-r--r--	2026-01-13 12:11
upgrade.xml	393 B	-rw-r--r--	2021-12-23 11:54
yourls.sql	2.91 KB	-rw-r--r--	2026-01-13 06:25
yourls.zip	5.44 MB	-rw-r--r--	2026-01-13 06:25

Rename

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

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

--
-- Database: `yourls1103`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]log`
--

CREATE TABLE `[[dbprefix]]log` (
  `click_id` int(11) NOT NULL AUTO_INCREMENT,
  `click_time` datetime NOT NULL,
  `shorturl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `referrer` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(41) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`click_id`),
  KEY `shorturl` (`shorturl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]options`
--

CREATE TABLE `[[dbprefix]]options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`option_id`,`option_name`),
  KEY `option_name` (`option_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `[[dbprefix]]options`
--

INSERT INTO `[[dbprefix]]options` VALUES
(1, 'version', '1.10.3'),
(2, 'db_version', '507'),
(3, 'next_id', '1'),
(4, 'active_plugins', 'a:0:{}');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]url`
--

CREATE TABLE `[[dbprefix]]url` (
  `keyword` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `url` text 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(10) unsigned NOT NULL,
  PRIMARY KEY (`keyword`),
  KEY `ip` (`ip`),
  KEY `timestamp` (`timestamp`),
  KEY `url_idx` (`url`(30))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `[[dbprefix]]url`
--

INSERT INTO `[[dbprefix]]url` VALUES
('ozh', 'https://ozh.org/', 'ozh.org', '[[regtime]]', '[[clientip]]', 0),
('yourls', 'https://yourls.org/', 'YOURLS: Your Own URL Shortener', '[[regtime]]', '[[clientip]]', 0),
('yourlsblog', 'https://blog.yourls.org/', 'YOURLS'' Blog', '[[regtime]]', '[[clientip]]', 0);

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