- DROP TABLE IF EXISTS cdb_common_member_profile_setting;
- CREATE TABLE cdb_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',
- showinthread 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;
- INSERT INTO cdb_common_member_profile_setting VALUES ('gender','1','0','0','性别','','0','0','0','0','1','select','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('birthyear','1','0','0','出生年份','','0','0','0','0','1','select','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('birthmonth','1','0','0','出生月份','','0','0','0','0','0','select','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('birthday','1','0','0','出生日期','','0','0','0','0','0','select','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('constellation','1','1','0','星座','星座(根据生日自动计算)','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('zodiac','1','1','0','生肖','生肖(根据生日自动计算)','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('telephone','1','1','0','固定电话','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('mobile','1','1','0','手机','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('idcardtype','1','1','0','证件号类型','身份证 护照 驾驶证等','0','0','0','0','0','select','0','身份证\n护照\n驾驶证','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('idcard','1','1','0','证件号','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('address','1','1','0','邮寄地址','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('zipcode','1','1','0','邮编','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('nationality','0','0','0','国籍','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('birthprovince','1','0','0','出生省份','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('birthcity','1','0','0','出生城市','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('resideprovince','1','0','0','居住省份','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('residecity','1','0','0','居住城市','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('residedist','1','0','0','居住县','居住行政区/县','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('residecommunity','1','0','0','居住小区','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('residesuite','0','0','0','房间','小区、写字楼门牌号','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('graduateschool','1','0','0','毕业学校','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('education','1','0','0','学历','','0','0','0','0','0','select','0','博士\n硕士\n本科\n专科\n中学\n小学\n其它','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('company','1','0','0','公司','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('occupation','1','0','0','职业','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('position','1','0','0','职位','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('revenue','1','0','0','年收入','单位 元','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('affectivestatus','1','1','0','情感状态','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('lookingfor','1','0','0','交友目的','希望在网站找到什么样的朋友','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('bloodtype','1','1','0','血型','','0','0','0','0','0','select','0','A\nB\nAB\nO\n其它','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('height','0','1','0','身高','单位 cm','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('weight','0','1','0','体重','单位 kg','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('alipay','1','1','0','支付宝帐号','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('icq','0','1','0','ICQ号','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('qq','1','1','0','QQ号','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('yahoo','0','1','0','YAHOO帐号','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('msn','1','1','0','MSN帐号','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('taobao','1','1','0','阿里旺旺帐号','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('site','1','0','0','个人主页','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('bio','1','1','0','自我介绍','','0','0','0','0','0','textarea','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('interest','1','0','0','兴趣爱好','','0','0','0','0','0','textarea','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field1','0','1','0','自定义字段1','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field2','0','1','0','自定义字段2','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field3','0','1','0','自定义字段3','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field4','0','1','0','自定义字段4','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field5','0','1','0','自定义字段5','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field6','0','1','0','自定义字段6','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field7','0','1','0','自定义字段7','','0','0','0','0','0','text','0','','');
- INSERT INTO cdb_common_member_profile_setting VALUES ('field8','0','1','0','自定义字段8','','0','0','0','0','0','text','0','','');
复制代码 |