create table inventory ( part text primary key, barcode text, current_stock integer default 0, target_2mo integer default 20, target_3mo integer default 30, target_4mo integer default 40, updated_at timestamptz default now() ); create table scan_log ( id uuid default gen_random_uuid() primary key, part text, delta integer, logged_at timestamptz default now() ); create table components ( id text primary key, wire_type text, size integer, category text, units_per_spool integer, spool_ft integer, on_hand integer default 0, updated_at timestamptz default now() ); alter table inventory enable row level security; alter table scan_log enable row level security; create policy "allow all" on inventory for all using (true) with check (true); create policy "allow all" on scan_log for all using (true) with check (true); alter table components enable row level security; create policy "allow all" on components for all using (true) with check (true); -- Add snowflake columns to custom_orders (run once): -- alter table spool_inventory add column if not exists order_qty_months numeric default 6; -- alter table custom_orders add column if not exists snowflake_type text; -- alter table custom_orders add column if not exists snowflake_description text; -- Fix loop_ft column to support decimals (run once): -- alter table custom_orders alter column loop_ft type numeric using loop_ft::numeric; -- Add employee column to scan_log if not exists: -- alter table scan_log add column if not exists employee text; -- Run this to add line_items support to existing custom_orders table: -- alter table custom_orders add column line_items jsonb default '[]'::jsonb; -- Run this to enable Realtime on custom_orders: -- alter publication supabase_realtime add table custom_orders; create table custom_orders ( id text primary key, customer text, loop_ft integer, lead_ft integer, qty integer, loop_wire text, lead_wire text, is_db boolean, use_typeb boolean default false, ups_red boolean default false, notes text, status text default 'pending', created_at timestamptz default now(), pulled_at timestamptz ); alter table custom_orders enable row level security; create policy "allow all" on custom_orders for all using (true) with check (true);