From 79a4be4a0b7f7a3127a815e14cc3534699d8bfce Mon Sep 17 00:00:00 2001
From: UMTS at Teleco <crt@teleco.ch>
Date: Sun, 11 Jan 2026 20:38:24 +0100
Subject: whoopsie

---
 backend/database/schema/beepzone-schema-dump.sql | 14 --------------
 1 file changed, 14 deletions(-)

(limited to 'backend/database/schema/beepzone-schema-dump.sql')

diff --git a/backend/database/schema/beepzone-schema-dump.sql b/backend/database/schema/beepzone-schema-dump.sql
index 69b619d..7ac6e09 100644
--- a/backend/database/schema/beepzone-schema-dump.sql
+++ b/backend/database/schema/beepzone-schema-dump.sql
@@ -2086,20 +2086,6 @@ CREATE TABLE `zones` (
 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
-ALTER TABLE `assets` ADD COLUMN `tag_generation_string` VARCHAR(255) DEFAULT NULL AFTER `asset_tag`;
-
-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;
-
 ALTER TABLE `zones` MODIFY `zone_code` VARCHAR(50) NOT NULL;
 
 ALTER TABLE `zones` ADD UNIQUE KEY `unique_zone_code` (`zone_code`);
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

