flesh out SQL schema

1 files changed, 26 insertions, 3 deletions

diff --git a/rust/migrations/2018-05-12-001226_init/down.sql b/rust/migrations/2018-05-12-001226_init/down.sql
index 6c379b2f..087f02b2 100644
--- a/rust/migrations/2018-05-12-001226_init/down.sql
+++ b/rust/migrations/2018-05-12-001226_init/down.sql
@@ -1,7 +1,30 @@
 
-DROP TABLE IF EXISTS editor CASCADE;
-DROP TABLE IF EXISTS editgroup CASCADE;
-DROP TABLE IF EXISTS changelog CASCADE;
+-- in opposite order as up.sql
+
+DROP TABLE IF EXISTS release_contrib CASCADE;
+DROP TABLE IF EXISTS release_ref CASCADE;
+DROP TABLE IF EXISTS file_release CASCADE;
+
+DROP TABLE IF EXISTS work_rev CASCADE;
+DROP TABLE IF EXISTS work_ident CASCADE;
+DROP TABLE IF EXISTS work_edit CASCADE;
+
+DROP TABLE IF EXISTS release_rev CASCADE;
+DROP TABLE IF EXISTS release_ident CASCADE;
+DROP TABLE IF EXISTS release_edit CASCADE;
+
+DROP TABLE IF EXISTS file_rev CASCADE;
+DROP TABLE IF EXISTS file_ident CASCADE;
+DROP TABLE IF EXISTS file_edit CASCADE;
+
+DROP TABLE IF EXISTS container_rev CASCADE;
+DROP TABLE IF EXISTS container_ident CASCADE;
+DROP TABLE IF EXISTS container_edit CASCADE;
+
 DROP TABLE IF EXISTS creator_rev CASCADE;
 DROP TABLE IF EXISTS creator_ident CASCADE;
 DROP TABLE IF EXISTS creator_edit CASCADE;
+
+DROP TABLE IF EXISTS editor CASCADE;
+DROP TABLE IF EXISTS editgroup CASCADE;
+DROP TABLE IF EXISTS changelog CASCADE;