-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 23, 2005 at 05:53 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: `chat`
--

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

--
-- Table structure for table `autoban`
--

CREATE TABLE `autoban` (
`ban` varchar(11) NOT NULL default '',
`messtime` int(11) NOT NULL default '0',
`kas` varchar(11) NOT NULL default '',
`info` varchar(200) NOT NULL default '',
`kodel` varchar(200) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `autoban`
--


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

--
-- Table structure for table `balsavimas`
--

CREATE TABLE `balsavimas` (
`id` int(11) NOT NULL auto_increment,
`atsakymas` varchar(50) NOT NULL default '',
`kas` varchar(11) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `balsavimas`
--


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

--
-- Table structure for table `ban`
--

CREATE TABLE `ban` (
`ban` varchar(11) NOT NULL default '',
`messtime` int(11) NOT NULL default '0',
`kas` varchar(11) NOT NULL default '',
`info` varchar(200) NOT NULL default '',
`kodel` varchar(200) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `ban`
--


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

--
-- Table structure for table `count`
--

CREATE TABLE `count` (
`ip` varchar(15) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`kanalas` varchar(15) NOT NULL default '',
`info` varchar(200) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `count`
--

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

--
-- Table structure for table `privatas`
--

CREATE TABLE `privatas` (
`kviecia` varchar(11) NOT NULL default '',
`ka` varchar(11) NOT NULL default '',
`kanalas` varchar(11) NOT NULL default '',
`laikas` varchar(11) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `privatas`
--

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

--
-- Table structure for table `privatepm`
--

CREATE TABLE `privatepm` (
`id` int(99) NOT NULL auto_increment,
`unread` varchar(5) NOT NULL default '',
`sentby` varchar(255) NOT NULL default '',
`sentto` varchar(255) NOT NULL default '',
`text` varchar(255) NOT NULL default '',
`date` varchar(100) NOT NULL default '',
`timesent` varchar(50) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

--
-- Dumping data for table `privatepm`
--

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

--
-- Table structure for table `stop`
--

CREATE TABLE `stop` (
`ID` smallint(5) NOT NULL auto_increment,
`ar` smallint(2) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `stop`
--


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

--
-- Table structure for table `topic`
--

CREATE TABLE `topic` (
`id` smallint(5) NOT NULL auto_increment,
`topic` varchar(255) NOT NULL default '',
`kas` varchar(11) NOT NULL default '',
`laikas` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

--
-- Dumping data for table `topic`
--

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
`ID` smallint(5) NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`email` varchar(30) NOT NULL default '',
`sk` mediumint(6) NOT NULL default '0',
`aprashymas` varchar(120) NOT NULL default '',
`rangas` smallint(2) NOT NULL default '1',
`config` smallint(5) NOT NULL default '20101',
`vardas` varchar(50) NOT NULL default '',
`miestas` varchar(99) NOT NULL default '',
`hobis` varchar(255) NOT NULL default '',
`ugis` char(3) NOT NULL default '',
`svoris` char(3) NOT NULL default '',
`amzius` smallint(2) NOT NULL default '0',
`foto` varchar(200) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `user`
--

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

--
-- Table structure for table `wapchat`
--

CREATE TABLE `wapchat` (
`mynick` varchar(11) NOT NULL default '',
`mymess` varchar(120) NOT NULL default '',
`kanalas` varchar(12) NOT NULL default '',
`messtime` int(11) NOT NULL default '0',
KEY `mynick` (`mynick`)
) TYPE=MyISAM;

--
-- Dumping data for table `wapchat`
--