OpenMRS

Timestamp:

05/09/08 10:53:35 (2 months ago)

Author:

bwolfe

Message:

Merging report-api-refactoring to trunk [2696]:[4157]

Files:

• openmrs/trunk/metadata/model/openmrs_1.1.0-to-1.2.0-mysqldiff.sql (modified) (1 diff)

openmrs/trunk/metadata/model/openmrs_1.1.0-to-1.2.0-mysqldiff.sql

@@ -72 +72 @@
-
-
+#----------------------------------------
+# OpenMRS Datamodel version 1.1.12
+# Ben Wolfe                 Dec 27th 2007
+# Adding report_schema_xml table
+#----------------------------------------
+
+DROP PROCEDURE IF EXISTS diff_procedure;
+
+delimiter //
+
+CREATE PROCEDURE diff_procedure (IN new_db_version VARCHAR(10))
+ BEGIN
+        IF (SELECT REPLACE(property_value, '.', '0') < REPLACE(new_db_version, '.', '0') FROM global_property WHERE property = 'database_version') THEN
+        SELECT CONCAT('Updating to ', new_db_version) AS 'Datamodel Update:' FROM dual;
+        
+        CREATE TABLE `report_schema_xml` (
+          `report_schema_id` int(11) NOT NULL auto_increment,
+          `name` varchar(255) NOT NULL,
+          `description` text NOT NULL,
+          `xml_data` text NOT NULL,
+          PRIMARY KEY  (`report_schema_id`)
+        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+        
+        UPDATE `global_property` SET property_value=new_db_version WHERE property = 'database_version';
+        
+        END IF;
+ END;
+//
+
+delimiter ;
+call diff_procedure('1.1.12');
+
-#---------------------------------------
-# Update OpenMRS to 1.2.0