1 files changed, 26 insertions, 0 deletions
diff --git a/lib/matrix_app_service/migrations.ex b/lib/matrix_app_service/migrations.ex
new file mode 100644
index 0000000..e6ce469
--- /dev/null
+++ b/lib/matrix_app_service/migrations.ex
@@ -0,0 +1,26 @@
+defmodule MatrixAppService.Migrations do
+  use Ecto.Migration
+
+  def change do
+    create table(:users) do
+      add :local_id, :string
+      add :remote_id, :string
+      add :data, :map
+
+      timestamps()
+    end
+    create unique_index(:users, [:local_id])
+    create unique_index(:users, [:remote_id])
+
+
+    create table(:rooms) do
+      add :local_id, :string
+      add :remote_id, :string
+      add :data, :map
+
+      timestamps()
+    end
+    create unique_index(:rooms, [:local_id])
+    create unique_index(:rooms, [:remote_id])
+  end
+end