aboutsummaryrefslogtreecommitdiffstats
path: root/src/main/sql/1_create-database.down.sql
diff options
context:
space:
mode:
authormrfoxygmfr <mrfoxygmfr@sch9.ru>2025-03-17 12:20:49 +0300
committermrfoxygmfr <mrfoxygmfr@sch9.ru>2025-03-17 12:20:49 +0300
commitfef1dc61af7373892eb32595ddc47329c2167d78 (patch)
treef5de71c78e1e759c378238fbb0c5f01c85940df6 /src/main/sql/1_create-database.down.sql
parentcc3d95e5ac17887b38b417e91da1cef36fed7f4b (diff)
feat(migrations): add database schema init scripts
Diffstat (limited to 'src/main/sql/1_create-database.down.sql')
-rw-r--r--src/main/sql/1_create-database.down.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/src/main/sql/1_create-database.down.sql b/src/main/sql/1_create-database.down.sql
new file mode 100644
index 0000000..f43aba0
--- /dev/null
+++ b/src/main/sql/1_create-database.down.sql
@@ -0,0 +1,12 @@
+DROP TABLE IF EXISTS operation_products;
+DROP TABLE IF EXISTS operations;
+DROP TABLE IF EXISTS operation_statuses;
+DROP TYPE IF EXISTS OPERATION_TYPE;
+DROP TABLE IF EXISTS product_slots;
+DROP TABLE IF EXISTS product_storage_statues;
+DROP TABLE IF EXISTS storage_slots;
+DROP TABLE IF EXISTS partner_contacts;
+DROP TABLE IF EXISTS partners;
+DROP TYPE IF EXISTS PARTNER_TYPE;
+DROP TABLE IF EXISTS products;
+DROP TABLE IF EXISTS product_types; \ No newline at end of file