Changes between Version 8 and Version 9 of i2b2 HowTo Create a Project

Timestamp:

08/04/15 16:00:54 (9 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create a Project

@@ -123 +123 @@
   * bin/project-install/2-update-datasources.sh [Project Name]
 
-=== 4. Create the ontology
+=== 4. Amend Tables
+
+{{{
+ALTER TABLE Observation_Fact
+ADD TEXT_SEARCH_INDEX INT NULL
+;
+
+ALTER TABLE Patient_Dimension
+ADD INCOME_CD VARCHAR(50) NULL
+;
+
+ALTER TABLE Visit_Dimension
+ADD LENGTH_OF_STAY INT NULL
+;
+}}}
+
+
+=== 5. Create the ontology
 
 See: [[i2b2 HowTo Create an Ontology]]