202211072338_website_healthcheck_fix1.sql 390 B

1234567891011
  1. ALTER TABLE HealthCheckParams RENAME TO HealthCheckParams_OLD;
  2. CREATE TABLE HealthCheckParams(
  3. ID INTEGER PRIMARY KEY AUTOINCREMENT,
  4. ConfigID INTEGER NOT NULL,
  5. Type TEXT NOT NULL,
  6. Key TEXT NOT NULL,
  7. Value TEXT NOT NULL,
  8. FOREIGN KEY(ConfigID) REFERENCES HealthCheckConfig(ID)
  9. );
  10. INSERT INTO HealthCheckParams SELECT * FROM HealthCheckParams_OLD;
  11. DROP TABLE HealthCheckParams_OLD;