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 UNIQUE INDEX uk_tech_book_id_name ON tech_book(id, name);
- statement: |
CREATE UNIQUE INDEX uk_tech_book_id_name ON tech_book(id, name);
CREATE UNIQUE INDEX tech_book_id_name ON tech_book(id, name);
want:
- status: 2
code: 304
title: NAMING_INDEX_UK
content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `tech_book_id_name`
startposition:
line: 2
column: 0
endposition: null
- statement: |
CREATE UNIQUE INDEX uk_tech_book_id_name ON tech_book(id, name);
CREATE UNIQUE INDEX qtzmquwvlnttctfluoouxelxeliltcfzzstrtyocogwwyiyrflmrkbhbfasynlacy ON tech_book(id, name)
want:
- status: 2
code: 304
title: NAMING_INDEX_UK
content: Unique key `qtzmquwvlnttctfluoouxelxeliltcfzzstrtyocogwwyiyrflmrkbhbfasynlacy` in table `tech_book` mismatches the naming convention, its length should be within 64 characters
startposition:
line: 2
column: 0
endposition: null
- status: 2
code: 304
title: NAMING_INDEX_UK
content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `qtzmquwvlnttctfluoouxelxeliltcfzzstrtyocogwwyiyrflmrkbhbfasynlacy`
startposition:
line: 2
column: 0
endposition: null
- statement: ALTER TABLE tech_book ADD UNIQUE uk_tech_book_id_name (id, name);
- statement: |
CREATE TABLE t1(a INT);
ALTER TABLE tech_book ADD UNIQUE tech_book_id_name (id, name);
want:
- status: 2
code: 304
title: NAMING_INDEX_UK
content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `tech_book_id_name`
startposition:
line: 2
column: 0
endposition: null
- statement: ALTER TABLE tech_book RENAME INDEX old_uk TO uk_tech_book_id_name;
- statement: |
CREATE TABLE t1(a INT);
ALTER TABLE tech_book RENAME INDEX old_uk TO uk_tech_book;
want:
- status: 2
code: 304
title: NAMING_INDEX_UK
content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `uk_tech_book`
startposition:
line: 2
column: 0
endposition: null
- statement: CREATE TABLE book(id INT PRIMARY KEY, name VARCHAR(20), UNIQUE INDEX uk_book_name (name));
- statement: |
CREATE TABLE book(
id INT PRIMARY KEY,
name VARCHAR(20),
UNIQUE KEY (name)
);
- statement: |
CREATE TABLE book(
id INT PRIMARY KEY,
name VARCHAR(20),
UNIQUE INDEX (name)
);