5 files changed, 52 insertions, 0 deletions
diff --git a/priv/repo/migrations/.formatter.exs b/priv/repo/migrations/.formatter.exs
new file mode 100644
index 0000000..49f9151
--- /dev/null
+++ b/priv/repo/migrations/.formatter.exs
@@ -0,0 +1,4 @@
+[
+  import_deps: [:ecto_sql],
+  inputs: ["*.exs"]
+]
diff --git a/priv/repo/migrations/20250323093704_create_users.exs b/priv/repo/migrations/20250323093704_create_users.exs
new file mode 100644
index 0000000..c418326
--- /dev/null
+++ b/priv/repo/migrations/20250323093704_create_users.exs
@@ -0,0 +1,13 @@
+defmodule Silmataivas.Repo.Migrations.CreateUsers do
+  use Ecto.Migration
+
+  def change do
+    create table(:users) do
+      add :user_id, :string
+
+      timestamps(type: :utc_datetime)
+    end
+
+    create unique_index(:users, [:user_id])
+  end
+end
diff --git a/priv/repo/migrations/20250323093713_create_locations.exs b/priv/repo/migrations/20250323093713_create_locations.exs
new file mode 100644
index 0000000..9373024
--- /dev/null
+++ b/priv/repo/migrations/20250323093713_create_locations.exs
@@ -0,0 +1,15 @@
+defmodule Silmataivas.Repo.Migrations.CreateLocations do
+  use Ecto.Migration
+
+  def change do
+    create table(:locations) do
+      add :latitude, :float
+      add :longitude, :float
+      add :user_id, references(:users, on_delete: :nothing)
+
+      timestamps(type: :utc_datetime)
+    end
+
+    create index(:locations, [:user_id])
+  end
+end
diff --git a/priv/repo/migrations/20250326104054_add_role_to_users.exs b/priv/repo/migrations/20250326104054_add_role_to_users.exs
new file mode 100644
index 0000000..786b46f
--- /dev/null
+++ b/priv/repo/migrations/20250326104054_add_role_to_users.exs
@@ -0,0 +1,9 @@
+defmodule Silmataivas.Repo.Migrations.AddRoleToUsers do
+  use Ecto.Migration
+
+  def change do
+    alter table(:users) do
+      add :role, :string, default: "user"
+    end
+  end
+end
diff --git a/priv/repo/seeds.exs b/priv/repo/seeds.exs
new file mode 100644
index 0000000..1a102d7
--- /dev/null
+++ b/priv/repo/seeds.exs
@@ -0,0 +1,11 @@
+# Script for populating the database. You can run it as:
+#
+#     mix run priv/repo/seeds.exs
+#
+# Inside the script, you can read and write to any of your
+# repositories directly:
+#
+#     Silmataivas.Repo.insert!(%Silmataivas.SomeSchema{})
+#
+# We recommend using the bang functions (`insert!`, `update!`
+# and so on) as they will fail if something goes wrong.