?HAMA

Navigation

Breadcrumbs

/ / proc / thread-self / root / proc / thread-self / root / proc / thread-self / root / var / softaculous / minibb

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 6.33 KB

/proc/thread-self/root/proc/thread-self/root/proc/thread-self/root/var/softaculous/minibb/minibb.sql

Text Base64

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

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 6 × Files: 12

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
images DIR	-	drwxr-xr-x	2026-03-30 21:03:52	Edit Download recursive recursive
php53 DIR	-	drwxr-xr-x	2026-03-30 21:03:52	Edit Download recursive recursive
php56 DIR	-	drwxr-xr-x	2026-03-30 21:03:52	Edit Download recursive recursive
php71 DIR	-	drwxr-xr-x	2026-03-30 21:03:52	Edit Download recursive recursive
php81 DIR	-	drwxr-xr-x	2026-03-30 21:03:52	Edit Download recursive recursive
php82 DIR	-	drwxr-xr-x	2026-03-30 21:03:52	Edit Download recursive recursive
clone.php	3.49 KB	lrw-r--r--	2026-03-30 12:13:32	Edit Download recursive recursive
fileindex.php	1.05 KB	lrw-r--r--	2023-03-28 15:42:00	Edit Download recursive recursive
import.php	2.95 KB	lrw-r--r--	2026-03-30 12:13:32	Edit Download recursive recursive
info.xml	3.49 KB	lrw-r--r--	2026-03-30 08:30:40	Edit Download recursive recursive
install.js	921 B	lrw-r--r--	2021-12-23 11:54:36	Edit Download recursive recursive
install.php	3.41 KB	lrw-r--r--	2026-03-30 12:13:32	Edit Download recursive recursive
install.xml	661 B	lrw-r--r--	2021-12-23 11:54:36	Edit Download recursive recursive
md5	2.62 KB	lrw-r--r--	2026-03-30 12:13:32	Edit Download recursive recursive
minibb.sql	6.33 KB	lrw-r--r--	2026-03-30 08:30:40	Edit Download recursive recursive
minibb.zip	521.18 KB	lrw-r--r--	2026-03-30 08:30:40	Edit Download recursive recursive
notes.txt	547 B	lrw-r--r--	2023-03-28 15:42:00	Edit Download recursive recursive
setup_options.php	5.41 KB	lrw-r--r--	2025-12-12 10:04:28	Edit Download recursive recursive