Downloads Documentation Community
Contribute
Contribute Demo






Show Sidebar
Login | Register


Show
Ignore:
Timestamp:
05/21/08 02:20:21 (6 months ago)
Author:
bwolfe
Message:

api-refactoring: adding fixes for concepts

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

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

    r4240 r4290  
    819819    ALTER TABLE `concept` ADD CONSTRAINT `user_who_retired_concept` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`); 
    820820         
    821         ALTER TABLE `concept_datatype` ADD COLUMN `retired_by` int(11) default NULL; 
     821        ALTER TABLE `concept_datatype` ADD COLUMN `retired` tinyint(1) NOT NULL default 0; 
     822    ALTER TABLE `concept_datatype` ADD COLUMN `retired_by` int(11) default NULL; 
    822823    ALTER TABLE `concept_datatype` ADD COLUMN `date_retired` datetime default NULL; 
    823824    ALTER TABLE `concept_datatype` ADD COLUMN `retire_reason` varchar(255) default NULL; 
    …… 
    826827        ALTER TABLE `concept_datatype` ADD INDEX `concept_datatype_retired_status` (`retired`); 
    827828 
    828         ALTER TABLE `concept_class` ADD COLUMN `retired_by` int(11) default NULL; 
     829        ALTER TABLE `concept_class` ADD COLUMN `retired` tinyint(1) NOT NULL default 0; 
     830    ALTER TABLE `concept_class` ADD COLUMN `retired_by` int(11) default NULL; 
    829831    ALTER TABLE `concept_class` ADD COLUMN `date_retired` datetime default NULL; 
    830832    ALTER TABLE `concept_class` ADD COLUMN `retire_reason` varchar(255) default NULL; 
    …… 
    838840        ALTER TABLE `drug` ADD CONSTRAINT `drug_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`); 
    839841        ALTER TABLE `drug` CHANGE COLUMN `date_voided` `date_retired` datetime default NULL; 
    840         ALTER TABLE `drug` DROP COLUMN `retired_reason`; 
     842        ALTER TABLE `drug` CHANGE COLUMN `void_reason` `retire_reason` datetime default NULL; 
     843         
     844        ALTER TABLE `concept_name` ADD COLUMN `concept_name_id` int(11) UNIQUE KEY NOT NULL AUTO_INCREMENT; 
     845        ALTER TABLE `concept_name` ADD INDEX `unique_concept_name_id` (`concept_id`); 
     846        ALTER TABLE `concept_name` DROP PRIMARY KEY, ADD PRIMARY KEY (`concept_name_id`); 
    841847         
    842848    UPDATE `global_property` SET property_value=new_db_version WHERE property = 'database_version';