View file SQL.sql

-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 10, 2010 at 01:12 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.12

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Database: `test`
--

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

--
-- Table structure for table `c_bannedib`
--

CREATE TABLE IF NOT EXISTS `c_bannedib` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `browser` text NOT NULL,
  `id_us` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `c_bannedib`
--


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

--
-- Table structure for table `c_forum_msg`
--

CREATE TABLE IF NOT EXISTS `c_forum_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` text NOT NULL,
  `liven` int(11) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  `date` text NOT NULL,
  `razdel` int(11) NOT NULL DEFAULT '0',
  `tema` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `c_forum_msg`
--


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

--
-- Table structure for table `c_forum_razdel`
--

CREATE TABLE IF NOT EXISTS `c_forum_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwan` text NOT NULL,
  `kto` text NOT NULL,
  `liven` int(11) NOT NULL DEFAULT '0',
  `daten` text NOT NULL,
  `kategor` int(11) NOT NULL DEFAULT '0',
  `pol` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `c_forum_razdel`
--


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

--
-- Table structure for table `c_forum_tema`
--

CREATE TABLE IF NOT EXISTS `c_forum_tema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazwan` text NOT NULL,
  `kto` text NOT NULL,
  `liven` int(11) NOT NULL DEFAULT '0',
  `razdel` int(11) NOT NULL DEFAULT '0',
  `date` text NOT NULL,
  `utwerdil` int(11) NOT NULL DEFAULT '0',
  `sostojan` int(11) NOT NULL DEFAULT '0',
  `poschen` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `c_forum_tema`
--


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

--
-- Table structure for table `c_log_admink`
--

CREATE TABLE IF NOT EXISTS `c_log_admink` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `c_log_admink`
--

INSERT INTO `c_log_admink` (`id`, `msg`) VALUES

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

--
-- Table structure for table `c_users`
--

CREATE TABLE IF NOT EXISTS `c_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nik` text NOT NULL,
  `login` text NOT NULL,
  `pass` text NOT NULL,
  `pol` text NOT NULL,
  `datareg` text NOT NULL,
  `mail` text NOT NULL,
  `status` text NOT NULL,
  `liven` int(11) NOT NULL DEFAULT '0',
  `ip` text NOT NULL,
  `brouser` text NOT NULL,
  `post_chat` int(11) NOT NULL DEFAULT '0',
  `ima` text NOT NULL,
  `oper` text NOT NULL,
  `mobil` text NOT NULL,
  `nev` int(11) NOT NULL DEFAULT '0',
  `icq` text NOT NULL,
  `site` text NOT NULL,
  `infa` text NOT NULL,
  `day` text NOT NULL,
  `month` text NOT NULL,
  `year` text NOT NULL,
  `gorod` text NOT NULL,
  `thm` int(11) NOT NULL DEFAULT '0',
  `avr` int(11) NOT NULL DEFAULT '0',
  `max` int(11) NOT NULL DEFAULT '0',
  `say` int(11) NOT NULL DEFAULT '0',
  `trun` int(11) NOT NULL DEFAULT '0',
  `smls` int(11) NOT NULL DEFAULT '0',
  `safe` int(11) NOT NULL DEFAULT '0',
  `fsize` int(11) NOT NULL DEFAULT '0',
  `buton1` int(11) NOT NULL DEFAULT '0',
  `anketa` int(11) NOT NULL DEFAULT '0',
  `limit_who` int(11) NOT NULL DEFAULT '0',
  `dames` int(11) NOT NULL DEFAULT '0',
  `vopros` int(11) NOT NULL DEFAULT '0',
  `priva` int(11) NOT NULL DEFAULT '0',
  `posfor` int(11) NOT NULL DEFAULT '0',
  `posttotal` int(11) NOT NULL DEFAULT '0',
  `ltime` text NOT NULL,
  `room` text NOT NULL,
  `anon` int(11) NOT NULL DEFAULT '0',
  `ban` text NOT NULL,
  `btime` text NOT NULL,
  `pri` text NOT NULL,
  `brak` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `c_users`
--

INSERT INTO `c_users` (`id`, `nik`, `login`, `pass`, `pol`, `datareg`, `mail`, `status`, `liven`, `ip`, `brouser`, `post_chat`, `ima`, `oper`, `mobil`, `nev`, `icq`, `site`, `infa`, `day`, `month`, `year`, `gorod`, `thm`, `avr`, `max`, `say`, `trun`, `smls`, `safe`, `fsize`, `buton1`, `anketa`, `limit_who`, `dames`, `vopros`, `priva`, `posfor`, `posttotal`, `ltime`, `room`, `anon`, `ban`, `btime`, `pri`, `brak`) VALUES
(1, 'admin', '1111', 'a963453cfc4164b6d234460613e2d0d1', 'm', '08.08.2010', '[email protected]', 'Пользователь', 9, '127.0.0.1', 'Opera/9.64 (Windows NT 6.0; U; MRA 5.6 (build 03402); ru) Presto/2.1.1', 0, 'Wolf_Tomash', '', '', 0, '', 'siyanie.org.ru', 'тест', '0001', '0001', '1990', 'Макеевка', 0, 15, 5, 1, 1, 1, 0, 2, 0, 0, 999, 0, 0, 0, 45645, 0, '1281435110', 'forum', 1, '', '', '', '');