Changeset 4308 for openmrs/branches/api_refactoring/metadata/model/update-to-latest-db.mysqldiff.sql
- Timestamp:
- 05/21/08 19:00:12 (8 months ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
openmrs/branches/api_refactoring/metadata/model/update-to-latest-db.mysqldiff.sql
r4290 r4308 684 684 ALTER TABLE `order_type` ADD COLUMN `retired_by` int(11) default NULL; 685 685 ALTER TABLE `order_type` ADD COLUMN `date_retired` datetime default NULL; 686 ALTER TABLE `order_type` ADD COLUMN `retire_reason` varchar(255) default NULL; 686 687 ALTER TABLE `order_type` ADD KEY `user_who_retired_order_type` (`retired_by`); 687 688 ALTER TABLE `order_type` ADD CONSTRAINT `user_who_retired_order_type` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`);