Database changes - OpenLMIS/open-lmis GitHub Wiki

Links to commits for database changes - Adding tables for Regimen and Regimen Categories, Adding regimenTemplateConfigured to Programs

• https://github.com/OpenLMIS/open-lmis/commit/3210f46d8f12643e19bbf2a0e78811991846a230

Making audit fields consistent across all tables

• https://github.com/OpenLMIS/open-lmis/commit/5c6dd92edacab26eafbe20c8558a6e26fc6b78ca
• https://github.com/OpenLMIS/open-lmis/commit/a562ad6d662dff0e9df634979d5dfdc247c9d7cc
• https://github.com/OpenLMIS/open-lmis/commit/c713b6dad2ebc898f4114c4908aedaea66f52bb9

Adding column 'push' to programs table to indicate whether it is push based or pull based

• https://github.com/OpenLMIS/open-lmis/commit/2c90bb66c760e05c99f9a12cf0bfde6cb1dc30c7

Adding columns 'catchment Population', 'longitude', 'latitude' to geographic_Zones

• https://github.com/OpenLMIS/open-lmis/commit/4c8b3b9683d80c881ccfd1357f9ef308f53661b4

Adding columns 'productGroupId' to products table

• https://github.com/OpenLMIS/open-lmis/commit/e1df78018eee69160d424c1ce488448e49d49fb0

Adding delivery zone ID field to role_assignments

• https://github.com/OpenLMIS/open-lmis/commit/f60cfc6676a3931dcc0e7211d631eff820ff28e3

Removing isa from program product table and adding programProductId to program product isa

• https://github.com/OpenLMIS/open-lmis/commit/8c367a7528331f75622988137ae47df18175cbee

Adding table for facility allocation program products

• https://github.com/OpenLMIS/open-lmis/commit/4997a5ec88faff4b7df8d07c62827c9addb8e315
• https://github.com/OpenLMIS/open-lmis/commit/bddb59af6a08ac22b6e32849ce766f3780566af2

Added unique constraint to facility allocation program products on facilityId and programProductId and added not null constraint to programProductId on program_product_isa table

• https://github.com/OpenLMIS/open-lmis/commit/6d0d01f841fef33126aa7993eb105be7af825c62