Revision 6945
Added by ben leinfelder about 11 years ago
| upgrade-db-to-2.0.0-oracle.sql | ||
|---|---|---|
| 37 | 37 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE |
| 38 | 38 |
); |
| 39 | 39 |
|
| 40 |
DROP TABLE identifier; |
|
| 40 |
DROP TABLE IF EXISTS identifier;
|
|
| 41 | 41 |
|
| 42 | 42 |
CREATE TABLE identifier ( |
| 43 | 43 |
guid VARCHAR2(2000), -- the globally unique string identifier |
Also available in: Unified diff
add "IF EXISTS" clause to identifier table drop in case it does not exist on the given deployment (as is the case on the KNB)