Просмотр архива StrongCMS ver 1.0 beta

SET
SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-----------------------------------
SET
time_zone =
"+00:00";
-----------------------------------
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;

-----------------------------------
CREATE TABLE IF NOT EXISTS
`admin_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` varchar(255)
NOT NULL,
  `time` int(11) NOT NULL,
  `avtor` int(11) NOT NULL,
 
`id_komu` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
-----------------------------------
CREATE
TABLE IF NOT EXISTS `ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
 
`time_srok` varchar(255) DEFAULT NULL,
  `kogda` varchar(255) DEFAULT
NULL,
  `color` varchar(244) CHARACTER SET utf8 NOT NULL,
  `b` int(11) NOT
NULL DEFAULT '0',
  `i` int(11) NOT NULL DEFAULT '0',
  `tip` int(11) NOT
NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `antispam`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news` varchar(244) NOT NULL,
 
`stena` varchar(244) NOT NULL,
  `chat` varchar(244) NOT NULL,
 
`forum_tema` varchar(255) NOT NULL,
  `forum_post` varchar(255) NOT NULL,
 
`guest` varchar(255) NOT NULL,
  `blog` varchar(244) NOT NULL,
  `mes`
varchar(244) NOT NULL,
  `down` varchar(244) NOT NULL,
  `repa`
varchar(255) NOT NULL,
  `friends` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
-----------------------------------
INSERT INTO `antispam` (`id`, `news`,
`stena`, `chat`, `forum_tema`, `forum_post`, `guest`, `blog`, `mes`,
`down`, `repa`, `friends`) VALUES
(1, '60', '60', '60', '60', '60', '60',
'60', '60', '60', '4', '60');
-----------------------------------
CREATE
TABLE IF NOT EXISTS `ban_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`kto` varchar(255) DEFAULT NULL,
  `about` varchar(255) DEFAULT NULL,
 
`time_play` varchar(255) DEFAULT NULL,
  `time_end` varchar(255) DEFAULT
NULL,
  `add_ban` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `blog_com`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` text NOT NULL,
  `avtor`
varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `blog`
varchar(244) NOT NULL,
  `avtorlogin` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `blog_r`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`blog_reit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stat` varchar(244)
NOT NULL,
  `r` varchar(244) NOT NULL,
  `kto` varchar(100) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`blog_search` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meta`
varchar(100) NOT NULL,
  `kto` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`blog_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titlename`
varchar(100) NOT NULL,
  `text` text NOT NULL,
  `meta` varchar(100) NOT
NULL,
  `razdel` varchar(100) NOT NULL,
  `avtor` varchar(100) NOT NULL,
 
`time` varchar(100) NOT NULL,
  `readlen` varchar(244) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`chat_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room` int(10) NOT
NULL,
  `msg` text NOT NULL,
  `avtor` varchar(244) NOT NULL,
 
`avtorlogin` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
 
`color` varchar(25) NOT NULL,
  `emotion` varchar(40) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`chat_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(244)
NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `config`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `style` varchar(244) NOT NULL
DEFAULT 'style',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8
AUTO_INCREMENT=2 ;
-----------------------------------
INSERT INTO `config`
(`id`, `style`) VALUES
(1,
'default');
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11)
NOT NULL,
  `name_file` varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_kat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
varchar(244) NOT NULL,
  `name` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11)
NOT NULL,
  `kat` int(11) NOT NULL,
  `tema` int(11) NOT NULL,
  `text`
mediumtext NOT NULL,
  `us` varchar(255) NOT NULL,
  `time` varchar(255)
NOT NULL,
  `citata` mediumtext NOT NULL,
  `citata_us` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `forum_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(244) NOT NULL,
  `opis` varchar(255) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_tema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11)
NOT NULL,
  `kat` int(11) NOT NULL,
  `text` varchar(244) NOT NULL,
 
`name` varchar(244) NOT NULL,
  `us` varchar(255) NOT NULL,
  `time`
varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `up` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `forum_zaklad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tema`
varchar(244) NOT NULL,
  `us` varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `friends`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `us_a` int(11) NOT NULL,
 
`us_b` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `time` varchar(244)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` text NOT
NULL,
  `avtorlogin` varchar(244) NOT NULL,
  `avtor` varchar(244) NOT
NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `jalob_ba`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `about` text NOT NULL,
 
`avtor` varchar(244) NOT NULL,
  `komy` varchar(244) NOT NULL,
  `time`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
-----------------------------------
CREATE
TABLE IF NOT EXISTS `lenta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`text` text NOT NULL,
  `kto` varchar(100) NOT NULL,
  `komy` varchar(100)
NOT NULL,
  `time` varchar(100) NOT NULL,
  `readlen` varchar(1) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`lib_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(100) DEFAULT NULL,
  `opis` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `lib_stat`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11) NOT NULL,
 
`name` varchar(100) DEFAULT NULL,
  `opis` varchar(244) NOT NULL,
  `meta`
varchar(100) NOT NULL,
  `files` varchar(255) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `load_ban`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11) NOT NULL,
 
`addban_user` int(11) NOT NULL,
  `cause` varchar(244) NOT NULL,
  `time`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `load_com` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time`
varchar(244) NOT NULL,
  `msg` text NOT NULL,
  `avtorlogin` varchar(244)
NOT NULL,
  `file` varchar(244) NOT NULL,
  `ip` varchar(244) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `load_dir`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_dir` int(11) NOT NULL
DEFAULT '0',
  `url` text,
  `name` varchar(100) DEFAULT NULL,
  `icon`
varchar(244) NOT NULL,
  `files` varchar(1) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`load_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_dir` int(11)
NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `url` text,
  `time`
int(11) NOT NULL,
  `avtor` varchar(25) NOT NULL,
  `format` varchar(244)
NOT NULL,
  `about` text NOT NULL,
  `files` varchar(244) NOT NULL,
  `mod`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `load_reit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file`
varchar(244) NOT NULL,
  `r` varchar(244) NOT NULL,
  `kto` varchar(100)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `load_screen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id`
int(11) NOT NULL,
  `name_screen` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `message`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` varchar(244) NOT NULL,
 
`komy` varchar(244) NOT NULL,
  `text` text NOT NULL,
  `time` varchar(244)
NOT NULL,
  `readlen` varchar(1) NOT NULL,
  `file` varchar(244) NOT NULL
DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `message_c` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto`
varchar(244) NOT NULL,
  `kogo` varchar(244) NOT NULL,
  `time`
varchar(244) NOT NULL,
  `ignor` varchar(1) NOT NULL,
  `posl_time` int(11)
NOT NULL,
  `del` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`message_save` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text NOT
NULL,
  `kto` varchar(244) NOT NULL,
  `ktoavtor` varchar(244) NOT NULL,
 
`uid` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `news` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text NOT NULL,
  `avtor`
varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5
;
-----------------------------------
INSERT INTO `news` (`id`, `text`,
`avtor`, `time`) VALUES
(1, 'Доброго времени суток!
\r\nЕсли Вы увидели эту новость,значит
установка StrongCMS ver 1.0 beta прошла
успешно.\r\nСкачать эту Wap CMS, а так же
модули и обновления можно на официальном
сайте -
[url=http://strongcms.ru]http://StrongCMS.ru[/url]\r\nУдачи в
начинаниях! .пох.', '1',
'1386831074');
-----------------------------------
CREATE TABLE IF NOT
EXISTS `news_com` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time`
varchar(244) NOT NULL,
  `msg` text NOT NULL,
  `avtor` int(244) NOT NULL,

 `avtorlogin` varchar(244) NOT NULL,
  `news` varchar(244) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`photo_album` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `us` int(11) NOT
NULL,
  `name` varchar(244) NOT NULL,
  `info` varchar(244) NOT NULL,
 
`tip` int(11) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`photo_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(255) NOT NULL,
  `album_id` int(11) NOT NULL,
  `time` varchar(100)
NOT NULL,
  `files` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`photo_reit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `foto`
varchar(244) NOT NULL,
  `r` varchar(244) NOT NULL,
  `kto` varchar(100)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `repa_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text
NOT NULL,
  `kto` varchar(244) NOT NULL,
  `komy` varchar(244) NOT NULL,
 
`time` varchar(244) NOT NULL,
  `repa` varchar(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `rules` (

 `site` text NOT NULL,
  `forum` text NOT NULL,
  `chat` text NOT NULL
)
ENGINE=InnoDB DEFAULT
CHARSET=utf8;
-----------------------------------
INSERT INTO `rules`
(`site`, `forum`, `chat`) VALUES
('Правил пока нет!',
'Правил пока нет!', 'Правил пока
нет!');
-----------------------------------
CREATE TABLE IF NOT EXISTS
`settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` text NOT
NULL,
  `des` text NOT NULL,
  `cop` varchar(50) NOT NULL,
  `reg_on`
int(11) NOT NULL,
  `load_mod` int(11) NOT NULL,
  `counter` varchar(10000)
NOT NULL,
  `counter_all` varchar(10000) NOT NULL,
  `forum_post_m` int(11)
NOT NULL,
  `forum_tem_m` int(11) NOT NULL,
  `down_file_m` int(11) NOT
NULL,
  `guest_post_m` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
-----------------------------------
INSERT INTO `settings` (`id`, `key`,
`des`, `cop`, `reg_on`, `load_mod`, `counter`, `counter_all`,
`forum_post_m`, `forum_tem_m`, `down_file_m`, `guest_post_m`) VALUES
(1,
'StrongCMS.RU', 'StrongCMS.RU', 'StrongCMS.RU', 0, 1, 'Счётчики
на главной', 'Счётчики на остальных
страницах', 3, 1, 3,
1);
-----------------------------------
CREATE TABLE IF NOT EXISTS `smile`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(244) NOT NULL,
 
`icon` varchar(244) NOT NULL,
  `papka` varchar(30) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
-----------------------------------
INSERT INTO `smile` (`id`, `name`,
`icon`, `papka`) VALUES
(1, '.пох.', 'pox.png',
'1');
-----------------------------------
CREATE TABLE IF NOT EXISTS
`smile_p` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8
AUTO_INCREMENT=2 ;
-----------------------------------
INSERT INTO
`smile_p` (`id`, `name`) VALUES
(1,
'Разные');
-----------------------------------
CREATE TABLE IF NOT
EXISTS `stena` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` text NOT
NULL,
  `avtor` varchar(244) NOT NULL,
  `ukogo` varchar(244) NOT NULL,
 
`time` varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
-----------------------------------
CREATE
TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`login` varchar(20) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `sex`
varchar(1) NOT NULL,
  `name` varchar(30) NOT NULL,
  `email` varchar(40)
NOT NULL,
  `strana` varchar(255) NOT NULL,
  `gorod` varchar(255) NOT
NULL,
  `osebe` varchar(555) NOT NULL,
  `stat` varchar(555) NOT NULL,
 
`skype` varchar(555) NOT NULL,
  `icq` varchar(555) NOT NULL,
  `url`
varchar(555) NOT NULL,
  `money` varchar(50) NOT NULL DEFAULT '0',
 
`style` varchar(255) DEFAULT 'default',
  `news` int(11) NOT NULL,
 
`datareg` varchar(255) NOT NULL,
  `level` varchar(1) NOT NULL,
  `browser`
varchar(250) NOT NULL,
  `ip` varchar(250) NOT NULL,
  `viz` varchar(250)
NOT NULL,
  `online` varchar(250) NOT NULL,
  `gde` varchar(255) NOT NULL,

 `xstatus` varchar(255) NOT NULL,
  `color_nick` varchar(255) NOT NULL,
 
`max` int(30) NOT NULL DEFAULT '10',
  `avatar` varchar(255) NOT NULL,
 
`new_tem` int(11) NOT NULL,
  `new_files` int(11) NOT NULL,
  `rating`
varchar(244) DEFAULT '0',
  `form_file` int(11) NOT NULL DEFAULT '1',
 
`bb_panel` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;