개정판 efec7833
issue #662: update script
Change-Id: I3152ab7884e060bcf2bac77946f1f7f49314cddb
DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
---|---|---|
3203 | 3203 |
[Action] VARCHAR(37), |
3204 | 3204 |
[Condition] VARCHAR(37), |
3205 | 3205 |
PRIMARY KEY([UID]) |
3206 |
); |
|
3207 |
|
|
3208 |
CREATE TABLE Views ( |
|
3209 |
[Drawings_UID] VARCHAR ( 37 ), |
|
3210 |
[X] REAL DEFAULT (0), |
|
3211 |
[Y] REAL DEFAULT (0), |
|
3212 |
[Width] REAL DEFAULT (0), |
|
3213 |
[Height] REAL DEFAULT (0), |
|
3214 |
FOREIGN KEY([Drawings_UID]) REFERENCES [Drawings]([UID]) ON DELETE CASCADE, |
|
3215 |
PRIMARY KEY([Drawings_UID]) |
|
3206 | 3216 |
); |
내보내기 Unified diff