iloom-flatten/migrations/20260530_052129_fix_yarn_ratios_insert_policy.sql

7 lines
509 B
MySQL
Raw Permalink Normal View History

-- ============================================
-- 此文件由 Meoo Cloud 自动生成,请勿修改
-- This file is auto-generated by Meoo Cloud, DO NOT MODIFY
-- ============================================
DROP POLICY IF EXISTS users_insert_yarn_ratios ON yarn_ratios; CREATE POLICY users_insert_yarn_ratios ON yarn_ratios FOR INSERT WITH CHECK (EXISTS ( SELECT 1 FROM production_plans WHERE production_plans.id = yarn_ratios.plan_id AND production_plans.purchaser_id = get_user_master_company_id() ));