リビジョン 109
データ投入(銀行営業日マスタ)暫定で2017年6月までインサート
branches/ddl/ProcessManagement.sql | ||
---|---|---|
2274 | 2274 |
alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ; |
2275 | 2275 |
|
2276 | 2276 |
|
2277 |
-- データ投入 |
|
2278 |
-- 銀行営業日マスタ |
|
2279 |
LOCK TABLES `bankbusinessdaymaster` WRITE; |
|
2280 |
/*!40000 ALTER TABLE `bankbusinessdaymaster` DISABLE KEYS */; |
|
2281 |
INSERT INTO `bankbusinessdaymaster` VALUES (201611,2,NULL,0,NULL,NULL),(201611,4,NULL,0,NULL,NULL),(201611,7,NULL,0,NULL,NULL),(201611,8,NULL,0,NULL,NULL),(201611,9,NULL,0,NULL,NULL),(201611,10,NULL,0,NULL,NULL),(201611,11,NULL,0,NULL,NULL),(201611,14,NULL,0,NULL,NULL),(201611,15,NULL,0,NULL,NULL),(201611,16,NULL,0,NULL,NULL),(201611,17,NULL,0,NULL,NULL),(201611,18,NULL,0,NULL,NULL),(201611,21,NULL,0,NULL,NULL),(201611,22,NULL,0,NULL,NULL),(201611,24,NULL,0,NULL,NULL),(201611,25,NULL,0,NULL,NULL),(201611,28,NULL,0,NULL,NULL),(201611,29,NULL,0,NULL,NULL),(201611,30,NULL,0,NULL,NULL),(201612,1,NULL,0,NULL,NULL),(201612,2,NULL,0,NULL,NULL),(201612,5,NULL,0,NULL,NULL),(201612,6,NULL,0,NULL,NULL),(201612,7,NULL,0,NULL,NULL),(201612,8,NULL,0,NULL,NULL),(201612,9,NULL,0,NULL,NULL),(201612,12,NULL,0,NULL,NULL),(201612,13,NULL,0,NULL,NULL),(201612,14,NULL,0,NULL,NULL),(201612,15,NULL,0,NULL,NULL),(201612,16,NULL,0,NULL,NULL),(201612,19,NULL,0,NULL,NULL),(201612,20,NULL,0,NULL,NULL),(201612,21,NULL,0,NULL,NULL),(201612,22,NULL,0,NULL,NULL),(201612,26,NULL,0,NULL,NULL),(201612,27,NULL,0,NULL,NULL),(201612,28,NULL,0,NULL,NULL),(201612,29,NULL,0,NULL,NULL),(201612,30,NULL,0,NULL,NULL),(201701,4,NULL,0,NULL,NULL),(201701,5,NULL,0,NULL,NULL),(201701,6,NULL,0,NULL,NULL),(201701,10,NULL,0,NULL,NULL),(201701,11,NULL,0,NULL,NULL),(201701,12,NULL,0,NULL,NULL),(201701,13,NULL,0,NULL,NULL),(201701,16,NULL,0,NULL,NULL),(201701,17,NULL,0,NULL,NULL),(201701,18,NULL,0,NULL,NULL),(201701,19,NULL,0,NULL,NULL),(201701,20,NULL,0,NULL,NULL),(201701,23,NULL,0,NULL,NULL),(201701,24,NULL,0,NULL,NULL),(201701,25,NULL,0,NULL,NULL),(201701,26,NULL,0,NULL,NULL),(201701,27,NULL,0,NULL,NULL),(201701,30,NULL,0,NULL,NULL),(201701,31,NULL,0,NULL,NULL),(201702,1,NULL,0,NULL,NULL),(201702,2,NULL,0,NULL,NULL),(201702,3,NULL,0,NULL,NULL),(201702,6,NULL,0,NULL,NULL),(201702,7,NULL,0,NULL,NULL),(201702,8,NULL,0,NULL,NULL),(201702,9,NULL,0,NULL,NULL),(201702,10,NULL,0,NULL,NULL),(201702,13,NULL,0,NULL,NULL),(201702,14,NULL,0,NULL,NULL),(201702,15,NULL,0,NULL,NULL),(201702,16,NULL,0,NULL,NULL),(201702,17,NULL,0,NULL,NULL),(201702,20,NULL,0,NULL,NULL),(201702,21,NULL,0,NULL,NULL),(201702,22,NULL,0,NULL,NULL),(201702,23,NULL,0,NULL,NULL),(201702,24,NULL,0,NULL,NULL),(201702,27,NULL,0,NULL,NULL),(201702,28,NULL,0,NULL,NULL),(201703,1,NULL,0,NULL,NULL),(201703,2,NULL,0,NULL,NULL),(201703,3,NULL,0,NULL,NULL),(201703,6,NULL,0,NULL,NULL),(201703,7,NULL,0,NULL,NULL),(201703,8,NULL,0,NULL,NULL),(201703,9,NULL,0,NULL,NULL),(201703,10,NULL,0,NULL,NULL),(201703,13,NULL,0,NULL,NULL),(201703,14,NULL,0,NULL,NULL),(201703,15,NULL,0,NULL,NULL),(201703,16,NULL,0,NULL,NULL),(201703,17,NULL,0,NULL,NULL),(201703,21,NULL,0,NULL,NULL),(201703,22,NULL,0,NULL,NULL),(201703,23,NULL,0,NULL,NULL),(201703,24,NULL,0,NULL,NULL),(201703,27,NULL,0,NULL,NULL),(201703,28,NULL,0,NULL,NULL),(201703,29,NULL,0,NULL,NULL),(201703,30,NULL,0,NULL,NULL),(201703,31,NULL,0,NULL,NULL),(201704,3,NULL,0,NULL,NULL),(201704,4,NULL,0,NULL,NULL),(201704,5,NULL,0,NULL,NULL),(201704,6,NULL,0,NULL,NULL),(201704,7,NULL,0,NULL,NULL),(201704,10,NULL,0,NULL,NULL),(201704,11,NULL,0,NULL,NULL),(201704,12,NULL,0,NULL,NULL),(201704,13,NULL,0,NULL,NULL),(201704,14,NULL,0,NULL,NULL),(201704,17,NULL,0,NULL,NULL),(201704,18,NULL,0,NULL,NULL),(201704,19,NULL,0,NULL,NULL),(201704,20,NULL,0,NULL,NULL),(201704,21,NULL,0,NULL,NULL),(201704,24,NULL,0,NULL,NULL),(201704,25,NULL,0,NULL,NULL),(201704,26,NULL,0,NULL,NULL),(201704,27,NULL,0,NULL,NULL),(201704,28,NULL,0,NULL,NULL),(201705,1,NULL,0,NULL,NULL),(201705,2,NULL,0,NULL,NULL),(201705,8,NULL,0,NULL,NULL),(201705,9,NULL,0,NULL,NULL),(201705,10,NULL,0,NULL,NULL),(201705,11,NULL,0,NULL,NULL),(201705,12,NULL,0,NULL,NULL),(201705,15,NULL,0,NULL,NULL),(201705,16,NULL,0,NULL,NULL),(201705,17,NULL,0,NULL,NULL),(201705,18,NULL,0,NULL,NULL),(201705,19,NULL,0,NULL,NULL),(201705,22,NULL,0,NULL,NULL),(201705,23,NULL,0,NULL,NULL),(201705,24,NULL,0,NULL,NULL),(201705,25,NULL,0,NULL,NULL),(201705,26,NULL,0,NULL,NULL),(201705,29,NULL,0,NULL,NULL),(201705,30,NULL,0,NULL,NULL),(201705,31,NULL,0,NULL,NULL),(201706,1,NULL,0,NULL,NULL),(201706,2,NULL,0,NULL,NULL),(201706,5,NULL,0,NULL,NULL),(201706,6,NULL,0,NULL,NULL),(201706,7,NULL,0,NULL,NULL),(201706,8,NULL,0,NULL,NULL),(201706,9,NULL,0,NULL,NULL),(201706,12,NULL,0,NULL,NULL),(201706,13,NULL,0,NULL,NULL),(201706,14,NULL,0,NULL,NULL),(201706,15,NULL,0,NULL,NULL),(201706,16,NULL,0,NULL,NULL),(201706,19,NULL,0,NULL,NULL),(201706,20,NULL,0,NULL,NULL),(201706,21,NULL,0,NULL,NULL),(201706,22,NULL,0,NULL,NULL),(201706,23,NULL,0,NULL,NULL),(201706,26,NULL,0,NULL,NULL),(201706,27,NULL,0,NULL,NULL),(201706,28,NULL,0,NULL,NULL),(201706,29,NULL,0,NULL,NULL),(201706,30,NULL,0,NULL,NULL); |
|
2282 |
/*!40000 ALTER TABLE `bankbusinessdaymaster` ENABLE KEYS */; |
|
2283 |
UNLOCK TABLES; |
|
2284 |
|
他の形式にエクスポート: Unified diff