凡是分类升级后不能使用的,进行以下操作:
后台升级:
DROP TABLE `cdb_dsort`;
再升级:
- CREATE TABLE `cdb_dsort` (
- `id` mediumint(10) unsigned NOT NULL auto_increment,
- `sup` int(10) NOT NULL default '1',
- `sort` varchar(12) NOT NULL default '',
- `idder` int(2) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) TYPE=MyISAM
复制代码
再升级:
- INSERT INTO `cdb_dsort` VALUES (1, 0, '常用工具', 0);
- INSERT INTO `cdb_dsort` VALUES (2, 0, '系统工具', 1);
- INSERT INTO `cdb_dsort` VALUES (3, 0, '音乐视频', 4);
- INSERT INTO `cdb_dsort` VALUES (4, 0, '媒体工具', 2);
- INSERT INTO `cdb_dsort` VALUES (5, 0, '图形图像', 3);
- INSERT INTO `cdb_dsort` VALUES (6, 0, '网络工具', 5);
- INSERT INTO `cdb_dsort` VALUES (7, 0, '编程开发', 6);
- INSERT INTO `cdb_dsort` VALUES (8, 0, '游戏娱乐', 7);
- INSERT INTO `cdb_dsort` VALUES (9, 0, '安全相关', 8);
- INSERT INTO `cdb_dsort` VALUES (10, 0, '其他软件', 9);
- INSERT INTO `cdb_dsort` VALUES (43, 1, '转换翻译', 4);
- INSERT INTO `cdb_dsort` VALUES (26, 1, '汉字输入', 2);
- INSERT INTO `cdb_dsort` VALUES (27, 3, '音乐MP3', 1);
- INSERT INTO `cdb_dsort` VALUES (28, 3, '音乐MTV', 2);
- INSERT INTO `cdb_dsort` VALUES (32, 5, '图像处理', 0);
- INSERT INTO `cdb_dsort` VALUES (33, 5, '动画制作', 0);
- INSERT INTO `cdb_dsort` VALUES (34, 5, '虚拟现实', 0);
- INSERT INTO `cdb_dsort` VALUES (35, 5, '图像管理', 0);
- INSERT INTO `cdb_dsort` VALUES (36, 5, '插件Plus', 0);
- INSERT INTO `cdb_dsort` VALUES (37, 5, '图标工具', 0);
- INSERT INTO `cdb_dsort` VALUES (38, 5, '3D软件', 0);
- INSERT INTO `cdb_dsort` VALUES (39, 1, '文字办公', 0);
- INSERT INTO `cdb_dsort` VALUES (40, 1, '文件管理', 1);
- INSERT INTO `cdb_dsort` VALUES (41, 1, '光驱工具', 8);
- INSERT INTO `cdb_dsort` VALUES (42, 1, '压缩解压', 3);
- INSERT INTO `cdb_dsort` VALUES (45, 1, '学习应用', 6);
- INSERT INTO `cdb_dsort` VALUES (46, 1, '信息管理', 7);
- INSERT INTO `cdb_dsort` VALUES (48, 1, '数据备份', 9);
- INSERT INTO `cdb_dsort` VALUES (50, 4, '视频处理', 0);
- INSERT INTO `cdb_dsort` VALUES (51, 4, '媒体制作', 0);
- INSERT INTO `cdb_dsort` VALUES (52, 4, '音频编辑', 0);
- INSERT INTO `cdb_dsort` VALUES (53, 4, '媒体播放', 0);
- INSERT INTO `cdb_dsort` VALUES (54, 4, '媒体管理', 0);
- INSERT INTO `cdb_dsort` VALUES (55, 4, '媒体插件', 0);
- INSERT INTO `cdb_dsort` VALUES (56, 2, '操作系统', 0);
- INSERT INTO `cdb_dsort` VALUES (57, 2, '系统设置', 0);
- INSERT INTO `cdb_dsort` VALUES (58, 2, '系统备份', 0);
- INSERT INTO `cdb_dsort` VALUES (59, 2, '系统测试', 0);
- INSERT INTO `cdb_dsort` VALUES (60, 2, '卸载清除', 0);
- INSERT INTO `cdb_dsort` VALUES (61, 2, '磁盘工具', 0);
- INSERT INTO `cdb_dsort` VALUES (62, 2, '硬件维护', 0);
- INSERT INTO `cdb_dsort` VALUES (63, 2, '系统其它', 0);
- INSERT INTO `cdb_dsort` VALUES (64, 3, '搞笑视频', 5);
- INSERT INTO `cdb_dsort` VALUES (65, 3, '另类视频', 6);
- INSERT INTO `cdb_dsort` VALUES (66, 3, '电影下载', 3);
- INSERT INTO `cdb_dsort` VALUES (67, 3, '电视剧下载', 4);
- INSERT INTO `cdb_dsort` VALUES (68, 6, '服务器类', 0);
- INSERT INTO `cdb_dsort` VALUES (69, 6, '网页制作', 0);
- INSERT INTO `cdb_dsort` VALUES (70, 6, '网络辅助', 0);
- INSERT INTO `cdb_dsort` VALUES (71, 6, '网页浏览', 0);
- INSERT INTO `cdb_dsort` VALUES (72, 6, '联络聊天', 0);
- INSERT INTO `cdb_dsort` VALUES (73, 6, '上传下载', 0);
- INSERT INTO `cdb_dsort` VALUES (74, 6, '远程监控', 0);
- INSERT INTO `cdb_dsort` VALUES (75, 6, '邮件工具', 0);
- INSERT INTO `cdb_dsort` VALUES (76, 6, '网络共享', 0);
- INSERT INTO `cdb_dsort` VALUES (77, 7, '编程工具', 0);
- INSERT INTO `cdb_dsort` VALUES (78, 7, '数据库类', 1);
- INSERT INTO `cdb_dsort` VALUES (79, 7, '安装制作', 2);
- INSERT INTO `cdb_dsort` VALUES (80, 7, '控件插件', 3);
- INSERT INTO `cdb_dsort` VALUES (81, 7, '编译调试', 4);
- INSERT INTO `cdb_dsort` VALUES (82, 7, '.NET相关', 5);
- INSERT INTO `cdb_dsort` VALUES (83, 8, '电脑游戏', 0);
- INSERT INTO `cdb_dsort` VALUES (84, 8, '游戏开发', 0);
- INSERT INTO `cdb_dsort` VALUES (85, 8, '影视频道', 0);
- INSERT INTO `cdb_dsort` VALUES (86, 8, '音乐频道', 0);
- INSERT INTO `cdb_dsort` VALUES (87, 8, '游戏外挂', 0);
- INSERT INTO `cdb_dsort` VALUES (88, 8, '存档升级', 0);
- INSERT INTO `cdb_dsort` VALUES (89, 8, '小型游戏', 0);
- INSERT INTO `cdb_dsort` VALUES (90, 8, '娱乐其他', 0);
- INSERT INTO `cdb_dsort` VALUES (91, 9, '病毒防治', 0);
- INSERT INTO `cdb_dsort` VALUES (92, 9, '系统安全', 0);
- INSERT INTO `cdb_dsort` VALUES (93, 9, '网络安全', 0);
- INSERT INTO `cdb_dsort` VALUES (94, 9, '系统监视', 0);
- INSERT INTO `cdb_dsort` VALUES (95, 9, '密码管理', 0);
- INSERT INTO `cdb_dsort` VALUES (96, 9, '网吧管理', 0);
- INSERT INTO `cdb_dsort` VALUES (97, 9, '浏览安全', 0);
- INSERT INTO `cdb_dsort` VALUES (98, 10, '建站源码', 0);
- INSERT INTO `cdb_dsort` VALUES (99, 10, '汉化补丁', 0);
- INSERT INTO `cdb_dsort` VALUES (100, 10, '精彩动画', 0);
- INSERT INTO `cdb_dsort` VALUES (101, 10, '精品图库', 0);
- INSERT INTO `cdb_dsort` VALUES (102, 10, '经典珍藏', 0);
- INSERT INTO `cdb_dsort` VALUES (103, 10, '综合其他', 0);
- INSERT INTO `cdb_dsort` VALUES (104, 7, '开发助手', 0);
复制代码
[ 本帖最后由 oytktk 于 2005-9-5 12:40 编辑 ] |