API tools faq
paste
Advertisement
Guest User

openmrs1122

a guest
Oct 25th, 2012
49
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.73 KB | None | 0 0
raw download clone embed print report
  1. The following database updates are required:
  2. Description of Update Actions Author
  3. Run the old sqldiff file to get database up to the 1.4.0.20 version if needed. (Requires 'mysql' to be on the PATH) Custom Change bwolfe
  4. Add the column to person_attribute type to connect each type to a privilege Add Column upul
  5. Create the foreign key from the privilege required for to edit a person attribute type and the privilege.privilege column Add Foreign Key Constraint upul
  6. Fix field property for new Tribe person attribute Update Data bwolfe
  7. Create the concept_complex table Create Table, Add Foreign Key Constraint bmckown
  8. Adding the value_complex column to obs. This may take a long time if you have a large number of observations. Add Column bmckown
  9. Adding a 'complex' Concept Datatype Insert Row bmckown
  10. Dropping the mimetype and complex_obs tables as they aren't needed in the new complex obs setup Drop Table (x2) bmckown
  11. Adding the hl7 archive message_state column so that archives can be tracked (preCondition database_version check in place because this change was in the old format in trunk for a while) Add Column smbugua
  12. Adding the hl7 archive message_state column so that archives can be tracked Rename Column, Modify Column smbugua
  13. Changing datatype of drug.retire_reason from DATETIME to varchar(255) Modify Column Knoll_Frank
  14. Remove Manage Tribes and View Tribes privileges from all roles Delete Data (x2) bwolfe
  15. Remove Manage Mime Types, View Mime Types, and Purge Mime Types privilege Delete Data (x2) bwolfe
  16. Removed the database_version global property Delete Data bwolfe
  17. Switched the default xslt to use PV1-19 instead of PV1-1 Custom SQL bwolfe
  18. Remove duplicate concept name tags Custom SQL, Add Lookup Table, Drop Foreign Key Constraint, Delete Data (x2), Drop Table bwolfe
  19. Add unique constraint to the tags table Add Unique Constraint bwolfe
  20. Add location tags table Create Table, Add Foreign Key Constraint (x2) Keelhaul+bwolfe
  21. Add location tag map table Create Table, Add Foreign Key Constraint (x2), Add Primary Key Keelhaul+bwolfe
  22. Add parent_location column to location table Add Column, Add Foreign Key Constraint Keelhaul+bwolfe
  23. Change location_tag.name to location_tag.tag and location_tag.retired_reason to location_tag.retire_reason Rename Column (x2) dthomas
  24. Modify the password column to fit the output of SHA-512 function Modify Column nribeka
  25. Fixes the description for name layout global property Update Data (x2) bwolfe
  26. Add weight and cd4 to patientGraphConcepts user property (mysql specific) Custom SQL isherman
  27. Add weight and cd4 to patientGraphConcepts user property (using standard sql) Custom SQL isherman
  28. Add weight and cd4 to patientGraphConcepts user property (mssql specific) Custom SQL isherman
  29. Change column types of all boolean columns to smallint. The columns used to be either tinyint(4) or MySQL's BIT. (This may take a while on large patient or obs tables) Modify Column (x7), Update Data, Modify Column (x18), Update Data, Modify Column (x11) vanand
  30. Add a table to enable generic storage of serialized objects Create Table, Add Foreign Key Constraint (x3) mseaton
  31. Remove Manage Tribes and View Tribes privileges from the privilege table and role_privilege table. The privileges will be recreated by the Tribe module if it is installed. Delete Data (x4) bwolfe
  32. Changed the datatype for encounter_type to 'text' instead of just 50 chars Modify Column Cory McCarthy
  33. Deleting invalid concept words Delete Data bwolfe
  34. Add an index to the concept_word.concept_id column (This update may fail if it already exists) Create Index bwolfe
  35. Adding "uuid" column to cohort table Add Column bwolfe
  36. Adding "uuid" column to concept table Add Column bwolfe
  37. Adding "uuid" column to concept_answer table Add Column bwolfe
  38. Adding "uuid" column to concept_class table Add Column bwolfe
  39. Adding "uuid" column to concept_datatype table Add Column bwolfe
  40. Adding "uuid" column to concept_description table Add Column bwolfe
  41. Adding "uuid" column to concept_map table Add Column bwolfe
  42. Adding "uuid" column to concept_name table Add Column bwolfe
  43. Adding "uuid" column to concept_name_tag table Add Column bwolfe
  44. Adding "uuid" column to concept_proposal table Add Column bwolfe
  45. Adding "uuid" column to concept_set table Add Column bwolfe
  46. Adding "uuid" column to concept_source table Add Column bwolfe
  47. Adding "uuid" column to concept_state_conversion table Add Column bwolfe
  48. Adding "uuid" column to drug table Add Column bwolfe
  49. Adding "uuid" column to encounter table Add Column bwolfe
  50. Adding "uuid" column to encounter_type table Add Column bwolfe
  51. Adding "uuid" column to field table Add Column bwolfe
  52. Adding "uuid" column to field_answer table Add Column bwolfe
  53. Adding "uuid" column to field_type table Add Column bwolfe
  54. Adding "uuid" column to form table Add Column bwolfe
  55. Adding "uuid" column to form_field table Add Column bwolfe
  56. Adding "uuid" column to global_property table Add Column bwolfe
  57. Adding "uuid" column to hl7_in_archive table Add Column bwolfe
  58. Adding "uuid" column to hl7_in_error table Add Column bwolfe
  59. Adding "uuid" column to hl7_in_queue table Add Column bwolfe
  60. Adding "uuid" column to hl7_source table Add Column bwolfe
  61. Adding "uuid" column to location table Add Column bwolfe
  62. Adding "uuid" column to location_tag table Add Column bwolfe
  63. Adding "uuid" column to note table Add Column bwolfe
  64. Adding "uuid" column to notification_alert table Add Column bwolfe
  65. Adding "uuid" column to notification_template table Add Column bwolfe
  66. Adding "uuid" column to obs table Add Column bwolfe
  67. Adding "uuid" column to order_type table Add Column bwolfe
  68. Adding "uuid" column to orders table Add Column bwolfe
  69. Adding "uuid" column to patient_identifier table Add Column bwolfe
  70. Adding "uuid" column to patient_identifier_type table Add Column bwolfe
  71. Adding "uuid" column to patient_program table Add Column bwolfe
  72. Adding "uuid" column to patient_state table Add Column bwolfe
  73. Adding "uuid" column to person table Add Column bwolfe
  74. Adding "uuid" column to person_address table Add Column bwolfe
  75. Adding "uuid" column to person_attribute table Add Column bwolfe
  76. Adding "uuid" column to person_attribute_type table Add Column bwolfe
  77. Adding "uuid" column to person_name table Add Column bwolfe
  78. Adding "uuid" column to privilege table Add Column bwolfe
  79. Adding "uuid" column to program table Add Column bwolfe
  80. Adding "uuid" column to program_workflow table Add Column bwolfe
  81. Adding "uuid" column to program_workflow_state table Add Column bwolfe
  82. Adding "uuid" column to relationship table Add Column bwolfe
  83. Adding "uuid" column to relationship_type table Add Column bwolfe
  84. Adding "uuid" column to report_object table Add Column bwolfe
  85. Adding "uuid" column to report_schema_xml table Add Column bwolfe
  86. Adding "uuid" column to role table Add Column bwolfe
  87. Adding "uuid" column to serialized_object table Add Column bwolfe
  88. Generating UUIDs for all rows in cohort table via built in uuid function. Update Data bwolfe
  89. Generating UUIDs for all rows in concept table via built in uuid function. Update Data bwolfe
  90. Generating UUIDs for all rows in concept_answer table via built in uuid function. Update Data bwolfe
  91. Generating UUIDs for all rows in concept_class table via built in uuid function. Update Data bwolfe
  92. Generating UUIDs for all rows in concept_datatype table via built in uuid function. Update Data bwolfe
  93. Generating UUIDs for all rows in concept_description table via built in uuid function. Update Data bwolfe
  94. Generating UUIDs for all rows in concept_map table via built in uuid function. Update Data bwolfe
  95. Generating UUIDs for all rows in concept_name table via built in uuid function. Update Data bwolfe
  96. Generating UUIDs for all rows in concept_name_tag table via built in uuid function. Update Data bwolfe
  97. Generating UUIDs for all rows in concept_proposal table via built in uuid function. Update Data bwolfe
  98. Generating UUIDs for all rows in concept_set table via built in uuid function. Update Data bwolfe
  99. Generating UUIDs for all rows in concept_source table via built in uuid function. Update Data bwolfe
  100. Generating UUIDs for all rows in concept_state_conversion table via built in uuid function. Update Data bwolfe
  101. Generating UUIDs for all rows in drug table via built in uuid function. Update Data bwolfe
  102. Generating UUIDs for all rows in encounter table via built in uuid function. Update Data bwolfe
  103. Generating UUIDs for all rows in encounter_type table via built in uuid function. Update Data bwolfe
  104. Generating UUIDs for all rows in field table via built in uuid function. Update Data bwolfe
  105. Generating UUIDs for all rows in field_answer table via built in uuid function. Update Data bwolfe
  106. Generating UUIDs for all rows in field_type table via built in uuid function. Update Data bwolfe
  107. Generating UUIDs for all rows in form table via built in uuid function. Update Data bwolfe
  108. Generating UUIDs for all rows in form_field table via built in uuid function. Update Data bwolfe
  109. Generating UUIDs for all rows in global_property table via built in uuid function. Update Data bwolfe
  110. Generating UUIDs for all rows in hl7_in_archive table via built in uuid function. Update Data bwolfe
  111. Generating UUIDs for all rows in hl7_in_error table via built in uuid function. Update Data bwolfe
  112. Generating UUIDs for all rows in hl7_in_queue table via built in uuid function. Update Data bwolfe
  113. Generating UUIDs for all rows in hl7_source table via built in uuid function. Update Data bwolfe
  114. Generating UUIDs for all rows in location table via built in uuid function. Update Data bwolfe
  115. Generating UUIDs for all rows in location_tag table via built in uuid function. Update Data bwolfe
  116. Generating UUIDs for all rows in note table via built in uuid function. Update Data bwolfe
  117. Generating UUIDs for all rows in notification_alert table via built in uuid function. Update Data bwolfe
  118. Generating UUIDs for all rows in notification_template table via built in uuid function. Update Data bwolfe
  119. Generating UUIDs for all rows in obs table via built in uuid function. Update Data bwolfe
  120. Generating UUIDs for all rows in order_type table via built in uuid function. Update Data bwolfe
  121. Generating UUIDs for all rows in orders table via built in uuid function. Update Data bwolfe
  122. Generating UUIDs for all rows in patient_identifier table via built in uuid function. Update Data bwolfe
  123. Generating UUIDs for all rows in patient_identifier_type table via built in uuid function. Update Data bwolfe
  124. Generating UUIDs for all rows in patient_program table via built in uuid function. Update Data bwolfe
  125. Generating UUIDs for all rows in patient_state table via built in uuid function. Update Data bwolfe
  126. Generating UUIDs for all rows in person table via built in uuid function. Update Data bwolfe
  127. Generating UUIDs for all rows in person_address table via built in uuid function. Update Data bwolfe
  128. Generating UUIDs for all rows in person_attribute table via built in uuid function. Update Data bwolfe
  129. Generating UUIDs for all rows in person_attribute_type table via built in uuid function. Update Data bwolfe
  130. Generating UUIDs for all rows in person_name table via built in uuid function. Update Data bwolfe
  131. Generating UUIDs for all rows in privilege table via built in uuid function. Update Data bwolfe
  132. Generating UUIDs for all rows in program table via built in uuid function. Update Data bwolfe
  133. Generating UUIDs for all rows in program_workflow table via built in uuid function. Update Data bwolfe
  134. Generating UUIDs for all rows in program_workflow_state table via built in uuid function. Update Data bwolfe
  135. Generating UUIDs for all rows in relationship table via built in uuid function. Update Data bwolfe
  136. Generating UUIDs for all rows in relationship_type table via built in uuid function. Update Data bwolfe
  137. Generating UUIDs for all rows in report_object table via built in uuid function. Update Data bwolfe
  138. Generating UUIDs for all rows in report_schema_xml table via built in uuid function. Update Data bwolfe
  139. Generating UUIDs for all rows in role table via built in uuid function. Update Data bwolfe
  140. Generating UUIDs for all rows in serialized_object table via built in uuid function. Update Data bwolfe
  141. Adding UUIDs to all rows in all columns via a java class. (This will take a long time on large databases) Custom Change bwolfe
  142. Now that UUID generation is done, set the uuid columns to not "NOT NULL" Add Not-Null Constraint (x52) bwolfe
  143. Creating unique index on cohort.uuid column Create Index bwolfe
  144. Creating unique index on concept.uuid column Create Index bwolfe
  145. Creating unique index on concept_answer.uuid column Create Index bwolfe
  146. Creating unique index on concept_class.uuid column Create Index bwolfe
  147. Creating unique index on concept_datatype.uuid column Create Index bwolfe
  148. Creating unique index on concept_description.uuid column Create Index bwolfe
  149. Creating unique index on concept_map.uuid column Create Index bwolfe
  150. Creating unique index on concept_name.uuid column Create Index bwolfe
  151. Creating unique index on concept_name_tag.uuid column Create Index bwolfe
  152. Creating unique index on concept_proposal.uuid column Create Index bwolfe
  153. Creating unique index on concept_set.uuid column Create Index bwolfe
  154. Creating unique index on concept_source.uuid column Create Index bwolfe
  155. Creating unique index on concept_state_conversion.uuid column Create Index bwolfe
  156. Creating unique index on drug.uuid column Create Index bwolfe
  157. Creating unique index on encounter.uuid column Create Index bwolfe
  158. Creating unique index on encounter_type.uuid column Create Index bwolfe
  159. Creating unique index on field.uuid column Create Index bwolfe
  160. Creating unique index on field_answer.uuid column Create Index bwolfe
  161. Creating unique index on field_type.uuid column Create Index bwolfe
  162. Creating unique index on form.uuid column Create Index bwolfe
  163. Creating unique index on form_field.uuid column Create Index bwolfe
  164. Creating unique index on global_property.uuid column Create Index bwolfe
  165. Creating unique index on hl7_in_archive.uuid column Create Index bwolfe
  166. Creating unique index on hl7_in_error.uuid column Create Index bwolfe
  167. Creating unique index on hl7_in_queue.uuid column Create Index bwolfe
  168. Creating unique index on hl7_source.uuid column Create Index bwolfe
  169. Creating unique index on location.uuid column Create Index bwolfe
  170. Creating unique index on location_tag.uuid column Create Index bwolfe
  171. Creating unique index on note.uuid column Create Index bwolfe
  172. Creating unique index on notification_alert.uuid column Create Index bwolfe
  173. Creating unique index on notification_template.uuid column Create Index bwolfe
  174. Creating unique index on obs.uuid column Create Index bwolfe
  175. Creating unique index on order_type.uuid column Create Index bwolfe
  176. Creating unique index on orders.uuid column Create Index bwolfe
  177. Creating unique index on patient_identifier.uuid column Create Index bwolfe
  178. Creating unique index on patient_identifier_type.uuid column Create Index bwolfe
  179. Creating unique index on patient_program.uuid column Create Index bwolfe
  180. Creating unique index on patient_state.uuid column Create Index bwolfe
  181. Creating unique index on person.uuid column Create Index bwolfe
  182. Creating unique index on person_address.uuid column Create Index bwolfe
  183. Creating unique index on person_attribute.uuid column Create Index bwolfe
  184. Creating unique index on person_attribute_type.uuid column Create Index bwolfe
  185. Creating unique index on person_name.uuid column Create Index bwolfe
  186. Creating unique index on privilege.uuid column Create Index bwolfe
  187. Creating unique index on program.uuid column Create Index bwolfe
  188. Creating unique index on program_workflow.uuid column Create Index bwolfe
  189. Creating unique index on program_workflow_state.uuid column Create Index bwolfe
  190. Creating unique index on relationship.uuid column Create Index bwolfe
  191. Creating unique index on relationship_type.uuid column Create Index bwolfe
  192. Creating unique index on report_object.uuid column Create Index bwolfe
  193. Creating unique index on report_schema_xml.uuid column Create Index bwolfe
  194. Creating unique index on role.uuid column Create Index bwolfe
  195. Creating unique index on serialized_object.uuid column Create Index bwolfe
  196. Dropping foreign key on concept_set.concept_id table Drop Foreign Key Constraint bwolfe
  197. Dropping primary key on concept set table Drop Primary Key bwolfe
  198. Adding new integer primary key to concept set table Add Column bwolfe
  199. Adding index and foreign key to concept_set.concept_id column Create Index, Add Foreign Key Constraint bwolfe
  200. Dropping foreign key on patient_identifier.patient_id column Drop Foreign Key Constraint bwolfe
  201. Dropping non-integer primary key on patient identifier table before adding a new integer primary key Drop Primary Key bwolfe
  202. Adding new integer primary key to patient identifier table Add Column bwolfe
  203. Adding index and foreign key on patient_identifier.patient_id column Create Index, Add Foreign Key Constraint bwolfe
  204. Dropping foreign key on concept_word.concept_id column Drop Foreign Key Constraint bwolfe
  205. Removing concept_word.concept_name_id foreign key so that primary key can be changed to concept_word_id Drop Foreign Key Constraint bwolfe
  206. Dropping non-integer primary key on concept word table before adding new integer one Drop Primary Key bwolfe
  207. Adding integer primary key to concept word table Add Column bwolfe
  208. Re-adding foreign key for concept_word.concept_name_id Add Foreign Key Constraint bwolfe
  209. Adding foreign key for concept_word.concept_id column Add Foreign Key Constraint bwolfe
  210. Deleting duplicate concept word keys Custom SQL bwolfe
  211. Remove the now unused synonym column Drop Column bwolfe
  212. Add a sortWeight field to PersonAttributeType Add Column ewolodzko
  213. Add default sortWeights to all current PersonAttributeTypes Update Data ewolodzko
  214. Change person_attribute_type.sort_weight from an integer to a float Modify Column bwolfe
  215. Change obs.value_numeric from a double(22,0) to a double Modify Column bwolfe
  216. Change concept_numeric columns from a double(22,0) type to a double Modify Column bwolfe
  217. Change concept_set.sort_weight from a double(22,0) to a double Modify Column bwolfe
  218. Change concept_set_derived.sort_weight from a double(22,0) to a double Modify Column bwolfe
  219. Change drug table columns from a double(22,0) to a double Modify Column bwolfe
  220. Change drug_order.dose from a double(22,0) to a double Modify Column bwolfe
  221. Adding 'System Developer' role again (see ticket #1499) Insert Row djazayeri
  222. Switching users back from 'Administrator' to 'System Developer' (see ticket #1499) Update Data djazayeri
  223. Deleting 'Administrator' role (see ticket #1499) Delete Data djazayeri
  224. Adding "uuid" column to scheduler_task_config table Add Column bwolfe
  225. Generating UUIDs for all rows in scheduler_task_config table via built in uuid function. Update Data bwolfe
  226. Adding UUIDs to all rows in scheduler_task_config table via a java class for non mysql/oracle/mssql databases. Custom Change bwolfe
  227. Now that UUID generation is done for scheduler_task_config, set the uuid column to not "NOT NULL" Add Not-Null Constraint bwolfe
  228. Creating unique index on scheduler_task_config.uuid column Create Index bwolfe
  229. Rename the concept_source.date_voided column to date_retired Rename Column Knoll_Frank
  230. Remove the concept_source.voided_by foreign key constraint Drop Foreign Key Constraint Knoll_Frank
  231. Rename the concept_source.voided_by column to retired_by Rename Column, Add Foreign Key Constraint Knoll_Frank
  232. Rename the concept_source.voided column to retired Rename Column Knoll_Frank
  233. Rename the concept_source.void_reason column to retire_reason Rename Column Knoll_Frank
  234. set hl7_code in ConceptSource to nullable column Modify Column dthomas
  235. set retired in ConceptSource to tinyint(1) not null Modify Column dthomas
  236. Create logic token table to store all registered token Create Table nribeka
  237. Create logic token tag table to store all tag associated with a token Create Table nribeka
  238. Adding foreign key for primary key of logic_rule_token_tag Add Foreign Key Constraint nribeka
  239. Removing bad foreign key for logic_rule_token.creator Drop Foreign Key Constraint nribeka
  240. Removing bad foreign key for logic_rule_token.creator Drop Foreign Key Constraint nribeka
  241. Adding correct foreign key for logic_rule_token.creator Add Foreign Key Constraint nribeka
  242. Adding foreign key for logic_rule_token.changed_by Add Foreign Key Constraint nribeka
  243. Setting core field types to have standard UUIDs Update Data (x5) bwolfe
  244. Setting core person attribute types to have standard UUIDs Update Data (x7) bwolfe
  245. Setting core encounter types to have standard UUIDs Update Data (x4) bwolfe
  246. Setting core concept datatypes to have standard UUIDs Update Data (x12) bwolfe
  247. Setting core relationship types to have standard UUIDs Update Data (x4) bwolfe
  248. Setting core concept classes to have standard UUIDs Update Data (x15) bwolfe
  249. Setting core patient identifier types to have standard UUIDs Update Data (x2) bwolfe
  250. Setting core location to have standard UUIDs Update Data bwolfe
  251. Setting core hl7 source to have standard UUIDs Update Data bwolfe
  252. Setting core roles to have standard UUIDs Update Data (x4) bwolfe
  253. Change name for patient.searchMaxResults global property to person.searchMaxResults Update Data arthurs
  254. Add changed_by column to encounter table Add Column, Add Foreign Key Constraint madanmohan
  255. Add date_changed column to encounter table Add Column madanmohan
  256. Adding language column to concept_derived table Add Column nribeka
  257. Changing encounter.provider_id to reference person instead of users Drop Foreign Key Constraint, Add Foreign Key Constraint djazayeri
  258. Removing the foreign key from users.user_id to person.person_id if it still exists Drop Foreign Key Constraint bwolfe
  259. Adding person_id column to users table (if needed) Add Column, Update Data djazayeri
  260. Populating users.person_id Update Data, Add Not-Null Constraint djazayeri
  261. Restoring foreign key constraint on users.person_id Add Foreign Key Constraint, Set Column as Auto-Increment djazayeri
  262. Adding retired metadata columns to users table Add Column, Add Foreign Key Constraint djazayeri
  263. Migrating voided metadata to retired metadata for users table Update Data djazayeri
  264. Dropping voided metadata columns from users table Drop Foreign Key Constraint, Drop Column (x4) djazayeri
  265. Adding "uuid" column to users table Add Column djazayeri
  266. Generating UUIDs for all rows in users table via built in uuid function. Update Data djazayeri
  267. Adding not null constraint to users.uuid Add Not-Null Constraint djazayeri
  268. Adding UUIDs to users table via a java class. (This will take a long time on large databases) Custom Change djazayeri
  269. Encounter Type should not be null when saving an Encounter Add Not-Null Constraint n.nehete
  270. Add last execution time column to scheduler_task_config table Add Column upul
  271. add retired column to relationship_type table Add Column rcrichton
  272. add retired_by column to relationship_type table Add Column rcrichton
  273. Create the foreign key from the relationship.retired_by to users.user_id. Add Foreign Key Constraint rcrichton
  274. add date_retired column to relationship_type table Add Column rcrichton
  275. add retire_reason column to relationship_type table Add Column rcrichton
  276. Prune concepts rows orphaned in concept_numeric tables Custom SQL sunbiz
  277. Prune concepts rows orphaned in concept_complex tables Custom SQL jmiranda
  278. Prune concepts rows orphaned in concept_derived tables Custom SQL jmiranda
  279. Dropping unused foreign key from notification alert table Drop Foreign Key Constraint thilini.hg
  280. Dropping unused user_id column from notification alert table Drop Column thilini.hg
  281. Adding sort_weight column to concept_answers table and initially sets the sort_weight to the concept_answer_id Add Column, Update Data syhaas
  282. Adding "uuid" column to notification_alert_recipient table Add Column bwolfe
  283. Generating UUIDs for all rows in notification_alert_recipient table via built in uuid function. Update Data bwolfe
  284. Adding UUIDs to notification_alert_recipient table via a java class (if needed). Custom Change bwolfe
  285. Now that UUID generation is done, set the notification_alert_recipient.uuid column to not "NOT NULL" Add Not-Null Constraint bwolfe
  286. Change location_tag.tag to location_tag.name Rename Column djazayeri
  287. Changing the datatype of global_property.property for mysql databases Modify Column bwolfe
  288. Add an index to the encounter.encounter_datetime column to speed up statistical analysis. Create Index slorenz
  289. Add an index to the obs.obs_datetime column to speed up statistical analysis. Create Index slorenz
  290. Adding daemon user to users table Insert Row syhaas
  291. Removing scheduler.username and scheduler.password global properties Delete Data (x2) syhaas
  292. Create core order_type for drug orders Insert Row djazayeri
  293. Switch boolean concepts/observations to be stored as coded Custom Change wyclif and djazayeri
  294. Drop Not-Null constraint from location column in Encounter and Obs table Drop Not-Null Constraint (x2) Harsha.cse
  295. Changing the default value to 2 for 'message_state' column in 'hl7_in_archive' table Add Default Value wyclif
  296. Converting 0 and 1 to 2 for 'message_state' column in 'hl7_in_archive' table Update Data wyclif
  297. Removing the duplicate privilege 'Add Concept Proposal' in favor of 'Add Concept Proposals' Update Data, Delete Data (x2) ricardosbarbosa
  298. Removing the duplicate privilege 'Edit Concept Proposal' in favor of 'Edit Concept Proposals' Update Data, Delete Data (x2) ricardosbarbosa
  299. Create active list type table. Create Table, Add Foreign Key Constraint (x2) syhaas
  300. Create active list table Create Table, Add Foreign Key Constraint (x7) syhaas
  301. Create allergen table Create Table, Add Foreign Key Constraint syhaas
  302. Create problem table Create Table syhaas
  303. Inserting default active list types Insert Row (x2) syhaas
  304. Adding 'concept_name_type' column to concept_name table Add Column wyclif
  305. Adding 'locale_preferred' column to concept_name table Add Column wyclif
  306. Dropping foreign key constraint on concept_name_tag_map.concept_name_tag_id Drop Foreign Key Constraint wyclif
  307. Converting preferred names to FULLY_SPECIFIED names Update Data, Delete Data (x2) wyclif
  308. Setting the concept name type for short names Update Data, Delete Data (x2) wyclif
  309. Converting concept names with country specific concept name tags to preferred names Update Data, Delete Data (x2) wyclif
  310. Deleting 'default' and 'synonym' concept name tags Delete Data (x2) wyclif
  311. Validating and attempting to fix invalid concepts and ConceptNames Custom Change wyclif
  312. Restoring foreign key constraint on concept_name_tag_map.concept_name_tag_id Add Foreign Key Constraint wyclif
  313. Modify the error_details column of hl7_in_error to hold stacktraces Modify Column jkeiper
  314. Add an index to the person_name.family_name2 to speed up patient and person searches Create Index bwolfe
  315. Validates Program Workflow States for possible configuration problems and reports warnings Custom Change mseaton
  316. Make person_name.person_id not NULLable Modify Column misha680
  317. Add location_id column to patient_program table Add Column, Add Foreign Key Constraint mseaton
  318. Remove the now unused default_charge column Drop Column misha680
  319. Setting the global property 'patient.identifierRegex' to an empty string Update Data wyclif
  320. Setting the global property 'patient.identifierSuffix' to an empty string Update Data wyclif
  321. Adding index to form.published column Create Index bwolfe
  322. Adding index to form.retired column Create Index bwolfe
  323. Adding multi column index on form.published and form.retired columns Create Index bwolfe
  324. Rename neighborhood_cell column to address3 and increase the size to 255 characters Rename Column crecabarren
  325. Rename township_division column to address4 and increase the size to 255 characters Rename Column crecabarren
  326. Rename subregion column to address5 and increase the size to 255 characters Rename Column crecabarren
  327. Rename region column to address6 and increase the size to 255 characters Rename Column crecabarren
  328. Rename neighborhood_cell column to address3 and increase the size to 255 characters Rename Column crecabarren
  329. Rename township_division column to address4 and increase the size to 255 characters Rename Column crecabarren
  330. Rename subregion column to address5 and increase the size to 255 characters Rename Column crecabarren
  331. Rename region column to address6 and increase the size to 255 characters Rename Column crecabarren
  332. Increasing length of address fields in person_address and location to 255 Modify Column (x10) djazayeri
  333. Adding index to message_state column in HL7 archive table Create Index jkeiper
  334. Moving "deleted" HL7s from HL7 archive table to queue table Custom Change jkeiper
  335. Add 'weight' column to concept_word table Add Column wyclif
  336. Adding index to concept_word.weight column Create Index wyclif
  337. Insert a row into the schedule_task_config table for the ConceptIndexUpdateTask Insert Row wyclif
  338. Setting the value of 'start_on_startup' to trigger off conceptIndexUpdateTask on startup Update Data wyclif
  339. Removing concept that are concept derived and the datatype Delete Data nribeka
  340. Removing concept derived tables Drop Table nribeka
  341. Removing 'View Encounters' privilege from Anonymous user Delete Data wyclif
  342. Removing 'View Observations' privilege from Anonymous user Delete Data
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!