Skip to content

Commit 00616f5

Browse files
dannykoppingdannykopping
committed
Add migration fixtures for prebuilds
Also removed schedule table; we are not using it yet Signed-off-by: Danny Kopping <dannykopping@gmail.com>
1 parent b40d37b commit 00616f5

File tree

6 files changed

+2
-35
lines changed

6 files changed

+2
-35
lines changed

‎coderd/database/dump.sql

Lines changed: 0 additions & 14 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/foreign_key_constraint.go

Lines changed: 0 additions & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/migrations/000303_preset_prebuilds.up.sql

Lines changed: 0 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -9,16 +9,5 @@ CREATE TABLE template_version_preset_prebuilds
99
FOREIGN KEY (preset_id) REFERENCES template_version_presets (id) ON DELETE CASCADE
1010
);
1111

12-
CREATE TABLE template_version_preset_prebuild_schedules
13-
(
14-
id UUID PRIMARY KEY,
15-
preset_prebuild_id UUID NOT NULL,
16-
timezone TEXT NOT NULL,
17-
cron_schedule TEXT NOT NULL,
18-
desired_instances INT NOT NULL,
19-
20-
FOREIGN KEY (preset_prebuild_id) REFERENCES template_version_preset_prebuilds (id) ON DELETE CASCADE
21-
);
22-
2312
-- We should not be able to have presets with the same name for a particular template version.
2413
CREATE UNIQUE INDEX idx_unique_preset_name ON template_version_presets (name, template_version_id);

‎coderd/database/migrations/testdata/fixtures/000303_preset_prebuilds.up.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
INSERT INTO template_version_preset_prebuilds (id, preset_id, desired_instances)
2+
VALUES (gen_random_uuid(), '28b42cc0-c4fe-4907-a0fe-e4d20f1e9bfe', 1);

‎coderd/database/models.go

Lines changed: 0 additions & 8 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/unique_constraint.go

Lines changed: 0 additions & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

0 commit comments

Comments
 (0)