Vapor database migration examples using addProperties function

quote_migration.swift

extension Quote: Migration { 
  static func prepare(on connection: PostgreSQLConnection) -> Future<Void> {
    return Database.create(self, on: connection) { builder in
      // Add fields from above
      try addProperties(to: builder)

      // Add FOREIGN KEY reference
      builder.reference(from: \.authorID, to: \Author.id)

      // make content UNIQUE and indexed
      builder.unique(on: \.content)
    }
  }
}

quote_migration_full.swift

extension Quote: Migration { 
  static func prepare(on connection: PostgreSQLConnection) -> Future<Void> {
    return Database.create(self, on: connection) { builder in
      builder.field(for: \.id, type: .uuid)
      builder.field(for: \.content)
      builder.field(for: \.authorID, type: .uuid)
      builder.field(for: \.createdAt)
      builder.field(for: \.updatedAt)

      // Add FOREIGN KEY reference
      builder.reference(from: \.authorID, to: \Author.id)

      // make content UNIQUE and indexed
      builder.unique(on: \.content)
    }
  }
}