Skip to content

Instantly share code, notes, and snippets.

@chriskonnertz

chriskonnertz/contentify.sql

Created April 28, 2015 09:57
Show Gist options
  • Save chriskonnertz/ff584773aa3f017537bf to your computer and use it in GitHub Desktop.
Save chriskonnertz/ff584773aa3f017537bf to your computer and use it in GitHub Desktop.
Download ZIP
Contentify CMS 0.7.0: MySQLDump (Username: example, Email: example@example.com, Password: example)
Raw
contentify.sql
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 */;
CREATE TABLE IF NOT EXISTS `advertcats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `adverts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`code` text COLLATE utf8_unicode_ci,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`advertcat_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `adverts_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `awards` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) NOT NULL DEFAULT '0',
`achieved_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`game_id` int(10) unsigned DEFAULT NULL,
`tournament_id` int(10) unsigned DEFAULT NULL,
`team_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`text` text COLLATE utf8_unicode_ci,
`foreign_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`foreign_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `config` (
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`value` text COLLATE utf8_unicode_ci,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `contact_messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`username` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`text` text COLLATE utf8_unicode_ci NOT NULL,
`ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`new` tinyint(1) NOT NULL DEFAULT '1',
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `countries` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
`icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=58 ;
INSERT INTO `countries` (`id`, `title`, `code`, `icon`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'European Union', 'eu', 'eu.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'Argentina', 'ar', 'ar.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 'Australia', 'au', 'au.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(4, 'Austria', 'at', 'at.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(5, 'Belgium', 'be', 'be.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(6, 'Bosnia Herzegowina', 'ba', 'ba.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(7, 'Brazil', 'br', 'br.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(8, 'Bulgaria', 'bg', 'bg.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(9, 'Canada', 'ca', 'ca.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(10, 'Chile', 'cl', 'cl.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(11, 'China', 'cn', 'cn.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(12, 'Colombia', 'co', 'co.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(13, 'Czech Republic', 'cz', 'cz.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(14, 'Croatia', 'hr', 'hr.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(15, 'Cyprus', 'cy', 'cy.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(16, 'Denmark', 'dk', 'dk.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(17, 'Estonia', 'ee', 'ee.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(18, 'Finland', 'fi', 'fi.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(19, 'Faroe Islands', 'fo', 'fo.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(20, 'France', 'fr', 'fr.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(21, 'Germany', 'de', 'de.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(22, 'Greece', 'gr', 'gr.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(23, 'Hungary', 'hu', 'hu.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(24, 'Iceland', 'is', 'is.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(25, 'Ireland', 'ie', 'ie.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(26, 'Israel', 'il', 'il.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(27, 'Italy', 'it', 'it.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(28, 'Japan', 'jp', 'jp.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(29, 'Korea', 'kr', 'kr.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(30, 'Latvia', 'lv', 'lv.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(31, 'Lithuania', 'lt', 'lt.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(32, 'Luxemburg', 'lu', 'lu.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(33, 'Malaysia', 'my', 'my.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(34, 'Malta', 'mt', 'mt.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(35, 'Netherlands', 'nl', 'nl.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(36, 'Mexico', 'mx', 'mx.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(37, 'Mongolia', 'mn', 'mn.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(38, 'New Zealand', 'nz', 'nz.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(39, 'Norway', 'no', 'no.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(40, 'Poland', 'pl', 'pl.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(41, 'Portugal', 'pt', 'pt.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(42, 'Romania', 'ro', 'ro.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(43, 'Russian Federation', 'ru', 'ru.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(44, 'Singapore', 'sg', 'sg.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(45, 'Slovak Republic', 'sk', 'sk.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(46, 'Slovenia', 'si', 'si.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(47, 'Taiwan', 'tw', 'tw.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(48, 'South Africa', 'za', 'za.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(49, 'Spain', 'es', 'es.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(50, 'Sweden', 'se', 'se.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(51, 'Syria', 'sy', 'sy.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(52, 'Switzerland', 'ch', 'ch.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(53, 'Tunisia', 'tn', 'tn.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(54, 'Turkey', 'tr', 'tr.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(55, 'Ukraine', 'ua', 'ua.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(56, 'United Kingdom', 'uk', 'uk.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(57, 'USA', 'us', 'us.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `downloadcats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `downloadcats_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `downloads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci,
`file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`file_size` int(11) NOT NULL DEFAULT '0',
`is_image` tinyint(1) NOT NULL DEFAULT '0',
`downloadcat_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `downloads_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `forums` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci,
`position` int(11) NOT NULL DEFAULT '0',
`internal` tinyint(1) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`threads_count` int(11) NOT NULL DEFAULT '0',
`posts_count` int(11) NOT NULL DEFAULT '0',
`forum_id` int(10) unsigned DEFAULT NULL,
`latest_thread_id` int(10) unsigned DEFAULT NULL,
`team_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `forums_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `forum_posts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`text` text COLLATE utf8_unicode_ci,
`root` tinyint(1) NOT NULL DEFAULT '0',
`thread_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `forum_reports` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`text` text COLLATE utf8_unicode_ci,
`post_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `forum_threads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`posts_count` int(11) NOT NULL DEFAULT '1',
`sticky` tinyint(1) NOT NULL DEFAULT '0',
`closed` tinyint(1) NOT NULL DEFAULT '0',
`forum_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `forum_threads_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `galleries` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `galleries_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `games` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`short` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
`icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;
INSERT INTO `games` (`id`, `title`, `short`, `icon`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Counter-Strike: Global Offensive', 'CS:GO', 'default/csgo.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'Counter-Strike: Source', 'CS:S', 'default/css.gif', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 'Counter-Strike 1.6', 'CS', 'default/cs.gif', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(4, 'Call of Duty', 'CoD', 'default/cod.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(5, 'Battlefield', 'BF', 'default/bf.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(6, 'Unreal Tournament 3', 'UT3', 'default/ut3.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(7, 'Left 4 Dead', 'L4D', 'default/l4d.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(8, 'Crysis', 'Crysis', 'default/crysis.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(9, 'Quake', 'Quake', 'default/quake.gif', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(10, 'StarCraft II', 'SC2', 'default/sc2.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(11, 'Warcraft III', 'WC3', 'default/wc3.gif', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(12, 'Diablo III', 'D3', 'default/d3.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(13, 'DotA 2', 'DotA', 'default/dota2.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(14, 'League of Legends', 'LoL', 'default/lol.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(15, 'World of Warcraft', 'WoW', 'default/wow.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(16, 'World of Tanks', 'WoT', 'default/wot.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(17, 'Trackmania', 'TM', 'default/tm.gif', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(18, 'FIFA', 'FIFA', 'default/fifa.gif', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(19, 'Minecraft', 'MS', 'default/mc.png', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`permissions` text COLLATE utf8_unicode_ci,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `groups_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
INSERT INTO `groups` (`id`, `name`, `permissions`, `created_at`, `updated_at`, `creator_id`, `updater_id`) VALUES
(1, 'Visitors', '', '2015-04-28 07:50:45', '2015-04-28 07:50:45', 0, 0),
(2, 'Users', '{"frontend":1,"comments":2}', '2015-04-28 07:50:46', '2015-04-28 07:50:46', 0, 0),
(3, 'Members', '{"frontend":1,"internal":1,"comments":2}', '2015-04-28 07:50:46', '2015-04-28 07:50:46', 0, 0),
(4, 'Admins', '{"frontend":1,"internal":1,"backend":1,"adverts":4,"auth":4,"awards":4,"comments":4,"config":4,"contact":4,"countries":4,"diag":4,"downloads":4,"forums":4,"galleries":4,"games":4,"groups":4,"help":4,"images":4,"maps":4,"matches":4,"modules":1,"news":4,"opponents":4,"pages":4,"partners":4,"servers":4,"slides":4,"streams":4,"teams":4,"tournaments":4,"users":4,"videos":4}', '2015-04-28 07:50:46', '2015-04-28 07:50:46', 0, 0),
(5, 'Super-Admins', '{"frontend":1,"internal":1,"backend":1,"superuser":1,"adverts":4,"auth":4,"awards":4,"comments":4,"config":4,"contact":4,"countries":4,"diag":4,"downloads":4,"forums":4,"galleries":4,"games":4,"groups":4,"help":4,"images":4,"maps":4,"matches":4,"modules":4,"news":4,"opponents":4,"pages":4,"partners":4,"servers":4,"slides":4,"streams":4,"teams":4,"tournaments":4,"users":4,"videos":4}', '2015-04-28 07:50:46', '2015-04-28 07:50:46', 0, 0);
CREATE TABLE IF NOT EXISTS `images` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`tags` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`width` int(11) NOT NULL DEFAULT '0',
`height` int(11) NOT NULL DEFAULT '0',
`gallery_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `languages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`code` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
INSERT INTO `languages` (`id`, `title`, `code`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'English', 'en', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'Deutsch', 'de', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `maps` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`game_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
INSERT INTO `maps` (`id`, `title`, `image`, `game_id`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Unknown', NULL, NULL, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'de_dust', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 'de_dust2', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(4, 'de_inferno', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(5, 'de_train', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(6, 'de_cbble', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(7, 'de_nuke', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(8, 'de_inferno', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(9, 'de_cache', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(10, 'de_mirage', NULL, 1, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `matches` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`state` int(11) NOT NULL DEFAULT '0',
`featured` tinyint(1) NOT NULL DEFAULT '0',
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`broadcast` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`left_lineup` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`right_lineup` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci NOT NULL,
`played_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`left_score` int(11) NOT NULL DEFAULT '0',
`right_score` int(11) NOT NULL DEFAULT '0',
`left_team_id` int(10) unsigned DEFAULT NULL,
`right_team_id` int(10) unsigned DEFAULT NULL,
`game_id` int(10) unsigned DEFAULT NULL,
`tournament_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `match_scores` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`left_score` int(11) NOT NULL DEFAULT '0',
`right_score` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`match_id` int(10) unsigned DEFAULT NULL,
`map_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`text` text COLLATE utf8_unicode_ci NOT NULL,
`new` tinyint(1) NOT NULL DEFAULT '1',
`creator_visible` tinyint(1) NOT NULL DEFAULT '1',
`receiver_visible` tinyint(1) NOT NULL DEFAULT '1',
`receiver_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `messages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `migrations` (
`migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2012_12_06_225921_migration_cartalyst_sentry_install_users', 1),
('2012_12_06_225929_migration_cartalyst_sentry_install_groups', 1),
('2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot', 1),
('2012_12_06_225988_migration_cartalyst_sentry_install_throttle', 1),
('2013_12_22_223744_add_username', 2),
('2013_12_23_003400_create_user_profile', 2),
('2014_04_04_003500_add_group_updater', 2);
CREATE TABLE IF NOT EXISTS `navigations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`items` text COLLATE utf8_unicode_ci,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`intro` text COLLATE utf8_unicode_ci,
`text` text COLLATE utf8_unicode_ci,
`published` tinyint(1) NOT NULL DEFAULT '0',
`published_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`internal` tinyint(1) NOT NULL DEFAULT '0',
`enable_comments` tinyint(1) NOT NULL DEFAULT '0',
`newscat_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `news_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `newscats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `opponents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`short` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`lineup` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`country_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `opponents_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `pagecats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
INSERT INTO `pagecats` (`id`, `title`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Blog Post', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'Custom Page', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 'Custom Content', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `pages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`text` text COLLATE utf8_unicode_ci,
`published` tinyint(1) NOT NULL DEFAULT '0',
`published_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`internal` tinyint(1) NOT NULL DEFAULT '0',
`enable_comments` tinyint(1) NOT NULL DEFAULT '0',
`pagecat_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
INSERT INTO `pages` (`id`, `title`, `slug`, `text`, `published`, `published_at`, `internal`, `enable_comments`, `pagecat_id`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Imprint', 'imprint', 'Imprint Page Text', 1, '0000-00-00 00:00:00', 0, 0, 2, 1, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `partnercats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `partners` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`text` text COLLATE utf8_unicode_ci,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) NOT NULL DEFAULT '0',
`published` tinyint(1) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`partnercat_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `partners_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `servers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`hoster` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slots` int(11) NOT NULL DEFAULT '0',
`game_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `shouts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`text` text COLLATE utf8_unicode_ci,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `slidecats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `slides` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slidecat_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `streams` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`permanent_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`provider` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`online` tinyint(1) NOT NULL DEFAULT '0',
`viewers` int(11) NOT NULL DEFAULT '0',
`renewed_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `streams_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `teamcats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
INSERT INTO `teamcats` (`id`, `title`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Staff', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'Gaming', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `teams` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` int(11) NOT NULL DEFAULT '0',
`published` tinyint(1) NOT NULL DEFAULT '0',
`teamcat_id` int(10) unsigned DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `teams_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `team_user` (
`user_id` int(10) unsigned NOT NULL,
`team_id` int(10) unsigned NOT NULL,
`task` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8_unicode_ci,
`position` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`,`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `throttle` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned DEFAULT NULL,
`ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`attempts` int(11) NOT NULL DEFAULT '0',
`suspended` tinyint(1) NOT NULL DEFAULT '0',
`banned` tinyint(1) NOT NULL DEFAULT '0',
`last_attempt_at` timestamp NULL DEFAULT NULL,
`suspended_at` timestamp NULL DEFAULT NULL,
`banned_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `throttle_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
INSERT INTO `throttle` (`id`, `user_id`, `ip_address`, `attempts`, `suspended`, `banned`, `last_attempt_at`, `suspended_at`, `banned_at`) VALUES
(1, 2, '::1', 0, 0, 0, NULL, NULL, NULL);
CREATE TABLE IF NOT EXISTS `tournaments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`short` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
`icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
INSERT INTO `tournaments` (`id`, `title`, `short`, `icon`, `creator_id`, `updater_id`, `access_counter`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Electronic Sports League', 'ESL', NULL, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'E-Sports Entertainment Association', 'ESEA', NULL, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 'Major League Gaming', 'MLG', NULL, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(4, 'Electronic Sports World Cup', 'ESWC', NULL, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(5, 'Dreamhack', 'DH', NULL, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`permissions` text COLLATE utf8_unicode_ci,
`activated` tinyint(1) NOT NULL DEFAULT '0',
`activation_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`activated_at` timestamp NULL DEFAULT NULL,
`last_login` timestamp NULL DEFAULT NULL,
`persist_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`reset_password_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`username` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`gender` int(11) DEFAULT '0',
`country_id` int(11) NOT NULL DEFAULT '1',
`language_id` int(11) NOT NULL DEFAULT '1',
`birthdate` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`occupation` text COLLATE utf8_unicode_ci,
`website` text COLLATE utf8_unicode_ci,
`about` text COLLATE utf8_unicode_ci,
`skype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`facebook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`twitter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`steam_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`cpu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`graphics` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ram` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`motherboard` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`drives` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`display` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`mouse` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`keyboard` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`headset` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`mousepad` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`game` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`food` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`drink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`music` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`film` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`access_counter` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`posts_count` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`signature` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`),
UNIQUE KEY `users_username_unique` (`username`),
KEY `users_activation_code_index` (`activation_code`),
KEY `users_reset_password_code_index` (`reset_password_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
INSERT INTO `users` (`id`, `email`, `password`, `permissions`, `activated`, `activation_code`, `activated_at`, `last_login`, `persist_code`, `reset_password_code`, `first_name`, `last_name`, `created_at`, `updated_at`, `username`, `slug`, `updater_id`, `gender`, `country_id`, `language_id`, `birthdate`, `occupation`, `website`, `about`, `skype`, `facebook`, `twitter`, `steam_id`, `cpu`, `graphics`, `ram`, `motherboard`, `drives`, `display`, `mouse`, `keyboard`, `headset`, `mousepad`, `game`, `food`, `drink`, `music`, `film`, `image`, `avatar`, `access_counter`, `posts_count`, `signature`) VALUES
(1, 'daemon@contentify.org', '$2y$10$EYiScbnM1R5w.5AwkozuR./XIqS7.G87cQ4u0ZKsDpC467iH8Cu02', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 07:50:46', '2015-04-28 07:50:46', 'Daemon', '', 0, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL),
(2, 'example@example.com', '$2y$10$XfCeOmhnvvDqKtxBIvzIB.D2hMqvGqYPk5NFiek/lFeIFyqP0XTQy', NULL, 1, NULL, '2015-04-28 07:51:27', '2015-04-28 07:51:39', '$2y$10$sNXKUIJKaB9xvqB8IqzTB.mvDrkGC83oqEAU51zD7EG2vJjH6Q46u', NULL, NULL, NULL, '2015-04-28 07:51:27', '2015-04-28 07:51:39', 'example', 'example', 0, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL);
CREATE TABLE IF NOT EXISTS `users_groups` (
`user_id` int(10) unsigned NOT NULL,
`group_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `users_groups` (`user_id`, `group_id`) VALUES
(2, 5);
CREATE TABLE IF NOT EXISTS `user_activities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`frontend` tinyint(1) NOT NULL,
`model_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`info` text COLLATE utf8_unicode_ci,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`activity_id` int(10) unsigned DEFAULT NULL,
`user_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `videos` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`permanent_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`provider` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`creator_id` int(10) unsigned NOT NULL DEFAULT '0',
`updater_id` int(10) unsigned NOT NULL DEFAULT '0',
`access_counter` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `videos_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `visits` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`user_agents` int(11) NOT NULL,
`visited_at` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
INSERT INTO `visits` (`id`, `ip`, `user_agents`, `visited_at`) VALUES
(1, '::1', 1, '2015-04-28');
/*!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 */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment