     CREATE UNIQUE INDEX users_lowercase_name_index
     ON users USING btree (lower(name));
     """
+  end
+
+  def profiles do
+    create table(:profiles) do
+      add :bio, :text, null: false, default: ""
+      add :comments_count, :integer, null: false, default: 0
+      add :user_id, references(:users)
+    end
+
+    create unique_index(:profiles, [:user_id])
   end
 
   def images do


      add :merged_into_id, references(:images)

      timestamps
    end

    create index(:images, [:tags], using: :gin)


  def change do
    users()
    profiles()
    images()
  end

