-- Database Migration Plan
CREATE TABLE organizations (
  id uuid PRIMARY KEY,
  name text NOT NULL,
  subscription_plan text DEFAULT 'freemium',
  created_at timestamp with time zone
);

CREATE TABLE products (
  id uuid PRIMARY KEY,
  name text NOT NULL,
  thickness numeric NOT NULL,
  sale_price numeric NOT NULL,
  organization_id uuid REFERENCES organizations(id)
);

CREATE TABLE calculators (
  id uuid PRIMARY KEY,
  name text NOT NULL,
  customer_name text NOT NULL,
  status text DEFAULT 'active'
);

-- Enable Row Level Security
ALTER TABLE products ENABLE ROW LEVEL SECURITY;
CREATE POLICY "users_view_org_products" ON products
  FOR SELECT USING (organization_id IN (
    SELECT organization_id FROM profiles WHERE id = auth.uid()
  ));

-- Create Indexes
CREATE INDEX idx_products_org ON products(organization_id);
CREATE INDEX idx_calculators_org ON calculators(organization_id);

-- Migration Statistics
-- Total Tables: 27
-- Total Indexes: 94
-- RLS Policies: 58
-- Extensions: 6

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE EXTENSION IF NOT EXISTS "pgcrypto";

-- Core Functions
CREATE OR REPLACE FUNCTION handle_updated_at()
RETURNS trigger AS $$
BEGIN
  new.updated_at = TIMEZONE('utc', NOW());
  RETURN new;
END;
$$ LANGUAGE plpgsql;

-- Triggers
CREATE TRIGGER update_quotes_updated_at
  BEFORE UPDATE ON quotes
  FOR EACH ROW EXECUTE FUNCTION handle_updated_at();