#$@%#$%!

Ngiler SH3LL 360
: / var / softaculous / paste /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	63.250.38.10
System	Linux premium90.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User	likhxapw
PHP Version	8.3.30
Software	LiteSpeed
Doc root	Writable

Edit File : paste.sql \| Size : 16.89 KB
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: `paste34` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `pass` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin@example.com', `reset_code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reset_expiry` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user` (`user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `admin` -- INSERT INTO `admin` VALUES (1, '[[admin_username]]', '[[admin_pass]]', 'admin@yourdomain.com', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `admin_history` -- CREATE TABLE `admin_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) DEFAULT NULL, `last_date` datetime NOT NULL, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `idx_admin_id` (`admin_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ads` -- CREATE TABLE `ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `text_ads` text COLLATE utf8mb4_unicode_ci, `ads_1` text COLLATE utf8mb4_unicode_ci, `ads_2` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `ads` -- INSERT INTO `ads` VALUES (1, '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `api_keys` -- CREATE TABLE `api_keys` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `api_key` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Default', `created_at` datetime DEFAULT CURRENT_TIMESTAMP, `last_used_at` datetime DEFAULT NULL, `is_active` tinyint(1) DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idx_api_key` (`api_key`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ban_user` -- CREATE TABLE `ban_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `last_date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `captcha` -- CREATE TABLE `captcha` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cap_e` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off', `mode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Normal', `recaptcha_version` enum('v2','v3') COLLATE utf8mb4_unicode_ci DEFAULT 'v2', `mul` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off', `allowed` text COLLATE utf8mb4_unicode_ci NOT NULL, `color` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#000000', `recaptcha_sitekey` text COLLATE utf8mb4_unicode_ci, `recaptcha_secretkey` text COLLATE utf8mb4_unicode_ci, `turnstile_sitekey` text COLLATE utf8mb4_unicode_ci, `turnstile_secretkey` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `captcha` -- INSERT INTO `captcha` VALUES (1, 'off', 'normal', 'v2', 'off', 'ABCDEFGHIJKLMNOPQRSTUVYXYZabcdefghijklmnopqrstuvwxyz0123456789', '#000000', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `interface` -- CREATE TABLE `interface` ( `id` int(11) NOT NULL AUTO_INCREMENT, `theme` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default', `lang` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en.php', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `interface` -- INSERT INTO `interface` VALUES (1, 'default', 'en.php'); -- -------------------------------------------------------- -- -- Table structure for table `mail` -- CREATE TABLE `mail` ( `id` int(11) NOT NULL AUTO_INCREMENT, `verification` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enabled', `smtp_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `smtp_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `smtp_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', `smtp_port` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '', `protocol` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2', `auth` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true', `socket` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tls', `oauth_client_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oauth_client_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oauth_refresh_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `mail` -- INSERT INTO `mail` VALUES (1, 'enabled', 'smtp.gmail.com', '', '', '587', '2', 'true', 'tls', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `mail_log` -- CREATE TABLE `mail_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sent_at` datetime NOT NULL, `type` enum('verification','reset','test') COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `last_date` datetime NOT NULL, `page_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `page_title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `page_content` longtext COLLATE utf8mb4_unicode_ci, `location` enum('','header','footer','both') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `nav_parent` int(11) DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '1', `external_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_pages_location` (`location`), KEY `idx_pages_navparent` (`nav_parent`), KEY `idx_pages_active` (`is_active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ; -- -- Dumping data for table `pages` -- INSERT INTO `pages` VALUES (1, '[[regtime]]', 'contact', 'Contact', '<h1>Contact Us</h1><p>Email: <a href="mailto:admin@example.com">admin@example.com</a></p>', 'footer', NULL, 0, 1, NULL), (2, '[[regtime]]', 'terms', 'Terms of Service', '<h1>Terms of Service</h1><p>Replace this with your actual terms.</p>', '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 /; Back

Edit File : paste.sql | Size : 16.89 KB

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: `paste34`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pass` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin@example.com',
  `reset_code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reset_expiry` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user` (`user`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', 'admin@yourdomain.com', NULL, NULL);

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

--
-- Table structure for table `admin_history`
--

CREATE TABLE `admin_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `last_date` datetime NOT NULL,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_admin_id` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text_ads` text COLLATE utf8mb4_unicode_ci,
  `ads_1` text COLLATE utf8mb4_unicode_ci,
  `ads_2` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `ads`
--

INSERT INTO `ads` VALUES
(1, '', '', '');

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

--
-- Table structure for table `api_keys`
--

CREATE TABLE `api_keys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `api_key` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Default',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `last_used_at` datetime DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_api_key` (`api_key`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ban_user`
--

CREATE TABLE `ban_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `captcha`
--

CREATE TABLE `captcha` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cap_e` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off',
  `mode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Normal',
  `recaptcha_version` enum('v2','v3') COLLATE utf8mb4_unicode_ci DEFAULT 'v2',
  `mul` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off',
  `allowed` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#000000',
  `recaptcha_sitekey` text COLLATE utf8mb4_unicode_ci,
  `recaptcha_secretkey` text COLLATE utf8mb4_unicode_ci,
  `turnstile_sitekey` text COLLATE utf8mb4_unicode_ci,
  `turnstile_secretkey` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `captcha`
--

INSERT INTO `captcha` VALUES
(1, 'off', 'normal', 'v2', 'off', 'ABCDEFGHIJKLMNOPQRSTUVYXYZabcdefghijklmnopqrstuvwxyz0123456789', '#000000', '', '', '', '');

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

--
-- Table structure for table `interface`
--

CREATE TABLE `interface` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `theme` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `lang` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en.php',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `interface`
--

INSERT INTO `interface` VALUES
(1, 'default', 'en.php');

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

--
-- Table structure for table `mail`
--

CREATE TABLE `mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `verification` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enabled',
  `smtp_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `smtp_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `smtp_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `smtp_port` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `protocol` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2',
  `auth` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `socket` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tls',
  `oauth_client_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oauth_client_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oauth_refresh_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mail`
--

INSERT INTO `mail` VALUES
(1, 'enabled', 'smtp.gmail.com', '', '', '587', '2', 'true', 'tls', NULL, NULL, NULL);

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

--
-- Table structure for table `mail_log`
--

CREATE TABLE `mail_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent_at` datetime NOT NULL,
  `type` enum('verification','reset','test') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `last_date` datetime NOT NULL,
  `page_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_content` longtext COLLATE utf8mb4_unicode_ci,
  `location` enum('','header','footer','both') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `nav_parent` int(11) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `external_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_pages_location` (`location`),
  KEY `idx_pages_navparent` (`nav_parent`),
  KEY `idx_pages_active` (`is_active`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES
(1, '[[regtime]]', 'contact', 'Contact', '<h1>Contact Us</h1><p>Email: <a href="mailto:admin@example.com">admin@example.com</a></p>', 'footer', NULL, 0, 1, NULL),
(2, '[[regtime]]', 'terms', 'Terms of Service', '<h1>Terms of Service</h1><p>Replace this with your actual terms.</p>', '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 */;

Back