プロジェクト

全般

プロフィール

リビジョン 109

山内7年以上前に追加

データ投入(銀行営業日マスタ)暫定で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