개정판 25e0cacb
update
| DTI_PID/DTI_PID/Scripts/FluidCode.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS FluidCode ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
CODE TEXT NOT NULL, |
|
| 4 |
DESCRIPTION TEXT, |
|
| 5 |
CONSTRAINT FluidCode_PK PRIMARY KEY (UID) |
|
| 6 |
); |
|
| 7 |
CREATE UNIQUE INDEX IF NOT EXISTS FluidCode_CODE_IDX ON FluidCode(CODE); |
|
| 1 |
CREATE TABLE IF NOT EXISTS [FluidCode]( |
|
| 2 |
[UID] TEXT CONSTRAINT [FluidCode_PK] PRIMARY KEY NOT NULL, |
|
| 3 |
[CODE] TEXT NOT NULL UNIQUE, |
|
| 4 |
[DESCRIPTION] TEXT); |
|
| 5 |
|
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [FluidCode_CODE_IDX] ON [FluidCode]([CODE]); |
|
내보내기 Unified diff
