| Server IP : 217.18.85.50 / Your IP : 3.136.18.192 Web Server : LiteSpeed System : Linux server50.tr85.dhs.com.tr 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64 User : ferhatgenc ( ) PHP Version : 7.2.34 Disable Function : restore_ini,mail,openbasedir,f_open,system,dl,array_compare,array_user_key_compare,passthru,cat,exec,popen,proc_close,proc_get_status,proc_nice,proc_open,escapeshellcmd,escapeshellarg,show_source,posix_mkfifo,ini_restore,mysql_list_dbs,getmyuid,pconnect,link,symlink,fin,passthruexec,fileread,shell_exec,pcntl_exec,ini_alter,leak,apache_child_terminate,chown,posix_kill,posix_setpgid,posix_setsid,posix_setuid,proc_terminate,syslog,allow_url_fopen,fpassthru,execute,shell,chgrp,passthru,socket_select,socket_create,socket_create_listen,socket_create_pair,socket_listen,socket_accept,socket_bind,foreach,socket_strerror,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,openlog,apache_get_version,apache_getenv,apache_note,apache_setenv,virtualal MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /var/softaculous/yourls/ |
Upload File : |
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: `yourls192`
--
-- --------------------------------------------------------
--
-- 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.9.2'),
(2, 'db_version', '506'),
(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`)
) 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 */;