リビジョン 368
工事担当変更履歴データ:フィールド追加
レコード番号管理:テーブル追加
| branches/ddl/20180629_SQL.txt | ||
|---|---|---|
| 1 |
-- ???R?[?h?????? |
|
| 2 |
drop table if exists RecordKey cascade; |
|
| 3 |
|
|
| 4 |
create table RecordKey ( |
|
| 5 |
KeyNo decimal(2,0) unsigned not null comment '?L?[?R?[?h' |
|
| 6 |
, RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???' |
|
| 7 |
|
|
| 8 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 9 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 10 |
, constraint RecordKey_PKC primary key (KeyNo, RecordNumber) |
|
| 11 |
) comment '???R?[?h??????' ; |
|
| 12 |
|
|
| 13 |
Insert recordkey Value ( |
|
| 14 |
1 |
|
| 15 |
, ( |
|
| 16 |
SELECT |
|
| 17 |
IFNULL(MAX(RecordNumber), 0) |
|
| 18 |
From |
|
| 19 |
messageboarddata |
|
| 20 |
) |
|
| 21 |
, NOW() |
|
| 22 |
, NOW() |
|
| 23 |
); |
|
| 24 |
commit; |
|
| branches/ddl/ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2018/06/19 8:22:40
|
|
| 2 |
-- Date/Time : 2018/07/24 8:34:39
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 362 | 362 |
, PersonCode decimal(8,0) not null comment '?S????R?[?h' |
| 363 | 363 |
, StartDate date comment '?S???J?n?N????' |
| 364 | 364 |
, CompDate date comment '?S???I???N????' |
| 365 |
, SourceCode decimal(10,0) unsigned not null comment '???H???R?[?h' |
|
| 366 |
, DeleteFlg decimal(1,0) not null comment '???t???O' |
|
| 365 | 367 |
, EntryDate datetime not null comment '?o?^???t' |
| 366 | 368 |
, UpdateDate datetime not null comment '?X?V???t' |
| 367 | 369 |
, constraint chgconstrcharge_PKC primary key (ConstructionCode,Division,SeqNo) |
| ... | ... | |
| 1998 | 2000 |
create index POrderDetail_Index1 |
| 1999 | 2001 |
on purchaseorderdetail(SourceCode); |
| 2000 | 2002 |
|
| 2003 |
-- ???R?[?h?????? |
|
| 2004 |
drop table if exists recordkey cascade; |
|
| 2005 |
|
|
| 2006 |
create table recordkey ( |
|
| 2007 |
KeyNo decimal(2,0) unsigned not null comment '?L?[?R?[?h' |
|
| 2008 |
, RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???' |
|
| 2009 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 2010 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 2011 |
, constraint recordkey_PKC primary key (KeyNo,RecordNumber) |
|
| 2012 |
) comment '???R?[?h??????' ; |
|
| 2013 |
|
|
| 2001 | 2014 |
-- ?????f?[?^ |
| 2002 | 2015 |
drop table if exists requestdata cascade; |
| 2003 | 2016 |
|
他の形式にエクスポート: Unified diff