ALTER TABLE athena.gateway_webhook DROP CONSTRAINT IF EXISTS gateway_webhook_route_key_check;

ALTER TABLE athena.gateway_webhook ADD CONSTRAINT gateway_webhook_route_key_check CHECK (route_key IN (
    'billing_document_upserted',
    'gateway_data', 'gateway_fetch', 'gateway_update', 'gateway_query',
    'gateway_insert', 'gateway_delete',
    'rest_get', 'rest_post', 'rest_patch', 'rest_delete',
    'schema_table_created', 'schema_table_dropped',
    'schema_view_created', 'schema_view_dropped',
    'schema_column_added', 'schema_column_dropped', 'schema_column_renamed', 'schema_column_altered',
    'schema_index_created', 'schema_index_dropped', 'schema_extension_installed'
));

ALTER TABLE athena.gateway_webhook_sink DROP CONSTRAINT IF EXISTS gateway_webhook_sink_route_key_check;

ALTER TABLE athena.gateway_webhook_sink ADD CONSTRAINT gateway_webhook_sink_route_key_check CHECK (route_key IN (
    'billing_document_upserted',
    'gateway_data', 'gateway_fetch', 'gateway_update', 'gateway_query',
    'gateway_insert', 'gateway_delete',
    'rest_get', 'rest_post', 'rest_patch', 'rest_delete',
    'schema_table_created', 'schema_table_dropped',
    'schema_view_created', 'schema_view_dropped',
    'schema_column_added', 'schema_column_dropped', 'schema_column_renamed', 'schema_column_altered',
    'schema_index_created', 'schema_index_dropped', 'schema_extension_installed'
));
