Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.1 KB
Raw Blame
- statement: |-
    CREATE TABLE MyTable (
      id INT,
      creator_id INT,
      created_ts INT,
      updated_ts INT,
      updater_id INT
    );
  changeType: 1
- statement: |-
    CREATE TABLE t (
      name TEXT,
      age INT
    );
  changeType: 1
  want:
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "created_ts"
      startposition:
        line: 1
        column: 0
      endposition: null
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "creator_id"
      startposition:
        line: 1
        column: 0
      endposition: null
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "id"
      startposition:
        line: 1
        column: 0
      endposition: null
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "updated_ts"
      startposition:
        line: 1
        column: 0
      endposition: null
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "updater_id"
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t (
      id INT,
      creator_id INT,
      created_ts INT,
      updater_id INT
    );
  changeType: 1
  want:
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "updated_ts"
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: ALTER TABLE t DROP COLUMN created_ts;
  changeType: 1
  want:
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "created_ts"
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: ALTER TABLE t DROP COLUMN creator_id;
  changeType: 1
  want:
    - status: 2
      code: 401
      title: COLUMN_REQUIRED
      content: Table t missing required column "creator_id"
      startposition:
        line: 1
        column: 0
      endposition: null