Add string id for project and reduce usage of numeric ids in general

User: username must be unique, use as primary key and drop id.

15 files changed, 119 insertions, 230 deletions

diff --git a/server/.sqlx/query-0c60083eadb7c144198ce6586ce5abe50b321b85febfc5a72157990753e404e2.json b/server/.sqlx/query-0c60083eadb7c144198ce6586ce5abe50b321b85febfc5a72157990753e404e2.json
deleted file mode 100644
index 6018cd3..0000000
--- a/server/.sqlx/query-0c60083eadb7c144198ce6586ce5abe50b321b85febfc5a72157990753e404e2.json
+++ /dev/null
@@ -1,69 +0,0 @@
-{
-  "db_name": "MySQL",
-  "query": "SELECT id,username,name,dn,review_users.role AS role FROM users JOIN review_users ON review_users.user=id WHERE review_users.review=? ORDER BY role,username,id",
-  "describe": {
-    "columns": [
-      {
-        "ordinal": 0,
-        "name": "id",
-        "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
-        }
-      },
-      {
-        "ordinal": 1,
-        "name": "username",
-        "type_info": {
-          "type": "VarString",
-          "flags": "NOT_NULL | UNIQUE_KEY | NO_DEFAULT_VALUE",
-          "char_set": 224,
-          "max_size": 1024
-        }
-      },
-      {
-        "ordinal": 2,
-        "name": "name",
-        "type_info": {
-          "type": "VarString",
-          "flags": "NOT_NULL",
-          "char_set": 224,
-          "max_size": 4096
-        }
-      },
-      {
-        "ordinal": 3,
-        "name": "dn",
-        "type_info": {
-          "type": "VarString",
-          "flags": "",
-          "char_set": 224,
-          "max_size": 1024
-        }
-      },
-      {
-        "ordinal": 4,
-        "name": "role",
-        "type_info": {
-          "type": "Tiny",
-          "flags": "NOT_NULL | UNSIGNED",
-          "char_set": 63,
-          "max_size": 3
-        }
-      }
-    ],
-    "parameters": {
-      "Right": 1
-    },
-    "nullable": [
-      false,
-      false,
-      false,
-      true,
-      false
-    ]
-  },
-  "hash": "0c60083eadb7c144198ce6586ce5abe50b321b85febfc5a72157990753e404e2"
-}
diff --git a/server/.sqlx/query-323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589.json b/server/.sqlx/query-1b2b0395773a2207fd7c75ae14151764df6120375321d88455a1ad09fb0abe66.json
index edc104b..c332e8a 100644
--- a/server/.sqlx/query-323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589.json
+++ b/server/.sqlx/query-1b2b0395773a2207fd7c75ae14151764df6120375321d88455a1ad09fb0abe66.json
@@ -1,30 +1,20 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT id, username, name, dn, default_role, maintainer FROM users JOIN project_users ON project_users.user=users.id WHERE project_users.project=?",
+  "query": "SELECT id, name, dn, default_role, maintainer FROM users JOIN project_users ON project_users.user=users.id WHERE project_users.project=?",
   "describe": {
     "columns": [
       {
         "ordinal": 0,
         "name": "id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
-        }
-      },
-      {
-        "ordinal": 1,
-        "name": "username",
-        "type_info": {
           "type": "VarString",
-          "flags": "NOT_NULL | UNIQUE_KEY | NO_DEFAULT_VALUE",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
           "char_set": 224,
-          "max_size": 1024
+          "max_size": 512
         }
       },
       {
-        "ordinal": 2,
+        "ordinal": 1,
         "name": "name",
         "type_info": {
           "type": "VarString",
@@ -34,7 +24,7 @@
         }
       },
       {
-        "ordinal": 3,
+        "ordinal": 2,
         "name": "dn",
         "type_info": {
           "type": "VarString",
@@ -44,7 +34,7 @@
         }
       },
       {
-        "ordinal": 4,
+        "ordinal": 3,
         "name": "default_role",
         "type_info": {
           "type": "Tiny",
@@ -54,7 +44,7 @@
         }
       },
       {
-        "ordinal": 5,
+        "ordinal": 4,
         "name": "maintainer",
         "type_info": {
           "type": "Tiny",
@@ -70,11 +60,10 @@
     "nullable": [
       false,
       false,
-      false,
       true,
       false,
       false
     ]
   },
-  "hash": "323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589"
+  "hash": "1b2b0395773a2207fd7c75ae14151764df6120375321d88455a1ad09fb0abe66"
 }
diff --git a/server/.sqlx/query-21e286004af94c0a0e26a4fe494b4a858fc02e4d63cec67231f837748a9f9702.json b/server/.sqlx/query-21e286004af94c0a0e26a4fe494b4a858fc02e4d63cec67231f837748a9f9702.json
deleted file mode 100644
index 4abfa06..0000000
--- a/server/.sqlx/query-21e286004af94c0a0e26a4fe494b4a858fc02e4d63cec67231f837748a9f9702.json
+++ /dev/null
@@ -1,12 +0,0 @@
-{
-  "db_name": "MySQL",
-  "query": "INSERT INTO projects (title, description, remote, main_branch) VALUES (?, ?, ?, ?)",
-  "describe": {
-    "columns": [],
-    "parameters": {
-      "Right": 4
-    },
-    "nullable": []
-  },
-  "hash": "21e286004af94c0a0e26a4fe494b4a858fc02e4d63cec67231f837748a9f9702"
-}
diff --git a/server/.sqlx/query-d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053.json b/server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json
index 7985a71..e277262 100644
--- a/server/.sqlx/query-d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053.json
+++ b/server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json
@@ -1,6 +1,6 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT reviews.id AS id,project,title,description,state,progress,branch,archived,users.id AS user_id,users.username AS username,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE reviews.id=?",
+  "query": "SELECT reviews.id AS id,title,description,state,progress,branch,archived,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? AND branch=?",
   "describe": {
     "columns": [
       {
@@ -15,16 +15,6 @@
       },
       {
         "ordinal": 1,
-        "name": "project",
-        "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | MULTIPLE_KEY | UNSIGNED | NO_DEFAULT_VALUE",
-          "char_set": 63,
-          "max_size": 20
-        }
-      },
-      {
-        "ordinal": 2,
         "name": "title",
         "type_info": {
           "type": "VarString",
@@ -34,7 +24,7 @@
         }
       },
       {
-        "ordinal": 3,
+        "ordinal": 2,
         "name": "description",
         "type_info": {
           "type": "Blob",
@@ -44,7 +34,7 @@
         }
       },
       {
-        "ordinal": 4,
+        "ordinal": 3,
         "name": "state",
         "type_info": {
           "type": "Tiny",
@@ -54,7 +44,7 @@
         }
       },
       {
-        "ordinal": 5,
+        "ordinal": 4,
         "name": "progress",
         "type_info": {
           "type": "Float",
@@ -64,7 +54,7 @@
         }
       },
       {
-        "ordinal": 6,
+        "ordinal": 5,
         "name": "branch",
         "type_info": {
           "type": "VarString",
@@ -74,7 +64,7 @@
         }
       },
       {
-        "ordinal": 7,
+        "ordinal": 6,
         "name": "archived",
         "type_info": {
           "type": "Tiny",
@@ -84,27 +74,17 @@
         }
       },
       {
-        "ordinal": 8,
+        "ordinal": 7,
         "name": "user_id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
-        }
-      },
-      {
-        "ordinal": 9,
-        "name": "username",
-        "type_info": {
           "type": "VarString",
-          "flags": "NOT_NULL | UNIQUE_KEY | NO_DEFAULT_VALUE",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
           "char_set": 224,
-          "max_size": 1024
+          "max_size": 512
         }
       },
       {
-        "ordinal": 10,
+        "ordinal": 8,
         "name": "name",
         "type_info": {
           "type": "VarString",
@@ -114,7 +94,7 @@
         }
       },
       {
-        "ordinal": 11,
+        "ordinal": 9,
         "name": "user_dn",
         "type_info": {
           "type": "VarString",
@@ -125,7 +105,7 @@
       }
     ],
     "parameters": {
-      "Right": 1
+      "Right": 2
     },
     "nullable": [
       false,
@@ -137,10 +117,8 @@
       false,
       false,
       false,
-      false,
-      false,
       true
     ]
   },
