From 7b57e2df69eccbc0fe78f119e25e58bee18f576d Mon Sep 17 00:00:00 2001
From: UMTS at Teleco <crt@teleco.ch>
Date: Sun, 11 Jan 2026 19:58:54 +0100
Subject: cleanup time

---
 backend/database/dev/update_002_add_asset_relationships.sql | 11 -----------
 1 file changed, 11 deletions(-)
 delete mode 100644 backend/database/dev/update_002_add_asset_relationships.sql

(limited to 'backend/database/dev/update_002_add_asset_relationships.sql')

diff --git a/backend/database/dev/update_002_add_asset_relationships.sql b/backend/database/dev/update_002_add_asset_relationships.sql
deleted file mode 100644
index 0d74b89..0000000
--- a/backend/database/dev/update_002_add_asset_relationships.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-ALTER TABLE `assets` 
-ADD COLUMN `belongs_to_item` INT(11) DEFAULT NULL COMMENT 'References asset_numeric_id of parent asset' AFTER `asset_numeric_id`,
-ADD COLUMN `previously_was` INT(11) DEFAULT NULL COMMENT 'References asset_numeric_id of the asset this replaced' AFTER `belongs_to_item`;
-
-ALTER TABLE `assets`
-ADD KEY `idx_belongs_to` (`belongs_to_item`),
-ADD KEY `idx_previously_was` (`previously_was`);
-
-ALTER TABLE `assets`
-ADD CONSTRAINT `fk_assets_belongs_to` FOREIGN KEY (`belongs_to_item`) REFERENCES `assets` (`asset_numeric_id`) ON DELETE SET NULL,
-ADD CONSTRAINT `fk_assets_previously_was` FOREIGN KEY (`previously_was`) REFERENCES `assets` (`asset_numeric_id`) ON DELETE SET NULL;
-- 
cgit v1.2.3-70-g09d2

