Skip to content

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

746 B
Raw Blame

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;