-  "hash": "d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053"
+  "hash": "3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67"
 }
diff --git a/server/.sqlx/query-c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c.json b/server/.sqlx/query-4314c7a7be9e055f82ede8e091cb376fe0d9e580993d47b61c8d77af0fd1ef64.json
index 7a582af..c6277c7 100644
--- a/server/.sqlx/query-c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c.json
+++ b/server/.sqlx/query-4314c7a7be9e055f82ede8e091cb376fe0d9e580993d47b61c8d77af0fd1ef64.json
@@ -1,30 +1,20 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT id,username,name,dn FROM users ORDER BY username LIMIT ? OFFSET ?",
+  "query": "SELECT id,name,dn,review_users.role AS role FROM users JOIN review_users ON review_users.user=id WHERE review_users.review=? ORDER BY role,id",
   "describe": {
     "columns": [
       {
         "ordinal": 0,
         "name": "id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
-        }
-      },
-      {
-        "ordinal": 1,
-        "name": "username",
-        "type_info": {
           "type": "VarString",
-          "flags": "NOT_NULL | UNIQUE_KEY | NO_DEFAULT_VALUE",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
           "char_set": 224,
-          "max_size": 1024
+          "max_size": 512
         }
       },
       {
-        "ordinal": 2,
+        "ordinal": 1,
         "name": "name",
         "type_info": {
           "type": "VarString",
@@ -34,7 +24,7 @@
         }
       },
       {
-        "ordinal": 3,
+        "ordinal": 2,
         "name": "dn",
         "type_info": {
           "type": "VarString",
@@ -42,17 +32,27 @@
           "char_set": 224,
           "max_size": 1024
         }
+      },
+      {
+        "ordinal": 3,
+        "name": "role",
+        "type_info": {
+          "type": "Tiny",
+          "flags": "NOT_NULL | UNSIGNED",
+          "char_set": 63,
+          "max_size": 3
+        }
       }
     ],
     "parameters": {
-      "Right": 2
+      "Right": 1
     },
     "nullable": [
       false,
       false,
-      false,
-      true
+      true,
+      false
     ]
   },
