プロジェクト

全般

プロフィール

リビジョン 487

堀内 が4年以上前に追加

製品版対応

差分を表示:

InitData.SQL
1 

  		




  1
  2
  
    
--


  		




  2
  3
  
    
-- Table structure for table `budgetsumcode`


  		




  3
  4
  
    
--


  		




  ......




  56
  57
  
    
UNLOCK TABLES;


  		




  57
  58
  
    

  		




  58
  59
  
    
--


  		




  
  60
  
    
-- Table structure for table `chgchargedep`


  		




  
  61
  
    
--


  		




  
  62
  
    

  		




  
  63
  
    
DROP TABLE IF EXISTS `chgchargedep`;


  		




  
  64
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  65
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  66
  
    
CREATE TABLE `chgchargedep` (


  		




  
  67
  
    
  `PersonCode` decimal(8,0) NOT NULL COMMENT '?S????R?[?h',


  		




  
  68
  
    
  `StartDate` date NOT NULL COMMENT '?J?n?N????',


  		




  
  69
  
    
  `CompDate` date NOT NULL COMMENT '?I???N????',


  		




  
  70
  
    
  `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '?????R?[?h',


  		




  
  71
  
    
  `DepartmentName` varchar(60) DEFAULT NULL COMMENT '??????',


  		




  
  72
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  
  73
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  
  74
  
    
  PRIMARY KEY (`PersonCode`,`StartDate`)


  		




  
  75
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S????????????f?[?^';


  		




  
  76
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  77
  
    

  		




  
  78
  
    
--


  		




  
  79
  
    
-- Dumping data for table `chgchargedep`


  		




  
  80
  
    
--


  		




  
  81
  
    

  		




  
  82
  
    
LOCK TABLES `chgchargedep` WRITE;


  		




  
  83
  
    
/*!40000 ALTER TABLE `chgchargedep` DISABLE KEYS */;


  		




  
  84
  
    
INSERT INTO `chgchargedep` VALUES (20181001,'2020-01-01','9999-12-31',1,'?H????','2020-09-29 16:26:56','2020-09-29 16:26:56');


  		




  
  85
  
    
/*!40000 ALTER TABLE `chgchargedep` ENABLE KEYS */;


  		




  
  86
  
    
UNLOCK TABLES;


  		




  
  87
  
    

  		




  
  88
  
    
--


  		




  59
  89
  
    
-- Table structure for table `componentlinkmaster`


  		




  60
  90
  
    
--


  		




  61
  91
  
    

  		




  ......




  112
  142
  
    

  		




  113
  143
  
    
LOCK TABLES `componentmaster` WRITE;


  		




  114
  144
  
    
/*!40000 ALTER TABLE `componentmaster` DISABLE KEYS */;


  		




  115
  
  
    
INSERT INTO `componentmaster` VALUES (1,13,'???????H????i????????j?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(2,14,'???H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(3,15,'???z?H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(4,17,'?d?C????H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(5,16,'?@?B????H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(6,19,'????????@?????????D?H???p',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(7,20,'???????@?????????D?H???p',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(8,9,'???o??@?????????E???H???p',0,1,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(17,2,'?H????@?????????E???H???p',1,0,0,0,'2016-02-16 11:29:45','2018-04-05 19:19:45'),(18,18,'???????????@?????????D?H???p',0,1,0,0,'2016-03-08 16:41:32','2018-04-05 19:19:45'),(19,1,'????H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:03:35','2018-04-05 19:19:45'),(20,7,'????????@?????????E???H???p',0,1,1,0,'2016-03-08 17:23:00','2018-04-05 19:19:45'),(21,8,'???????@?????????E???H???p',0,1,1,0,'2016-03-08 17:24:06','2018-04-05 19:19:45'),(22,3,'?????H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:24:56','2018-04-05 19:19:45'),(23,4,'?d?C?H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:25:37','2018-04-05 19:19:45'),(24,5,'?@?B????H????@?????????E???H???p',1,0,0,0,'2016-03-24 07:43:42','2018-04-05 19:19:45'),(25,6,'?d?C????H????@?????????E???H???p',1,0,0,0,'2016-03-24 07:44:15','2018-04-05 19:19:45'),(26,21,'??v??p',1,0,1,0,'2016-10-15 12:27:37','2018-04-05 19:19:45'),(27,22,'?@??????',0,1,1,0,'2017-03-30 16:44:21','2018-04-05 19:19:45'),(28,23,'???H????????V?z?p',1,0,0,1,'2018-01-31 08:14:46','2018-10-23 07:52:54'),(29,24,'?O???H????????V?z?p',1,0,0,1,'2018-01-31 08:15:48','2018-10-23 07:52:59'),(30,25,'?????H????????V?z?p',1,0,0,1,'2018-01-31 08:16:16','2018-10-23 07:53:03'),(31,26,'?????????H????????V?z?p',1,0,0,1,'2018-01-31 08:17:33','2018-10-23 07:53:06'),(32,27,'??r?H????????V?z?p',1,0,0,1,'2018-01-31 08:18:25','2018-10-23 07:53:09'),(33,28,'????p??????V?z',1,0,1,1,'2018-01-31 10:29:30','2018-10-23 07:53:12');


  		




  
  145
  
    
INSERT INTO `componentmaster` VALUES (1,13,'???????H????i????????j?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(2,14,'???H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(3,15,'???z?H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(4,17,'?d?C????H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(5,16,'?@?B????H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(6,19,'????????@?????????D?H???p',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(7,20,'???????@?????????D?H???p',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(8,9,'???o??@?????????E???H???p',0,1,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(14,10,'???C?U?H???@???c?U???s?Z??A?p',1,0,0,0,'2015-11-18 18:45:38','2018-04-05 19:19:45'),(15,11,'????C?H???@???c?U???s?Z??A?p',1,0,0,0,'2015-11-18 18:46:07','2018-04-05 19:19:45'),(16,12,'????p?@???c?U???s?Z??A?p',0,1,1,0,'2015-11-27 09:14:52','2018-04-05 19:19:45'),(17,2,'?H????@?????????E???H???p',1,0,0,0,'2016-02-16 11:29:45','2018-04-05 19:19:45'),(18,18,'???????????@?????????D?H???p',0,1,0,0,'2016-03-08 16:41:32','2018-04-05 19:19:45'),(19,1,'????H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:03:35','2018-04-05 19:19:45'),(20,7,'????????@?????????E???H???p',0,1,1,0,'2016-03-08 17:23:00','2018-04-05 19:19:45'),(21,8,'???????@?????????E???H???p',0,1,1,0,'2016-03-08 17:24:06','2018-04-05 19:19:45'),(22,3,'?????H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:24:56','2018-04-05 19:19:45'),(23,4,'?d?C?H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:25:37','2018-04-05 19:19:45'),(24,5,'?@?B????H????@?????????E???H???p',1,0,0,0,'2016-03-24 07:43:42','2018-04-05 19:19:45'),(25,6,'?d?C????H????@?????????E???H???p',1,0,0,0,'2016-03-24 07:44:15','2018-04-05 19:19:45'),(26,21,'??v??p',1,0,1,0,'2016-10-15 12:27:37','2018-04-05 19:19:45'),(27,22,'?@??????',0,1,1,0,'2017-03-30 16:44:21','2018-04-05 19:19:45'),(28,23,'???H????????V?z?p',1,0,0,1,'2018-01-31 08:14:46','2018-10-23 07:52:54'),(29,24,'?O???H????????V?z?p',1,0,0,1,'2018-01-31 08:15:48','2018-10-23 07:52:59'),(30,25,'?????H????????V?z?p',1,0,0,1,'2018-01-31 08:16:16','2018-10-23 07:53:03'),(31,26,'?????????H????????V?z?p',1,0,0,1,'2018-01-31 08:17:33','2018-10-23 07:53:06'),(32,27,'??r?H????????V?z?p',1,0,0,1,'2018-01-31 08:18:25','2018-10-23 07:53:09'),(33,28,'????p??????V?z',1,0,1,1,'2018-01-31 10:29:30','2018-10-23 07:53:12');


  		




  116
  146
  
    
/*!40000 ALTER TABLE `componentmaster` ENABLE KEYS */;


  		




  117
  147
  
    
UNLOCK TABLES;


  		




  118
  148
  
    

  		




  ......




  133
  163
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  134
  164
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  135
  165
  
    
  PRIMARY KEY (`ItemCode`)


  		




  136
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?H??}?X?^';


  		




  
  166
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?H??}?X?^';


  		




  137
  167
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  138
  168
  
    

  		




  139
  169
  
    
--


  		




  ......




  142
  172
  
    

  		




  143
  173
  
    
LOCK TABLES `constructionitemmaster` WRITE;


  		




  144
  174
  
    
/*!40000 ALTER TABLE `constructionitemmaster` DISABLE KEYS */;


  		




  145
  
  
    
INSERT INTO `constructionitemmaster` VALUES (10,2,'????????????',1,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:10'),(11,1,'???????H???@???W???Z?????',0,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:09'),(20,4,'???????H????',1,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:09'),(22,13,'?y?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(23,14,'?n??H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(24,16,'?S??H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(25,17,'?R???N???[?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(26,18,'?^?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(27,19,'?S???H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(28,20,'?????H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(29,21,'?`?k?b?p?l???H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(30,22,'???o???`?Z?????g??H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(31,24,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(32,25,'??E?^?C???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(33,26,'??H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(35,29,'?????E????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(36,30,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(37,31,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(39,33,'???????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(40,34,'??????????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(41,35,'?V???b?^?[?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(42,36,'?K???X?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(43,38,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(44,39,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(45,41,'?y?S?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(46,42,'?????d???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(47,44,'???j?b?g?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(50,50,'??????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(51,43,'???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(86,48,'?A??H??',1,0,0,'2016-02-15 15:13:16','2018-10-03 13:53:09'),(112,23,'?????R???N???[?g?H??',1,0,0,'2016-04-21 08:26:28','2018-10-03 13:53:09'),(116,40,'?O???H??',1,0,0,'2016-09-21 16:58:22','2018-10-03 13:53:09'),(117,15,'??b?H??',1,0,0,'2016-10-12 15:22:56','2018-10-03 13:53:09'),(119,47,'???O?H??',1,0,0,'2016-10-27 13:10:39','2018-10-03 13:53:09'),(120,37,'????E?K???X?H??',1,0,0,'2016-10-27 13:13:18','2018-10-03 13:53:09'),(126,49,'?T?C???H??',1,0,0,'2017-01-14 10:20:06','2018-10-03 13:53:09');


  		




  
  175
  
    
INSERT INTO `constructionitemmaster` VALUES (1,1,'??????@???W???Z??',0,1,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(2,2,'?????????@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(3,3,'?H???{???@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(4,4,'??????S??@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(5,5,'????p?????M??@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(6,6,'???O???????|??@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(7,7,'?@?B????@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(8,8,'??????@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(10,10,'????????????@???????H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(11,9,'???????Z???@???????H??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(14,11,'????H???@?????E???H??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(15,15,'???H????',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(16,16,'?????P???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(17,17,'?O???P???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(18,19,'???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(19,20,'?????????',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(20,12,'???????H????',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(21,90,'???@?P???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:56'),(22,21,'?y?H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(23,22,'?n??H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(24,24,'?S??H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(25,25,'?R???N???[?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(26,26,'?^?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(27,27,'?S???H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(28,28,'?????H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(29,29,'?`?k?b?p?l???H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(30,30,'???o???`?Z?????g??H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(31,32,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(32,33,'??E?^?C???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(33,34,'??H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(34,35,'??H?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(35,37,'?????E????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(36,38,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(37,39,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(38,40,'?????t???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(39,41,'???????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(40,42,'??????????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(41,43,'?V???b?^?[?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(42,44,'?K???X?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(43,46,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(44,47,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(45,49,'?y?S?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(46,50,'?????d???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(47,52,'???j?b?g?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(48,53,'?t???[?A?N?Z?X?t???A?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(49,54,'?O?\?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(50,58,'??????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(51,51,'???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(52,63,'?h?????C?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(53,64,'?h?????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(54,62,'?O????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(55,65,'??????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(56,66,'???????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(57,67,'??k???C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(58,89,'???@?c?U?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:56'),(59,59,'???C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(60,18,'?P???H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:54'),(61,68,'?z???H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(62,69,'????E?X?C?b?`?H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(63,70,'??????H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(64,71,'??d?H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(65,72,'?L???[?r?N???E?u???[?J?[??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:55'),(67,73,'???r???z??H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(68,74,'?q???????t???H??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(69,76,'????H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(70,77,'?z???h???H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(71,78,'?????H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(72,79,'?z?C?E???C?H??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(73,80,'?G?A?R???H??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(74,83,'?K?X????H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(86,56,'?A??H??',1,0,0,'2016-02-15 15:13:16','2018-10-29 21:39:55'),(106,85,'???A?C?U?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(107,86,'???C?C?U?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(108,87,'??l???S?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(109,88,'?s?????S?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(110,60,'??C?H??',1,0,0,'2016-02-16 10:22:40','2018-10-29 21:39:55'),(111,61,'?O?????C?H??',1,0,0,'2016-04-18 07:55:25','2018-10-29 21:39:55'),(112,31,'?????R???N???[?g?H??',1,0,0,'2016-04-21 08:26:28','2018-10-29 21:39:54'),(113,91,'?o??????-?`',1,0,0,'2016-09-14 16:22:45','2018-10-29 21:39:56'),(114,92,'?o??????-?a',1,0,0,'2016-09-14 16:23:19','2018-10-29 21:39:56'),(115,93,'?o??????-?b',1,0,0,'2016-09-14 16:23:45','2018-10-29 21:39:56'),(116,48,'?O???H??',1,0,0,'2016-09-21 16:58:22','2018-10-29 21:39:55'),(117,23,'??b?H??',1,0,0,'2016-10-12 15:22:56','2018-10-29 21:39:54'),(118,13,'?{??H?? ',1,0,0,'2016-10-27 13:09:47','2018-10-29 21:39:53'),(119,55,'???O?H??',1,0,0,'2016-10-27 13:10:39','2018-10-29 21:39:55'),(120,45,'????E?K???X?H??',1,0,0,'2016-10-27 13:13:18','2018-10-29 21:39:55'),(121,36,'??E?????H??',1,0,0,'2016-10-27 13:14:20','2018-10-29 21:39:54'),(122,14,'?G?H??',1,0,0,'2016-10-27 13:14:46','2018-10-29 21:39:53'),(123,82,'???E??????H??',1,0,0,'2016-12-23 09:55:36','2018-10-29 21:39:56'),(124,75,'?O???X?g???b?v??u?H??',1,0,0,'2016-12-23 10:06:14','2018-10-29 21:39:56'),(125,94,'?~?[?@??Y??H??',1,0,0,'2016-12-23 10:33:40','2018-10-29 21:39:56'),(126,57,'?T?C???H??',1,0,0,'2017-01-14 10:20:06','2018-10-29 21:39:55'),(127,95,'??????d????H??',1,0,0,'2017-01-17 07:50:49','2018-10-29 21:39:56'),(128,96,'?????E???????H??',1,0,0,'2017-01-17 07:51:41','2018-10-29 21:39:56'),(129,97,'?d???E???????H??',1,0,0,'2017-01-17 07:52:35','2018-10-29 21:39:56'),(130,99,'??d????H??',1,0,0,'2017-01-17 07:53:10','2018-10-29 21:39:56'),(131,100,'???h????H??',1,0,0,'2017-01-17 07:53:51','2018-10-29 21:39:56'),(132,101,'?_?N?g?E?t?[?h?H??',1,0,0,'2017-01-17 07:54:33','2018-10-29 21:39:56'),(133,102,'?@??{??i??@??j',1,0,0,'2017-01-17 07:55:08','2018-10-29 21:39:56'),(134,103,'?@??{??i???C?@??j',1,0,0,'2017-01-17 07:59:26','2018-10-29 21:39:56'),(135,104,'?????H??',1,0,0,'2017-01-17 08:00:15','2018-10-29 21:39:56'),(136,105,'???C????H??',1,0,0,'2017-01-17 08:01:02','2018-10-29 21:39:56'),(137,98,'???????H??',1,0,0,'2017-01-17 08:06:28','2018-10-29 21:39:56'),(138,106,'?????H??',1,0,0,'2017-02-15 08:19:36','2018-10-29 21:39:56'),(139,107,'???z?H??',1,0,0,'2017-02-15 08:39:06','2018-10-29 21:39:56'),(140,108,'?z???H??',1,0,0,'2017-03-09 17:19:19','2018-10-29 21:39:56'),(144,109,'???z?H??',1,0,0,'2017-09-30 09:22:07','2018-10-29 21:39:56'),(145,110,'???????H????????V?z?p',1,1,0,'2018-01-31 08:19:51','2018-10-29 21:39:56'),(146,111,'??b?H????????V?z?p',1,0,0,'2018-01-31 08:20:37','2018-10-29 21:39:57'),(147,112,'???H????????V?z?p',1,0,0,'2018-01-31 08:21:02','2018-10-29 21:39:57'),(148,113,'?O??????H????????V?z?p',1,0,0,'2018-01-31 08:21:28','2018-10-29 21:39:57'),(149,114,'?O??????H????????V?z?p',1,0,0,'2018-01-31 08:23:00','2018-10-29 21:39:57'),(150,115,'?O???t??H????????V?z?p',1,0,0,'2018-01-31 08:23:44','2018-10-29 21:39:57'),(151,116,'????????H????????V?z?p',1,0,0,'2018-01-31 08:24:32','2018-10-29 21:39:57'),(152,117,'????????H????????V?z?p',1,0,0,'2018-01-31 08:25:10','2018-10-29 21:39:57'),(153,118,'?????H???H????????V?z?p',1,0,0,'2018-01-31 08:25:52','2018-10-29 21:39:57'),(154,119,'?????????E?t??H????????V?z?p',1,0,0,'2018-01-31 08:26:21','2018-10-29 21:39:57'),(155,81,'???z?????d?H??',1,0,0,'2018-01-31 08:27:46','2018-10-29 21:39:56'),(156,84,'?????????H??',1,0,0,'2018-02-01 07:59:14','2018-10-29 21:39:56'),(157,120,'???|?H??',1,0,0,'2018-02-01 07:59:43','2018-10-29 21:39:57'),(158,121,'?c?y?E?q?y?H??',1,0,0,'2018-02-01 08:00:12','2018-10-29 21:39:57'),(159,122,'???S???E????{?H',1,0,0,'2018-02-01 08:00:56','2018-10-29 21:39:57'),(160,123,'???????',0,0,0,'2018-04-05 18:34:43','2018-10-29 21:39:57'),(161,124,'??????',0,0,0,'2018-04-05 18:35:06','2018-10-29 21:39:57'),(162,125,'??v????F?\??????',0,0,0,'2018-04-05 18:35:25','2018-10-29 21:39:57'),(163,126,'??v????F?\????????p',0,0,0,'2018-04-05 18:41:30','2018-10-29 21:39:57'),(164,127,'??v????F?????v??',0,0,0,'2018-04-05 18:42:13','2018-10-29 21:39:57'),(165,128,'????H??',1,0,0,'2018-04-26 10:16:20','2018-10-29 21:39:57'),(166,129,'?????E???H??',1,0,0,'2018-10-29 21:38:03','2018-10-29 21:39:57');


  		




  146
  176
  
    
/*!40000 ALTER TABLE `constructionitemmaster` ENABLE KEYS */;


  		




  147
  177
  
    
UNLOCK TABLES;


  		




  
  178
  
    

  		




  148
  179
  
    
--


  		




  149
  180
  
    
-- Table structure for table `constructiontypemaster`


  		




  150
  181
  
    
--


  		




  ......




  160
  191
  
    
  `RepairFlg` decimal(1,0) NOT NULL COMMENT '?V?z?E???C?t???O',


  		




  161
  192
  
    
  `SecRank` decimal(1,0) NOT NULL COMMENT '?????????N',


  		




  162
  193
  
    
  `ExpensesLink` decimal(1,0) NOT NULL COMMENT '?o??g?p??',


  		




  
  194
  
    
  `CompanyProp` decimal(1,0) NOT NULL COMMENT '????H????',


  		




  163
  195
  
    
  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',


  		




  164
  196
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  165
  197
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  ......




  173
  205
  
    

  		




  174
  206
  
    
LOCK TABLES `constructiontypemaster` WRITE;


  		




  175
  207
  
    
/*!40000 ALTER TABLE `constructiontypemaster` DISABLE KEYS */;


  		




  176
  
  
    
INSERT INTO `constructiontypemaster` VALUES (1,5,'????H???@???C?i?????j',2,0,4,0,0,'2015-11-16 15:19:01','2018-05-24 09:40:41'),(2,7,'????H???@???C?i?????j',2,0,4,0,0,'2015-11-16 15:19:01','2018-05-24 09:40:41'),(3,11,'??l?q???t?H?[???H???i?????j',2,0,4,0,0,'2015-11-16 15:19:01','2018-05-24 09:40:41'),(4,1,'?????H???@???C?i?????j',1,2,4,0,0,'2015-11-17 08:16:00','2018-05-24 09:40:41'),(5,3,'?????H???@???C?i?????j',1,2,4,0,0,'2015-11-17 08:16:00','2018-05-24 09:40:41'),(9,2,'?????H???@?V?z?i?????j',1,1,4,0,0,'2016-01-30 10:35:47','2018-05-24 09:40:41'),(10,4,'?????H???@?V?z?i?????j',1,1,4,0,0,'2016-01-30 10:42:20','2018-05-24 09:40:41'),(11,6,'????H???@?V?z?i?????j',2,0,4,0,0,'2016-01-30 10:43:14','2018-05-24 09:40:41'),(12,8,'????H???@?V?z?i?????j',2,0,4,0,0,'2016-01-30 10:43:47','2018-05-24 09:40:41');


  		




  
  208
  
    
INSERT INTO `constructiontypemaster` VALUES (1,1,'?????H???@???C?i?????j',1,2,4,0,0,0,'2015-11-17 08:16:00','2019-12-03 14:10:14'),(2,2,'?????H???@?V?z?i?????j',1,1,4,0,0,0,'2016-01-30 10:35:47','2019-12-03 14:10:14'),(3,3,'?????H???@???C?i?????j',1,2,4,0,0,0,'2015-11-17 08:16:00','2019-12-03 14:10:14'),(4,4,'?????H???@?V?z?i?????j',1,1,4,0,0,0,'2016-01-30 10:42:20','2019-12-03 14:10:14'),(5,5,'????H???@???C?i?????j',2,0,4,0,0,0,'2015-11-16 15:19:01','2019-12-03 14:10:14'),(6,6,'????H???@?V?z?i?????j',2,0,4,0,0,0,'2016-01-30 10:43:14','2019-12-03 14:10:14'),(7,7,'????H???@???C?i?????j',2,0,4,0,0,0,'2015-11-16 15:19:01','2019-12-03 14:10:14'),(8,8,'????H???@?V?z?i?????j',2,0,4,0,0,0,'2016-01-30 10:43:47','2019-12-03 14:10:14');


  		




  177
  209
  
    
/*!40000 ALTER TABLE `constructiontypemaster` ENABLE KEYS */;


  		




  178
  210
  
    
UNLOCK TABLES;


  		




  179
  211
  
    

  		




  ......




  199
  231
  
    
INSERT INTO `daymaster` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31);


  		




  200
  232
  
    
/*!40000 ALTER TABLE `daymaster` ENABLE KEYS */;


  		




  201
  233
  
    
UNLOCK TABLES;


  		




  
  234
  
    

  		




  202
  235
  
    
--


  		




  203
  236
  
    
-- Table structure for table `departmentexpensesmaster`


  		




  204
  237
  
    
--


  		




  ......




  226
  259
  
    

  		




  227
  260
  
    
LOCK TABLES `departmentexpensesmaster` WRITE;


  		




  228
  261
  
    
/*!40000 ALTER TABLE `departmentexpensesmaster` DISABLE KEYS */;


  		




  229
  
  
    
INSERT INTO `departmentexpensesmaster` VALUES (0,15,1,'?c??o??',1,8.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,15,2,'?e?????o??',2,5.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,15,3,'???o??',3,7.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,1,'?c??o??',1,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,2,'?e?????o??',2,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,3,'???o??',3,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,1,'?c??o??',1,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,2,'?e?????o??',2,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,3,'???o??',3,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(1,15,1,'?c??o??',2,8.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,15,2,'?e?????o??',3,5.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,15,3,'???o??',1,7.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,16,1,'?c??o??',2,2.00,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,16,2,'?e?????o??',3,7.00,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,16,3,'???o??',1,8.50,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,17,1,'?c??o??',2,2.00,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,17,2,'?e?????o??',3,6.50,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,17,3,'???o??',1,8.50,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,18,1,'?c??o??',3,1.50,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,18,2,'?e?????o??',2,7.50,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,18,3,'???o??',1,9.50,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,18,4,'?S???C??',4,0.00,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,19,1,'?c??o??',3,1.50,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,19,2,'?e?????o??',2,7.50,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,19,3,'???o??',1,9.50,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,19,4,'?S???C??',4,0.20,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,20,1,'?c??o??',3,1.50,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,20,2,'?e?????o??',2,6.80,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,20,3,'???o??',1,9.80,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,20,4,'?S???C??',4,0.20,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,21,1,'?c??o??',3,1.50,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(1,21,2,'?e?????o??',2,6.80,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(1,21,3,'???o??',1,9.80,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(1,21,4,'?S???C??',4,0.20,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(2,15,1,'?c??o??',2,8.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,15,2,'?e?????o??',3,5.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,15,3,'???o??',1,7.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,16,1,'?c??o??',2,2.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,16,2,'?e?????o??',3,8.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,16,3,'???o??',1,8.50,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,17,1,'?c??o??',2,2.00,0,'2017-11-24 15:05:17','2017-11-24 15:05:17'),(2,17,2,'?e?????o??',3,7.00,0,'2017-11-24 15:05:17','2017-11-24 15:05:17'),(2,17,3,'???o??',1,8.50,0,'2017-11-24 15:05:17','2017-11-24 15:05:17'),(2,18,1,'?c??o??',3,1.50,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,18,2,'?e?????o??',2,6.00,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,18,3,'???o??',1,9.50,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,18,4,'?S???C??',4,0.00,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,19,1,'?c??o??',3,1.50,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,19,2,'?e?????o??',2,7.00,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,19,3,'???o??',1,9.50,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,19,4,'?S???C??',4,0.20,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,20,1,'?c??o??',3,1.50,0,'2018-10-13 10:50:57','2018-10-13 10:50:57'),(2,20,2,'?e?????o??',2,5.70,0,'2018-10-13 10:50:57','2018-10-13 10:50:57'),(2,20,3,'???o??',1,9.80,0,'2018-10-13 10:50:57','2018-10-13 10:50:57'),(3,15,1,'?c??o??',2,8.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,15,2,'?e?????o??',3,5.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,15,3,'???o??',1,7.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,1,'?c??o??',2,2.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,2,'?e?????o??',3,9.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,3,'???o??',1,8.50,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,17,1,'?c??o??',2,2.00,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,17,2,'?e?????o??',3,7.50,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,17,3,'???o??',1,8.50,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,18,1,'?c??o??',2,1.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,18,2,'?e?????o??',3,7.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,18,3,'???o??',1,9.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,19,1,'?c??o??',2,2.00,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(3,19,2,'?e?????o??',3,10.00,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(3,19,3,'???o??',1,8.50,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(4,15,1,'?c??o??',2,8.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,15,2,'?e?????o??',3,5.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,15,3,'???o??',1,7.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,16,1,'?c??o??',2,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,16,2,'?e?????o??',3,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,16,3,'???o??',1,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,17,1,'?c??o??',2,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,17,2,'?e?????o??',3,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,17,3,'???o??',1,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(5,15,1,'?c??o??',2,8.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,15,2,'?e?????o??',3,5.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,15,3,'???o??',1,7.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,16,1,'?c??o??',2,10.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,16,2,'?e?????o??',3,20.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,16,3,'???o??',1,20.50,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,17,1,'?c??o??',2,10.00,0,'2017-05-09 09:47:21','2017-05-09 09:47:21'),(5,17,2,'?e?????o??',3,20.00,0,'2017-05-09 09:47:21','2017-05-09 09:47:21'),(5,17,3,'???o??',1,10.00,0,'2017-05-09 09:47:21','2017-05-09 09:47:21'),(5,18,1,'?c??o??',3,10.00,0,'2018-10-13 10:52:41','2018-10-13 10:52:41'),(5,18,2,'?e?????o??',2,20.00,0,'2018-10-13 10:52:41','2018-10-13 10:52:41'),(5,18,3,'???o??',1,10.00,0,'2018-10-13 10:52:41','2018-10-13 10:52:41'),(5,19,1,'?c??o??',3,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,19,2,'?e?????o??',2,20.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,19,3,'???o??',1,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,19,4,'?S???C??',4,0.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,1,'?c??o??',3,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,2,'?e?????o??',2,20.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,3,'???o??',1,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,4,'?S???C??',4,0.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(7,15,1,'?c??o??',2,8.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,15,2,'?e?????o??',3,5.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,15,3,'???o??',1,7.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,16,1,'?c??o??',2,2.00,0,'2016-12-16 10:10:10','2016-12-16 10:10:10'),(7,16,2,'?e?????o??',3,7.00,0,'2016-12-16 10:10:10','2016-12-16 10:10:10'),(7,16,3,'???o??',1,8.50,0,'2016-12-16 10:10:10','2016-12-16 10:10:10'),(7,17,1,'?c??o??',2,2.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,17,2,'?e?????o??',3,7.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,17,3,'???o??',1,8.50,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,18,1,'?c??o??',2,1.50,0,'2018-02-10 20:41:24','2018-02-10 20:41:24'),(7,18,2,'?e?????o??',3,7.50,0,'2018-02-10 20:41:24','2018-02-10 20:41:24'),(7,18,3,'???o??',1,9.50,0,'2018-02-10 20:41:24','2018-02-10 20:41:24'),(7,19,1,'?c??o??',3,1.50,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,19,2,'?e?????o??',2,8.00,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,19,3,'???o??',1,9.50,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,19,4,'?S???C??',4,0.02,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,20,1,'?c??o??',3,1.50,0,'2018-10-13 10:52:04','2018-10-13 10:52:04'),(7,20,2,'?e?????o??',2,7.50,0,'2018-10-13 10:52:04','2018-10-13 10:52:04'),(7,20,3,'???o??',1,9.80,0,'2018-10-13 10:52:04','2018-10-13 10:52:04'),(8,15,1,'?c??o??',2,8.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,15,2,'?e?????o??',3,5.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,15,3,'???o??',1,7.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,16,1,'?c??o??',2,2.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,16,2,'?e?????o??',3,7.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,16,3,'???o??',1,8.50,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,17,1,'?c??o??',2,2.00,1,'2017-05-09 09:50:16','2019-05-07 08:15:22'),(8,17,2,'?e?????o??',3,10.00,1,'2017-05-09 09:50:16','2019-05-07 08:15:22'),(8,17,3,'???o??',1,8.50,1,'2017-05-09 09:50:16','2019-05-07 08:15:22'),(8,18,1,'?c??o??',2,1.50,1,'2018-02-10 20:39:49','2019-05-07 08:15:22'),(8,18,2,'?e?????o??',3,7.50,1,'2018-02-10 20:39:49','2019-05-07 08:15:22'),(8,18,3,'???o??',1,9.50,1,'2018-02-10 20:39:49','2019-05-07 08:15:22'),(8,19,1,'?c??o??',3,1.50,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,19,2,'?e?????o??',2,7.70,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,19,3,'???o??',1,9.50,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,19,4,'?S???C??',4,0.20,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,20,1,'?c??o??',3,1.50,1,'2018-10-13 10:49:59','2019-05-07 08:15:22'),(8,20,2,'?e?????o??',2,6.80,1,'2018-10-13 10:49:59','2019-05-07 08:15:22'),(8,20,3,'???o??',1,9.80,1,'2018-10-13 10:49:59','2019-05-07 08:15:22'),(9,15,1,'?c??o??',2,8.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,15,2,'?e?????o??',3,5.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,15,3,'???o??',1,7.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,1,'?c??o??',2,2.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,2,'?e?????o??',3,8.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,3,'???o??',1,15.50,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,17,1,'?c??o??',2,1.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,17,2,'?e?????o??',3,7.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,17,3,'???o??',1,9.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,18,1,'?c??o??',2,2.00,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,18,2,'?e?????o??',3,9.00,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,18,3,'???o??',1,8.50,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,19,1,'?c??o??',2,2.00,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(9,19,2,'?e?????o??',3,10.00,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(9,19,3,'???o??',1,8.50,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(10,17,1,'?c??o??',2,0.00,1,'2018-03-29 17:28:32','2019-09-02 08:28:01'),(10,17,2,'?e?????o??',3,0.00,1,'2018-03-29 17:28:32','2019-09-02 08:28:01'),(10,17,3,'???o??',1,0.00,1,'2018-03-29 17:28:32','2019-09-02 08:28:01'),(10,18,1,'?c??o??',3,1.50,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,18,2,'?e?????o??',2,7.50,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,18,3,'???o??',1,9.50,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,18,4,'?S???C??',4,0.00,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,19,1,'?c??o??',3,1.50,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,19,2,'?e?????o??',2,7.90,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,19,3,'???o??',1,9.50,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,19,4,'?S???C??',4,0.20,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,20,1,'?c??o??',3,1.50,1,'2018-10-13 10:51:36','2019-09-02 08:28:01'),(10,20,2,'?e?????o??',2,9.20,1,'2018-10-13 10:51:36','2019-09-02 08:28:01'),(10,20,3,'???o??',1,9.80,1,'2018-10-13 10:51:36','2019-09-02 08:28:01'),(11,18,1,'?c??o??',3,1.50,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,18,2,'?e?????o??',2,18.50,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,18,3,'???o??',1,5.00,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,18,4,'?S???C??',4,0.02,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,19,1,'?c??o??',3,1.50,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,19,2,'?e?????o??',2,16.30,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,19,3,'???o??',1,0.00,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,19,4,'?S???C??',4,0.00,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,20,1,'?c??o??',3,1.50,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(11,20,2,'?e?????o??',2,16.30,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(11,20,3,'???o??',1,0.00,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(11,20,4,'?S???C??',4,0.00,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(12,18,1,'?c??o??',3,1.50,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,18,2,'?e?????o??',2,18.50,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,18,3,'???o??',1,5.00,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,18,4,'?S???C??',4,0.02,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,19,1,'?c??o??',3,1.50,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,19,2,'?e?????o??',2,19.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,19,3,'???o??',1,5.00,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,19,4,'?S???C??',4,0.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,1,'?c??o??',3,1.50,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,2,'?e?????o??',2,19.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,3,'???o??',1,5.00,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,4,'?S???C??',4,0.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(13,19,1,'?c??o??',3,1.50,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,19,2,'?e?????o??',2,7.50,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,19,3,'???o??',1,9.50,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,19,4,'?S???C??',4,0.20,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,20,1,'?c??o??',3,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(13,20,2,'?e?????o??',2,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(13,20,3,'???o??',1,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(13,20,4,'?S???C??',4,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(14,19,1,'?c??o??',3,1.50,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,19,2,'?e?????o??',2,7.50,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,19,3,'???o??',1,9.50,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,19,4,'?S???C??',4,0.20,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,20,1,'?c??o??',3,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,20,2,'?e?????o??',2,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,20,3,'???o??',1,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,20,4,'?S???C??',4,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,1,'?c??o??',3,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,2,'?e?????o??',2,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,3,'???o??',1,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,4,'?S???C??',4,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52');


  		




  
  262
  
    
INSERT INTO `departmentexpensesmaster` VALUES (1,1,1,'???o??',1,0.00,0,'2020-09-29 16:17:58','2020-09-29 16:17:58'),(1,1,2,'?c??o??',2,0.00,0,'2020-09-29 16:17:58','2020-09-29 16:17:58');


  		




  230
  263
  
    
/*!40000 ALTER TABLE `departmentexpensesmaster` ENABLE KEYS */;


  		




  231
  264
  
    
UNLOCK TABLES;


  		




  232
  265
  
    

  		




  ......




  259
  292
  
    

  		




  260
  293
  
    
LOCK TABLES `departmentmaster` WRITE;


  		




  261
  294
  
    
/*!40000 ALTER TABLE `departmentmaster` DISABLE KEYS */;


  		




  262
  
  
    
INSERT INTO `departmentmaster` VALUES (1,1,'?H????',0,0,'2018-10-01 00:00:00','0001-01-01 00:00:00',0,'0000-00-00 00:00:00','0000-00-00 00:00:00');


  		




  
  295
  
    
INSERT INTO `departmentmaster` VALUES (1,1,'?H????',0,0,'2018-10-01 00:00:00','0001-01-01 00:00:00',0,'0000-00-00 00:00:00','2020-09-29 16:17:58');


  		




  263
  296
  
    
/*!40000 ALTER TABLE `departmentmaster` ENABLE KEYS */;


  		




  264
  297
  
    
UNLOCK TABLES;


  		




  265
  298
  
    

  		




  ......




  279
  312
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  280
  313
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  281
  314
  
    
  PRIMARY KEY (`DivisionCode`,`NameCode`)


  		




  282
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='???}?X?^';


  		




  
  315
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='???}?X?^';


  		




  283
  316
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  284
  317
  
    

  		




  285
  318
  
    
--


  		




  ......




  288
  321
  
    

  		




  289
  322
  
    
LOCK TABLES `divisionmaster` WRITE;


  		




  290
  323
  
    
/*!40000 ALTER TABLE `divisionmaster` DISABLE KEYS */;


  		




  291
  
  
    
INSERT INTO `divisionmaster` VALUES (1,1,1,'?@?l?i??????j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,2,2,'?@?l?i??????j',0,'2015-11-09 14:25:45','2018-10-03 14:18:22'),(1,3,3,'?@?l?i?a?@?E?????{????j',0,'2018-02-24 19:31:29','2018-10-03 14:18:22'),(1,4,4,'?@?l?i?w?Z?@?l?j',0,'2015-11-09 14:31:08','2018-10-03 14:18:22'),(1,5,5,'?????c??i?e????j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,6,6,'???z?m???????E??????m???????',0,'2015-11-13 13:47:24','2018-10-03 14:18:22'),(1,7,7,'??l?i???j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,8,8,'????g???E??????',0,'2017-04-19 07:36:33','2018-10-03 14:18:22'),(1,9,9,'?X???',0,'2018-02-24 19:25:37','2018-10-03 14:18:22'),(1,10,10,'?????',0,'2017-04-19 07:36:44','2018-10-03 14:18:22'),(3,3,1,'???o??',0,'2015-11-16 15:19:23','2018-04-27 08:33:01');


  		




  
  324
  
    
INSERT INTO `divisionmaster` VALUES (1,1,1,'?????c??',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,2,2,'?@?l',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,3,3,'??l',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,4,4,'?????',0,'2017-04-19 07:36:44','2020-09-29 16:14:53'),(3,1,1,'???o??',0,'2015-11-16 15:19:23','2018-11-14 11:01:03'),(3,2,2,'?c??o??',0,'2015-11-16 15:19:23','2018-11-14 11:01:03');


  		




  292
  325
  
    
/*!40000 ALTER TABLE `divisionmaster` ENABLE KEYS */;


  		




  293
  326
  
    
UNLOCK TABLES;


  		




  294
  327
  
    

  		




  ......




  302
  335
  
    
CREATE TABLE `monthmaster` (


  		




  303
  336
  
    
  `month` smallint(6) NOT NULL COMMENT '??',


  		




  304
  337
  
    
  PRIMARY KEY (`month`)


  		




  305
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='???}?X?^';


  		




  
  338
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='???}?X?^';


  		




  306
  339
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  307
  340
  
    

  		




  308
  341
  
    
--


  		




  ......




  316
  349
  
    
UNLOCK TABLES;


  		




  317
  350
  
    

  		




  318
  351
  
    
--


  		




  
  352
  
    
-- Table structure for table `persondepartmentmaster`


  		




  
  353
  
    
--


  		




  
  354
  
    

  		




  
  355
  
    
DROP TABLE IF EXISTS `persondepartmentmaster`;


  		




  
  356
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  357
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  358
  
    
CREATE TABLE `persondepartmentmaster` (


  		




  
  359
  
    
  `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '?S????R?[?h',


  		




  
  360
  
    
  `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '?????R?[?h',


  		




  
  361
  
    
  `AffiliationFlg` decimal(1,0) NOT NULL COMMENT '?????t???O',


  		




  
  362
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  
  363
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  
  364
  
    
  PRIMARY KEY (`PersonCode`,`DepartmentCode`),


  		




  
  365
  
    
  KEY `PersonDepartmentMaster_Index1` (`PersonCode`),


  		




  
  366
  
    
  KEY `PersonDepartmentMaster_Index2` (`DepartmentCode`)


  		




  
  367
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S??????????}?X?^';


  		




  
  368
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  369
  
    

  		




  
  370
  
    
--


  		




  
  371
  
    
-- Dumping data for table `persondepartmentmaster`


  		




  
  372
  
    
--


  		




  
  373
  
    

  		




  
  374
  
    
LOCK TABLES `persondepartmentmaster` WRITE;


  		




  
  375
  
    
/*!40000 ALTER TABLE `persondepartmentmaster` DISABLE KEYS */;


  		




  
  376
  
    
INSERT INTO `persondepartmentmaster` VALUES (20181001,1,1,'2020-09-29 16:26:56','2020-09-29 16:26:56');


  		




  
  377
  
    
/*!40000 ALTER TABLE `persondepartmentmaster` ENABLE KEYS */;


  		




  
  378
  
    
UNLOCK TABLES;


  		




  
  379
  
    

  		




  
  380
  
    
--


  		




  319
  381
  
    
-- Table structure for table `personinchargemaster`


  		




  320
  382
  
    
--


  		




  321
  383
  
    

  		




  ......




  372
  434
  
    

  		




  373
  435
  
    
LOCK TABLES `personinchargemaster` WRITE;


  		




  374
  436
  
    
/*!40000 ALTER TABLE `personinchargemaster` DISABLE KEYS */;


  		




  375
  
  
    
INSERT INTO `personinchargemaster` VALUES (20181001,1,'?H???????','?R?E?W?J?????V??',0,'A','9999-12-31','','','','','','','','2018-10-01','9999-12-31','20181001',4,1,'','',1,0,0,'','???F??',1,1,0.00,0.0,0.0,0,0,0,0,'2018-10-03 14:23:19','2018-10-03 14:23:19');


  		




  
  437
  
    
INSERT INTO `personinchargemaster` VALUES (20200101,1,'?????@','?V???L?@',0,'A','9999-12-31','','','','','','','','2018-10-01','9999-12-31','20200101',4,1,'','??\',1,0,0,'','???F??',1,1,0.00,0,0.0,0.0,0,0,0,'2018-10-03 14:23:19','2020-09-29 16:26:56');


  		




  376
  438
  
    
/*!40000 ALTER TABLE `personinchargemaster` ENABLE KEYS */;


  		




  377
  439
  
    
UNLOCK TABLES;


  		




  378
  440
  
    

  		




  
  441
  
    

  		




  379
  442
  
    
--


  		




  
  443
  
    
-- Dumping data for table `personqualification`


  		




  
  444
  
    
--


  		




  
  445
  
    

  		




  
  446
  
    
LOCK TABLES `personqualification` WRITE;


  		




  
  447
  
    
/*!40000 ALTER TABLE `personqualification` DISABLE KEYS */;


  		




  
  448
  
    
/*!40000 ALTER TABLE `personqualification` ENABLE KEYS */;


  		




  
  449
  
    
UNLOCK TABLES;


  		




  
  450
  
    

  		




  
  451
  
    
--


  		




  
  452
  
    
-- Table structure for table `personsalarymaster`


  		




  
  453
  
    
--


  		




  
  454
  
    

  		




  
  455
  
    
DROP TABLE IF EXISTS `personsalarymaster`;


  		




  
  456
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  457
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  458
  
    
CREATE TABLE `personsalarymaster` (


  		




  
  459
  
    
  `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '?S????R?[?h',


  		




  
  460
  
    
  `StartDate` date NOT NULL COMMENT '?g?p?J?n?N????',


  		




  
  461
  
    
  `MonthlySalary` decimal(11,0) NOT NULL COMMENT '???????z',


  		




  
  462
  
    
  `YearSalary` decimal(12,0) NOT NULL COMMENT '?N????z',


  		




  
  463
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  
  464
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  
  465
  
    
  PRIMARY KEY (`PersonCode`,`StartDate`),


  		




  
  466
  
    
  KEY `PersonSalaryMaster_Index1` (`PersonCode`),


  		




  
  467
  
    
  KEY `PersonSalaryMaster_Index2` (`StartDate`),


  		




  
  468
  
    
  KEY `PersonSalaryMaster_Index3` (`MonthlySalary`)


  		




  
  469
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S??????^?}?X?^';


  		




  
  470
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  471
  
    

  		




  
  472
  
    
--


  		




  
  473
  
    
-- Dumping data for table `personsalarymaster`


  		




  
  474
  
    
--


  		




  
  475
  
    

  		




  
  476
  
    
LOCK TABLES `personsalarymaster` WRITE;


  		




  
  477
  
    
/*!40000 ALTER TABLE `personsalarymaster` DISABLE KEYS */;


  		




  
  478
  
    
INSERT INTO `personsalarymaster` VALUES (20181001,'2020-01-01',0,0,'2020-09-29 16:26:56','2020-09-29 16:26:56');


  		




  
  479
  
    
/*!40000 ALTER TABLE `personsalarymaster` ENABLE KEYS */;


  		




  
  480
  
    
UNLOCK TABLES;


  		




  
  481
  
    

  		




  
  482
  
    
--


  		




  380
  483
  
    
-- Table structure for table `processexcutemaster`


  		




  381
  484
  
    
--


  		




  382
  485
  
    

  		




  ......




  401
  504
  
    

  		




  402
  505
  
    
LOCK TABLES `processexcutemaster` WRITE;


  		




  403
  506
  
    
/*!40000 ALTER TABLE `processexcutemaster` DISABLE KEYS */;


  		




  404
  
  
    
INSERT INTO `processexcutemaster` VALUES (1,1,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,7,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,11,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,12,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,15,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,37,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,45,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,101,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,102,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,111,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,112,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,115,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,117,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,118,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,120,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,124,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,126,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,129,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,130,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,131,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,132,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(2,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(3,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(4,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(6,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(7,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,130,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,18,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(8,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,12,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,15,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(9,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,2,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,3,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,16,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,17,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,19,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,29,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,30,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,31,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,32,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,34,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,36,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,39,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,40,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,42,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(10,102,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,103,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,110,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,111,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,114,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,116,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,118,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,121,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,122,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,123,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,125,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,126,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(11,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(12,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07');


  		




  
  507
  
    
INSERT INTO `processexcutemaster` VALUES (1,1,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,2,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,3,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,4,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,5,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,6,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,7,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,8,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,9,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,10,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,11,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,12,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,13,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,14,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,15,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,16,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,17,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,19,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,29,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,30,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,31,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,32,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,37,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,39,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,40,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,41,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,42,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,45,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,101,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,102,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,103,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,104,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,105,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,106,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,107,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,108,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,109,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,110,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,111,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,112,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,114,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,115,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,116,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,117,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,119,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,120,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,122,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,123,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,124,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,125,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,126,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,131,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,132,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,134,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,135,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(2,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(2,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(3,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(4,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(6,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(7,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,130,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,18,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(8,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,12,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,15,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(9,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,2,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,3,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,16,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,17,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,19,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,29,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,30,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,31,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,32,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,34,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,36,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,39,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,40,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,42,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(10,102,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,103,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,110,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,111,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,114,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,116,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,118,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,121,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,122,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,123,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,125,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,126,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(11,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(12,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07');


  		




  405
  508
  
    
/*!40000 ALTER TABLE `processexcutemaster` ENABLE KEYS */;


  		




  406
  509
  
    
UNLOCK TABLES;


  		




  407
  510
  
    

  		




  408
  511
  
    
--


  		




  
  512
  
    
-- Table structure for table `securitymaster`


  		




  
  513
  
    
--


  		




  
  514
  
    

  		




  
  515
  
    
DROP TABLE IF EXISTS `securitymaster`;


  		




  
  516
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  517
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  518
  
    
CREATE TABLE `securitymaster` (


  		




  
  519
  
    
  `SecCode` decimal(4,0) unsigned NOT NULL COMMENT '???????',


  		




  
  520
  
    
  `DisplayOrder` decimal(4,0) NOT NULL COMMENT '?\????',


  		




  
  521
  
    
  `SecName` varchar(60) NOT NULL COMMENT '????????',


  		




  
  522
  
    
  `SecRank` decimal(1,0) NOT NULL COMMENT '?????????N',


  		




  
  523
  
    
  `SecRange` decimal(1,0) NOT NULL COMMENT '???????',


  		




  
  524
  
    
  `GeneralAffairs` decimal(1,0) NOT NULL COMMENT '????????t???O',


  		




  
  525
  
    
  `SelectBackColor` varchar(8) NOT NULL COMMENT '?I??w?i?F',


  		




  
  526
  
    
  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',


  		




  
  527
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  
  528
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  
  529
  
    
  PRIMARY KEY (`SecCode`),


  		




  
  530
  
    
  KEY `SecurityMaster_Index1` (`DisplayOrder`),


  		




  
  531
  
    
  KEY `SecurityMaster_Index2` (`SecRank`),


  		




  
  532
  
    
  KEY `SecurityMaster_Index3` (`SecRange`)


  		




  
  533
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?????}?X?^';


  		




  
  534
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  535
  
    

  		




  
  536
  
    
--


  		




  
  537
  
    
-- Dumping data for table `securitymaster`


  		




  
  538
  
    
--


  		




  
  539
  
    

  		




  
  540
  
    
LOCK TABLES `securitymaster` WRITE;


  		




  
  541
  
    
/*!40000 ALTER TABLE `securitymaster` DISABLE KEYS */;


  		




  
  542
  
    
INSERT INTO `securitymaster` VALUES (1,1,'??\',1,1,1,'0x000000',0,'2020-09-29 16:25:38','2020-09-29 16:25:47');


  		




  
  543
  
    
/*!40000 ALTER TABLE `securitymaster` ENABLE KEYS */;


  		




  
  544
  
    
UNLOCK TABLES;


  		




  
  545
  
    

  		




  
  546
  
    
--


  		




  409
  547
  
    
-- Table structure for table `systemexecute`


  		




  410
  548
  
    
--


  		




  411
  549
  
    

  		




  ......




  429
  567
  
    

  		




  430
  568
  
    
LOCK TABLES `systemexecute` WRITE;


  		




  431
  569
  
    
/*!40000 ALTER TABLE `systemexecute` DISABLE KEYS */;


  		




  432
  
  
    
INSERT INTO `systemexecute` VALUES (1,'2018-10-03',0,0,'2015-12-21 17:24:12','2018-10-03 13:27:49'),(2,'2017-02-27',228,2,'2017-02-27 15:04:23','2017-05-13 13:15:23');


  		




  
  570
  
    
INSERT INTO `systemexecute` VALUES (1,'2018-10-03',0,0,'2015-12-21 17:24:12','2018-10-03 13:27:49'),(2,'2017-02-27',1,1,'2017-02-27 15:04:23','2017-05-13 13:15:23');


  		




  433
  571
  
    
/*!40000 ALTER TABLE `systemexecute` ENABLE KEYS */;


  		




  434
  572
  
    
UNLOCK TABLES;


  		




  
  573
  
    

  		




  435
  574
  
    
--


  		




  436
  575
  
    
-- Table structure for table `systemmaster`


  		




  437
  576
  
    
--


  		




  ......




  469
  608
  
    
  `SloganString2` varchar(100) DEFAULT NULL COMMENT '?W??2',


  		




  470
  609
  
    
  `SloganString3` varchar(100) DEFAULT NULL COMMENT '?W??3',


  		




  471
  610
  
    
  `OperationFlg` decimal(2,0) unsigned NOT NULL COMMENT '???F?^?p?t???O',


  		




  
  611
  
    
  `SystemOpenTime` datetime NOT NULL COMMENT '?^?p?J?n????',


  		




  
  612
  
    
  `SystemCloseTime` datetime NOT NULL COMMENT '?^?p?I??????',


  		




  
  613
  
    
  `PesrsonCost1` decimal(7,0) unsigned NOT NULL COMMENT '???l????P?i?w?????R?X?g?j',


  		




  
  614
  
    
  `PesrsonCost2` decimal(7,0) unsigned NOT NULL COMMENT '???l????Q?i???S????R?X?g?j',


  		




  472
  615
  
    
  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',


  		




  473
  616
  
    
  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',


  		




  474
  617
  
    
  PRIMARY KEY (`SystemCode`)


  		




  475
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='????}?X?^';


  		




  
  618
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='????}?X?^';


  		




  476
  619
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  477
  620
  
    

  		




  478
  621
  
    
--


  		




  ......




  481
  624
  
    

  		




  482
  625
  
    
LOCK TABLES `systemmaster` WRITE;


  		




  483
  626
  
    
/*!40000 ALTER TABLE `systemmaster` DISABLE KEYS */;


  		




  484
  
  
    
INSERT INTO `systemmaster` VALUES (1,'???????@???z???','','??\?@???N','??\?????','650-0001','?????','?_??s??????','???[??','078-000-0000','078-000-0001','',10.00,0.50,8.00,20.00,3.00,'C:\\Temp\\?G?N?Z???f?[?^',0,0,'2010-01-01 00:00:00','2010-01-01 00:00:00','9999-12-31 00:00:00','9999-12-31 00:00:00',-1,'','','',0,'2015-09-05 00:00:00','2018-09-28 15:25:49');


  		




  
  627
  
    
INSERT INTO `systemmaster` VALUES (1,'???????@???z???','','??\?@???N','??\?????','650-0001','?????','?_??s??????','???[??','078-000-0000','078-000-0000','',10.00,0.50,8.00,0.00,0.00,'C:\\Temp\\?G?N?Z???f?[?^',1,2020,'2020-04-01 00:00:00','2020-04-01 00:00:00','2021-03-31 00:00:00','2021-03-31 00:00:00',-1,'','','',0,'0001-01-01 06:00:00','0001-01-01 22:00:00',100000,100000,'2015-09-05 00:00:00','2020-09-29 16:20:48');


  		




  485
  628
  
    
/*!40000 ALTER TABLE `systemmaster` ENABLE KEYS */;


  		




  486
  629
  
    
UNLOCK TABLES;


  		




  487
  630
  
    

  		












他の形式にエクスポート:  Unified diff