Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- 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