diff options
Diffstat (limited to 'libbrep/package-030-pre.sql')
| -rw-r--r-- | libbrep/package-030-pre.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/libbrep/package-030-pre.sql b/libbrep/package-030-pre.sql new file mode 100644 index 0000000..8cfa823 --- /dev/null +++ b/libbrep/package-030-pre.sql @@ -0,0 +1,17 @@ +/* This file was generated by ODB, object-relational mapping (ORM) + * compiler for C++. + */ + +ALTER TABLE "tenant" + ADD COLUMN "service_id" TEXT NULL, + ADD COLUMN "service_type" TEXT NULL, + ADD COLUMN "service_data" TEXT NULL, + ADD COLUMN "queued_timestamp" BIGINT NULL; + +CREATE INDEX "tenant_service_id_i" + ON "tenant" ("service_id"); + +UPDATE "schema_version" + SET "version" = 30, "migration" = TRUE + WHERE "name" = 'package'; + |