-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 31, 2006 at 01:39 PM
-- Server version: 4.1.8
-- PHP Version: 4.4.0
--
-- Database: `forum`
--
-- --------------------------------------------------------
--
-- Table structure for table `administrators`
--
CREATE TABLE `administrators` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(99) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `administrators`
--
INSERT INTO `administrators` VALUES (1, 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `annonces`
--
CREATE TABLE `annonces` (
`numero` int(11) default NULL,
`nom` varchar(45) default NULL,
`auteur` varchar(30) default NULL,
`email` varchar(50) default NULL,
`contenu` blob,
`rubrique` varchar(20) default NULL,
`telephone` varchar(10) default NULL,
`date` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Dumping data for table `annonces`
--
-- --------------------------------------------------------
--
-- Table structure for table `buddylist`
--
CREATE TABLE `buddylist` (
`id` int(100) NOT NULL auto_increment,
`whos` varchar(255) NOT NULL default '',
`buddy` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `buddylist`
--
-- --------------------------------------------------------
--
-- Table structure for table `chat`
--
CREATE TABLE `chat` (
`id` int(10) NOT NULL auto_increment,
`msg` varchar(150) NOT NULL default '',
`sentby` varchar(40) NOT NULL default '',
`time` int(30) NOT NULL default '0',
`sent` varchar(30) NOT NULL default '',
`room` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `chat`
--
-- --------------------------------------------------------
--
-- Table structure for table `chatonline`
--
CREATE TABLE `chatonline` (
`id` int(20) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`room` varchar(50) NOT NULL default '',
`time` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `chatonline`
--
-- --------------------------------------------------------
--
-- Table structure for table `counter`
--
CREATE TABLE `counter` (
`id` int(5) NOT NULL default '0',
`visitors` int(99) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Dumping data for table `counter`
--
INSERT INTO `counter` VALUES (1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `forums`
--
CREATE TABLE `forums` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(200) NOT NULL default '',
`perms` int(99) NOT NULL default '0',
`position` int(99) NOT NULL default '0',
`adminonl` varchar(10) NOT NULL default '',
`modonl` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `forums`
--
INSERT INTO `forums` VALUES (1, 'AW', 0, 1, 'n', 'n');
-- --------------------------------------------------------
--
-- Table structure for table `log`
--
CREATE TABLE `log` (
`id` int(10) NOT NULL auto_increment,
`date` varchar(99) NOT NULL default '',
`text` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `log`
--
INSERT INTO `log` VALUES (1, '06 03 30 - 0:50:35', '<b>grend</b> переименовал <b>123456789123456zxxxxxxxxxxxxxxxxxxx789123456789123</b> в <b>123456789123456zxxxxxxxxxxxxxxxxxxx789123456789123</b> в форуме <b>AW</b>');
INSERT INTO `log` VALUES (2, '06 03 30 - 0:50:46', '<b>grend</b> заблокирова <b>123456789123456zxxxxxxxxxxxxxxxxxxx789123456789123</b>');
INSERT INTO `log` VALUES (3, '06 03 30 - 0:56:20', '<b>grend</b> закрыл <b>123456789123456789123456789123</b>');
INSERT INTO `log` VALUES (4, '06 03 30 - 0:57:35', '<b>grend</b> заблокирова <b>123456789123456789123456789123</b>');
INSERT INTO `log` VALUES (5, '06 03 30 - 0:57:52', '<b>grend</b> разблокировал <b>123456789123456789123456789123</b>');
INSERT INTO `log` VALUES (6, '06 03 30 - 0:57:59', '<b>grend</b> отрыл <b>123456789123456789123456789123</b>');
INSERT INTO `log` VALUES (7, '06 03 30 - 0:58:04', '<b>grend</b> заблокирова <b>123456789123456789123456789123</b>');
INSERT INTO `log` VALUES (8, '06 03 30 - 1:12:49', '<b>grend</b> заблокирова <b>tests</b>');
INSERT INTO `log` VALUES (9, '06 03 30 - 1:12:57', '<b>grend</b> удалил <b>tests</b> в форуме <b>AW</b>');
-- --------------------------------------------------------
--
-- Table structure for table `moderators`
--
CREATE TABLE `moderators` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(200) NOT NULL default '',
`forum` varchar(99) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `moderators`
--
-- --------------------------------------------------------
--
-- Table structure for table `online`
--
CREATE TABLE `online` (
`laikas` int(15) NOT NULL default '0',
`username` varchar(40) NOT NULL default '',
PRIMARY KEY (`laikas`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Dumping data for table `online`
--
-- --------------------------------------------------------
--
-- Table structure for table `online2`
--
CREATE TABLE `online2` (
`timeuser` int(12) NOT NULL default '0',
`userip` varchar(40) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Dumping data for table `online2`
--
-- --------------------------------------------------------
--
-- Table structure for table `permissions`
--
CREATE TABLE `permissions` (
`id` int(99) NOT NULL auto_increment,
`name` varchar(200) NOT NULL default '',
`forum` varchar(99) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `permissions`
--
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
CREATE TABLE `posts` (
`id` int(99) NOT NULL auto_increment,
`forum` int(99) NOT NULL default '0',
`postedby` varchar(99) NOT NULL default '',
`name` varchar(254) NOT NULL default '',
`pinned` varchar(5) NOT NULL default '',
`thread` char(1) NOT NULL default '',
`position` bigint(99) NOT NULL default '0',
`perms` int(99) NOT NULL default '0',
`text` text NOT NULL,
`closed` varchar(5) NOT NULL default '',
`date` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `text` (`pinned`),
FULLTEXT KEY `text_2` (`pinned`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=65 ;
--
-- Dumping data for table `posts`
--
-- --------------------------------------------------------
--
-- Table structure for table `private`
--
CREATE TABLE `private` (
`id` int(99) NOT NULL auto_increment,
`unread` varchar(5) NOT NULL default '',
`sentby` text NOT NULL,
`sentto` text NOT NULL,
`text` text NOT NULL,
`date` varchar(100) NOT NULL default '',
`timesent` int(50) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `private`
--
-- --------------------------------------------------------
--
-- Table structure for table `rooms`
--
CREATE TABLE `rooms` (
`id` int(30) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`private` char(2) NOT NULL default '',
`pinned` char(2) NOT NULL default '',
`roomstart` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `rooms`
--
-- --------------------------------------------------------
--
-- Table structure for table `smilies`
--
CREATE TABLE `smilies` (
`id` int(10) NOT NULL auto_increment,
`bbcode` varchar(200) NOT NULL default '',
`changeto` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `smilies`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(254) NOT NULL default '',
`pass` varchar(254) NOT NULL default '',
`postno` int(100) NOT NULL default '0',
`pluses` int(99) NOT NULL default '0',
`status` varchar(99) NOT NULL default '',
`owntext` text NOT NULL,
`email` varchar(50) NOT NULL default '',
`banned` char(2) NOT NULL default '',
`bannedby` varchar(100) NOT NULL default '',
`banto` int(40) NOT NULL default '0',
`tlphone` varchar(99) NOT NULL default '',
`site` varchar(50) NOT NULL default '',
`avatar` varchar(100) NOT NULL default '',
`lastpost` int(100) NOT NULL default '0',
`lastthread` int(100) NOT NULL default '0',
`banreason` varchar(255) NOT NULL default '',
`plusreason` varchar(255) NOT NULL default '',
`pms` int(255) NOT NULL default '0',
`age` int(2) NOT NULL default '0',
`city` varchar(40) NOT NULL default '',
`likes` text NOT NULL,
`chate` char(2) NOT NULL default 'n',
`pradejo` int(30) NOT NULL default '0',
`chtmsg` int(50) NOT NULL default '0',
`chtroom` varchar(50) NOT NULL default '',
`requesting` varchar(100) NOT NULL default '',
`reqban` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=92 ;
--
-- Dumping data for table `users`
--
-- --------------------------------------------------------
--
-- Table structure for table `vartotoju`
--
CREATE TABLE `vartotoju` (
`laikas` int(15) NOT NULL default '0',
`ip` varchar(40) NOT NULL default '',
`file` varchar(100) NOT NULL default '',
PRIMARY KEY (`laikas`),
KEY `ip` (`ip`),
KEY `file` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Dumping data for table `vartotoju`
--