lightning-terminal/db/sqlc/migrations/000003_kvstores.down.sql
Elle Mouton e8d72f7276
db/sqlc: kvstores schemas & queries
In this commit, we define the schemas and queries that are needed to
implement the firewalldb's KVStores in SQL.
2025-04-10 13:03:20 +02:00

9 lines
277 B
SQL

-- Drop indexes first.
DROP INDEX IF EXISTS kvstores_lookup_idx;
DROP INDEX IF EXISTS features_name_idx;
DROP INDEX IF EXISTS rules_name_idx;
-- Drop tables in reverse dependency order.
DROP TABLE IF EXISTS kvstores;
DROP TABLE IF EXISTS features;
DROP TABLE IF EXISTS rules;