aboutsummaryrefslogtreecommitdiffstats
path: root/python_moondb/bin
diff options
context:
space:
mode:
Diffstat (limited to 'python_moondb/bin')
-rw-r--r--python_moondb/bin/drop_tables.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/python_moondb/bin/drop_tables.sql b/python_moondb/bin/drop_tables.sql
new file mode 100644
index 00000000..f5f65ea7
--- /dev/null
+++ b/python_moondb/bin/drop_tables.sql
@@ -0,0 +1,18 @@
+use moon;
+drop table action_assignments;
+drop table object_assignments;
+drop table subject_assignments;
+drop table subject_scopes;
+drop table action_scopes;
+drop table object_scopes;
+drop table action_categories;
+drop table subject_categories;
+drop table object_categories;
+drop table rules;
+drop table sub_meta_rules;
+drop table actions;
+drop table objects;
+drop table subjects;
+drop table tenants;
+drop table intra_extensions;
+show tables;