개정판 2b57a455
issue #49: db script
Change-Id: Ia4ffe969278715a1cf89c9893c14fc9e72b69788
| DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
|---|---|---|
| 2098 | 2098 |
PRIMARY KEY(UID), |
| 2099 | 2099 |
FOREIGN KEY(SymbolAttribute_UID) REFERENCES SymbolAttribute (UID) |
| 2100 | 2100 |
); |
| 2101 |
|
|
| 2102 |
CREATE TABLE IF NOT EXISTS CustomCodes ( |
|
| 2103 |
UID VARCHAR ( 37 ) NOT NULL, |
|
| 2104 |
Table_UID VARCHAR ( 37 ) NOT NULL, |
|
| 2105 |
[Name] VARCHAR ( 32 ) NOT NULL, |
|
| 2106 |
Code VARCHAR ( 32 ) NOT NULL, |
|
| 2107 |
Description TEXT, |
|
| 2108 |
Allowables TEXT, |
|
| 2109 |
CONSTRAINT CustomCodes_PK PRIMARY KEY(UID) |
|
| 2110 |
); |
|
| DTI_PID/DTI_PID/Scripts/Project.Projects.sql | ||
|---|---|---|
| 13 | 13 |
NOT NULL, |
| 14 | 14 |
Name TEXT |
| 15 | 15 |
); |
| 16 |
|
|
| 16 | 17 |
INSERT INTO DBTypes(Name) select 'SQLite' where not exists(select 1 from DBTypes where Name='SQLite'); |
| 17 | 18 |
INSERT INTO DBTypes(Name) select 'MSSQL' where not exists(select 1 from DBTypes where Name='MSSQL'); |
| 18 | 19 |
|
| DTI_PID/DTI_PID/Scripts/SQLite_Project.tables.sql | ||
|---|---|---|
| 13 | 13 |
`SymbolAttribute_UID` VARCHAR ( 37 ) NOT NULL, |
| 14 | 14 |
PRIMARY KEY(`UID`), |
| 15 | 15 |
FOREIGN KEY(`SymbolAttribute_UID`) REFERENCES `SymbolAttribute`(`UID`) |
| 16 |
); |
|
| 17 |
|
|
| 18 |
CREATE TABLE IF NOT EXISTS "CustomCodes" ( |
|
| 19 |
`UID` VARCHAR ( 37 ) NOT NULL, |
|
| 20 |
`Table_UID` VARCHAR ( 37 ) NOT NULL, |
|
| 21 |
`Name` VARCHAR ( 32 ) NOT NULL, |
|
| 22 |
`Code` VARCHAR ( 32 ) NOT NULL, |
|
| 23 |
'Description` TEXT, |
|
| 24 |
`Allowables` TEXT, |
|
| 25 |
CONSTRAINT `CustomCodes_PK` PRIMARY KEY(`UID`) |
|
| 16 | 26 |
); |
내보내기 Unified diff
