去评论
dz插件网

Discuz!X3.5新增 用户历史资料下载功能需要升级的数据库语句

admin
2021/12/28 09:48:38
Discuz!X3.5新增 用户历史资料下载功能需要升级的数据库语句：
  1. DROP TABLE IF EXISTS pre_common_member_profile_history;
  2. CREATE TABLE pre_common_member_profile_history (
  3.   hid int(10) unsigned NOT NULL AUTO_INCREMENT,
  4.   uid mediumint(8) unsigned NOT NULL,
  5.   realname varchar(255) NOT NULL DEFAULT '',
  6.   gender tinyint(1) NOT NULL DEFAULT '0',
  7.   birthyear smallint(6) unsigned NOT NULL DEFAULT '0',
  8.   birthmonth tinyint(3) unsigned NOT NULL DEFAULT '0',
  9.   birthday tinyint(3) unsigned NOT NULL DEFAULT '0',
  10.   constellation varchar(255) NOT NULL DEFAULT '',
  11.   zodiac varchar(255) NOT NULL DEFAULT '',
  12.   telephone varchar(255) NOT NULL DEFAULT '',
  13.   mobile varchar(255) NOT NULL DEFAULT '',
  14.   idcardtype varchar(255) NOT NULL DEFAULT '',
  15.   idcard varchar(255) NOT NULL DEFAULT '',
  16.   address varchar(255) NOT NULL DEFAULT '',
  17.   zipcode varchar(255) NOT NULL DEFAULT '',
  18.   nationality varchar(255) NOT NULL DEFAULT '',
  19.   birthprovince varchar(255) NOT NULL DEFAULT '',
  20.   birthcity varchar(255) NOT NULL DEFAULT '',
  21.   birthdist varchar(20) NOT NULL DEFAULT '',
  22.   birthcommunity varchar(255) NOT NULL DEFAULT '',
  23.   resideprovince varchar(255) NOT NULL DEFAULT '',
  24.   residecity varchar(255) NOT NULL DEFAULT '',
  25.   residedist varchar(20) NOT NULL DEFAULT '',
  26.   residecommunity varchar(255) NOT NULL DEFAULT '',
  27.   residesuite varchar(255) NOT NULL DEFAULT '',
  28.   graduateschool varchar(255) NOT NULL DEFAULT '',
  29.   company varchar(255) NOT NULL DEFAULT '',
  30.   education varchar(255) NOT NULL DEFAULT '',
  31.   occupation varchar(255) NOT NULL DEFAULT '',
  32.   position varchar(255) NOT NULL DEFAULT '',
  33.   revenue varchar(255) NOT NULL DEFAULT '',
  34.   affectivestatus varchar(255) NOT NULL DEFAULT '',
  35.   lookingfor varchar(255) NOT NULL DEFAULT '',
  36.   bloodtype varchar(255) NOT NULL DEFAULT '',
  37.   height varchar(255) NOT NULL DEFAULT '',
  38.   weight varchar(255) NOT NULL DEFAULT '',
  39.   alipay varchar(255) NOT NULL DEFAULT '',
  40.   icq varchar(255) NOT NULL DEFAULT '',
  41.   qq varchar(255) NOT NULL DEFAULT '',
  42.   yahoo varchar(255) NOT NULL DEFAULT '',
  43.   msn varchar(255) NOT NULL DEFAULT '',
  44.   taobao varchar(255) NOT NULL DEFAULT '',
  45.   site varchar(255) NOT NULL DEFAULT '',
  46.   bio text NOT NULL,
  47.   interest text NOT NULL,
  48.   field1 text NOT NULL,
  49.   field2 text NOT NULL,
  50.   field3 text NOT NULL,
  51.   field4 text NOT NULL,
  52.   field5 text NOT NULL,
  53.   field6 text NOT NULL,
  54.   field7 text NOT NULL,
  55.   field8 text NOT NULL,
  56.   dateline int(10) unsigned NOT NULL DEFAULT '0',
  57.   PRIMARY KEY (hid)
  58. ) ENGINE=InnoDB;


进入原文参与互动