Changes between Version 4 and Version 5 of i2b2 HowTo Create an Ontology

Timestamp:

10/07/13 12:03:49 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create an Ontology

@@ -172 +172 @@
 EXEC (@TCreateOntologyTable);
 
+-- Upgrade ontology table to version 1.6
+
+DECLARE @UpgradeOntology1_6A VARCHAR(MAX)
+DECLARE @UpgradeOntology1_6B VARCHAR(MAX)
+
+SET @UpgradeOntology1_6A = '
+    ALTER TABLE ' + @OntologyName + '
+        ADD m_applied_path varchar(700) NULL
+    ;
+    
+    ALTER TABLE ' + @OntologyName + '
+        ADD m_exclusion_cd varchar(25) NULL
+    ;
+    
+    ALTER TABLE ' + @OntologyName + '
+        ADD     C_PATH  VARCHAR(700)   NULL
+    ;
+    
+    ALTER TABLE ' + @OntologyName + '
+        ADD     C_SYMBOL VARCHAR(50)    NULL
+    ;
+'
+
+SET @UpgradeOntology1_6B = '
+    UPDATE ' + @OntologyName + '
+    SET m_applied_path = ''@''
+    ;
+
+    ALTER TABLE ' + @OntologyName + '
+        ALTER COLUMN [m_applied_path] varchar(700) NOT NULL
+    ;
+        
+    CREATE INDEX ' + @OntologyName + '_META_FULLNAME_IDX ON ' + @OntologyName + '(C_FULLNAME);
+    
+    CREATE INDEX ' + @OntologyName + '_META_APPLIED_PATH_IDX ON ' + @OntologyName + '(M_APPLIED_PATH);  
+'
+
+EXEC (@UpgradeOntology1_6A);
+EXEC (@UpgradeOntology1_6B);
+
 --
 -- CREATE SCHEME