more-examples.swift

extension User: Migration {
    static func prepare(on connection: PostgreSQLConnection) -> Future<void> {
        return Database.create(self, on: connection) { builder in
            builder.field(for: \.id, type: .int, isIdentifier: true)
            builder.field(for: \.email, type: .string, .notNull)
            builder.field(for: \.lifeStory, type: .text)
            builder.field(for: \.iq, type: .int, .default(.literal("123456")))
            builder.field(for: \.companyID, type: .int)
            builder.reference(from: \.companyID, to: \Company.id)
            builder.unique(on: \.email)
        }
    }
}