不完善,实在不敢推啊!
系统功能->数据库工具->数据库工具里执行下就可以了
DROP TABLE IF EXISTS `qb_wenjuan_category`; CREATE TABLE `qb_wenjuan_category` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `pid` int(10) NOT NULL DEFAULT 0, `uid` int(7) NOT NULL COMMENT '老师的uid', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `list` int(10) NOT NULL, `is_learn` tinyint(1) NOT NULL COMMENT '1为练习题可反复考试', `grade` smallint(5) NOT NULL COMMENT '所属年级', `kemu` smallint(5) NOT NULL COMMENT '所属科目', `step` smallint(5) NOT NULL COMMENT '所属章节', `user_num` mediumint(6) NOT NULL COMMENT '考试人数', `ave_fen` smallint(3) NOT NULL COMMENT '平均分', `money` smallint(4) NOT NULL COMMENT '售价多少积分', `status` tinyint(1) NOT NULL COMMENT '审核状态', `is_share` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否共享给所有人考试', `begin_time` int(10) NOT NULL COMMENT '考试开始日期', `end_time` int(10) NOT NULL COMMENT '考试结束日期', `limit_time` smallint(3) NOT NULL COMMENT '考试时间限制,单位分钟', `prize_about` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `prize_cop` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `myfid` int(7) NOT NULL COMMENT '用户自定义分类', PRIMARY KEY (`id`) USING BTREE, INDEX `pid`(`pid`) USING BTREE, INDEX `list`(`list`) USING BTREE, INDEX `grade`(`grade`) USING BTREE, INDEX `kemu`(`kemu`) USING BTREE, INDEX `step`(`step`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_share`(`is_share`) USING BTREE, INDEX `myfid`(`myfid`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '试卷(原为辅栏目)' ROW_FORMAT = Dynamic;
你这个是问卷吧?