~bigbes/lethe

ref: 2d9d2b8ec08ee09cc64c5d925ab85716b1d7d1fb lethe/internal/platform/database/migrations/0001_init.down.sql -rw-r--r-- 584 bytes
2d9d2b8e — Eugene Blikh search: add /api/v1/search API and opencode collector parser 24 days ago 
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

-- Drop in dependency order: triggers, FTS virtual tables, real tables.
-- Indexes on `sessions` are dropped automatically by DROP TABLE.

DROP TRIGGER IF EXISTS tool_outputs_fts_delete;
DROP TRIGGER IF EXISTS tool_outputs_fts_update;
DROP TRIGGER IF EXISTS tool_outputs_fts_insert;
DROP TRIGGER IF EXISTS turns_fts_delete;
DROP TRIGGER IF EXISTS turns_fts_update;
DROP TRIGGER IF EXISTS turns_fts_insert;

DROP TABLE IF EXISTS tool_outputs_fts;
DROP TABLE IF EXISTS turns_fts;

DROP INDEX IF EXISTS sessions_owner_started;

DROP TABLE IF EXISTS turns;
DROP TABLE IF EXISTS sessions;