View file frends.sql

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

DROP TABLE IF EXISTS `frends`;
CREATE TABLE IF NOT EXISTS `frends` (
`id` int(11) unsigned NOT NULL auto_increment,
`user_login` varchar(20) NOT NULL default '',
`frend_login` varchar(11) NOT NULL default '',
`time` int(11) unsigned NOT NULL,
`level` smallint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY  (`id`),
KEY `user_login` (`user_login`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `frends`
--

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

DROP TABLE IF EXISTS `new_frends`;
CREATE TABLE IF NOT EXISTS `new_frends` (
`id` int(11) unsigned NOT NULL auto_increment,
`user_login` varchar(20) NOT NULL default '',
`frend_login` varchar(11) NOT NULL default '',
`time` int(11) unsigned NOT NULL,
`message` text NOT NULL,
`level` smallint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_login` (`user_login`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `frends_new`
--