<?php 

/**
* @author	Thomas Hambach - thomas@rdlt.com
* @website	www.clancommandcenter.com
* @package	ClanCommandCenter
*
* Copyright (C) 2007  ClanCommandCenter
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
* 
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
* 
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
* 
*/

if(!defined('in_installer')) die('access to this file is forbidden');
?>
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- --------------------------------------------------------
DROP TABLE IF EXISTS `access`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `access` (
  `module` mediumint(5) NOT NULL default '0',
  `view` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `comment` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `moderatecomment` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `add` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `modify` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `admin` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `accesslevel` mediumint(5) NOT NULL default '0',
  KEY `module` (`module`,`accesslevel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
INSERT INTO `access` (`module`, `view`, `comment`, `moderatecomment`, `add`, `modify`, `admin`, `accesslevel`) VALUES
(0, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(7, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(12, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(4, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(18, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(20, 'Y', 'N', 'Y', 'N', 'N', 'N', 1),
(6, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(21, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(8, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(15, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(11, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(5, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(10, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(17, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(2, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(1, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(1, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(2, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(3, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(4, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(5, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(6, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(7, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(8, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(9, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(11, 'Y', 'N', 'N', 'N', 'N', 'N', 2),
(10, 'Y', 'N', 'N', 'N', 'N', 'N', 2),
(12, 'Y', 'N', 'N', 'N', 'N', 'N', 2),
(13, 'Y', 'N', 'N', 'N', 'N', 'Y', 2),
(14, 'Y', 'N', 'N', 'N', 'N', 'N', 2),
(15, 'Y', 'N', 'N', 'N', 'N', 'N', 2),
(16, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(1, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(17, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(14, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(18, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(7, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(12, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(4, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(18, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(20, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(6, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(21, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(8, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(15, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(11, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(5, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(24, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(10, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(17, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(2, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(1, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(3, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(19, 'N', 'N', 'N', 'N', 'N', 'N', 2),
(16, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(13, 'Y', 'N', 'N', 'N', 'N', 'Y', 1),
(20, 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 2),
(23, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(9, 'Y', 'N', 'N', 'N', 'N', 'N', 1),
(21, 'Y', 'Y', 'N', 'N', 'N', 'N', 2),
(14, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(3, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(1, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(2, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(3, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(4, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(5, 'N', 'Y', 'N', 'N', 'N', 'N', 0),
(6, 'N', 'N', 'Y', 'N', 'N', 'N', 0),
(7, 'N', 'N', 'N', 'N', 'N', 'Y', 0),
(8, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(9, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(10, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(11, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(12, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(13, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(14, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(15, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(16, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(17, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(18, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(19, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(20, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(21, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(22, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(23, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(24, 'Y', 'N', 'N', 'N', 'N', 'N', 0),
(4, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(18, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(20, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(28, 'N', 'N', 'N', 'N', 'N', 'Y', 5),
(27, 'N', 'N', 'Y', 'N', 'N', 'N', 5),
(26, 'N', 'Y', 'N', 'N', 'N', 'N', 5),
(25, 'Y', 'N', 'N', 'N', 'N', 'N', 5),
(21, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(8, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(15, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(11, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(5, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(24, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(10, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(17, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(2, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(1, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(16, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(23, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(14, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(3, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(13, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(9, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(19, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(13, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(9, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(19, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(22, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 3),
(7, 'Y', 'N', 'N', 'N', 'N', 'N', 4),
(12, 'N', 'Y', 'N', 'N', 'N', 'N', 4),
(4, 'Y', 'N', 'N', 'N', 'N', 'N', 4),
(18, 'Y', 'N', 'N', 'N', 'N', 'N', 4),
(20, 'N', 'N', 'Y', 'N', 'N', 'Y', 4),
(6, 'N', 'N', 'Y', 'N', 'N', 'N', 4),
(21, 'Y', 'N', 'N', 'N', 'N', 'N', 4),
(8, 'N', 'Y', 'N', 'N', 'N', 'N', 4),
(15, 'Y', 'N', 'N', 'N', 'N', 'N', 4),
(11, 'Y', 'N', 'N', 'N', 'N', 'N', 4),
(5, 'N', 'Y', 'N', 'N', 'N', 'N', 4),
(24, 'N', 'N', 'N', 'N', 'N', 'Y', 4),
(10, 'N', 'N', 'N', 'N', 'N', 'Y', 4),
(17, 'N', 'N', 'Y', 'N', 'N', 'N', 4),
(2, 'N', 'N', 'Y', 'N', 'N', 'N', 4),
(1, 'N', 'Y', 'N', 'N', 'N', 'N', 4),
(16, 'N', 'Y', 'N', 'N', 'N', 'N', 4),
(23, 'N', 'N', 'Y', 'N', 'N', 'N', 4),
(7, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(12, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 5),
(7, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(12, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(4, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(18, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(20, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(6, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(21, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(8, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(15, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(11, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(5, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(24, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(10, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(17, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(2, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(1, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(16, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(23, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(14, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(3, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(13, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(9, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(19, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(22, 'Y', 'Y', 'Y', 'N', 'N', 'Y', 6),
(14, 'N', 'N', 'N', 'N', 'N', 'Y', 4),
(3, 'N', 'N', 'N', 'N', 'N', 'Y', 4),
(13, 'N', 'N', 'Y', 'N', 'N', 'N', 4),
(9, 'N', 'N', 'Y', 'N', 'N', 'N', 4),
(19, 'N', 'Y', 'N', 'N', 'N', 'N', 4),
(22, 'N', 'Y', 'N', 'N', 'N', 'N', 4);
-- --------------------------------------------------------
DROP TABLE IF EXISTS `accesslevels`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `accesslevels` (
  `id` mediumint(5) NOT NULL auto_increment,
  `superadmin` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
INSERT INTO `accesslevels` (`id`, `superadmin`, `name`, `description`) VALUES
(1, 'N', 'Guest profile', 'This level is assigned to a surfer that is not signed in.'),
(2, 'N', 'Site member', 'This level is assigned to someone that is registered on the website but is not a part of the clan.'),
(3, 'N', 'Clan recruit', ''),
(4, 'N', 'Match Manager', ''),
(5, 'N', 'Clan Co-Leader', ''),
(6, 'Y', 'Clan Leader', '');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `banned`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `banned` (
  `id` mediumint(5) NOT NULL auto_increment,
  `ip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `reason` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `date` int(12) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `blockpositions`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `blockpositions` (
  `block` smallint(5) unsigned NOT NULL,
  `template` smallint(5) unsigned NOT NULL,
  `order` smallint(5) unsigned NOT NULL,
  `column` smallint(5) unsigned NOT NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=182 ;
-- --------------------------------------------------------
INSERT INTO `blockpositions` (`block`, `template`, `order`, `column`, `id`) VALUES
(7, 1, 4, 2, 181),
(13, 1, 3, 2, 180),
(6, 1, 2, 2, 179),
(5, 1, 1, 2, 178),
(9, 1, 0, 2, 177),
(2, 1, 3, 1, 176),
(4, 1, 2, 1, 175),
(8, 1, 1, 1, 174),
(1, 1, 0, 1, 173);
-- --------------------------------------------------------
DROP TABLE IF EXISTS `blocks`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `blocks` (
  `id` mediumint(5) NOT NULL auto_increment,
  `name` varchar(75) collate utf8_unicode_ci default NULL,
  `description` varchar(250) collate utf8_unicode_ci default NULL,
  `identifier` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `variables` text collate utf8_unicode_ci NOT NULL,
  `active` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `author` varchar(255) collate utf8_unicode_ci NOT NULL,
  `authorweb` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `active` (`active`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
INSERT INTO `blocks` (`id`, `name`, `description`, `identifier`, `variables`, `active`, `author`, `authorweb`) VALUES
(1, 'Main menu', 'Displays the main menu', 'menu', 'type=main', 'Y', '', ''),
(2, 'Shoutbox', 'Display a shoutbox where people can add their message', 'shoutbox', 'items=7\r\ndateformat=d/m/y H:i', 'Y', '', ''),
(4, 'Headlines', 'Display the latest headlines', 'news', 'items=5\r\ndateformat=d-m-Y', 'Y', '', ''),
(5, 'Upcoming matches', 'Displays the upcoming matches', 'matches', 'dateformat=d/m/Y\r\nitems=5\r\ntype=upcoming', 'Y', '', ''),
(6, 'Matches', 'Displays recently played matches', 'matches', 'dateformat=d/m/Y\r\nitems=5', 'Y', '', ''),
(7, 'Statistics', 'Displays brief website statistics', 'statistics', '', 'Y', '', ''),
(8, 'Sub menu', 'Displays the sub menu', 'menu', 'type=submenu', 'Y', '', ''),
(9, 'Log in', 'Displays a log in / user control panel', 'login', '', 'Y', '', ''),
(13, 'Squads', 'Displays squad photos', 'squads', '', 'Y', '', ''),
(12, 'Member blogs', 'Display the latest member blogs', 'blogs', '', 'N', '', '');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `categories`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint(15) NOT NULL auto_increment,
  `type` enum('ccc','download','link','gallery','shop','avatar') collate utf8_unicode_ci NOT NULL default 'ccc',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci NOT NULL,
  `parent` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `parent` (`parent`),
  KEY `site` (`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=567 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `categoryitems`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `categoryitems` (
  `id` bigint(15) NOT NULL auto_increment,
  `category` bigint(15) NOT NULL default '0',
  `order` mediumint(9) NOT NULL default '1',
  `status` enum('published','banned','pending') collate utf8_unicode_ci NOT NULL default 'published',
  `author` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `author_email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `valid` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `validcode` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `file` text collate utf8_unicode_ci NOT NULL,
  `date` bigint(15) NOT NULL default '0',
  `type` enum('sponsor','avatar','shop','gallery','download','link') collate utf8_unicode_ci NOT NULL default 'link',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci NOT NULL,
  `rating` mediumint(2) NOT NULL default '5',
  `url` text collate utf8_unicode_ci NOT NULL,
  `displayurl` text collate utf8_unicode_ci NOT NULL,
  `backlink` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `category` (`category`),
  KEY `status` (`status`,`author_email`,`validcode`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=644 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `form`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `form` (
  `id` mediumint(3) NOT NULL auto_increment,
  `name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `ident` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
INSERT INTO `form` (`id`, `name`, `ident`, `description`) VALUES
(1, 'My profile', 'myprofile', '');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `formfield`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `formfield` (
  `id` int(8) NOT NULL auto_increment,
  `formid` mediumint(3) NOT NULL default '0',
  `order` mediumint(2) NOT NULL default '1',
  `name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `text` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(150) collate utf8_unicode_ci NOT NULL default '',
  `type` enum('spacer','text','password','textarea','select','radio','checkbox','date') collate utf8_unicode_ci NOT NULL default 'text',
  `values` text collate utf8_unicode_ci NOT NULL,
  `maxlength` mediumint(3) NOT NULL default '255',
  `minlength` mediumint(3) NOT NULL default '0',
  `limitchars` enum('any','alpha','numeric','alphanumeric') collate utf8_unicode_ci NOT NULL default 'any',
  PRIMARY KEY  (`id`),
  KEY `formid` (`formid`),
  KEY `order` (`order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=39 ;
-- --------------------------------------------------------
INSERT INTO `formfield` (`id`, `formid`, `order`, `name`, `text`, `description`, `type`, `values`, `maxlength`, `minlength`, `limitchars`) VALUES
(1, 1, 1, 'email', 'E-mail', 'Your e-mail address', 'text', '', 255, 6, 'any'),
(2, 1, 3, 'newpassword', 'New password', 'If you wish to change your password, type your new password in this field', 'password', '', 30, 0, 'any'),
(3, 1, 4, 'newpasswordconfirmation', 'New password confirmation', 'Please confirm your new password by typing it in again', 'password', '', 30, 0, 'any'),
(4, 1, 5, 'password', 'Current password', 'If you wish to change your password, type in your current password', 'password', '', 255, 0, 'any'),
(5, 1, 2, '', 'Password', '', 'spacer', '', 255, 0, 'any'),
(6, 1, 6, 'name', 'Name', '', 'text', '', 255, 0, 'any'),
(7, 1, 6, 'Gender', 'Gender', '', 'select', 'M<Male>F<Female>O<Private', 255, 0, 'any'),
(8, 1, 5, '', 'General information', '', 'spacer', '', 255, 0, 'any'),
(9, 1, 6, 'location', 'Location', '', 'text', '', 100, 0, 'any'),
(10, 1, 6, '', 'Other information', '', 'spacer', '', 255, 0, 'any'),
(11, 1, 6, 'website', 'Website', '', 'text', '', 255, 0, 'any'),
(12, 1, 6, 'xfire', 'Xfire', '', 'text', '', 255, 0, 'any'),
(13, 1, 6, 'msnm', 'MSN', '', 'text', '', 255, 0, 'any'),
(14, 1, 6, 'yahoo', 'Yahoo IM', '', 'text', '', 255, 0, 'any'),
(15, 1, 6, 'icq', 'ICQ', '', 'text', '', 255, 0, 'numeric'),
(17, 1, 6, 'aim', 'AIM', '', 'text', '', 255, 0, 'any'),
(18, 1, 6, 'birthday', 'Birthday', '', 'date', '', 255, 0, 'any'),
(19, 1, 6, 'FavFood', 'Favorite food', '', 'text', '', 255, 0, 'any'),
(20, 1, 6, 'FavDrink', 'Favorite drink', '', 'text', '', 255, 0, 'any'),
(21, 1, 6, 'FavMovie', 'Favorite movie', '', 'text', '', 255, 0, 'any'),
(22, 1, 6, 'FavGame', 'Favorite game', '', 'text', '', 255, 0, 'any'),
(23, 0, 1, 'FavMap', 'Favorite map', '', 'text', '', 255, 0, 'any'),
(24, 1, 7, '', 'Clan information', '', 'spacer', '', 255, 0, 'any'),
(25, 1, 7, 'clan', 'Clan name', '', 'text', '', 255, 0, 'any'),
(26, 0, 1, 'clantag', 'Clan tag', '', 'text', '', 255, 0, 'any'),
(27, 1, 7, 'clantag', 'Clan tag', '', 'text', '', 255, 0, 'any'),
(28, 1, 7, 'clanwebsite', 'Clan website', '', 'text', '', 255, 0, 'any'),
(29, 1, 8, '', 'Computer information', '', 'spacer', '', 255, 0, 'any'),
(30, 1, 8, 'VGA', 'Video card', '', 'text', '', 255, 0, 'any'),
(31, 1, 8, 'CPU', 'CPU', '', 'text', '', 255, 0, 'any'),
(32, 1, 8, 'Soundcard', 'Soundcard', '', 'text', '', 255, 0, 'any'),
(33, 1, 8, 'Mouse', 'Mouse', '', 'text', '', 255, 0, 'any'),
(34, 1, 8, 'Keyboard', 'Keyboard', '', 'text', '', 255, 0, 'any'),
(35, 1, 8, 'Memory', 'Memory', '', 'text', '', 255, 0, 'any'),
(36, 1, 8, 'Connection', 'Connection', '', 'text', '', 255, 0, 'any'),
(38, 1, 5, 'country', 'Country', '', 'select', '', 3, 0, 'any');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `forum_categories`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `forum_categories` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(200) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `order` mediumint(8) unsigned NOT NULL default '0',
  `description` text character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `CategoriesOrder` (`order`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-- --------------------------------------------------------
INSERT INTO `forum_categories` (`id`, `name`, `order`, `description`) VALUES
(1, 'Test Category', 1, 'This is just an example forum category');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `forum_forums`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `forum_forums` (
  `id` mediumint(5) unsigned NOT NULL auto_increment,
  `categoryid` mediumint(8) unsigned NOT NULL default '0',
  `name` varchar(150) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `description` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `topics` mediumint(10) unsigned NOT NULL default '0',
  `posts` mediumint(10) unsigned NOT NULL default '0',
  `status` tinyint(1) unsigned NOT NULL default '0',
  `order` smallint(5) unsigned NOT NULL default '0',
  `password` varchar(32) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `redirect` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `ForumsOrder` (`order`),
  KEY `ForumsCategory` (`categoryid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
INSERT INTO `forum_forums` (`id`, `categoryid`, `name`, `description`, `topics`, `posts`, `status`, `order`, `password`, `redirect`) VALUES
(1, 1, 'Example forum', 'This is just an example forum', 0, 0, 0, 1, '', '');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `forum_moderators`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `forum_moderators` (
  `memberid` bigint(15) NOT NULL default '0',
  `forumid` mediumint(5) NOT NULL default '0',
  `edit` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `delete` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `merge` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `warn` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `type` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `status` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  KEY `memberid` (`memberid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `forum_topics`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `forum_topics` (
  `id` bigint(15) NOT NULL auto_increment,
  `title` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `forumid` bigint(15) NOT NULL default '0',
  `postid` bigint(15) NOT NULL default '0',
  `posterid` bigint(15) NOT NULL default '0',
  `date` int(12) NOT NULL default '0',
  `type` enum('announcement','pinned','normal') collate utf8_unicode_ci NOT NULL default 'normal',
  `closed` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `deleted` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `lastpost` bigint(15) NOT NULL default '0',
  `views` bigint(10) NOT NULL default '0',
  `posts` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `postid` (`postid`,`type`),
  KEY `forumid` (`forumid`),
  KEY `posterid` (`posterid`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `languages`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `languages` (
  `isocode` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  UNIQUE KEY `isocode` (`isocode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
INSERT INTO `languages` (`isocode`, `name`) VALUES
('en', 'English'),
('nl', 'Nederlands');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `logmonthly`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `logmonthly` (
  `year` mediumint(4) NOT NULL default '0',
  `month` tinyint(4) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `visits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`year`,`month`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `logrequests`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `logrequests` (
  `ip` int(11) NOT NULL default '0',
  `uri` text collate utf8_unicode_ci NOT NULL,
  `uri_encoded` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `referer` text collate utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `memberid` bigint(15) NOT NULL default '0',
  KEY `ip` (`ip`,`date`,`memberid`),
  KEY `uri_encoded` (`uri_encoded`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `logvisits`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `logvisits` (
  `ip` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `referer` text collate utf8_unicode_ci NOT NULL,
  `uri` text collate utf8_unicode_ci NOT NULL,
  `uri_encoded` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `memberid` bigint(15) NOT NULL default '0',
  `method` enum('POST','GET') collate utf8_unicode_ci NOT NULL default 'POST',
  `agent` text collate utf8_unicode_ci NOT NULL,
  KEY `ip` (`ip`,`date`,`memberid`),
  KEY `uri_encoded` (`uri_encoded`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `matches`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `matches` (
  `id` bigint(15) NOT NULL auto_increment,
  `opponentid` mediumint(5) NOT NULL default '0',
  `maps` text collate utf8_unicode_ci NOT NULL,
  `galleryid` bigint(15) NOT NULL default '0',
  `demo` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
  `matchtype` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `gametype` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `date` int(12) NOT NULL default '0',
  `squadid` mediumint(5) NOT NULL default '0',
  `score` mediumint(6) NOT NULL default '0',
  `opponentscore` mediumint(6) NOT NULL default '0',
  `report` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `opponentid` (`opponentid`,`squadid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `members`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `members` (
  `id` bigint(15) NOT NULL auto_increment,
  `accesslevel` mediumint(5) NOT NULL default '0',
  `posts` mediumint(5) NOT NULL default '0',
  `username` varchar(75) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `logincode` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `gender` enum('M','F','O') collate utf8_unicode_ci NOT NULL default 'F',
  `socialstatus` enum('single','single and looking','in relationship','married','widow','rather not say') collate utf8_unicode_ci NOT NULL default 'rather not say',
  `location` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `country` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `status` enum('active','banned','pending') collate utf8_unicode_ci NOT NULL default 'pending',
  `registrationdate` int(12) NOT NULL default '0',
  `lastlogindate` int(12) NOT NULL default '0',
  `lastseendate` int(12) NOT NULL default '0',
  `lastadminaction` int(11) NOT NULL default '0',
  `avatar` text collate utf8_unicode_ci NOT NULL,
  `signature` text collate utf8_unicode_ci NOT NULL,
  `website` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `xfire` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `msnm` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `aim` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `icq` bigint(20) default NULL,
  `yahoo` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `birthday` date NOT NULL default '0000-00-00',
  `clan` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `clantag` varchar(75) collate utf8_unicode_ci NOT NULL default '',
  `clanwebsite` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `showavatars` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `showsignatures` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `favfood` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `favmovie` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `favgame` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `favdrink` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `favmap` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `cpu` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `vga` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `soundcard` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `soundsystem` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `mouse` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `keyboard` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `memory` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `monitor` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `connection` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `accesslevel` (`accesslevel`,`country`),
  KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=44 ;
-- --------------------------------------------------------
INSERT INTO `members` (`id`, `accesslevel`, `posts`, `username`, `email`, `password`, `logincode`, `name`, `gender`, `socialstatus`, `location`, `country`, `status`, `registrationdate`, `lastlogindate`, `lastseendate`, `lastadminaction`, `avatar`, `signature`, `website`, `xfire`, `msnm`, `aim`, `icq`, `yahoo`, `birthday`, `clan`, `clantag`, `clanwebsite`, `showavatars`, `showsignatures`, `favfood`, `favmovie`, `favgame`, `favdrink`, `favmap`, `cpu`, `vga`, `soundcard`, `soundsystem`, `mouse`, `keyboard`, `memory`, `monitor`, `connection`) VALUES
(1, 6, 0, 'Admin', 'admin@website.com', '', '', '', 'M', 'rather not say', '', '', 'active', 0, 0, 0, 0, '', '', '', '', '', '', 0, '', '', '', '', '', 'Y', 'Y', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `menucontent`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `menucontent` (
  `id` mediumint(5) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `url` text collate utf8_unicode_ci NOT NULL,
  `hidden` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `order` mediumint(5) NOT NULL default '0',
  `type` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `hidden` (`hidden`,`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
INSERT INTO `menucontent` (`id`, `name`, `description`, `url`, `hidden`, `order`, `type`) VALUES
(1, 'News', 'View the latest news', '', 'N', 1, 'main'),
(2, 'News archives', 'browse our news archives', 'index.php?module=news', 'N', 2, 'main'),
(3, 'Matches', 'matches', 'index.php?module=matches', 'N', 3, 'main'),
(4, 'Squads', 'Squads', 'index.php?module=squads', 'N', 5, 'main'),
(5, 'Upcoming matches', 'Upcoming matches', 'index.php?module=matches&action=upcoming', 'N', 4, 'main'),
(6, 'Servers', 'Our clan''s servers', 'index.php?module=servers', 'N', 4, 'submenu'),
(7, 'Website statistics', 'Advanced website statistics', 'index.php?module=statistics', 'N', 5, 'submenu'),
(8, 'Forum', 'Forum', 'index.php?module=forum', 'N', 6, 'main'),
(9, 'Site members', 'Site members', 'index.php?module=profiles', 'N', 5, 'submenu'),
(10, 'Opponents', 'Opponents', 'index.php?module=opponents', 'N', 2, 'submenu'),
(11, 'Sponsors', 'Sponsors', 'index.php?module=sponsors', 'N', 3, 'submenu');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `modules`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `modules` (
  `id` mediumint(5) NOT NULL auto_increment,
  `module` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `adminname` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `author` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `authorweb` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `version` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `active` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `frontend` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `backend` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `taborder` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `active` (`active`),
  KEY `module` (`module`),
  KEY `frontend` (`frontend`),
  KEY `backend` (`backend`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=25 ;
-- --------------------------------------------------------
INSERT INTO `modules` (`id`, `module`, `name`, `adminname`, `description`, `author`, `authorweb`, `version`, `active`, `frontend`, `backend`, `taborder`) VALUES
(1, 'index', 'News', 'News', 'News overview', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'N', 1),
(2, 'news', 'News archives', 'News', 'News archives', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'Y', 1),
(3, 'matches', 'Matches', 'Matches', 'Matches', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'Y', 1),
(4, 'squads', 'Squads', '', 'Squads', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'Y', 1),
(5, 'profiles', 'Profiles', 'Users', 'List of all members & profile details', '', '', '', 'Y', 'Y', 'Y', 1),
(6, 'shoutbox', 'Shoutbox', '', 'Shoutbox', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'Y', 1),
(7, 'statistics', 'Website Statistics', '', 'Advanced Website Statistics', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'N', 1),
(8, 'servers', 'Servers', '', 'Clan servers', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'Y', 1),
(9, 'forum', 'Forums', 'Forum', 'Clan forums', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'Y', 1),
(10, 'posts', 'Post', '', 'Add a comment, write a new topic or reply to a topic', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'N', 1),
(11, 'register', 'Register', '', 'Registration', 'ClanCommandCenter', 'ClanCommandCenter.com', '1.0', 'Y', 'Y', 'N', 1),
(12, 'validate', 'Validate', '', 'Validate your account', 'ClanCommandCenter', '', '1.0', 'Y', 'Y', 'N', 1),
(13, 'login', 'Login', '', 'login', '', '', '', 'Y', 'Y', 'N', 1),
(15, 'rss', 'RSS feed', '', 'rss', '', '', '', 'Y', 'Y', 'N', 1),
(16, 'mycontrolpanel', 'My control panel', '', 'My control panel', '', '', '', 'Y', 'Y', 'N', 1),
(17, 'opponents', 'Opponents', '', 'Opponents', '', '', '', 'Y', 'Y', 'Y', 1),
(18, 'sponsors', 'Sponsors', '', 'Sponsors', '', '', '', 'Y', 'Y', 'Y', 1),
(19, 'dashboard', 'Dashboard', '', 'Dashboard', '', '', '', 'Y', 'N', 'Y', 0),
(20, 'smilies', 'Smilies', 'Smilies', 'Smilies', '', '', '', 'Y', 'Y', 'N', 1),
(21, 'settings', 'settings', 'Settings', 'settings', '', '', '', 'Y', 'N', 'Y', 20),
(22, 'accesslevels', 'Access levels', 'Access Levels', '', '', '', '', 'Y', 'N', 'Y', 21),
(23, 'modules', 'Modules', 'Modules', 'Modules', '', '', '', 'Y', 'N', 'Y', 22),
(24, 'presentation', 'Presentation', 'Presentation', 'Presentation', 'Clan Command Center', 'http://www.clancommandcenter.com', '1.0', 'Y', 'N', 'Y', 23);
-- --------------------------------------------------------
DROP TABLE IF EXISTS `news`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `news` (
  `id` bigint(15) NOT NULL auto_increment,
  `title` varchar(250) collate utf8_unicode_ci NOT NULL default '',
  `date` int(12) NOT NULL default '0',
  `country` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `categoryId` mediumint(5) NOT NULL default '0',
  `posterId` bigint(15) NOT NULL default '0',
  `squadId` mediumint(5) NOT NULL default '0',
  `published` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `country` (`country`,`categoryId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
INSERT INTO `news` (`id`, `title`, `date`, `country`, `categoryId`, `posterId`, `squadId`, `published`) VALUES
(1, 'ClanCommandCenter was installed', 1184812507, '0', 0, 1, 0, 'Y');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `newscategories`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `newscategories` (
  `id` mediumint(5) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `opponents`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `opponents` (
  `id` mediumint(5) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `tag` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `country` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `website` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `irc` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `country` (`country`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `posts`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `posts` (
  `id` bigint(15) NOT NULL auto_increment,
  `posterid` bigint(15) NOT NULL default '0',
  `relationId` bigint(15) NOT NULL default '0',
  `relationType` varchar(20) collate utf8_unicode_ci NOT NULL default 'reply',
  `date` bigint(12) NOT NULL default '0',
  `read` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `deleted` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `ip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `lastedit` int(12) NOT NULL default '0',
  `text` text collate utf8_unicode_ci NOT NULL,
  `title` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `bb_code` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `smilies` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `signature` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  `avatar` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'Y',
  PRIMARY KEY  (`id`),
  KEY `relationId` (`relationId`,`relationType`,`date`),
  KEY `posterid` (`posterid`),
  KEY `read` (`read`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
INSERT INTO `posts` (`id`, `posterid`, `relationId`, `relationType`, `date`, `read`, `deleted`, `ip`, `lastedit`, `text`, `title`, `bb_code`, `smilies`, `signature`, `avatar`) VALUES
(1, 1, 1, 'newspost', 45208, 'N', 'Y', '127.0.0.1', 1200170797, 'ClanCommandCenter [url=http://www.clancommandcenter.com]clan cms[/url] has now been installed on your hosting package.\r\nThank you for choosing ClanCommandCenter to power your clan website!', 'ClanCommandCenter was installed', 'Y', 'Y', 'Y', 'Y');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `ranks`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `ranks` (
  `id` mediumint(5) NOT NULL auto_increment,
  `order` mediumint(5) NOT NULL default '0',
  `name` varchar(75) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
INSERT INTO `ranks` (`id`, `order`, `name`, `description`) VALUES
(1, 0, 'Clan Leader', '');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `servers`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `servers` (
  `id` mediumint(5) NOT NULL auto_increment,
  `ip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `port` varchar(10) collate utf8_unicode_ci NOT NULL default '8080',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci NOT NULL,
  `password` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `game` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `maxplayers` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
DROP TABLE IF EXISTS `settings`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `settings` (
  `name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `value` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  USING BTREE (`name`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
INSERT INTO `settings` (`name`, `value`) VALUES
('email', 'admin@website.com'),
('clanname', 'ClanCommandCenter'),
('clantag', 'CCC|'),
('avatar_maxwidth', '100'),
('avatar_maxheight', '100'),
('avatar_maxsize', '150'),
('avatar_allow_upload', 'true'),
('avatars_allow_external', ''),
('picture_maxwidth', '50'),
('picture_maxheight', '60'),
('picture_maxsize', '150'),
('picture_allow_upload', 'true'),
('picture_allow_external', ''),
('errorReport', 'N'),
('errorReportHome', 'N'),
('baseurl', ''),
('template', 'Default'),
('timezone', '+0'),
('language', 'en');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `shoutbox`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `shoutbox` (
  `id` bigint(15) NOT NULL auto_increment,
  `status` enum('published','spam') collate utf8_unicode_ci NOT NULL default 'published',
  `memberid` bigint(15) NOT NULL default '0',
  `name` varchar(75) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `website` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `message` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `ip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `date` int(12) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `date` (`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
INSERT INTO `shoutbox` (`id`, `status`, `memberid`, `name`, `email`, `website`, `message`, `ip`, `date`) VALUES
(1, 'published', 1, 'Admin', 'admin@website.com', 'WEBSITE', 'I\\''m first ;)', '127.0.0.1', 1200170827);
-- --------------------------------------------------------
DROP TABLE IF EXISTS `smilies`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `smilies` (
  `icon` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `extension` varchar(4) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `icon` (`icon`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=48 ;
-- --------------------------------------------------------
INSERT INTO `smilies` (`icon`, `id`, `extension`) VALUES
(':@', 1, 'gif'),
(':byebye:', 39, 'gif'),
(':look:', 38, 'gif'),
(':loved:', 4, 'gif'),
(':wantz:', 47, 'gif'),
(':hiyaa:', 46, 'gif'),
(':ehehe:', 45, 'gif'),
(':wawa:', 44, 'gif'),
(':kma:', 43, 'gif'),
(':frustro:', 42, 'gif'),
(':pondering:', 41, 'gif'),
(':D', 40, 'gif');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `squadassign`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `squadassign` (
  `squadId` mediumint(5) NOT NULL default '0',
  `memberid` bigint(15) NOT NULL default '0',
  `rank` mediumint(3) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
INSERT INTO `squadassign` (`squadId`, `memberid`, `rank`) VALUES
(1, 1, 1),
(2, 1, 1);
-- --------------------------------------------------------
DROP TABLE IF EXISTS `squads`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `squads` (
  `id` mediumint(5) NOT NULL auto_increment,
  `order` mediumint(5) NOT NULL default '0',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
INSERT INTO `squads` (`id`, `order`, `name`, `description`) VALUES
(1, 0, 'ClanCommandCenter', '');
-- --------------------------------------------------------
DROP TABLE IF EXISTS `templates`;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `templates` (
  `id` mediumint(5) NOT NULL auto_increment,
  `name` varchar(75) collate utf8_unicode_ci NOT NULL default '',
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `author` varchar(75) collate utf8_unicode_ci NOT NULL default '',
  `current` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
  `authorweb` varchar(255) collate utf8_unicode_ci NOT NULL,
  `folder` varchar(255) collate utf8_unicode_ci NOT NULL,
  `tplcolumns` smallint(5) unsigned NOT NULL default '2',
  PRIMARY KEY  (`id`),
  KEY `current` (`current`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
INSERT INTO `templates` (`id`, `name`, `description`, `author`, `current`, `authorweb`, `folder`, `tplcolumns`) VALUES
(1, 'Default', 'Default Clan Command Center template', 'Thomas H', 'Y', 'http://www.rdlt.com', 'Default', 2);