Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
CREATE TABLE a (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
scratch VARCHAR(50),
PRIMARY KEY (id),
KEY idx_a_name (name),
KEY idx_a_scratch (scratch)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE b (
id INT NOT NULL AUTO_INCREMENT,
a_id INT NOT NULL,
PRIMARY KEY (id),
KEY idx_b_a (a_id),
CONSTRAINT fk_b_a FOREIGN KEY (a_id) REFERENCES a (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE scratch_table (
id INT PRIMARY KEY,
v INT NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE VIEW v_a AS SELECT id, name FROM a;
CREATE FUNCTION f_double(x INT) RETURNS INT DETERMINISTIC RETURN x * 2;
CREATE PROCEDURE p_reset() BEGIN UPDATE scratch_table SET v = 0; END;