- args:
    sql: CREATE EXTENSION IF NOT EXISTS pgcrypto;
  type: run_sql
- args:
    sql: "CREATE TABLE \"public\".\"parts_order_lines\"(\"id\" uuid NOT NULL DEFAULT
      gen_random_uuid(), \"created_at\" timestamptz NOT NULL DEFAULT now(), \"updated_at\"
      timestamptz NOT NULL DEFAULT now(), \"orderid\" uuid NOT NULL, \"job_line_id\"
      uuid, \"line_desc\" text NOT NULL, \"oem_partno\" text, \"db_price\" numeric,
      \"act_price\" numeric, \"status\" text NOT NULL DEFAULT 'Ordered', \"line_remarks\"
      text, PRIMARY KEY (\"id\") , FOREIGN KEY (\"orderid\") REFERENCES \"public\".\"parts_order\"(\"id\")
      ON UPDATE cascade ON DELETE cascade, FOREIGN KEY (\"job_line_id\") REFERENCES
      \"public\".\"joblines\"(\"id\") ON UPDATE restrict ON DELETE set null);\nCREATE
      OR REPLACE FUNCTION \"public\".\"set_current_timestamp_updated_at\"()\nRETURNS
      TRIGGER AS $$\nDECLARE\n  _new record;\nBEGIN\n  _new := NEW;\n  _new.\"updated_at\"
      = NOW();\n  RETURN _new;\nEND;\n$$ LANGUAGE plpgsql;\nCREATE TRIGGER \"set_public_parts_order_lines_updated_at\"\nBEFORE
      UPDATE ON \"public\".\"parts_order_lines\"\nFOR EACH ROW\nEXECUTE PROCEDURE
      \"public\".\"set_current_timestamp_updated_at\"();\nCOMMENT ON TRIGGER \"set_public_parts_order_lines_updated_at\"
      ON \"public\".\"parts_order_lines\" \nIS 'trigger to set value of column \"updated_at\"
      to current timestamp on row update';\n"
  type: run_sql
- args:
    name: parts_order_lines
    schema: public
  type: add_existing_table_or_view
