27 lines
1.0 KiB
PL/PgSQL
27 lines
1.0 KiB
PL/PgSQL
BEGIN;
|
|
|
|
-- Dritte Referenz-Distribution (Roadmap-Plan Phase 1, siehe
|
|
-- platform-docs/roadmap/multi-distro-merkmal-workspace-creator.md und
|
|
-- tuxflotte-installer@4f3ea1b fuer backends/ubuntu-image/backend.sh).
|
|
INSERT INTO backends (id, key, name, installer_type, version) VALUES
|
|
(gen_random_uuid(), 'ubuntu-image', 'Ubuntu (Golden Image)', 'golden-image', '26.04');
|
|
|
|
-- Test-/Entwicklungsvorlage in der Liebherr-Org, analog zu den bestehenden
|
|
-- Tuxflotte-Mint-Entwicklung-v0.1 / Tuxflotte-Debian-Entwicklung-v0.1.
|
|
INSERT INTO bereitstellungsvorlagen
|
|
(id, organization_id, workspace_id, backend_id, label, is_default,
|
|
disk_encryption, partitioning, secure_boot_required)
|
|
SELECT
|
|
gen_random_uuid(),
|
|
'ab49c741-6795-43d3-abd4-50772565365a', -- Org "Liebherr"
|
|
'55555555-5555-4555-8555-555555555555', -- Workspace "Entwickler"
|
|
id,
|
|
'Tuxflotte-Ubuntu-Entwicklung-v0.1',
|
|
false,
|
|
false,
|
|
'{"scheme": "single", "root_filesystem": "ext4", "target_disk_rank": 1}'::jsonb,
|
|
false
|
|
FROM backends WHERE key = 'ubuntu-image';
|
|
|
|
COMMIT;
|