[ PARENT ]

EDIT :: yourls.sql

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

SAVE CANCEL