OpenMRS

Timestamp:

05/16/08 13:28:28 (4 months ago)

Author:

bwolfe

Message:

api-refactoring: Re-refactoring some of the api services

Files:

• openmrs/branches/api_refactoring/metadata/model/update-to-latest-db.mysqldiff.sql (modified) (1 diff)

openmrs/branches/api_refactoring/metadata/model/update-to-latest-db.mysqldiff.sql

@@ -797 +797 @@
-call diff_procedure('1.3.0.06');
-
+#----------------------------------------
+# OpenMRS Datamodel version 1.3.0.07
+# Ben Wolfe               May 16th, 2008
+# Adding retired* columns to Concept
+
+#----------------------------------------
+
+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;
+
+    ALTER TABLE `concept` ADD COLUMN `retired_by` int(11) default NULL;
+    ALTER TABLE `concept` ADD COLUMN `date_retired` datetime default NULL;
+    ALTER TABLE `concept` ADD COLUMN `retire_reason` varchar(255) default NULL;
+    ALTER TABLE `concept` ADD KEY `user_who_retired_concept` (`retired_by`);
+    ALTER TABLE `concept` ADD CONSTRAINT `user_who_retired_concept` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`);
+        
+        ALTER TABLE `concept_datatype` ADD COLUMN `retired_by` int(11) default NULL;
+    ALTER TABLE `concept_datatype` ADD COLUMN `date_retired` datetime default NULL;
+    ALTER TABLE `concept_datatype` ADD COLUMN `retire_reason` varchar(255) default NULL;
+    ALTER TABLE `concept_datatype` ADD KEY `user_who_retired_concept_datatype` (`retired_by`);
+    ALTER TABLE `concept_datatype` ADD CONSTRAINT `user_who_retired_concept_datatype` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`);
+        ALTER TABLE `concept_datatype` ADD INDEX `concept_datatype_retired_status` (`retired`);
+
+        ALTER TABLE `concept_class` ADD COLUMN `retired_by` int(11) default NULL;
+    ALTER TABLE `concept_class` ADD COLUMN `date_retired` datetime default NULL;
+    ALTER TABLE `concept_class` ADD COLUMN `retire_reason` varchar(255) default NULL;
+    ALTER TABLE `concept_class` ADD KEY `user_who_retired_concept_class` (`retired_by`);
+    ALTER TABLE `concept_class` ADD CONSTRAINT `user_who_retired_concept_class` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`);
+        ALTER TABLE `concept_class` ADD INDEX `concept_class_retired_status` (`retired`);
+        
+        ALTER TABLE `drug` CHANGE COLUMN `voided` `retired` tinyint(1) NOT NULL default '0';
+        ALTER TABLE `drug` DROP FOREIGN KEY `user_who_voided_drug`;
+        ALTER TABLE `drug` CHANGE COLUMN `voided_by` `retired_by` int(11) default NULL;
+        ALTER TABLE `drug` ADD CONSTRAINT `drug_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`);
+        ALTER TABLE `drug` CHANGE COLUMN `date_voided` `date_retired` datetime default NULL;
+        ALTER TABLE `drug` DROP COLUMN `retired_reason`;
+        
+    UPDATE `global_property` SET property_value=new_db_version WHERE property = 'database_version';
+    
+    END IF;
+ END;
+//
+
+delimiter ;
+call diff_procedure('1.3.0.07');
+
-
-#-----------------------------------