- 论坛徽章:
- 1
|
- echo 'create raw table "picccar".prplafterward
- > (
- > id decimal(19,0) not null ,
- > claimno char(22) not null ,
- > kindcode char(6),
- > chargecode char(3),
- > chargename char(16),
- > currency char(3),
- > chargeamount decimal(14,2),
- > sumrealpay decimal(14,2),
- > dealdate datetime year to second,
- > flag char(10),
- > remark varchar(255),
- > validflag char(1) not null ,
- > inserttimeforhis datetime year to second
- > default current year to second,
- > operatetimeforhis datetime year to second
- > default current year to second,
- > primary key (id)
- > ) extent size 16 next size 16 lock mode row;
- > '|sed '$!N;s/,\([^,]*\n.*primary key (handlercode)\)/\1/;P;D'
- create raw table "picccar".prplafterward
- (
- id decimal(19,0) not null ,
- claimno char(22) not null ,
- kindcode char(6),
- chargecode char(3),
- chargename char(16),
- currency char(3),
- chargeamount decimal(14,2),
- sumrealpay decimal(14,2),
- dealdate datetime year to second,
- flag char(10),
- remark varchar(255),
- validflag char(1) not null ,
- inserttimeforhis datetime year to second
- default current year to second,
- operatetimeforhis datetime year to second
- default current year to second,
- primary key (id)
- ) extent size 16 next size 16 lock mode row;
复制代码 |
|