-- phpMyAdmin SQL Dump
-- version 2.8.0
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Czas wygenerowania: 21 Maj 2006, 17:08
-- Wersja serwera: 5.0.17
-- Wersja PHP: 5.1.1
-- 
-- Baza danych: `killbox`
-- 

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

-- 
-- Struktura tabeli dla  `kb_cats`
-- 

CREATE TABLE `kb_cats` (
  `cat_id` int(11) NOT NULL,
  `cat_desc` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=26 ;

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

-- 
-- Struktura tabeli dla  `kb_comments`
-- 

CREATE TABLE `kb_comments` (
  `com_data` int(13) NOT NULL,
  `news_id` int(11) NOT NULL default '0',
  `com_nick` varchar(50) NOT NULL default '',
  `com_text` text NOT NULL,
  PRIMARY KEY  (`com_data`)
) TYPE=MyISAM AUTO_INCREMENT=1140989798 ;

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

-- 
-- Struktura tabeli dla  `kb_config`
-- 

CREATE TABLE `kb_config` (
  `config_name` varchar(50) NOT NULL,
  `config_value` varchar(50) NOT NULL
) TYPE=InnoDB;

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

-- 
-- Struktura tabeli dla  `kb_news`
-- 

CREATE TABLE `kb_news` (
  `news_id` int(11) NOT NULL,
  `news_cat` varchar(15) NOT NULL default '',
  `news_data` int(13) NOT NULL default '0',
  `news_title` varchar(200) NOT NULL default '',
  `news_text` text NOT NULL,
  `news_allow_comments` int(11) NOT NULL default '1',
  PRIMARY KEY  (`news_id`),
  KEY `news_data` (`news_data`)
) TYPE=MyISAM AUTO_INCREMENT=48 ;

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

-- 
-- Struktura tabeli dla  `kb_news2cat`
-- 

CREATE TABLE `kb_news2cat` (
  `rel_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  PRIMARY KEY  (`rel_id`),
  KEY `news_id` (`news_id`,`cat_id`)
) TYPE=InnoDB AUTO_INCREMENT=79 ;
