Просмотр файла sys/db_tables/users_konts.sql
- CREATE TABLE IF NOT EXISTS `users_konts` (
- `id_user` int(11) NOT NULL,
- `id_kont` int(11) NOT NULL,
- `time` int(11) NOT NULL,
- `new_msg` int(11) NOT NULL default '0',
- `type` enum('common','ignor','favorite','deleted') NOT NULL default 'common',
- `name` varchar(64) default NULL,
- UNIQUE KEY `id_user` (`id_user`,`id_kont`),
- KEY `type` (`type`),
- KEY `time` (`time`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;