API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 30th, 2016
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.35 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE `ipbcore_members` (
  2.     `member_id` MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
  3.     `name` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  4.     `member_group_id` SMALLINT(3) NOT NULL DEFAULT '0',
  5.     `email` VARCHAR(150) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  6.     `joined` INT(10) NOT NULL DEFAULT '0',
  7.     `ip_address` VARCHAR(46) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  8.     `skin` SMALLINT(5) NULL DEFAULT NULL,
  9.     `warn_level` INT(10) NULL DEFAULT NULL,
  10.     `warn_lastwarn` INT(10) NOT NULL DEFAULT '0',
  11.     `language` MEDIUMINT(4) NULL DEFAULT NULL,
  12.     `restrict_post` INT(10) NOT NULL DEFAULT '0',
  13.     `bday_day` INT(2) NULL DEFAULT NULL,
  14.     `bday_month` INT(2) NULL DEFAULT NULL,
  15.     `bday_year` INT(4) NULL DEFAULT NULL,
  16.     `msg_count_new` INT(2) NOT NULL DEFAULT '0',
  17.     `msg_count_total` INT(3) NOT NULL DEFAULT '0',
  18.     `msg_count_reset` INT(1) NOT NULL DEFAULT '0',
  19.     `msg_show_notification` INT(1) NOT NULL DEFAULT '0',
  20.     `last_visit` INT(10) NULL DEFAULT '0',
  21.     `last_activity` INT(10) NULL DEFAULT '0',
  22.     `mod_posts` INT(10) NOT NULL DEFAULT '0',
  23.     `auto_track` VARCHAR(256) NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci',
  24.     `temp_ban` INT(10) NULL DEFAULT '0',
  25.     `mgroup_others` VARCHAR(245) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  26.     `member_login_key` VARCHAR(32) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  27.     `member_login_key_expire` INT(10) NOT NULL DEFAULT '0',
  28.     `members_seo_name` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  29.     `members_cache` MEDIUMTEXT NULL COLLATE 'utf8mb4_unicode_ci',
  30.     `failed_logins` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  31.     `failed_login_count` SMALLINT(3) NOT NULL DEFAULT '0',
  32.     `members_profile_views` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  33.     `members_pass_hash` VARCHAR(60) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  34.     `members_pass_salt` VARCHAR(22) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  35.     `members_bitoptions` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  36.     `fb_uid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  37.     `members_day_posts` VARCHAR(32) NOT NULL DEFAULT '0,0' COLLATE 'utf8mb4_unicode_ci',
  38.     `live_id` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  39.     `twitter_id` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  40.     `twitter_token` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  41.     `twitter_secret` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  42.     `notification_cnt` MEDIUMINT(9) NOT NULL DEFAULT '0',
  43.     `fb_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  44.     `ipsconnect_id` INT(10) NOT NULL DEFAULT '0',
  45.     `google_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  46.     `linkedin_id` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  47.     `pp_last_visitors` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  48.     `pp_main_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  49.     `pp_main_width` INT(5) NULL DEFAULT NULL,
  50.     `pp_main_height` INT(5) NULL DEFAULT NULL,
  51.     `pp_thumb_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  52.     `pp_thumb_width` INT(5) NULL DEFAULT NULL,
  53.     `pp_thumb_height` INT(5) NULL DEFAULT NULL,
  54.     `pp_setting_count_comments` INT(2) NULL DEFAULT NULL,
  55.     `pp_reputation_points` INT(10) NULL DEFAULT NULL,
  56.     `pp_gravatar` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  57.     `pp_photo_type` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  58.     `signature` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  59.     `pconversation_filters` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  60.     `fb_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  61.     `fb_photo_thumb` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  62.     `fb_bwoptions` INT(10) NULL DEFAULT NULL,
  63.     `tc_last_sid_import` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  64.     `tc_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  65.     `tc_bwoptions` INT(10) NULL DEFAULT NULL,
  66.     `pp_customization` MEDIUMTEXT NULL COLLATE 'utf8mb4_unicode_ci',
  67.     `timezone` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  68.     `pp_cover_photo` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
  69.     `profilesync` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  70.     `profilesync_lastsync` INT(10) NOT NULL DEFAULT '0' COMMENT 'Indicates the last time any profile sync service was ran',
  71.     `google_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  72.     `linkedin_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  73.     `live_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  74.     `allow_admin_mails` BIT(1) NULL DEFAULT b'0',
  75.     `members_bitoptions2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  76.     `create_menu` TEXT NULL COMMENT 'Cached contents of the "Create" drop down menu.' COLLATE 'utf8mb4_unicode_ci',
  77.     `ipsconnect_revalidate_url` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  78.     `members_disable_pm` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 - not disabled, 1 - disabled, member can re-enable, 2 - disabled',
  79.     `marked_site_read` INT(10) UNSIGNED NULL DEFAULT '0',
  80.     `pp_cover_offset` INT(10) NOT NULL DEFAULT '0',
  81.     `acp_skin` SMALLINT(6) NULL DEFAULT NULL,
  82.     `acp_language` MEDIUMINT(9) NULL DEFAULT NULL,
  83.     `member_title` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  84.     `member_posts` MEDIUMINT(7) NOT NULL DEFAULT '0',
  85.     `member_last_post` INT(10) NULL DEFAULT NULL,
  86.     `member_streams` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  87.     `photo_last_update` INT(10) NULL DEFAULT NULL,
  88.     `cm_credits` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
  89.     `cm_no_sev` TINYINT(1) NULL DEFAULT '0',
  90.     `cm_return_group` SMALLINT(3) NULL DEFAULT '0',
  91.     `idm_block_submissions` TINYINT(1) UNSIGNED NULL DEFAULT '0' COMMENT 'Blocked from submitting Downloads files?',
  92.     `steamid` VARCHAR(17) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  93.     PRIMARY KEY (`member_id`),
  94.     INDEX `bday_day` (`bday_day`),
  95.     INDEX `bday_month` (`bday_month`),
  96.     INDEX `members_bitoptions` (`members_bitoptions`),
  97.     INDEX `ip_address` (`ip_address`),
  98.     INDEX `failed_login_count` (`failed_login_count`),
  99.     INDEX `joined` (`joined`),
  100.     INDEX `fb_uid` (`fb_uid`),
  101.     INDEX `twitter_id` (`twitter_id`(191)),
  102.     INDEX `email` (`email`),
  103.     INDEX `member_groups` (`member_group_id`, `mgroup_others`(188)),
  104.     INDEX `google_id` (`google_id`),
  105.     INDEX `linkedin_id` (`linkedin_id`),
  106.     INDEX `mgroup` (`member_id`, `member_group_id`),
  107.     INDEX `allow_admin_mails` (`allow_admin_mails`),
  108.     INDEX `name_index` (`name`(191)),
  109.     INDEX `ipsconnect_id` (`ipsconnect_id`),
  110.     INDEX `mod_posts` (`mod_posts`),
  111.     INDEX `photo_last_update` (`photo_last_update`),
  112.     INDEX `steamid` (`steamid`)
  113. )
  114. COLLATE='utf8mb4_unicode_ci'
  115. ENGINE=InnoDB
  116. AUTO_INCREMENT=218
  117. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!