Email: admin@example.com
', 'footer', NULL, 0, 1, NULL), (2, '[[regtime]]', 'terms', 'Terms of Service', 'Replace this with your actual terms.
', 'footer', NULL, 1, 1, NULL), (3, '[[regtime]]', 'api', 'API Documentation', NULL, 'footer', NULL, 2, 1, 'api-docs.php'); -- -------------------------------------------------------- -- -- Table structure for table `page_view` -- CREATE TABLE `page_view` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `tpage` int(10) unsigned NOT NULL DEFAULT '0', `tvisit` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `pastes` -- CREATE TABLE `pastes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `slug` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Untitled', `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `visible` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text', `expiry` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NONE', `encrypt` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `member` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Guest', `date` datetime NOT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `now_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `s_date` date DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_pastes_slug` (`slug`), KEY `idx_pastes_parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `paste_comments` -- CREATE TABLE `paste_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `paste_id` int(11) NOT NULL, `parent_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `body_html_cached` text COLLATE utf8mb4_unicode_ci, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_paste_time` (`paste_id`,`created_at`), KEY `idx_parent` (`paste_id`,`parent_id`,`created_at`), KEY `fk_comments_parent` (`parent_id`), KEY `fk_comments_user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `paste_options` -- CREATE TABLE `paste_options` ( `id` int(11) NOT NULL AUTO_INCREMENT, `option_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `option_value` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `idx_option_name` (`option_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ; -- -- Dumping data for table `paste_options` -- INSERT INTO `paste_options` VALUES (1, 'url_mode', 'slug'), (2, 'slug_length', '8'), (3, 'api_enabled', '1'), (4, 'api_keys_per_user', '5'); -- -------------------------------------------------------- -- -- Table structure for table `paste_views` -- CREATE TABLE `paste_views` ( `id` int(11) NOT NULL AUTO_INCREMENT, `paste_id` int(11) NOT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `view_date` date NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_paste_ip_date` (`paste_id`,`ip`,`view_date`), KEY `idx_paste_id` (`paste_id`), KEY `idx_view_date` (`view_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `sitemap_options` -- CREATE TABLE `sitemap_options` ( `id` int(11) NOT NULL AUTO_INCREMENT, `priority` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0.9', `changefreq` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'daily', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `sitemap_options` -- INSERT INTO `sitemap_options` VALUES (1, '0.9', 'daily'); -- -------------------------------------------------------- -- -- Table structure for table `site_info` -- CREATE TABLE `site_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `des` mediumtext COLLATE utf8mb4_unicode_ci, `keyword` mediumtext COLLATE utf8mb4_unicode_ci, `site_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `twit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `face` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gplus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ga` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `additional_scripts` text COLLATE utf8mb4_unicode_ci, `baseurl` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `site_info` -- INSERT INTO `site_info` VALUES (1, 'Paste', 'Paste can store text, source code, or sensitive data for a set period of time.', 'paste,pastebin.com,pastebin,text,paste,online paste', 'Paste', 'admin@yourdomain.com', 'https://x.com/', 'https://www.facebook.com/', '', '', '', '[[softurl]]/'); -- -------------------------------------------------------- -- -- Table structure for table `site_permissions` -- CREATE TABLE `site_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `disableguest` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off', `siteprivate` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off', `hiderecentpastes` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `site_permissions` -- INSERT INTO `site_permissions` VALUES (1, 'off', 'off', 'off'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `oauth_uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `username_locked` tinyint(1) NOT NULL DEFAULT '1', `email_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `full_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `platform` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `verified` enum('0','1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'NONE', `date` datetime NOT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `last_ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refresh_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `verification_code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reset_code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reset_expiry` datetime DEFAULT NULL, `remember_token` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `visitor_ips` -- CREATE TABLE `visitor_ips` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `visit_date` date NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_ip_date` (`ip`,`visit_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -- Constraints for dumped tables -- -- -- Constraints for table `admin_history` -- ALTER TABLE `admin_history` ADD CONSTRAINT `fk_admin_history_admin` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`) ON DELETE SET NULL; -- -- Constraints for table `api_keys` -- ALTER TABLE `api_keys` ADD CONSTRAINT `api_keys_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `pages` -- ALTER TABLE `pages` ADD CONSTRAINT `fk_pages_navparent` FOREIGN KEY (`nav_parent`) REFERENCES `pages` (`id`) ON DELETE SET NULL; -- -- Constraints for table `paste_comments` -- ALTER TABLE `paste_comments` ADD CONSTRAINT `fk_comments_parent` FOREIGN KEY (`parent_id`) REFERENCES `paste_comments` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_comments_paste` FOREIGN KEY (`paste_id`) REFERENCES `pastes` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_comments_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `paste_views` -- ALTER TABLE `paste_views` ADD CONSTRAINT `paste_views_ibfk_1` FOREIGN KEY (`paste_id`) REFERENCES `pastes` (`id`) ON DELETE CASCADE; /*!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 */;