[color=#808030; ]#[/color] phpMyAdmin SQL Dump [color=#808030; ]#[/color] version [color=#008000; ]2.5[/color][color=#808030; ].[/color][color=#008c00; ]3[/color][color=#808030; ]-[/color]rc1 [color=#808030; ]#[/color] [color=#808030; ][[/color]url http:[color=#808030; ]/[/color][color=#808030; ]/[/color]www[color=#808030; ].[/color]phpmyadmin[color=#808030; ].[/color]net[color=#808030; ]|[/color]http:[color=#808030; ]/[/color][color=#808030; ]/[/color]www[color=#808030; ].[/color]phpmyadmin[color=#808030; ].[/color]net[color=#808030; ]][/color] [color=#808030; ]#[/color] [color=#808030; ]#[/color] [color=#e34adc; ]Хост:[/color] localhost [color=#808030; ]#[/color] Время [color=#e34adc; ]создания:[/color] Фев [color=#008c00; ]02[/color] [color=#008c00; ]2004[/color] г[color=#808030; ].[/color][color=#808030; ],[/color] [color=#008c00; ]19[/color]:29 [color=#808030; ]#[/color] Версия [color=#e34adc; ]сервера:[/color] [color=#008000; ]4.0[/color][color=#808030; ].[/color][color=#008c00; ]16[/color] [color=#808030; ]#[/color] Версия [color=#e34adc; ]PHP:[/color] [color=#008000; ]4.3[/color][color=#808030; ].[/color][color=#008c00; ]4[/color] [color=#808030; ]#[/color] [color=#808030; ]#[/color] [color=#e34adc; ]БД :[/color] `FORUM` [color=#808030; ]#[/color] [color=#808030; ]#[/color] [color=#696969; ]--------------------------------------------------------[/color] [color=#808030; ]#[/color] [color=#808030; ]#[/color] Структура таблицы `ib_groups` [color=#808030; ]#[/color] CREATE TABLE `ib_groups` [color=#808030; ]([/color] `g_id` int[color=#808030; ]([/color][color=#008c00; ]3[/color][color=#808030; ])[/color] unsigned NOT NULL auto_increment[color=#808030; ],[/color] `g_view_board` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_mem_info` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_other_topics` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_use_search` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_email_friend` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_invite_friend` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_edit_profile` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_post_new_topics` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_reply_own_topics` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_reply_other_topics` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_edit_posts` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_delete_own_posts` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_open_close_posts` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_delete_own_topics` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_post_polls` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_vote_polls` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_use_pm` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_is_supmod` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_access_cp` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_title` varchar[color=#808030; ]([/color][color=#008c00; ]32[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `g_can_remove` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_append_edit` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_access_offline` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_avoid_q` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_avoid_flood` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_icon` varchar[color=#808030; ]([/color][color=#008c00; ]64[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_attach_max` bigint[color=#808030; ]([/color][color=#008c00; ]20[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_avatar_upload` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `g_calendar_post` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `prefix` varchar[color=#808030; ]([/color][color=#008c00; ]250[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `suffix` varchar[color=#808030; ]([/color][color=#008c00; ]250[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `g_max_messages` int[color=#808030; ]([/color][color=#008c00; ]5[/color][color=#808030; ])[/color] default [color=#0000e6; ]'50'[/color][color=#808030; ],[/color] `g_max_mass_pm` int[color=#808030; ]([/color][color=#008c00; ]5[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `g_search_flood` mediumint[color=#808030; ]([/color][color=#008c00; ]6[/color][color=#808030; ])[/color] default [color=#0000e6; ]'20'[/color][color=#808030; ],[/color] `g_edit_cutoff` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `g_promotion` varchar[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default [color=#0000e6; ]'-1&-1'[/color][color=#808030; ],[/color] `g_hide_from_list` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `g_post_closed` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `g_perm_id` varchar[color=#808030; ]([/color][color=#008c00; ]255[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `g_photo_max_vars` varchar[color=#808030; ]([/color][color=#008c00; ]200[/color][color=#808030; ])[/color] default [color=#0000e6; ]'100:250:250'[/color][color=#808030; ],[/color] `g_dohtml` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `g_edit_topic` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `g_email_limit` varchar[color=#808030; ]([/color][color=#008c00; ]15[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'10:15'[/color][color=#808030; ],[/color] PRIMARY KEY [color=#808030; ]([/color]`g_id`[color=#808030; ])[/color] [color=#808030; ])[/color] TYPE[color=#808030; ]=[/color]MyISAM AUTO_INCREMENT[color=#808030; ]=[/color][color=#008c00; ]12[/color] [color=#808030; ];[/color] [color=#808030; ]#[/color] [color=#696969; ]--------------------------------------------------------[/color] [color=#808030; ]#[/color] [color=#808030; ]#[/color] Структура таблицы `ib_members` [color=#808030; ]#[/color] CREATE TABLE `ib_members` [color=#808030; ]([/color] `id` mediumint[color=#808030; ]([/color][color=#008c00; ]8[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `ubb_id` int[color=#808030; ]([/color][color=#008c00; ]11[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `name` varchar[color=#808030; ]([/color][color=#008c00; ]32[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `mgroup` smallint[color=#808030; ]([/color][color=#008c00; ]3[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `password` varchar[color=#808030; ]([/color][color=#008c00; ]32[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `email` varchar[color=#808030; ]([/color][color=#008c00; ]60[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `joined` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `ip_address` varchar[color=#808030; ]([/color][color=#008c00; ]16[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `avatar` varchar[color=#808030; ]([/color][color=#008c00; ]128[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `avatar_size` varchar[color=#808030; ]([/color][color=#008c00; ]9[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `posts` mediumint[color=#808030; ]([/color][color=#008c00; ]7[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `aim_name` varchar[color=#808030; ]([/color][color=#008c00; ]40[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `icq_number` varchar[color=#808030; ]([/color][color=#008c00; ]40[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `location` varchar[color=#808030; ]([/color][color=#008c00; ]128[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `signature` text[color=#808030; ],[/color] `website` varchar[color=#808030; ]([/color][color=#008c00; ]70[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `yahoo` varchar[color=#808030; ]([/color][color=#008c00; ]32[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `title` varchar[color=#808030; ]([/color][color=#008c00; ]64[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `allow_admin_mails` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `time_offset` varchar[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `interests` text[color=#808030; ],[/color] `hide_email` varchar[color=#808030; ]([/color][color=#008c00; ]8[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `email_pm` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `email_full` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `skin` smallint[color=#808030; ]([/color][color=#008c00; ]5[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `warn_level` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `warn_lastwarn` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `language` varchar[color=#808030; ]([/color][color=#008c00; ]32[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `msnname` varchar[color=#808030; ]([/color][color=#008c00; ]64[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `last_post` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `restrict_post` varchar[color=#808030; ]([/color][color=#008c00; ]100[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `view_sigs` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'1'[/color][color=#808030; ],[/color] `view_img` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'1'[/color][color=#808030; ],[/color] `view_avs` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'1'[/color][color=#808030; ],[/color] `view_pop` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'1'[/color][color=#808030; ],[/color] `bday_day` int[color=#808030; ]([/color][color=#008c00; ]2[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `bday_month` int[color=#808030; ]([/color][color=#008c00; ]2[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `bday_year` int[color=#808030; ]([/color][color=#008c00; ]4[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `new_msg` tinyint[color=#808030; ]([/color][color=#008c00; ]2[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `msg_from_id` mediumint[color=#808030; ]([/color][color=#008c00; ]8[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `msg_msg_id` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `msg_total` smallint[color=#808030; ]([/color][color=#008c00; ]5[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `vdirs` text[color=#808030; ],[/color] `show_popup` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `misc` varchar[color=#808030; ]([/color][color=#008c00; ]128[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `last_visit` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `last_activity` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `dst_in_use` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `view_prefs` varchar[color=#808030; ]([/color][color=#008c00; ]64[/color][color=#808030; ])[/color] default [color=#0000e6; ]'-1&-1'[/color][color=#808030; ],[/color] `coppa_user` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `mod_posts` varchar[color=#808030; ]([/color][color=#008c00; ]100[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `auto_track` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `org_supmod` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] default [color=#0000e6; ]'0'[/color][color=#808030; ],[/color] `org_perm_id` varchar[color=#808030; ]([/color][color=#008c00; ]255[/color][color=#808030; ])[/color] default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `temp_ban` varchar[color=#808030; ]([/color][color=#008c00; ]100[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `integ_msg` varchar[color=#808030; ]([/color][color=#008c00; ]250[/color][color=#808030; ])[/color] default [color=#0000e6; ]''[/color][color=#808030; ],[/color] `rep` int[color=#808030; ]([/color][color=#008c00; ]10[/color][color=#808030; ])[/color] default NULL[color=#808030; ],[/color] `allow_rep` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'1'[/color][color=#808030; ],[/color] `allow_anon` tinyint[color=#808030; ]([/color][color=#008c00; ]1[/color][color=#808030; ])[/color] NOT NULL default [color=#0000e6; ]'1'[/color][color=#808030; ],[/color] PRIMARY KEY [color=#808030; ]([/color]`id`[color=#808030; ])[/color][color=#808030; ],[/color] KEY `name` [color=#808030; ]([/color]`name`[color=#808030; ])[/color][color=#808030; ],[/color] KEY `mgroup` [color=#808030; ]([/color]`mgroup`[color=#808030; ])[/color][color=#808030; ],[/color] KEY `bday_day` [color=#808030; ]([/color]`bday_day`[color=#808030; ])[/color][color=#808030; ],[/color] KEY `bday_month` [color=#808030; ]([/color]`bday_month`[color=#808030; ])[/color] [color=#808030; ])[/color] TYPE[color=#808030; ]=[/color]MyISAM[color=#808030; ];[/color] |