개정판 e540076b
issue #000 update_database.sql 수정.
1.PAPUploadInformation,PAPUploadInformationItem insert query문 추가.
Change-Id: I44bceaeb6842ba5412907138a0f2b8b238af5339
| HYTOS/HYTOS/Scripts/update_database.sql | ||
|---|---|---|
| 10 | 10 |
HHP REAL, |
| 11 | 11 |
dpRatio REAL |
| 12 | 12 |
); |
| 13 |
CREATE TABLE IF NOT EXISTS PAPUploadInformation ( |
|
| 14 |
Project_UID TEXT NOT NULL, |
|
| 15 |
ProjectNo TEXT, |
|
| 16 |
CalculationCase TEXT, |
|
| 17 |
CreateDateTime datetime NOT NULL DEFAULT (datetime('now', 'localtime')),
|
|
| 18 |
PRIMARY KEY(Project_UID) |
|
| 19 |
); |
|
| 13 | 20 |
|
| 21 |
CREATE TABLE IF NOT EXISTS PAPUploadInformationItem ( |
|
| 22 |
Components_UID TEXT NOT NULL, |
|
| 23 |
Project_UID TEXT NOT NULL, |
|
| 24 |
ProjectNo TEXT, |
|
| 25 |
Components_Type TEXT, |
|
| 26 |
Components_ItemNo TEXT, |
|
| 27 |
Components_DataCase TEXT, |
|
| 28 |
PRIMARY KEY(Components_UID, Project_UID) |
|
| 29 |
); |
|
| 14 | 30 |
insert or replace into SymbolType(UID,Category,Type) values('8502d693-2e13-422f-b81a-67edf19dc07d', 'Callout', 'Callout');
|
| 15 | 31 |
insert or replace into Symbols(UID,Name,Display_Name,SymbolType_UID,OriginalPoint) values('c288afbb-2612-4b8e-9932-2a84815cfa4e', 'Callout', 'Callout','8502d693-2e13-422f-b81a-67edf19dc07d', '0,0,0,0');
|
| 16 | 32 |
insert or replace into Symbols(UID,Name,Display_Name,SymbolType_UID,OriginalPoint) values('22384e9d-74d7-4639-b500-73ac6285ff8a', 'Dimension', 'Dimension', '8502d693-2e13-422f-b81a-67edf19dc07d', '0,0,0,0');
|
내보내기 Unified diff
