aboutsummaryrefslogtreecommitdiffstats
path: root/utility/truncate_script.sql
diff options
context:
space:
mode:
authorMatthew Lemon <lemon@matthewlemon.com>2020-02-21 17:09:13 +0000
committerMatthew Lemon <lemon@matthewlemon.com>2020-02-21 17:09:13 +0000
commit29a6bc7097d8e0e6a0097c27e039242ec47f292c (patch)
treeb9876395adab2a1110871c8915d2727aab56f886 /utility/truncate_script.sql
parent3b2a8ac12c8b0303ebecf277f975449e8e560ec9 (diff)
added truncate sql script
Diffstat (limited to 'utility/truncate_script.sql')
-rw-r--r--utility/truncate_script.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/utility/truncate_script.sql b/utility/truncate_script.sql
new file mode 100644
index 0000000..47776a2
--- /dev/null
+++ b/utility/truncate_script.sql
@@ -0,0 +1,6 @@
+TRUNCATE TABLE users_user RESTART IDENTITY CASCADE;
+TRUNCATE TABLE organisations_organisation RESTART IDENTITY CASCADE;
+TRUNCATE TABLE organisations_mode RESTART IDENTITY CASCADE;
+TRUNCATE TABLE organisations_role RESTART IDENTITY CASCADE;
+TRUNCATE TABLE organisations_address RESTART IDENTITY CASCADE;
+TRUNCATE TABLE organisations_addresstype RESTART IDENTITY CASCADE;