[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

--

[10] Fix | Delete

-- Database: `yourls192`

[11] Fix | Delete

--

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

--

[16] Fix | Delete

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

[17] Fix | Delete

--

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]log` (

[20] Fix | Delete

`click_id` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`click_time` datetime NOT NULL,

[22] Fix | Delete

`shorturl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,

[23] Fix | Delete

`referrer` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,

[24] Fix | Delete

`user_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[25] Fix | Delete

`ip_address` varchar(41) COLLATE utf8mb4_unicode_ci NOT NULL,

[26] Fix | Delete

`country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,

[27] Fix | Delete

PRIMARY KEY (`click_id`),

[28] Fix | Delete

KEY `shorturl` (`shorturl`)

[29] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[30] Fix | Delete

[31] Fix | Delete

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

[32] Fix | Delete

[33] Fix | Delete

--

[34] Fix | Delete

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

[35] Fix | Delete

--

[36] Fix | Delete

[37] Fix | Delete

CREATE TABLE `[[dbprefix]]options` (

[38] Fix | Delete

`option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

[39] Fix | Delete

`option_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[40] Fix | Delete

`option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

[41] Fix | Delete

PRIMARY KEY (`option_id`,`option_name`),

[42] Fix | Delete

KEY `option_name` (`option_name`)

[43] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

[44] Fix | Delete

[45] Fix | Delete

--

[46] Fix | Delete

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

[47] Fix | Delete

--

[48] Fix | Delete

[49] Fix | Delete

INSERT INTO `[[dbprefix]]options` VALUES

[50] Fix | Delete

(1, 'version', '1.9.2'),

[51] Fix | Delete

(2, 'db_version', '506'),

[52] Fix | Delete

(3, 'next_id', '1'),

[53] Fix | Delete

(4, 'active_plugins', 'a:0:{}');

[54] Fix | Delete

[55] Fix | Delete

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

[56] Fix | Delete

[57] Fix | Delete

--

[58] Fix | Delete

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

[59] Fix | Delete

--

[60] Fix | Delete

[61] Fix | Delete

CREATE TABLE `[[dbprefix]]url` (

[62] Fix | Delete

`keyword` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[63] Fix | Delete

`url` text COLLATE utf8mb4_bin NOT NULL,

[64] Fix | Delete

`title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,

[65] Fix | Delete

`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

[66] Fix | Delete

`ip` varchar(41) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

[67] Fix | Delete

`clicks` int(10) unsigned NOT NULL,

[68] Fix | Delete

PRIMARY KEY (`keyword`),

[69] Fix | Delete

KEY `ip` (`ip`),

[70] Fix | Delete

KEY `timestamp` (`timestamp`)

[71] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

[72] Fix | Delete

[73] Fix | Delete

--

[74] Fix | Delete

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

[75] Fix | Delete

--

[76] Fix | Delete

[77] Fix | Delete

INSERT INTO `[[dbprefix]]url` VALUES

[78] Fix | Delete

('ozh', 'https://ozh.org/', 'ozh.org', '[[regtime]]', '[[clientip]]', 0),

[79] Fix | Delete

('yourls', 'https://yourls.org/', 'YOURLS: Your Own URL Shortener', '[[regtime]]', '[[clientip]]', 0),

[80] Fix | Delete

('yourlsblog', 'https://blog.yourls.org/', 'YOURLS'' Blog', '[[regtime]]', '[[clientip]]', 0);

[81] Fix | Delete

[82] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[83] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[84] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[85] Fix | Delete

[86] Fix | Delete