Updated Bio, Image, AvatarURL from text type to nvarchar(255) type

package-lock.json

@@ -431,43 +431,23 @@
       }
     },
     "node_modules/body-parser": {
-      "version": "2.2.1",
+      "version": "2.2.0",
-      "resolved": "https://registry.npmjs.org/body-parser/-/body-parser-2.2.1.tgz",
+      "resolved": "https://registry.npmjs.org/body-parser/-/body-parser-2.2.0.tgz",
-      "integrity": "sha512-nfDwkulwiZYQIGwxdy0RUmowMhKcFVcYXUU7m4QlKYim1rUtg83xm2yjZ40QjDuc291AJjjeSc9b++AWHSgSHw==",
+      "integrity": "sha512-02qvAaxv8tp7fBa/mw1ga98OGm+eCbqzJOKoRt70sLmfEEi+jyBYVTDGfCL/k06/4EMk/z01gCe7HoCH/f2LTg==",
       "license": "MIT",
       "dependencies": {
         "bytes": "^3.1.2",
         "content-type": "^1.0.5",
-        "debug": "^4.4.3",
+        "debug": "^4.4.0",
         "http-errors": "^2.0.0",
-        "iconv-lite": "^0.7.0",
+        "iconv-lite": "^0.6.3",
         "on-finished": "^2.4.1",
         "qs": "^6.14.0",
-        "raw-body": "^3.0.1",
+        "raw-body": "^3.0.0",
-        "type-is": "^2.0.1"
+        "type-is": "^2.0.0"
       },
       "engines": {
         "node": ">=18"
-      },
-      "funding": {
-        "type": "opencollective",
-        "url": "https://opencollective.com/express"
-      }
-    },
-    "node_modules/body-parser/node_modules/iconv-lite": {
-      "version": "0.7.0",
-      "resolved": "https://registry.npmjs.org/iconv-lite/-/iconv-lite-0.7.0.tgz",
-      "integrity": "sha512-cf6L2Ds3h57VVmkZe+Pn+5APsT7FpqJtEhhieDCvrE2MK5Qk9MyffgQyuxQTm6BChfeZNtcOLHp9IcWRVcIcBQ==",
-      "license": "MIT",
-      "dependencies": {
-        "safer-buffer": ">= 2.1.2 < 3.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      },
-      "funding": {
-        "type": "opencollective",
-        "url": "https://opencollective.com/express"
       }
     },
     "node_modules/buffer": {
@@ -627,9 +607,9 @@
       }
     },
     "node_modules/debug": {
-      "version": "4.4.3",
+      "version": "4.4.1",
-      "resolved": "https://registry.npmjs.org/debug/-/debug-4.4.3.tgz",
+      "resolved": "https://registry.npmjs.org/debug/-/debug-4.4.1.tgz",
-      "integrity": "sha512-RGwwWnwQvkVfavKVt22FGLw+xYSdzARwm0ru6DhTVA3umU5hZc28V3kO4stgYryrTlLpuvgI9GiijltAjNbcqA==",
+      "integrity": "sha512-KcKCqiftBJcZr++7ykoDIEwSa3XWowTfNPo92BYxjXiyYEVrUQh2aLyhxBCwww+heortUFxEJYcRzosstTEBYQ==",
       "license": "MIT",
       "dependencies": {
         "ms": "^2.1.3"
@@ -1079,23 +1059,28 @@
       }
     },
     "node_modules/http-errors": {
-      "version": "2.0.1",
+      "version": "2.0.0",
-      "resolved": "https://registry.npmjs.org/http-errors/-/http-errors-2.0.1.tgz",
+      "resolved": "https://registry.npmjs.org/http-errors/-/http-errors-2.0.0.tgz",
-      "integrity": "sha512-4FbRdAX+bSdmo4AUFuS0WNiPz8NgFt+r8ThgNWmlrjQjt1Q7ZR9+zTlce2859x4KSXrwIsaeTqDoKQmtP8pLmQ==",
+      "integrity": "sha512-FtwrG/euBzaEjYeRqOgly7G0qviiXoJWnvEH2Z1plBdXgbyjv34pHTSb9zoeHMyDy33+DWy5Wt9Wo+TURtOYSQ==",
       "license": "MIT",
       "dependencies": {
-        "depd": "~2.0.0",
+        "depd": "2.0.0",
-        "inherits": "~2.0.4",
+        "inherits": "2.0.4",
-        "setprototypeof": "~1.2.0",
+        "setprototypeof": "1.2.0",
-        "statuses": "~2.0.2",
+        "statuses": "2.0.1",
-        "toidentifier": "~1.0.1"
+        "toidentifier": "1.0.1"
       },
       "engines": {
         "node": ">= 0.8"
+      }
     },
