mirror of
https://github.com/tiennm99/goclaw.git
synced 2026-06-10 00:13:42 +00:00
viettranx
5d632a522e
Add thread_id, thread_type columns to track forum topics and threaded conversations.
6 lines
308 B
SQL
6 lines
308 B
SQL
DROP INDEX IF EXISTS idx_channel_contacts_tenant_type_sender;
|
|
ALTER TABLE channel_contacts DROP COLUMN IF EXISTS thread_type;
|
|
ALTER TABLE channel_contacts DROP COLUMN IF EXISTS thread_id;
|
|
CREATE UNIQUE INDEX idx_channel_contacts_tenant_type_sender
|
|
ON channel_contacts (tenant_id, channel_type, sender_id);
|