2 files changed, 17 insertions, 0 deletions
diff --git a/db/migrations/.keep b/db/migrations/.keep
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/db/migrations/.keep
diff --git a/db/migrations/00000000000001_create_users.cr b/db/migrations/00000000000001_create_users.cr
new file mode 100644
index 0000000..96283bf
--- /dev/null
+++ b/db/migrations/00000000000001_create_users.cr
@@ -0,0 +1,17 @@
+class CreateUsers::V00000000000001 < Avram::Migrator::Migration::V1
+  def migrate
+    enable_extension "citext"
+
+    create table_for(User) do
+      primary_key id : Int64
+      add_timestamps
+      add email : String, unique: true, case_sensitive: false
+      add encrypted_password : String
+    end
+  end
+
+  def rollback
+    drop table_for(User)
+    disable_extension "citext"
+  end
+end