Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 utf8mb4 */;
- CREATE DATABASE IF NOT EXISTS `boardc_sample` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- USE `boardc_sample`;
- DROP TABLE IF EXISTS `categories`;
- CREATE TABLE `categories` (
- `id` int(32) NOT NULL,
- `name` varchar(128) NOT NULL,
- `powerlevel` int(1) NOT NULL DEFAULT '0',
- `ord` int(32) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- INSERT INTO `categories` (`id`, `name`, `powerlevel`, `ord`) VALUES
- (1, 'Main', 0, 1);
- DROP TABLE IF EXISTS `failed_logins`;
- CREATE TABLE `failed_logins` (
- `id` int(32) NOT NULL,
- `ip` varchar(32) NOT NULL,
- `attempt` tinyint(1) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `forummods`;
- CREATE TABLE `forummods` (
- `id` int(32) NOT NULL,
- `fid` int(32) NOT NULL,
- `uid` int(32) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `forums`;
- CREATE TABLE `forums` (
- `id` int(32) NOT NULL,
- `name` varchar(256) NOT NULL,
- `title` varchar(256) NOT NULL,
- `powerlevel` int(1) NOT NULL DEFAULT '0',
- `hidden` tinyint(1) NOT NULL DEFAULT '0',
- `threads` int(32) NOT NULL DEFAULT '0',
- `posts` int(32) NOT NULL DEFAULT '0',
- `category` int(32) NOT NULL DEFAULT '0',
- `ord` int(32) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- INSERT INTO `forums` (`id`, `name`, `title`, `powerlevel`, `hidden`, `threads`, `posts`, `category`, `ord`) VALUES
- (1, 'General forum', 'This is a sample description.', 0, 0, 0, 0, 1, 1),
- (2, 'General staff forum', 'For all staff members.', 2, 0, 0, 0, 1, 0);
- DROP TABLE IF EXISTS `ipbans`;
- CREATE TABLE `ipbans` (
- `id` int(32) NOT NULL,
- `ip` varchar(32) DEFAULT NULL,
- `time` int(32) DEFAULT NULL,
- `reason` varchar(255) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `jstrap`;
- CREATE TABLE `jstrap` (
- `id` int(32) NOT NULL,
- `user` int(32) NOT NULL,
- `ip` varchar(32) NOT NULL,
- `source` text NOT NULL,
- `filtered` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `misc`;
- CREATE TABLE `misc` (
- `disable` tinyint(1) NOT NULL,
- `views` int(32) NOT NULL,
- `threads` int(32) NOT NULL DEFAULT '0',
- `posts` int(32) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `online`;
- CREATE TABLE `online` (
- `id` int(32) NOT NULL,
- `user` int(32) NOT NULL,
- `ip` varchar(32) NOT NULL,
- `time` int(32) NOT NULL,
- `page` varchar(64) NOT NULL,
- `useragent` text NOT NULL,
- `forum` int(32) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `posts`;
- CREATE TABLE `posts` (
- `id` int(32) NOT NULL,
- `text` text NOT NULL,
- `time` int(32) NOT NULL,
- `thread` int(32) NOT NULL,
- `user` int(32) NOT NULL,
- `rev` int(4) NOT NULL,
- `deleted` tinyint(1) NOT NULL DEFAULT '0',
- `nohtml` tinyint(1) NOT NULL DEFAULT '0',
- `nosmilies` tinyint(1) NOT NULL DEFAULT '0',
- `nolayout` tinyint(1) NOT NULL DEFAULT '0',
- `lastedited` int(32) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `posts_old`;
- CREATE TABLE `posts_old` (
- `id` int(32) NOT NULL,
- `pid` int(32) NOT NULL,
- `text` text NOT NULL,
- `time` int(32) NOT NULL,
- `rev` int(4) NOT NULL,
- `nohtml` tinyint(1) NOT NULL DEFAULT '0',
- `nosmilies` tinyint(1) NOT NULL DEFAULT '0',
- `nolayout` tinyint(1) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Old revisions of posts are stored here';
- DROP TABLE IF EXISTS `ratings`;
- CREATE TABLE `ratings` (
- `id` int(32) NOT NULL,
- `userfrom` int(32) NOT NULL,
- `userto` int(32) NOT NULL,
- `rating` int(4) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `test`;
- CREATE TABLE `test` (
- `id` int(32) NOT NULL,
- `name` varchar(255) DEFAULT NULL,
- `time` date DEFAULT NULL,
- `ptext` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `themes`;
- CREATE TABLE `themes` (
- `id` int(11) NOT NULL,
- `name` varchar(64) NOT NULL,
- `file` varchar(64) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `themes` (`id`, `name`, `file`) VALUES
- (0, 'Default', 'default.css'),
- (1, 'Night (Jul)', 'night.css');
- DROP TABLE IF EXISTS `threads`;
- CREATE TABLE `threads` (
- `id` int(32) NOT NULL,
- `name` varchar(255) NOT NULL,
- `title` varchar(255) NOT NULL,
- `time` int(32) NOT NULL,
- `forum` int(32) NOT NULL,
- `user` int(32) NOT NULL,
- `sticky` tinyint(1) NOT NULL,
- `closed` tinyint(1) NOT NULL,
- `views` int(32) NOT NULL DEFAULT '0',
- `replies` int(32) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `tor`;
- CREATE TABLE `tor` (
- `id` int(32) NOT NULL,
- `ip` varchar(32) NOT NULL,
- `time` int(32) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `users`;
- CREATE TABLE `users` (
- `id` int(32) NOT NULL,
- `name` varchar(32) NOT NULL,
- `displayname` varchar(255) DEFAULT NULL,
- `title` varchar(255) DEFAULT NULL,
- `password` varchar(255) NOT NULL,
- `powerlevel` int(1) NOT NULL DEFAULT '0',
- `sex` int(1) NOT NULL DEFAULT '2',
- `namecolor` varchar(6) DEFAULT NULL,
- `lastip` varchar(32) DEFAULT NULL,
- `ban_expire` int(32) DEFAULT '0',
- `since` int(32) NOT NULL DEFAULT '0',
- `ppp` int(3) NOT NULL DEFAULT '25',
- `tpp` int(3) NOT NULL DEFAULT '25',
- `head` text,
- `sign` text,
- `dateformat` varchar(32) DEFAULT NULL,
- `timeformat` varchar(32) DEFAULT NULL,
- `lastview` int(32) NOT NULL DEFAULT '0',
- `lastforum` int(32) NOT NULL DEFAULT '0',
- `bio` text,
- `posts` int(32) NOT NULL DEFAULT '0',
- `threads` int(32) NOT NULL DEFAULT '0',
- `email` varchar(64) NOT NULL,
- `homepage` varchar(64) NOT NULL,
- `youtube` varchar(64) NOT NULL,
- `twitter` varchar(64) NOT NULL,
- `facebook` varchar(64) NOT NULL,
- `homepage_name` varchar(64) NOT NULL,
- `tzoff` int(2) NOT NULL DEFAULT '0',
- `realname` varchar(64) NOT NULL,
- `location` varchar(64) NOT NULL,
- `birthday` int(32) NOT NULL DEFAULT '0',
- `theme` int(8) NOT NULL DEFAULT '0',
- `showhead` tinyint(1) NOT NULL DEFAULT '1',
- `signsep` int(3) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- ALTER TABLE `categories`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `failed_logins`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `forummods`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `forums`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `ipbans`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `jstrap`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `online`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `id` (`id`);
- ALTER TABLE `posts`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `posts_old`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `ratings`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `test`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `themes`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `threads`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `tor`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `users`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `categories`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- ALTER TABLE `failed_logins`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `forummods`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `forums`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- ALTER TABLE `ipbans`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `jstrap`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `online`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `posts`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `posts_old`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `ratings`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `test`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `threads`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `tor`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `users`
- MODIFY `id` int(32) NOT NULL AUTO_INCREMENT;
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement