View file ilichat3.9/ilichat/sql.txt

Милый пушистый сайт !!!!
File size: 11.96Kb 
-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Сен 22 2007 г., 10:08
-- Версия сервера: 4.1.16
-- Версия PHP: 4.4.2
-- 
-- БД: `ilichat`
-- 

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

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

CREATE TABLE `chat1` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=15 ;

-- 
-- Дамп данных таблицы `chat1`
-- 


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

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

CREATE TABLE `chat2` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

-- 
-- Дамп данных таблицы `chat2`
-- 

INSERT INTO `chat2` VALUES (1, 1, 'wer', 'cvbcvb', 0, '10:05:47', 1190441147);
INSERT INTO `chat2` VALUES (2, 1, 'wer', 'cvbcvbcvbcvb', 0, '10:05:52', 1190441152);

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

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

CREATE TABLE `chat3` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat3`
-- 


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

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

CREATE TABLE `chat4` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinytext NOT NULL,
  `msg` text NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinytext NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=37 ;

-- 
-- Дамп данных таблицы `chat4`
-- 


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

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

CREATE TABLE `chat_bad_answers` (
  `id` int(11) NOT NULL auto_increment,
  `answer` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_bad_answers`
-- 


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

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

CREATE TABLE `chat_banned` (
  `id` int(11) NOT NULL auto_increment,
  `ip` tinyblob NOT NULL,
  `ua` tinyblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_banned`
-- 


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

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

CREATE TABLE `chat_banned_nicknames` (
  `id` int(11) NOT NULL auto_increment,
  `nickname` tinyblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_banned_nicknames`
-- 


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

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

CREATE TABLE `chat_ignor` (
  `id` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
-- Дамп данных таблицы `chat_ignor`
-- 


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

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

CREATE TABLE `chat_insults` (
  `id` int(11) NOT NULL auto_increment,
  `insult` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_insults`
-- 


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

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

CREATE TABLE `chat_intim` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `nickname` tinyblob NOT NULL,
  `msg` blob NOT NULL,
  `key` tinyblob NOT NULL,
  `to` int(11) NOT NULL default '0',
  `time` tinyblob NOT NULL,
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_intim`
-- 


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

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

CREATE TABLE `chat_jokes` (
  `id` int(6) NOT NULL auto_increment,
  `joke` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_jokes`
-- 


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

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

CREATE TABLE `chat_letters` (
  `lid` int(11) unsigned NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `to` int(11) unsigned NOT NULL default '0',
  `from` int(11) unsigned NOT NULL default '0',
  `subject` tinyblob NOT NULL,
  `body` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) unsigned NOT NULL default '0',
  `read` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

-- 
-- Дамп данных таблицы `chat_letters`
-- 

INSERT INTO `chat_letters` VALUES (1, 1, 1, 1, 0xd0a1d0bfd0b0d181d0b8d0b1d0be20d0b7d0b020d180d0b5d0b3d0b8d181d182d180d0b0d186d0b8d18e, 0xd0a1d0bfd0b0d181d0b8d0b1d0be20d0b7d0b020d180d0b5d0b3d0b8d181d182d180d0b0d186d0b8d18e20d0b220d0bdd0b0d188d0b5d0bc20d187d0b0d182d0b52e20d0a2d0b5d0b1d0b520d182d183d18220d0bed0b1d18fd0b7d0b0d182d0b5d0bbd18cd0bdd0be20d0bfd0bed0bdd180d0b0d0b2d0b8d182d181d18f2e203a29, 0x30362d30392d32303130, 1283760917, 1);
INSERT INTO `chat_letters` VALUES (2, 2, 2, 1, 0xd0a1d0bfd0b0d181d0b8d0b1d0be20d0b7d0b020d180d0b5d0b3d0b8d181d182d180d0b0d186d0b8d18e, 0xd0a1d0bfd0b0d181d0b8d0b1d0be20d0b7d0b020d180d0b5d0b3d0b8d181d182d180d0b0d186d0b8d18e20d0b220d0bdd0b0d188d0b5d0bc20d187d0b0d182d0b52e20d0a2d0b5d0b1d0b520d182d183d18220d0bed0b1d18fd0b7d0b0d182d0b5d0bbd18cd0bdd0be20d0bfd0bed0bdd180d0b0d0b2d0b8d182d181d18f2e203a29, 0x31302d30392d32303130, 1284116482, 0);
INSERT INTO `chat_letters` VALUES (3, 3, 3, 1, 0xd0a1d0bfd0b0d181d0b8d0b1d0be20d0b7d0b020d180d0b5d0b3d0b8d181d182d180d0b0d186d0b8d18e, 0xd0a1d0bfd0b0d181d0b8d0b1d0be20d0b7d0b020d180d0b5d0b3d0b8d181d182d180d0b0d186d0b8d18e20d0b220d0bdd0b0d188d0b5d0bc20d187d0b0d182d0b52e20d0a2d0b5d0b1d0b520d182d183d18220d0bed0b1d18fd0b7d0b0d182d0b5d0bbd18cd0bdd0be20d0bfd0bed0bdd180d0b0d0b2d0b8d182d181d18f2e203a29, 0x31392d30392d32303037, 1190204594, 0);

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

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

CREATE TABLE `chat_logs` (
  `id` int(11) NOT NULL auto_increment,
  `moder` tinyblob NOT NULL,
  `action` tinyint(1) NOT NULL default '0',
  `object` tinyblob NOT NULL,
  `blob` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_logs`
-- 


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

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

CREATE TABLE `chat_meets` (
  `id` int(11) NOT NULL auto_increment,
  `author` tinyblob NOT NULL,
  `title` tinyblob NOT NULL,
  `body` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_meets`
-- 


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

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

CREATE TABLE `chat_news` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `name` tinyblob NOT NULL,
  `author` tinyblob NOT NULL,
  `blob` blob NOT NULL,
  `date` tinyblob NOT NULL,
  `time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_news`
-- 


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

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

CREATE TABLE `chat_questions` (
  `id` int(6) NOT NULL auto_increment,
  `question` blob NOT NULL,
  `answer` tinyblob NOT NULL,
  `translit` tinyblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `chat_questions`
-- 


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

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

CREATE TABLE `chat_rooms` (
  `id` int(11) NOT NULL auto_increment,
  `name` tinyblob NOT NULL,
  `position` int(6) NOT NULL default '0',
  `topic` tinyblob NOT NULL,
  `type` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=10 ;

-- 
-- Дамп данных таблицы `chat_rooms`
-- 

INSERT INTO `chat_rooms` VALUES (1, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 0, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 0);
INSERT INTO `chat_rooms` VALUES (2, 0xd093d0bed181d182d0b8d0bdd0b0d18f, 0, 0xd093d0bed181d182d0b8d0bdd0b0d18f, 0);
INSERT INTO `chat_rooms` VALUES (3, 0xd0a2d183d0b0d0bbd0b5d18220d0b7d0bdd0b0d182d0bed0bad0bed0b2, 0, 0xd0a2d183d0b0d0bbd0b5d18220d0b7d0bdd0b0d182d0bed0bad0bed0b2, 0);
INSERT INTO `chat_rooms` VALUES (4, 0xd0a2d183d0b0d0bbd0b5d182, 0, 0xd0a2d183d0b0d0bbd0b5d182, 0);

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

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

CREATE TABLE `chat_users` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `nickname` tinyblob NOT NULL,
  `password` tinytext NOT NULL,
  `ip` tinyblob NOT NULL,
  `ua` blob NOT NULL,
  `level` tinyint(1) NOT NULL default '0',
  `photo` tinyblob NOT NULL,
  `invisible` tinyint(1) NOT NULL default '0',
  `status` tinyblob NOT NULL,
  `kick` int(11) unsigned NOT NULL default '0',
  `moder` tinyblob NOT NULL,
  `reason` blob NOT NULL,
  `ban` tinyint(1) NOT NULL default '0',
  `name` tinyblob NOT NULL,
  `sex` tinyint(1) NOT NULL default '0',
  `email` blob NOT NULL,
  `site` blob NOT NULL,
  `birthday` tinyblob NOT NULL,
  `from` blob NOT NULL,
  `mobile` tinyblob NOT NULL,
  `about` blob NOT NULL,
  `posts` int(11) NOT NULL default '0',
  `answers` int(11) NOT NULL default '0',
  `gbalans` int(11) NOT NULL default '0',
  `smiles` tinyint(1) NOT NULL default '1',
  `translit` tinyint(1) NOT NULL default '0',
  `msgs` tinyint(2) NOT NULL default '5',
  `refresh` tinyint(3) unsigned NOT NULL default '20',
  `fsize` tinyint(1) NOT NULL default '1',
  `security` tinyint(1) NOT NULL default '1',
  `place` mediumint(9) NOT NULL default '0',
  `time` int(11) unsigned NOT NULL default '0',
  `intim` int(11) unsigned NOT NULL default '0',
  `key` tinyblob NOT NULL,
  `regdate` tinyblob NOT NULL,
  `hidden` tinyint(1) NOT NULL default '0',
  `mood` tinyint(2) NOT NULL default '0',
  `default` tinyint(1) NOT NULL default '0',
  `emotions` tinyint(1) NOT NULL default '1',
  `system` tinyint(1) NOT NULL default '1',
  `gzip` tinyint(1) NOT NULL default '0',
  `sftky` int(6) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

-- 
-- Дамп данных таблицы `chat_users`
-- 

INSERT INTO `chat_users` VALUES (1, 0x776572, '22c276a05aa7c90566ae2175bcc2a9b0', 0x3132372e302e302e31, 0x4f706572612f392e3032202857696e646f7773204e5420352e313b20553b20727529, 4, '', 0, 0xd09dd0bed0b2d0b8d187d0bed0ba, 0, '', '', 0, '', 0, '', '', 0x302d302d30, '', 0x4f70657261, '', 101, 0, 0, 1, 0, 5, 20, 1, 1, 0, 1190441355, 1189836968, 0x776572, 0x31302d30392d3130, 0, 0, 0, 1, 1, 0, 120456);
INSERT INTO `chat_users` VALUES (3, 0x617364, '7815696ecbf1c96e6894b779456d330e', 0x3132372e302e302e31, 0x4f706572612f392e3032202857696e646f7773204e5420352e313b20553b20727529, 0, '', 0, 0xd09dd0bed0b2d0b8d187d0bed0ba, 0, '', '', 0, '', 0, '', '', 0x302d302d30, '', 0x4f70657261, '', 7, 0, 0, 1, 0, 5, 20, 1, 1, 2, 1190205661, 0, '', 0x31392d30392d3037, 0, 0, 0, 1, 1, 0, 0);