リビジョン 475
台帳作成前入金データ追加
| ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2019/12/07 16:08:48
|
|
| 2 |
-- Date/Time : 2020/01/25 17:17:05
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 221 | 221 |
, constraint bankbusinessdaymaster_PKC primary key (YEARMONTH,BANKBUSINESSDAY) |
| 222 | 222 |
) comment '??s?c????}?X?^' ; |
| 223 | 223 |
|
| 224 |
-- ?H?????????O?f?[?^ |
|
| 225 |
--* BackupToTempTable |
|
| 226 |
drop table if exists beforecreatingledger cascade; |
|
| 227 |
|
|
| 228 |
--* RestoreFromTempTable |
|
| 229 |
create table beforecreatingledger ( |
|
| 230 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
| 231 |
, GroupCount decimal(2,0) unsigned not null comment '?O???[?v???' |
|
| 232 |
, TargetMonth decimal(6,0) unsigned not null comment '???N??' |
|
| 233 |
, PaymentAmount decimal(12,0) not null comment '???????z' |
|
| 234 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 235 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 236 |
, constraint beforecreatingledger_PKC primary key (ConstructionCode,GroupCount,TargetMonth) |
|
| 237 |
) comment '?H?????????O?f?[?^' ; |
|
| 238 |
|
|
| 224 | 239 |
-- ???????f?[?^ |
| 225 | 240 |
--* BackupToTempTable |
| 226 | 241 |
drop table if exists billingdata cascade; |
他の形式にエクスポート: Unified diff