RaidRifts Schema

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