Create database for a web hosting package

A new database for one web hosting package - MariaDB unless asked otherwise.

WWriteNot idempotentbetaNeeds service_webhosting
Tool
manitu_webhosting_web_database_createon https://mcp.manitu.de/mcp
POST
/v1/webhosting/web/database/createon https://api.manitu.de
Try it
Changes the account. Agents say what will happen and wait for an explicit yes before calling it.
readOnlyHint falsedestructiveHint falseidempotentHint falseopenWorldHint false

Creates a database for a web hosting package of the manitu customer account this connection works in, by its site_id from manitu_webhosting_list: on a MariaDB server unless server_type says mysql or postgres, with a description. manitu makes the name, the user and the password; the answer gives host, name and user - the password itself is NOT given here (secrets_withheld), the customer finds it in the customer panel. Check count_max in manitu_webhosting_web_database_list first. Refused with a conflict when the package allows no more databases (limit_reached), has no server of that kind (server_type_not_available) or cannot be changed now (not_configurable).

site_idinteger | stringrequired

The site_id from manitu_webhosting_list - never guess one.

pattern ^[1-9][0-9]*$min 1
server_typestring

The kind of database server. Default: mariadb.

One of mariadb mysql postgres
descriptionstring | null

The customer's description, for his own overview - e.g. which website uses it. Left out: unchanged (set) or none (create); null or empty: none.

max length 1024
database_idintegerrequired

The database - what the other database tools take.

server_typestring | nullrequired

The kind of database server: mariadb, mysql or postgres; null if it cannot be told right now.

One of mariadb mysql postgres null
hostnamestringrequired

The database server to connect to - from the web hosting package's own scripts.

namestringrequired

The name of the database (db<number>).

usernamestringrequired

The user to connect with (u<number>).

descriptionstring | nullrequired

What the customer wrote about it (his description), null if nothing - not its name or user name.

password_storedbooleanrequired

manitu still knows the password. false: the customer had it forgotten - the database keeps it, dumps and copies need a new one (set with password_action regenerate).

table_countinteger | nullrequired

How many tables it has, as last counted; null if never counted.

data_size_mbinteger | nullrequired

How much data and indexes it holds in MB (rounded down), as reported by the database server when last counted; the files on disk can be larger. null if never counted.

counted_atstring | nullrequired

When table_count and data_size_mb were counted.

Format date-time
created_atstring | nullrequired

When it was created.

Format date-time
passwordstring | nullrequired

The password - a secret; null where it is withheld (secrets_withheld) or not stored (password_stored).

secrets_withheldbooleanrequired

The password is left out here (an answer to an agent) - the customer finds it in the customer panel.

One of X-API-Key, Authorization: Bearer … - never more than one in a request. More

site_idinteger | stringrequired

The site_id from manitu_webhosting_list - never guess one.

pattern ^[1-9][0-9]*$min 1
server_typestring

The kind of database server. Default: mariadb.

One of mariadb mysql postgres
descriptionstring | null

The customer's description, for his own overview - e.g. which website uses it. Left out: unchanged (set) or none (create); null or empty: none.

max length 1024
database_idintegerrequired

The database - what the other database tools take.

server_typestring | nullrequired

The kind of database server: mariadb, mysql or postgres; null if it cannot be told right now.

One of mariadb mysql postgres null
hostnamestringrequired

The database server to connect to - from the web hosting package's own scripts.

namestringrequired

The name of the database (db<number>).

usernamestringrequired

The user to connect with (u<number>).

descriptionstring | nullrequired

What the customer wrote about it (his description), null if nothing - not its name or user name.

password_storedbooleanrequired

manitu still knows the password. false: the customer had it forgotten - the database keeps it, dumps and copies need a new one (set with password_action regenerate).

table_countinteger | nullrequired

How many tables it has, as last counted; null if never counted.

data_size_mbinteger | nullrequired

How much data and indexes it holds in MB (rounded down), as reported by the database server when last counted; the files on disk can be larger. null if never counted.

counted_atstring | nullrequired

When table_count and data_size_mb were counted.

Format date-time
created_atstring | nullrequired

When it was created.

Format date-time
passwordstring | nullrequired

The password - a secret; null where it is withheld (secrets_withheld) or not stored (password_stored).

secrets_withheldbooleanrequired

The password is left out here (an answer to an agent) - the customer finds it in the customer panel.

200Success.400The request does not match the declared input schema.401No credential was presented, or it was not recognised.403The credential is not permitted to use this operation.500The server failed. Nothing about the request was wrong. Whether a change took effect is not known - check before trying it again.503The channel this operation forwards through is unavailable.