-- MySQL dump 10.13 Distrib 5.5.38, for Win32 (x86)---- Host: localhost Database: taskcms-- -------------------------------------------------------- Server version 5.5.38/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `bs_auth_group`--DROP TABLE IF EXISTS `bs_auth_group`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_auth_group` (`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,`title` char(100) NOT NULL DEFAULT '',`status` tinyint(1) NOT NULL DEFAULT '1',`rules` text NOT NULL,`dateline` int(10) unsigned NOT NULL,`modified` int(10) unsigned NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_auth_group`--LOCK TABLES `bs_auth_group` WRITE;/*!40000 ALTER TABLE `bs_auth_group` DISABLE KEYS */;INSERT INTO `bs_auth_group` VALUES (1,'系统管理员',1,'1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,39,40,41,42,43,44,45,21,22,23,24,25,27,28,29,30,31,33,34,35,36,37',1424856755,1425439576),(2,'项目经理',1,'6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,39,40,41,42,43,45',1424846589,1425439569),(3,'普通会员',1,'6,7,13,14,15,16,17,18,19,40,41,42,43,44',1424846649,1425439545);/*!40000 ALTER TABLE `bs_auth_group` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_auth_group_access`--DROP TABLE IF EXISTS `bs_auth_group_access`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_auth_group_access` (`uid` mediumint(8) unsigned NOT NULL,`group_id` mediumint(8) unsigned NOT NULL,UNIQUE KEY `uid_group_id` (`uid`,`group_id`),KEY `uid` (`uid`),KEY `group_id` (`group_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_auth_group_access`--LOCK TABLES `bs_auth_group_access` WRITE;/*!40000 ALTER TABLE `bs_auth_group_access` DISABLE KEYS */;INSERT INTO `bs_auth_group_access` VALUES (3,3),(4,2),(4,3);/*!40000 ALTER TABLE `bs_auth_group_access` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_auth_rule`--DROP TABLE IF EXISTS `bs_auth_rule`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_auth_rule` (`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,`tpid` int(10) unsigned NOT NULL,`name` char(80) NOT NULL DEFAULT '',`title` char(20) NOT NULL DEFAULT '',`type` tinyint(1) NOT NULL DEFAULT '1',`status` tinyint(1) NOT NULL DEFAULT '1',`condition` char(100) NOT NULL DEFAULT '',`dateline` int(10) unsigned NOT NULL,`modified` int(10) unsigned NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `name` (`name`)) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_auth_rule`--LOCK TABLES `bs_auth_rule` WRITE;/*!40000 ALTER TABLE `bs_auth_rule` DISABLE KEYS */;INSERT INTO `bs_auth_rule` VALUES (1,1,'Members/index','查看会员列表',1,1,'',1424841858,1424841858),(2,1,'Members/add','添加会员(页面显示)',1,1,'',1424841989,1424841989),(3,1,'Members/create','添加会员(写操作)',1,1,'',1424842037,1424842037),(4,1,'Members/edit','编辑会员(查看)',1,1,'',1424842089,1424842089),(5,1,'Members/update','编辑会员(写操作)',1,1,'',1424842120,1424842120),(6,2,'Project/index','查看项目列表',1,1,'',1424842823,1424842823),(7,2,'Project/projects_info','查看项目详情',1,1,'',1424842862,1424842862),(8,2,'Project/process','添加项目进程(显示)',1,1,'',1424842897,1424842992),(9,2,'Project/addProcess','添加项目进程(写操作)',1,1,'',1424842961,1424842961),(10,2,'Project/create','添加项目(写操作)',1,1,'',1424843112,1424843112),(11,2,'Project/update','编辑项目(写操作)',1,1,'',1424843168,1424843168),(12,2,'Project/addProMember','添加项目成员',1,1,'',1424843266,1424843280),(13,2,'Task/index','查看任务列表',1,1,'',1424843413,1424843413),(14,2,'Task/taskList','查看任务列表(某项目下)',1,1,'',1424843747,1424843747),(15,2,'Task/add','添加任务(显示)',1,1,'',1424843797,1424843797),(16,2,'Task/create','添加任务(写操作)',1,1,'',1424843830,1424843830),(17,2,'Task/edit','编辑任务(显示)',1,1,'',1424843880,1424843880),(18,2,'Task/update','编辑任务(写操作)',1,1,'',1424843907,1424843907),(19,2,'Task/check','登记任务',1,1,'',1424843980,1424843980),(20,2,'Task/deal','审核任务',1,1,'',1424844026,1424844026),(21,3,'RuleType/index','查看规则类型列表',1,1,'',1424844503,1424844503),(22,3,'RuleType/add','添加规则类型(显示)',1,1,'',1424844547,1424844547),(23,3,'RuleType/create','添加规则类型(写操作)',1,1,'',1424844578,1424844578),(24,3,'RuleType/edit','编辑规则类型(查看)',1,1,'',1424844697,1424844747),(25,3,'RuleType/update','编辑规则类型(写操作)',1,1,'',1424844732,1424844732),(26,3,'RuleType/delete','删除规则类型',1,1,'',1424844824,1424844824),(27,4,'Node/index','查看节点列表',1,1,'',1424844976,1424844976),(28,4,'Node/add','添加节点(显示)',1,1,'',1424845031,1424845031),(29,4,'Node/create','添加节点(写操作)',1,1,'',1424845056,1424845056),(30,4,'Node/edit','编辑节点(显示)',1,1,'',1424845079,1424845079),(31,4,'Node/update','编辑节点(写操作)',1,1,'',1424845102,1424845102),(32,4,'Node/delete','删除节点',1,1,'',1424845124,1424845124),(33,5,'Role/index','查看用户组列表',1,1,'',1424845330,1424845330),(34,5,'Role/add','添加用户组(显示)',1,1,'',1424845357,1424845357),(35,5,'Role/create','添加用户组(写操作)',1,1,'',1424845390,1424845390),(36,5,'Role/edit','编辑用户组(显示)',1,1,'',1424845475,1424845475),(37,5,'Role/update','编辑用户组(写操作)',1,1,'',1424845503,1424845503),(38,5,'Role/delete','删除用户组',1,1,'',1424845533,1424845533),(39,2,'Task/shoutDown','关闭任务',1,1,'',1425009241,1425009241),(40,2,'Project/defect','添加项目缺陷(显示)',1,1,'',1425437179,1425437179),(41,2,'Project/defectEdit','查看、审核项目缺陷(显示)',1,1,'',1425437253,1425437386),(42,2,'Project/addDefect','添加项目缺陷(写操作)',1,1,'',1425437315,1425437315),(43,2,'Project/defectList','查看项目缺陷列表(显示)',1,1,'',1425437365,1425437365),(44,2,'Project/checkDefect','登记缺陷',1,1,'',1425439473,1425439473),(45,2,'Project/reviewDefect','审核缺陷',1,1,'',1425439493,1425439501);/*!40000 ALTER TABLE `bs_auth_rule` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_auth_type`--DROP TABLE IF EXISTS `bs_auth_type`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_auth_type` (`id` mediumint(8) NOT NULL AUTO_INCREMENT,`name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',`disc` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',`status` tinyint(4) DEFAULT '1' COMMENT '1==可用,2==不可用',`dateline` int(10) DEFAULT NULL COMMENT '添加时间',`modified` int(10) DEFAULT NULL COMMENT '更新时间',PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='规则类型表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_auth_type`--LOCK TABLES `bs_auth_type` WRITE;/*!40000 ALTER TABLE `bs_auth_type` DISABLE KEYS */;INSERT INTO `bs_auth_type` VALUES (1,'members','会员操作相关',1,1424841796,1424841796),(2,'projects','项目操作相关',1,1424842723,1424842723),(3,'authtype','权限操作相关(规则)',1,1424844356,1424844446),(4,'node','权限操作相关(节点)',1,1424844933,1424844933),(5,'role','权限操作相关(用户组)',1,1424845280,1424845280);/*!40000 ALTER TABLE `bs_auth_type` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_members`--DROP TABLE IF EXISTS `bs_members`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_members` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`username` varchar(45) NOT NULL DEFAULT '' COMMENT '用户名',`pwd` varchar(45) NOT NULL DEFAULT '' COMMENT '密码',`identity` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '会员身份 1==普通会员,2==项目管理员,3==管理员',`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '会员状态 1==可用,2==禁用',`name` varchar(20) NOT NULL DEFAULT '' COMMENT '会员姓名',`sex` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '性别 1 == 保密 ,2==男,3==女',`mobile` varchar(15) NOT NULL DEFAULT '' COMMENT '手机号',`birthday` varchar(15) NOT NULL DEFAULT '' COMMENT '生日',`dateline` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',`modified` int(10) NOT NULL DEFAULT '0' COMMENT '更改时间',PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='会员表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_members`--LOCK TABLES `bs_members` WRITE;/*!40000 ALTER TABLE `bs_members` DISABLE KEYS */;INSERT INTO `bs_members` VALUES (1,'admin','effd59bd1e0098c239946d56bedd8660',1,1,'刘富强',1,'15954913451','2015-02-25',0,1424917407),(2,'jiacunqiang','effd59bd1e0098c239946d56bedd8660',1,1,'贾存青',1,'15954913451','2015-02-25',0,1424917382),(3,'yangwenfeng','12be11286202ec0e3b2b7011b179bb99',1,1,'杨文峰',1,'15954913451','2015-02-26',0,1424912772),(4,'test1','778af5f780e5edf1cbfc9f9e7b656935',1,1,'测试',3,'15954913451','2015-02-10',1424831682,1426063635);/*!40000 ALTER TABLE `bs_members` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_projects`--DROP TABLE IF EXISTS `bs_projects`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_projects` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`code` varchar(45) NOT NULL DEFAULT '' COMMENT '项目编号应唯一',`create_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建者id,即项目管理员id',`name` varchar(50) NOT NULL DEFAULT '' COMMENT '项目名称',`begin_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始日期',`end_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束日期',`gradation` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '当前阶段\n1 == 立项\n2 == 需求分析\n3 == 设计\n4 == 开发\n5 = 测试\n6 == 初验\n7 == 终验\n8 == 完成\n9 == 维护项目',`customer_name` varchar(50) NOT NULL DEFAULT '' COMMENT '客户名称',`contract_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '合同额',`cost` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '计划成本',`reward` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '计划奖励',`type` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '项目类型\n1==企业站\n2==商城',`reward_ratio` decimal(2,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '项目经理奖励比例',`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',`modified` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更改时间',PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='项目表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_projects`--LOCK TABLES `bs_projects` WRITE;/*!40000 ALTER TABLE `bs_projects` DISABLE KEYS */;INSERT INTO `bs_projects` VALUES (1,'20150203020304179740',4,'测试项目',1422892800,1429286399,1,'张三',100000.00,100000.00,10000.00,2,0.99,1422956328,1424940076),(2,'20150204020405168330',1,'轮胎博士',1422979200,1431791999,2,'彰武',150000.00,80000.00,30000.00,2,0.99,1423034259,1423549471);/*!40000 ALTER TABLE `bs_projects` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_projects_defects`--DROP TABLE IF EXISTS `bs_projects_defects`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_projects_defects` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`projects_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '项目id',`create_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人id',`members_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行人id',`check_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核人id',`defects_num` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '缺陷数量',`defects_file` varchar(255) NOT NULL DEFAULT '' COMMENT '缺陷文档地址',`defects_content` text NOT NULL COMMENT '缺陷说明',`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '缺陷状态 1==待处理,2==执行中,3==提交(待审核),4== 关闭(审核成功)',`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',`modified` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',`handle_content` text NOT NULL COMMENT '处理说明',`handle_content1` text NOT NULL,`handle_content2` text NOT NULL,`handle_content3` text NOT NULL,`handle_content4` text NOT NULL,`check_content` text NOT NULL COMMENT '审核说明',`check_content1` text NOT NULL,`check_content2` text NOT NULL,`check_content3` text NOT NULL,`check_content4` text NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='项目缺陷关联表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_projects_defects`--LOCK TABLES `bs_projects_defects` WRITE;/*!40000 ALTER TABLE `bs_projects_defects` DISABLE KEYS */;INSERT INTO `bs_projects_defects` VALUES (1,1,1,4,0,5,'/Public/Uploads/files/20150227/54f01837e25a1.docx','<p>\r\n 测试缺陷\r\n</p>\r\n<p>\r\n 阿尔法色粉\r\n</p>\r\n<p>\r\n 啊色粉\r\n</p>\r\n<p>\r\n &nbsp;aef aff\r\n</p>\r\n<p>\r\n <br />\r\n</p>\r\n<p>\r\n 发阿尔法\r\n</p>\r\n<p>\r\n <br />\r\n</p>\r\n<p>\r\n &nbsp;阿尔法俄\r\n</p>',1,1425020983,1425441210,'测试一下色粉色发','处理2','','','','处理成功<br />','处理2','','','');/*!40000 ALTER TABLE `bs_projects_defects` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_projects_members`--DROP TABLE IF EXISTS `bs_projects_members`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_projects_members` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`projects_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '项目id',`members_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '成员id',`members_role` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '1==美工设计,2==页面切图,3==程序,4==项目经理',PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='项目会员关系表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_projects_members`--LOCK TABLES `bs_projects_members` WRITE;/*!40000 ALTER TABLE `bs_projects_members` DISABLE KEYS */;INSERT INTO `bs_projects_members` VALUES (30,1,4,3),(29,1,3,4),(28,1,2,3),(26,2,4,4),(25,2,3,1),(24,2,1,3),(23,2,2,2),(27,1,1,3);/*!40000 ALTER TABLE `bs_projects_members` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_projects_process`--DROP TABLE IF EXISTS `bs_projects_process`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_projects_process` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`projects_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '项目id',`create_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建者(项目经理)id',`check_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核人id',`finish_ratio` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '项目完成百分比',`content` text NOT NULL COMMENT '进程说明',`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',`modified` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更改时间',PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='项目进程关联表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_projects_process`--LOCK TABLES `bs_projects_process` WRITE;/*!40000 ALTER TABLE `bs_projects_process` DISABLE KEYS */;INSERT INTO `bs_projects_process` VALUES (1,1,1,0,15,'测试进度',1423640849,1423640849),(2,1,1,0,20,'的人格的若干',1423647105,1423647105),(3,2,1,0,20,'123',1424911992,1424911992);/*!40000 ALTER TABLE `bs_projects_process` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_projects_task`--DROP TABLE IF EXISTS `bs_projects_task`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_projects_task` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`projects_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '项目id',`fid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父类任务id',`create_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建者id',`members_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行人id',`before_tid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '前置任务id',`check_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核人id',`task_name` varchar(50) NOT NULL DEFAULT '' COMMENT '任务名称',`description` text COMMENT '任务描述',`task_code` varchar(45) NOT NULL DEFAULT '' COMMENT '任务编号',`task_hours` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '要求工时',`handle_hours` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '任务执行工时',`begin_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始日期',`end_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束日期',`handle_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '实际开始执行时间',`handle_end_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '时间执行任务结束时间',`handle_status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '执行状态\n1==新建任务\n2==进行中\n3==已解决',`handle_ratio` decimal(3,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '执行进度百分比',`check_status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '审核状态\n1==未达审核条件\n2==审核通过\n3==审核失败',`check_content` text NOT NULL COMMENT '审核说明',`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '任务状态\n1 == 新建任务\n2 == 执行中\n3= 提交\n4 == 审核中\n5 == 完成',`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '任务创建时间',`modified` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '任务更新时间',`priority` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '任务优先级\n1==普通\n2=低\n3==高\n4==紧急\n5==立刻',`check_content1` text NOT NULL,`check_content2` text NOT NULL,`check_content3` text NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='项目任务关联表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_projects_task`--LOCK TABLES `bs_projects_task` WRITE;/*!40000 ALTER TABLE `bs_projects_task` DISABLE KEYS */;INSERT INTO `bs_projects_task` VALUES (1,1,0,0,1,0,1,'任务一',NULL,'20150209939568',8.00,8.00,1423411200,1424447999,1423497600,1423756800,3,1.00,3,'页面错误',5,1423446880,1425002485,3,'','',''),(2,2,0,0,1,0,0,'测试任务',NULL,'20150226760813',25.00,0.00,1424880000,1425052799,0,0,1,0.00,1,'',1,1424911951,1424911951,1,'','',''),(3,2,2,3,1,0,0,'子任务',NULL,'20150226312460',12.00,0.00,1424880000,1425052799,0,0,1,0.00,1,'',1,1424912505,1424912505,1,'','',''),(4,1,0,4,4,0,0,'任务二','','20150226557128',10.00,4.00,1426089600,1426262399,1426126347,0,1,0.20,1,'',2,1424914456,1426122438,1,'','',''),(5,1,0,4,1,0,0,'身份色粉色发','aawawdawdwadaw','20150305790826',20.00,7.00,1425484800,1425657599,0,0,1,0.90,1,'',3,1425543296,1425543296,1,'','','');/*!40000 ALTER TABLE `bs_projects_task` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `bs_task_records`--DROP TABLE IF EXISTS `bs_task_records`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `bs_task_records` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`tid` int(10) unsigned NOT NULL COMMENT '任务id',`mid` int(10) unsigned NOT NULL COMMENT '会员id',`description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',`content` text NOT NULL COMMENT '具体说明',`dateline` int(10) unsigned NOT NULL,`type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1 更新消息,2登记记录',PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='任务记录表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `bs_task_records`--LOCK TABLES `bs_task_records` WRITE;/*!40000 ALTER TABLE `bs_task_records` DISABLE KEYS */;INSERT INTO `bs_task_records` VALUES (1,1,1,'刘富强 将任务结束日期由 1423497599 变更为 1424447999','',1423536971,1),(2,1,1,'刘富强 将任务状态变更为 执行中','',1423540158,1),(3,1,1,'','adawdawdawdawdawadaw',1423540399,2),(4,1,1,'刘富强 将任务进度由 0% 变更为 15%','',1423540399,1),(5,1,1,'刘富强 增加任务工时 2','',1423540462,1),(6,1,1,'刘富强 将任务进度由 15% 变更为 0%','',1423540462,1),(7,1,1,'刘富强 增加任务工时 3','',1423547179,1),(8,1,1,'刘富强 将任务进度由 0% 变更为 20%','',1423547179,1),(9,1,1,'刘富强 增加任务工时 3','',1423549127,1),(10,1,1,'刘富强 将任务进度由 20% 变更为 100%','',1423549127,1),(11,1,1,'刘富强 将任务状态变更为 提交','',1423549127,1),(12,1,1,'','问题已更改',1423552421,2),(13,1,1,'刘富强 将任务状态变更为 提交','',1423552421,1),(14,1,1,'刘富强 将任务状态修改为 关闭 ','',1425002485,1),(15,5,1,'刘富强 任务进度变更为 10%','',1425889121,1),(16,5,1,'刘富强 增加执行工时 22','',1425889121,1),(17,5,1,'刘富强 增加执行工时 1','',1425889191,1),(18,5,1,'刘富强 将任务状态变更为 提交','',1425889327,1),(19,5,1,'刘富强 任务进度变更为 60%','',1425889327,1),(20,5,1,'刘富强 增加执行工时 2','',1425889327,1),(21,5,1,'刘富强 任务进度变更为 70%','',1425889597,1),(22,5,1,'刘富强 增加执行工时 1','',1425889597,1),(23,5,1,'刘富强 任务进度变更为 80%','',1425889681,1),(24,5,1,'刘富强 增加执行工时 1','',1425889681,1),(25,5,1,'刘富强 任务进度变更为 90%','',1425889821,1),(26,5,1,'刘富强 增加执行工时 2','',1425889821,1),(27,4,4,'测试 将任务开始日期由 2015年02月26日 变更为 2015年02月26日','',1426122438,1),(28,4,4,'测试 将任务结束日期由 2015年02月26日 变更为 2015年02月26日','',1426122438,1),(29,4,4,'测试 将任务状态变更为 新建任务','',1426122438,1),(30,4,4,'测试 将任务状态变更为 执行中','',1426126114,1),(31,4,4,'测试 任务进度变更为 10%','',1426126114,1),(32,4,4,'测试 增加执行工时 1','',1426126114,1),(33,4,4,'测试 任务进度变更为 20%','',1426126197,1),(34,4,4,'测试 增加执行工时 2','',1426126197,1),(35,4,4,'测试 增加执行工时 1','',1426126347,1);/*!40000 ALTER TABLE `bs_task_records` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2015年03月12日 11:43:13
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。