diff options
Diffstat (limited to 'priv/repo/migrations')
4 files changed, 41 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 |