-  "hash": "c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c"
+  "hash": "4314c7a7be9e055f82ede8e091cb376fe0d9e580993d47b61c8d77af0fd1ef64"
 }
diff --git a/server/.sqlx/query-498432f84ea2c01707cc92a490ca116a3d45c7da646182e8e5153ac5b31c8d6f.json b/server/.sqlx/query-498432f84ea2c01707cc92a490ca116a3d45c7da646182e8e5153ac5b31c8d6f.json
index b10c944..5215f19 100644
--- a/server/.sqlx/query-498432f84ea2c01707cc92a490ca116a3d45c7da646182e8e5153ac5b31c8d6f.json
+++ b/server/.sqlx/query-498432f84ea2c01707cc92a490ca116a3d45c7da646182e8e5153ac5b31c8d6f.json
@@ -7,10 +7,10 @@
         "ordinal": 0,
         "name": "count",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
         }
       }
     ],
diff --git a/server/.sqlx/query-51f58915888d2523f6de00e206ea36137a50e7b8871751c631edb738db2cd197.json b/server/.sqlx/query-51f58915888d2523f6de00e206ea36137a50e7b8871751c631edb738db2cd197.json
index d6650fd..942c054 100644
--- a/server/.sqlx/query-51f58915888d2523f6de00e206ea36137a50e7b8871751c631edb738db2cd197.json
+++ b/server/.sqlx/query-51f58915888d2523f6de00e206ea36137a50e7b8871751c631edb738db2cd197.json
@@ -7,10 +7,10 @@
         "ordinal": 0,
         "name": "id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
         }
       },
       {
diff --git a/server/.sqlx/query-bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c.json b/server/.sqlx/query-5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726.json
index 61a445f..9d60686 100644
--- a/server/.sqlx/query-bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c.json
+++ b/server/.sqlx/query-5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726.json
@@ -1,16 +1,16 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT id,dn FROM users WHERE username=?",
+  "query": "SELECT id,dn FROM users ORDER BY id",
   "describe": {
     "columns": [
       {
         "ordinal": 0,
         "name": "id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
         }
       },
       {
@@ -25,12 +25,12 @@
       }
     ],
     "parameters": {
-      "Right": 1
+      "Right": 0
     },
     "nullable": [
       false,
       true
     ]
   },
-  "hash": "bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c"
+  "hash": "5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726"
 }
