Файл: tables.sql
Строк: 312
--
-- Структура таблицы `adv`
--
CREATE TABLE IF NOT
EXISTS `adv` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gde` varchar(4)
NOT NULL,
`link` varchar(50) NOT NULL,
`name` varchar(60) NOT NULL,
`count` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`antimat`
--
CREATE TABLE IF NOT EXISTS `antimat` (
`mat_id` int(11)
unsigned NOT NULL AUTO_INCREMENT,
`mat_string` varchar(100) NOT NULL,
PRIMARY KEY (`mat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=122 ;
--
-- Структура таблицы
`ban`
--
CREATE TABLE IF NOT EXISTS `ban` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`login` text,
`ip` text,
`time` text,
`live`
text,
`ban` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`book`
--
CREATE TABLE IF NOT EXISTS `book` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`login` varchar(50) NOT NULL,
`msg` varchar(500) NOT
NULL,
`data` varchar(100) NOT NULL,
`ip` varchar(50) NOT NULL,
`brouser` varchar(50) NOT NULL,
`admin_login` varchar(75) NOT NULL,
`admin_msg` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`status` text
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`chat_msg`
--
CREATE TABLE IF NOT EXISTS `chat_msg` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`id_chat` int(11) NOT NULL,
`login` text NOT
NULL,
`msg` text NOT NULL,
`data` text NOT NULL,
`arbuz` text NOT
NULL,
`ip` text NOT NULL,
`time` text NOT NULL,
`privat` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `dating`
--
CREATE TABLE
IF NOT EXISTS `dating` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`name` text NOT NULL,
`sity` text NOT NULL,
`starna` text NOT NULL,
`data` text NOT NULL,
`about` text NOT
NULL,
`interes` text NOT NULL,
`music` text NOT NULL,
`movie` text
NOT NULL,
`book` text NOT NULL,
`status` text NOT NULL,
`oren`
text NOT NULL,
`znakom` text NOT NULL,
`brak` text NOT NULL,
`partner` text NOT NULL,
`rost` int(11) NOT NULL,
`ves` text NOT
NULL,
`glas` text NOT NULL,
`volos` text NOT NULL,
`body` text NOT
NULL,
`xarakter` text NOT NULL,
`zanim` text NOT NULL,
`prof` text
NOT NULL,
`smoke` text NOT NULL,
`img` text NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
Структура таблицы `ddos`
--
CREATE TABLE IF NOT EXISTS
`ddos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT
NULL,
`ip` varchar(50) NOT NULL,
`url` varchar(150) NOT NULL,
`refer` varchar(300) NOT NULL,
`brow` varchar(50) NOT NULL,
`user`
varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`diary`
--
CREATE TABLE IF NOT EXISTS `diary` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `diary_cat`
--
CREATE
TABLE IF NOT EXISTS `diary_cat` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_diary` int(11) NOT NULL,
`login` varchar(30) NOT
NULL,
`data` varchar(30) NOT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `diary_com`
--
CREATE
TABLE IF NOT EXISTS `diary_com` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_diary_note` int(11) NOT NULL,
`login` varchar(30)
NOT NULL,
`data` varchar(30) NOT NULL,
`msg` varchar(250) NOT NULL,
`time` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `diary_note`
--
CREATE TABLE IF NOT EXISTS `diary_note`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_diary_cat` int(11) NOT
NULL,
`login` varchar(30) NOT NULL,
`data` varchar(30) NOT NULL,
`name` varchar(70) NOT NULL,
`msg` varchar(1000) NOT NULL,
`count`
int(11) NOT NULL,
`status` varchar(10) NOT NULL,
`time` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`files`
--
CREATE TABLE IF NOT EXISTS `files` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`last` varchar(30)
NOT NULL,
`kb` varchar(30) NOT NULL,
`data` varchar(30) NOT NULL,
`link` varchar(300) NOT NULL,
`login` varchar(30) NOT NULL,
`type`
varchar(30) NOT NULL,
`opi` varchar(500) NOT NULL,
`count` int(11)
NOT NULL,
`time` varchar(30) NOT NULL,
`plus` int(11) NOT NULL,
`minus` int(11) NOT NULL,
`id_obmen` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `files_com`
--
CREATE
TABLE IF NOT EXISTS `files_com` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`file` varchar(150) NOT NULL,
`login` varchar(30) NOT
NULL,
`msg` varchar(200) NOT NULL,
`data` varchar(30) NOT NULL,
`time` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`files_com_status`
--
CREATE TABLE IF NOT EXISTS `files_com_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file` varchar(150) NOT NULL,
`status` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `files_my`
--
CREATE TABLE IF NOT EXISTS `files_my` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` varchar(300) NOT NULL,
`login` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `files_rat`
--
CREATE TABLE IF NOT EXISTS `files_rat`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`file` varchar(150) NOT
NULL,
`login` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `files_spam`
--
CREATE TABLE IF NOT
EXISTS `files_spam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_file`
int(11) NOT NULL,
`name` varchar(150) NOT NULL,
`ip` varchar(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`forum`
--
CREATE TABLE IF NOT EXISTS `forum` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`themes` text,
`pod_themes` text,
`login`
text,
`data` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `forum_themes`
--
CREATE TABLE IF NOT EXISTS
`forum_themes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`forum`
text,
`themes` text,
`login` text,
`mail_login` varchar(30) NOT
NULL,
`pod_themes` text,
`status` text,
`krep` text,
`time`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`forum_topic`
--
CREATE TABLE IF NOT EXISTS `forum_topic` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`themes` text,
`topic` text,
`login` text,
`message` text,
`data` text,
`time` text,
`privat` text,
`edit` varchar(150) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `friend`
--
CREATE
TABLE IF NOT EXISTS `friend` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` varchar(75) NOT NULL,
`friend` varchar(75) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `friend_att`
--
CREATE
TABLE IF NOT EXISTS `friend_att` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`my_login` varchar(75) NOT NULL,
`add` varchar(75)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`gallery`
--
CREATE TABLE IF NOT EXISTS `gallery` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 NOT NULL,
`login` varchar(30) CHARACTER SET utf8 NOT NULL,
`opi` varchar(100)
CHARACTER SET utf8 NOT NULL,
`data_reg` varchar(50) CHARACTER SET utf8
NOT NULL,
`data_edit` varchar(50) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`gallery_anti`
--
CREATE TABLE IF NOT EXISTS `gallery_anti` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_file` int(11) NOT NULL,
`login`
varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `gallery_com`
--
CREATE TABLE IF NOT EXISTS
`gallery_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_foto`
int(11) NOT NULL,
`login` varchar(50) NOT NULL,
`data` varchar(50)
NOT NULL,
`msg` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `gallery_foto`
--
CREATE TABLE IF NOT
EXISTS `gallery_foto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_gallery` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`opi`
varchar(100) NOT NULL,
`rat` int(11) NOT NULL,
`img` varchar(100) NOT
NULL,
`login` varchar(50) NOT NULL,
`size` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `guest`
--
CREATE TABLE IF
NOT EXISTS `guest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login`
varchar(50) NOT NULL,
`login` varchar(50) NOT NULL,
`data`
varchar(50) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;--
--
Структура таблицы `history_ban`
--
CREATE TABLE IF NOT
EXISTS `history_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login`
text NOT NULL,
`data` text NOT NULL,
`pri` text NOT NULL,
`status`
text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`ignor`
--
CREATE TABLE IF NOT EXISTS `ignor` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`my_login` varchar(75) NOT NULL,
`ignor`
varchar(75) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`title` varchar(150) NOT NULL,
`data` varchar(50) NOT
NULL,
`msg` varchar(500) NOT NULL,
`login` varchar(50) NOT NULL,
`count` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `news_com`
--
CREATE TABLE IF NOT
EXISTS `news_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login`
varchar(50) NOT NULL,
`msg` varchar(250) NOT NULL,
`data` varchar(50)
NOT NULL,
`id_news` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `obmen`
--
CREATE TABLE IF NOT EXISTS
`obmen` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`obmen_cat`
--
CREATE TABLE IF NOT EXISTS `obmen_cat` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`id_obmen` int(11) NOT NULL,
`name`
varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`present`
--
CREATE TABLE IF NOT EXISTS `present` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` text NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `present_c`
--
CREATE TABLE IF NOT
EXISTS `present_c` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_present` int(11) NOT NULL,
`name` varchar(75) NOT NULL,
`img`
varchar(50) NOT NULL,
`money` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `present_user`
--
CREATE TABLE IF NOT
EXISTS `present_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` varchar(20) NOT NULL,
`send_login` varchar(20) NOT NULL,
`msg` varchar(150) NOT NULL,
`data` varchar(50) NOT NULL,
`img`
varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`rating`
--
CREATE TABLE IF NOT EXISTS `rating` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`login` varchar(50) NOT NULL,
`data` varchar(50)
NOT NULL,
`rat` varchar(2) NOT NULL,
`msg` varchar(150) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`send_mail`
--
CREATE TABLE IF NOT EXISTS `send_mail` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`my_login` varchar(50) NOT NULL,
`send_login` varchar(50) NOT NULL,
`msg` varchar(500) NOT NULL,
`data` varchar(50) NOT NULL,
`status` int(11) NOT NULL,
KEY `id`
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `session`
--
CREATE TABLE IF NOT
EXISTS `session` (
`id_session` tinytext NOT NULL,
`putdate` datetime
NOT NULL,
`user` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
-- Структура таблицы
`session_chat`
--
CREATE TABLE IF NOT EXISTS `session_chat` (
`id_session` tinytext NOT NULL,
`putdate` datetime NOT NULL DEFAULT
'0000-00-00 00:00:00',
`user` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `session_user`
--
CREATE TABLE IF NOT
EXISTS `session_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
varchar(75) NOT NULL,
`time` int(11) NOT NULL,
`session_id`
varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`session_vic`
--
CREATE TABLE IF NOT EXISTS `session_vic` (
`id_session` tinytext NOT NULL,
`putdate` datetime NOT NULL DEFAULT
'0000-00-00 00:00:00',
`user` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `setting`
--
CREATE TABLE IF NOT
EXISTS `setting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`book`
varchar(10) NOT NULL,
`activ_email` int(11) NOT NULL,
`admin_mail`
varchar(75) NOT NULL,
`admin_pod` varchar(75) NOT NULL,
`ava_upload`
int(11) NOT NULL,
`check_key` varchar(10) NOT NULL,
`key` varchar(10)
NOT NULL,
`mail` int(11) NOT NULL,
`forum` int(11) NOT NULL,
`antiflood` int(11) NOT NULL,
`reg` varchar(5) NOT NULL,
`forum_index` int(11) NOT NULL,
`upload` int(11) NOT NULL,
`ddos`
varchar(5) NOT NULL,
`ddos_limit` int(11) NOT NULL,
`index_obmen`
varchar(5) NOT NULL,
`cron` varchar(10) NOT NULL,
`bank` int(11) NOT
NULL,
`game` int(11) NOT NULL,
`game_i` int(11) NOT NULL,
`site`
varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`site_keys`
--
--
-- Структура таблицы
`smiles`
--
CREATE TABLE IF NOT EXISTS `smiles` (
`smiles_id`
int(11) unsigned NOT NULL AUTO_INCREMENT,
`smiles_cats` smallint(4)
unsigned NOT NULL,
`smiles_name` varchar(20) NOT NULL,
`smiles_code`
varchar(20) NOT NULL,
PRIMARY KEY (`smiles_id`),
KEY `smiles_cats`
(`smiles_cats`),
KEY `smiles_code` (`smiles_code`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=128 ;
--
-- Структура
таблицы `spam`
--
CREATE TABLE IF NOT EXISTS `spam` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`spam` varchar(1000) NOT NULL,
`login` varchar(75) NOT NULL,
`data` varchar(100) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `tiket`
--
CREATE TABLE IF NOT EXISTS
`tiket` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(75)
NOT NULL,
`num` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS
`users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(50)
NOT NULL,
`pass` varchar(60) NOT NULL,
`email` varchar(50) NOT
NULL,
`status` int(11) NOT NULL,
`nik` varchar(50) NOT NULL,
`lost_pass_time` int(11) NOT NULL,
`ip` varchar(50) NOT NULL,
`last`
varchar(50) NOT NULL,
`pol` int(11) NOT NULL,
`activ` varchar(11) NOT
NULL,
`money` varchar(11) NOT NULL,
`bank` varchar(11) NOT NULL,
`level` int(11) NOT NULL,
`exp` varchar(11) NOT NULL,
`plus` int(11)
NOT NULL,
`minus` int(11) NOT NULL,
`data_reg` varchar(70) NOT
NULL,
`code_pass` varchar(10) NOT NULL,
`my_mail` int(11) NOT NULL,
`new` int(11) NOT NULL,
`ava` varchar(150) NOT NULL,
`x-status`
varchar(200) NOT NULL,
`activ_email` varchar(10) NOT NULL,
`rating`
varchar(100) NOT NULL,
`op_mail` varchar(5) NOT NULL,
`chat` int(11)
NOT NULL,
`mes_on_page` int(11) NOT NULL,
`vic` int(11) NOT NULL,
`hero` int(11) NOT NULL,
`time` int(11) NOT NULL,
`x_ava` int(11) NOT
NULL,
`y_ava` int(11) NOT NULL,
`theme` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `vic`
--
CREATE TABLE IF
NOT EXISTS `vic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vopros`
varchar(250) CHARACTER SET utf8 NOT NULL,
`otvet` text CHARACTER SET
utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Структура таблицы
`vic_msg`
--
CREATE TABLE IF NOT EXISTS `vic_msg` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`login` varchar(50) CHARACTER SET utf8 NOT NULL,
`msg` varchar(500) CHARACTER SET utf8 NOT NULL,
`data` varchar(50)
CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Структура
таблицы `vic_vopros`
--
CREATE TABLE IF NOT EXISTS `vic_vopros`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`vopros` varchar(500)
CHARACTER SET utf8 NOT NULL,
`otvet` varchar(50) CHARACTER SET utf8 NOT
NULL,
`pod` varchar(50) CHARACTER SET utf8 NOT NULL,
`pod_1`
varchar(50) CHARACTER SET utf8 NOT NULL,
`pod_2` varchar(50) CHARACTER
SET utf8 NOT NULL,
`step` varchar(10) CHARACTER SET utf8 NOT NULL,
`time` varchar(75) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `vote`
--
CREATE TABLE IF NOT EXISTS
`vote` (
`vote_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`vote_title` varchar(100) NOT NULL,
`vote_count` smallint(4) unsigned
NOT NULL DEFAULT '0',
`vote_closed` tinyint(1) unsigned NOT NULL DEFAULT
'0',
`vote_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY
(`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `voteanswer`
--
CREATE
TABLE IF NOT EXISTS `voteanswer` (
`answer_id` mediumint(8) unsigned NOT
NULL AUTO_INCREMENT,
`answer_vote_id` smallint(4) unsigned NOT NULL,
`answer_option` varchar(50) NOT NULL,
`answer_result` smallint(4)
unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`answer_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `votepoll`
--
CREATE TABLE IF NOT
EXISTS `votepoll` (
`poll_id` int(11) unsigned NOT NULL
AUTO_INCREMENT,
`poll_vote_id` smallint(4) unsigned NOT NULL,
`poll_user` varchar(20) NOT NULL,
PRIMARY KEY (`poll_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--
Структура таблицы `wall`
--
CREATE TABLE IF NOT EXISTS
`wall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`my_login` text
CHARACTER SET utf8 NOT NULL,
`send_login` text CHARACTER SET utf8 NOT
NULL,
`msg` text CHARACTER SET utf8 NOT NULL,
`data` text CHARACTER
SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;