From 3747204267e8b75bc77d6c0962b67bbe018dad15 Mon Sep 17 00:00:00 2001 From: Joel Klinghed Date: Thu, 9 Jan 2025 21:20:17 +0100 Subject: 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. --- ...586ce5abe50b321b85febfc5a72157990753e404e2.json | 69 ---------- ...ae14151764df6120375321d88455a1ad09fb0abe66.json | 69 ++++++++++ ...fe494b4a858fc02e4d63cec67231f837748a9f9702.json | 12 -- ...56f7588486032bb85b883832366aae944d1e80e589.json | 80 ----------- ...360f92af157f36f3d92a667c0adc06c100cc495c67.json | 124 +++++++++++++++++ ...e091cb376fe0d9e580993d47b61c8d77af0fd1ef64.json | 58 ++++++++ ...a490ca116a3d45c7da646182e8e5153ac5b31c8d6f.json | 8 +- ...e206ea36137a50e7b8871751c631edb738db2cd197.json | 8 +- ...11df2f01e4e21c83d0fa03b917e5792b8753f32726.json | 36 +++++ ...78ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4.json | 47 ------- ...d710a924d3552e8aceb50d37d969c83fd7ff3920c5.json | 69 ---------- ...ed1c4556dc42ac9158578112c01d7e5f5428eadac4.json | 47 +++++++ ...06d30b081c4855858cd710399f9328075e885704fd.json | 12 -- ...e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json | 91 +++++++++++++ ...4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce.json | 58 ++++++++ ...dd94f4749fcf1f80cc0389cf3f84f0864a4bfece6f.json | 12 ++ ...1a49dbf5975b623da8c99241f30e8c042849d7fd8e.json | 8 +- ...ac9cce4b4592616cad37afdb2b1e40bd38cbf2190c.json | 36 ----- ...9ce115a989097782d7f86a1fbfe7687cafb33e040c.json | 58 -------- ...119c22ff28262a3762add33f8f96f6838312b6b43f.json | 25 ++++ ...56951ac0b61416fabb63da0376ba64c331f1867053.json | 146 --------------------- ...fd8aa380e32ed83aee297d7d84b469f4fd068cedeb.json | 102 -------------- 22 files changed, 532 insertions(+), 643 deletions(-) delete mode 100644 server/.sqlx/query-0c60083eadb7c144198ce6586ce5abe50b321b85febfc5a72157990753e404e2.json create mode 100644 server/.sqlx/query-1b2b0395773a2207fd7c75ae14151764df6120375321d88455a1ad09fb0abe66.json delete mode 100644 server/.sqlx/query-21e286004af94c0a0e26a4fe494b4a858fc02e4d63cec67231f837748a9f9702.json delete mode 100644 server/.sqlx/query-323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589.json create mode 100644 server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json create mode 100644 server/.sqlx/query-4314c7a7be9e055f82ede8e091cb376fe0d9e580993d47b61c8d77af0fd1ef64.json create mode 100644 server/.sqlx/query-5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726.json delete mode 100644 server/.sqlx/query-5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4.json delete mode 100644 server/.sqlx/query-8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5.json create mode 100644 server/.sqlx/query-91e21f94ae4a7a6ff3234ded1c4556dc42ac9158578112c01d7e5f5428eadac4.json delete mode 100644 server/.sqlx/query-940807355ceddb03b2b69306d30b081c4855858cd710399f9328075e885704fd.json create mode 100644 server/.sqlx/query-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json create mode 100644 server/.sqlx/query-9a7d3f823cc6d5978a77ae4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce.json create mode 100644 server/.sqlx/query-a3929af470685bfea9b913dd94f4749fcf1f80cc0389cf3f84f0864a4bfece6f.json delete mode 100644 server/.sqlx/query-bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c.json delete mode 100644 server/.sqlx/query-c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c.json create mode 100644 server/.sqlx/query-d1934a970a5bef4df382ea119c22ff28262a3762add33f8f96f6838312b6b43f.json delete mode 100644 server/.sqlx/query-d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053.json delete mode 100644 server/.sqlx/query-e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb.json (limited to 'server/.sqlx') 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-1b2b0395773a2207fd7c75ae14151764df6120375321d88455a1ad09fb0abe66.json b/server/.sqlx/query-1b2b0395773a2207fd7c75ae14151764df6120375321d88455a1ad09fb0abe66.json new file mode 100644 index 0000000..c332e8a --- /dev/null +++ b/server/.sqlx/query-1b2b0395773a2207fd7c75ae14151764df6120375321d88455a1ad09fb0abe66.json @@ -0,0 +1,69 @@ +{ + "db_name": "MySQL", + "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": "VarString", + "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 512 + } + }, + { + "ordinal": 1, + "name": "name", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 2, + "name": "dn", + "type_info": { + "type": "VarString", + "flags": "", + "char_set": 224, + "max_size": 1024 + } + }, + { + "ordinal": 3, + "name": "default_role", + "type_info": { + "type": "Tiny", + "flags": "NOT_NULL | UNSIGNED | NO_DEFAULT_VALUE", + "char_set": 63, + "max_size": 3 + } + }, + { + "ordinal": 4, + "name": "maintainer", + "type_info": { + "type": "Tiny", + "flags": "NOT_NULL", + "char_set": 63, + "max_size": 1 + } + } + ], + "parameters": { + "Right": 1 + }, + "nullable": [ + false, + false, + true, + false, + false + ] + }, + "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-323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589.json b/server/.sqlx/query-323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589.json deleted file mode 100644 index edc104b..0000000 --- a/server/.sqlx/query-323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589.json +++ /dev/null @@ -1,80 +0,0 @@ -{ - "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=?", - "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": "default_role", - "type_info": { - "type": "Tiny", - "flags": "NOT_NULL | UNSIGNED | NO_DEFAULT_VALUE", - "char_set": 63, - "max_size": 3 - } - }, - { - "ordinal": 5, - "name": "maintainer", - "type_info": { - "type": "Tiny", - "flags": "NOT_NULL", - "char_set": 63, - "max_size": 1 - } - } - ], - "parameters": { - "Right": 1 - }, - "nullable": [ - false, - false, - false, - true, - false, - false - ] - }, - "hash": "323b0d90d6c3bccbf7708556f7588486032bb85b883832366aae944d1e80e589" -} diff --git a/server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json b/server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json new file mode 100644 index 0000000..e277262 --- /dev/null +++ b/server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json @@ -0,0 +1,124 @@ +{ + "db_name": "MySQL", + "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": [ + { + "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": "title", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 2, + "name": "description", + "type_info": { + "type": "Blob", + "flags": "NOT_NULL | BLOB", + "char_set": 224, + "max_size": 67108860 + } + }, + { + "ordinal": 3, + "name": "state", + "type_info": { + "type": "Tiny", + "flags": "NOT_NULL | UNSIGNED", + "char_set": 63, + "max_size": 3 + } + }, + { + "ordinal": 4, + "name": "progress", + "type_info": { + "type": "Float", + "flags": "NOT_NULL", + "char_set": 63, + "max_size": 12 + } + }, + { + "ordinal": 5, + "name": "branch", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 6, + "name": "archived", + "type_info": { + "type": "Tiny", + "flags": "NOT_NULL", + "char_set": 63, + "max_size": 1 + } + }, + { + "ordinal": 7, + "name": "user_id", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 512 + } + }, + { + "ordinal": 8, + "name": "name", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 9, + "name": "user_dn", + "type_info": { + "type": "VarString", + "flags": "", + "char_set": 224, + "max_size": 1024 + } + } + ], + "parameters": { + "Right": 2 + }, + "nullable": [ + false, + false, + false, + false, + false, + false, + false, + false, + false, + true + ] + }, + "hash": "3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67" +} diff --git a/server/.sqlx/query-4314c7a7be9e055f82ede8e091cb376fe0d9e580993d47b61c8d77af0fd1ef64.json b/server/.sqlx/query-4314c7a7be9e055f82ede8e091cb376fe0d9e580993d47b61c8d77af0fd1ef64.json new file mode 100644 index 0000000..c6277c7 --- /dev/null +++ b/server/.sqlx/query-4314c7a7be9e055f82ede8e091cb376fe0d9e580993d47b61c8d77af0fd1ef64.json @@ -0,0 +1,58 @@ +{ + "db_name": "MySQL", + "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": "VarString", + "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 512 + } + }, + { + "ordinal": 1, + "name": "name", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 2, + "name": "dn", + "type_info": { + "type": "VarString", + "flags": "", + "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": 1 + }, + "nullable": [ + false, + false, + true, + false + ] + }, + "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-5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726.json b/server/.sqlx/query-5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726.json new file mode 100644 index 0000000..9d60686 --- /dev/null +++ b/server/.sqlx/query-5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726.json @@ -0,0 +1,36 @@ +{ + "db_name": "MySQL", + "query": "SELECT id,dn FROM users ORDER BY id", + "describe": { + "columns": [ + { + "ordinal": 0, + "name": "id", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 512 + } + }, + { + "ordinal": 1, + "name": "dn", + "type_info": { + "type": "VarString", + "flags": "", + "char_set": 224, + "max_size": 1024 + } + } + ], + "parameters": { + "Right": 0 + }, + "nullable": [ + false, + true + ] + }, + "hash": "5d34251e2084507d7bc10c11df2f01e4e21c83d0fa03b917e5792b8753f32726" +} diff --git a/server/.sqlx/query-5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4.json b/server/.sqlx/query-5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4.json deleted file mode 100644 index c11e1fb..0000000 --- a/server/.sqlx/query-5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4.json +++ /dev/null @@ -1,47 +0,0 @@ -{ - "db_name": "MySQL", - "query": "SELECT id,username,dn FROM users ORDER BY username", - "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": "dn", - "type_info": { - "type": "VarString", - "flags": "", - "char_set": 224, - "max_size": 1024 - } - } - ], - "parameters": { - "Right": 0 - }, - "nullable": [ - false, - false, - true - ] - }, - "hash": "5ebc001294b03e0eadf76878ff3e95fc42a1ee1bec8f145d4a5ed4f94d474fa4" -} diff --git a/server/.sqlx/query-8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5.json b/server/.sqlx/query-8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5.json deleted file mode 100644 index 3c25e9a..0000000 --- a/server/.sqlx/query-8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5.json +++ /dev/null @@ -1,69 +0,0 @@ -{ - "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", - "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 | NO_DEFAULT_VALUE", - "char_set": 63, - "max_size": 3 - } - } - ], - "parameters": { - "Right": 1 - }, - "nullable": [ - false, - false, - false, - true, - false - ] - }, - "hash": "8537211b442452b1e5e0ddd710a924d3552e8aceb50d37d969c83fd7ff3920c5" -} diff --git a/server/.sqlx/query-91e21f94ae4a7a6ff3234ded1c4556dc42ac9158578112c01d7e5f5428eadac4.json b/server/.sqlx/query-91e21f94ae4a7a6ff3234ded1c4556dc42ac9158578112c01d7e5f5428eadac4.json new file mode 100644 index 0000000..d3038a4 --- /dev/null +++ b/server/.sqlx/query-91e21f94ae4a7a6ff3234ded1c4556dc42ac9158578112c01d7e5f5428eadac4.json @@ -0,0 +1,47 @@ +{ + "db_name": "MySQL", + "query": "SELECT id,name,dn FROM users ORDER BY id LIMIT ? OFFSET ?", + "describe": { + "columns": [ + { + "ordinal": 0, + "name": "id", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 512 + } + }, + { + "ordinal": 1, + "name": "name", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 2, + "name": "dn", + "type_info": { + "type": "VarString", + "flags": "", + "char_set": 224, + "max_size": 1024 + } + } + ], + "parameters": { + "Right": 2 + }, + "nullable": [ + false, + false, + true + ] + }, + "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-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json b/server/.sqlx/query-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json new file mode 100644 index 0000000..22a6d40 --- /dev/null +++ b/server/.sqlx/query-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json @@ -0,0 +1,91 @@ +{ + "db_name": "MySQL", + "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": [ + { + "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": "title", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 2, + "name": "state", + "type_info": { + "type": "Tiny", + "flags": "NOT_NULL | UNSIGNED", + "char_set": 63, + "max_size": 3 + } + }, + { + "ordinal": 3, + "name": "progress", + "type_info": { + "type": "Float", + "flags": "NOT_NULL", + "char_set": 63, + "max_size": 12 + } + }, + { + "ordinal": 4, + "name": "user_id", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 512 + } + }, + { + "ordinal": 5, + "name": "name", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 6, + "name": "user_dn", + "type_info": { + "type": "VarString", + "flags": "", + "char_set": 224, + "max_size": 1024 + } + } + ], + "parameters": { + "Right": 3 + }, + "nullable": [ + false, + false, + false, + false, + false, + false, + true + ] + }, + "hash": "956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831" +} diff --git a/server/.sqlx/query-9a7d3f823cc6d5978a77ae4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce.json b/server/.sqlx/query-9a7d3f823cc6d5978a77ae4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce.json new file mode 100644 index 0000000..47eca1c --- /dev/null +++ b/server/.sqlx/query-9a7d3f823cc6d5978a77ae4bfff82ab8dccd2e48936f8735d5bf6ec79a38ecce.json @@ -0,0 +1,58 @@ +{ + "db_name": "MySQL", + "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": "VarString", + "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE", + "char_set": 224, + "max_size": 512 + } + }, + { + "ordinal": 1, + "name": "name", + "type_info": { + "type": "VarString", + "flags": "NOT_NULL", + "char_set": 224, + "max_size": 4096 + } + }, + { + "ordinal": 2, + "name": "dn", + "type_info": { + "type": "VarString", + "flags": "", + "char_set": 224, + "max_size": 1024 + } + }, + { + "ordinal": 3, + "name": "role", + "type_info": { + "type": "Tiny", + "flags": "NOT_NULL | UNSIGNED | NO_DEFAULT_VALUE", + "char_set": 63, + "max_size": 3 + } + } + ], + "parameters": { + "Right": 1 + }, + "nullable": [ + false, + false, + true, + false + ] + }, + "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-bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c.json b/server/.sqlx/query-bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c.json deleted file mode 100644 index 61a445f..0000000 --- a/server/.sqlx/query-bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c.json +++ /dev/null @@ -1,36 +0,0 @@ -{ - "db_name": "MySQL", - "query": "SELECT id,dn FROM users WHERE username=?", - "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": "dn", - "type_info": { - "type": "VarString", - "flags": "", - "char_set": 224, - "max_size": 1024 - } - } - ], - "parameters": { - "Right": 1 - }, - "nullable": [ - false, - true - ] - }, - "hash": "bfbd002137bcf942b9911eac9cce4b4592616cad37afdb2b1e40bd38cbf2190c" -} diff --git a/server/.sqlx/query-c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c.json b/server/.sqlx/query-c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c.json deleted file mode 100644 index 7a582af..0000000 --- a/server/.sqlx/query-c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c.json +++ /dev/null @@ -1,58 +0,0 @@ -{ - "db_name": "MySQL", - "query": "SELECT id,username,name,dn FROM users ORDER BY username 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 - } - }, - { - "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 - } - } - ], - "parameters": { - "Right": 2 - }, - "nullable": [ - false, - false, - false, - true - ] - }, - "hash": "c75ed143fca19b2d827d589ce115a989097782d7f86a1fbfe7687cafb33e040c" -} 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" +} diff --git a/server/.sqlx/query-d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053.json b/server/.sqlx/query-d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053.json deleted file mode 100644 index 7985a71..0000000 --- a/server/.sqlx/query-d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053.json +++ /dev/null @@ -1,146 +0,0 @@ -{ - "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=?", - "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": "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", - "flags": "NOT_NULL | NO_DEFAULT_VALUE", - "char_set": 224, - "max_size": 4096 - } - }, - { - "ordinal": 3, - "name": "description", - "type_info": { - "type": "Blob", - "flags": "NOT_NULL | BLOB", - "char_set": 224, - "max_size": 67108860 - } - }, - { - "ordinal": 4, - "name": "state", - "type_info": { - "type": "Tiny", - "flags": "NOT_NULL | UNSIGNED", - "char_set": 63, - "max_size": 3 - } - }, - { - "ordinal": 5, - "name": "progress", - "type_info": { - "type": "Float", - "flags": "NOT_NULL", - "char_set": 63, - "max_size": 12 - } - }, - { - "ordinal": 6, - "name": "branch", - "type_info": { - "type": "VarString", - "flags": "NOT_NULL | NO_DEFAULT_VALUE", - "char_set": 224, - "max_size": 4096 - } - }, - { - "ordinal": 7, - "name": "archived", - "type_info": { - "type": "Tiny", - "flags": "NOT_NULL", - "char_set": 63, - "max_size": 1 - } - }, - { - "ordinal": 8, - "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", - "char_set": 224, - "max_size": 1024 - } - }, - { - "ordinal": 10, - "name": "name", - "type_info": { - "type": "VarString", - "flags": "NOT_NULL", - "char_set": 224, - "max_size": 4096 - } - }, - { - "ordinal": 11, - "name": "user_dn", - "type_info": { - "type": "VarString", - "flags": "", - "char_set": 224, - "max_size": 1024 - } - } - ], - "parameters": { - "Right": 1 - }, - "nullable": [ - false, - false, - false, - false, - false, - false, - false, - false, - false, - false, - false, - true - ] - }, - "hash": "d60078d46c209e113e078856951ac0b61416fabb63da0376ba64c331f1867053" -} diff --git a/server/.sqlx/query-e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb.json b/server/.sqlx/query-e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb.json deleted file mode 100644 index 930ff79..0000000 --- a/server/.sqlx/query-e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb.json +++ /dev/null @@ -1,102 +0,0 @@ -{ - "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 ?", - "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": "title", - "type_info": { - "type": "VarString", - "flags": "NOT_NULL | NO_DEFAULT_VALUE", - "char_set": 224, - "max_size": 4096 - } - }, - { - "ordinal": 2, - "name": "state", - "type_info": { - "type": "Tiny", - "flags": "NOT_NULL | UNSIGNED", - "char_set": 63, - "max_size": 3 - } - }, - { - "ordinal": 3, - "name": "progress", - "type_info": { - "type": "Float", - "flags": "NOT_NULL", - "char_set": 63, - "max_size": 12 - } - }, - { - "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", - "char_set": 224, - "max_size": 1024 - } - }, - { - "ordinal": 6, - "name": "name", - "type_info": { - "type": "VarString", - "flags": "NOT_NULL", - "char_set": 224, - "max_size": 4096 - } - }, - { - "ordinal": 7, - "name": "user_dn", - "type_info": { - "type": "VarString", - "flags": "", - "char_set": 224, - "max_size": 1024 - } - } - ], - "parameters": { - "Right": 3 - }, - "nullable": [ - false, - false, - false, - false, - false, - false, - false, - true - ] - }, - "hash": "e8f3b6fd1666b9a317ee98fd8aa380e32ed83aee297d7d84b469f4fd068cedeb" -} -- cgit v1.2.3-70-g09d2