/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50528 Source Host : localhost:3306 Source Database : comperformance Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2013-01-19 10:06:15 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `assessment` -- ---------------------------- DROP TABLE IF EXISTS `assessment`; CREATE TABLE `assessment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `term` varchar(16) NOT NULL, `excellent` int(11) NOT NULL, `good` int(11) NOT NULL, `ordinary` int(11) NOT NULL, `begindate` date NOT NULL, `enddate` date NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `assessment_term_2d24275f2f1163b1_uniq` (`term`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of assessment -- ---------------------------- INSERT INTO `assessment` VALUES ('44', '2012年秋', '40', '30', '30', '2012-12-25', '2012-12-28'); -- ---------------------------- -- Table structure for `assessmentrecord` -- ---------------------------- DROP TABLE IF EXISTS `assessmentrecord`; CREATE TABLE `assessmentrecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `assessment_id` int(11) NOT NULL, `result` varchar(1) NOT NULL, `ostudent_id` int(11) NOT NULL, `dstudent_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `assessmentrecord_c168f2dc` (`assessment_id`), KEY `assessmentrecord_370b6994` (`ostudent_id`), KEY `assessmentrecord_9c969999` (`dstudent_id`), CONSTRAINT `assessment_id_refs_id_481497ac315d3be` FOREIGN KEY (`assessment_id`) REFERENCES `assessment` (`id`), CONSTRAINT `dstudent_id_refs_id_3e3af109a366ce10` FOREIGN KEY (`dstudent_id`) REFERENCES `student` (`id`), CONSTRAINT `ostudent_id_refs_id_3e3af109a366ce10` FOREIGN KEY (`ostudent_id`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2707 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of assessmentrecord -- ---------------------------- INSERT INTO `assessmentrecord` VALUES ('2687', '44', '0', '37', '37'); INSERT INTO `assessmentrecord` VALUES ('2688', '44', '1', '37', '38'); INSERT INTO `assessmentrecord` VALUES ('2689', '44', '1', '37', '39'); INSERT INTO `assessmentrecord` VALUES ('2690', '44', '0', '37', '40'); INSERT INTO `assessmentrecord` VALUES ('2691', '44', '0', '38', '37'); INSERT INTO `assessmentrecord` VALUES ('2692', '44', '0', '38', '38'); INSERT INTO `assessmentrecord` VALUES ('2693', '44', '1', '38', '39'); INSERT INTO `assessmentrecord` VALUES ('2694', '44', '1', '38', '40'); INSERT INTO `assessmentrecord` VALUES ('2695', '44', '0', '39', '37'); INSERT INTO `assessmentrecord` VALUES ('2696', '44', '0', '39', '38'); INSERT INTO `assessmentrecord` VALUES ('2697', '44', '1', '39', '39'); INSERT INTO `assessmentrecord` VALUES ('2698', '44', '2', '39', '40'); INSERT INTO `assessmentrecord` VALUES ('2699', '44', '0', '40', '37'); INSERT INTO `assessmentrecord` VALUES ('2700', '44', '0', '40', '38'); INSERT INTO `assessmentrecord` VALUES ('2701', '44', '1', '40', '39'); INSERT INTO `assessmentrecord` VALUES ('2702', '44', '2', '40', '40'); INSERT INTO `assessmentrecord` VALUES ('2703', '44', '0', '41', '41'); INSERT INTO `assessmentrecord` VALUES ('2704', '44', '1', '41', '42'); INSERT INTO `assessmentrecord` VALUES ('2705', '44', '0', '42', '41'); INSERT INTO `assessmentrecord` VALUES ('2706', '44', '1', '42', '42'); -- ---------------------------- -- Table structure for `assessmentrow` -- ---------------------------- DROP TABLE IF EXISTS `assessmentrow`; CREATE TABLE `assessmentrow` ( `id` int(11) NOT NULL AUTO_INCREMENT, `assessment_id` int(11) NOT NULL, `excellent` int(11) NOT NULL, `good` int(11) NOT NULL, `ordinary` int(11) NOT NULL, `student_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `assessmentrow_c168f2dc` (`assessment_id`), KEY `assessmentrow_42ff452e` (`student_id`), CONSTRAINT `assessment_id_refs_id_678d39fc296003b8` FOREIGN KEY (`assessment_id`) REFERENCES `assessment` (`id`), CONSTRAINT `student_id_refs_id_6c5fd85230c6a2fa` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of assessmentrow -- ---------------------------- INSERT INTO `assessmentrow` VALUES ('123', '44', '4', '0', '0', '37'); INSERT INTO `assessmentrow` VALUES ('124', '44', '3', '1', '0', '38'); INSERT INTO `assessmentrow` VALUES ('125', '44', '0', '4', '0', '39'); INSERT INTO `assessmentrow` VALUES ('126', '44', '1', '1', '2', '40'); INSERT INTO `assessmentrow` VALUES ('127', '44', '2', '0', '0', '41'); INSERT INTO `assessmentrow` VALUES ('128', '44', '0', '2', '0', '42'); -- ---------------------------- -- Table structure for `auth_group` -- ---------------------------- DROP TABLE IF EXISTS `auth_group`; CREATE TABLE `auth_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_group -- ---------------------------- -- ---------------------------- -- Table structure for `auth_group_permissions` -- ---------------------------- DROP TABLE IF EXISTS `auth_group_permissions`; CREATE TABLE `auth_group_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `permission_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `group_id` (`group_id`,`permission_id`), KEY `auth_group_permissions_bda51c3c` (`group_id`), KEY `auth_group_permissions_1e014c8f` (`permission_id`), CONSTRAINT `group_id_refs_id_3cea63fe` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), CONSTRAINT `permission_id_refs_id_a7792de1` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_group_permissions -- ---------------------------- -- ---------------------------- -- Table structure for `auth_message` -- ---------------------------- DROP TABLE IF EXISTS `auth_message`; CREATE TABLE `auth_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `message` longtext NOT NULL, PRIMARY KEY (`id`), KEY `auth_message_fbfc09f1` (`user_id`), CONSTRAINT `user_id_refs_id_9af0b65a` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_message -- ---------------------------- -- ---------------------------- -- Table structure for `auth_permission` -- ---------------------------- DROP TABLE IF EXISTS `auth_permission`; CREATE TABLE `auth_permission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `content_type_id` int(11) NOT NULL, `codename` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `content_type_id` (`content_type_id`,`codename`), KEY `auth_permission_e4470c6e` (`content_type_id`), CONSTRAINT `content_type_id_refs_id_728de91f` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_permission -- ---------------------------- INSERT INTO `auth_permission` VALUES ('1', 'Can add permission', '1', 'add_permission'); INSERT INTO `auth_permission` VALUES ('2', 'Can change permission', '1', 'change_permission'); INSERT INTO `auth_permission` VALUES ('3', 'Can delete permission', '1', 'delete_permission'); INSERT INTO `auth_permission` VALUES ('4', 'Can add group', '2', 'add_group'); INSERT INTO `auth_permission` VALUES ('5', 'Can change group', '2', 'change_group'); INSERT INTO `auth_permission` VALUES ('6', 'Can delete group', '2', 'delete_group'); INSERT INTO `auth_permission` VALUES ('7', 'Can add user', '3', 'add_user'); INSERT INTO `auth_permission` VALUES ('8', 'Can change user', '3', 'change_user'); INSERT INTO `auth_permission` VALUES ('9', 'Can delete user', '3', 'delete_user'); INSERT INTO `auth_permission` VALUES ('10', 'Can add message', '4', 'add_message'); INSERT INTO `auth_permission` VALUES ('11', 'Can change message', '4', 'change_message'); INSERT INTO `auth_permission` VALUES ('12', 'Can delete message', '4', 'delete_message'); INSERT INTO `auth_permission` VALUES ('13', 'Can add content type', '5', 'add_contenttype'); INSERT INTO `auth_permission` VALUES ('14', 'Can change content type', '5', 'change_contenttype'); INSERT INTO `auth_permission` VALUES ('15', 'Can delete content type', '5', 'delete_contenttype'); INSERT INTO `auth_permission` VALUES ('16', 'Can add session', '6', 'add_session'); INSERT INTO `auth_permission` VALUES ('17', 'Can change session', '6', 'change_session'); INSERT INTO `auth_permission` VALUES ('18', 'Can delete session', '6', 'delete_session'); INSERT INTO `auth_permission` VALUES ('19', 'Can add site', '7', 'add_site'); INSERT INTO `auth_permission` VALUES ('20', 'Can change site', '7', 'change_site'); INSERT INTO `auth_permission` VALUES ('21', 'Can delete site', '7', 'delete_site'); INSERT INTO `auth_permission` VALUES ('22', 'Can add captcha store', '8', 'add_captchastore'); INSERT INTO `auth_permission` VALUES ('23', 'Can change captcha store', '8', 'change_captchastore'); INSERT INTO `auth_permission` VALUES ('24', 'Can delete captcha store', '8', 'delete_captchastore'); INSERT INTO `auth_permission` VALUES ('25', 'Can add migration history', '9', 'add_migrationhistory'); INSERT INTO `auth_permission` VALUES ('26', 'Can change migration history', '9', 'change_migrationhistory'); INSERT INTO `auth_permission` VALUES ('27', 'Can delete migration history', '9', 'delete_migrationhistory'); INSERT INTO `auth_permission` VALUES ('28', 'Can add class', '10', 'add_class'); INSERT INTO `auth_permission` VALUES ('29', 'Can change class', '10', 'change_class'); INSERT INTO `auth_permission` VALUES ('30', 'Can delete class', '10', 'delete_class'); INSERT INTO `auth_permission` VALUES ('31', 'Can add student', '11', 'add_student'); INSERT INTO `auth_permission` VALUES ('32', 'Can change student', '11', 'change_student'); INSERT INTO `auth_permission` VALUES ('33', 'Can delete student', '11', 'delete_student'); INSERT INTO `auth_permission` VALUES ('34', 'Can add assessment', '12', 'add_assessment'); INSERT INTO `auth_permission` VALUES ('35', 'Can change assessment', '12', 'change_assessment'); INSERT INTO `auth_permission` VALUES ('36', 'Can delete assessment', '12', 'delete_assessment'); INSERT INTO `auth_permission` VALUES ('40', 'Can add grade', '14', 'add_grade'); INSERT INTO `auth_permission` VALUES ('41', 'Can change grade', '14', 'change_grade'); INSERT INTO `auth_permission` VALUES ('42', 'Can delete grade', '14', 'delete_grade'); INSERT INTO `auth_permission` VALUES ('43', 'Can add behavior', '15', 'add_behavior'); INSERT INTO `auth_permission` VALUES ('44', 'Can change behavior', '15', 'change_behavior'); INSERT INTO `auth_permission` VALUES ('45', 'Can delete behavior', '15', 'delete_behavior'); INSERT INTO `auth_permission` VALUES ('46', 'Can add development', '16', 'add_development'); INSERT INTO `auth_permission` VALUES ('47', 'Can change development', '16', 'change_development'); INSERT INTO `auth_permission` VALUES ('48', 'Can delete development', '16', 'delete_development'); INSERT INTO `auth_permission` VALUES ('49', 'Can add comperformance', '17', 'add_comperformance'); INSERT INTO `auth_permission` VALUES ('50', 'Can change comperformance', '17', 'change_comperformance'); INSERT INTO `auth_permission` VALUES ('51', 'Can delete comperformance', '17', 'delete_comperformance'); INSERT INTO `auth_permission` VALUES ('52', 'Can add comperformance development score', '18', 'add_comperformancedevelopmentscore'); INSERT INTO `auth_permission` VALUES ('53', 'Can change comperformance development score', '18', 'change_comperformancedevelopmentscore'); INSERT INTO `auth_permission` VALUES ('54', 'Can delete comperformance development score', '18', 'delete_comperformancedevelopmentscore'); INSERT INTO `auth_permission` VALUES ('55', 'Can add comperformance behavior score', '19', 'add_comperformancebehaviorscore'); INSERT INTO `auth_permission` VALUES ('56', 'Can change comperformance behavior score', '19', 'change_comperformancebehaviorscore'); INSERT INTO `auth_permission` VALUES ('57', 'Can delete comperformance behavior score', '19', 'delete_comperformancebehaviorscore'); INSERT INTO `auth_permission` VALUES ('58', 'Can add comperformance physical score', '20', 'add_comperformancephysicalscore'); INSERT INTO `auth_permission` VALUES ('59', 'Can change comperformance physical score', '20', 'change_comperformancephysicalscore'); INSERT INTO `auth_permission` VALUES ('60', 'Can delete comperformance physical score', '20', 'delete_comperformancephysicalscore'); INSERT INTO `auth_permission` VALUES ('61', 'Can add assessment record', '21', 'add_assessmentrecord'); INSERT INTO `auth_permission` VALUES ('62', 'Can change assessment record', '21', 'change_assessmentrecord'); INSERT INTO `auth_permission` VALUES ('63', 'Can delete assessment record', '21', 'delete_assessmentrecord'); INSERT INTO `auth_permission` VALUES ('64', 'Can add log entry', '22', 'add_logentry'); INSERT INTO `auth_permission` VALUES ('65', 'Can change log entry', '22', 'change_logentry'); INSERT INTO `auth_permission` VALUES ('66', 'Can delete log entry', '22', 'delete_logentry'); INSERT INTO `auth_permission` VALUES ('67', 'Can add assessment row', '23', 'add_assessmentrow'); INSERT INTO `auth_permission` VALUES ('68', 'Can change assessment row', '23', 'change_assessmentrow'); INSERT INTO `auth_permission` VALUES ('69', 'Can delete assessment row', '23', 'delete_assessmentrow'); INSERT INTO `auth_permission` VALUES ('70', 'Can add comperformance score', '24', 'add_comperformancescore'); INSERT INTO `auth_permission` VALUES ('71', 'Can change comperformance score', '24', 'change_comperformancescore'); INSERT INTO `auth_permission` VALUES ('72', 'Can delete comperformance score', '24', 'delete_comperformancescore'); -- ---------------------------- -- Table structure for `auth_user` -- ---------------------------- DROP TABLE IF EXISTS `auth_user`; CREATE TABLE `auth_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(30) NOT NULL, `first_name` varchar(30) NOT NULL, `last_name` varchar(30) NOT NULL, `email` varchar(75) NOT NULL, `password` varchar(128) NOT NULL, `is_staff` tinyint(1) NOT NULL, `is_active` tinyint(1) NOT NULL, `is_superuser` tinyint(1) NOT NULL, `last_login` datetime NOT NULL, `date_joined` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_user -- ---------------------------- INSERT INTO `auth_user` VALUES ('1', 'guomeng', '', '', '[email protected]', 'sha1$65839$3a98a347d1a6306326aafd1ccc323f773f555120', '1', '1', '1', '2013-01-19 09:41:42', '2012-12-10 05:55:42'); INSERT INTO `auth_user` VALUES ('41', '101110312', '', '', '', 'sha1$f265d$2dba19d5fe4360f0f4d20cf278b97e3daead5d96', '1', '1', '0', '2012-12-25 08:52:34', '2012-12-25 08:34:29'); INSERT INTO `auth_user` VALUES ('42', '101110313', '', '', '', 'sha1$68917$9550a7bddad10e51ac899c132fb903f8d5d99174', '1', '1', '0', '2012-12-25 08:57:33', '2012-12-25 08:36:28'); INSERT INTO `auth_user` VALUES ('43', '101110314', '', '', '', 'sha1$6f8b7$f7fc46006b082cb7e8ba9a3db067e21626d886e7', '1', '1', '0', '2012-12-25 08:43:28', '2012-12-25 08:37:05'); INSERT INTO `auth_user` VALUES ('44', '101110315', '', '', '', 'sha1$202db$6917256dcd23f5d760658f3f8c2a41efc3f3d6ee', '1', '1', '0', '2012-12-25 08:43:54', '2012-12-25 08:37:28'); INSERT INTO `auth_user` VALUES ('45', '101110101', '', '', '', 'sha1$0903e$bed4b52cd97109132412abf25081ee598f4fee5d', '1', '1', '0', '2012-12-25 08:45:14', '2012-12-25 08:37:49'); INSERT INTO `auth_user` VALUES ('46', '101110112', '', '', '', 'sha1$b1b12$75319957624d83828c7ff76ba4784fb7fa8ee46f', '1', '1', '0', '2012-12-25 08:45:33', '2012-12-25 08:38:38'); -- ---------------------------- -- Table structure for `auth_user_groups` -- ---------------------------- DROP TABLE IF EXISTS `auth_user_groups`; CREATE TABLE `auth_user_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`,`group_id`), KEY `auth_user_groups_fbfc09f1` (`user_id`), KEY `auth_user_groups_bda51c3c` (`group_id`), CONSTRAINT `group_id_refs_id_f0ee9890` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), CONSTRAINT `user_id_refs_id_831107f1` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_user_groups -- ---------------------------- -- ---------------------------- -- Table structure for `auth_user_user_permissions` -- ---------------------------- DROP TABLE IF EXISTS `auth_user_user_permissions`; CREATE TABLE `auth_user_user_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `permission_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`,`permission_id`), KEY `auth_user_user_permissions_fbfc09f1` (`user_id`), KEY `auth_user_user_permissions_1e014c8f` (`permission_id`), CONSTRAINT `permission_id_refs_id_67e79cb` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `user_id_refs_id_f2045483` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_user_user_permissions -- ---------------------------- -- ---------------------------- -- Table structure for `behavior` -- ---------------------------- DROP TABLE IF EXISTS `behavior`; CREATE TABLE `behavior` ( `id` int(11) NOT NULL AUTO_INCREMENT, `actlevel` varchar(1) NOT NULL, `name` varchar(16) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of behavior -- ---------------------------- INSERT INTO `behavior` VALUES ('14', '0', '运动会'); INSERT INTO `behavior` VALUES ('15', '0', '社团联合会'); INSERT INTO `behavior` VALUES ('16', '1', '卫生'); -- ---------------------------- -- Table structure for `captcha_captchastore` -- ---------------------------- DROP TABLE IF EXISTS `captcha_captchastore`; CREATE TABLE `captcha_captchastore` ( `id` int(11) NOT NULL AUTO_INCREMENT, `challenge` varchar(32) NOT NULL, `response` varchar(32) NOT NULL, `hashkey` varchar(40) NOT NULL, `expiration` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `hashkey` (`hashkey`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of captcha_captchastore -- ---------------------------- INSERT INTO `captcha_captchastore` VALUES ('4', '5+7=', '12', 'baca31961f955278284c8f67845da1215f782f60', '2013-01-19 09:42:13'); INSERT INTO `captcha_captchastore` VALUES ('5', '3-2=', '1', '0c6e8d844fca7e80a004442ca6835a7e9955d4d6', '2013-01-19 09:43:28'); -- ---------------------------- -- Table structure for `class` -- ---------------------------- DROP TABLE IF EXISTS `class`; CREATE TABLE `class` ( `id` int(11) NOT NULL AUTO_INCREMENT, `classid` varchar(10) NOT NULL, `classname` varchar(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `class_classid_4a2e781305b0d34e_uniq` (`classid`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of class -- ---------------------------- INSERT INTO `class` VALUES ('22', '1011103', '软件三班'); INSERT INTO `class` VALUES ('23', '1011101', '软件一班'); -- ---------------------------- -- Table structure for `comperformance` -- ---------------------------- DROP TABLE IF EXISTS `comperformance`; CREATE TABLE `comperformance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `excellent` double NOT NULL, `good` double NOT NULL, `ordinary` double NOT NULL, `physical` double NOT NULL, `behavior` double NOT NULL, `development` double NOT NULL, `moral` double NOT NULL, `behaviorup` double NOT NULL, `term` varchar(16) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `comperformance_term_98541db216b86d0_uniq` (`term`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of comperformance -- ---------------------------- INSERT INTO `comperformance` VALUES ('23', '40', '35', '30', '5', '35', '2', '40', '55', '2012年秋'); -- ---------------------------- -- Table structure for `comperformancebehaviorscore` -- ---------------------------- DROP TABLE IF EXISTS `comperformancebehaviorscore`; CREATE TABLE `comperformancebehaviorscore` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `comperformance_id` int(11) NOT NULL, `behavior_id` int(11) NOT NULL, `score` double, PRIMARY KEY (`id`), KEY `comperformancebehaviorscore_42ff452e` (`student_id`), KEY `comperformancebehaviorscore_28fbb1e5` (`comperformance_id`), KEY `comperformancebehaviorscore_1675d4f6` (`behavior_id`), CONSTRAINT `behavior_id_refs_id_77382c078dcf59a5` FOREIGN KEY (`behavior_id`) REFERENCES `behavior` (`id`), CONSTRAINT `comperformance_id_refs_id_9db7e2145d39566` FOREIGN KEY (`comperformance_id`) REFERENCES `comperformance` (`id`), CONSTRAINT `student_id_refs_id_550d503b0393d3c5` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of comperformancebehaviorscore -- ---------------------------- INSERT INTO `comperformancebehaviorscore` VALUES ('1', '37', '23', '16', '5'); INSERT INTO `comperformancebehaviorscore` VALUES ('2', '37', '23', '14', '5'); -- ---------------------------- -- Table structure for `comperformancedevelopmentscore` -- ---------------------------- DROP TABLE IF EXISTS `comperformancedevelopmentscore`; CREATE TABLE `comperformancedevelopmentscore` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `comperformance_id` int(11) NOT NULL, `development_id` int(11) NOT NULL, `score` double, PRIMARY KEY (`id`), KEY `comperformancedevelopmentscore_42ff452e` (`student_id`), KEY `comperformancedevelopmentscore_28fbb1e5` (`comperformance_id`), KEY `comperformancedevelopmentscore_fce2cd04` (`development_id`), CONSTRAINT `comperformance_id_refs_id_3cde1d1e3bb5ec66` FOREIGN KEY (`comperformance_id`) REFERENCES `comperformance` (`id`), CONSTRAINT `development_id_refs_id_5a19d8e2dcf4b593` FOREIGN KEY (`development_id`) REFERENCES `development` (`id`), CONSTRAINT `student_id_refs_id_10b9c16c636bae29` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of comperformancedevelopmentscore -- ---------------------------- INSERT INTO `comperformancedevelopmentscore` VALUES ('1', '37', '23', '16', '2'); -- ---------------------------- -- Table structure for `comperformancephysicalscore` -- ---------------------------- DROP TABLE IF EXISTS `comperformancephysicalscore`; CREATE TABLE `comperformancephysicalscore` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `comperformance_id` int(11) NOT NULL, `score` double, PRIMARY KEY (`id`), KEY `comperformancephysicalscore_42ff452e` (`student_id`), KEY `comperformancephysicalscore_28fbb1e5` (`comperformance_id`), CONSTRAINT `comperformance_id_refs_id_47d583b7ad9a3037` FOREIGN KEY (`comperformance_id`) REFERENCES `comperformance` (`id`), CONSTRAINT `student_id_refs_id_2e6f0bea3f56cbd8` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of comperformancephysicalscore -- ---------------------------- INSERT INTO `comperformancephysicalscore` VALUES ('14', '37', '23', '5'); -- ---------------------------- -- Table structure for `comperformancescore` -- ---------------------------- DROP TABLE IF EXISTS `comperformancescore`; CREATE TABLE `comperformancescore` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `comperformance_id` int(11) NOT NULL, `score` double, `assessmentscore` double, PRIMARY KEY (`id`), KEY `comperformancescore_42ff452e` (`student_id`), KEY `comperformancescore_28fbb1e5` (`comperformance_id`), CONSTRAINT `comperformance_id_refs_id_5c562630e95b581c` FOREIGN KEY (`comperformance_id`) REFERENCES `comperformance` (`id`), CONSTRAINT `student_id_refs_id_c1fcc1a5d7f512d` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of comperformancescore -- ---------------------------- INSERT INTO `comperformancescore` VALUES ('49', '37', '23', '88.038', '40'); INSERT INTO `comperformancescore` VALUES ('50', '38', '23', '83.9', '38.75'); INSERT INTO `comperformancescore` VALUES ('51', '39', '23', '78.015', '35'); INSERT INTO `comperformancescore` VALUES ('52', '40', '23', '79.509', '33.75'); INSERT INTO `comperformancescore` VALUES ('53', '41', '23', '73.166', '40'); INSERT INTO `comperformancescore` VALUES ('54', '42', '23', '78.848', '35'); -- ---------------------------- -- Table structure for `development` -- ---------------------------- DROP TABLE IF EXISTS `development`; CREATE TABLE `development` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent` varchar(1) NOT NULL DEFAULT '1', `name` varchar(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of development -- ---------------------------- INSERT INTO `development` VALUES ('15', '1', '校电赛'); INSERT INTO `development` VALUES ('16', '0', '学生会'); -- ---------------------------- -- Table structure for `django_admin_log` -- ---------------------------- DROP TABLE IF EXISTS `django_admin_log`; CREATE TABLE `django_admin_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_time` datetime NOT NULL, `user_id` int(11) NOT NULL, `content_type_id` int(11) DEFAULT NULL, `object_id` longtext, `object_repr` varchar(200) NOT NULL, `action_flag` smallint(5) unsigned NOT NULL, `change_message` longtext NOT NULL, PRIMARY KEY (`id`), KEY `django_admin_log_fbfc09f1` (`user_id`), KEY `django_admin_log_e4470c6e` (`content_type_id`), CONSTRAINT `content_type_id_refs_id_288599e6` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`), CONSTRAINT `user_id_refs_id_c8665aa` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of django_admin_log -- ---------------------------- INSERT INTO `django_admin_log` VALUES ('1', '2012-12-16 03:13:11', '1', '12', '2', '2012年秋', '1', ''); INSERT INTO `django_admin_log` VALUES ('2', '2012-12-17 10:05:08', '1', '21', '1', '2012年秋郭猛-闫超', '1', ''); INSERT INTO `django_admin_log` VALUES ('3', '2012-12-17 10:15:56', '1', '12', '3', '2011年秋', '1', ''); INSERT INTO `django_admin_log` VALUES ('4', '2012-12-17 10:49:06', '1', '12', '4', '2011年春', '1', ''); INSERT INTO `django_admin_log` VALUES ('5', '2012-12-17 10:49:28', '1', '12', '5', '2012年春', '1', ''); INSERT INTO `django_admin_log` VALUES ('6', '2012-12-18 04:27:04', '1', '21', '1', '2012年秋郭猛-闫超', '3', ''); INSERT INTO `django_admin_log` VALUES ('7', '2012-12-18 05:20:54', '1', '21', '2', '2012年秋苏向坤-王冠群', '3', ''); INSERT INTO `django_admin_log` VALUES ('8', '2012-12-18 15:53:33', '1', '12', '31', '2012年秋', '2', '已修改 begindate 。'); INSERT INTO `django_admin_log` VALUES ('9', '2012-12-18 20:01:51', '1', '21', '1919', '2012年秋郭猛-闫超', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('10', '2012-12-18 20:02:06', '1', '21', '1920', '2012年秋郭猛-陈彦克', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('11', '2012-12-18 20:02:18', '1', '21', '1921', '2012年秋郭猛-张琦', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('12', '2012-12-18 20:02:37', '1', '21', '1924', '2012年秋郭猛-赵婷婷', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('13', '2012-12-18 20:02:58', '1', '21', '1923', '2012年秋郭猛-常轶群', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('14', '2012-12-18 20:03:15', '1', '21', '1930', '2012年秋郭猛-何鑫', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('15', '2012-12-18 20:03:26', '1', '21', '1929', '2012年秋郭猛-朴铁军', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('16', '2012-12-18 20:03:40', '1', '21', '1931', '2012年秋郭猛-王功勋', '2', '已修改 result 。'); INSERT INTO `django_admin_log` VALUES ('17', '2012-12-19 14:31:47', '1', '14', '2', '2012年秋 101110112-->82.64', '3', ''); INSERT INTO `django_admin_log` VALUES ('18', '2012-12-19 14:31:47', '1', '14', '1', '2012年秋 101110101-->72.38', '3', ''); INSERT INTO `django_admin_log` VALUES ('19', '2012-12-19 19:54:46', '1', '15', '1', '社团联合会', '1', ''); INSERT INTO `django_admin_log` VALUES ('20', '2012-12-19 19:55:05', '1', '15', '2', '卫生学院', '1', ''); INSERT INTO `django_admin_log` VALUES ('21', '2012-12-19 19:55:45', '1', '15', '3', '征文比赛', '1', ''); INSERT INTO `django_admin_log` VALUES ('22', '2012-12-19 19:55:59', '1', '15', '4', '志愿者', '1', ''); INSERT INTO `django_admin_log` VALUES ('23', '2012-12-19 22:05:59', '1', '15', '5', '123', '3', ''); INSERT INTO `django_admin_log` VALUES ('24', '2012-12-20 08:41:06', '1', '16', '1', '班委', '1', ''); INSERT INTO `django_admin_log` VALUES ('25', '2012-12-20 08:41:15', '1', '16', '2', '学生会', '1', ''); INSERT INTO `django_admin_log` VALUES ('26', '2012-12-20 08:41:47', '1', '16', '3', '省级以上竞赛', '1', ''); INSERT INTO `django_admin_log` VALUES ('27', '2012-12-20 08:42:05', '1', '16', '4', '软件工程师', '1', ''); INSERT INTO `django_admin_log` VALUES ('28', '2012-12-20 13:58:00', '1', '17', '1', '2012年秋', '1', ''); INSERT INTO `django_admin_log` VALUES ('29', '2012-12-20 14:23:35', '1', '24', '9', '综合成绩分数：88.12互评分数：37.78', '1', ''); INSERT INTO `django_admin_log` VALUES ('30', '2012-12-20 14:26:02', '1', '18', '1', '101110312-->个性发展分数:2.0', '1', ''); INSERT INTO `django_admin_log` VALUES ('31', '2012-12-20 14:26:20', '1', '20', '2', '101110312-->体能分数：5.0', '1', ''); INSERT INTO `django_admin_log` VALUES ('32', '2012-12-20 14:26:31', '1', '19', '2', '101110312-->日常行为分数:5.0', '1', ''); INSERT INTO `django_admin_log` VALUES ('33', '2012-12-20 14:26:57', '1', '18', '1', '101110312-->个性发展分数:2.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('34', '2012-12-20 14:27:08', '1', '20', '2', '101110312-->体能分数：5.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('35', '2012-12-20 14:27:28', '1', '19', '2', '101110312-->日常行为分数:5.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('36', '2012-12-20 14:28:00', '1', '24', '9', '101110312-->综合成绩分数：88.12互评分数：37.78', '3', ''); INSERT INTO `django_admin_log` VALUES ('37', '2012-12-20 14:28:13', '1', '17', '1', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('38', '2012-12-21 14:03:15', '1', '17', '2', '2012年秋', '1', ''); INSERT INTO `django_admin_log` VALUES ('39', '2012-12-21 15:32:16', '1', '18', '2', '101110312-->个性发展分数:2.0', '1', ''); INSERT INTO `django_admin_log` VALUES ('40', '2012-12-21 15:32:21', '1', '18', '2', '101110312-->个性发展分数:2.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('41', '2012-12-22 06:23:55', '1', '24', '15', '101110112-->综合成绩分数：107.64互评分数：0.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('42', '2012-12-22 06:23:55', '1', '24', '14', '101110101-->综合成绩分数：102.33互评分数：0.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('43', '2012-12-22 06:23:55', '1', '24', '13', '101110315-->综合成绩分数：119.12互评分数：0.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('44', '2012-12-22 06:23:55', '1', '24', '12', '101110314-->综合成绩分数：106.45互评分数：0.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('45', '2012-12-22 06:23:55', '1', '24', '11', '101110313-->综合成绩分数：112.89互评分数：0.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('46', '2012-12-22 06:23:55', '1', '24', '10', '101110312-->综合成绩分数：116.38互评分数：0.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('47', '2012-12-22 16:51:43', '1', '19', '3', '101110101-->日常行为分数:None', '3', ''); INSERT INTO `django_admin_log` VALUES ('48', '2012-12-22 16:52:38', '1', '19', '5', '101110101-->日常行为分数:None', '3', ''); INSERT INTO `django_admin_log` VALUES ('49', '2012-12-22 16:59:22', '1', '19', '7', '101110101-->日常行为分数:None', '3', ''); INSERT INTO `django_admin_log` VALUES ('50', '2012-12-22 17:05:56', '1', '19', '10', '101110101-->日常行为分数:None', '3', ''); INSERT INTO `django_admin_log` VALUES ('51', '2012-12-22 17:05:56', '1', '19', '9', '101110312-->日常行为分数:2.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('52', '2012-12-22 17:05:56', '1', '19', '8', '101110112-->日常行为分数:2.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('53', '2012-12-22 17:05:56', '1', '19', '6', '101110101-->日常行为分数:5.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('54', '2012-12-22 17:05:57', '1', '19', '4', '101110101-->日常行为分数:5.0', '3', ''); INSERT INTO `django_admin_log` VALUES ('55', '2012-12-22 17:16:24', '1', '20', '3', '101110101-->体能分数：None', '3', ''); INSERT INTO `django_admin_log` VALUES ('56', '2012-12-22 20:34:16', '1', '17', '19', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('57', '2012-12-22 20:34:28', '1', '10', '11', '1011101', '3', ''); INSERT INTO `django_admin_log` VALUES ('58', '2012-12-22 20:34:28', '1', '10', '1', '1011103', '3', ''); INSERT INTO `django_admin_log` VALUES ('59', '2012-12-22 20:34:51', '1', '15', '6', '学校卫生', '3', ''); INSERT INTO `django_admin_log` VALUES ('60', '2012-12-22 20:34:51', '1', '15', '5', '篮球赛', '3', ''); INSERT INTO `django_admin_log` VALUES ('61', '2012-12-22 20:34:51', '1', '15', '4', '志愿者', '3', ''); INSERT INTO `django_admin_log` VALUES ('62', '2012-12-22 20:34:51', '1', '15', '2', '卫生学院', '3', ''); INSERT INTO `django_admin_log` VALUES ('63', '2012-12-22 20:34:51', '1', '15', '1', '社团联合会', '3', ''); INSERT INTO `django_admin_log` VALUES ('64', '2012-12-22 20:35:02', '1', '16', '6', '导员助理', '3', ''); INSERT INTO `django_admin_log` VALUES ('65', '2012-12-22 20:35:02', '1', '16', '5', '校电赛', '3', ''); INSERT INTO `django_admin_log` VALUES ('66', '2012-12-22 20:35:02', '1', '16', '4', '软件工程师', '3', ''); INSERT INTO `django_admin_log` VALUES ('67', '2012-12-22 20:35:02', '1', '16', '3', '省级以上竞赛', '3', ''); INSERT INTO `django_admin_log` VALUES ('68', '2012-12-22 20:35:02', '1', '16', '2', '学生会', '3', ''); INSERT INTO `django_admin_log` VALUES ('69', '2012-12-22 20:35:14', '1', '12', '39', '2013年春', '3', ''); INSERT INTO `django_admin_log` VALUES ('70', '2012-12-22 20:35:14', '1', '12', '38', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('71', '2012-12-22 20:40:15', '1', '3', '14', '101110101', '3', ''); INSERT INTO `django_admin_log` VALUES ('72', '2012-12-22 20:40:15', '1', '3', '15', '101110112', '3', ''); INSERT INTO `django_admin_log` VALUES ('73', '2012-12-22 20:40:15', '1', '3', '3', '101110312', '3', ''); INSERT INTO `django_admin_log` VALUES ('74', '2012-12-22 20:40:15', '1', '3', '4', '101110313', '3', ''); INSERT INTO `django_admin_log` VALUES ('75', '2012-12-22 20:40:15', '1', '3', '5', '101110314', '3', ''); INSERT INTO `django_admin_log` VALUES ('76', '2012-12-22 20:40:15', '1', '3', '6', '101110315', '3', ''); INSERT INTO `django_admin_log` VALUES ('77', '2012-12-22 21:00:33', '1', '17', '20', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('78', '2012-12-22 21:00:44', '1', '10', '17', '1011101', '3', ''); INSERT INTO `django_admin_log` VALUES ('79', '2012-12-22 21:00:44', '1', '10', '15', '1011104', '3', ''); INSERT INTO `django_admin_log` VALUES ('80', '2012-12-22 21:00:44', '1', '10', '14', '1011103', '3', ''); INSERT INTO `django_admin_log` VALUES ('81', '2012-12-22 21:00:54', '1', '16', '9', '软件工程师', '3', ''); INSERT INTO `django_admin_log` VALUES ('82', '2012-12-22 21:00:54', '1', '16', '8', '省赛', '3', ''); INSERT INTO `django_admin_log` VALUES ('83', '2012-12-22 21:00:54', '1', '16', '7', '学生会', '3', ''); INSERT INTO `django_admin_log` VALUES ('84', '2012-12-22 21:01:02', '1', '12', '40', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('85', '2012-12-22 21:01:28', '1', '15', '9', '运动会', '3', ''); INSERT INTO `django_admin_log` VALUES ('86', '2012-12-22 21:01:28', '1', '15', '8', '编程大赛', '3', ''); INSERT INTO `django_admin_log` VALUES ('87', '2012-12-22 21:01:28', '1', '15', '7', '卫生', '3', ''); INSERT INTO `django_admin_log` VALUES ('88', '2012-12-22 21:07:25', '1', '3', '25', '101110101', '3', ''); INSERT INTO `django_admin_log` VALUES ('89', '2012-12-22 21:07:25', '1', '3', '26', '101110112', '3', ''); INSERT INTO `django_admin_log` VALUES ('90', '2012-12-22 21:07:25', '1', '3', '24', '101110201', '3', ''); INSERT INTO `django_admin_log` VALUES ('91', '2012-12-22 21:07:25', '1', '3', '18', '101110312', '3', ''); INSERT INTO `django_admin_log` VALUES ('92', '2012-12-22 21:07:25', '1', '3', '19', '101110313', '3', ''); INSERT INTO `django_admin_log` VALUES ('93', '2012-12-22 21:07:25', '1', '3', '21', '101110314', '3', ''); INSERT INTO `django_admin_log` VALUES ('94', '2012-12-22 21:07:25', '1', '3', '20', '101110315', '3', ''); INSERT INTO `django_admin_log` VALUES ('95', '2012-12-22 21:07:25', '1', '3', '22', '101110401', '3', ''); INSERT INTO `django_admin_log` VALUES ('96', '2012-12-22 21:07:25', '1', '3', '23', '101110405', '3', ''); INSERT INTO `django_admin_log` VALUES ('97', '2012-12-23 10:00:18', '1', '17', '21', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('98', '2012-12-23 10:00:29', '1', '10', '19', '1011103', '3', ''); INSERT INTO `django_admin_log` VALUES ('99', '2012-12-23 10:00:29', '1', '10', '18', '1011101', '3', ''); INSERT INTO `django_admin_log` VALUES ('100', '2012-12-23 10:02:37', '1', '16', '12', '软件工程师', '3', ''); INSERT INTO `django_admin_log` VALUES ('101', '2012-12-23 10:02:37', '1', '16', '11', 'acm', '3', ''); INSERT INTO `django_admin_log` VALUES ('102', '2012-12-23 10:02:37', '1', '16', '10', '学生会', '3', ''); INSERT INTO `django_admin_log` VALUES ('103', '2012-12-23 10:02:55', '1', '15', '11', '篮球赛', '3', ''); INSERT INTO `django_admin_log` VALUES ('104', '2012-12-23 10:02:55', '1', '15', '10', '卫生', '3', ''); INSERT INTO `django_admin_log` VALUES ('105', '2012-12-23 10:03:13', '1', '12', '42', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('106', '2012-12-23 10:03:37', '1', '3', '27', '101110101', '3', ''); INSERT INTO `django_admin_log` VALUES ('107', '2012-12-23 10:03:37', '1', '3', '33', '101110103', '3', ''); INSERT INTO `django_admin_log` VALUES ('108', '2012-12-23 10:03:37', '1', '3', '28', '101110112', '3', ''); INSERT INTO `django_admin_log` VALUES ('109', '2012-12-23 10:03:37', '1', '3', '29', '101110312', '3', ''); INSERT INTO `django_admin_log` VALUES ('110', '2012-12-23 10:03:37', '1', '3', '31', '101110313', '3', ''); INSERT INTO `django_admin_log` VALUES ('111', '2012-12-23 10:03:37', '1', '3', '30', '101110314', '3', ''); INSERT INTO `django_admin_log` VALUES ('112', '2012-12-23 10:03:37', '1', '3', '32', '101110315', '3', ''); INSERT INTO `django_admin_log` VALUES ('113', '2012-12-23 11:09:12', '1', '3', '41', 'aabbcc', '1', ''); INSERT INTO `django_admin_log` VALUES ('114', '2012-12-23 11:09:51', '1', '3', '41', 'aabbc', '2', '已修改 username 。'); INSERT INTO `django_admin_log` VALUES ('115', '2012-12-23 11:10:22', '1', '3', '41', 'aabbc', '3', ''); INSERT INTO `django_admin_log` VALUES ('116', '2012-12-25 08:26:36', '1', '3', '34', '101110101', '3', ''); INSERT INTO `django_admin_log` VALUES ('117', '2012-12-25 08:26:37', '1', '3', '35', '101110112', '3', ''); INSERT INTO `django_admin_log` VALUES ('118', '2012-12-25 08:26:37', '1', '3', '40', '101110312', '3', ''); INSERT INTO `django_admin_log` VALUES ('119', '2012-12-25 08:26:37', '1', '3', '36', '101110313', '3', ''); INSERT INTO `django_admin_log` VALUES ('120', '2012-12-25 08:26:37', '1', '3', '37', '101110314', '3', ''); INSERT INTO `django_admin_log` VALUES ('121', '2012-12-25 08:26:37', '1', '3', '38', '101110315', '3', ''); INSERT INTO `django_admin_log` VALUES ('122', '2012-12-25 08:26:52', '1', '16', '14', '省级以上竞赛', '3', ''); INSERT INTO `django_admin_log` VALUES ('123', '2012-12-25 08:26:52', '1', '16', '13', '学生会', '3', ''); INSERT INTO `django_admin_log` VALUES ('124', '2012-12-25 08:27:06', '1', '12', '43', '2012年秋', '3', ''); INSERT INTO `django_admin_log` VALUES ('125', '2012-12-25 08:28:10', '1', '15', '13', '卫生', '3', ''); INSERT INTO `django_admin_log` VALUES ('126', '2012-12-25 08:28:10', '1', '15', '12', '运动会', '3', ''); INSERT INTO `django_admin_log` VALUES ('127', '2012-12-25 08:28:20', '1', '10', '21', '1011103', '3', ''); INSERT INTO `django_admin_log` VALUES ('128', '2012-12-25 08:28:20', '1', '10', '20', '1011101', '3', ''); INSERT INTO `django_admin_log` VALUES ('129', '2012-12-25 08:28:33', '1', '17', '22', '2012年秋', '3', ''); -- ---------------------------- -- Table structure for `django_content_type` -- ---------------------------- DROP TABLE IF EXISTS `django_content_type`; CREATE TABLE `django_content_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `app_label` varchar(100) NOT NULL, `model` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `app_label` (`app_label`,`model`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of django_content_type -- ---------------------------- INSERT INTO `django_content_type` VALUES ('1', 'permission', 'auth', 'permission'); INSERT INTO `django_content_type` VALUES ('2', 'group', 'auth', 'group'); INSERT INTO `django_content_type` VALUES ('3', 'user', 'auth', 'user'); INSERT INTO `django_content_type` VALUES ('4', 'message', 'auth', 'message'); INSERT INTO `django_content_type` VALUES ('5', 'content type', 'contenttypes', 'contenttype'); INSERT INTO `django_content_type` VALUES ('6', 'session', 'sessions', 'session'); INSERT INTO `django_content_type` VALUES ('7', 'site', 'sites', 'site'); INSERT INTO `django_content_type` VALUES ('8', 'captcha store', 'captcha', 'captchastore'); INSERT INTO `django_content_type` VALUES ('9', 'migration history', 'south', 'migrationhistory'); INSERT INTO `django_content_type` VALUES ('10', 'class', 'engine', 'class'); INSERT INTO `django_content_type` VALUES ('11', 'student', 'engine', 'student'); INSERT INTO `django_content_type` VALUES ('12', 'assessment', 'engine', 'assessment'); INSERT INTO `django_content_type` VALUES ('14', 'grade', 'engine', 'grade'); INSERT INTO `django_content_type` VALUES ('15', 'behavior', 'engine', 'behavior'); INSERT INTO `django_content_type` VALUES ('16', 'development', 'engine', 'development'); INSERT INTO `django_content_type` VALUES ('17', 'comperformance', 'engine', 'comperformance'); INSERT INTO `django_content_type` VALUES ('18', 'comperformance development score', 'engine', 'comperformancedevelopmentscore'); INSERT INTO `django_content_type` VALUES ('19', 'comperformance behavior score', 'engine', 'comperformancebehaviorscore'); INSERT INTO `django_content_type` VALUES ('20', 'comperformance physical score', 'engine', 'comperformancephysicalscore'); INSERT INTO `django_content_type` VALUES ('21', 'assessment record', 'engine', 'assessmentrecord'); INSERT INTO `django_content_type` VALUES ('22', 'log entry', 'admin', 'logentry'); INSERT INTO `django_content_type` VALUES ('23', 'assessment row', 'engine', 'assessmentrow'); INSERT INTO `django_content_type` VALUES ('24', 'comperformance score', 'engine', 'comperformancescore'); -- ---------------------------- -- Table structure for `django_session` -- ---------------------------- DROP TABLE IF EXISTS `django_session`; CREATE TABLE `django_session` ( `session_key` varchar(40) NOT NULL, `session_data` longtext NOT NULL, `expire_date` datetime NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_c25c2c28` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of django_session -- ---------------------------- INSERT INTO `django_session` VALUES ('008bf666be8a0fd730534848b6580c72', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-01-06 09:44:18'); INSERT INTO `django_session` VALUES ('0b3aaeb7ef95c35ad9fab2764b710510', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-01-06 08:52:16'); INSERT INTO `django_session` VALUES ('1f3fadc96f1dd829588a45c500ebbd17', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-01-04 07:34:21'); INSERT INTO `django_session` VALUES ('25cf8ce32028cfd20d4277c07b7ae354', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2012-12-31 23:17:42'); INSERT INTO `django_session` VALUES ('28bb36b7177e872d3dd74a4678f096e5', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-01-06 00:15:05'); INSERT INTO `django_session` VALUES ('2a9f7aed2c9b91308c9047dfa4b91ffc', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2012-12-24 19:11:27'); INSERT INTO `django_session` VALUES ('557af2dbc8055cace195319bf63160a6', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2012-12-31 14:32:46'); INSERT INTO `django_session` VALUES ('67452165b7d8efa23e52dcfb1a146993', 'NWRiOTI2OTQ3ODIxYTU3OGZhMGRiNmFlYWM0MmYzNWIxZjI5OWU5MzqAAn1xAShVDV9hdXRoX3Vz\nZXJfaWSKAQFVEl9hdXRoX3VzZXJfYmFja2VuZFUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxAnUu\n', '2012-12-24 21:11:51'); INSERT INTO `django_session` VALUES ('8e36e3f3b459f0aa25ab60af96614cae', 'ZGM2MzFjZDFiZGM2MWFkMjBmZGY1NjAyNmE2ZGZiZGZhNDIyMmYzODqAAn1xAS4=\n', '2013-01-06 11:16:01'); INSERT INTO `django_session` VALUES ('9eb769b87dfdae0baf26fd75fb41c15a', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2012-12-24 21:41:04'); INSERT INTO `django_session` VALUES ('aadd8f0719cb1d2006dfa8e7ca9adafb', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-01-18 14:37:27'); INSERT INTO `django_session` VALUES ('b30a94cfd066a3efe05eb674c017b9c6', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2012-12-25 00:10:48'); INSERT INTO `django_session` VALUES ('b40950becdf9a0e127a7d71e70f6bf73', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2012-12-24 18:33:22'); INSERT INTO `django_session` VALUES ('bd85cffc3d8bc15bc18ff804668bfe1c', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2012-12-24 11:17:48'); INSERT INTO `django_session` VALUES ('bec32181a58f03b7899172ff4dd66171', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-01-23 10:25:34'); INSERT INTO `django_session` VALUES ('ccab94e9743df95805ac6eeed4c852e6', 'NWRiOTI2OTQ3ODIxYTU3OGZhMGRiNmFlYWM0MmYzNWIxZjI5OWU5MzqAAn1xAShVDV9hdXRoX3Vz\nZXJfaWSKAQFVEl9hdXRoX3VzZXJfYmFja2VuZFUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxAnUu\n', '2013-01-01 23:40:08'); INSERT INTO `django_session` VALUES ('d3d9151f853cb053a11c54cda18a4963', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-02-02 09:41:42'); INSERT INTO `django_session` VALUES ('d78f26e38024658ca796d1952b36d0a7', 'ZGM2MzFjZDFiZGM2MWFkMjBmZGY1NjAyNmE2ZGZiZGZhNDIyMmYzODqAAn1xAS4=\n', '2012-12-26 06:54:15'); INSERT INTO `django_session` VALUES ('f0f54559c4f4af1a15a6ca4ecbd16c0c', 'YWMxOTAyMTE4MTE3NTYzMWFhYmZlNTNiM2M1YTdhODNkNmFhOWRkMjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2013-01-06 09:16:57'); INSERT INTO `django_session` VALUES ('f7e93ce64a321579329ec016581ea4c7', 'ZGM2MzFjZDFiZGM2MWFkMjBmZGY1NjAyNmE2ZGZiZGZhNDIyMmYzODqAAn1xAS4=\n', '2013-01-06 08:34:33'); -- ---------------------------- -- Table structure for `django_site` -- ---------------------------- DROP TABLE IF EXISTS `django_site`; CREATE TABLE `django_site` ( `id` int(11) NOT NULL AUTO_INCREMENT, `domain` varchar(100) NOT NULL, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of django_site -- ---------------------------- INSERT INTO `django_site` VALUES ('1', 'example.com', 'example.com'); -- ---------------------------- -- Table structure for `grade` -- ---------------------------- DROP TABLE IF EXISTS `grade`; CREATE TABLE `grade` ( `id` int(11) NOT NULL AUTO_INCREMENT, `term` varchar(16) NOT NULL, `student_id` int(11) NOT NULL, `score` double NOT NULL, PRIMARY KEY (`id`), KEY `grade_42ff452e` (`student_id`), CONSTRAINT `student_id_refs_id_696aeb74468fbd7` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of grade -- ---------------------------- INSERT INTO `grade` VALUES ('87', '2012年秋', '41', '72.38'); INSERT INTO `grade` VALUES ('88', '2012年秋', '42', '82.64'); INSERT INTO `grade` VALUES ('89', '2012年秋', '37', '84.34'); INSERT INTO `grade` VALUES ('90', '2012年秋', '38', '88.25'); INSERT INTO `grade` VALUES ('91', '2012年秋', '39', '81.45'); INSERT INTO `grade` VALUES ('92', '2012年秋', '40', '84.12'); INSERT INTO `grade` VALUES ('93', '2012年春', '41', '82.38'); INSERT INTO `grade` VALUES ('94', '2012年春', '42', '72.64'); INSERT INTO `grade` VALUES ('95', '2012年春', '37', '74.34'); INSERT INTO `grade` VALUES ('96', '2012年春', '38', '68.25'); INSERT INTO `grade` VALUES ('97', '2012年春', '39', '71.45'); INSERT INTO `grade` VALUES ('98', '2012年春', '40', '64.12'); INSERT INTO `grade` VALUES ('99', '2011年春', '41', '67.33'); INSERT INTO `grade` VALUES ('100', '2011年春', '42', '72.64'); INSERT INTO `grade` VALUES ('101', '2011年春', '37', '81.38'); INSERT INTO `grade` VALUES ('102', '2011年春', '38', '77.89'); INSERT INTO `grade` VALUES ('103', '2011年春', '39', '71.45'); INSERT INTO `grade` VALUES ('104', '2011年春', '40', '84.12'); INSERT INTO `grade` VALUES ('105', '2011年秋', '41', '88.12'); INSERT INTO `grade` VALUES ('106', '2011年秋', '42', '67.35'); INSERT INTO `grade` VALUES ('107', '2011年秋', '37', '65.58'); INSERT INTO `grade` VALUES ('108', '2011年秋', '38', '76.89'); INSERT INTO `grade` VALUES ('109', '2011年秋', '39', '66.82'); INSERT INTO `grade` VALUES ('110', '2011年秋', '40', '74.12'); -- ---------------------------- -- Table structure for `south_migrationhistory` -- ---------------------------- DROP TABLE IF EXISTS `south_migrationhistory`; CREATE TABLE `south_migrationhistory` ( `id` int(11) NOT NULL AUTO_INCREMENT, `app_name` varchar(255) NOT NULL, `migration` varchar(255) NOT NULL, `applied` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of south_migrationhistory -- ---------------------------- INSERT INTO `south_migrationhistory` VALUES ('12', 'engine', '0001_initial', '2012-12-20 06:09:38'); INSERT INTO `south_migrationhistory` VALUES ('13', 'captcha', '0001_initial', '2012-12-20 06:10:09'); INSERT INTO `south_migrationhistory` VALUES ('14', 'engine', '0002_auto__del_field_comperformancescore_assessmentscore', '2012-12-20 06:11:29'); INSERT INTO `south_migrationhistory` VALUES ('15', 'engine', '0003_auto__add_field_comperformancescore_assessmentscore', '2012-12-20 06:11:48'); INSERT INTO `south_migrationhistory` VALUES ('16', 'engine', '0004_auto__chg_field_comperformancescore_score__chg_field_comperformancesco', '2012-12-20 06:14:29'); INSERT INTO `south_migrationhistory` VALUES ('17', 'engine', '0005_auto__chg_field_comperformancedevelopmentscore_score__chg_field_comper', '2012-12-22 08:50:45'); -- ---------------------------- -- Table structure for `student` -- ---------------------------- DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `realname` varchar(16) NOT NULL, `theclass_id` int(11) NOT NULL, `sex` varchar(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), KEY `student_c48b39e9` (`theclass_id`), CONSTRAINT `theclass_id_refs_id_660c1d0a704564aa` FOREIGN KEY (`theclass_id`) REFERENCES `class` (`id`), CONSTRAINT `user_id_refs_id_32dd460521947d82` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of student -- ---------------------------- INSERT INTO `student` VALUES ('37', '41', '郭猛', '22', '0'); INSERT INTO `student` VALUES ('38', '42', '闫超', '22', '0'); INSERT INTO `student` VALUES ('39', '43', '陈彦克', '22', '0'); INSERT INTO `student` VALUES ('40', '44', '张琦', '22', '0'); INSERT INTO `student` VALUES ('41', '45', '朱明珠', '23', '1'); INSERT INTO `student` VALUES ('42', '46', '王凯', '23', '0');