ALTER TABLE site_settings
  ADD COLUMN IF NOT EXISTS upload_max_file_count INTEGER NOT NULL DEFAULT 20,
  ADD COLUMN IF NOT EXISTS upload_max_total_size BIGINT NOT NULL DEFAULT 314572800;

ALTER TABLE site_settings
  ADD CONSTRAINT site_settings_upload_max_file_count_range_check
  CHECK (upload_max_file_count BETWEEN 1 AND 50)
  NOT VALID;

ALTER TABLE site_settings
  ADD CONSTRAINT site_settings_upload_max_total_size_range_check
  CHECK (upload_max_total_size BETWEEN 1048576 AND 1073741824)
  NOT VALID;

ALTER TABLE site_settings
  VALIDATE CONSTRAINT site_settings_upload_max_file_count_range_check;

ALTER TABLE site_settings
  VALIDATE CONSTRAINT site_settings_upload_max_total_size_range_check;