ucenter · 英文版開發文檔

# ucenter ucenter - [server\_id\_seq](#server_id_seq) - [ucenter\_base\_app](#ucenter_base_app) - [ucenter\_base\_app\_server](#ucenter_base_app_server) - [ucenter\_base\_district](#ucenter_base_district) - [ucenter\_message\_template](#ucenter_message_template) - [ucenter\_reg\_option](#ucenter_reg_option) - [ucenter\_reg\_option\_value](#ucenter_reg_option_value) - [ucenter\_server\_id\_seq](#ucenter_server_id_seq) - [ucenter\_user\_app](#ucenter_user_app) - [ucenter\_user\_app\_server](#ucenter_user_app_server) - [ucenter\_user\_bind\_connect](#ucenter_user_bind_connect) - [ucenter\_user\_grade](#ucenter_user_grade) - [ucenter\_user\_id\_seq](#ucenter_user_id_seq) - [ucenter\_user\_info](#ucenter_user_info) - [ucenter\_user\_info\_detail](#ucenter_user_info_detail) - [ucenter\_user\_option](#ucenter_user_option) - [ucenter\_user\_privacy](#ucenter_user_privacy) - [ucenter\_web\_config](#ucenter_web_config) - [user\_id\_seq](#user_id_seq) - - - - - - server\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid int(10) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentserver\_id\_seq 0 PRIMARY 1 id A 0 (NULL) (NULL) BTREE [Back](#header) ucenter\_base\_app FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentapp\_id int(11) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 服務ID app\_name varchar(40) utf8\_general\_ci YES (NULL) select,insert,update,references 服務名稱 app\_type smallint(5) unsigned (NULL) NO 0 select,insert,update,references 服務類型 app\_seq int(11) (NULL) NO (NULL) select,insert,update,references 順序號 app\_key varchar(50) utf8\_general\_ci YES (NULL) select,insert,update,references 服務密鑰 app\_ip\_list text utf8\_general\_ci YES (NULL) select,insert,update,references 服務 IP 列表 app\_url varchar(255) utf8\_general\_ci YES (NULL) select,insert,update,references 服務網址 app\_admin\_url varchar(255) utf8\_general\_ci YES (NULL) select,insert,update,references 后臺網址 app\_url\_recharge varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references app\_url\_order varchar(255) utf8\_general\_ci NO select,insert,update,references 檢查訂單是否存在的url地址 app\_logo varchar(255) utf8\_general\_ci YES (NULL) select,insert,update,references LOGO 圖片地址 app\_hosts text utf8\_general\_ci YES (NULL) select,insert,update,references 域名列表 return\_fields text utf8\_general\_ci YES (NULL) select,insert,update,references 返回字段 app\_status tinyint(1) (NULL) NO 1 select,insert,update,references 1:啟用 0：禁用 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_base\_app 0 PRIMARY 1 app\_id A 7 (NULL) (NULL) BTREE [Back](#header) ucenter\_base\_app\_server FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentserver\_id mediumint(9) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 服務器id server\_prefix varchar(50) utf8\_general\_ci NO select,insert,update,references 服務器前綴：一區 server\_name varchar(50) utf8\_general\_ci NO (NULL) select,insert,update,references 服務器名稱 server\_url varchar(200) utf8\_general\_ci NO MUL (NULL) select,insert,update,references 服務器url server\_order int(11) (NULL) NO 0 select,insert,update,references 服務器列表排序 app\_id smallint(6) (NULL) NO MUL (NULL) select,insert,update,references 所屬游戲id company\_id int(11) (NULL) NO MUL (NULL) select,insert,update,references 運營商id server\_type tinyint(4) (NULL) NO 1 select,insert,update,references 服類型,1:new,2:hot,3:滿 4:維護 server\_state tinyint(4) (NULL) NO 0 select,insert,update,references 服務器狀態,0:備運 1:開服中 2、停服,3:服務器宕機 socket\_ip varchar(15) utf8\_general\_ci NO select,insert,update,references socket 的ip地址 socket\_port mediumint(9) (NULL) NO 0 select,insert,update,references socket的端口號 server\_stop\_start\_time datetime (NULL) NO (NULL) select,insert,update,references 停服開始時間 server\_stop\_end\_time datetime (NULL) NO (NULL) select,insert,update,references 停服結束時間 server\_stop\_tip varchar(100) utf8\_general\_ci NO select,insert,update,references 服務器宕機提示 app\_version\_package varchar(100) utf8\_general\_ci NO select,insert,update,references CPP中定義的版本, 決定是否顯示 company\_name varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 公司名稱 company\_phone varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 電話 contacter varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 聯系人 sign\_time datetime (NULL) NO (NULL) select,insert,update,references 簽約時間 user\_name varchar(50) utf8\_general\_ci NO select,insert,update,references 管理員賬號 account\_num mediumint(8) (NULL) NO (NULL) select,insert,update,references 賬號個數 db\_host varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 數據庫IP db\_user varchar(50) utf8\_general\_ci NO select,insert,update,references db\_name varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 數據庫名 db\_passwd varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 數據庫密碼 upload\_path varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 附件存放地址 business\_agent varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 業務代表 price varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 費用 effective\_date\_start date (NULL) NO (NULL) select,insert,update,references 有效期開始與結束 effective\_date\_end date (NULL) NO (NULL) select,insert,update,references 有效期開始與結束1 plantform\_url varchar(200) utf8\_general\_ci NO (NULL) select,insert,update,references mallbuilder平臺url ucenter\_url varchar(200) utf8\_general\_ci NO (NULL) select,insert,update,references paycenter\_url varchar(200) utf8\_general\_ci NO (NULL) select,insert,update,references cloud\_type int(11) (NULL) NO (NULL) select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_base\_app\_server 0 PRIMARY 1 server\_id A 0 (NULL) (NULL) BTREE ucenter\_base\_app\_server 1 game\_id 1 app\_id A 0 (NULL) (NULL) BTREE ucenter\_base\_app\_server 1 server\_url 1 server\_url A 0 (NULL) (NULL) BTREE ucenter\_base\_app\_server 1 company\_id 1 company\_id A 0 (NULL) (NULL) BTREE [Back](#header) ucenter\_base\_district FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentdistrict\_id mediumint(8) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 地區id district\_name varchar(255) utf8\_general\_ci NO select,insert,update,references 地區名稱 district\_parent\_id mediumint(8) unsigned (NULL) NO MUL 0 select,insert,update,references 父id district\_displayorder smallint(6) (NULL) NO 0 select,insert,update,references 排序 district\_region varchar(50) utf8\_general\_ci NO select,insert,update,references 區域名稱 - 華北、東北、華東、華南、華中、西南、西北、港澳臺、海外 district\_is\_leaf tinyint(1) (NULL) NO 1 select,insert,update,references 無子類 district\_is\_level tinyint(1) (NULL) NO 1 select,insert,update,references 等級 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_base\_district 0 PRIMARY 1 district\_id A 43767 (NULL) (NULL) BTREE ucenter\_base\_district 1 upid 1 district\_parent\_id A 7294 (NULL) (NULL) BTREE ucenter\_base\_district 1 upid 2 district\_displayorder A 7294 (NULL) (NULL) BTREE [Back](#header) ucenter\_message\_template FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid int(10) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references code varchar(100) utf8\_general\_ci NO (NULL) select,insert,update,references name varchar(100) utf8\_general\_ci NO (NULL) select,insert,update,references title varchar(100) utf8\_general\_ci NO (NULL) select,insert,update,references 主題 content\_email text utf8\_general\_ci NO (NULL) select,insert,update,references 郵件內容 type tinyint(1) (NULL) NO (NULL) select,insert,update,references 0商家1用戶 is\_phone tinyint(1) (NULL) NO 0 select,insert,update,references 0關閉1開啟 is\_email tinyint(1) (NULL) NO 0 select,insert,update,references 0關閉1開啟 is\_mail tinyint(1) (NULL) NO 0 select,insert,update,references 0關閉1開啟 content\_mail text utf8\_general\_ci NO (NULL) select,insert,update,references 站內信內容 content\_phone text utf8\_general\_ci NO (NULL) select,insert,update,references 短信內容 force\_phone tinyint(1) (NULL) NO 0 select,insert,update,references 手機短信0不強制1強制 force\_email tinyint(1) (NULL) NO 0 select,insert,update,references 郵件0不強制1強制 force\_mail tinyint(1) (NULL) NO 0 select,insert,update,references 站內信0不強制1強制 mold tinyint(1) (NULL) NO 0 select,insert,update,references 0常用提示1訂單提示2卡券提示3售后提示 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_message\_template 0 PRIMARY 1 id A 9 (NULL) (NULL) BTREE [Back](#header) ucenter\_reg\_option FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentreg\_option\_id int(11) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 選項值 reg\_option\_name varchar(20) utf8\_general\_ci NO select,insert,update,references reg\_option\_order int(3) (NULL) NO (NULL) select,insert,update,references option\_id int(11) (NULL) NO (NULL) select,insert,update,references 選項id reg\_option\_required tinyint(1) unsigned (NULL) NO 0 select,insert,update,references 是否必須(BOOL):0-非必填;1-必填 reg\_option\_placeholder varchar(100) utf8\_general\_ci NO select,insert,update,references placeholder reg\_option\_datatype varchar(20) utf8\_general\_ci NO select,insert,update,references data\_type reg\_option\_value varchar(255) utf8\_general\_ci NO select,insert,update,references 配置選項 reg\_option\_active tinyint(1) (NULL) NO 0 select,insert,update,references 是否啟用 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_reg\_option 0 PRIMARY 1 reg\_option\_id A 13 (NULL) (NULL) BTREE [Back](#header) ucenter\_reg\_option\_value FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentreg\_option\_value\_id int(11) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 選項值 reg\_option\_id int(11) (NULL) NO (NULL) select,insert,update,references 選項id reg\_option\_value\_image varchar(255) utf8\_general\_ci NO select,insert,update,references 選項值圖片 reg\_option\_value\_order tinyint(3) unsigned (NULL) NO 50 select,insert,update,references reg\_option\_value\_name varchar(255) utf8\_general\_ci NO select,insert,update,references 選項值名稱 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_reg\_option\_value 0 PRIMARY 1 reg\_option\_value\_id A 0 (NULL) (NULL) BTREE [Back](#header) ucenter\_server\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid int(10) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_server\_id\_seq 0 PRIMARY 1 id A 0 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_app FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_name varchar(100) utf8\_general\_ci NO PRI (NULL) select,insert,update,references 用戶名 app\_id int(11) unsigned (NULL) NO PRI 0 select,insert,update,references 服務ID app\_user\_id int(11) unsigned (NULL) NO 0 select,insert,update,references 用戶在該服務的ID app\_user\_level int(11) unsigned (NULL) NO 0 select,insert,update,references 用戶在該服務的等級 active\_time int(11) unsigned (NULL) NO 0 select,insert,update,references 激活時間 app\_quantity int(11) (NULL) NO 1 select,insert,update,references app數量 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_app 0 PRIMARY 1 user\_name A 56 (NULL) (NULL) BTREE ucenter\_user\_app 0 PRIMARY 2 app\_id A 56 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_app\_server FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_name varchar(100) utf8\_general\_ci NO PRI (NULL) select,insert,update,references 這個user\_name是指玩家在運營商那邊的唯一標記，不是官方平臺的賬號 app\_id int(11) (NULL) NO PRI (NULL) select,insert,update,references 應用在官方平臺的app\_id server\_id int(11) (NULL) NO PRI (NULL) select,insert,update,references 服務器id active\_time int(11) (NULL) NO (NULL) select,insert,update,references 激活時間 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_app\_server 0 PRIMARY 1 user\_name A 56 (NULL) (NULL) BTREE ucenter\_user\_app\_server 0 PRIMARY 2 app\_id A 56 (NULL) (NULL) BTREE ucenter\_user\_app\_server 0 PRIMARY 3 server\_id A 56 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_bind\_connect FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentbind\_id varchar(100) utf8\_general\_ci NO PRI (NULL) select,insert,update,references 綁定標記：mobie/email/openid 綁定類型+openid bind\_type tinyint(4) (NULL) NO PRI (NULL) select,insert,update,references 綁定類型 1:sinaweibo 2:qq 3:weixin 11:email 12:mobile user\_id int(10) unsigned (NULL) NO 0 select,insert,update,references 用戶id bind\_time timestamp (NULL) NO CURRENT\_TIMESTAMP select,insert,update,references 綁定時間 bind\_nickname varchar(50) utf8\_general\_ci NO select,insert,update,references 名稱 bind\_avator varchar(255) utf8\_general\_ci NO select,insert,update,references 地址 bind\_gender tinyint(1) (NULL) NO 1 select,insert,update,references 性別 1:男 2:女 bind\_openid varchar(200) utf8\_general\_ci NO select,insert,update,references 訪問 bind\_token varchar(200) latin1\_swedish\_ci NO select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_bind\_connect 0 PRIMARY 1 bind\_id A 612 (NULL) (NULL) BTREE ucenter\_user\_bind\_connect 0 PRIMARY 2 bind\_type A 612 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_grade FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_grade\_id int(11) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references user\_grade\_name varchar(50) utf8\_general\_ci NO (NULL) select,insert,update,references user\_grade\_demand int(10) (NULL) NO 0 select,insert,update,references 條件 user\_grade\_treatment text utf8\_general\_ci NO (NULL) select,insert,update,references 權益 user\_grade\_blogo varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 大圖 user\_grade\_logo varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references LOGO user\_grade\_valid int(1) (NULL) NO 0 select,insert,update,references 有效期 user\_grade\_sum int(11) (NULL) NO 0 select,insert,update,references 年費 user\_grade\_rate float(3,1) (NULL) NO 0.0 select,insert,update,references 折扣率 user\_grade\_time datetime (NULL) NO (NULL) select,insert,update,references 創建時間 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_grade 0 PRIMARY 1 user\_grade\_id A 5 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid int(10) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_id\_seq 0 PRIMARY 1 id A 0 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_info FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id int(11) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 用戶ID user\_name varchar(100) utf8\_general\_ci NO UNI (NULL) select,insert,update,references 用戶名 password char(32) utf8\_general\_ci YES (NULL) select,insert,update,references 密碼 user\_state tinyint(1) unsigned (NULL) NO 0 select,insert,update,references 狀態(0:未激活,1:未認證,2:已認證,3:鎖定) action\_time int(11) unsigned (NULL) NO 0 select,insert,update,references 活動時間 action\_ip varchar(15) utf8\_general\_ci YES (NULL) select,insert,update,references 活動IP session\_id varchar(100) utf8\_general\_ci YES (NULL) select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_info 0 PRIMARY 1 user\_id A 649 (NULL) (NULL) BTREE ucenter\_user\_info 0 user\_name 1 user\_name A 649 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_info\_detail FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_name varchar(100) utf8\_general\_ci NO PRI (NULL) select,insert,update,references 用戶名 nickname varchar(100) utf8\_general\_ci YES (NULL) select,insert,update,references 昵稱 user\_group int(11) (NULL) NO 0 select,insert,update,references 用戶組 user\_site\_id int(11) unsigned (NULL) NO 0 select,insert,update,references 用戶站點ID user\_site\_domain varchar(50) utf8\_general\_ci YES (NULL) select,insert,update,references 用戶站點域名 user\_question varchar(100) utf8\_general\_ci YES (NULL) select,insert,update,references 密碼提示問題 user\_answer varchar(100) utf8\_general\_ci YES (NULL) select,insert,update,references 密碼提示答案 user\_avatar varchar(255) utf8\_general\_ci YES (NULL) select,insert,update,references 頭像 user\_avatar\_thumb varchar(255) utf8\_general\_ci YES (NULL) select,insert,update,references 頭像縮略圖 user\_gender tinyint(1) unsigned (NULL) NO 0 select,insert,update,references 性別 user\_truename varchar(20) utf8\_general\_ci YES (NULL) select,insert,update,references 真實姓名 user\_tel varchar(30) utf8\_general\_ci YES (NULL) select,insert,update,references 電話 user\_birth varchar(10) utf8\_general\_ci YES (NULL) select,insert,update,references 生日(YYYY-MM-DD) user\_qq varchar(20) utf8\_general\_ci YES (NULL) select,insert,update,references QQ user\_msn varchar(255) utf8\_general\_ci YES (NULL) select,insert,update,references MSN user\_province varchar(20) utf8\_general\_ci YES (NULL) select,insert,update,references 省份 user\_city varchar(20) utf8\_general\_ci YES (NULL) select,insert,update,references 城市 user\_intro text utf8\_general\_ci YES (NULL) select,insert,update,references 個人簡介 user\_sign varchar(500) utf8\_general\_ci YES (NULL) select,insert,update,references 用戶簽名 user\_reg\_time int(11) unsigned (NULL) NO 0 select,insert,update,references 注冊時間 user\_count\_login int(11) unsigned (NULL) NO 0 select,insert,update,references 登錄次數 user\_lastlogin\_time int(11) unsigned (NULL) NO 0 select,insert,update,references 上次登錄時間 user\_lastlogin\_ip varchar(15) utf8\_general\_ci YES (NULL) select,insert,update,references 上次登錄IP user\_like\_games text utf8\_general\_ci YES (NULL) select,insert,update,references 喜愛的游戲 user\_reg\_ip varchar(15) utf8\_general\_ci YES (NULL) select,insert,update,references 注冊IP user\_money int(11) unsigned (NULL) NO 0 select,insert,update,references 用戶資金 user\_credit int(11) (NULL) NO 0 select,insert,update,references 用戶積分 user\_getpsw\_code varchar(32) utf8\_general\_ci YES (NULL) select,insert,update,references 取回密碼認證碼 user\_verify\_code varchar(32) utf8\_general\_ci YES (NULL) select,insert,update,references 認證賬號認證碼 user\_phone\_code varchar(32) utf8\_general\_ci YES (NULL) select,insert,update,references 手機驗證碼 user\_phone\_code\_stats varchar(20) utf8\_general\_ci YES (NULL) select,insert,update,references 獲取手機驗證碼記錄(獲取次數,上次獲取時間) user\_idcard varchar(30) utf8\_general\_ci YES (NULL) select,insert,update,references 身份證 user\_mobile varchar(20) utf8\_general\_ci YES (NULL) select,insert,update,references 手機號碼 user\_email varchar(255) utf8\_general\_ci NO select,insert,update,references user\_binded varchar(50) utf8\_general\_ci YES (NULL) select,insert,update,references 已綁定項目 user\_history\_password text utf8\_general\_ci YES (NULL) select,insert,update,references 歷史密碼 user\_history\_ip text utf8\_general\_ci YES (NULL) select,insert,update,references 歷史 IP user\_grade tinyint(1) (NULL) NO 0 select,insert,update,references user\_mobile\_verify tinyint(1) (NULL) NO 0 select,insert,update,references user\_email\_verify tinyint(1) (NULL) NO 0 select,insert,update,references user\_provinceid int(11) (NULL) NO 0 select,insert,update,references user\_cityid int(11) (NULL) NO 0 select,insert,update,references user\_areaid int(11) (NULL) NO 0 select,insert,update,references user\_area varchar(255) utf8\_general\_ci NO select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_info\_detail 0 PRIMARY 1 user\_name A 651 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_option FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_option\_id int(11) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 選項值 reg\_option\_id int(3) (NULL) NO (NULL) select,insert,update,references reg\_option\_value\_id varchar(20) utf8\_general\_ci NO select,insert,update,references user\_id int(11) (NULL) NO (NULL) select,insert,update,references 選項id user\_option\_value text utf8\_general\_ci NO (NULL) select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_option 0 PRIMARY 1 user\_option\_id A 50 (NULL) (NULL) BTREE [Back](#header) ucenter\_user\_privacy FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id int(10) unsigned (NULL) NO PRI (NULL) select,insert,update,references 用戶id user\_privacy\_email tinyint(1) (NULL) NO 0 select,insert,update,references 郵箱設置0公開1好友可見2保密 user\_privacy\_realname tinyint(1) (NULL) NO 0 select,insert,update,references 真實姓名設置0公開1好友可見2保密 user\_privacy\_sex tinyint(1) (NULL) NO 0 select,insert,update,references 性別設置0公開1好友可見2保密 user\_privacy\_birthday tinyint(1) (NULL) NO 0 select,insert,update,references 生日設置0公開1好友可見2保密 user\_privacy\_area tinyint(1) (NULL) NO 0 select,insert,update,references 所在地區設置0公開1好友可見2保密 user\_privacy\_qq tinyint(1) (NULL) NO 0 select,insert,update,references QQ設置0公開1好友可見2保密 user\_privacy\_ww tinyint(1) (NULL) NO 0 select,insert,update,references 阿里旺旺設置0公開1好友可見2保密 user\_privacy\_mobile tinyint(1) (NULL) NO 0 select,insert,update,references 手機設置0公開1好友可見2保密 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_user\_privacy 0 PRIMARY 1 user\_id A 38 (NULL) (NULL) BTREE [Back](#header) ucenter\_web\_config FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentconfig\_key varchar(50) utf8\_general\_ci NO PRI (NULL) select,insert,update,references 數組下標 config\_value text utf8\_general\_ci NO (NULL) select,insert,update,references 數組值 config\_type varchar(50) utf8\_general\_ci NO (NULL) select,insert,update,references config\_enable tinyint(1) (NULL) NO 1 select,insert,update,references 狀態值，1可能，0不可用 config\_comment text utf8\_general\_ci NO (NULL) select,insert,update,references config\_datatype enum('string','json','number') utf8\_general\_ci NO string select,insert,update,references 數據類型 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentucenter\_web\_config 0 PRIMARY 1 config\_key A 226 (NULL) (NULL) BTREE ucenter\_web\_config 1 index 1 config\_key A 226 (NULL) (NULL) BTREE ucenter\_web\_config 1 index 2 config\_type A 226 (NULL) (NULL) BTREE [Back](#header) user\_id\_seq FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentid int(10) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentuser\_id\_seq 0 PRIMARY 1 id A 1 (NULL) (NULL) BTREE