From b9506be0a6cb9b58a6ce634a13cbf3b3c7155545 Mon Sep 17 00:00:00 2001 From: UMTS at Teleco Date: Sun, 11 Jan 2026 20:01:08 +0100 Subject: include updates crudely --- backend/database/schema/beepzone-schema-dump.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'backend') diff --git a/backend/database/schema/beepzone-schema-dump.sql b/backend/database/schema/beepzone-schema-dump.sql index 05d738a..69b619d 100644 --- a/backend/database/schema/beepzone-schema-dump.sql +++ b/backend/database/schema/beepzone-schema-dump.sql @@ -2086,3 +2086,20 @@ 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