- args:
    sql: CREATE EXTENSION IF NOT EXISTS pgcrypto;
  type: run_sql
- args:
    sql: "CREATE TABLE \"public\".\"vendors\"(\"id\" uuid NOT NULL DEFAULT gen_random_uuid(),
      \"created_at\" timestamptz NOT NULL DEFAULT now(), \"updated_at\" timestamptz
      NOT NULL DEFAULT now(), \"bodyshopid\" uuid NOT NULL, \"name\" text NOT NULL,
      \"street1\" text, \"street2\" text, \"city\" text, \"state\" text, \"zip\" text,
      \"country\" text, \"email\" text, \"taxid\" text, \"discount\" numeric NOT NULL
      DEFAULT 0, \"prompt_discount\" numeric NOT NULL DEFAULT 0, \"due_date\" integer,
      \"terms\" text, \"display_name\" text, PRIMARY KEY (\"id\") , FOREIGN KEY (\"bodyshopid\")
      REFERENCES \"public\".\"bodyshops\"(\"id\") ON UPDATE cascade ON DELETE cascade);\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_vendors_updated_at\"\nBEFORE
      UPDATE ON \"public\".\"vendors\"\nFOR EACH ROW\nEXECUTE PROCEDURE \"public\".\"set_current_timestamp_updated_at\"();\nCOMMENT
      ON TRIGGER \"set_public_vendors_updated_at\" ON \"public\".\"vendors\" \nIS
      'trigger to set value of column \"updated_at\" to current timestamp on row update';\n"
  type: run_sql
- args:
    name: vendors
    schema: public
  type: add_existing_table_or_view
