Files
auv/migrations/20260703_124548_add_user_id_to_collections.sql
2026-07-05 21:29:17 +08:00

7 lines
552 B
SQL
Executable File

-- ============================================
-- 此文件由 Meoo Cloud 自动生成,请勿修改
-- This file is auto-generated by Meoo Cloud, DO NOT MODIFY
-- ============================================
ALTER TABLE stock_collections ADD COLUMN user_id VARCHAR(100) NOT NULL DEFAULT ''; ALTER TABLE stock_collections ADD COLUMN last_accessed_at TIMESTAMPTZ NOT NULL DEFAULT NOW(); CREATE INDEX idx_stock_collections_user_id ON stock_collections(user_id); CREATE INDEX idx_stock_collections_last_accessed ON stock_collections(last_accessed_at);