barometer table data constraint updates

[wetlandsDiane]

Here are some steps for cleaning up the barometers table. I have attached a script that should do everything besides fixing the auto-increment. I sent the script to Nate - I can't run as a non-owner of the table

1. readingdate- make not null; currently no null values
2. measuredlevel- make not null; currently no null values
3. locationid- make not null, currently no null values; ensure match in locations table
4. Already an index on readingdating and locationid; change to a unique index; two records need to be deleted first (see locationid=9069 and readingdate ='2021-11-04 12:00:00.000')
5. objectid change to an identity column or serial column- make it auto-generate, currently int4 with no default

barometer_structure_updates.txt

[wetlandsDiane]

Two remaining issues to address

1. create unique index on readingdating and locationid; there are more duplicates that I thought!!
2. objectid change to an identity column or serial column- make it auto-generate, currently int4 with no default