-      "funding": {
+    "node_modules/http-errors/node_modules/statuses": {
-        "type": "opencollective",
+      "version": "2.0.1",
-        "url": "https://opencollective.com/express"
+      "resolved": "https://registry.npmjs.org/statuses/-/statuses-2.0.1.tgz",
+      "integrity": "sha512-RwNA9Z/7PrK06rYLIzFMlaF+l73iwpzsqRIFgbMLbTcLD6cOao82TaWefPXQvB2fOC4AjuYSEndS7N/mTCbkdQ==",
+      "license": "MIT",
+      "engines": {
+        "node": ">= 0.8"
       }
     },
     "node_modules/http-proxy-agent": {
@@ -1569,7 +1554,6 @@
       "resolved": "https://registry.npmjs.org/pg/-/pg-8.16.3.tgz",
       "integrity": "sha512-enxc1h0jA/aq5oSDMvqyW3q89ra6XIIDZgCX9vkMrnz5DFTw/Ny3Li2lFQ+pt3L6MCgm/5o2o8HW9hiJji+xvw==",
       "license": "MIT",
-      "peer": true,
       "dependencies": {
         "pg-connection-string": "^2.9.1",
         "pg-pool": "^3.10.1",
@@ -1746,34 +1730,18 @@
       }
     },
     "node_modules/raw-body": {
-      "version": "3.0.2",
+      "version": "3.0.0",
-      "resolved": "https://registry.npmjs.org/raw-body/-/raw-body-3.0.2.tgz",
+      "resolved": "https://registry.npmjs.org/raw-body/-/raw-body-3.0.0.tgz",
-      "integrity": "sha512-K5zQjDllxWkf7Z5xJdV0/B0WTNqx6vxG70zJE4N0kBs4LovmEYWJzQGxC9bS9RAKu3bgM40lrd5zoLJ12MQ5BA==",
+      "integrity": "sha512-RmkhL8CAyCRPXCE28MMH0z2PNWQBNk2Q09ZdxM9IOOXwxwZbN+qbWaatPkdkWIKL2ZVDImrN/pK5HTRz2PcS4g==",
       "license": "MIT",
       "dependencies": {
-        "bytes": "~3.1.2",
+        "bytes": "3.1.2",
-        "http-errors": "~2.0.1",
+        "http-errors": "2.0.0",
-        "iconv-lite": "~0.7.0",
+        "iconv-lite": "0.6.3",
-        "unpipe": "~1.0.0"
+        "unpipe": "1.0.0"
       },
       "engines": {
-        "node": ">= 0.10"
+        "node": ">= 0.8"
-      }
-    },
-    "node_modules/raw-body/node_modules/iconv-lite": {
-      "version": "0.7.0",
-      "resolved": "https://registry.npmjs.org/iconv-lite/-/iconv-lite-0.7.0.tgz",
-      "integrity": "sha512-cf6L2Ds3h57VVmkZe+Pn+5APsT7FpqJtEhhieDCvrE2MK5Qk9MyffgQyuxQTm6BChfeZNtcOLHp9IcWRVcIcBQ==",
-      "license": "MIT",
-      "dependencies": {
-        "safer-buffer": ">= 2.1.2 < 3.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      },
-      "funding": {
-        "type": "opencollective",
-        "url": "https://opencollective.com/express"
       }
     },
     "node_modules/readable-stream": {

services/dbconnector/paramsConfig.json

@@ -4,6 +4,7 @@
         "Name": { "type": "nvarchar", "maxLength": 255 },
         "Description": { "type": "nvarchar", "maxLength": 255 },
         "Building": { "type": "nvarchar", "maxLength": 255 },
+        "Bin": { "type": "nvarchar", "maxLength": 255 },
         "Owner": { "type": "nvarchar", "maxLength": 255 },
         "Role": { "type": "nvarchar", "maxLength": 255 },
         "Location": { "type": "nvarchar", "maxLength": 255 },
@@ -14,12 +15,14 @@
         "Username": { "type": "nvarchar", "maxLength": 50 },
         "AuthenticatedUsername": { "type": "nvarchar", "maxLength": 50 },
         "UITheme": { "type": "nvarchar", "maxLength": 50 },
-        "Bio": { "type": "text" },
+        "Bio": { "type": "nvarchar", "maxlength": 255 },
         "PasswordHash": { "type": "text" },
-        "Image": { "type": "text" },
+        "Image": { "type": "nvarchar", "maxLength": 255 },
-        "AvatarURL": { "type": "text" },
+        "AvatarURL": { "type": "nvarchar", "maxlength": 255  },
         "SQL_USER": { "type": "bit" },
-        "Text": { "type": "nvarchar", "maxLength": 255 }
+        "Text": { "type": "nvarchar", "maxLength": 255 },
+        "Quantity": { "type": "int" },
+        "RequestPayload": { "type": "text" }
     },
     "oracle": {
         "ID": { "type": "string" },