遇到【用户栏目】问题的朋友来看看 解决方案

顶上去

1. DROP TABLE IF EXISTS cdb_common_member_profile_setting;
   
2. CREATE TABLE cdb_common_member_profile_setting (
   
3.   fieldid varchar(255) NOT NULL default '' COMMENT 'profile字段标志符',
   
4.   available tinyint(1) NOT NULL default '0' COMMENT '是否可用',
   
5.   invisible tinyint(1) NOT NULL default '0' COMMENT '是否隐藏',
   
6.   needverify tinyint(1) NOT NULL default '0' COMMENT '是否需要审核',
   
7.   title varchar(255) NOT NULL default '' COMMENT '栏目标题',
   
8.   description varchar(255) NOT NULL default '' COMMENT '解释说明',
   
9.   displayorder smallint(6) unsigned NOT NULL default '0' COMMENT '显示顺序',
   
10.   required tinyint(1) NOT NULL default '0' COMMENT '是否必填内容',
    
11.   unchangeable tinyint(1) NOT NULL default '0' COMMENT '不可修改',
    
12.   showinthread tinyint(1) NOT NULL default '0' COMMENT '在帖子中显示',
    
13.   allowsearch tinyint(1) NOT NULL default '0' COMMENT '是否可搜索',
    
14.   formtype varchar(255) NOT NULL COMMENT '表单元素类型',
    
15.   size smallint(6) unsigned NOT NULL default '0' COMMENT '内容最大长度',
    
16.   choices text NOT NULL COMMENT '选填内容',
    
17.   validate text NOT NULL COMMENT '验证数据的正则表达式',
    
18.   PRIMARY KEY  (fieldid)
    
19. ) ENGINE=MyISAM  COMMENT='个人信息扩展表' ;
    
20. 
    
21. INSERT INTO cdb_common_member_profile_setting VALUES ('gender','1','0','0','性别','','0','0','0','0','1','select','0','','');
    
22. INSERT INTO cdb_common_member_profile_setting VALUES ('birthyear','1','0','0','出生年份','','0','0','0','0','1','select','0','','');
    
23. INSERT INTO cdb_common_member_profile_setting VALUES ('birthmonth','1','0','0','出生月份','','0','0','0','0','0','select','0','','');
    
24. INSERT INTO cdb_common_member_profile_setting VALUES ('birthday','1','0','0','出生日期','','0','0','0','0','0','select','0','','');
    
25. INSERT INTO cdb_common_member_profile_setting VALUES ('constellation','1','1','0','星座','星座(根据生日自动计算)','0','0','0','0','0','text','0','','');
    
26. INSERT INTO cdb_common_member_profile_setting VALUES ('zodiac','1','1','0','生肖','生肖(根据生日自动计算)','0','0','0','0','0','text','0','','');
    
27. INSERT INTO cdb_common_member_profile_setting VALUES ('telephone','1','1','0','固定电话','','0','0','0','0','0','text','0','','');
    
28. INSERT INTO cdb_common_member_profile_setting VALUES ('mobile','1','1','0','手机','','0','0','0','0','0','text','0','','');
    
29. INSERT INTO cdb_common_member_profile_setting VALUES ('idcardtype','1','1','0','证件号类型','身份证 护照 驾驶证等','0','0','0','0','0','select','0','身份证\n护照\n驾驶证','');
    
30. INSERT INTO cdb_common_member_profile_setting VALUES ('idcard','1','1','0','证件号','','0','0','0','0','0','text','0','','');
    
31. INSERT INTO cdb_common_member_profile_setting VALUES ('address','1','1','0','邮寄地址','','0','0','0','0','0','text','0','','');
    
32. INSERT INTO cdb_common_member_profile_setting VALUES ('zipcode','1','1','0','邮编','','0','0','0','0','0','text','0','','');
    
33. INSERT INTO cdb_common_member_profile_setting VALUES ('nationality','0','0','0','国籍','','0','0','0','0','0','text','0','','');
    
34. INSERT INTO cdb_common_member_profile_setting VALUES ('birthprovince','1','0','0','出生省份','','0','0','0','0','0','text','0','','');
    
35. INSERT INTO cdb_common_member_profile_setting VALUES ('birthcity','1','0','0','出生城市','','0','0','0','0','0','text','0','','');
    
36. INSERT INTO cdb_common_member_profile_setting VALUES ('resideprovince','1','0','0','居住省份','','0','0','0','0','0','text','0','','');
    
37. INSERT INTO cdb_common_member_profile_setting VALUES ('residecity','1','0','0','居住城市','','0','0','0','0','0','text','0','','');
    
38. INSERT INTO cdb_common_member_profile_setting VALUES ('residedist','1','0','0','居住县','居住行政区/县','0','0','0','0','0','text','0','','');
    
39. INSERT INTO cdb_common_member_profile_setting VALUES ('residecommunity','1','0','0','居住小区','','0','0','0','0','0','text','0','','');
    
