-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Erstellungszeit: 24. Dez 2014 um 01:50
-- Server Version: 5.6.16
-- PHP-Version: 5.5.11

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

--
-- Datenbank: `al`
--

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

--
-- Tabellenstruktur für Tabelle `r789_blog_cat`
--

CREATE TABLE IF NOT EXISTS `r789_blog_cat` (
  `cat_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `count_id` mediumint(8) unsigned DEFAULT NULL,
  `cat_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cat_desc` text COLLATE utf8_bin NOT NULL,
  `cat_image` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cat_auth_see` text COLLATE utf8_bin,
  `cat_auth_view` text COLLATE utf8_bin,
  `cat_auth_rate` text COLLATE utf8_bin,
  `cat_auth_create_topic` text COLLATE utf8_bin,
  `cat_auth_reply` text COLLATE utf8_bin,
  `cat_auth_importantmarker` text COLLATE utf8_bin,
  `cat_auth_report_topic` text COLLATE utf8_bin,
  `cat_auth_report_post` text COLLATE utf8_bin,
  `cat_auth_delete_topic` text COLLATE utf8_bin,
  `cat_auth_delete_post` text COLLATE utf8_bin,
  `cat_auth_edit_post` text COLLATE utf8_bin,
  PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=8 ;

--
-- Daten für Tabelle `r789_blog_cat`
--

INSERT INTO `r789_blog_cat` (`cat_id`, `count_id`, `cat_name`, `cat_desc`, `cat_image`, `cat_auth_see`, `cat_auth_view`, `cat_auth_rate`, `cat_auth_create_topic`, `cat_auth_reply`, `cat_auth_importantmarker`, `cat_auth_report_topic`, `cat_auth_report_post`, `cat_auth_delete_topic`, `cat_auth_delete_post`, `cat_auth_edit_post`) VALUES
(6, NULL, 'Allgemein', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, NULL, 'Plugins', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Tabellenstruktur für Tabelle `r789_blog_post`
--

CREATE TABLE IF NOT EXISTS `r789_blog_post` (
  `post_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `parrent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `cat_id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `post_time` int(11) unsigned NOT NULL DEFAULT '0',
  `post_username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `post_subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `post_text` mediumtext COLLATE utf8_bin NOT NULL,
  `post_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
  `post_edit_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `post_edit_user` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `post_edit_count` smallint(4) unsigned NOT NULL DEFAULT '0',
  `post_edit_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `read_position` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `post_date` int(11) DEFAULT NULL,
  `id_post` int(11) NOT NULL,
  `ip` varchar(40) COLLATE utf8_bin NOT NULL,
  `rate` int(11) NOT NULL,
  `dt_rated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`post_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=132 ;

--
-- Daten für Tabelle `r789_blog_post`
--

INSERT INTO `r789_blog_post` (`post_id`, `parrent_id`, `cat_id`, `poster_id`, `post_time`, `post_username`, `post_subject`, `post_text`, `post_edit_time`, `post_edit_reason`, `post_edit_user`, `post_edit_count`, `post_edit_locked`, `read_position`, `post_date`, `id_post`, `ip`, `rate`, `dt_rated`) VALUES
(131, 0, '6', 0, 1419347344, '', 'Dies ist ein Betreff', '<p>Dies ist der Inhalt</p>', 0, '', 0, 0, 0, NULL, NULL, 0, '', 0, '2014-12-23 15:09:04');

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