iloom-flatten/migrations/20260523_124703_add_company_id_to_inventory.sql

15 lines
784 B
MySQL
Raw Permalink Normal View History

-- ============================================
-- 此文件由 Meoo Cloud 自动生成,请勿修改
-- This file is auto-generated by Meoo Cloud, DO NOT MODIFY
-- ============================================
ALTER TABLE product_inventory_records ADD COLUMN company_id UUID REFERENCES companies(id) ON DELETE CASCADE;
-- 更新RLS策略
CREATE POLICY company_select_product_inventory_records ON product_inventory_records FOR SELECT USING (true);
CREATE POLICY company_insert_product_inventory_records ON product_inventory_records FOR INSERT WITH CHECK (true);
CREATE POLICY company_update_product_inventory_records ON product_inventory_records FOR UPDATE USING (true);
CREATE POLICY company_delete_product_inventory_records ON product_inventory_records FOR DELETE USING (true);