c/bmaas/bmdb: add Agent{Started,Heartbeat} tags and queries
This should be the required tags and queries for the first interactions
with the Shepherd subsystem.
Change-Id: I8c663803cfd936b11c59bce7db5abc94b99dd1db
Reviewed-on: https://review.monogon.dev/c/monogon/+/962
Tested-by: Jenkins CI
Reviewed-by: Mateusz Zalega <mateusz@monogon.tech>
diff --git a/cloud/bmaas/bmdb/model/migrations/1662136250_initial.up.sql b/cloud/bmaas/bmdb/model/migrations/1662136250_initial.up.sql
index b31324f..7b5b812 100644
--- a/cloud/bmaas/bmdb/model/migrations/1662136250_initial.up.sql
+++ b/cloud/bmaas/bmdb/model/migrations/1662136250_initial.up.sql
@@ -49,25 +49,4 @@
process process NOT NULL,
UNIQUE (machine_id, process),
CONSTRAINT "primary" PRIMARY KEY (machine_id, session_id, process)
-);
-
--- The following three tables are for illustrative purposes only.
-
-CREATE TABLE machine_provided (
- machine_id UUID NOT NULL REFERENCES machines(machine_id) ON DELETE CASCADE,
- provider STRING NOT NULL,
- provider_id STRING NOT NULL,
- CONSTRAINT "primary" PRIMARY KEY (machine_id)
-);
-
-CREATE TABLE machine_agent_installed (
- machine_id UUID NOT NULL REFERENCES machines(machine_id) ON DELETE CASCADE,
- CONSTRAINT "primary" PRIMARY KEY (machine_id)
-);
-
-CREATE TABLE machine_agent_report (
- machine_id UUID NOT NULL REFERENCES machines(machine_id) ON DELETE CASCADE,
- shape_cpu_count INT NOT NULL,
- shape_memory_megabytes INT NOT NULL,
- CONSTRAINT "primary" PRIMARY KEY (machine_id)
-);
+);
\ No newline at end of file