Skip to content
Source
Sign inSign up
pingdotgg/t3code
Open History to see the last commit

018_ProjectionThreadsArchivedAtIndex.ts

11 lines325 Bytes

1import * as Effect from "effect/Effect";
2import * as SqlClient from "effect/sql/SqlClient";
3​
4export default Effect.gen(function* () {
5 const sql = yield* SqlClient.SqlClient;
6​
7 yield* sql`
8 CREATE INDEX IF NOT EXISTS idx_projection_threads_project_archived_at
9 ON projection_threads(project_id, archived_at)
10 `;
11});