mysql.sql

# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Õîñò: localhost
# Âðåìÿ ñîçäàíèÿ: Àâã 09 2009 ã., 20:22
# Âåðñèÿ ñåðâåðà: 3.23.53
# Âåðñèÿ PHP: 4.3.6
# 
# ÁÄ : `mysql`
# 

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `messages`
#

CREATE TABLE `messages` (
  `id` int(9) NOT NULL auto_increment,
  `author` varchar(15) NOT NULL default '',
  `poluchatel` varchar(15) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# Äàìï äàííûõ òàáëèöû `messages`
#


# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `oshibka`
#

CREATE TABLE `oshibka` (
  `ip` varchar(12) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `col` int(1) NOT NULL default '0'
) TYPE=MyISAM;

#
# Äàìï äàííûõ òàáëèöû `oshibka`
#


# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `users`
#

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(15) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `avatar` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `activation` int(1) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=41 ;

#
# Äàìï äàííûõ òàáëèöû `users`
#