개정판 9eb852fc
issue #622: update sqlite script
Change-Id: Iff6b34b03701205d0b350bc1d956fc98bf252bfc
DTI_PID/DTI_PID/Scripts/SQLite_Project.tables.sql | ||
---|---|---|
44 | 44 |
`Condition` VARCHAR(37), PRIMARY KEY(`UID`) |
45 | 45 |
); |
46 | 46 |
|
47 |
CREATE TABLE IF NOT EXISTS 'Views' ( |
|
48 |
'Drawings_UID' VARCHAR (37) REFERENCES 'Drawings' (UID) ON DELETE CASCADE |
|
49 |
PRIMARY KEY, |
|
50 |
'X' REAL DEFAULT (0), |
|
51 |
'Y' REAL DEFAULT (0), |
|
52 |
'Width' REAL DEFAULT (0), |
|
53 |
'Height' REAL DEFAULT (0) |
|
47 |
CREATE TABLE IF NOT EXISTS `Views` ( |
|
48 |
`Drawings_UID` VARCHAR ( 37 ), |
|
49 |
`X` REAL DEFAULT (0), |
|
50 |
`Y` REAL DEFAULT (0), |
|
51 |
`Width` REAL DEFAULT (0), |
|
52 |
`Height` REAL DEFAULT (0), |
|
53 |
FOREIGN KEY(`Drawings_UID`) REFERENCES `Drawings`(`UID`) ON DELETE CASCADE, |
|
54 |
PRIMARY KEY(`Drawings_UID`) |
|
54 | 55 |
); |
내보내기 Unified diff