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