개정판 a882d9e5
issue #1465: sql update
Change-Id: If12249a0f0a8dd87591c86e7f7c45dcd5bd09430
| DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
|---|---|---|
| 3237 | 3237 |
[Stream_No] VARCHAR ( 100 ) NOT NULL, |
| 3238 | 3238 |
[From] VARCHAR ( 100 ), |
| 3239 | 3239 |
[To] VARCHAR ( 100 ), |
| 3240 |
[Type] VARCHAR ( 100 ), |
|
| 3240 | 3241 |
PRIMARY KEY([UID]) |
| 3241 | 3242 |
); |
| 3242 | 3243 | |
| ... | ... | |
| 3256 | 3257 |
[Name] VARCHAR ( 100 ) NOT NULL, |
| 3257 | 3258 |
[Unit] VARCHAR ( 100 ), |
| 3258 | 3259 |
[index] INTEGER NOT NULL, |
| 3260 |
[Type] VARCHAR ( 100 ), |
|
| 3259 | 3261 |
PRIMARY KEY([UID]) |
| 3260 | 3262 |
); |
| DTI_PID/DTI_PID/Scripts/SQLite_Project.tables.sql | ||
|---|---|---|
| 78 | 78 |
`UID` VARCHAR(37), |
| 79 | 79 |
`Stream_No` VARCHAR ( 100 ) NOT NULL, |
| 80 | 80 |
`From` VARCHAR ( 100 ), |
| 81 |
`To` VARCHAR ( 100 ), PRIMARY KEY(`UID`) |
|
| 81 |
`To` VARCHAR ( 100 ), |
|
| 82 |
`Type` VARCHAR ( 100 ), |
|
| 83 |
PRIMARY KEY(`UID`) |
|
| 82 | 84 |
); |
| 83 | 85 | |
| 84 | 86 |
CREATE TABLE IF NOT EXISTS "HMB_From_To" ( |
| ... | ... | |
| 98 | 100 |
`Name` VARCHAR ( 100 ) NOT NULL, |
| 99 | 101 |
`Unit` VARCHAR ( 100 ), |
| 100 | 102 |
`index` INTEGER NOT NULL, |
| 103 |
`Type` VARCHAR ( 100 ), |
|
| 101 | 104 |
PRIMARY KEY(`UID`) |
| 102 | 105 |
); |
내보내기 Unified diff