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

008_ProjectionThreadActivitySequence.ts

16 lines434 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 ALTER TABLE projection_thread_activities
9 ADD COLUMN sequence INTEGER
10 `;
11​
12 yield* sql`
13 CREATE INDEX IF NOT EXISTS idx_projection_thread_activities_thread_sequence
14 ON projection_thread_activities(thread_id, sequence)
15 `;
16});