-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Czas wygenerowania: 09 Gru 2007, 10:57
-- Wersja serwera: 5.0.41
-- Wersja PHP: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Baza danych: `coje`
-- 

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

-- 
-- Struktura tabeli dla  `comments`
-- 

CREATE TABLE `comments` (
  `comment_id` int(11) NOT NULL auto_increment,
  `comment_data` int(11) NOT NULL default '0',
  `comment_data_service` varchar(25) collate utf8_polish_ci NOT NULL default '',
  `comment_user` int(11) NOT NULL default '0',
  `comment_time` int(11) NOT NULL default '0',
  `comment_text` text collate utf8_polish_ci NOT NULL,
  PRIMARY KEY  (`comment_id`),
  KEY `comment_user` (`comment_user`),
  KEY `comment_data` (`comment_data`),
  KEY `comment_data_service` (`comment_data_service`),
  KEY `comment_data_2` (`comment_data`,`comment_data_service`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=10 ;

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

-- 
-- Struktura tabeli dla  `data`
-- 

CREATE TABLE `data` (
  `ID` int(11) NOT NULL auto_increment,
  `data_id` int(11) NOT NULL default '0',
  `data_service` varchar(25) collate utf8_polish_ci NOT NULL default '',
  `data_category` int(2) NOT NULL default '0',
  `data_active` enum('y','n') collate utf8_polish_ci NOT NULL default 'n',
  `data_referer` int(11) NOT NULL default '0',
  `data_rewrite` varchar(255) collate utf8_polish_ci NOT NULL default '',
  `data_title` text collate utf8_polish_ci NOT NULL,
  `data_text` text collate utf8_polish_ci NOT NULL,
  `data_code` text collate utf8_polish_ci NOT NULL,
  `data_time` int(11) NOT NULL default '0',
  `data_comments` int(11) NOT NULL default '0',
  `data_hits` int(11) NOT NULL default '0',
  `data_rating` int(11) NOT NULL default '0',
  `data_rating_votes` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `data_rewrite` (`data_rewrite`),
  KEY `data_category` (`data_category`),
  KEY `data_service` (`data_service`),
  KEY `data_active` (`data_active`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=5871 ;

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

-- 
-- Struktura tabeli dla  `online`
-- 

CREATE TABLE `online` (
  `online_hash` varchar(32) collate utf8_polish_ci NOT NULL default '',
  `online_timeout` int(11) NOT NULL default '0',
  `online_user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`online_hash`),
  KEY `online_timeout` (`online_timeout`),
  KEY `online_user` (`online_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

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

-- 
-- Struktura tabeli dla  `users`
-- 

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_key` varchar(32) collate utf8_polish_ci NOT NULL default '',
  `user_lost_key` varchar(32) collate utf8_polish_ci NOT NULL default '',
  `user_join` int(11) NOT NULL default '0',
  `user_admin` enum('y','n') collate utf8_polish_ci NOT NULL default 'n',
  `user_name` varchar(255) collate utf8_polish_ci NOT NULL default '',
  `user_pass` varchar(32) collate utf8_polish_ci NOT NULL default '',
  `user_mail` varchar(255) collate utf8_polish_ci NOT NULL default '',
  `user_avatar` varchar(255) collate utf8_polish_ci NOT NULL default '',
  `user_referer` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  UNIQUE KEY `user_mail` (`user_mail`),
  KEY `user_key` (`user_key`),
  KEY `user_join` (`user_join`),
  KEY `user_lost_key` (`user_lost_key`),
  KEY `user_referer` (`user_referer`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=136 ;