postgresql CB missing some columns
There appear to be a few omissions in the Postgresql CB schema:
dhcp4_option_def - missing class_id column and related constraints dhcp6_option_def - missing class_id column and related constraints
see MySQL change (similar change for dhcp4 too)
ALTER TABLE dhcp6_option_def
ADD COLUMN class_id BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE dhcp6_option_def
ADD CONSTRAINT fk_dhcp6_option_def_client_class_id
FOREIGN KEY (class_id)
REFERENCES dhcp6_client_class (id)
ON DELETE CASCADE
ON UPDATE CASCADE;
dhcp6_client_class - missing preferred_lifetime
Need to do an audit and see if there are any other missing elements.