|
ตารางที่มีปัญหาน่าจะ 2 ตารางนี้ครับ ลองใช้รีเซ็ตด้วยคำสั่งข้างล่างในหน้า SQL ของ phpMyAdmin ดูครับ อาจช่วยได้
(อย่าลืม backup ฐานข้อมูลก่อน เผื่อมีปัญหานะครับ)
- DROP TABLE IF EXISTS pre_common_member_profile;
- CREATE TABLE pre_common_member_profile (
- uid mediumint(8) unsigned NOT NULL,
- realname varchar(255) NOT NULL DEFAULT '',
- gender tinyint(1) NOT NULL DEFAULT '0',
- birthyear smallint(6) unsigned NOT NULL DEFAULT '0',
- birthmonth tinyint(3) unsigned NOT NULL DEFAULT '0',
- birthday tinyint(3) unsigned NOT NULL DEFAULT '0',
- constellation varchar(255) NOT NULL DEFAULT '',
- zodiac varchar(255) NOT NULL DEFAULT '',
- telephone varchar(255) NOT NULL DEFAULT '',
- mobile varchar(255) NOT NULL DEFAULT '',
- idcardtype varchar(255) NOT NULL DEFAULT '',
- idcard varchar(255) NOT NULL DEFAULT '',
- address varchar(255) NOT NULL DEFAULT '',
- zipcode varchar(255) NOT NULL DEFAULT '',
- nationality varchar(255) NOT NULL DEFAULT '',
- birthprovince varchar(255) NOT NULL DEFAULT '',
- birthcity varchar(255) NOT NULL DEFAULT '',
- birthdist varchar(20) NOT NULL DEFAULT '',
- birthcommunity varchar(255) NOT NULL DEFAULT '',
- resideprovince varchar(255) NOT NULL DEFAULT '',
- residecity varchar(255) NOT NULL DEFAULT '',
- residedist varchar(20) NOT NULL DEFAULT '',
- residecommunity varchar(255) NOT NULL DEFAULT '',
- residesuite varchar(255) NOT NULL DEFAULT '',
- graduateschool varchar(255) NOT NULL DEFAULT '',
- company varchar(255) NOT NULL DEFAULT '',
- education varchar(255) NOT NULL DEFAULT '',
- occupation varchar(255) NOT NULL DEFAULT '',
- position varchar(255) NOT NULL DEFAULT '',
- revenue varchar(255) NOT NULL DEFAULT '',
- affectivestatus varchar(255) NOT NULL DEFAULT '',
- lookingfor varchar(255) NOT NULL DEFAULT '',
- bloodtype varchar(255) NOT NULL DEFAULT '',
- height varchar(255) NOT NULL DEFAULT '',
- weight varchar(255) NOT NULL DEFAULT '',
- alipay varchar(255) NOT NULL DEFAULT '',
- icq varchar(255) NOT NULL DEFAULT '',
- qq varchar(255) NOT NULL DEFAULT '',
- yahoo varchar(255) NOT NULL DEFAULT '',
- msn varchar(255) NOT NULL DEFAULT '',
- taobao varchar(255) NOT NULL DEFAULT '',
- site varchar(255) NOT NULL DEFAULT '',
- bio text NOT NULL,
- interest text NOT NULL,
- field1 text NOT NULL,
- field2 text NOT NULL,
- field3 text NOT NULL,
- field4 text NOT NULL,
- field5 text NOT NULL,
- field6 text NOT NULL,
- field7 text NOT NULL,
- field8 text NOT NULL,
- PRIMARY KEY (uid)
- ) TYPE=MyISAM;
- DROP TABLE IF EXISTS pre_common_member_profile_setting;
- CREATE TABLE pre_common_member_profile_setting (
- fieldid varchar(255) NOT NULL DEFAULT '',
- available tinyint(1) NOT NULL DEFAULT '0',
- invisible tinyint(1) NOT NULL DEFAULT '0',
- needverify tinyint(1) NOT NULL DEFAULT '0',
- title varchar(255) NOT NULL DEFAULT '',
- description varchar(255) NOT NULL DEFAULT '',
- displayorder smallint(6) unsigned NOT NULL DEFAULT '0',
- required tinyint(1) NOT NULL DEFAULT '0',
- unchangeable tinyint(1) NOT NULL DEFAULT '0',
- showincard tinyint(1) NOT NULL DEFAULT '0',
- showinthread tinyint(1) NOT NULL DEFAULT '0',
- showinregister tinyint(1) NOT NULL DEFAULT '0',
- allowsearch tinyint(1) NOT NULL DEFAULT '0',
- formtype varchar(255) NOT NULL,
- size smallint(6) unsigned NOT NULL DEFAULT '0',
- choices text NOT NULL,
- validate text NOT NULL,
- PRIMARY KEY (fieldid)
- ) TYPE=MyISAM;
คัดลอกไปที่คลิปบอร์ด
|
|