diff --git a/server/.sqlx/query-5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4.json b/server/.sqlx/query-91e21f94ae4a7a6ff3234ded1c4556dc42ac9158578112c01d7e5f5428eadac4.json
index c11e1fb..d3038a4 100644
--- a/server/.sqlx/query-5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4.json
+++ b/server/.sqlx/query-91e21f94ae4a7a6ff3234ded1c4556dc42ac9158578112c01d7e5f5428eadac4.json
@@ -1,26 +1,26 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT id,username,dn FROM users ORDER BY username",
+  "query": "SELECT id,name,dn FROM users ORDER BY id LIMIT ? OFFSET ?",
   "describe": {
     "columns": [
       {
         "ordinal": 0,
         "name": "id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
         }
       },
       {
         "ordinal": 1,
-        "name": "username",
+        "name": "name",
         "type_info": {
           "type": "VarString",
-          "flags": "NOT_NULL | UNIQUE_KEY | NO_DEFAULT_VALUE",
+          "flags": "NOT_NULL",
           "char_set": 224,
-          "max_size": 1024
+          "max_size": 4096
         }
       },
       {
@@ -35,7 +35,7 @@
       }
     ],
     "parameters": {
-      "Right": 0
+      "Right": 2
     },
     "nullable": [
       false,
@@ -43,5 +43,5 @@
       true
     ]
   },
-  "hash": "5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4"
+  "hash": "91e21f94ae4a7a6ff3234ded1c4556dc42ac9158578112c01d7e5f5428eadac4"
 }
diff --git a/server/.sqlx/query-940807355ceddb03b2b69306d30b081c4855858cd710399f9328075e885704fd.json b/server/.sqlx/query-940807355ceddb03b2b69306d30b081c4855858cd710399f9328075e885704fd.json
deleted file mode 100644
index 412ba1f..0000000
--- a/server/.sqlx/query-940807355ceddb03b2b69306d30b081c4855858cd710399f9328075e885704fd.json
+++ /dev/null
@@ -1,12 +0,0 @@
-{
-  "db_name": "MySQL",
-  "query": "INSERT IGNORE INTO users (username,dn) VALUES (?,?), (?,?)",
-  "describe": {
-    "columns": [],
-    "parameters": {
-      "Right": 4
-    },
-    "nullable": []
-  },
-  "hash": "940807355ceddb03b2b69306d30b081c4855858cd710399f9328075e885704fd"
-}
diff --git a/server/.sqlx/query-e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb.json b/server/.sqlx/query-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json
index 930ff79..22a6d40 100644
--- a/server/.sqlx/query-e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb.json
+++ b/server/.sqlx/query-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json
@@ -1,6 +1,6 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT reviews.id AS id,title,state,progress,users.id AS user_id,users.username AS username,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? ORDER BY id DESC LIMIT ? OFFSET ?",
+  "query": "SELECT reviews.id AS id,title,state,progress,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? ORDER BY id DESC LIMIT ? OFFSET ?",
   "describe": {
     "columns": [
       {
@@ -47,24 +47,14 @@
         "ordinal": 4,
         "name": "user_id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
-        }
-      },
-      {
-        "ordinal": 5,
-        "name": "username",
-        "type_info": {
           "type": "VarString",
-          "flags": "NOT_NULL | UNIQUE_KEY | NO_DEFAULT_VALUE",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
           "char_set": 224,
-          "max_size": 1024
+          "max_size": 512
         }
       },
       {
-        "ordinal": 6,
+        "ordinal": 5,
         "name": "name",
         "type_info": {
           "type": "VarString",
@@ -74,7 +64,7 @@
         }
       },
       {
-        "ordinal": 7,
+        "ordinal": 6,
         "name": "user_dn",
         "type_info": {
           "type": "VarString",
@@ -94,9 +84,8 @@
       false,
       false,
       false,
-      false,
       true
     ]
   },
-  "hash": "e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb"
+  "hash": "956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831"
 }
