-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Värd: 127.0.0.1
-- Tid vid skapande: 29 dec 2017 kl 14:37
-- Serverversion: 5.7.14
-- PHP-version: 7.1.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Databas: `forum_ci`
--

-- --------------------------------------------------------

--
-- Tabellstruktur `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_position` int(11) NOT NULL,
  `category_title` varchar(150) NOT NULL,
  `category_layout` varchar(50) NOT NULL DEFAULT 'modern'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumpning av Data i tabell `categories`
--

INSERT INTO `categories` (`category_id`, `category_position`, `category_title`, `category_layout`) VALUES
(1, 1, 'Development', 'modern'),
(2, 2, 'Community', 'classic');

-- --------------------------------------------------------

--
-- Tabellstruktur `forums`
--

CREATE TABLE `forums` (
  `forum_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `forum_position` int(11) NOT NULL,
  `forum_image` varchar(150) NOT NULL,
  `forum_title` varchar(150) NOT NULL,
  `forum_description` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumpning av Data i tabell `forums`
--

INSERT INTO `forums` (`forum_id`, `category_id`, `forum_position`, `forum_image`, `forum_title`, `forum_description`) VALUES
(1, 1, 1, '', 'Regulations & Guidelines', ''),
(2, 1, 2, '', 'Lore & Wiki', ''),
(3, 1, 3, '', 'News', ''),
(4, 1, 4, '', 'Questions', ''),
(5, 1, 5, '', 'Bug', ''),
(6, 1, 6, '', 'Player', ''),
(7, 2, 1, '', 'Regulations', ''),
(8, 2, 2, '', 'Lore', ''),
(9, 2, 3, '', 'News', ''),
(10, 2, 4, '', 'Questions', '');

-- --------------------------------------------------------

--
-- Tabellstruktur `posts`
--

CREATE TABLE `posts` (
  `post_id` int(11) NOT NULL,
  `post_topic_id` int(11) NOT NULL,
  `post_position` int(11) NOT NULL,
  `post_title` varchar(150) NOT NULL,
  `post_description` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellstruktur `topics`
--

CREATE TABLE `topics` (
  `topic_id` int(11) NOT NULL,
  `topic_forum_id` int(11) NOT NULL,
  `topic_position` int(11) NOT NULL,
  `topic_title` varchar(150) NOT NULL,
  `topic_description` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Index för dumpade tabeller
--

--
-- Index för tabell `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Index för tabell `forums`
--
ALTER TABLE `forums`
  ADD PRIMARY KEY (`forum_id`);

--
-- Index för tabell `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`post_id`);

--
-- Index för tabell `topics`
--
ALTER TABLE `topics`
  ADD PRIMARY KEY (`topic_id`);

--
-- AUTO_INCREMENT för dumpade tabeller
--

--
-- AUTO_INCREMENT för tabell `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT för tabell `forums`
--
ALTER TABLE `forums`
  MODIFY `forum_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT för tabell `posts`
--
ALTER TABLE `posts`
  MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT för tabell `topics`
--
ALTER TABLE `topics`
  MODIFY `topic_id` int(11) NOT NULL AUTO_INCREMENT;