Meeting 20240115

[zipperer]

Describe here what we did with

• gLabels
• default values for columns
• update column value for modification_time with function and trigger
• create table logging.t_history and update that table with function and trigger

[zipperer]

update column value for modification_time with function and trigger, create table logging.t_history and update that table with function and trigger

We followed these steps:

steps to setup track changes

and modified them for the names of tables we used, e.g. mailing_list.

[zipperer]

what we did with gLabels

We performed steps similar to those on #28 and #7 .

[zipperer]

default values for columns

We followed steps similar to #25 -- using the TablePlus interface.

Given a table (e.g. mailing_list), go to the 'Structure' tab. View the column names and column data types. Edit the cell for default.

Separately, we also edited the value for is_nullable after we made sure a given column had no NULL values.