Skip to content

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

3.5 KB
Raw Blame
- statement: |-
    CREATE TABLE has_pk(id INT PRIMARY KEY);
    CREATE TABLE no_pk(id INT);
    CREATE TABLE has_pk_fork LIKE has_pk;
    CREATE TABLE no_pk_fork LIKE no_pk;
  changeType: 1
  want:
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `no_pk` requires PRIMARY KEY
      startposition:
        line: 2
        column: 0
      endposition: null
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `no_pk_fork` requires PRIMARY KEY
      startposition:
        line: 4
        column: 0
      endposition: null
- statement: CREATE TABLE t(id INT PRIMARY KEY)
  changeType: 1
- statement: CREATE TABLE t(id INT, PRIMARY KEY (id))
  changeType: 1
- statement: CREATE TABLE t(id INT)
  changeType: 1
  want:
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `t` requires PRIMARY KEY
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t(id INT);
                DROP TABLE t
  changeType: 1
- statement: |-
    CREATE TABLE t(id INT);
                ALTER TABLE t ADD CONSTRAINT PRIMARY KEY (id)
  changeType: 1
- statement: |-
    CREATE TABLE t(id INT PRIMARY KEY);
                ALTER TABLE t DROP PRIMARY KEY
  changeType: 1
  want:
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `t` requires PRIMARY KEY
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t(id INT PRIMARY KEY);
    ALTER TABLE t DROP INDEX `PRIMARY`
  changeType: 1
  want:
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `t` requires PRIMARY KEY
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t(id INT);
                ALTER TABLE t ADD COLUMN name varchar(30) PRIMARY KEY
  changeType: 1
- statement: |-
    CREATE TABLE t(id INT);
                ALTER TABLE t CHANGE COLUMN id id INT PRIMARY KEY
  changeType: 1
- statement: ALTER TABLE tech_book CHANGE COLUMN id uid INT
  changeType: 1
- statement: |-
    CREATE TABLE t(id INT);
                ALTER TABLE t MODIFY COLUMN id INT PRIMARY KEY
  changeType: 1
- statement: ALTER TABLE tech_book MODIFY COLUMN id INT
  changeType: 1
- statement: |-
    CREATE TABLE t(id INT, name varchar(30), PRIMARY KEY(id, name));
                ALTER TABLE t DROP COLUMN id
  changeType: 1
- statement: |-
    CREATE TABLE t(id INT, name varchar(30), comment varchar(255), PRIMARY KEY(id, name));
                ALTER TABLE t DROP COLUMN id, DROP COLUMN name
  changeType: 1
  want:
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `t` requires PRIMARY KEY
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: ALTER TABLE tech_book ADD COLUMN a int, DROP COLUMN id, DROP COLUMN name
  changeType: 1
  want:
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `tech_book` requires PRIMARY KEY
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: ALTER TABLE tech_book DROP COLUMN name
  changeType: 1
- statement: |-
    ALTER TABLE tech_book CHANGE COLUMN id uid int;
                ALTER TABLE tech_book ADD COLUMN a int, DROP COLUMN uid, DROP COLUMN name
  changeType: 1
  want:
    - status: 2
      code: 601
      title: TABLE_REQUIRE_PK
      content: Table `tech_book` requires PRIMARY KEY
      startposition:
        line: 2
        column: 0
      endposition: null