CREATE TABLE `ipb_core_members` (
`member_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`member_group_id` smallint(3) NOT NULL DEFAULT '0',
`email` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`joined` int(10) NOT NULL DEFAULT '0',
`ip_address` varchar(46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`allow_admin_mails` bit(1) DEFAULT b'0',
`skin` smallint(5) DEFAULT NULL,
`warn_level` int(10) DEFAULT NULL,
`warn_lastwarn` int(10) NOT NULL DEFAULT '0',
`language` mediumint(4) DEFAULT NULL,
`restrict_post` int(10) NOT NULL DEFAULT '0',
`bday_day` int(2) DEFAULT NULL,
`bday_month` int(2) DEFAULT NULL,
`bday_year` int(4) DEFAULT NULL,
`msg_count_new` int(2) NOT NULL DEFAULT '0',
`msg_count_total` int(3) NOT NULL DEFAULT '0',
`msg_count_reset` int(1) NOT NULL DEFAULT '0',
`msg_show_notification` int(1) NOT NULL DEFAULT '0',
`misc` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_visit` int(10) DEFAULT '0',
`last_activity` int(10) DEFAULT '0',
`mod_posts` int(10) NOT NULL DEFAULT '0',
`auto_track` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '0',
`temp_ban` int(10) DEFAULT '0',
`mgroup_others` varchar(245) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`member_login_key_expire` int(10) NOT NULL DEFAULT '0',
`has_blog` text COLLATE utf8mb4_unicode_ci,
`blogs_recache` tinyint(1) DEFAULT NULL,
`has_gallery` tinyint(1) NOT NULL DEFAULT '0',
`members_seo_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`members_cache` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`members_disable_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 - not disabled, 1 - disabled, member can re-enable, 2 - disabled',
`failed_logins` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`failed_login_count` smallint(3) NOT NULL DEFAULT '0',
`members_profile_views` int(10) UNSIGNED NOT NULL DEFAULT '0',
`members_pass_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`members_pass_salt` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`members_bitoptions` int(10) UNSIGNED NOT NULL DEFAULT '0',
`members_day_posts` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0,0',
`notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
`pp_last_visitors` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`pp_main_photo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`pp_main_width` int(5) DEFAULT NULL,
`pp_main_height` int(5) DEFAULT NULL,
`pp_thumb_photo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`pp_thumb_width` int(5) DEFAULT NULL,
`pp_thumb_height` int(5) DEFAULT NULL,
`pp_setting_count_comments` int(2) DEFAULT NULL,
`pp_reputation_points` int(10) DEFAULT NULL,
`pp_photo_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`signature` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`pconversation_filters` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`pp_customization` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`timezone` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`pp_cover_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`profilesync` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`profilesync_lastsync` int(10) NOT NULL DEFAULT '0' COMMENT 'Indicates the last time any profile sync service was ran',
`members_bitoptions2` int(10) UNSIGNED NOT NULL DEFAULT '0',
`create_menu` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT 'Cached contents of the "Create" drop down menu.',
`marked_site_read` int(10) UNSIGNED DEFAULT '0',
`pp_cover_offset` int(10) NOT NULL DEFAULT '0',
`acp_language` mediumint(9) DEFAULT NULL,
`member_title` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`member_posts` mediumint(7) NOT NULL DEFAULT '0',
`member_last_post` int(10) DEFAULT NULL,
`member_streams` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`photo_last_update` int(10) DEFAULT NULL,
`mfa_details` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`failed_mfa_attempts` smallint(3) UNSIGNED DEFAULT '0' COMMENT 'Number of times tried and failed MFA',
`permission_array` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT 'A cache of the clubs and social groups that the member is in',
`pp_setting_count_visitors` tinyint(1) NOT NULL DEFAULT '0',
`time_spent` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0,0',
`idm_block_submissions` tinyint(1) UNSIGNED DEFAULT '0' COMMENT 'Blocked from submitting Downloads files?',
`failed_security_answers` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
`completed` bit(1) NOT NULL DEFAULT b'0' COMMENT 'Whether the account is completed or not',
`steamid` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`donate_donations` smallint(5) DEFAULT '0',
`donate_amount` decimal(10,2) DEFAULT '0.00',
`ProfileVideo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`MSI_FacebookLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_TwitterLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_GoogleLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_YoutubeLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_WebsiteLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_GitHubLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_SteamLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_InstagramLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_LinkedinLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_SkypeName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_TwitchLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_OdnoklassnikiLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_vKontakteLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_DiscordLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_RedditLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_VineLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_VidmeLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_SnapchatLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_SmashcastLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_MixerLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_PlaystationLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_XboxLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`MSI_OriginLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`shop_points` int(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Przy dodawaniu użytkownika wycinki:
INSERT INTO `ipb_core_members` (`member_id`, `name`, `member_group_id`, `email`, `joined`,
(1, 'nOt ', 4, '
[email protected]', 1583164877,