diff --git a/server/.sqlx/query-8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5.json b/server/.sqlx/query-9a7d3f823cc6d5978a77ae4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce.json
index 3c25e9a..47eca1c 100644
--- a/server/.sqlx/query-8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5.json
+++ b/server/.sqlx/query-9a7d3f823cc6d5978a77ae4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce.json
@@ -1,30 +1,20 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT id,username,name,dn,project_users.default_role AS role FROM users JOIN project_users ON project_users.user=id WHERE project_users.project=? ORDER BY role,username,id",
+  "query": "SELECT id,name,dn,project_users.default_role AS role FROM users JOIN project_users ON project_users.user=id WHERE project_users.project=? ORDER BY role,id",
   "describe": {
     "columns": [
       {
         "ordinal": 0,
         "name": "id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
-        }
-      },
-      {
-        "ordinal": 1,
-        "name": "username",
-        "type_info": {
           "type": "VarString",
-          "flags": "NOT_NULL | UNIQUE_KEY | NO_DEFAULT_VALUE",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
           "char_set": 224,
-          "max_size": 1024
+          "max_size": 512
         }
       },
       {
-        "ordinal": 2,
+        "ordinal": 1,
         "name": "name",
         "type_info": {
           "type": "VarString",
@@ -34,7 +24,7 @@
         }
       },
       {
-        "ordinal": 3,
+        "ordinal": 2,
         "name": "dn",
         "type_info": {
           "type": "VarString",
@@ -44,7 +34,7 @@
         }
       },
       {
-        "ordinal": 4,
+        "ordinal": 3,
         "name": "role",
         "type_info": {
           "type": "Tiny",
@@ -60,10 +50,9 @@
     "nullable": [
       false,
       false,
-      false,
       true,
       false
     ]
   },
-  "hash": "8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5"
+  "hash": "9a7d3f823cc6d5978a77ae4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce"
 }
diff --git a/server/.sqlx/query-a3929af470685bfea9b913dd94f4749fcf1f80cc0389cf3f84f0864a4bfece6f.json b/server/.sqlx/query-a3929af470685bfea9b913dd94f4749fcf1f80cc0389cf3f84f0864a4bfece6f.json
new file mode 100644
index 0000000..6f761ee
--- /dev/null
+++ b/server/.sqlx/query-a3929af470685bfea9b913dd94f4749fcf1f80cc0389cf3f84f0864a4bfece6f.json
@@ -0,0 +1,12 @@
+{
+  "db_name": "MySQL",
+  "query": "INSERT INTO projects (id, title, description, remote, main_branch) VALUES (?, ?, ?, ?, ?)",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Right": 5
+    },
+    "nullable": []
+  },
+  "hash": "a3929af470685bfea9b913dd94f4749fcf1f80cc0389cf3f84f0864a4bfece6f"
+}
diff --git a/server/.sqlx/query-b93e2879cf7334469d3ceb1a49dbf5975b623da8c99241f30e8c042849d7fd8e.json b/server/.sqlx/query-b93e2879cf7334469d3ceb1a49dbf5975b623da8c99241f30e8c042849d7fd8e.json
index 93fa0bd..158583c 100644
--- a/server/.sqlx/query-b93e2879cf7334469d3ceb1a49dbf5975b623da8c99241f30e8c042849d7fd8e.json
+++ b/server/.sqlx/query-b93e2879cf7334469d3ceb1a49dbf5975b623da8c99241f30e8c042849d7fd8e.json
@@ -7,10 +7,10 @@
         "ordinal": 0,
         "name": "id",
         "type_info": {
-          "type": "LongLong",
-          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
-          "char_set": 63,
-          "max_size": 20
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
         }
       },
       {
diff --git a/server/.sqlx/query-d1934a970a5bef4df382ea119c22ff28262a3762add33f8f96f6838312b6b43f.json b/server/.sqlx/query-d1934a970a5bef4df382ea119c22ff28262a3762add33f8f96f6838312b6b43f.json
new file mode 100644
index 0000000..26b2d60
--- /dev/null
+++ b/server/.sqlx/query-d1934a970a5bef4df382ea119c22ff28262a3762add33f8f96f6838312b6b43f.json
@@ -0,0 +1,25 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT dn FROM users WHERE id=?",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "dn",
+        "type_info": {
+          "type": "VarString",
+          "flags": "",
+          "char_set": 224,
+          "max_size": 1024
+        }
+      }
+    ],
+    "parameters": {
+      "Right": 1
+    },
+    "nullable": [
+      true
+    ]
+  },
+  "hash": "d1934a970a5bef4df382ea119c22ff28262a3762add33f8f96f6838312b6b43f"
+}