File manager

File manager - Edit - /var/softaculous/minibb/minibb.sql

Back
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: `minibb372` -- -- -------------------------------------------------------- -- -- Table structure for table `minibbtable_banned` -- CREATE TABLE `minibbtable_banned` ( `id` int(10) NOT NULL AUTO_INCREMENT, `banip` varchar(45) NOT NULL DEFAULT '', `banreason` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `banwhen` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `minibbtable_failedlogin` -- CREATE TABLE `minibbtable_failedlogin` ( `forced_id` int(10) NOT NULL, `forced_username` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `forced_ip` varchar(45) NOT NULL, `forced_amount` int(2) NOT NULL, `blocked_until` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `minibbtable_forums` -- CREATE TABLE `minibbtable_forums` ( `forum_id` int(10) NOT NULL AUTO_INCREMENT, `forum_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `forum_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `forum_order` int(10) NOT NULL DEFAULT '0', `forum_icon` varchar(255) NOT NULL DEFAULT 'default.gif', `topics_count` int(10) NOT NULL DEFAULT '0', `posts_count` int(10) NOT NULL DEFAULT '0', `forum_group` varchar(150) NOT NULL DEFAULT '', PRIMARY KEY (`forum_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `minibbtable_posts` -- CREATE TABLE `minibbtable_posts` ( `post_id` int(10) NOT NULL AUTO_INCREMENT, `forum_id` int(10) NOT NULL DEFAULT '1', `topic_id` int(10) NOT NULL DEFAULT '1', `poster_id` int(10) NOT NULL DEFAULT '0', `poster_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Guest', `post_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `post_time` datetime DEFAULT NULL, `poster_ip` varchar(45) NOT NULL DEFAULT '', `post_status` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`post_id`), KEY `forum_id` (`forum_id`), KEY `topic_id` (`topic_id`), KEY `poster_id` (`poster_id`), KEY `poster_ip` (`poster_ip`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `minibbtable_send_mails` -- CREATE TABLE `minibbtable_send_mails` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '1', `topic_id` int(11) NOT NULL DEFAULT '0', `active` int(1) unsigned NOT NULL DEFAULT '1', `email_code` varchar(10) DEFAULT NULL, `post_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `topic_id` (`topic_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `minibbtable_topics` -- CREATE TABLE `minibbtable_topics` ( `topic_id` int(10) NOT NULL AUTO_INCREMENT, `topic_title` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `topic_poster` int(10) NOT NULL DEFAULT '0', `topic_poster_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Guest', `topic_time` datetime DEFAULT NULL, `topic_views` int(10) NOT NULL DEFAULT '0', `forum_id` int(10) NOT NULL DEFAULT '1', `topic_status` tinyint(1) NOT NULL DEFAULT '0', `topic_last_post_id` int(10) NOT NULL DEFAULT '1', `posts_count` int(10) NOT NULL DEFAULT '0', `sticky` int(1) NOT NULL DEFAULT '0', `topic_last_post_time` datetime DEFAULT NULL, `topic_last_poster` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`topic_id`), KEY `forum_id` (`forum_id`), KEY `topic_last_post_id` (`topic_last_post_id`), KEY `sticky` (`sticky`), KEY `posts_count` (`posts_count`), KEY `topic_last_post_time` (`topic_last_post_time`), KEY `topic_views` (`topic_views`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `minibbtable_users` -- CREATE TABLE `minibbtable_users` ( `user_id` int(10) NOT NULL AUTO_INCREMENT, `username` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_regdate` datetime DEFAULT NULL, `user_password` varchar(32) NOT NULL DEFAULT '', `user_email` varchar(100) NOT NULL DEFAULT '', `user_icq` varchar(256) NOT NULL DEFAULT '', `user_website` varchar(100) NOT NULL DEFAULT '', `user_occ` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_from` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_interest` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_viewemail` tinyint(1) NOT NULL DEFAULT '0', `user_sorttopics` tinyint(1) NOT NULL DEFAULT '0', `user_newpwdkey` varchar(32) NOT NULL DEFAULT '', `user_newpasswd` varchar(32) NOT NULL DEFAULT '', `language` char(3) NOT NULL DEFAULT '', `activity` int(1) NOT NULL DEFAULT '1', `num_topics` int(10) unsigned NOT NULL DEFAULT '0', `num_posts` int(10) unsigned NOT NULL DEFAULT '0', `user_custom1` varchar(256) NOT NULL DEFAULT '', `user_custom2` varchar(256) NOT NULL DEFAULT '', `user_custom3` varchar(256) NOT NULL DEFAULT '', PRIMARY KEY (`user_id`), KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `minibbtable_users` -- INSERT INTO `minibbtable_users` VALUES (1, '[[admin_username]]', '[[regtime]]', '[[admin_pass]]', '[[admin_email]]', '', '', '', '', '', 0, 0, '', '', '', 1, 0, 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 /;

| ver. 1.4 | Github | . | PHP 7.0.33 | Generation time: 0.18 | proxy | phpinfo | Settings