40. INSERT INTO cdb_common_member_profile_setting VALUES ('residesuite','0','0','0','房间','小区、写字楼门牌号','0','0','0','0','0','text','0','','');
    
41. INSERT INTO cdb_common_member_profile_setting VALUES ('graduateschool','1','0','0','毕业学校','','0','0','0','0','0','text','0','','');
    
42. 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其它','');
    
43. INSERT INTO cdb_common_member_profile_setting VALUES ('company','1','0','0','公司','','0','0','0','0','0','text','0','','');
    
44. INSERT INTO cdb_common_member_profile_setting VALUES ('occupation','1','0','0','职业','','0','0','0','0','0','text','0','','');
    
45. INSERT INTO cdb_common_member_profile_setting VALUES ('position','1','0','0','职位','','0','0','0','0','0','text','0','','');
    
46. INSERT INTO cdb_common_member_profile_setting VALUES ('revenue','1','0','0','年收入','单位 元','0','0','0','0','0','text','0','','');
    
47. INSERT INTO cdb_common_member_profile_setting VALUES ('affectivestatus','1','1','0','情感状态','','0','0','0','0','0','text','0','','');
    
48. INSERT INTO cdb_common_member_profile_setting VALUES ('lookingfor','1','0','0','交友目的','希望在网站找到什么样的朋友','0','0','0','0','0','text','0','','');
    
49. INSERT INTO cdb_common_member_profile_setting VALUES ('bloodtype','1','1','0','血型','','0','0','0','0','0','select','0','A\nB\nAB\nO\n其它','');
    
50. INSERT INTO cdb_common_member_profile_setting VALUES ('height','0','1','0','身高','单位 cm','0','0','0','0','0','text','0','','');
    
51. INSERT INTO cdb_common_member_profile_setting VALUES ('weight','0','1','0','体重','单位 kg','0','0','0','0','0','text','0','','');
    
52. INSERT INTO cdb_common_member_profile_setting VALUES ('alipay','1','1','0','支付宝帐号','','0','0','0','0','0','text','0','','');
    
53. INSERT INTO cdb_common_member_profile_setting VALUES ('icq','0','1','0','ICQ号','','0','0','0','0','0','text','0','','');
    
54. INSERT INTO cdb_common_member_profile_setting VALUES ('qq','1','1','0','QQ号','','0','0','0','0','0','text','0','','');
    
55. INSERT INTO cdb_common_member_profile_setting VALUES ('yahoo','0','1','0','YAHOO帐号','','0','0','0','0','0','text','0','','');
    
56. INSERT INTO cdb_common_member_profile_setting VALUES ('msn','1','1','0','MSN帐号','','0','0','0','0','0','text','0','','');
    
57. INSERT INTO cdb_common_member_profile_setting VALUES ('taobao','1','1','0','阿里旺旺帐号','','0','0','0','0','0','text','0','','');
    
58. INSERT INTO cdb_common_member_profile_setting VALUES ('site','1','0','0','个人主页','','0','0','0','0','0','text','0','','');
    
59. INSERT INTO cdb_common_member_profile_setting VALUES ('bio','1','1','0','自我介绍','','0','0','0','0','0','textarea','0','','');
    
60. INSERT INTO cdb_common_member_profile_setting VALUES ('interest','1','0','0','兴趣爱好','','0','0','0','0','0','textarea','0','','');
    
61. INSERT INTO cdb_common_member_profile_setting VALUES ('field1','0','1','0','自定义字段1','','0','0','0','0','0','text','0','','');
    
62. INSERT INTO cdb_common_member_profile_setting VALUES ('field2','0','1','0','自定义字段2','','0','0','0','0','0','text','0','','');
    
63. INSERT INTO cdb_common_member_profile_setting VALUES ('field3','0','1','0','自定义字段3','','0','0','0','0','0','text','0','','');
    
64. INSERT INTO cdb_common_member_profile_setting VALUES ('field4','0','1','0','自定义字段4','','0','0','0','0','0','text','0','','');
    
65. INSERT INTO cdb_common_member_profile_setting VALUES ('field5','0','1','0','自定义字段5','','0','0','0','0','0','text','0','','');
    
66. INSERT INTO cdb_common_member_profile_setting VALUES ('field6','0','1','0','自定义字段6','','0','0','0','0','0','text','0','','');
    
67. INSERT INTO cdb_common_member_profile_setting VALUES ('field7','0','1','0','自定义字段7','','0','0','0','0','0','text','0','','');
    
68. INSERT INTO cdb_common_member_profile_setting VALUES ('field8','0','1','0','自定义字段8','','0','0','0','0','0','text','0','','');

复制代码

回复 12# 体无完肤


    怎么修改? 那个文件里面?

回复 12# 体无完肤


    发现点问题
   你的表前缀是cdb的 X的版本前缀是pre

回复 14# netolive


    只是一个模子，当然升级前要自己替换掉前缀嘛~  呵呵

回复 15# 体无完肤


    那倒是 还发现一个问题  字符集 是默认的 还得修改
gbk_chinese_ci

不知道怎么写  栏目的标题 全成了乱码

自己支持