View file tables.sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Структура таблицы `actmail`
--

CREATE TABLE IF NOT EXISTS `actmail` (
  `login` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `code` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `anket`
--

CREATE TABLE IF NOT EXISTS `anket` (
  `id` int(10) NOT NULL auto_increment,
  `login` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `pass` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `lastdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `online` smallint(1) NOT NULL default '0',
  `room` int(5) default NULL,
  `photo` int(11) NOT NULL default '0',
  `defphoto` int(11) NOT NULL default '1',
  `loadcode` varchar(8) NOT NULL,
  `regdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `loginmask` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `emailactive` smallint(1) NOT NULL default '0',
  `mesmail` smallint(1) NOT NULL default '0',
  `caponpage` int(10) default NULL,
  `mesonpage` int(10) default NULL,
  `autoupdate` varchar(10) character set utf8 collate utf8_bin default NULL,
  `best` tinyint(1) NOT NULL default '0',
  `bestdate` datetime default NULL,
  `ip` varchar(20) character set utf8 collate utf8_bin default NULL,
  `ua` varchar(100) character set utf8 collate utf8_bin default NULL,
  `banned` tinyint(1) NOT NULL default '0',
  `bandate` datetime default NULL,
  `email` varchar(100) character set utf8 collate utf8_bin default NULL,
  `icq` varchar(100) character set utf8 collate utf8_bin default NULL,
  `sex` varchar(10) character set utf8 collate utf8_bin default NULL,
  `so` char(1) character set utf8 collate utf8_bin default NULL,
  `name` varchar(70) character set utf8 collate utf8_bin default NULL,
  `vozrast` varchar(2) character set utf8 collate utf8_bin default NULL,
  `rost` varchar(10) character set utf8 collate utf8_bin default NULL,
  `zodiak` varchar(50) character set utf8 collate utf8_bin default NULL,
  `glaza` varchar(50) character set utf8 collate utf8_bin default NULL,
  `tel` varchar(30) character set utf8 collate utf8_bin default NULL,
  `site` varchar(100) character set utf8 collate utf8_bin default NULL,
  `task` varchar(255) character set utf8 collate utf8_bin default NULL,
  `info` text character set utf8 collate utf8_bin,
  `region` int(5) NOT NULL default '0',
  `rating` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `antirep`
--

CREATE TABLE IF NOT EXISTS `antirep` (
  `repcode` varchar(5) character set utf8 collate utf8_bin NOT NULL default '',
  `lastdate` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `ban`
--

CREATE TABLE IF NOT EXISTS `ban` (
  `ip` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
  `ua` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `bandate` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `chat`
--

CREATE TABLE IF NOT EXISTS `chat` (
  `id` int(10) NOT NULL auto_increment,
  `fromn` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `body` text character set utf8 collate utf8_bin NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `r` int(5) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `fototop`
--

CREATE TABLE IF NOT EXISTS `fototop` (
  `aid` int(10) NOT NULL,
  `fid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `friends`
--

CREATE TABLE IF NOT EXISTS `friends` (
  `alogin` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `flogin` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `ignor`
--

CREATE TABLE IF NOT EXISTS `ignor` (
  `alogin` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `ignlogin` varchar(50) character set utf8 collate utf8_bin NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(10) NOT NULL auto_increment,
  `komu` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `ot` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `body` text character set utf8 collate utf8_bin,
  `new` smallint(1) NOT NULL default '1',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(10) NOT NULL auto_increment,
  `date` datetime NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `rooms`
--

CREATE TABLE IF NOT EXISTS `rooms` (
  `id` int(5) NOT NULL auto_increment,
  `title` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;