개정판 7bc24847
edit issue #581: edit Script
| DTI_PID/DTI_PID/Scripts/FluidCode.sql | ||
|---|---|---|
| 3 | 3 |
[CODE] TEXT NOT NULL UNIQUE, |
| 4 | 4 |
[DESCRIPTION] TEXT); |
| 5 | 5 |
|
| 6 |
CREATE UNIQUE INDEX [FluidCode_CODE_IDX] ON [FluidCode]([CODE]); |
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [FluidCode_CODE_IDX] ON [FluidCode]([CODE]); |
|
| DTI_PID/DTI_PID/Scripts/InsulationPurpose.sql | ||
|---|---|---|
| 3 | 3 |
[CODE] TEXT NOT NULL UNIQUE, |
| 4 | 4 |
[DESCRIPTION] TEXT); |
| 5 | 5 |
|
| 6 |
CREATE UNIQUE INDEX [InsulationPurpose_CODE_IDX] |
|
| 7 |
ON [InsulationPurpose]([CODE]); |
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [InsulationPurpose_CODE_IDX] ON [InsulationPurpose]([CODE]); |
|
| DTI_PID/DTI_PID/Scripts/PipingMaterialsClass.sql | ||
|---|---|---|
| 3 | 3 |
[CODE] TEXT NOT NULL UNIQUE, |
| 4 | 4 |
[DESCRIPTION] TEXT); |
| 5 | 5 |
|
| 6 |
CREATE UNIQUE INDEX [PipingMaterialsClass_CODE_IDX] ON [PipingMaterialsClass]([CODE]); |
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [PipingMaterialsClass_CODE_IDX] ON [PipingMaterialsClass]([CODE]); |
|
| DTI_PID/DTI_PID/Scripts/PnIDNumber.sql | ||
|---|---|---|
| 3 | 3 |
[CODE] TEXT NOT NULL UNIQUE, |
| 4 | 4 |
[DESCRIPTION] TEXT); |
| 5 | 5 |
|
| 6 |
CREATE UNIQUE INDEX [PnIDNumber_CODE_IDX] ON [PnIDNumber]([CODE]); |
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [PnIDNumber_CODE_IDX] ON [PnIDNumber]([CODE]); |
|
| DTI_PID/DTI_PID/Scripts/UnitNumber.sql | ||
|---|---|---|
| 3 | 3 |
[CODE] TEXT NOT NULL UNIQUE, |
| 4 | 4 |
[DESCRIPTION] TEXT); |
| 5 | 5 |
|
| 6 |
CREATE UNIQUE INDEX [UnitNumber_CODE_IDX] ON [UnitNumber]([CODE]); |
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [UnitNumber_CODE_IDX] ON [UnitNumber]([CODE]); |
|
내보내기 Unified diff
