1 files changed, 19 insertions, 0 deletions
diff --git a/migrations/deploy/users.sql b/migrations/deploy/users.sql
new file mode 100644
index 0000000..63b25cc
--- /dev/null
+++ b/migrations/deploy/users.sql
@@ -0,0 +1,19 @@
+-- Deploy byspel:users to sqlite
+
+BEGIN;
+
+create table users(
+  id uuid not null primary key,
+  primary_email string not null unique,
+  full_name string,
+  avatar string not null,
+  last_login timestamp
+);
+
+create table shadow(
+  user_id uuid not null primary key,
+  hash string not null,
+  foreign key (user_id) references users(id)
+);
+
+COMMIT;