Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.4.5
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Feb 18, 2012 at 12:55 PM
- -- Server version: 5.5.16
- -- PHP Version: 5.3.8
- 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: `raidrifts`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `applications`
- --
- CREATE TABLE IF NOT EXISTS `applications` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `gid` INT(11) NOT NULL,
- `uid` INT(11) NOT NULL,
- `date` datetime NOT NULL,
- `message` text NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `attempts`
- --
- CREATE TABLE IF NOT EXISTS `attempts` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `id_log` INT(11) NOT NULL,
- `id_boss` INT(11) NOT NULL,
- `start` INT(11) NOT NULL,
- `end` INT(11) NOT NULL,
- `length` INT(11) NOT NULL,
- `wipe` tinyint(1) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `boards`
- --
- CREATE TABLE IF NOT EXISTS `boards` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `id_category` INT(11) NOT NULL,
- `id_lastpost` INT(11) DEFAULT NULL,
- `id_lastpost_user` INT(11) DEFAULT NULL,
- `id_lasttopic` INT(11) DEFAULT NULL,
- `name` VARCHAR(128) NOT NULL,
- `description` VARCHAR(256) NOT NULL,
- `flags` INT(11) NOT NULL DEFAULT '0',
- `date_inserted` datetime NOT NULL,
- `date_lastpost` datetime DEFAULT NULL,
- `sort` INT(11) NOT NULL,
- `count_topics` INT(11) NOT NULL DEFAULT '0',
- `count_posts` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `bosses`
- --
- CREATE TABLE IF NOT EXISTS `bosses` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `id_raid` INT(11) NOT NULL,
- `EN` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `FR` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `DE` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `categories`
- --
- CREATE TABLE IF NOT EXISTS `categories` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(256) NOT NULL,
- `flags` INT(11) NOT NULL DEFAULT '0',
- `sort` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `guilds`
- --
- CREATE TABLE IF NOT EXISTS `guilds` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(32) NOT NULL,
- `shard` INT(11) NOT NULL,
- `faction` VARCHAR(16) NOT NULL DEFAULT 'Defiant',
- `website` VARCHAR(64) NOT NULL,
- `default_privacy` INT(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `logs`
- --
- CREATE TABLE IF NOT EXISTS `logs` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `processed` INT(11) NOT NULL DEFAULT '0',
- `hash` VARCHAR(32) NOT NULL,
- `gid` INT(11) NOT NULL,
- `notes` VARCHAR(256) NOT NULL DEFAULT '',
- `private` tinyint(1) NOT NULL DEFAULT '0',
- `uploaded` datetime NOT NULL,
- `raid_date` DATE NOT NULL,
- `vars` text NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pages`
- --
- CREATE TABLE IF NOT EXISTS `pages` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(32) NOT NULL,
- `content` text NOT NULL,
- `date_lastedit` datetime NOT NULL,
- KEY `id` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `posts`
- --
- CREATE TABLE IF NOT EXISTS `posts` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `id_topic` INT(11) NOT NULL,
- `id_user` INT(11) NOT NULL,
- `title` VARCHAR(256) DEFAULT NULL,
- `body` text NOT NULL,
- `date_inserted` datetime NOT NULL,
- `date_lastedit` datetime DEFAULT NULL,
- `edit_count` INT(11) NOT NULL DEFAULT '0',
- `edit_reason` VARCHAR(256) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `raids`
- --
- CREATE TABLE IF NOT EXISTS `raids` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `size` INT(11) NOT NULL,
- `EN` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `FR` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `DE` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `sessions`
- --
- CREATE TABLE IF NOT EXISTS `sessions` (
- `session_id` VARCHAR(40) NOT NULL DEFAULT '0',
- `ip_address` VARCHAR(16) NOT NULL DEFAULT '0',
- `user_agent` VARCHAR(50) NOT NULL,
- `last_activity` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- `user_data` text NOT NULL,
- PRIMARY KEY (`session_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `shards`
- --
- CREATE TABLE IF NOT EXISTS `shards` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(32) NOT NULL,
- `region` VARCHAR(2) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `submissions`
- --
- CREATE TABLE IF NOT EXISTS `submissions` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `type` VARCHAR(32) NOT NULL,
- `message` text NOT NULL,
- `email` VARCHAR(32) NOT NULL,
- `url` VARCHAR(64) NOT NULL,
- `submitted` datetime NOT NULL,
- `ip` VARCHAR(15) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `topics`
- --
- CREATE TABLE IF NOT EXISTS `topics` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `id_board` INT(11) NOT NULL,
- `id_user` INT(11) NOT NULL,
- `id_lastpost` INT(11) DEFAULT NULL,
- `id_lastpost_user` INT(11) DEFAULT NULL,
- `title` VARCHAR(128) NOT NULL,
- `body` text NOT NULL,
- `post_count` INT(11) NOT NULL DEFAULT '0',
- `views` INT(11) NOT NULL DEFAULT '0',
- `date_inserted` datetime NOT NULL,
- `date_lastpost` datetime DEFAULT NULL,
- `date_lastedit` datetime DEFAULT NULL,
- `edit_count` INT(11) NOT NULL DEFAULT '0',
- `edit_reason` VARCHAR(256) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `users`
- --
- CREATE TABLE IF NOT EXISTS `users` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `username` VARCHAR(16) NOT NULL,
- `password` VARCHAR(40) NOT NULL,
- `email` VARCHAR(64) NOT NULL,
- `verified` tinyint(1) NOT NULL DEFAULT '0',
- `admin` tinyint(1) NOT NULL DEFAULT '0',
- `joined` DATE NOT NULL,
- `guild` INT(11) NOT NULL DEFAULT '0',
- `rank` INT(11) NOT NULL DEFAULT '0',
- `added` datetime NOT NULL,
- `posts` INT(11) NOT NULL DEFAULT '0',
- `date_lastvisit` datetime DEFAULT NULL,
- `date_lastpost` datetime DEFAULT NULL,
- `id_lastpost` INT(11) DEFAULT NULL,
- `id_lasttopic` INT(11) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- /*!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