User roles.v0.0.13

2 files changed, 19 insertions, 2 deletions

diff --git a/db/migrations.go b/db/migrations.go
index f0df49c..e8fc40d 100644
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -89,4 +89,15 @@ var migrations []Migration = []Migration{
                         "DROP TYPE market_config_status",
                 },
         },
+        {
+                Version: 201805131000,
+                Up: []string{
+                        "CREATE TYPE user_role AS ENUM ('admin', 'user')",
+                        "ALTER TABLE users ADD role user_role NOT NULL DEFAULT 'user'",
+                },
+                Down: []string{
+                        "ALTER TABLE users DROP COLUMN role",
+                        "DROP TYPE user_role",
+                },
+        },
 }
diff --git a/db/user.go b/db/user.go
index 64ca6a6..24ce491 100644
--- a/db/user.go
+++ b/db/user.go
@@ -11,10 +11,16 @@ const (
         AwaitingConfirmation
 )
 
+type UserRole string
+
+const RoleUser UserRole = "user"
+const RoleAdmin UserRole = "admin"
+
 type User struct {
         Id           int64
-        Email        string `sql:",unique,notnull"`
-        PasswordHash string `sql:",notnull"`
+        Role         UserRole
+        Email        string
+        PasswordHash string
         OtpSecret    string
         IsOtpSetup   bool
         Status       UserStatus