curl --location --request POST 'http://10.11.53.2:2885/api/v1-alpha/database/table/create' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data-raw '{
"database": "shop",
"schema": "public",
"table": {
"name": "users",
"columns": [
{
"name": "id",
"type": "INTEGER",
"flags": {
"primary": true,
"unique": true,
"nullable": false,
"default": null,
"autoIncrement": true,
"index": true,
"unsigned": true,
"length": 5
},
"foreignKeys": [],
"constraints": []
},
{
"name": "first_name",
"type": "TEXT",
"flags": {
"primary": false,
"unique": false,
"nullable": false,
"default": null,
"autoIncrement": false,
"index": true,
"unsigned": false,
"length": 20
},
"foreignKeys": [],
"constraints": []
},
{
"name": "age",
"type": "INTEGER",
"flags": {
"primary": false,
"unique": false,
"nullable": false,
"default": null,
"autoIncrement": false,
"index": true,
"unsigned": false,
"length": 3
},
"foreignKeys": [],
"constraints": []
},
{
"name": "initials",
"type": "VARCHAR",
"flags": {
"primary": false,
"unique": false,
"nullable": false,
"default": null,
"autoIncrement": false,
"index": true,
"unsigned": false,
"length": 3
},
"foreignKeys": [],
"constraints": []
}
],
"indexes": [
{
"name": "",
"columns": [],
"unique": false
}
],
"constraints": {
"primary_keys": [],
"uniques": [],
"checks": [],
"foreign_keys": []
},
"options": {
"engine": "InnoDB",
"charset": "utf8mb4",
"collation": "utf8mb4_unicode_ci",
"comment": "Benutzertabelle",
"if_not_exists": true
}
}
}'