Downloads Documentation Community
Contribute
Contribute Demo






Show Sidebar
Login | Register


Show
Ignore:
Timestamp:
07/02/08 19:40:36 (5 months ago)
Author:
bmckown
Message:

Merging trunk to complex-obs [4379][4764]

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • openmrs/branches/complex-obs/metadata/model/1.3.0-schema-only.sql

    r4417 r4785  
    11-- MySQL dump 10.11 
    22-- 
    3 -- Host: localhost    Database: openmrs_test 
     3-- Host: localhost    Database: openmrs 
    44-- ------------------------------------------------------ 
    5 -- Server version       5.0.51a-3ubuntu5 
    6  
    7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 
    8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 
    9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 
    10 /*!40101 SET NAMES utf8 */; 
     5-- Server version       5.0.51a-3ubuntu5.1 
    116/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 
    127/*!40103 SET TIME_ZONE='+00:00' */; 
    …… 
    3328  `date_voided` datetime default NULL, 
    3429  `void_reason` varchar(255) default NULL, 
     30  `changed_by` int(11) default NULL, 
     31  `date_changed` datetime default NULL, 
    3532  PRIMARY KEY  (`cohort_id`), 
    3633  KEY `cohort_creator` (`creator`), 
    3734  KEY `user_who_voided_cohort` (`voided_by`), 
     35  KEY `user_who_changed_cohort` (`changed_by`), 
     36  CONSTRAINT `user_who_changed_cohort` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), 
    3837  CONSTRAINT `cohort_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
    3938  CONSTRAINT `user_who_voided_cohort` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) 
    …… 
    10099  `changed_by` int(11) default NULL, 
    101100  `date_changed` datetime default NULL, 
     101  `retired_by` int(11) default NULL, 
     102  `date_retired` datetime default NULL, 
     103  `retire_reason` varchar(255) default NULL, 
    102104  PRIMARY KEY  (`concept_id`), 
    103105  KEY `concept_classes` (`class_id`), 
    …… 
    105107  KEY `concept_datatypes` (`datatype_id`), 
    106108  KEY `user_who_changed_concept` (`changed_by`), 
     109  KEY `user_who_retired_concept` (`retired_by`), 
     110  CONSTRAINT `user_who_retired_concept` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`), 
    107111  CONSTRAINT `concept_classes` FOREIGN KEY (`class_id`) REFERENCES `concept_class` (`concept_class_id`), 
    108112  CONSTRAINT `concept_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
    109113  CONSTRAINT `concept_datatypes` FOREIGN KEY (`datatype_id`) REFERENCES `concept_datatype` (`concept_datatype_id`), 
    110114  CONSTRAINT `user_who_changed_concept` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`) 
    111 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; 
     115) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    112116SET character_set_client = @saved_cs_client; 
    113117 
    …… 
    133137  CONSTRAINT `answers_for_concept` FOREIGN KEY (`concept_id`) REFERENCES `concept` (`concept_id`), 
    134138  CONSTRAINT `answer_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    135 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; 
     139) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    136140SET character_set_client = @saved_cs_client; 
    137141 
    …… 
    149153  `creator` int(11) NOT NULL default '0', 
    150154  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
     155  `retired` tinyint(1) NOT NULL default '0', 
     156  `retired_by` int(11) default NULL, 
     157  `date_retired` datetime default NULL, 
     158  `retire_reason` varchar(255) default NULL, 
    151159  PRIMARY KEY  (`concept_class_id`), 
    152160  KEY `concept_class_creator` (`creator`), 
    153   CONSTRAINT `concept_class_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    154 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; 
     161  KEY `user_who_retired_concept_class` (`retired_by`), 
     162  KEY `concept_class_retired_status` (`retired`), 
     163  CONSTRAINT `concept_class_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     164  CONSTRAINT `user_who_retired_concept_class` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
     165) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    155166SET character_set_client = @saved_cs_client; 
    156167 
    …… 
    169180  `creator` int(11) NOT NULL default '0', 
    170181  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
     182  `retired` tinyint(1) NOT NULL default '0', 
     183  `retired_by` int(11) default NULL, 
     184  `date_retired` datetime default NULL, 
     185  `retire_reason` varchar(255) default NULL, 
    171186  PRIMARY KEY  (`concept_datatype_id`), 
    172187  KEY `concept_datatype_creator` (`creator`), 
    173   CONSTRAINT `concept_datatype_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    174 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; 
     188  KEY `user_who_retired_concept_datatype` (`retired_by`), 
     189  KEY `concept_datatype_retired_status` (`retired`), 
     190  CONSTRAINT `concept_datatype_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     191  CONSTRAINT `user_who_retired_concept_datatype` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
     192) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    175193SET character_set_client = @saved_cs_client; 
    176194 
    …… 
    226244SET character_set_client = utf8; 
    227245CREATE TABLE `concept_name` ( 
    228   `concept_id` int(11) NOT NULL default '0', 
     246  `concept_id` int(11) default NULL, 
    229247  `name` varchar(255) NOT NULL default '', 
    230248  `short_name` varchar(255) default NULL, 
    …… 
    233251  `creator` int(11) NOT NULL default '0', 
    234252  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
    235   PRIMARY KEY  (`concept_id`,`locale`), 
     253  `concept_name_id` int(11) NOT NULL auto_increment, 
     254  PRIMARY KEY  (`concept_name_id`), 
     255  UNIQUE KEY `concept_name_id` (`concept_name_id`), 
    236256  KEY `user_who_created_name` (`creator`), 
    237257  KEY `name_of_concept` (`name`), 
    238258  KEY `short_name_of_concept` (`short_name`), 
     259  KEY `unique_concept_name_id` (`concept_id`), 
    239260  CONSTRAINT `name_for_concept` FOREIGN KEY (`concept_id`) REFERENCES `concept` (`concept_id`), 
    240261  CONSTRAINT `user_who_created_name` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    …… 
    446467  `creator` int(11) NOT NULL default '0', 
    447468  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
    448   `voided` tinyint(1) NOT NULL default '0', 
    449   `voided_by` int(11) default NULL, 
    450   `date_voided` datetime default NULL, 
    451   `void_reason` varchar(255) default NULL, 
     469  `retired` tinyint(1) NOT NULL default '0', 
     470  `retired_by` int(11) default NULL, 
     471  `date_retired` datetime default NULL, 
     472  `retire_reason` datetime default NULL, 
    452473  PRIMARY KEY  (`drug_id`), 
    453474  KEY `drug_creator` (`creator`), 
    …… 
    455476  KEY `dosage_form_concept` (`dosage_form`), 
    456477  KEY `route_concept` (`route`), 
    457   KEY `user_who_voided_drug` (`voided_by`), 
     478  KEY `user_who_voided_drug` (`retired_by`), 
    458479  CONSTRAINT `dosage_form_concept` FOREIGN KEY (`dosage_form`) REFERENCES `concept` (`concept_id`), 
    459480  CONSTRAINT `drug_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     481  CONSTRAINT `drug_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`), 
    460482  CONSTRAINT `primary_drug_concept` FOREIGN KEY (`concept_id`) REFERENCES `concept` (`concept_id`), 
    461   CONSTRAINT `route_concept` FOREIGN KEY (`route`) REFERENCES `concept` (`concept_id`), 
    462   CONSTRAINT `user_who_voided_drug` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) 
     483  CONSTRAINT `route_concept` FOREIGN KEY (`route`) REFERENCES `concept` (`concept_id`) 
    463484) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    464485SET character_set_client = @saved_cs_client; 
    …… 
    557578  `creator` int(11) NOT NULL default '0', 
    558579  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
     580  `retired` tinyint(1) NOT NULL default '0', 
     581  `retired_by` int(11) default NULL, 
     582  `date_retired` datetime default NULL, 
     583  `retire_reason` varchar(255) default NULL, 
    559584  PRIMARY KEY  (`encounter_type_id`), 
    560585  KEY `user_who_created_type` (`creator`), 
    561   CONSTRAINT `user_who_created_type` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    562 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; 
     586  KEY `user_who_retired_encounter_type` (`retired_by`), 
     587  KEY `retired_status` (`retired`), 
     588  CONSTRAINT `user_who_created_type` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     589  CONSTRAINT `user_who_retired_encounter_type` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
     590) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    563591SET character_set_client = @saved_cs_client; 
    564592 
    …… 
    584612  `changed_by` int(11) default NULL, 
    585613  `date_changed` datetime default NULL, 
     614  `retired` tinyint(1) NOT NULL default '0', 
     615  `retired_by` int(11) default NULL, 
     616  `date_retired` datetime default NULL, 
     617  `retire_reason` varchar(255) default NULL, 
    586618  PRIMARY KEY  (`field_id`), 
    587619  KEY `concept_for_field` (`concept_id`), 
    …… 
    589621  KEY `user_who_created_field` (`creator`), 
    590622  KEY `type_of_field` (`field_type`), 
     623  KEY `user_who_retired_field` (`retired_by`), 
     624  KEY `field_retired_status` (`retired`), 
    591625  CONSTRAINT `concept_for_field` FOREIGN KEY (`concept_id`) REFERENCES `concept` (`concept_id`), 
    592626  CONSTRAINT `type_of_field` FOREIGN KEY (`field_type`) REFERENCES `field_type` (`field_type_id`), 
    593627  CONSTRAINT `user_who_changed_field` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), 
    594   CONSTRAINT `user_who_created_field` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
     628  CONSTRAINT `user_who_created_field` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     629  CONSTRAINT `user_who_retired_field` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
    595630) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    596631SET character_set_client = @saved_cs_client; 
    …… 
    635670  KEY `user_who_created_field_type` (`creator`), 
    636671  CONSTRAINT `user_who_created_field_type` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    637 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; 
     672) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    638673SET character_set_client = @saved_cs_client; 
    639674 
    …… 
    855890  KEY `creator` (`creator`), 
    856891  CONSTRAINT `creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    857 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 
     892) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    858893SET character_set_client = @saved_cs_client; 
    859894 
    …… 
    884919  `subregion` varchar(50) default NULL, 
    885920  `township_division` varchar(50) default NULL, 
     921  `retired` tinyint(1) NOT NULL default '0', 
     922  `retired_by` int(11) default NULL, 
     923  `date_retired` datetime default NULL, 
     924  `retire_reason` varchar(255) default NULL, 
    886925  PRIMARY KEY  (`location_id`), 
    887926  KEY `user_who_created_location` (`creator`), 
    888927  KEY `name_of_location` (`name`), 
    889   CONSTRAINT `user_who_created_location` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    890 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 
     928  KEY `user_who_retired_location` (`retired_by`), 
     929  KEY `retired_status` (`retired`), 
     930  CONSTRAINT `user_who_created_location` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     931  CONSTRAINT `user_who_retired_location` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
     932) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    891933SET character_set_client = @saved_cs_client; 
    892934 
    …… 
    10811123  `creator` int(11) NOT NULL default '0', 
    10821124  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
     1125  `retired` tinyint(1) NOT NULL default '0', 
     1126  `retired_by` int(11) default NULL, 
     1127  `date_retired` datetime default NULL, 
     1128  `retire_reason` varchar(255) default NULL, 
    10831129  PRIMARY KEY  (`order_type_id`), 
    10841130  KEY `type_created_by` (`creator`), 
    1085   CONSTRAINT `type_created_by` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
     1131  KEY `user_who_retired_order_type` (`retired_by`), 
     1132  KEY `retired_status` (`retired`), 
     1133  CONSTRAINT `type_created_by` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     1134  CONSTRAINT `user_who_retired_order_type` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
    10861135) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    10871136SET character_set_client = @saved_cs_client; 
    …… 
    12151264  `required` tinyint(1) NOT NULL default '0', 
    12161265  `format_description` varchar(255) default NULL, 
     1266  `validator` varchar(200) default NULL, 
     1267  `retired` tinyint(1) NOT NULL default '0', 
     1268  `retired_by` int(11) default NULL, 
     1269  `date_retired` datetime default NULL, 
     1270  `retire_reason` varchar(255) default NULL, 
    12171271  PRIMARY KEY  (`patient_identifier_type_id`), 
    12181272  KEY `type_creator` (`creator`), 
    1219   CONSTRAINT `type_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    1220 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; 
     1273  KEY `user_who_retired_patient_identifier_type` (`retired_by`), 
     1274  KEY `retired_status` (`retired`), 
     1275  CONSTRAINT `type_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     1276  CONSTRAINT `user_who_retired_patient_identifier_type` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
     1277) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    12211278SET character_set_client = @saved_cs_client; 
    12221279 
    …… 
    13251382  CONSTRAINT `user_who_created_person` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
    13261383  CONSTRAINT `user_who_voided_person` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) 
    1327 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 
     1384) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    13281385SET character_set_client = @saved_cs_client; 
    13291386 
    …… 
    14201477  `changed_by` int(11) default NULL, 
    14211478  `date_changed` datetime default NULL, 
     1479  `retired` tinyint(1) NOT NULL default '0', 
     1480  `retired_by` int(11) default NULL, 
     1481  `date_retired` datetime default NULL, 
     1482  `retire_reason` varchar(255) default NULL, 
    14221483  PRIMARY KEY  (`person_attribute_type_id`), 
    14231484  KEY `name_of_attribute` (`name`), 
    …… 
    14251486  KEY `attribute_type_changer` (`changed_by`), 
    14261487  KEY `attribute_is_searchable` (`searchable`), 
     1488  KEY `user_who_retired_person_attribute_type` (`retired_by`), 
     1489  KEY `person_attribute_type_retired_status` (`retired`), 
    14271490  CONSTRAINT `attribute_type_changer` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), 
    1428   CONSTRAINT `attribute_type_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    1429 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; 
     1491  CONSTRAINT `attribute_type_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
     1492  CONSTRAINT `user_who_retired_person_attribute_type` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`) 
     1493) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    14301494SET character_set_client = @saved_cs_client; 
    14311495 
    …… 
    14671531  CONSTRAINT `user_who_made_name` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
    14681532  CONSTRAINT `user_who_voided_name` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) 
    1469 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 
     1533) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    14701534SET character_set_client = @saved_cs_client; 
    14711535 
    …… 
    14981562  `changed_by` int(11) default NULL, 
    14991563  `date_changed` datetime default NULL, 
    1500   `voided` tinyint(1) NOT NULL default '0', 
    1501   `voided_by` int(11) default NULL, 
    1502   `date_voided` datetime default NULL, 
    1503   `void_reason` varchar(255) default NULL, 
     1564  `retired` tinyint(1) NOT NULL default '0', 
     1565  `name` varchar(50) NOT NULL, 
     1566  `description` varchar(500) default NULL, 
    15041567  PRIMARY KEY  (`program_id`), 
    15051568  KEY `program_concept` (`concept_id`), 
    15061569  KEY `program_creator` (`creator`), 
    15071570  KEY `user_who_changed_program` (`changed_by`), 
    1508   KEY `user_who_voided_program` (`voided_by`), 
    1509   CONSTRAINT `user_who_voided_program` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`), 
    15101571  CONSTRAINT `program_concept` FOREIGN KEY (`concept_id`) REFERENCES `concept` (`concept_id`), 
    15111572  CONSTRAINT `program_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
    …… 
    15271588  `creator` int(11) NOT NULL default '0', 
    15281589  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
    1529   `voided` tinyint(1) default NULL, 
    1530   `voided_by` int(11) default NULL, 
    1531   `date_voided` datetime default NULL, 
    1532   `void_reason` varchar(255) default NULL, 
     1590  `retired` tinyint(1) NOT NULL default '0', 
     1591  `changed_by` int(11) default NULL, 
     1592  `date_changed` datetime default NULL, 
    15331593  PRIMARY KEY  (`program_workflow_id`), 
    15341594  KEY `program_for_workflow` (`program_id`), 
    15351595  KEY `workflow_concept` (`concept_id`), 
    15361596  KEY `workflow_creator` (`creator`), 
    1537   KEY `workflow_voided_by` (`voided_by`), 
     1597  KEY `workflow_voided_by` (`changed_by`), 
    15381598  CONSTRAINT `program_for_workflow` FOREIGN KEY (`program_id`) REFERENCES `program` (`program_id`), 
     1599  CONSTRAINT `workflow_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), 
    15391600  CONSTRAINT `workflow_concept` FOREIGN KEY (`concept_id`) REFERENCES `concept` (`concept_id`), 
    1540   CONSTRAINT `workflow_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
    1541   CONSTRAINT `workflow_voided_by` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) 
     1601  CONSTRAINT `workflow_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    15421602) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    15431603SET character_set_client = @saved_cs_client; 
    …… 
    15581618  `creator` int(11) NOT NULL default '0', 
    15591619  `date_created` datetime NOT NULL default '0000-00-00 00:00:00', 
    1560   `voided` tinyint(1) default NULL, 
    1561   `voided_by` int(11) default NULL, 
    1562   `date_voided` datetime default NULL, 
    1563   `void_reason` varchar(255) default NULL, 
     1620  `retired` tinyint(1) NOT NULL default '0', 
     1621  `changed_by` int(11) default NULL, 
     1622  `date_changed` datetime default NULL, 
    15641623  PRIMARY KEY  (`program_workflow_state_id`), 
    15651624  KEY `workflow_for_state` (`program_workflow_id`), 
    15661625  KEY `state_concept` (`concept_id`), 
    15671626  KEY `state_creator` (`creator`), 
    1568   KEY `state_voided_by` (`voided_by`), 
    1569   CONSTRAINT `workflow_for_state` FOREIGN KEY (`program_workflow_id`) REFERENCES `program_workflow` (`program_workflow_id`), 
     1627  KEY `state_voided_by` (`changed_by`), 
     1628  CONSTRAINT `state_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), 
    15701629  CONSTRAINT `state_concept` FOREIGN KEY (`concept_id`) REFERENCES `concept` (`concept_id`), 
    15711630  CONSTRAINT `state_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), 
    1572   CONSTRAINT `state_voided_by` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) 
     1631  CONSTRAINT `workflow_for_state` FOREIGN KEY (`program_workflow_id`) REFERENCES `program_workflow` (`program_workflow_id`) 
    15731632) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    15741633SET character_set_client = @saved_cs_client; 
    …… 
    16251684  KEY `user_who_created_rel` (`creator`), 
    16261685  CONSTRAINT `user_who_created_rel` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`) 
    1627 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; 
     1686) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    16281687SET character_set_client = @saved_cs_client; 
    16291688 
    …… 
    17501809  CONSTRAINT `scheduler_changer` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), 
    17511810  CONSTRAINT `scheduler_creator` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`) 
    1752 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; 
     1811) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    17531812SET character_set_client = @saved_cs_client; 
    17541813 
    …… 
    18501909  CONSTRAINT `user_who_changed_user` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`), 
    18511910  CONSTRAINT `user_who_voided_user` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`) 
    1852 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 
     1911) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    18531912SET character_set_client = @saved_cs_client; 
    18541913/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 
    …… 
    18571916/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 
    18581917/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 
    1859 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 
    1860 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 
    1861 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 
    18621918/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 
    18631919 
    1864 -- Dump completed on 2008-05-09 21:22:36 
     1920-- Dump completed on 2008-06-12 14:39:34