in Sources/XCMetricsBackendLib/Common/Repositories/Postgress/Migrations/CreateBuildMetadata.swift [24:41]
func prepare(on database: Database) -> EventLoopFuture<Void> {
if let sql = database as? SQLDatabase {
return sql.raw("""
CREATE TABLE build_metadata (
id uuid,
day date NOT NULL,
build_identifier text NOT NULL,
metadata jsonb NOT NULL,
PRIMARY KEY (id, day)
) PARTITION BY LIST (day);
""").run()
}
return database.schema("build_metadata")
.id()
.field("build_identifier", .string, .required)
.field("metadata", .json, .required)
.create()
}