OU data removal script

[migration-tools.git] / remove_ou_data / README

diff --git a/remove_ou_data/README b/remove_ou_data/README
new file mode 100644 (file)
index 0000000..c740409
--- /dev/null
+++ b/remove_ou_data/README
@@ -0,0 +1,20 @@
+This is a set of SQL scripts to be run, in order, to completely
+remove data belonging to an OU and its descendants in an Evergreen
+database.  Each script uses a variable called ou_to_del that should
+be set to the shortname of the OU to remove.
+
+Generate script to delete users:
+
+SELECT 'DELETE FROM actor.usr WHERE id = ' || id || ';'
+FROM actor.usr WHERE home_ou IN (
+    SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit
+    WHERE shortname = 'EXAMPLE'
+);
+
+After running through the scripts, it should be possible to
+remove the actor.org_unit entries themselves.
+
+TODO:
+
+-- remove event output that is no longer associated with any events
+-- remvoe user address auditor entries