-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 12. September 2005 um 11:44
-- Server Version: 4.1.12
-- PHP-Version: 5.0.4
-- 
-- Datenbank: `site`
-- 

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

-- 
-- Tabellenstruktur für Tabelle `_banned`
-- 

CREATE TABLE `_banned` (
  `ID` int(11) NOT NULL auto_increment,
  `ip` varchar(15) collate latin1_german1_ci NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `_banned`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `_member`
-- 

CREATE TABLE `_member` (
  `UserId` int(11) NOT NULL auto_increment,
  `UserLevel` int(3) NOT NULL default '1',
  `Name` varchar(30) collate latin1_german1_ci NOT NULL default 'Name',
  `Vorname` varchar(50) collate latin1_german1_ci NOT NULL default 'Vorname',
  `UserName` varchar(12) collate latin1_german1_ci NOT NULL default '',
  `UserPasswd` varchar(32) collate latin1_german1_ci NOT NULL default '',
  `UserMail` varchar(150) collate latin1_german1_ci NOT NULL default '',
  `UserSession` varchar(32) collate latin1_german1_ci default NULL,
  `UserLogin` datetime default NULL,
  `LastAction` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserLogout` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserActive` varchar(32) collate latin1_german1_ci NOT NULL default '',
  `UserRegisteredAt` datetime default NULL,
  `FailedLogins` int(11) NOT NULL default '0',
  PRIMARY KEY  (`UserId`),
  UNIQUE KEY `UserName` (`UserName`),
  UNIQUE KEY `UserMail` (`UserMail`),
  UNIQUE KEY `UserSession` (`UserSession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `_member`
-- 

INSERT INTO `_member` (`UserId`, `UserLevel`, `Name`, `Vorname`, `UserName`, `UserPasswd`, `UserMail`, `UserSession`, `UserLogin`, `LastAction`, `UserLogout`, `UserActive`, `UserRegisteredAt`, `FailedLogins`) VALUES (1, 1000, 'Name', 'Vorname', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'mail@localhost.de', 'irvjk6o34ns1a88drc74sj4a75', '2005-09-11 03:25:09', '2005-09-11 05:22:56', '0000-00-00 00:00:00', '1', '2005-08-29 04:30:46', 0);
INSERT INTO `_member` (`UserId`, `UserLevel`, `Name`, `Vorname`, `UserName`, `UserPasswd`, `UserMail`, `UserSession`, `UserLogin`, `LastAction`, `UserLogout`, `UserActive`, `UserRegisteredAt`, `FailedLogins`) VALUES (2, 1, 'Name', 'Vorname', 'Nascar', '7f26af91ea092313a869b864e1c746e6', 'bufokind@web.de', NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1', '2005-09-11 05:38:03', 0);

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

-- 
-- Tabellenstruktur für Tabelle `_modul`
-- 

CREATE TABLE `_modul` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(20) collate latin1_german1_ci NOT NULL default '',
  `url` text collate latin1_german1_ci NOT NULL,
  `active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `_modul`
-- 

INSERT INTO `_modul` (`ID`, `name`, `url`, `active`) VALUES (1, 'test', 'test/index.php', 0);
INSERT INTO `_modul` (`ID`, `name`, `url`, `active`) VALUES (2, 'news_comments', 'news/comments.php', 1);

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

-- 
-- Tabellenstruktur für Tabelle `_news`
-- 

CREATE TABLE `_news` (
  `ID` int(11) NOT NULL auto_increment,
  `title` varchar(75) collate latin1_german1_ci NOT NULL default '',
  `news` text collate latin1_german1_ci NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `user` int(11) NOT NULL default '0',
  `cat` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=7 ;

-- 
-- Daten für Tabelle `_news`
-- 

INSERT INTO `_news` (`ID`, `title`, `news`, `date`, `user`, `cat`) VALUES (1, '1. News', 'Joa das ist der text', '2005-09-11 04:34:01', 1, 1);
INSERT INTO `_news` (`ID`, `title`, `news`, `date`, `user`, `cat`) VALUES (2, '2. News', 'TEXT 2. News', '2005-08-29 21:33:04', 1, 2);
INSERT INTO `_news` (`ID`, `title`, `news`, `date`, `user`, `cat`) VALUES (3, 'noch ne BF2 News', 'Ka weiß atm keine aber guckt doch mal auf diversen inet seiten da steht bestimmt eine rum!!!!!!!!!!!!!!! rolf ey', '2005-09-11 05:39:45', 2, 2);
INSERT INTO `_news` (`ID`, `title`, `news`, `date`, `user`, `cat`) VALUES (4, 'kA News', 'blubba texte', '2005-09-11 05:39:50', 2, 1);
INSERT INTO `_news` (`ID`, `title`, `news`, `date`, `user`, `cat`) VALUES (5, 'spam news', 'kA wasn kack text', '2005-09-11 08:07:24', 1, 1);
INSERT INTO `_news` (`ID`, `title`, `news`, `date`, `user`, `cat`) VALUES (6, 'noch ne spam news', 'joa das hier ist der text', '2005-09-11 08:07:50', 2, 1);

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

-- 
-- Tabellenstruktur für Tabelle `_news_cat`
-- 

CREATE TABLE `_news_cat` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(75) collate latin1_german1_ci NOT NULL default '',
  `picture` text collate latin1_german1_ci NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `_news_cat`
-- 

INSERT INTO `_news_cat` (`ID`, `name`, `picture`) VALUES (1, 'Allgemein', 'news/allg.jpg');
INSERT INTO `_news_cat` (`ID`, `name`, `picture`) VALUES (2, 'BF2', 'news/bf2.jpg');

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

-- 
-- Tabellenstruktur für Tabelle `_news_comments`
-- 

CREATE TABLE `_news_comments` (
  `ID` int(11) NOT NULL auto_increment,
  `newsID` int(11) NOT NULL default '0',
  `userID` int(11) NOT NULL default '0',
  `comment` text collate latin1_german1_ci NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=11 ;

-- 
-- Daten für Tabelle `_news_comments`
-- 

INSERT INTO `_news_comments` (`ID`, `newsID`, `userID`, `comment`, `date`) VALUES (1, 1, 1, 'joa mein comment halt', '2005-08-30 00:15:37');
INSERT INTO `_news_comments` (`ID`, `newsID`, `userID`, `comment`, `date`) VALUES (2, 2, 1, 'test', '2005-08-30 10:24:30');
INSERT INTO `_news_comments` (`ID`, `newsID`, `userID`, `comment`, `date`) VALUES (3, 2, 1, 'blubba', '2005-08-30 10:26:32');
INSERT INTO `_news_comments` (`ID`, `newsID`, `userID`, `comment`, `date`) VALUES (4, 2, 1, 'testle geil oder?', '2005-08-30 10:34:26');
INSERT INTO `_news_comments` (`ID`, `newsID`, `userID`, `comment`, `date`) VALUES (5, 2, 1, 'whot???', '2005-09-10 22:52:51');
INSERT INTO `_news_comments` (`ID`, `newsID`, `userID`, `comment`, `date`) VALUES (7, 2, 1, ' '' </div>test<div>', '2005-09-11 03:36:11');

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

-- 
-- Tabellenstruktur für Tabelle `_settings`
-- 

CREATE TABLE `_settings` (
  `ID` int(11) NOT NULL auto_increment,
  `name` text collate latin1_german1_ci NOT NULL,
  `value` text collate latin1_german1_ci NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=4 ;

-- 
-- Daten für Tabelle `_settings`
-- 

INSERT INTO `_settings` (`ID`, `name`, `value`) VALUES (1, 'default_modul', 'news/index.php');
INSERT INTO `_settings` (`ID`, `name`, `value`) VALUES (2, 'site_title', 'Testing Page');
INSERT INTO `_settings` (`ID`, `name`, `value`) VALUES (3, 'news_limit', '10');