リビジョン 472
一人親方・承認版の初期データ
trunk/ddl/ProductType1.SQL | ||
---|---|---|
4 | 4 |
|
5 | 5 |
LOCK TABLES `approvalmaster` WRITE; |
6 | 6 |
/*!40000 ALTER TABLE `approvalmaster` DISABLE KEYS */; |
7 |
INSERT INTO `approvalmaster` VALUES (1,1,1,1,20181001,0,'2019-12-18 19:28:27','2019-12-18 19:28:27'),(3,1,1,1,20181001,0,'2019-12-18 19:28:33','2019-12-18 19:28:33'),(4,1,1,1,20181001,0,'2019-12-18 19:28:39','2019-12-18 19:28:39'),(5,1,1,1,20181001,0,'2019-12-18 19:28:45','2019-12-18 19:28:45');
|
|
7 |
INSERT INTO `approvalmaster` VALUES (1,1,1,1,20181001,0,NOW(),NOW()),(3,1,1,1,20181001,0,NOW(),NOW()),(4,1,1,1,20181001,0,NOW(),NOW()),(5,1,1,1,20181001,0,NOW(),NOW());
|
|
8 | 8 |
/*!40000 ALTER TABLE `approvalmaster` ENABLE KEYS */; |
9 | 9 |
UNLOCK TABLES; |
10 | 10 |
|
... | ... | |
14 | 14 |
|
15 | 15 |
LOCK TABLES `budgetsumcode` WRITE; |
16 | 16 |
/*!40000 ALTER TABLE `budgetsumcode` DISABLE KEYS */; |
17 |
INSERT INTO `budgetsumcode` VALUES (1,0,1,0,'???????H????i????????j?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,0,2,0,'???H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,0,3,0,'???z?H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,0,4,0,'?d?C????H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,0,5,0,'?@?B????H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,0,6,0,'????????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,0,7,0,'???????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,0,18,0,'???????????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,1,18,0,'???????????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,2,7,0,'???????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,2,8,0,'???o??@?????????E???H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,2,21,0,'???????@?????????E???H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,3,6,0,'????????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,3,20,0,'????????@?????????E???H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,4,1,0,'???????H????i????????j?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,4,1,10,'????????????@???????H??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,5,2,0,'???H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,6,3,0,'???z?H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,7,4,0,'?d?C????H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,8,5,0,'?@?B????H????@?????????D?H???p','2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
17 |
INSERT INTO `budgetsumcode` VALUES (1,0,1,0,'???????H????i????????j?????????D?H???p',NOW(),NOW()),(1,0,2,0,'???H????@?????????D?H???p',NOW(),NOW()),(1,0,3,0,'???z?H????@?????????D?H???p',NOW(),NOW()),(1,0,4,0,'?d?C????H????@?????????D?H???p',NOW(),NOW()),(1,0,5,0,'?@?B????H????@?????????D?H???p',NOW(),NOW()),(1,0,6,0,'????????@?????????D?H???p',NOW(),NOW()),(1,0,7,0,'???????@?????????D?H???p',NOW(),NOW()),(1,0,18,0,'???????????@?????????D?H???p',NOW(),NOW()),(2,1,18,0,'???????????@?????????D?H???p',NOW(),NOW()),(3,2,7,0,'???????@?????????D?H???p',NOW(),NOW()),(3,2,8,0,'???o??@?????????E???H???p',NOW(),NOW()),(3,2,21,0,'???????@?????????E???H???p',NOW(),NOW()),(4,3,6,0,'????????@?????????D?H???p',NOW(),NOW()),(4,3,20,0,'????????@?????????E???H???p',NOW(),NOW()),(5,4,1,0,'???????H????i????????j?????????D?H???p',NOW(),NOW()),(5,4,1,10,'????????????@???????H??',NOW(),NOW()),(6,5,2,0,'???H????@?????????D?H???p',NOW(),NOW()),(6,6,3,0,'???z?H????@?????????D?H???p',NOW(),NOW()),(6,7,4,0,'?d?C????H????@?????????D?H???p',NOW(),NOW()),(6,8,5,0,'?@?B????H????@?????????D?H???p',NOW(),NOW());
|
|
18 | 18 |
/*!40000 ALTER TABLE `budgetsumcode` ENABLE KEYS */; |
19 | 19 |
UNLOCK TABLES; |
20 | 20 |
|
... | ... | |
24 | 24 |
|
25 | 25 |
LOCK TABLES `businesstypemaster` WRITE; |
26 | 26 |
/*!40000 ALTER TABLE `businesstypemaster` DISABLE KEYS */; |
27 |
INSERT INTO `businesstypemaster` VALUES (1,1,'???????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,2,'?L?????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,3,'???????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,4,'???????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,5,'???????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,6,'???@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(7,7,'???@?l??c','2019-12-01 00:00:00','2019-12-01 00:00:00'),(8,8,'???@?l???c','2019-12-01 00:00:00','2019-12-01 00:00:00'),(9,9,'?????@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(10,10,'???c?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(11,11,'?????c?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(12,12,'???v???c?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(13,13,'??c?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(14,14,'????c?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(15,15,'???v??c?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(16,16,'?@???@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,17,'?w?Z?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(18,18,'??????@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(19,19,'?X?????@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(20,20,'??????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(21,21,'?????c???????@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,22,'????s???@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,23,'?n??????s???@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,24,'???m?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,25,'?L????C????@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,26,'??????C????@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(27,27,'?s?????m?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(28,28,'?i?@???m?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,29,'????m?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,30,'??????w?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,31,'??????w?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,32,'?_???g???@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(33,33,'????g???@?l','2019-12-01 00:00:00','2019-12-01 00:00:00'),(34,34,'??????J???m?@?l','2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
27 |
INSERT INTO `businesstypemaster` VALUES (1,1,'???????',NOW(),NOW()),(2,2,'?L?????',NOW(),NOW()),(3,3,'???????',NOW(),NOW()),(4,4,'???????',NOW(),NOW()),(5,5,'???????',NOW(),NOW()),(6,6,'???@?l',NOW(),NOW()),(7,7,'???@?l??c',NOW(),NOW()),(8,8,'???@?l???c',NOW(),NOW()),(9,9,'?????@?l',NOW(),NOW()),(10,10,'???c?@?l',NOW(),NOW()),(11,11,'?????c?@?l',NOW(),NOW()),(12,12,'???v???c?@?l',NOW(),NOW()),(13,13,'??c?@?l',NOW(),NOW()),(14,14,'????c?@?l',NOW(),NOW()),(15,15,'???v??c?@?l',NOW(),NOW()),(16,16,'?@???@?l',NOW(),NOW()),(17,17,'?w?Z?@?l',NOW(),NOW()),(18,18,'??????@?l',NOW(),NOW()),(19,19,'?X?????@?l',NOW(),NOW()),(20,20,'??????',NOW(),NOW()),(21,21,'?????c???????@?l',NOW(),NOW()),(22,22,'????s???@?l',NOW(),NOW()),(23,23,'?n??????s???@?l',NOW(),NOW()),(24,24,'???m?@?l',NOW(),NOW()),(25,25,'?L????C????@?l',NOW(),NOW()),(26,26,'??????C????@?l',NOW(),NOW()),(27,27,'?s?????m?@?l',NOW(),NOW()),(28,28,'?i?@???m?@?l',NOW(),NOW()),(29,29,'????m?@?l',NOW(),NOW()),(30,30,'??????w?@?l',NOW(),NOW()),(31,31,'??????w?@?l',NOW(),NOW()),(32,32,'?_???g???@?l',NOW(),NOW()),(33,33,'????g???@?l',NOW(),NOW()),(34,34,'??????J???m?@?l',NOW(),NOW());
|
|
28 | 28 |
/*!40000 ALTER TABLE `businesstypemaster` ENABLE KEYS */; |
29 | 29 |
UNLOCK TABLES; |
30 | 30 |
|
... | ... | |
34 | 34 |
|
35 | 35 |
LOCK TABLES `chgchargedep` WRITE; |
36 | 36 |
/*!40000 ALTER TABLE `chgchargedep` DISABLE KEYS */; |
37 |
INSERT INTO `chgchargedep` VALUES (20181001,'2018-10-01','9999-12-31',1,'?H????','2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
37 |
INSERT INTO `chgchargedep` VALUES (20181001,'2018-10-01','9999-12-31',1,'?H????',NOW(),NOW());
|
|
38 | 38 |
/*!40000 ALTER TABLE `chgchargedep` ENABLE KEYS */; |
39 | 39 |
UNLOCK TABLES; |
40 |
|
|
40 | 41 |
-- |
41 | 42 |
-- Dumping data for table `componentlinkmaster` |
42 | 43 |
-- |
43 | 44 |
|
44 | 45 |
LOCK TABLES `componentlinkmaster` WRITE; |
45 | 46 |
/*!40000 ALTER TABLE `componentlinkmaster` DISABLE KEYS */; |
46 |
INSERT INTO `componentlinkmaster` VALUES (1,1,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,2,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,3,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,4,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,5,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,6,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,7,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,8,9,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,10,10,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,11,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,15,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,16,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,17,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,18,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,19,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,20,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,21,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,20,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,22,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,23,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,24,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,25,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,26,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,27,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,28,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,29,9,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,30,10,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,31,11,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,32,12,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,33,13,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,34,14,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,35,15,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,36,16,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,37,17,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,38,18,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,39,19,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,40,20,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,41,21,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,42,22,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,43,23,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,44,24,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,45,25,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,46,26,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,47,28,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,48,29,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,49,30,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,50,31,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,51,27,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,52,35,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,53,36,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,54,34,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,55,37,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,56,38,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,57,39,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,58,40,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,59,32,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,60,41,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,110,33,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,111,42,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,112,43,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,140,45,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,166,44,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,58,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,61,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,62,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,63,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,64,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,65,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,66,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,58,10,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,67,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,68,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,69,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,70,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,71,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,72,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,73,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,74,9,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,131,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(14,106,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(14,107,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(15,108,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(15,109,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,15,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,16,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,17,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,18,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,19,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,20,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,22,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,23,9,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,24,10,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,25,13,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,26,11,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,27,14,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,28,16,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,29,15,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,30,17,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,31,24,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,32,22,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,33,20,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,34,19,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,35,23,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,36,30,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,37,21,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,38,70,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,39,28,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,40,26,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,41,27,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,42,29,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,43,25,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,44,31,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,45,32,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,46,33,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,47,35,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,48,37,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,49,39,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,50,34,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,51,36,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,52,47,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,53,48,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,54,46,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,55,50,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,56,49,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,57,40,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,59,45,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,60,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,61,51,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,62,52,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,63,53,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,64,54,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,65,55,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,67,56,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,68,57,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,69,58,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,70,59,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,71,60,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,72,61,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,73,62,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,74,63,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,86,41,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,110,44,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,111,42,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,112,68,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,113,64,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,114,65,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,115,66,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,116,43,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,117,12,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,119,72,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,120,71,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,121,69,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,122,67,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,123,74,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,125,38,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,126,73,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,138,75,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,139,76,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,144,77,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,165,18,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(19,14,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,67,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,68,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,69,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,70,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,71,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,72,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,73,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,124,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,61,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,62,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,63,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,64,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,65,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,71,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,72,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,73,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,67,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,68,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,69,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,70,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,71,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,72,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,73,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,123,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,124,9,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,131,14,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,132,10,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,133,11,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,134,12,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,135,13,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,136,15,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,61,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,62,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,63,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,64,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,65,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,71,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,72,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,127,8,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,128,9,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,129,10,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,130,12,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,131,13,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,137,11,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,160,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,161,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,162,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,163,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,164,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,148,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,149,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,150,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,151,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,152,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,153,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,154,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,63,4,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,73,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,155,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,156,3,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,157,5,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,158,6,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,159,7,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,61,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,67,2,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,74,3,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
47 |
INSERT INTO `componentlinkmaster` VALUES (1,1,2,NOW(),NOW()),(1,2,3,NOW(),NOW()),(1,3,4,NOW(),NOW()),(1,4,5,NOW(),NOW()),(1,5,6,NOW(),NOW()),(1,6,7,NOW(),NOW()),(1,7,8,NOW(),NOW()),(1,8,9,NOW(),NOW()),(1,10,10,NOW(),NOW()),(1,11,1,NOW(),NOW()),(2,15,2,NOW(),NOW()),(2,16,3,NOW(),NOW()),(2,17,4,NOW(),NOW()),(2,18,5,NOW(),NOW()),(2,19,6,NOW(),NOW()),(2,20,1,NOW(),NOW()),(2,21,7,NOW(),NOW()),(3,20,2,NOW(),NOW()),(3,22,1,NOW(),NOW()),(3,23,3,NOW(),NOW()),(3,24,4,NOW(),NOW()),(3,25,5,NOW(),NOW()),(3,26,6,NOW(),NOW()),(3,27,7,NOW(),NOW()),(3,28,8,NOW(),NOW()),(3,29,9,NOW(),NOW()),(3,30,10,NOW(),NOW()),(3,31,11,NOW(),NOW()),(3,32,12,NOW(),NOW()),(3,33,13,NOW(),NOW()),(3,34,14,NOW(),NOW()),(3,35,15,NOW(),NOW()),(3,36,16,NOW(),NOW()),(3,37,17,NOW(),NOW()),(3,38,18,NOW(),NOW()),(3,39,19,NOW(),NOW()),(3,40,20,NOW(),NOW()),(3,41,21,NOW(),NOW()),(3,42,22,NOW(),NOW()),(3,43,23,NOW(),NOW()),(3,44,24,NOW(),NOW()),(3,45,25,NOW(),NOW()),(3,46,26,NOW(),NOW()),(3,47,28,NOW(),NOW()),(3,48,29,NOW(),NOW()),(3,49,30,NOW(),NOW()),(3,50,31,NOW(),NOW()),(3,51,27,NOW(),NOW()),(3,52,35,NOW(),NOW()),(3,53,36,NOW(),NOW()),(3,54,34,NOW(),NOW()),(3,55,37,NOW(),NOW()),(3,56,38,NOW(),NOW()),(3,57,39,NOW(),NOW()),(3,58,40,NOW(),NOW()),(3,59,32,NOW(),NOW()),(3,60,41,NOW(),NOW()),(3,110,33,NOW(),NOW()),(3,111,42,NOW(),NOW()),(3,112,43,NOW(),NOW()),(3,140,45,NOW(),NOW()),(3,166,44,NOW(),NOW()),(4,58,7,NOW(),NOW()),(4,61,1,NOW(),NOW()),(4,62,2,NOW(),NOW()),(4,63,3,NOW(),NOW()),(4,64,4,NOW(),NOW()),(4,65,5,NOW(),NOW()),(4,66,6,NOW(),NOW()),(5,58,10,NOW(),NOW()),(5,67,2,NOW(),NOW()),(5,68,3,NOW(),NOW()),(5,69,4,NOW(),NOW()),(5,70,5,NOW(),NOW()),(5,71,6,NOW(),NOW()),(5,72,7,NOW(),NOW()),(5,73,8,NOW(),NOW()),(5,74,9,NOW(),NOW()),(5,131,1,NOW(),NOW()),(14,106,1,NOW(),NOW()),(14,107,2,NOW(),NOW()),(15,108,1,NOW(),NOW()),(15,109,2,NOW(),NOW()),(17,15,2,NOW(),NOW()),(17,16,4,NOW(),NOW()),(17,17,5,NOW(),NOW()),(17,18,7,NOW(),NOW()),(17,19,6,NOW(),NOW()),(17,20,1,NOW(),NOW()),(17,22,8,NOW(),NOW()),(17,23,9,NOW(),NOW()),(17,24,10,NOW(),NOW()),(17,25,13,NOW(),NOW()),(17,26,11,NOW(),NOW()),(17,27,14,NOW(),NOW()),(17,28,16,NOW(),NOW()),(17,29,15,NOW(),NOW()),(17,30,17,NOW(),NOW()),(17,31,24,NOW(),NOW()),(17,32,22,NOW(),NOW()),(17,33,20,NOW(),NOW()),(17,34,19,NOW(),NOW()),(17,35,23,NOW(),NOW()),(17,36,30,NOW(),NOW()),(17,37,21,NOW(),NOW()),(17,38,70,NOW(),NOW()),(17,39,28,NOW(),NOW()),(17,40,26,NOW(),NOW()),(17,41,27,NOW(),NOW()),(17,42,29,NOW(),NOW()),(17,43,25,NOW(),NOW()),(17,44,31,NOW(),NOW()),(17,45,32,NOW(),NOW()),(17,46,33,NOW(),NOW()),(17,47,35,NOW(),NOW()),(17,48,37,NOW(),NOW()),(17,49,39,NOW(),NOW()),(17,50,34,NOW(),NOW()),(17,51,36,NOW(),NOW()),(17,52,47,NOW(),NOW()),(17,53,48,NOW(),NOW()),(17,54,46,NOW(),NOW()),(17,55,50,NOW(),NOW()),(17,56,49,NOW(),NOW()),(17,57,40,NOW(),NOW()),(17,59,45,NOW(),NOW()),(17,60,3,NOW(),NOW()),(17,61,51,NOW(),NOW()),(17,62,52,NOW(),NOW()),(17,63,53,NOW(),NOW()),(17,64,54,NOW(),NOW()),(17,65,55,NOW(),NOW()),(17,67,56,NOW(),NOW()),(17,68,57,NOW(),NOW()),(17,69,58,NOW(),NOW()),(17,70,59,NOW(),NOW()),(17,71,60,NOW(),NOW()),(17,72,61,NOW(),NOW()),(17,73,62,NOW(),NOW()),(17,74,63,NOW(),NOW()),(17,86,41,NOW(),NOW()),(17,110,44,NOW(),NOW()),(17,111,42,NOW(),NOW()),(17,112,68,NOW(),NOW()),(17,113,64,NOW(),NOW()),(17,114,65,NOW(),NOW()),(17,115,66,NOW(),NOW()),(17,116,43,NOW(),NOW()),(17,117,12,NOW(),NOW()),(17,119,72,NOW(),NOW()),(17,120,71,NOW(),NOW()),(17,121,69,NOW(),NOW()),(17,122,67,NOW(),NOW()),(17,123,74,NOW(),NOW()),(17,125,38,NOW(),NOW()),(17,126,73,NOW(),NOW()),(17,138,75,NOW(),NOW()),(17,139,76,NOW(),NOW()),(17,144,77,NOW(),NOW()),(17,165,18,NOW(),NOW()),(19,14,1,NOW(),NOW()),(22,67,1,NOW(),NOW()),(22,68,2,NOW(),NOW()),(22,69,3,NOW(),NOW()),(22,70,4,NOW(),NOW()),(22,71,5,NOW(),NOW()),(22,72,6,NOW(),NOW()),(22,73,7,NOW(),NOW()),(22,124,8,NOW(),NOW()),(23,61,1,NOW(),NOW()),(23,62,2,NOW(),NOW()),(23,63,3,NOW(),NOW()),(23,64,4,NOW(),NOW()),(23,65,5,NOW(),NOW()),(23,71,6,NOW(),NOW()),(23,72,7,NOW(),NOW()),(23,73,8,NOW(),NOW()),(24,67,1,NOW(),NOW()),(24,68,2,NOW(),NOW()),(24,69,3,NOW(),NOW()),(24,70,7,NOW(),NOW()),(24,71,4,NOW(),NOW()),(24,72,5,NOW(),NOW()),(24,73,6,NOW(),NOW()),(24,123,8,NOW(),NOW()),(24,124,9,NOW(),NOW()),(24,131,14,NOW(),NOW()),(24,132,10,NOW(),NOW()),(24,133,11,NOW(),NOW()),(24,134,12,NOW(),NOW()),(24,135,13,NOW(),NOW()),(24,136,15,NOW(),NOW()),(25,61,1,NOW(),NOW()),(25,62,2,NOW(),NOW()),(25,63,3,NOW(),NOW()),(25,64,4,NOW(),NOW()),(25,65,5,NOW(),NOW()),(25,71,6,NOW(),NOW()),(25,72,7,NOW(),NOW()),(25,127,8,NOW(),NOW()),(25,128,9,NOW(),NOW()),(25,129,10,NOW(),NOW()),(25,130,12,NOW(),NOW()),(25,131,13,NOW(),NOW()),(25,137,11,NOW(),NOW()),(26,160,1,NOW(),NOW()),(26,161,2,NOW(),NOW()),(26,162,5,NOW(),NOW()),(26,163,3,NOW(),NOW()),(26,164,4,NOW(),NOW()),(29,148,1,NOW(),NOW()),(29,149,2,NOW(),NOW()),(29,150,3,NOW(),NOW()),(30,151,1,NOW(),NOW()),(30,152,2,NOW(),NOW()),(30,153,3,NOW(),NOW()),(30,154,4,NOW(),NOW()),(31,63,4,NOW(),NOW()),(31,73,2,NOW(),NOW()),(31,155,1,NOW(),NOW()),(31,156,3,NOW(),NOW()),(31,157,5,NOW(),NOW()),(31,158,6,NOW(),NOW()),(31,159,7,NOW(),NOW()),(32,61,1,NOW(),NOW()),(32,67,2,NOW(),NOW()),(32,74,3,NOW(),NOW());
|
|
47 | 48 |
/*!40000 ALTER TABLE `componentlinkmaster` ENABLE KEYS */; |
48 | 49 |
UNLOCK TABLES; |
49 | 50 |
|
... | ... | |
53 | 54 |
|
54 | 55 |
LOCK TABLES `componentmaster` WRITE; |
55 | 56 |
/*!40000 ALTER TABLE `componentmaster` DISABLE KEYS */; |
56 |
INSERT INTO `componentmaster` VALUES (1,13,'???????H????i????????j?????????D?H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,14,'???H????@?????????D?H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,15,'???z?H????@?????????D?H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,17,'?d?C????H????@?????????D?H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,16,'?@?B????H????@?????????D?H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,19,'????????@?????????D?H???p',0,1,1,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(7,20,'???????@?????????D?H???p',0,1,1,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(8,9,'???o??@?????????E???H???p',0,1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,2,'?H????@?????????E???H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(18,18,'???????????@?????????D?H???p',0,1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(19,1,'????H????@?????????E???H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(20,7,'????????@?????????E???H???p',0,1,1,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(21,8,'???????@?????????E???H???p',0,1,1,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,3,'?????H????@?????????E???H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,4,'?d?C?H????@?????????E???H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,5,'?@?B????H????@?????????E???H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,6,'?d?C????H????@?????????E???H???p',1,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,21,'??v??p',1,0,1,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(27,22,'?@??????',0,1,1,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(28,23,'???H????????V?z?p',1,0,0,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,24,'?O???H????????V?z?p',1,0,0,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,25,'?????H????????V?z?p',1,0,0,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,26,'?????????H????????V?z?p',1,0,0,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,27,'??r?H????????V?z?p',1,0,0,1,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(33,28,'????p??????V?z',1,0,1,1,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
57 |
INSERT INTO `componentmaster` VALUES (1,13,'???????H????i????????j?????????D?H???p',1,0,0,0,NOW(),NOW()),(2,14,'???H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(3,15,'???z?H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(4,17,'?d?C????H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(5,16,'?@?B????H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(6,19,'????????@?????????D?H???p',0,1,1,0,NOW(),NOW()),(7,20,'???????@?????????D?H???p',0,1,1,0,NOW(),NOW()),(8,9,'???o??@?????????E???H???p',0,1,0,0,NOW(),NOW()),(17,2,'?H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(18,18,'???????????@?????????D?H???p',0,1,0,0,NOW(),NOW()),(19,1,'????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(20,7,'????????@?????????E???H???p',0,1,1,0,NOW(),NOW()),(21,8,'???????@?????????E???H???p',0,1,1,0,NOW(),NOW()),(22,3,'?????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(23,4,'?d?C?H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(24,5,'?@?B????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(25,6,'?d?C????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(26,21,'??v??p',1,0,1,0,NOW(),NOW()),(27,22,'?@??????',0,1,1,0,NOW(),NOW()),(28,23,'???H????????V?z?p',1,0,0,1,NOW(),NOW()),(29,24,'?O???H????????V?z?p',1,0,0,1,NOW(),NOW()),(30,25,'?????H????????V?z?p',1,0,0,1,NOW(),NOW()),(31,26,'?????????H????????V?z?p',1,0,0,1,NOW(),NOW()),(32,27,'??r?H????????V?z?p',1,0,0,1,NOW(),NOW()),(33,28,'????p??????V?z',1,0,1,1,NOW(),NOW());
|
|
57 | 58 |
/*!40000 ALTER TABLE `componentmaster` ENABLE KEYS */; |
58 | 59 |
UNLOCK TABLES; |
59 | 60 |
|
60 | 61 |
-- |
62 |
-- Dumping data for table `consumptiontax` |
|
63 |
-- |
|
64 |
|
|
65 |
LOCK TABLES `consumptiontax` WRITE; |
|
66 |
/*!40000 ALTER TABLE `consumptiontax` DISABLE KEYS */; |
|
67 |
INSERT INTO `consumptiontax` VALUES ('1989-04-01','1997-03-31',3.00,0,NOW(),NOW()),('1997-04-01','2014-03-31',5.00,0,NOW(),NOW()),('2014-04-01','2019-09-30',8.00,0,NOW(),NOW()),('2019-10-01','9999-12-31',10.00,0,NOW(),NOW()); |
|
68 |
/*!40000 ALTER TABLE `consumptiontax` ENABLE KEYS */; |
|
69 |
UNLOCK TABLES; |
|
70 |
|
|
71 |
-- |
|
61 | 72 |
-- Dumping data for table `constructionitemmaster` |
62 | 73 |
-- |
63 | 74 |
|
64 | 75 |
LOCK TABLES `constructionitemmaster` WRITE; |
65 | 76 |
/*!40000 ALTER TABLE `constructionitemmaster` DISABLE KEYS */; |
66 |
INSERT INTO `constructionitemmaster` VALUES (10,2,'????????????',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(11,1,'???????H???@???W???Z?????',0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(20,4,'???????H????',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,13,'?y?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,14,'?n??H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,16,'?S??H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,17,'?R???N???[?g?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,18,'?^?g?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(27,19,'?S???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(28,20,'?????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,21,'?`?k?b?p?l???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,22,'???o???`?Z?????g??H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,24,'?h???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,25,'??E?^?C???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(33,26,'??H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(35,29,'?????E????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(36,30,'?????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(37,31,'?????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(39,33,'???????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(40,34,'??????????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(41,35,'?V???b?^?[?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(42,36,'?K???X?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(43,38,'?h???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(44,39,'?????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(45,41,'?y?S?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(46,42,'?????d???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(47,44,'???j?b?g?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(50,50,'??????H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(51,43,'???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(86,48,'?A??H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(112,23,'?????R???N???[?g?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(116,40,'?O???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(117,15,'??b?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(119,47,'???O?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(120,37,'????E?K???X?H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(126,49,'?T?C???H??',1,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
77 |
INSERT INTO `constructionitemmaster` VALUES (10,2,'????????????',1,0,0,NOW(),NOW()),(11,1,'???????H???@???W???Z?????',0,0,0,NOW(),NOW()),(20,4,'???????H????',1,0,0,NOW(),NOW()),(22,13,'?y?H??',1,0,0,NOW(),NOW()),(23,14,'?n??H??',1,0,0,NOW(),NOW()),(24,16,'?S??H??',1,0,0,NOW(),NOW()),(25,17,'?R???N???[?g?H??',1,0,0,NOW(),NOW()),(26,18,'?^?g?H??',1,0,0,NOW(),NOW()),(27,19,'?S???H??',1,0,0,NOW(),NOW()),(28,20,'?????H??',1,0,0,NOW(),NOW()),(29,21,'?`?k?b?p?l???H??',1,0,0,NOW(),NOW()),(30,22,'???o???`?Z?????g??H??',1,0,0,NOW(),NOW()),(31,24,'?h???H??',1,0,0,NOW(),NOW()),(32,25,'??E?^?C???H??',1,0,0,NOW(),NOW()),(33,26,'??H??',1,0,0,NOW(),NOW()),(35,29,'?????E????H??',1,0,0,NOW(),NOW()),(36,30,'?????H??',1,0,0,NOW(),NOW()),(37,31,'?????H??',1,0,0,NOW(),NOW()),(39,33,'???????H??',1,0,0,NOW(),NOW()),(40,34,'??????????H??',1,0,0,NOW(),NOW()),(41,35,'?V???b?^?[?H??',1,0,0,NOW(),NOW()),(42,36,'?K???X?H??',1,0,0,NOW(),NOW()),(43,38,'?h???H??',1,0,0,NOW(),NOW()),(44,39,'?????H??',1,0,0,NOW(),NOW()),(45,41,'?y?S?H??',1,0,0,NOW(),NOW()),(46,42,'?????d???H??',1,0,0,NOW(),NOW()),(47,44,'???j?b?g?H??',1,0,0,NOW(),NOW()),(50,50,'??????H??',1,0,0,NOW(),NOW()),(51,43,'???H??',1,0,0,NOW(),NOW()),(86,48,'?A??H??',1,0,0,NOW(),NOW()),(112,23,'?????R???N???[?g?H??',1,0,0,NOW(),NOW()),(116,40,'?O???H??',1,0,0,NOW(),NOW()),(117,15,'??b?H??',1,0,0,NOW(),NOW()),(119,47,'???O?H??',1,0,0,NOW(),NOW()),(120,37,'????E?K???X?H??',1,0,0,NOW(),NOW()),(126,49,'?T?C???H??',1,0,0,NOW(),NOW());
|
|
67 | 78 |
/*!40000 ALTER TABLE `constructionitemmaster` ENABLE KEYS */; |
68 | 79 |
UNLOCK TABLES; |
69 | 80 |
|
... | ... | |
73 | 84 |
|
74 | 85 |
LOCK TABLES `constructiontypemaster` WRITE; |
75 | 86 |
/*!40000 ALTER TABLE `constructiontypemaster` DISABLE KEYS */; |
76 |
INSERT INTO `constructiontypemaster` VALUES (1,1,'?????H???@???C?i?????j',1,2,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,2,'?????H???@?V?z?i?????j',1,1,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,3,'?????H???@???C?i?????j',1,2,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,4,'?????H???@?V?z?i?????j',1,1,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,5,'????H???@???C?i?????j',2,0,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,6,'????H???@?V?z?i?????j',2,0,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(7,7,'????H???@???C?i?????j',2,0,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(8,8,'????H???@?V?z?i?????j',2,0,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(9,9,'??l?q???t?H?[???H???i?????j',2,0,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(10,10,'????V?z?H???i?????j',2,0,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(11,11,'?????A?H??',0,0,4,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(12,12,'???????',0,0,3,0,1,0,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
87 |
INSERT INTO `constructiontypemaster` VALUES (1,1,'?????H???@???C?i?????j',1,2,4,0,0,0,NOW(),NOW()),(2,2,'?????H???@?V?z?i?????j',1,1,4,0,0,0,NOW(),NOW()),(3,3,'?????H???@???C?i?????j',1,2,4,0,0,0,NOW(),NOW()),(4,4,'?????H???@?V?z?i?????j',1,1,4,0,0,0,NOW(),NOW()),(5,5,'????H???@???C?i?????j',2,0,4,0,0,0,NOW(),NOW()),(6,6,'????H???@?V?z?i?????j',2,0,4,0,0,0,NOW(),NOW()),(7,7,'????H???@???C?i?????j',2,0,4,0,0,0,NOW(),NOW()),(8,8,'????H???@?V?z?i?????j',2,0,4,0,0,0,NOW(),NOW()),(9,9,'??l?q???t?H?[???H???i?????j',2,0,4,0,0,0,NOW(),NOW()),(10,10,'????V?z?H???i?????j',2,0,4,0,0,0,NOW(),NOW()),(11,11,'?????A?H??',0,0,4,0,0,0,NOW(),NOW()),(12,12,'???????',0,0,3,0,1,0,NOW(),NOW());
|
|
77 | 88 |
/*!40000 ALTER TABLE `constructiontypemaster` ENABLE KEYS */; |
78 | 89 |
UNLOCK TABLES; |
79 | 90 |
|
... | ... | |
93 | 104 |
|
94 | 105 |
LOCK TABLES `departmentmaster` WRITE; |
95 | 106 |
/*!40000 ALTER TABLE `departmentmaster` DISABLE KEYS */; |
96 |
INSERT INTO `departmentmaster` VALUES (1,1,'?H????',0,0,NOW(),'0001-01-01 00:00:00',0,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
107 |
INSERT INTO `departmentmaster` VALUES (1,1,'?H????',0,0,NOW(),'0001-01-01 00:00:00',0,NOW(),NOW());
|
|
97 | 108 |
/*!40000 ALTER TABLE `departmentmaster` ENABLE KEYS */; |
98 | 109 |
UNLOCK TABLES; |
99 | 110 |
|
... | ... | |
103 | 114 |
|
104 | 115 |
LOCK TABLES `divisionmaster` WRITE; |
105 | 116 |
/*!40000 ALTER TABLE `divisionmaster` DISABLE KEYS */; |
106 |
INSERT INTO `divisionmaster` VALUES (1,1,1,'?@?l?i??????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,2,2,'?@?l?i??????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,3,3,'?@?l?i?a?@?E?????{????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,4,4,'?@?l?i?w?Z?@?l?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,5,5,'?????c??i?e????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,6,6,'???z?m???????E??????m???????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,7,7,'??l?i???j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,8,8,'????g???E??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,9,9,'?X???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(1,10,10,'?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,3,1,'???o??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
117 |
INSERT INTO `divisionmaster` VALUES (1,1,1,'?@?l?i??????j',0,NOW(),NOW()),(1,2,2,'?@?l?i??????j',0,NOW(),NOW()),(1,3,3,'?@?l?i?a?@?E?????{????j',0,NOW(),NOW()),(1,4,4,'?@?l?i?w?Z?@?l?j',0,NOW(),NOW()),(1,5,5,'?????c??i?e????j',0,NOW(),NOW()),(1,6,6,'???z?m???????E??????m???????',0,NOW(),NOW()),(1,7,7,'??l?i???j',0,NOW(),NOW()),(1,8,8,'????g???E??????',0,NOW(),NOW()),(1,9,9,'?X???',0,NOW(),NOW()),(1,10,10,'?????',0,NOW(),NOW()),(3,3,1,'???o??',0,NOW(),NOW());
|
|
107 | 118 |
/*!40000 ALTER TABLE `divisionmaster` ENABLE KEYS */; |
108 | 119 |
UNLOCK TABLES; |
109 | 120 |
|
... | ... | |
123 | 134 |
|
124 | 135 |
LOCK TABLES `personinchargemaster` WRITE; |
125 | 136 |
/*!40000 ALTER TABLE `personinchargemaster` DISABLE KEYS */; |
126 |
INSERT INTO `personinchargemaster` VALUES (20181001,1,'?H???????','?R?E?W?J?????V??',0,'A','0001-01-01','','','','','','','',NOW(),'0001-01-01','20181001',4,1,'','',1,0,0,'','???F??',1,1,0.00,0.0,0.0,0,0,0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
137 |
INSERT INTO `personinchargemaster` VALUES (20181001,1,'?H???????','?R?E?W?J?????V??',0,'A','0001-01-01','','','','','','','',NOW(),'0001-01-01','20181001',4,1,'','',1,0,0,'','???F??',1,1,0.00,0.0,0.0,0,0,0,0,NOW(),NOW());
|
|
127 | 138 |
/*!40000 ALTER TABLE `personinchargemaster` ENABLE KEYS */; |
128 | 139 |
UNLOCK TABLES; |
129 | 140 |
|
... | ... | |
133 | 144 |
|
134 | 145 |
LOCK TABLES `processexcutemaster` WRITE; |
135 | 146 |
/*!40000 ALTER TABLE `processexcutemaster` DISABLE KEYS */; |
136 |
INSERT INTO `processexcutemaster` VALUES (1,1,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,2,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,3,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,4,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,6,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,8,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,9,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,10,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,12,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,13,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,19,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,30,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,31,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,32,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,37,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,39,0,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,40,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,41,0,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,42,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,45,0,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,47,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,101,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,102,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,103,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,104,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,105,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,106,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,107,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,108,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,109,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,110,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,111,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,114,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,117,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,120,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,123,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,125,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,126,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,131,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,132,1,'2019-12-13 19:10:29','2019-12-13 19:10:29'),(1,133,1,'2019-12-13 19:10:29','2019-12-13 19:10:29');
|
|
147 |
INSERT INTO `processexcutemaster` VALUES (1,1,1,NOW(),NOW()),(1,2,1,NOW(),NOW()),(1,3,1,NOW(),NOW()),(1,4,1,NOW(),NOW()),(1,6,1,NOW(),NOW()),(1,8,1,NOW(),NOW()),(1,9,1,NOW(),NOW()),(1,10,1,NOW(),NOW()),(1,12,1,NOW(),NOW()),(1,13,1,NOW(),NOW()),(1,19,1,NOW(),NOW()),(1,30,1,NOW(),NOW()),(1,31,1,NOW(),NOW()),(1,32,1,NOW(),NOW()),(1,37,1,NOW(),NOW()),(1,39,0,NOW(),NOW()),(1,40,1,NOW(),NOW()),(1,41,0,NOW(),NOW()),(1,42,1,NOW(),NOW()),(1,45,0,NOW(),NOW()),(1,47,1,NOW(),NOW()),(1,101,1,NOW(),NOW()),(1,102,1,NOW(),NOW()),(1,103,1,NOW(),NOW()),(1,104,1,NOW(),NOW()),(1,105,1,NOW(),NOW()),(1,106,1,NOW(),NOW()),(1,107,1,NOW(),NOW()),(1,108,1,NOW(),NOW()),(1,109,1,NOW(),NOW()),(1,110,1,NOW(),NOW()),(1,111,1,NOW(),NOW()),(1,114,1,NOW(),NOW()),(1,117,1,NOW(),NOW()),(1,120,1,NOW(),NOW()),(1,123,1,NOW(),NOW()),(1,125,1,NOW(),NOW()),(1,126,1,NOW(),NOW()),(1,131,1,NOW(),NOW()),(1,132,1,NOW(),NOW()),(1,133,1,NOW(),NOW());
|
|
137 | 148 |
/*!40000 ALTER TABLE `processexcutemaster` ENABLE KEYS */; |
138 | 149 |
UNLOCK TABLES; |
139 | 150 |
|
140 | 151 |
-- |
152 |
-- Dumping data for table `recordkey` |
|
153 |
-- |
|
154 |
|
|
155 |
LOCK TABLES `recordkey` WRITE; |
|
156 |
/*!40000 ALTER TABLE `recordkey` DISABLE KEYS */; |
|
157 |
INSERT INTO `recordkey` VALUES (1,0,NOW(),NOW()); |
|
158 |
/*!40000 ALTER TABLE `recordkey` ENABLE KEYS */; |
|
159 |
UNLOCK TABLES; |
|
160 |
|
|
161 |
-- |
|
141 | 162 |
-- Dumping data for table `securitymaster` |
142 | 163 |
-- |
143 | 164 |
|
144 | 165 |
LOCK TABLES `securitymaster` WRITE; |
145 | 166 |
/*!40000 ALTER TABLE `securitymaster` DISABLE KEYS */; |
146 |
INSERT INTO `securitymaster` VALUES (1,1,'?H???????',1,3,1,'0xFFFFFF','2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
167 |
INSERT INTO `securitymaster` VALUES (1,1,'?H???????',1,3,1,'0xFFFFFF',NOW(),NOW());
|
|
147 | 168 |
/*!40000 ALTER TABLE `securitymaster` ENABLE KEYS */; |
148 | 169 |
UNLOCK TABLES; |
149 | 170 |
|
... | ... | |
153 | 174 |
|
154 | 175 |
LOCK TABLES `subcontractoritemmaster` WRITE; |
155 | 176 |
/*!40000 ALTER TABLE `subcontractoritemmaster` DISABLE KEYS */; |
156 |
INSERT INTO `subcontractoritemmaster` VALUES (1,1,'???H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,2,'?A?X?x?X?g????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,3,'???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,4,'????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,5,'?g????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,6,'???????????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(7,7,'??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(8,8,'???z?H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(9,9,'?y??H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(10,10,'?y?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(11,11,'??b?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(12,12,'?Y?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(13,13,'?n?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(14,14,'?????@????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(15,15,'?A?X?t?@???g?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(16,16,'?????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,17,'?S??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(18,18,'?R???N???[?g?R?A?????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(19,19,'?R???N???[?g???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(20,20,'?^?g?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(21,21,'?S???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,22,'?K?X?n??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,23,'?`?k?b?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,24,'???o???`?Z?????g??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,25,'?h???H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,26,'?R?[?L???O?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(27,27,'?h????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(28,28,'?????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,29,'?R???N???[?g?u???b?N?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,30,'?y??H???i?y????????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,31,'?^?C???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,32,'??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(33,33,'??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(34,34,'?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(35,35,'?????E????H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(36,36,'???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(37,37,'????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(38,38,'?T?C?f?B???O?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(39,39,'?????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(40,40,'?G?L?X?p???V????????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(41,41,'?????t???H???i?????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(42,42,'?????t???H???i?f?M??j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(43,43,'???????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(44,44,'?|??????H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(45,45,'?T?b?V?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(46,46,'?V???b?^?[?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(47,47,'?K???X?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(48,48,'?h???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(49,49,'?h?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(50,50,'?????H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(51,51,'?y?S?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(52,52,'?{?[?h?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(53,53,'?A???J?[?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(54,54,'?N???X?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(55,55,'???H???i?????n?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(56,56,'???H???i?t???[?????O?n?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(57,57,'???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(58,58,'??????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(59,59,'??q????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(60,60,'??????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(61,61,'???V??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(62,62,'?V?X?e???V??H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(63,63,'???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(64,64,'?e???g????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(65,65,'OA?t???A?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(66,66,'???????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(67,67,'?_???E?F?[?_?[?E?z?[???d?u',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(68,68,'?N???[?j???O?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(69,69,'?O?\?H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(70,70,'?G?N?X?e???A?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(71,71,'?t?F???X?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(72,72,'?l?b?g?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(73,73,'?O????C?H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(74,74,'??k???C?H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(75,75,'?@?B????H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(76,76,'?????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(77,77,'???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(78,78,'????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(79,79,'?d?C????H????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(80,80,'?z?C?E???C?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(81,81,'?G?A?R???H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(82,82,'???E??????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(83,83,'?{?C???[????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(84,84,'?K?X????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(85,85,'?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(86,86,'???C?????i????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(87,87,'?????n??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(88,88,'?O???n??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(89,89,'?????n??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(90,90,'?y??n??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(91,91,'?z???????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(92,92,'???h????E?h?????{?H???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(93,93,'????@?????i?Z??j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(94,94,'????@?????i??d?E????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(95,95,'???z????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(96,96,'???z????????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(97,97,'???z???????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(98,98,'???z????????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(99,99,'?@?B?H?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(100,100,'?e?????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(101,101,'???O??????E?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(102,102,'?~?[?@?????E????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(103,103,'?z?[???Z???^?[??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(104,104,'?x????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(105,105,'?|???v?i?????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(106,106,'???b?J?[',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(107,107,'?N???[???i?k?d?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(108,108,'???[?X????n',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(109,109,'???[?X????n?E?X',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(110,110,'???[?X??????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(111,111,'???[?X????????????i',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(112,112,'?S???h??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(113,113,'?Y??p????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(114,114,'?Q?????E?h?a????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(115,115,'?R?s?[?E???{',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(116,116,'?e???????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(117,117,'??v??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(118,118,'??v???????i?\???j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(119,119,'?????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(120,120,'?s???Y??W',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(121,121,'?s?????m',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(122,122,'?i?@???m',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(123,123,'???m??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(124,124,'???@??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(125,125,'??p??i???j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(126,126,'??p??i?????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(127,127,'???~????i?d?u?j?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(128,128,'?\?D',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(129,129,'?e????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(130,130,'?s???Y??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(131,131,'??????p???~?@',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(132,132,'?Z?????r??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(133,133,'?v???n?u?V?z?E???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(134,134,'???????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(135,135,'??j???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(136,136,'?O?\????E??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(137,137,'???z??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(138,138,'????J????????E?{?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(139,139,'?????????E?C??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(140,140,'?p???E?p?t??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(141,141,'????H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
177 |
INSERT INTO `subcontractoritemmaster` VALUES (1,1,'???H????',0,NOW(),NOW()),(2,2,'?A?X?x?X?g????????',0,NOW(),NOW()),(3,3,'???H??',0,NOW(),NOW()),(4,4,'????H??',0,NOW(),NOW()),(5,5,'?g????H??',0,NOW(),NOW()),(6,6,'???????????H??',0,NOW(),NOW()),(7,7,'??H??',0,NOW(),NOW()),(8,8,'???z?H????',0,NOW(),NOW()),(9,9,'?y??H????',0,NOW(),NOW()),(10,10,'?y?H??',0,NOW(),NOW()),(11,11,'??b?H??',0,NOW(),NOW()),(12,12,'?Y?H??',0,NOW(),NOW()),(13,13,'?n?????',0,NOW(),NOW()),(14,14,'?????@????',0,NOW(),NOW()),(15,15,'?A?X?t?@???g?H??',0,NOW(),NOW()),(16,16,'?????H??',0,NOW(),NOW()),(17,17,'?S??H??',0,NOW(),NOW()),(18,18,'?R???N???[?g?R?A?????H??',0,NOW(),NOW()),(19,19,'?R???N???[?g???',0,NOW(),NOW()),(20,20,'?^?g?H??',0,NOW(),NOW()),(21,21,'?S???H??',0,NOW(),NOW()),(22,22,'?K?X?n??H??',0,NOW(),NOW()),(23,23,'?`?k?b?H??',0,NOW(),NOW()),(24,24,'???o???`?Z?????g??H??',0,NOW(),NOW()),(25,25,'?h???H????',0,NOW(),NOW()),(26,26,'?R?[?L???O?H??',0,NOW(),NOW()),(27,27,'?h????????',0,NOW(),NOW()),(28,28,'?????H??',0,NOW(),NOW()),(29,29,'?R???N???[?g?u???b?N?H??',0,NOW(),NOW()),(30,30,'?y??H???i?y????????j',0,NOW(),NOW()),(31,31,'?^?C???H??',0,NOW(),NOW()),(32,32,'??H??',0,NOW(),NOW()),(33,33,'??H??',0,NOW(),NOW()),(34,34,'?????H',0,NOW(),NOW()),(35,35,'?????E????H????',0,NOW(),NOW()),(36,36,'???H??',0,NOW(),NOW()),(37,37,'????H??',0,NOW(),NOW()),(38,38,'?T?C?f?B???O?H??',0,NOW(),NOW()),(39,39,'?????H??',0,NOW(),NOW()),(40,40,'?G?L?X?p???V????????E?H??',0,NOW(),NOW()),(41,41,'?????t???H???i?????j',0,NOW(),NOW()),(42,42,'?????t???H???i?f?M??j',0,NOW(),NOW()),(43,43,'???????H??',0,NOW(),NOW()),(44,44,'?|??????H????',0,NOW(),NOW()),(45,45,'?T?b?V?H??',0,NOW(),NOW()),(46,46,'?V???b?^?[?H??',0,NOW(),NOW()),(47,47,'?K???X?H??',0,NOW(),NOW()),(48,48,'?h???H??',0,NOW(),NOW()),(49,49,'?h?????',0,NOW(),NOW()),(50,50,'?????H????',0,NOW(),NOW()),(51,51,'?y?S?H??',0,NOW(),NOW()),(52,52,'?{?[?h?H??',0,NOW(),NOW()),(53,53,'?A???J?[?H??',0,NOW(),NOW()),(54,54,'?N???X?H??',0,NOW(),NOW()),(55,55,'???H???i?????n?j',0,NOW(),NOW()),(56,56,'???H???i?t???[?????O?n?j',0,NOW(),NOW()),(57,57,'???H??',0,NOW(),NOW()),(58,58,'??????E?H??',0,NOW(),NOW()),(59,59,'??q????E?H??',0,NOW(),NOW()),(60,60,'??????E?H??',0,NOW(),NOW()),(61,61,'???V??H??',0,NOW(),NOW()),(62,62,'?V?X?e???V??H??',0,NOW(),NOW()),(63,63,'???H??',0,NOW(),NOW()),(64,64,'?e???g????E?H??',0,NOW(),NOW()),(65,65,'OA?t???A?H??',0,NOW(),NOW()),(66,66,'???????E?H??',0,NOW(),NOW()),(67,67,'?_???E?F?[?_?[?E?z?[???d?u',0,NOW(),NOW()),(68,68,'?N???[?j???O?H??',0,NOW(),NOW()),(69,69,'?O?\?H????',0,NOW(),NOW()),(70,70,'?G?N?X?e???A?H??',0,NOW(),NOW()),(71,71,'?t?F???X?H??',0,NOW(),NOW()),(72,72,'?l?b?g?H??',0,NOW(),NOW()),(73,73,'?O????C?H????',0,NOW(),NOW()),(74,74,'??k???C?H????',0,NOW(),NOW()),(75,75,'?@?B????H????',0,NOW(),NOW()),(76,76,'?????H??',0,NOW(),NOW()),(77,77,'???H??',0,NOW(),NOW()),(78,78,'????H??',0,NOW(),NOW()),(79,79,'?d?C????H????',0,NOW(),NOW()),(80,80,'?z?C?E???C?H??',0,NOW(),NOW()),(81,81,'?G?A?R???H??',0,NOW(),NOW()),(82,82,'???E??????H??',0,NOW(),NOW()),(83,83,'?{?C???[????H??',0,NOW(),NOW()),(84,84,'?K?X????H??',0,NOW(),NOW()),(85,85,'?????',0,NOW(),NOW()),(86,86,'???C?????i????j',0,NOW(),NOW()),(87,87,'?????n??????',0,NOW(),NOW()),(88,88,'?O???n??????',0,NOW(),NOW()),(89,89,'?????n??????',0,NOW(),NOW()),(90,90,'?y??n??????',0,NOW(),NOW()),(91,91,'?z???????',0,NOW(),NOW()),(92,92,'???h????E?h?????{?H???',0,NOW(),NOW()),(93,93,'????@?????i?Z??j',0,NOW(),NOW()),(94,94,'????@?????i??d?E????j',0,NOW(),NOW()),(95,95,'???z????????',0,NOW(),NOW()),(96,96,'???z????????E?H??',0,NOW(),NOW()),(97,97,'???z???????',0,NOW(),NOW()),(98,98,'???z????????E?H??',0,NOW(),NOW()),(99,99,'?@?B?H?????',0,NOW(),NOW()),(100,100,'?e?????????',0,NOW(),NOW()),(101,101,'???O??????E?H??',0,NOW(),NOW()),(102,102,'?~?[?@?????E????',0,NOW(),NOW()),(103,103,'?z?[???Z???^?[??',0,NOW(),NOW()),(104,104,'?x????',0,NOW(),NOW()),(105,105,'?|???v?i?????j',0,NOW(),NOW()),(106,106,'???b?J?[',0,NOW(),NOW()),(107,107,'?N???[???i?k?d?j',0,NOW(),NOW()),(108,108,'???[?X????n',0,NOW(),NOW()),(109,109,'???[?X????n?E?X',0,NOW(),NOW()),(110,110,'???[?X??????????',0,NOW(),NOW()),(111,111,'???[?X????????????i',0,NOW(),NOW()),(112,112,'?S???h??',0,NOW(),NOW()),(113,113,'?Y??p????????',0,NOW(),NOW()),(114,114,'?Q?????E?h?a????',0,NOW(),NOW()),(115,115,'?R?s?[?E???{',0,NOW(),NOW()),(116,116,'?e???????',0,NOW(),NOW()),(117,117,'??v??????',0,NOW(),NOW()),(118,118,'??v???????i?\???j',0,NOW(),NOW()),(119,119,'?????????',0,NOW(),NOW()),(120,120,'?s???Y??W',0,NOW(),NOW()),(121,121,'?s?????m',0,NOW(),NOW()),(122,122,'?i?@???m',0,NOW(),NOW()),(123,123,'???m??????',0,NOW(),NOW()),(124,124,'???@??',0,NOW(),NOW()),(125,125,'??p??i???j',0,NOW(),NOW()),(126,126,'??p??i?????j',0,NOW(),NOW()),(127,127,'???~????i?d?u?j?H??',0,NOW(),NOW()),(128,128,'?\?D',0,NOW(),NOW()),(129,129,'?e????',0,NOW(),NOW()),(130,130,'?s???Y??',0,NOW(),NOW()),(131,131,'??????p???~?@',0,NOW(),NOW()),(132,132,'?Z?????r??????',0,NOW(),NOW()),(133,133,'?v???n?u?V?z?E???',0,NOW(),NOW()),(134,134,'???????????',0,NOW(),NOW()),(135,135,'??j???',0,NOW(),NOW()),(136,136,'?O?\????E??????',0,NOW(),NOW()),(137,137,'???z??????',0,NOW(),NOW()),(138,138,'????J????????E?{?H',0,NOW(),NOW()),(139,139,'?????????E?C??',0,NOW(),NOW()),(140,140,'?p???E?p?t??????',0,NOW(),NOW()),(141,141,'????H??',0,NOW(),NOW());
|
|
157 | 178 |
/*!40000 ALTER TABLE `subcontractoritemmaster` ENABLE KEYS */; |
158 | 179 |
UNLOCK TABLES; |
180 |
|
|
159 | 181 |
-- |
160 | 182 |
-- Dumping data for table `subcontractorjobcategory` |
161 | 183 |
-- |
162 | 184 |
|
163 | 185 |
LOCK TABLES `subcontractorjobcategory` WRITE; |
164 | 186 |
/*!40000 ALTER TABLE `subcontractorjobcategory` DISABLE KEYS */; |
165 |
INSERT INTO `subcontractorjobcategory` VALUES (1,1,'????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,2,'???U????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,3,'????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,4,'???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,5,'??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,6,'??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(7,7,'?d???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(8,8,'?y?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(9,9,'????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(10,10,'?J?b?^?[?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(11,11,'?Y?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(12,12,'??C?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(13,13,'?G?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(14,14,'?^?g??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(15,15,'?^?g???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(16,16,'?S??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,17,'??b?H??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(18,18,'?S???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(19,19,'?b???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(20,20,'?K?X?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(21,21,'?`?k?b?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,22,'?A???J?[?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,23,'?R?A?[?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,24,'?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,25,'?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,26,'??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(27,27,'?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(28,28,'?^?C???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,29,'??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,30,'?h???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,31,'?V?[???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,32,'???n??C?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(33,33,'???????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(34,34,'?|??????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(35,35,'?K???X?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(36,36,'?????E??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(37,37,'????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(38,38,'?h???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(39,39,'???t?H?i?h???j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(40,40,'?f?M?H?i???t?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(41,41,'?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(42,42,'??g???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(43,43,'?????d???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(44,44,'???j?b?g?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(45,45,'?p?l???H?i???z?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(46,46,'???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(47,47,'?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(48,48,'???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(49,49,'?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(50,50,'?d?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(51,51,'?????d?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(52,52,'??d?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(53,53,'???r??????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(54,54,'?@?B????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(55,55,'?????H?i???C?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(56,56,'?????H?i?G?A?R???j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(57,57,'?f?M?H?i?z?????n?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(58,58,'?K?X?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(59,59,'?{?C???[?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(60,60,'???????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(61,61,'?p?l???H?i????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(62,62,'?|???v?????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(63,63,'???b?J?[',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(64,64,'?k?d?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(65,65,'????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(66,66,'?h???A?h?a',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(67,67,'?Z??@??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(68,68,'?S?~????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(69,69,'????n?E?X?E?v?b?E??????[?X',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(70,70,'????@???[?X',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(71,71,'???z??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(72,72,'??p??i?????j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(73,73,'??p??i?H???j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(74,74,'??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(75,75,'?e????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(76,76,'??v??????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(77,77,'?h????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(78,78,'?x???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(79,79,'?s???Y?c??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(80,80,'?y?S?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(81,81,'??C?H?i???y?A?[?j',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(82,82,'?h????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(83,83,'?O?\?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(84,84,'???H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(85,85,'?l?b?g?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(86,86,'???z??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(87,87,'????E?z???C?g?{?[?h',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(88,88,'?V???u?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(89,89,'??????p???~?@?E??u?E???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(90,90,'?~?[?@?????E??u',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(91,91,'???????E?@????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(92,92,'?R?s?[?E???{',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(93,93,'?n?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(94,94,'?e???g?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(95,95,'??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(96,96,'?t?F???X??t?H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(97,97,'?A?X?x?X?g??W????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(98,98,'?s?????m',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(99,99,'?i?@???m',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(100,100,'????H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(101,101,'?R???N???[?g?z???A???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(102,102,'?Z?????r?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(103,103,'?v???n?u?V?z?E???',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(104,104,'?H??E???z???S???????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(105,105,'??j?????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(106,106,'?O?\????E????????',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(107,107,'?g??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(108,108,'?????????E?C??',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(109,109,'????m',0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(110,110,'?O??H',0,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
187 |
INSERT INTO `subcontractorjobcategory` VALUES (1,1,'????',0,NOW(),NOW()),(2,2,'???U????',0,NOW(),NOW()),(3,3,'????H',0,NOW(),NOW()),(4,4,'???H',0,NOW(),NOW()),(5,5,'??H',0,NOW(),NOW()),(6,6,'??H',0,NOW(),NOW()),(7,7,'?d???H',0,NOW(),NOW()),(8,8,'?y?H',0,NOW(),NOW()),(9,9,'????H',0,NOW(),NOW()),(10,10,'?J?b?^?[?H',0,NOW(),NOW()),(11,11,'?Y?H',0,NOW(),NOW()),(12,12,'??C?H',0,NOW(),NOW()),(13,13,'?G?H',0,NOW(),NOW()),(14,14,'?^?g??H',0,NOW(),NOW()),(15,15,'?^?g???H',0,NOW(),NOW()),(16,16,'?S??H',0,NOW(),NOW()),(17,17,'??b?H??',0,NOW(),NOW()),(18,18,'?S???H',0,NOW(),NOW()),(19,19,'?b???H',0,NOW(),NOW()),(20,20,'?K?X?H',0,NOW(),NOW()),(21,21,'?`?k?b?H',0,NOW(),NOW()),(22,22,'?A???J?[?H',0,NOW(),NOW()),(23,23,'?R?A?[?H',0,NOW(),NOW()),(24,24,'?????H',0,NOW(),NOW()),(25,25,'?????H',0,NOW(),NOW()),(26,26,'??H',0,NOW(),NOW()),(27,27,'?????H',0,NOW(),NOW()),(28,28,'?^?C???H',0,NOW(),NOW()),(29,29,'??H',0,NOW(),NOW()),(30,30,'?h???H',0,NOW(),NOW()),(31,31,'?V?[???H',0,NOW(),NOW()),(32,32,'???n??C?H',0,NOW(),NOW()),(33,33,'???????H',0,NOW(),NOW()),(34,34,'?|??????H',0,NOW(),NOW()),(35,35,'?K???X?H',0,NOW(),NOW()),(36,36,'?????E??H',0,NOW(),NOW()),(37,37,'????H',0,NOW(),NOW()),(38,38,'?h???H',0,NOW(),NOW()),(39,39,'???t?H?i?h???j',0,NOW(),NOW()),(40,40,'?f?M?H?i???t?j',0,NOW(),NOW()),(41,41,'?????H',0,NOW(),NOW()),(42,42,'??g???H',0,NOW(),NOW()),(43,43,'?????d???H',0,NOW(),NOW()),(44,44,'???j?b?g?H',0,NOW(),NOW()),(45,45,'?p?l???H?i???z?j',0,NOW(),NOW()),(46,46,'???H',0,NOW(),NOW()),(47,47,'?????H',0,NOW(),NOW()),(48,48,'???H',0,NOW(),NOW()),(49,49,'?????H',0,NOW(),NOW()),(50,50,'?d?H',0,NOW(),NOW()),(51,51,'?????d?H',0,NOW(),NOW()),(52,52,'??d?H',0,NOW(),NOW()),(53,53,'???r??????H',0,NOW(),NOW()),(54,54,'?@?B????H',0,NOW(),NOW()),(55,55,'?????H?i???C?j',0,NOW(),NOW()),(56,56,'?????H?i?G?A?R???j',0,NOW(),NOW()),(57,57,'?f?M?H?i?z?????n?j',0,NOW(),NOW()),(58,58,'?K?X?H',0,NOW(),NOW()),(59,59,'?{?C???[?H',0,NOW(),NOW()),(60,60,'???????H',0,NOW(),NOW()),(61,61,'?p?l???H?i????j',0,NOW(),NOW()),(62,62,'?|???v?????H',0,NOW(),NOW()),(63,63,'???b?J?[',0,NOW(),NOW()),(64,64,'?k?d?H',0,NOW(),NOW()),(65,65,'????',0,NOW(),NOW()),(66,66,'?h???A?h?a',0,NOW(),NOW()),(67,67,'?Z??@??',0,NOW(),NOW()),(68,68,'?S?~????',0,NOW(),NOW()),(69,69,'????n?E?X?E?v?b?E??????[?X',0,NOW(),NOW()),(70,70,'????@???[?X',0,NOW(),NOW()),(71,71,'???z??????',0,NOW(),NOW()),(72,72,'??p??i?????j',0,NOW(),NOW()),(73,73,'??p??i?H???j',0,NOW(),NOW()),(74,74,'??????',0,NOW(),NOW()),(75,75,'?e????',0,NOW(),NOW()),(76,76,'??v??????',0,NOW(),NOW()),(77,77,'?h????????',0,NOW(),NOW()),(78,78,'?x???H',0,NOW(),NOW()),(79,79,'?s???Y?c??',0,NOW(),NOW()),(80,80,'?y?S?H',0,NOW(),NOW()),(81,81,'??C?H?i???y?A?[?j',0,NOW(),NOW()),(82,82,'?h????????',0,NOW(),NOW()),(83,83,'?O?\?H',0,NOW(),NOW()),(84,84,'???H',0,NOW(),NOW()),(85,85,'?l?b?g?H',0,NOW(),NOW()),(86,86,'???z??',0,NOW(),NOW()),(87,87,'????E?z???C?g?{?[?h',0,NOW(),NOW()),(88,88,'?V???u?H',0,NOW(),NOW()),(89,89,'??????p???~?@?E??u?E???',0,NOW(),NOW()),(90,90,'?~?[?@?????E??u',0,NOW(),NOW()),(91,91,'???????E?@????',0,NOW(),NOW()),(92,92,'?R?s?[?E???{',0,NOW(),NOW()),(93,93,'?n?????',0,NOW(),NOW()),(94,94,'?e???g?H',0,NOW(),NOW()),(95,95,'??H',0,NOW(),NOW()),(96,96,'?t?F???X??t?H',0,NOW(),NOW()),(97,97,'?A?X?x?X?g??W????',0,NOW(),NOW()),(98,98,'?s?????m',0,NOW(),NOW()),(99,99,'?i?@???m',0,NOW(),NOW()),(100,100,'????H',0,NOW(),NOW()),(101,101,'?R???N???[?g?z???A???',0,NOW(),NOW()),(102,102,'?Z?????r?????',0,NOW(),NOW()),(103,103,'?v???n?u?V?z?E???',0,NOW(),NOW()),(104,104,'?H??E???z???S???????',0,NOW(),NOW()),(105,105,'??j?????',0,NOW(),NOW()),(106,106,'?O?\????E????????',0,NOW(),NOW()),(107,107,'?g??H',0,NOW(),NOW()),(108,108,'?????????E?C??',0,NOW(),NOW()),(109,109,'????m',0,NOW(),NOW()),(110,110,'?O??H',0,NOW(),NOW());
|
|
166 | 188 |
/*!40000 ALTER TABLE `subcontractorjobcategory` ENABLE KEYS */; |
167 | 189 |
UNLOCK TABLES; |
168 | 190 |
|
... | ... | |
172 | 194 |
|
173 | 195 |
LOCK TABLES `systemexecute` WRITE; |
174 | 196 |
/*!40000 ALTER TABLE `systemexecute` DISABLE KEYS */; |
175 |
INSERT INTO `systemexecute` VALUES (1,'2018-10-03',0,0,'2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,'2017-02-27',228,2,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
197 |
INSERT INTO `systemexecute` VALUES (1,'2019-12-01',0,0,NOW(),NOW()),(2,'2019-12-01',1,1,NOW(),NOW());
|
|
176 | 198 |
/*!40000 ALTER TABLE `systemexecute` ENABLE KEYS */; |
177 | 199 |
UNLOCK TABLES; |
178 | 200 |
|
... | ... | |
182 | 204 |
|
183 | 205 |
LOCK TABLES `systemmaster` WRITE; |
184 | 206 |
/*!40000 ALTER TABLE `systemmaster` DISABLE KEYS */; |
185 |
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,'2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
207 |
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,NOW(),NOW());
|
|
186 | 208 |
/*!40000 ALTER TABLE `systemmaster` ENABLE KEYS */; |
187 | 209 |
UNLOCK TABLES; |
188 | 210 |
|
... | ... | |
192 | 214 |
|
193 | 215 |
LOCK TABLES `unitmaster` WRITE; |
194 | 216 |
/*!40000 ALTER TABLE `unitmaster` DISABLE KEYS */; |
195 |
INSERT INTO `unitmaster` VALUES (1,2,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(2,28,'???j?b?g','2019-12-01 00:00:00','2019-12-01 00:00:00'),(3,26,'?p?b?N','2019-12-01 00:00:00','2019-12-01 00:00:00'),(4,27,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(5,21,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(6,29,'????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(7,30,'????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(8,18,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(9,31,'?n??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(10,7,'????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(11,32,'?X?p??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(12,33,'?p??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(13,15,'????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(14,1,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(15,34,'?A','2019-12-01 00:00:00','2019-12-01 00:00:00'),(16,16,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(17,35,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(18,36,'???E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(19,9,'?????Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(20,37,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(21,38,'???E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(22,3,'???Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(23,14,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(24,39,'???Q?E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(25,40,'?????Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(26,23,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(27,41,'?X?p????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(28,8,'?????Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(29,13,'?g','2019-12-01 00:00:00','2019-12-01 00:00:00'),(30,42,'???X?p??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(31,10,'?????Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(32,19,'?{','2019-12-01 00:00:00','2019-12-01 00:00:00'),(33,43,'??E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(34,44,'???????Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(35,45,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(36,46,'???E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(37,47,'???k','2019-12-01 00:00:00','2019-12-01 00:00:00'),(38,48,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(39,49,'?{?E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(40,50,'?k','2019-12-01 00:00:00','2019-12-01 00:00:00'),(41,20,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(42,51,'?g?E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(43,4,'???R','2019-12-01 00:00:00','2019-12-01 00:00:00'),(44,52,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(45,53,'??E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(46,5,'??R','2019-12-01 00:00:00','2019-12-01 00:00:00'),(47,54,'?Z?b?g','2019-12-01 00:00:00','2019-12-01 00:00:00'),(48,55,'???E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(49,56,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(50,57,'?L?b?g','2019-12-01 00:00:00','2019-12-01 00:00:00'),(51,58,'?Z?b?g??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(52,59,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(53,22,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(54,60,'???Q?E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(55,61,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(56,62,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(57,63,'??E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(58,64,'????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(59,6,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(60,65,'??E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(61,66,'?E','2019-12-01 00:00:00','2019-12-01 00:00:00'),(62,67,'???','2019-12-01 00:00:00','2019-12-01 00:00:00'),(63,11,'????Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(64,24,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(65,68,'?????O','2019-12-01 00:00:00','2019-12-01 00:00:00'),(66,12,'????Q','2019-12-01 00:00:00','2019-12-01 00:00:00'),(67,69,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(68,70,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(69,71,'???Q?E??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(70,72,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(71,73,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(72,74,'?S????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(73,75,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(74,25,'?P?[?X','2019-12-01 00:00:00','2019-12-01 00:00:00'),(75,76,'???X?p??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(76,77,'?o','2019-12-01 00:00:00','2019-12-01 00:00:00'),(77,78,'????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(78,79,'?|?C???g','2019-12-01 00:00:00','2019-12-01 00:00:00'),(79,80,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(80,17,'????','2019-12-01 00:00:00','2019-12-01 00:00:00'),(81,81,'??','2019-12-01 00:00:00','2019-12-01 00:00:00'),(82,82,'???','2019-12-01 00:00:00','2019-12-01 00:00:00');
|
|
217 |
INSERT INTO `unitmaster` VALUES (1,2,'??',NOW(),NOW()),(2,28,'???j?b?g',NOW(),NOW()),(3,26,'?p?b?N',NOW(),NOW()),(4,27,'??',NOW(),NOW()),(5,21,'??',NOW(),NOW()),(6,29,'????',NOW(),NOW()),(7,30,'????',NOW(),NOW()),(8,18,'??',NOW(),NOW()),(9,31,'?n??',NOW(),NOW()),(10,7,'????',NOW(),NOW()),(11,32,'?X?p??',NOW(),NOW()),(12,33,'?p??',NOW(),NOW()),(13,15,'????',NOW(),NOW()),(14,1,'??',NOW(),NOW()),(15,34,'?A',NOW(),NOW()),(16,16,'??',NOW(),NOW()),(17,35,'??',NOW(),NOW()),(18,36,'???E??',NOW(),NOW()),(19,9,'?????Q',NOW(),NOW()),(20,37,'??',NOW(),NOW()),(21,38,'???E??',NOW(),NOW()),(22,3,'???Q',NOW(),NOW()),(23,14,'??',NOW(),NOW()),(24,39,'???Q?E??',NOW(),NOW()),(25,40,'?????Q',NOW(),NOW()),(26,23,'??',NOW(),NOW()),(27,41,'?X?p????',NOW(),NOW()),(28,8,'?????Q',NOW(),NOW()),(29,13,'?g',NOW(),NOW()),(30,42,'???X?p??',NOW(),NOW()),(31,10,'?????Q',NOW(),NOW()),(32,19,'?{',NOW(),NOW()),(33,43,'??E??',NOW(),NOW()),(34,44,'???????Q',NOW(),NOW()),(35,45,'??',NOW(),NOW()),(36,46,'???E??',NOW(),NOW()),(37,47,'???k',NOW(),NOW()),(38,48,'??',NOW(),NOW()),(39,49,'?{?E??',NOW(),NOW()),(40,50,'?k',NOW(),NOW()),(41,20,'??',NOW(),NOW()),(42,51,'?g?E??',NOW(),NOW()),(43,4,'???R',NOW(),NOW()),(44,52,'??',NOW(),NOW()),(45,53,'??E??',NOW(),NOW()),(46,5,'??R',NOW(),NOW()),(47,54,'?Z?b?g',NOW(),NOW()),(48,55,'???E??',NOW(),NOW()),(49,56,'??',NOW(),NOW()),(50,57,'?L?b?g',NOW(),NOW()),(51,58,'?Z?b?g??',NOW(),NOW()),(52,59,'??',NOW(),NOW()),(53,22,'??',NOW(),NOW()),(54,60,'???Q?E??',NOW(),NOW()),(55,61,'??',NOW(),NOW()),(56,62,'??',NOW(),NOW()),(57,63,'??E??',NOW(),NOW()),(58,64,'????',NOW(),NOW()),(59,6,'??',NOW(),NOW()),(60,65,'??E??',NOW(),NOW()),(61,66,'?E',NOW(),NOW()),(62,67,'???',NOW(),NOW()),(63,11,'????Q',NOW(),NOW()),(64,24,'??',NOW(),NOW()),(65,68,'?????O',NOW(),NOW()),(66,12,'????Q',NOW(),NOW()),(67,69,'??',NOW(),NOW()),(68,70,'??',NOW(),NOW()),(69,71,'???Q?E??',NOW(),NOW()),(70,72,'??',NOW(),NOW()),(71,73,'??',NOW(),NOW()),(72,74,'?S????',NOW(),NOW()),(73,75,'??',NOW(),NOW()),(74,25,'?P?[?X',NOW(),NOW()),(75,76,'???X?p??',NOW(),NOW()),(76,77,'?o',NOW(),NOW()),(77,78,'????',NOW(),NOW()),(78,79,'?|?C???g',NOW(),NOW()),(79,80,'??',NOW(),NOW()),(80,17,'????',NOW(),NOW()),(81,81,'??',NOW(),NOW()),(82,82,'???',NOW(),NOW());
|
|
196 | 218 |
/*!40000 ALTER TABLE `unitmaster` ENABLE KEYS */; |
197 | 219 |
UNLOCK TABLES; |
198 |
; |
|
220 |
|
|
199 | 221 |
-- |
200 | 222 |
-- Dumping data for table `yearmaster` |
201 | 223 |
-- |
trunk/ddl/ProductType2.SQL | ||
---|---|---|
1 |
-- |
|
2 |
-- Dumping data for table `budgetsumcode` |
|
3 |
-- |
|
4 |
|
|
5 |
LOCK TABLES `budgetsumcode` WRITE; |
|
6 |
/*!40000 ALTER TABLE `budgetsumcode` DISABLE KEYS */; |
|
7 |
INSERT INTO `budgetsumcode` VALUES (1,0,1,0,'???????H????i????????j?????????D?H???p',NOW(),NOW()),(1,0,2,0,'???H????@?????????D?H???p',NOW(),NOW()),(1,0,3,0,'???z?H????@?????????D?H???p',NOW(),NOW()),(1,0,4,0,'?d?C????H????@?????????D?H???p',NOW(),NOW()),(1,0,5,0,'?@?B????H????@?????????D?H???p',NOW(),NOW()),(1,0,6,0,'????????@?????????D?H???p',NOW(),NOW()),(1,0,7,0,'???????@?????????D?H???p',NOW(),NOW()),(1,0,18,0,'???????????@?????????D?H???p',NOW(),NOW()),(2,1,18,0,'???????????@?????????D?H???p',NOW(),NOW()),(3,2,7,0,'???????@?????????D?H???p',NOW(),NOW()),(3,2,8,0,'???o??@?????????E???H???p',NOW(),NOW()),(3,2,21,0,'???????@?????????E???H???p',NOW(),NOW()),(4,3,6,0,'????????@?????????D?H???p',NOW(),NOW()),(4,3,20,0,'????????@?????????E???H???p',NOW(),NOW()),(5,4,1,0,'???????H????i????????j?????????D?H???p',NOW(),NOW()),(5,4,1,10,'????????????@???????H??',NOW(),NOW()),(6,5,2,0,'???H????@?????????D?H???p',NOW(),NOW()),(6,6,3,0,'???z?H????@?????????D?H???p',NOW(),NOW()),(6,7,4,0,'?d?C????H????@?????????D?H???p',NOW(),NOW()),(6,8,5,0,'?@?B????H????@?????????D?H???p',NOW(),NOW()); |
|
8 |
/*!40000 ALTER TABLE `budgetsumcode` ENABLE KEYS */; |
|
9 |
UNLOCK TABLES; |
|
10 |
|
|
11 |
-- |
|
12 |
-- Dumping data for table `businesstypemaster` |
|
13 |
-- |
|
14 |
|
|
15 |
LOCK TABLES `businesstypemaster` WRITE; |
|
16 |
/*!40000 ALTER TABLE `businesstypemaster` DISABLE KEYS */; |
|
17 |
INSERT INTO `businesstypemaster` VALUES (1,1,'???????',NOW(),NOW()),(2,2,'?L?????',NOW(),NOW()),(3,3,'???????',NOW(),NOW()),(4,4,'???????',NOW(),NOW()),(5,5,'???????',NOW(),NOW()),(6,6,'???@?l',NOW(),NOW()),(7,7,'???@?l??c',NOW(),NOW()),(8,8,'???@?l???c',NOW(),NOW()),(9,9,'?????@?l',NOW(),NOW()),(10,10,'???c?@?l',NOW(),NOW()),(11,11,'?????c?@?l',NOW(),NOW()),(12,12,'???v???c?@?l',NOW(),NOW()),(13,13,'??c?@?l',NOW(),NOW()),(14,14,'????c?@?l',NOW(),NOW()),(15,15,'???v??c?@?l',NOW(),NOW()),(16,16,'?@???@?l',NOW(),NOW()),(17,17,'?w?Z?@?l',NOW(),NOW()),(18,18,'??????@?l',NOW(),NOW()),(19,19,'?X?????@?l',NOW(),NOW()),(20,20,'??????',NOW(),NOW()),(21,21,'?????c???????@?l',NOW(),NOW()),(22,22,'????s???@?l',NOW(),NOW()),(23,23,'?n??????s???@?l',NOW(),NOW()),(24,24,'???m?@?l',NOW(),NOW()),(25,25,'?L????C????@?l',NOW(),NOW()),(26,26,'??????C????@?l',NOW(),NOW()),(27,27,'?s?????m?@?l',NOW(),NOW()),(28,28,'?i?@???m?@?l',NOW(),NOW()),(29,29,'????m?@?l',NOW(),NOW()),(30,30,'??????w?@?l',NOW(),NOW()),(31,31,'??????w?@?l',NOW(),NOW()),(32,32,'?_???g???@?l',NOW(),NOW()),(33,33,'????g???@?l',NOW(),NOW()),(34,34,'??????J???m?@?l',NOW(),NOW()); |
|
18 |
/*!40000 ALTER TABLE `businesstypemaster` ENABLE KEYS */; |
|
19 |
UNLOCK TABLES; |
|
20 |
|
|
21 |
-- |
|
22 |
-- Dumping data for table `chgchargedep` |
|
23 |
-- |
|
24 |
|
|
25 |
LOCK TABLES `chgchargedep` WRITE; |
|
26 |
/*!40000 ALTER TABLE `chgchargedep` DISABLE KEYS */; |
|
27 |
INSERT INTO `chgchargedep` VALUES (20181001,'2018-10-01','9999-12-31',1,'?H????',NOW(),NOW()); |
|
28 |
/*!40000 ALTER TABLE `chgchargedep` ENABLE KEYS */; |
|
29 |
UNLOCK TABLES; |
|
30 |
|
|
31 |
-- |
|
32 |
-- Dumping data for table `componentlinkmaster` |
|
33 |
-- |
|
34 |
|
|
35 |
LOCK TABLES `componentlinkmaster` WRITE; |
|
36 |
/*!40000 ALTER TABLE `componentlinkmaster` DISABLE KEYS */; |
|
37 |
INSERT INTO `componentlinkmaster` VALUES (1,1,2,NOW(),NOW()),(1,2,3,NOW(),NOW()),(1,3,4,NOW(),NOW()),(1,4,5,NOW(),NOW()),(1,5,6,NOW(),NOW()),(1,6,7,NOW(),NOW()),(1,7,8,NOW(),NOW()),(1,8,9,NOW(),NOW()),(1,10,10,NOW(),NOW()),(1,11,1,NOW(),NOW()),(2,15,2,NOW(),NOW()),(2,16,3,NOW(),NOW()),(2,17,4,NOW(),NOW()),(2,18,5,NOW(),NOW()),(2,19,6,NOW(),NOW()),(2,20,1,NOW(),NOW()),(2,21,7,NOW(),NOW()),(3,20,2,NOW(),NOW()),(3,22,1,NOW(),NOW()),(3,23,3,NOW(),NOW()),(3,24,4,NOW(),NOW()),(3,25,5,NOW(),NOW()),(3,26,6,NOW(),NOW()),(3,27,7,NOW(),NOW()),(3,28,8,NOW(),NOW()),(3,29,9,NOW(),NOW()),(3,30,10,NOW(),NOW()),(3,31,11,NOW(),NOW()),(3,32,12,NOW(),NOW()),(3,33,13,NOW(),NOW()),(3,34,14,NOW(),NOW()),(3,35,15,NOW(),NOW()),(3,36,16,NOW(),NOW()),(3,37,17,NOW(),NOW()),(3,38,18,NOW(),NOW()),(3,39,19,NOW(),NOW()),(3,40,20,NOW(),NOW()),(3,41,21,NOW(),NOW()),(3,42,22,NOW(),NOW()),(3,43,23,NOW(),NOW()),(3,44,24,NOW(),NOW()),(3,45,25,NOW(),NOW()),(3,46,26,NOW(),NOW()),(3,47,28,NOW(),NOW()),(3,48,29,NOW(),NOW()),(3,49,30,NOW(),NOW()),(3,50,31,NOW(),NOW()),(3,51,27,NOW(),NOW()),(3,52,35,NOW(),NOW()),(3,53,36,NOW(),NOW()),(3,54,34,NOW(),NOW()),(3,55,37,NOW(),NOW()),(3,56,38,NOW(),NOW()),(3,57,39,NOW(),NOW()),(3,58,40,NOW(),NOW()),(3,59,32,NOW(),NOW()),(3,60,41,NOW(),NOW()),(3,110,33,NOW(),NOW()),(3,111,42,NOW(),NOW()),(3,112,43,NOW(),NOW()),(3,140,45,NOW(),NOW()),(3,166,44,NOW(),NOW()),(4,58,7,NOW(),NOW()),(4,61,1,NOW(),NOW()),(4,62,2,NOW(),NOW()),(4,63,3,NOW(),NOW()),(4,64,4,NOW(),NOW()),(4,65,5,NOW(),NOW()),(4,66,6,NOW(),NOW()),(5,58,10,NOW(),NOW()),(5,67,2,NOW(),NOW()),(5,68,3,NOW(),NOW()),(5,69,4,NOW(),NOW()),(5,70,5,NOW(),NOW()),(5,71,6,NOW(),NOW()),(5,72,7,NOW(),NOW()),(5,73,8,NOW(),NOW()),(5,74,9,NOW(),NOW()),(5,131,1,NOW(),NOW()),(14,106,1,NOW(),NOW()),(14,107,2,NOW(),NOW()),(15,108,1,NOW(),NOW()),(15,109,2,NOW(),NOW()),(17,15,2,NOW(),NOW()),(17,16,4,NOW(),NOW()),(17,17,5,NOW(),NOW()),(17,18,7,NOW(),NOW()),(17,19,6,NOW(),NOW()),(17,20,1,NOW(),NOW()),(17,22,8,NOW(),NOW()),(17,23,9,NOW(),NOW()),(17,24,10,NOW(),NOW()),(17,25,13,NOW(),NOW()),(17,26,11,NOW(),NOW()),(17,27,14,NOW(),NOW()),(17,28,16,NOW(),NOW()),(17,29,15,NOW(),NOW()),(17,30,17,NOW(),NOW()),(17,31,24,NOW(),NOW()),(17,32,22,NOW(),NOW()),(17,33,20,NOW(),NOW()),(17,34,19,NOW(),NOW()),(17,35,23,NOW(),NOW()),(17,36,30,NOW(),NOW()),(17,37,21,NOW(),NOW()),(17,38,70,NOW(),NOW()),(17,39,28,NOW(),NOW()),(17,40,26,NOW(),NOW()),(17,41,27,NOW(),NOW()),(17,42,29,NOW(),NOW()),(17,43,25,NOW(),NOW()),(17,44,31,NOW(),NOW()),(17,45,32,NOW(),NOW()),(17,46,33,NOW(),NOW()),(17,47,35,NOW(),NOW()),(17,48,37,NOW(),NOW()),(17,49,39,NOW(),NOW()),(17,50,34,NOW(),NOW()),(17,51,36,NOW(),NOW()),(17,52,47,NOW(),NOW()),(17,53,48,NOW(),NOW()),(17,54,46,NOW(),NOW()),(17,55,50,NOW(),NOW()),(17,56,49,NOW(),NOW()),(17,57,40,NOW(),NOW()),(17,59,45,NOW(),NOW()),(17,60,3,NOW(),NOW()),(17,61,51,NOW(),NOW()),(17,62,52,NOW(),NOW()),(17,63,53,NOW(),NOW()),(17,64,54,NOW(),NOW()),(17,65,55,NOW(),NOW()),(17,67,56,NOW(),NOW()),(17,68,57,NOW(),NOW()),(17,69,58,NOW(),NOW()),(17,70,59,NOW(),NOW()),(17,71,60,NOW(),NOW()),(17,72,61,NOW(),NOW()),(17,73,62,NOW(),NOW()),(17,74,63,NOW(),NOW()),(17,86,41,NOW(),NOW()),(17,110,44,NOW(),NOW()),(17,111,42,NOW(),NOW()),(17,112,68,NOW(),NOW()),(17,113,64,NOW(),NOW()),(17,114,65,NOW(),NOW()),(17,115,66,NOW(),NOW()),(17,116,43,NOW(),NOW()),(17,117,12,NOW(),NOW()),(17,119,72,NOW(),NOW()),(17,120,71,NOW(),NOW()),(17,121,69,NOW(),NOW()),(17,122,67,NOW(),NOW()),(17,123,74,NOW(),NOW()),(17,125,38,NOW(),NOW()),(17,126,73,NOW(),NOW()),(17,138,75,NOW(),NOW()),(17,139,76,NOW(),NOW()),(17,144,77,NOW(),NOW()),(17,165,18,NOW(),NOW()),(19,14,1,NOW(),NOW()),(22,67,1,NOW(),NOW()),(22,68,2,NOW(),NOW()),(22,69,3,NOW(),NOW()),(22,70,4,NOW(),NOW()),(22,71,5,NOW(),NOW()),(22,72,6,NOW(),NOW()),(22,73,7,NOW(),NOW()),(22,124,8,NOW(),NOW()),(23,61,1,NOW(),NOW()),(23,62,2,NOW(),NOW()),(23,63,3,NOW(),NOW()),(23,64,4,NOW(),NOW()),(23,65,5,NOW(),NOW()),(23,71,6,NOW(),NOW()),(23,72,7,NOW(),NOW()),(23,73,8,NOW(),NOW()),(24,67,1,NOW(),NOW()),(24,68,2,NOW(),NOW()),(24,69,3,NOW(),NOW()),(24,70,7,NOW(),NOW()),(24,71,4,NOW(),NOW()),(24,72,5,NOW(),NOW()),(24,73,6,NOW(),NOW()),(24,123,8,NOW(),NOW()),(24,124,9,NOW(),NOW()),(24,131,14,NOW(),NOW()),(24,132,10,NOW(),NOW()),(24,133,11,NOW(),NOW()),(24,134,12,NOW(),NOW()),(24,135,13,NOW(),NOW()),(24,136,15,NOW(),NOW()),(25,61,1,NOW(),NOW()),(25,62,2,NOW(),NOW()),(25,63,3,NOW(),NOW()),(25,64,4,NOW(),NOW()),(25,65,5,NOW(),NOW()),(25,71,6,NOW(),NOW()),(25,72,7,NOW(),NOW()),(25,127,8,NOW(),NOW()),(25,128,9,NOW(),NOW()),(25,129,10,NOW(),NOW()),(25,130,12,NOW(),NOW()),(25,131,13,NOW(),NOW()),(25,137,11,NOW(),NOW()),(26,160,1,NOW(),NOW()),(26,161,2,NOW(),NOW()),(26,162,5,NOW(),NOW()),(26,163,3,NOW(),NOW()),(26,164,4,NOW(),NOW()),(29,148,1,NOW(),NOW()),(29,149,2,NOW(),NOW()),(29,150,3,NOW(),NOW()),(30,151,1,NOW(),NOW()),(30,152,2,NOW(),NOW()),(30,153,3,NOW(),NOW()),(30,154,4,NOW(),NOW()),(31,63,4,NOW(),NOW()),(31,73,2,NOW(),NOW()),(31,155,1,NOW(),NOW()),(31,156,3,NOW(),NOW()),(31,157,5,NOW(),NOW()),(31,158,6,NOW(),NOW()),(31,159,7,NOW(),NOW()),(32,61,1,NOW(),NOW()),(32,67,2,NOW(),NOW()),(32,74,3,NOW(),NOW()); |
|
38 |
/*!40000 ALTER TABLE `componentlinkmaster` ENABLE KEYS */; |
|
39 |
UNLOCK TABLES; |
|
40 |
|
|
41 |
-- |
|
42 |
-- Dumping data for table `componentmaster` |
|
43 |
-- |
|
44 |
|
|
45 |
LOCK TABLES `componentmaster` WRITE; |
|
46 |
/*!40000 ALTER TABLE `componentmaster` DISABLE KEYS */; |
|
47 |
INSERT INTO `componentmaster` VALUES (1,13,'???????H????i????????j?????????D?H???p',1,0,0,0,NOW(),NOW()),(2,14,'???H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(3,15,'???z?H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(4,17,'?d?C????H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(5,16,'?@?B????H????@?????????D?H???p',1,0,0,0,NOW(),NOW()),(6,19,'????????@?????????D?H???p',0,1,1,0,NOW(),NOW()),(7,20,'???????@?????????D?H???p',0,1,1,0,NOW(),NOW()),(8,9,'???o??@?????????E???H???p',0,1,0,0,NOW(),NOW()),(17,2,'?H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(18,18,'???????????@?????????D?H???p',0,1,0,0,NOW(),NOW()),(19,1,'????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(20,7,'????????@?????????E???H???p',0,1,1,0,NOW(),NOW()),(21,8,'???????@?????????E???H???p',0,1,1,0,NOW(),NOW()),(22,3,'?????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(23,4,'?d?C?H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(24,5,'?@?B????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(25,6,'?d?C????H????@?????????E???H???p',1,0,0,0,NOW(),NOW()),(26,21,'??v??p',1,0,1,0,NOW(),NOW()),(27,22,'?@??????',0,1,1,0,NOW(),NOW()),(28,23,'???H????????V?z?p',1,0,0,1,NOW(),NOW()),(29,24,'?O???H????????V?z?p',1,0,0,1,NOW(),NOW()),(30,25,'?????H????????V?z?p',1,0,0,1,NOW(),NOW()),(31,26,'?????????H????????V?z?p',1,0,0,1,NOW(),NOW()),(32,27,'??r?H????????V?z?p',1,0,0,1,NOW(),NOW()),(33,28,'????p??????V?z',1,0,1,1,NOW(),NOW()); |
|
48 |
/*!40000 ALTER TABLE `componentmaster` ENABLE KEYS */; |
|
49 |
UNLOCK TABLES; |
|
50 |
|
|
51 |
-- |
|
52 |
-- Dumping data for table `consumptiontax` |
|
53 |
-- |
|
54 |
|
|
55 |
LOCK TABLES `consumptiontax` WRITE; |
|
56 |
/*!40000 ALTER TABLE `consumptiontax` DISABLE KEYS */; |
|
57 |
INSERT INTO `consumptiontax` VALUES ('1989-04-01','1997-03-31',3.00,0,NOW(),NOW()),('1997-04-01','2014-03-31',5.00,0,NOW(),NOW()),('2014-04-01','2019-09-30',8.00,0,NOW(),NOW()),('2019-10-01','9999-12-31',10.00,0,NOW(),NOW()); |
|
58 |
/*!40000 ALTER TABLE `consumptiontax` ENABLE KEYS */; |
|
59 |
UNLOCK TABLES; |
|
60 |
|
|
61 |
-- |
|
62 |
-- Dumping data for table `constructionitemmaster` |
|
63 |
-- |
|
64 |
|
|
65 |
LOCK TABLES `constructionitemmaster` WRITE; |
|
66 |
/*!40000 ALTER TABLE `constructionitemmaster` DISABLE KEYS */; |
|
67 |
INSERT INTO `constructionitemmaster` VALUES (10,2,'????????????',1,0,0,NOW(),NOW()),(11,1,'???????H???@???W???Z?????',0,0,0,NOW(),NOW()),(20,4,'???????H????',1,0,0,NOW(),NOW()),(22,13,'?y?H??',1,0,0,NOW(),NOW()),(23,14,'?n??H??',1,0,0,NOW(),NOW()),(24,16,'?S??H??',1,0,0,NOW(),NOW()),(25,17,'?R???N???[?g?H??',1,0,0,NOW(),NOW()),(26,18,'?^?g?H??',1,0,0,NOW(),NOW()),(27,19,'?S???H??',1,0,0,NOW(),NOW()),(28,20,'?????H??',1,0,0,NOW(),NOW()),(29,21,'?`?k?b?p?l???H??',1,0,0,NOW(),NOW()),(30,22,'???o???`?Z?????g??H??',1,0,0,NOW(),NOW()),(31,24,'?h???H??',1,0,0,NOW(),NOW()),(32,25,'??E?^?C???H??',1,0,0,NOW(),NOW()),(33,26,'??H??',1,0,0,NOW(),NOW()),(35,29,'?????E????H??',1,0,0,NOW(),NOW()),(36,30,'?????H??',1,0,0,NOW(),NOW()),(37,31,'?????H??',1,0,0,NOW(),NOW()),(39,33,'???????H??',1,0,0,NOW(),NOW()),(40,34,'??????????H??',1,0,0,NOW(),NOW()),(41,35,'?V???b?^?[?H??',1,0,0,NOW(),NOW()),(42,36,'?K???X?H??',1,0,0,NOW(),NOW()),(43,38,'?h???H??',1,0,0,NOW(),NOW()),(44,39,'?????H??',1,0,0,NOW(),NOW()),(45,41,'?y?S?H??',1,0,0,NOW(),NOW()),(46,42,'?????d???H??',1,0,0,NOW(),NOW()),(47,44,'???j?b?g?H??',1,0,0,NOW(),NOW()),(50,50,'??????H??',1,0,0,NOW(),NOW()),(51,43,'???H??',1,0,0,NOW(),NOW()),(86,48,'?A??H??',1,0,0,NOW(),NOW()),(112,23,'?????R???N???[?g?H??',1,0,0,NOW(),NOW()),(116,40,'?O???H??',1,0,0,NOW(),NOW()),(117,15,'??b?H??',1,0,0,NOW(),NOW()),(119,47,'???O?H??',1,0,0,NOW(),NOW()),(120,37,'????E?K???X?H??',1,0,0,NOW(),NOW()),(126,49,'?T?C???H??',1,0,0,NOW(),NOW()); |
|
68 |
/*!40000 ALTER TABLE `constructionitemmaster` ENABLE KEYS */; |
|
69 |
UNLOCK TABLES; |
|
70 |
|
|
71 |
-- |
|
72 |
-- Dumping data for table `constructiontypemaster` |
|
73 |
-- |
|
74 |
|
|
75 |
LOCK TABLES `constructiontypemaster` WRITE; |
|
76 |
/*!40000 ALTER TABLE `constructiontypemaster` DISABLE KEYS */; |
|
77 |
INSERT INTO `constructiontypemaster` VALUES (1,1,'?????H???@???C?i?????j',1,2,4,0,0,0,NOW(),NOW()),(2,2,'?????H???@?V?z?i?????j',1,1,4,0,0,0,NOW(),NOW()),(3,3,'?????H???@???C?i?????j',1,2,4,0,0,0,NOW(),NOW()),(4,4,'?????H???@?V?z?i?????j',1,1,4,0,0,0,NOW(),NOW()),(5,5,'????H???@???C?i?????j',2,0,4,0,0,0,NOW(),NOW()),(6,6,'????H???@?V?z?i?????j',2,0,4,0,0,0,NOW(),NOW()),(7,7,'????H???@???C?i?????j',2,0,4,0,0,0,NOW(),NOW()),(8,8,'????H???@?V?z?i?????j',2,0,4,0,0,0,NOW(),NOW()),(9,9,'??l?q???t?H?[???H???i?????j',2,0,4,0,0,0,NOW(),NOW()),(10,10,'????V?z?H???i?????j',2,0,4,0,0,0,NOW(),NOW()),(11,11,'?????A?H??',0,0,4,0,0,0,NOW(),NOW()),(12,12,'???????',0,0,3,0,1,0,NOW(),NOW()); |
|
78 |
/*!40000 ALTER TABLE `constructiontypemaster` ENABLE KEYS */; |
|
79 |
UNLOCK TABLES; |
|
80 |
|
|
81 |
-- |
|
82 |
-- Dumping data for table `daymaster` |
|
83 |
-- |
|
84 |
|
|
85 |
LOCK TABLES `daymaster` WRITE; |
|
86 |
/*!40000 ALTER TABLE `daymaster` DISABLE KEYS */; |
|
87 |
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); |
|
88 |
/*!40000 ALTER TABLE `daymaster` ENABLE KEYS */; |
|
89 |
UNLOCK TABLES; |
|
90 |
|
|
91 |
-- |
|
92 |
-- Dumping data for table `departmentmaster` |
|
93 |
-- |
|
94 |
|
|
95 |
LOCK TABLES `departmentmaster` WRITE; |
|
96 |
/*!40000 ALTER TABLE `departmentmaster` DISABLE KEYS */; |
|
97 |
INSERT INTO `departmentmaster` VALUES (1,1,'?H????',0,0,NOW(),'0001-01-01 00:00:00',0,NOW(),NOW()); |
|
98 |
/*!40000 ALTER TABLE `departmentmaster` ENABLE KEYS */; |
|
99 |
UNLOCK TABLES; |
|
100 |
|
|
101 |
-- |
|
102 |
-- Dumping data for table `divisionmaster` |
|
103 |
-- |
|
104 |
|
|
105 |
LOCK TABLES `divisionmaster` WRITE; |
|
106 |
/*!40000 ALTER TABLE `divisionmaster` DISABLE KEYS */; |
|
107 |
INSERT INTO `divisionmaster` VALUES (1,1,1,'?@?l?i??????j',0,NOW(),NOW()),(1,2,2,'?@?l?i??????j',0,NOW(),NOW()),(1,3,3,'?@?l?i?a?@?E?????{????j',0,NOW(),NOW()),(1,4,4,'?@?l?i?w?Z?@?l?j',0,NOW(),NOW()),(1,5,5,'?????c??i?e????j',0,NOW(),NOW()),(1,6,6,'???z?m???????E??????m???????',0,NOW(),NOW()),(1,7,7,'??l?i???j',0,NOW(),NOW()),(1,8,8,'????g???E??????',0,NOW(),NOW()),(1,9,9,'?X???',0,NOW(),NOW()),(1,10,10,'?????',0,NOW(),NOW()),(3,3,1,'???o??',0,NOW(),NOW()); |
|
108 |
/*!40000 ALTER TABLE `divisionmaster` ENABLE KEYS */; |
|
109 |
UNLOCK TABLES; |
|
110 |
|
|
111 |
-- |
|
112 |
-- Dumping data for table `monthmaster` |
|
113 |
-- |
|
114 |
|
|
115 |
LOCK TABLES `monthmaster` WRITE; |
|
116 |
/*!40000 ALTER TABLE `monthmaster` DISABLE KEYS */; |
|
117 |
INSERT INTO `monthmaster` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12); |
|
118 |
/*!40000 ALTER TABLE `monthmaster` ENABLE KEYS */; |
|
119 |
UNLOCK TABLES; |
|
120 |
|
|
121 |
-- |
|
122 |
-- Dumping data for table `personinchargemaster` |
|
123 |
-- |
|
124 |
|
|
125 |
LOCK TABLES `personinchargemaster` WRITE; |
|
126 |
/*!40000 ALTER TABLE `personinchargemaster` DISABLE KEYS */; |
|
127 |
INSERT INTO `personinchargemaster` VALUES (20181001,1,'?V?X?e???????','?V?X?e???J?????V??',0,'A','0001-01-01','','','','','','','',NOW(),'0001-01-01','20181001',4,1,'','',1,0,0,'','???F??',1,1,0.00,0.0,0.0,0,0,0,0,NOW(),NOW()); |
|
128 |
/*!40000 ALTER TABLE `personinchargemaster` ENABLE KEYS */; |
|
129 |
UNLOCK TABLES; |
|
130 |
|
|
131 |
-- |
|
132 |
-- Dumping data for table `processexcutemaster` |
|
133 |
-- |
|
134 |
|
|
135 |
LOCK TABLES `processexcutemaster` WRITE; |
|
136 |
/*!40000 ALTER TABLE `processexcutemaster` DISABLE KEYS */; |
|
137 |
INSERT INTO `processexcutemaster` VALUES (1,1,1,NOW(),NOW()),(1,2,1,NOW(),NOW()),(1,3,1,NOW(),NOW()),(1,4,1,NOW(),NOW()),(1,5,1,NOW(),NOW()),(1,6,1,NOW(),NOW()),(1,7,1,NOW(),NOW()),(1,8,1,NOW(),NOW()),(1,9,1,NOW(),NOW()),(1,10,1,NOW(),NOW()),(1,12,1,NOW(),NOW()),(1,13,1,NOW(),NOW()),(1,19,1,NOW(),NOW()),(1,30,1,NOW(),NOW()),(1,31,1,NOW(),NOW()),(1,32,1,NOW(),NOW()),(1,37,1,NOW(),NOW()),(1,39,0,NOW(),NOW()),(1,40,1,NOW(),NOW()),(1,41,0,NOW(),NOW()),(1,42,1,NOW(),NOW()),(1,45,0,NOW(),NOW()),(1,47,1,NOW(),NOW()),(1,101,1,NOW(),NOW()),(1,102,1,NOW(),NOW()),(1,103,1,NOW(),NOW()),(1,104,1,NOW(),NOW()),(1,105,1,NOW(),NOW()),(1,106,1,NOW(),NOW()),(1,107,1,NOW(),NOW()),(1,108,1,NOW(),NOW()),(1,109,1,NOW(),NOW()),(1,110,1,NOW(),NOW()),(1,111,1,NOW(),NOW()),(1,112,1,NOW(),NOW()),(1,114,1,NOW(),NOW()),(1,117,1,NOW(),NOW()),(1,119,0,NOW(),NOW()),(1,120,1,NOW(),NOW()),(1,123,1,NOW(),NOW()),(1,124,1,NOW(),NOW()),(1,125,1,NOW(),NOW()),(1,126,1,NOW(),NOW()),(1,131,1,NOW(),NOW()),(1,132,1,NOW(),NOW()),(1,133,1,NOW(),NOW()),(1,134,1,NOW(),NOW()),(1,135,1,NOW(),NOW()); |
|
138 |
/*!40000 ALTER TABLE `processexcutemaster` ENABLE KEYS */; |
|
139 |
UNLOCK TABLES; |
|
140 |
|
|
141 |
-- |
|
142 |
-- Dumping data for table `recordkey` |
|
143 |
-- |
|
144 |
|
|
145 |
LOCK TABLES `recordkey` WRITE; |
|
146 |
/*!40000 ALTER TABLE `recordkey` DISABLE KEYS */; |
|
147 |
INSERT INTO `recordkey` VALUES (1,0,NOW(),NOW()); |
|
148 |
/*!40000 ALTER TABLE `recordkey` ENABLE KEYS */; |
|
149 |
UNLOCK TABLES; |
|
150 |
|
|
151 |
-- |
|
152 |
-- Dumping data for table `securitymaster` |
|
153 |
-- |
|
154 |
|
|
155 |
LOCK TABLES `securitymaster` WRITE; |
|
156 |
/*!40000 ALTER TABLE `securitymaster` DISABLE KEYS */; |
|
157 |
INSERT INTO `securitymaster` VALUES (1,1,'?V?X?e???????',1,3,1,'0xFFFFFF',NOW(),NOW()); |
|
158 |
/*!40000 ALTER TABLE `securitymaster` ENABLE KEYS */; |
|
159 |
UNLOCK TABLES; |
|
160 |
|
|
161 |
-- |
|
162 |
-- Dumping data for table `subcontractoritemmaster` |
|
163 |
-- |
|
164 |
|
|
165 |
LOCK TABLES `subcontractoritemmaster` WRITE; |
|
166 |
/*!40000 ALTER TABLE `subcontractoritemmaster` DISABLE KEYS */; |
|
167 |
INSERT INTO `subcontractoritemmaster` VALUES (1,1,'???H????',0,NOW(),NOW()),(2,2,'?A?X?x?X?g????????',0,NOW(),NOW()),(3,3,'???H??',0,NOW(),NOW()),(4,4,'????H??',0,NOW(),NOW()),(5,5,'?g????H??',0,NOW(),NOW()),(6,6,'???????????H??',0,NOW(),NOW()),(7,7,'??H??',0,NOW(),NOW()),(8,8,'???z?H????',0,NOW(),NOW()),(9,9,'?y??H????',0,NOW(),NOW()),(10,10,'?y?H??',0,NOW(),NOW()),(11,11,'??b?H??',0,NOW(),NOW()),(12,12,'?Y?H??',0,NOW(),NOW()),(13,13,'?n?????',0,NOW(),NOW()),(14,14,'?????@????',0,NOW(),NOW()),(15,15,'?A?X?t?@???g?H??',0,NOW(),NOW()),(16,16,'?????H??',0,NOW(),NOW()),(17,17,'?S??H??',0,NOW(),NOW()),(18,18,'?R???N???[?g?R?A?????H??',0,NOW(),NOW()),(19,19,'?R???N???[?g???',0,NOW(),NOW()),(20,20,'?^?g?H??',0,NOW(),NOW()),(21,21,'?S???H??',0,NOW(),NOW()),(22,22,'?K?X?n??H??',0,NOW(),NOW()),(23,23,'?`?k?b?H??',0,NOW(),NOW()),(24,24,'???o???`?Z?????g??H??',0,NOW(),NOW()),(25,25,'?h???H????',0,NOW(),NOW()),(26,26,'?R?[?L???O?H??',0,NOW(),NOW()),(27,27,'?h????????',0,NOW(),NOW()),(28,28,'?????H??',0,NOW(),NOW()),(29,29,'?R???N???[?g?u???b?N?H??',0,NOW(),NOW()),(30,30,'?y??H???i?y????????j',0,NOW(),NOW()),(31,31,'?^?C???H??',0,NOW(),NOW()),(32,32,'??H??',0,NOW(),NOW()),(33,33,'??H??',0,NOW(),NOW()),(34,34,'?????H',0,NOW(),NOW()),(35,35,'?????E????H????',0,NOW(),NOW()),(36,36,'???H??',0,NOW(),NOW()),(37,37,'????H??',0,NOW(),NOW()),(38,38,'?T?C?f?B???O?H??',0,NOW(),NOW()),(39,39,'?????H??',0,NOW(),NOW()),(40,40,'?G?L?X?p???V????????E?H??',0,NOW(),NOW()),(41,41,'?????t???H???i?????j',0,NOW(),NOW()),(42,42,'?????t???H???i?f?M??j',0,NOW(),NOW()),(43,43,'???????H??',0,NOW(),NOW()),(44,44,'?|??????H????',0,NOW(),NOW()),(45,45,'?T?b?V?H??',0,NOW(),NOW()),(46,46,'?V???b?^?[?H??',0,NOW(),NOW()),(47,47,'?K???X?H??',0,NOW(),NOW()),(48,48,'?h???H??',0,NOW(),NOW()),(49,49,'?h?????',0,NOW(),NOW()),(50,50,'?????H????',0,NOW(),NOW()),(51,51,'?y?S?H??',0,NOW(),NOW()),(52,52,'?{?[?h?H??',0,NOW(),NOW()),(53,53,'?A???J?[?H??',0,NOW(),NOW()),(54,54,'?N???X?H??',0,NOW(),NOW()),(55,55,'???H???i?????n?j',0,NOW(),NOW()),(56,56,'???H???i?t???[?????O?n?j',0,NOW(),NOW()),(57,57,'???H??',0,NOW(),NOW()),(58,58,'??????E?H??',0,NOW(),NOW()),(59,59,'??q????E?H??',0,NOW(),NOW()),(60,60,'??????E?H??',0,NOW(),NOW()),(61,61,'???V??H??',0,NOW(),NOW()),(62,62,'?V?X?e???V??H??',0,NOW(),NOW()),(63,63,'???H??',0,NOW(),NOW()),(64,64,'?e???g????E?H??',0,NOW(),NOW()),(65,65,'OA?t???A?H??',0,NOW(),NOW()),(66,66,'???????E?H??',0,NOW(),NOW()),(67,67,'?_???E?F?[?_?[?E?z?[???d?u',0,NOW(),NOW()),(68,68,'?N???[?j???O?H??',0,NOW(),NOW()),(69,69,'?O?\?H????',0,NOW(),NOW()),(70,70,'?G?N?X?e???A?H??',0,NOW(),NOW()),(71,71,'?t?F???X?H??',0,NOW(),NOW()),(72,72,'?l?b?g?H??',0,NOW(),NOW()),(73,73,'?O????C?H????',0,NOW(),NOW()),(74,74,'??k???C?H????',0,NOW(),NOW()),(75,75,'?@?B????H????',0,NOW(),NOW()),(76,76,'?????H??',0,NOW(),NOW()),(77,77,'???H??',0,NOW(),NOW()),(78,78,'????H??',0,NOW(),NOW()),(79,79,'?d?C????H????',0,NOW(),NOW()),(80,80,'?z?C?E???C?H??',0,NOW(),NOW()),(81,81,'?G?A?R???H??',0,NOW(),NOW()),(82,82,'???E??????H??',0,NOW(),NOW()),(83,83,'?{?C???[????H??',0,NOW(),NOW()),(84,84,'?K?X????H??',0,NOW(),NOW()),(85,85,'?????',0,NOW(),NOW()),(86,86,'???C?????i????j',0,NOW(),NOW()),(87,87,'?????n??????',0,NOW(),NOW()),(88,88,'?O???n??????',0,NOW(),NOW()),(89,89,'?????n??????',0,NOW(),NOW()),(90,90,'?y??n??????',0,NOW(),NOW()),(91,91,'?z???????',0,NOW(),NOW()),(92,92,'???h????E?h?????{?H???',0,NOW(),NOW()),(93,93,'????@?????i?Z??j',0,NOW(),NOW()),(94,94,'????@?????i??d?E????j',0,NOW(),NOW()),(95,95,'???z????????',0,NOW(),NOW()),(96,96,'???z????????E?H??',0,NOW(),NOW()),(97,97,'???z???????',0,NOW(),NOW()),(98,98,'???z????????E?H??',0,NOW(),NOW()),(99,99,'?@?B?H?????',0,NOW(),NOW()),(100,100,'?e?????????',0,NOW(),NOW()),(101,101,'???O??????E?H??',0,NOW(),NOW()),(102,102,'?~?[?@?????E????',0,NOW(),NOW()),(103,103,'?z?[???Z???^?[??',0,NOW(),NOW()),(104,104,'?x????',0,NOW(),NOW()),(105,105,'?|???v?i?????j',0,NOW(),NOW()),(106,106,'???b?J?[',0,NOW(),NOW()),(107,107,'?N???[???i?k?d?j',0,NOW(),NOW()),(108,108,'???[?X????n',0,NOW(),NOW()),(109,109,'???[?X????n?E?X',0,NOW(),NOW()),(110,110,'???[?X??????????',0,NOW(),NOW()),(111,111,'???[?X????????????i',0,NOW(),NOW()),(112,112,'?S???h??',0,NOW(),NOW()),(113,113,'?Y??p????????',0,NOW(),NOW()),(114,114,'?Q?????E?h?a????',0,NOW(),NOW()),(115,115,'?R?s?[?E???{',0,NOW(),NOW()),(116,116,'?e???????',0,NOW(),NOW()),(117,117,'??v??????',0,NOW(),NOW()),(118,118,'??v???????i?\???j',0,NOW(),NOW()),(119,119,'?????????',0,NOW(),NOW()),(120,120,'?s???Y??W',0,NOW(),NOW()),(121,121,'?s?????m',0,NOW(),NOW()),(122,122,'?i?@???m',0,NOW(),NOW()),(123,123,'???m??????',0,NOW(),NOW()),(124,124,'???@??',0,NOW(),NOW()),(125,125,'??p??i???j',0,NOW(),NOW()),(126,126,'??p??i?????j',0,NOW(),NOW()),(127,127,'???~????i?d?u?j?H??',0,NOW(),NOW()),(128,128,'?\?D',0,NOW(),NOW()),(129,129,'?e????',0,NOW(),NOW()),(130,130,'?s???Y??',0,NOW(),NOW()),(131,131,'??????p???~?@',0,NOW(),NOW()),(132,132,'?Z?????r??????',0,NOW(),NOW()),(133,133,'?v???n?u?V?z?E???',0,NOW(),NOW()),(134,134,'???????????',0,NOW(),NOW()),(135,135,'??j???',0,NOW(),NOW()),(136,136,'?O?\????E??????',0,NOW(),NOW()),(137,137,'???z??????',0,NOW(),NOW()),(138,138,'????J????????E?{?H',0,NOW(),NOW()),(139,139,'?????????E?C??',0,NOW(),NOW()),(140,140,'?p???E?p?t??????',0,NOW(),NOW()),(141,141,'????H??',0,NOW(),NOW()); |
|
168 |
/*!40000 ALTER TABLE `subcontractoritemmaster` ENABLE KEYS */; |
|
169 |
UNLOCK TABLES; |
|
170 |
|
|
171 |
-- |
|
172 |
-- Dumping data for table `subcontractorjobcategory` |
|
173 |
-- |
|
174 |
|
|
175 |
LOCK TABLES `subcontractorjobcategory` WRITE; |
|
176 |
/*!40000 ALTER TABLE `subcontractorjobcategory` DISABLE KEYS */; |
|
177 |
INSERT INTO `subcontractorjobcategory` VALUES (1,1,'????',0,NOW(),NOW()),(2,2,'???U????',0,NOW(),NOW()),(3,3,'????H',0,NOW(),NOW()),(4,4,'???H',0,NOW(),NOW()),(5,5,'??H',0,NOW(),NOW()),(6,6,'??H',0,NOW(),NOW()),(7,7,'?d???H',0,NOW(),NOW()),(8,8,'?y?H',0,NOW(),NOW()),(9,9,'????H',0,NOW(),NOW()),(10,10,'?J?b?^?[?H',0,NOW(),NOW()),(11,11,'?Y?H',0,NOW(),NOW()),(12,12,'??C?H',0,NOW(),NOW()),(13,13,'?G?H',0,NOW(),NOW()),(14,14,'?^?g??H',0,NOW(),NOW()),(15,15,'?^?g???H',0,NOW(),NOW()),(16,16,'?S??H',0,NOW(),NOW()),(17,17,'??b?H??',0,NOW(),NOW()),(18,18,'?S???H',0,NOW(),NOW()),(19,19,'?b???H',0,NOW(),NOW()),(20,20,'?K?X?H',0,NOW(),NOW()),(21,21,'?`?k?b?H',0,NOW(),NOW()),(22,22,'?A???J?[?H',0,NOW(),NOW()),(23,23,'?R?A?[?H',0,NOW(),NOW()),(24,24,'?????H',0,NOW(),NOW()),(25,25,'?????H',0,NOW(),NOW()),(26,26,'??H',0,NOW(),NOW()),(27,27,'?????H',0,NOW(),NOW()),(28,28,'?^?C???H',0,NOW(),NOW()),(29,29,'??H',0,NOW(),NOW()),(30,30,'?h???H',0,NOW(),NOW()),(31,31,'?V?[???H',0,NOW(),NOW()),(32,32,'???n??C?H',0,NOW(),NOW()),(33,33,'???????H',0,NOW(),NOW()),(34,34,'?|??????H',0,NOW(),NOW()),(35,35,'?K???X?H',0,NOW(),NOW()),(36,36,'?????E??H',0,NOW(),NOW()),(37,37,'????H',0,NOW(),NOW()),(38,38,'?h???H',0,NOW(),NOW()),(39,39,'???t?H?i?h???j',0,NOW(),NOW()),(40,40,'?f?M?H?i???t?j',0,NOW(),NOW()),(41,41,'?????H',0,NOW(),NOW()),(42,42,'??g???H',0,NOW(),NOW()),(43,43,'?????d???H',0,NOW(),NOW()),(44,44,'???j?b?g?H',0,NOW(),NOW()),(45,45,'?p?l???H?i???z?j',0,NOW(),NOW()),(46,46,'???H',0,NOW(),NOW()),(47,47,'?????H',0,NOW(),NOW()),(48,48,'???H',0,NOW(),NOW()),(49,49,'?????H',0,NOW(),NOW()),(50,50,'?d?H',0,NOW(),NOW()),(51,51,'?????d?H',0,NOW(),NOW()),(52,52,'??d?H',0,NOW(),NOW()),(53,53,'???r??????H',0,NOW(),NOW()),(54,54,'?@?B????H',0,NOW(),NOW()),(55,55,'?????H?i???C?j',0,NOW(),NOW()),(56,56,'?????H?i?G?A?R???j',0,NOW(),NOW()),(57,57,'?f?M?H?i?z?????n?j',0,NOW(),NOW()),(58,58,'?K?X?H',0,NOW(),NOW()),(59,59,'?{?C???[?H',0,NOW(),NOW()),(60,60,'???????H',0,NOW(),NOW()),(61,61,'?p?l???H?i????j',0,NOW(),NOW()),(62,62,'?|???v?????H',0,NOW(),NOW()),(63,63,'???b?J?[',0,NOW(),NOW()),(64,64,'?k?d?H',0,NOW(),NOW()),(65,65,'????',0,NOW(),NOW()),(66,66,'?h???A?h?a',0,NOW(),NOW()),(67,67,'?Z??@??',0,NOW(),NOW()),(68,68,'?S?~????',0,NOW(),NOW()),(69,69,'????n?E?X?E?v?b?E??????[?X',0,NOW(),NOW()),(70,70,'????@???[?X',0,NOW(),NOW()),(71,71,'???z??????',0,NOW(),NOW()),(72,72,'??p??i?????j',0,NOW(),NOW()),(73,73,'??p??i?H???j',0,NOW(),NOW()),(74,74,'??????',0,NOW(),NOW()),(75,75,'?e????',0,NOW(),NOW()),(76,76,'??v??????',0,NOW(),NOW()),(77,77,'?h????????',0,NOW(),NOW()),(78,78,'?x???H',0,NOW(),NOW()),(79,79,'?s???Y?c??',0,NOW(),NOW()),(80,80,'?y?S?H',0,NOW(),NOW()),(81,81,'??C?H?i???y?A?[?j',0,NOW(),NOW()),(82,82,'?h????????',0,NOW(),NOW()),(83,83,'?O?\?H',0,NOW(),NOW()),(84,84,'???H',0,NOW(),NOW()),(85,85,'?l?b?g?H',0,NOW(),NOW()),(86,86,'???z??',0,NOW(),NOW()),(87,87,'????E?z???C?g?{?[?h',0,NOW(),NOW()),(88,88,'?V???u?H',0,NOW(),NOW()),(89,89,'??????p???~?@?E??u?E???',0,NOW(),NOW()),(90,90,'?~?[?@?????E??u',0,NOW(),NOW()),(91,91,'???????E?@????',0,NOW(),NOW()),(92,92,'?R?s?[?E???{',0,NOW(),NOW()),(93,93,'?n?????',0,NOW(),NOW()),(94,94,'?e???g?H',0,NOW(),NOW()),(95,95,'??H',0,NOW(),NOW()),(96,96,'?t?F???X??t?H',0,NOW(),NOW()),(97,97,'?A?X?x?X?g??W????',0,NOW(),NOW()),(98,98,'?s?????m',0,NOW(),NOW()),(99,99,'?i?@???m',0,NOW(),NOW()),(100,100,'????H',0,NOW(),NOW()),(101,101,'?R???N???[?g?z???A???',0,NOW(),NOW()),(102,102,'?Z?????r?????',0,NOW(),NOW()),(103,103,'?v???n?u?V?z?E???',0,NOW(),NOW()),(104,104,'?H??E???z???S???????',0,NOW(),NOW()),(105,105,'??j?????',0,NOW(),NOW()),(106,106,'?O?\????E????????',0,NOW(),NOW()),(107,107,'?g??H',0,NOW(),NOW()),(108,108,'?????????E?C??',0,NOW(),NOW()),(109,109,'????m',0,NOW(),NOW()),(110,110,'?O??H',0,NOW(),NOW()); |
|
178 |
/*!40000 ALTER TABLE `subcontractorjobcategory` ENABLE KEYS */; |
|
179 |
UNLOCK TABLES; |
|
180 |
|
|
181 |
-- |
|
182 |
-- Dumping data for table `systemexecute` |
|
183 |
-- |
|
184 |
|
|
185 |
LOCK TABLES `systemexecute` WRITE; |
|
186 |
/*!40000 ALTER TABLE `systemexecute` DISABLE KEYS */; |
|
187 |
INSERT INTO `systemexecute` VALUES (1,'2019-12-01',0,0,NOW(),NOW()),(2,'2019-12-01',1,1,NOW(),NOW()); |
|
188 |
/*!40000 ALTER TABLE `systemexecute` ENABLE KEYS */; |
|
189 |
UNLOCK TABLES; |
|
190 |
|
|
191 |
-- |
|
192 |
-- Dumping data for table `systemmaster` |
|
193 |
-- |
|
194 |
|
|
195 |
LOCK TABLES `systemmaster` WRITE; |
|
196 |
/*!40000 ALTER TABLE `systemmaster` DISABLE KEYS */; |
|
197 |
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,NOW(),NOW()); |
|
198 |
/*!40000 ALTER TABLE `systemmaster` ENABLE KEYS */; |
|
199 |
UNLOCK TABLES; |
|
200 |
|
|
201 |
-- |
|
202 |
-- Dumping data for table `unitmaster` |
|
203 |
-- |
|
204 |
|
|
205 |
LOCK TABLES `unitmaster` WRITE; |
|
206 |
/*!40000 ALTER TABLE `unitmaster` DISABLE KEYS */; |
|
207 |
INSERT INTO `unitmaster` VALUES (1,2,'??',NOW(),NOW()),(2,28,'???j?b?g',NOW(),NOW()),(3,26,'?p?b?N',NOW(),NOW()),(4,27,'??',NOW(),NOW()),(5,21,'??',NOW(),NOW()),(6,29,'????',NOW(),NOW()),(7,30,'????',NOW(),NOW()),(8,18,'??',NOW(),NOW()),(9,31,'?n??',NOW(),NOW()),(10,7,'????',NOW(),NOW()),(11,32,'?X?p??',NOW(),NOW()),(12,33,'?p??',NOW(),NOW()),(13,15,'????',NOW(),NOW()),(14,1,'??',NOW(),NOW()),(15,34,'?A',NOW(),NOW()),(16,16,'??',NOW(),NOW()),(17,35,'??',NOW(),NOW()),(18,36,'???E??',NOW(),NOW()),(19,9,'?????Q',NOW(),NOW()),(20,37,'??',NOW(),NOW()),(21,38,'???E??',NOW(),NOW()),(22,3,'???Q',NOW(),NOW()),(23,14,'??',NOW(),NOW()),(24,39,'???Q?E??',NOW(),NOW()),(25,40,'?????Q',NOW(),NOW()),(26,23,'??',NOW(),NOW()),(27,41,'?X?p????',NOW(),NOW()),(28,8,'?????Q',NOW(),NOW()),(29,13,'?g',NOW(),NOW()),(30,42,'???X?p??',NOW(),NOW()),(31,10,'?????Q',NOW(),NOW()),(32,19,'?{',NOW(),NOW()),(33,43,'??E??',NOW(),NOW()),(34,44,'???????Q',NOW(),NOW()),(35,45,'??',NOW(),NOW()),(36,46,'???E??',NOW(),NOW()),(37,47,'???k',NOW(),NOW()),(38,48,'??',NOW(),NOW()),(39,49,'?{?E??',NOW(),NOW()),(40,50,'?k',NOW(),NOW()),(41,20,'??',NOW(),NOW()),(42,51,'?g?E??',NOW(),NOW()),(43,4,'???R',NOW(),NOW()),(44,52,'??',NOW(),NOW()),(45,53,'??E??',NOW(),NOW()),(46,5,'??R',NOW(),NOW()),(47,54,'?Z?b?g',NOW(),NOW()),(48,55,'???E??',NOW(),NOW()),(49,56,'??',NOW(),NOW()),(50,57,'?L?b?g',NOW(),NOW()),(51,58,'?Z?b?g??',NOW(),NOW()),(52,59,'??',NOW(),NOW()),(53,22,'??',NOW(),NOW()),(54,60,'???Q?E??',NOW(),NOW()),(55,61,'??',NOW(),NOW()),(56,62,'??',NOW(),NOW()),(57,63,'??E??',NOW(),NOW()),(58,64,'????',NOW(),NOW()),(59,6,'??',NOW(),NOW()),(60,65,'??E??',NOW(),NOW()),(61,66,'?E',NOW(),NOW()),(62,67,'???',NOW(),NOW()),(63,11,'????Q',NOW(),NOW()),(64,24,'??',NOW(),NOW()),(65,68,'?????O',NOW(),NOW()),(66,12,'????Q',NOW(),NOW()),(67,69,'??',NOW(),NOW()),(68,70,'??',NOW(),NOW()),(69,71,'???Q?E??',NOW(),NOW()),(70,72,'??',NOW(),NOW()),(71,73,'??',NOW(),NOW()),(72,74,'?S????',NOW(),NOW()),(73,75,'??',NOW(),NOW()),(74,25,'?P?[?X',NOW(),NOW()),(75,76,'???X?p??',NOW(),NOW()),(76,77,'?o',NOW(),NOW()),(77,78,'????',NOW(),NOW()),(78,79,'?|?C???g',NOW(),NOW()),(79,80,'??',NOW(),NOW()),(80,17,'????',NOW(),NOW()),(81,81,'??',NOW(),NOW()),(82,82,'???',NOW(),NOW()); |
|
208 |
/*!40000 ALTER TABLE `unitmaster` ENABLE KEYS */; |
|
209 |
UNLOCK TABLES; |
|
210 |
|
|
211 |
-- |
|
212 |
-- Dumping data for table `yearmaster` |
|
213 |
-- |
|
214 |
|
|
215 |
LOCK TABLES `yearmaster` WRITE; |
|
216 |
/*!40000 ALTER TABLE `yearmaster` DISABLE KEYS */; |
|
217 |
INSERT INTO `yearmaster` VALUES (2010),(2011),(2012),(2013),(2014),(2015),(2016),(2017),(2018),(2019),(2020),(2021),(2022),(2023),(2024),(2025),(2026),(2027),(2028),(2029),(2030),(2031),(2032),(2033),(2034),(2035),(2036),(2037),(2038),(2039),(2040),(2041),(2042),(2043),(2044),(2045),(2046),(2047),(2048),(2049),(2050),(2051),(2052),(2053),(2054),(2055),(2056),(2057),(2058),(2059),(2060),(2061),(2062),(2063),(2064),(2065),(2066),(2067),(2068),(2069),(2070),(2071),(2072),(2073),(2074),(2075),(2076),(2077),(2078),(2079),(2080),(2081),(2082),(2083),(2084),(2085),(2086),(2087),(2088),(2089),(2090),(2091),(2092),(2093),(2094),(2095),(2096),(2097),(2098),(2099),(2100),(2101),(2102),(2103),(2104),(2105),(2106),(2107),(2108),(2109),(2110),(2111),(2112),(2113),(2114); |
|
218 |
/*!40000 ALTER TABLE `yearmaster` ENABLE KEYS */; |
|
219 |
UNLOCK TABLES; |
|
220 |
|
他の形式にエクスポート: Unified diff