search

bravetechnologycoop / BraveSensor

1 stars 2 forks source link

Cc updateclienttables CU-86du6jp33 #301

Closed CCheng00 closed 1 month ago

CCheng00 commented 1 month ago

Here are the updates needed to the DB,

Country - clients_extension.country (existing) Country subdivision - clients_extension.country_subdivision (existing) Building type - clients_extension.building_type (existing) Funder - clients_extension.funder (NEW) Project - clients_extension.project (NEW) Parent org - clients_extension.organization; (NEW) Client name - clients.display_name (existing) City - clients_extension.city (NEW) Zip Code/Postal Code - clients_extension.postal_code (NEW)

organization, funder, postal_code has been added by Elana, seen in script 50.

added script 52, to add the remaining fields.

There are 2 commits that I added to test the dev server, they cancel each other out. Changes in first commit.

trisapeace commented 1 month ago

Task linked: CU-86du6jp33 Add "Organization", "Funder", "Zip/Postal Code", "Project" to Clients table. Fill in "Building Type"