Eduardo ebarrera89

ebarrera89 / add.sql

Created October 24, 2023 16:29 — forked from dongryphon/add.sql

Closure table triggers

	-- NOTE: Organizations have id and parentOrgId columns
	-- OrgClosure has parentId, childId, depth columns

	CREATE OR REPLACE TRIGGER Org_Add_Trigger
	AFTER INSERT ON Organization
	REFERENCING NEW AS NEW
	FOR EACH ROW
	BEGIN
	-- must insert in this order...
	insert into OrgClosure (parentId, childId, depth)

ebarrera89 / mysql-docker.sh

Created March 22, 2021 05:01 — forked from spalladino/mysql-docker.sh

Backup and restore a mysql database from a running Docker mysql container

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE