56,678
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `projectcounts` (
`projectcountsid` int(11) NOT NULL AUTO_INCREMENT,
`projectid` int(11) NOT NULL,
`projectusersid` int(11) DEFAULT NULL,
`count1` double(8,1) DEFAULT NULL,
`count2` double(8,1) DEFAULT NULL,
`count3` double(8,1) DEFAULT NULL,
`count4` double(8,1) DEFAULT NULL,
`count8` varchar(4) DEFAULT NULL,
`countdate` datetime DEFAULT NULL,
`counttotal` double(8,2) DEFAULT NULL,
PRIMARY KEY (`projectcountsid`)
) ENGINE=InnoDB AUTO_INCREMENT=733 DEFAULT CHARSET=gb2312;
INSERT INTO `projectcounts` VALUES ('725', '1', '52', '0.5', '0.0', '0.0', '0.0', '1', '2014-06-11 00:00:00', '0.50');
INSERT INTO `projectcounts` VALUES ('726', '1', '50', '1.0', '0.0', '0.0', '0.0', '1', '2014-06-11 00:00:00', '1.00');
INSERT INTO `projectcounts` VALUES ('727', '1', '51', '1.0', '0.0', '0.0', '0.0', '1', '2014-06-11 00:00:00', '1.00');
INSERT INTO `projectcounts` VALUES ('728', '1', '53', '0.5', '0.0', '0.0', '0.0', '1', '2014-06-11 00:00:00', '0.50');
INSERT INTO `projectcounts` VALUES ('729', '2', '53', '0.5', '0.0', '0.0', '0.0', '1', '2014-06-11 00:00:00', '0.50');
INSERT INTO `projectcounts` VALUES ('730', '2', '52', '0.5', '0.0', '0.0', '0.0', '1', '2014-06-11 00:00:00', '0.50');
INSERT INTO `projectcounts` VALUES ('731', '2', '51', '35.0', '5.0', '25.0', '35.0', '1', '2014-06-11 00:00:00', '100.00');
INSERT INTO `projectcounts` VALUES ('732', '2', '50', '35.0', '5.0', '25.0', '35.0', '1', '2014-06-11 00:00:00', '100.00');
CREATE TABLE `projects` (
`projectid` int(11) NOT NULL AUTO_INCREMENT,
`projectcode` varchar(50) DEFAULT NULL,
`projectname` varchar(300) DEFAULT NULL,
`projectdate` datetime DEFAULT NULL,
`projectlvlid` int(11) DEFAULT NULL,
PRIMARY KEY (`projectid`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=gb2312;
INSERT INTO `projects` VALUES ('1', 'kj201201', 'xxxx开发', '2014-06-11 00:00:00', '1');
INSERT INTO `projects` VALUES ('2', 'kj201202', 'xxxxx技术研究', '2014-06-11 00:00:00', '1');
CREATE TABLE `users` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`xiongkahao` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`pass` varchar(100) DEFAULT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=gb2312;
INSERT INTO `users` VALUES ('50', 'a', '张三', 'a');
INSERT INTO `users` VALUES ('51', 'b', '李四', 'b');
INSERT INTO `users` VALUES ('52', 'c', '王麻子', 'c');
INSERT INTO `users` VALUES ('53', 'd', '李二', 'd');