개정판 d695194d
issue #000: script, manual update
Change-Id: Ic80fa14db1d5809b4db40c169e826f5c1bd690ca
| DTI_PID/DTI_PID/Scripts/ID2.sql | ||
|---|---|---|
| 258 | 258 |
UID INTEGER PRIMARY KEY AUTOINCREMENT |
| 259 | 259 |
NOT NULL, |
| 260 | 260 |
HMB_UID VARCHAR (37) REFERENCES HMB (UID) ON DELETE CASCADE, |
| 261 |
[From] VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL, |
|
| 262 |
[To] VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL |
|
| 261 |
[From_UID] VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL, |
|
| 262 |
[To_UID] VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL, |
|
| 263 |
[From] VARCHAR (100), |
|
| 264 |
[To] VARCHAR (100) |
|
| 263 | 265 |
); |
| 264 | 266 |
|
| 265 | 267 |
|
| DTI_PID/DTI_PID/Scripts/SQLite_Project.tables.sql | ||
|---|---|---|
| 72 | 72 |
`Priority` varchar ( 37 ), |
| 73 | 73 |
FOREIGN KEY(`Table_UID`) REFERENCES `InstTables`(`UID`), |
| 74 | 74 |
PRIMARY KEY(`UID`) |
| 75 |
); |
|
| 76 |
|
|
| 77 |
CREATE TABLE IF NOT EXISTS Streamlines ( |
|
| 78 |
UID INTEGER PRIMARY KEY AUTOINCREMENT |
|
| 79 |
NOT NULL, |
|
| 80 |
HMB_UID VARCHAR (37) REFERENCES HMB (UID) ON DELETE CASCADE, |
|
| 81 |
[From_UID] VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL, |
|
| 82 |
[To_UID] VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL, |
|
| 83 |
[From] VARCHAR (100), |
|
| 84 |
[To] VARCHAR (100) |
|
| 75 | 85 |
); |
내보내기 Unified diff
