Reserve some usernames for system

2 files changed, 10 insertions, 0 deletions

diff --git a/migrations/2020-02-04-123502_reserved_users/down.sql b/migrations/2020-02-04-123502_reserved_users/down.sql
new file mode 100644
index 0000000..7caccef
--- /dev/null
+++ b/migrations/2020-02-04-123502_reserved_users/down.sql
@@ -0,0 +1,5 @@
+delete from users where username in (
+  'root',
+  'system',
+  'admin'
+);
diff --git a/migrations/2020-02-04-123502_reserved_users/up.sql b/migrations/2020-02-04-123502_reserved_users/up.sql
new file mode 100644
index 0000000..c386998
--- /dev/null
+++ b/migrations/2020-02-04-123502_reserved_users/up.sql
@@ -0,0 +1,5 @@
+insert into users (username, password) values
+  ('root', 'reserved'),
+  ('system', 'reserved'),
+  ('admin', 'reserved')
+;