IP : 3.144.4.127Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
x2/
../
wp59/
../
hablator/
../
lime5/
../
fusio/
fusio.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
INSERT INTO `fusio_config` VALUES (1, NULL, 2, 'app_approval', 'If true the status of a new app is PENDING so that an administrator has to manually activate the app', '0'), (2, NULL, 3, 'consumer_max_apps', 'The max amount of apps a consumer can generate', '16'), (3, NULL, 3, 'consumer_max_tokens', 'The max amount of tokens a consumer can generate', '16'), (4, NULL, 3, 'consumer_max_webhooks', 'The max amount of webhooks a consumer can register', '8'), (5, NULL, 1, 'authorization_url', 'Url where the user can authorize for the OAuth2 flow', ''), (6, NULL, 1, 'info_title', 'The title of the application', 'Fusio'), (7, NULL, 1, 'info_description', 'A short description of the application. CommonMark syntax MAY be used for rich text representation', ''), (8, NULL, 1, 'info_tos', 'A URL to the Terms of Service for the API. MUST be in the format of a URL', ''), (9, NULL, 1, 'info_contact_name', 'The identifying name of the contact person/organization', ''), (10, NULL, 1, 'info_contact_url', 'The URL pointing to the contact information. MUST be in the format of a URL', ''), (11, NULL, 1, 'info_contact_email', 'The email address of the contact person/organization. MUST be in the format of an email address', ''), (12, NULL, 1, 'info_license_name', 'The license name used for the API', ''), (13, NULL, 1, 'info_license_url', 'A URL to the license used for the API. MUST be in the format of a URL', ''), (14, NULL, 1, 'mail_register_subject', 'Subject of the activation mail', 'Fusio registration'), (15, NULL, 6, 'mail_register_body', 'Body of the activation mail', 'Hello {name},\n\nyou have successful registered at Fusio.\nTo activate you account please visit the following link:\n{apps_url}/developer/register/activate/{token}'), (16, NULL, 1, 'mail_pw_reset_subject', 'Subject of the password reset mail', 'Fusio password reset'), (17, NULL, 6, 'mail_pw_reset_body', 'Body of the password reset mail', 'Hello {name},\n\nyou have requested to reset your password.\nTo set a new password please visit the following link:\n{apps_url}/developer/password/confirm/{token}\n\nPlease ignore this email if you have not requested a password reset.'), (18, NULL, 1, 'mail_points_subject', 'Subject of the points threshold mail', 'Fusio points threshold reached'), (19, NULL, 6, 'mail_points_body', 'Body of the points threshold mail', 'Hello {name},\n\nyour account has reached the configured threshold of {points} points.\nIf your account reaches 0 points your are not longer able to invoke specific endpoints.\nTo prevent this please go to the developer portal to purchase new points:\n{apps_url}/developer'), (20, NULL, 1, 'recaptcha_key', 'ReCaptcha key', ''), (21, NULL, 1, 'recaptcha_secret', 'ReCaptcha secret', ''), (22, NULL, 1, 'payment_stripe_secret', 'The stripe webhook secret which is needed to verify a webhook request', ''), (23, NULL, 1, 'payment_stripe_portal_configuration', 'The stripe portal configuration id', ''), (24, NULL, 1, 'payment_currency', 'The three-character ISO-4217 currency code which is used to process payments', ''), (25, NULL, 1, 'role_default', 'Default role which a user gets assigned on registration', 'Consumer'), (26, NULL, 3, 'points_default', 'The default amount of points which a user receives if he registers', '0'), (27, NULL, 3, 'points_threshold', 'If a user goes below this points threshold we send an information to the user', '0'), (28, NULL, 1, 'system_mailer', 'Optional the name of an SMTP connection which is used as mailer, by default the system uses the connection configured through the APP_MAILER environment variable', ''), (29, NULL, 1, 'system_dispatcher', 'Optional the name of an HTTP or Message-Queue connection which is used to dispatch events. By default the system uses simply cron and an internal table to dispatch such events, for better performance you can provide a Message-Queue connection and Fusio will only dispatch the event to the queue, then your worker must execute the actual webhook HTTP request', ''), (30, NULL, 3, 'user_pw_length', 'Minimal required password length', '8'), (31, NULL, 2, 'user_approval', 'Whether the user needs to activate the account through an email', '1'), (32, NULL, 1, 'marketplace_client_id', 'The marketplace client id', ''), (33, NULL, 1, 'marketplace_client_secret', 'The marketplace client secret', '');
INSERT INTO `fusio_page` VALUES (1, NULL, 2, 'Overview', 'overview', '\n<div class="fusio-intro">\n <h1>Employ the Acme API<br> to power your app.</h1>\n <p>Explore the documentation or dive<br>directly into the API reference.</p>\n <p>\n <a class="btn btn-primary btn-lg" href="./bootstrap" role="button">Get started</a>\n <a class="btn btn-secondary btn-lg" href="./api" role="button">REST API</a>\n </p>\n</div>\n\n<div class="fusio-intro-subline">\n <h2>Join the developer community.</h2>\n <p>You can <a href="./register">register</a> a new account or <a href="./login">login</a>.</p>\n</div>\n\n<div class="row">\n <div class="col-md-4">\n <div class="fusio-intro-column">\n <div class="fusio-intro-column-icon text-primary">\n <i class="bi bi-cloudy-fill"></i>\n </div>\n <h3><a href="./bootstrap" class="link-primary">Documentation</a></h3>\n <p>Explore guides which<br>help you get started quickly.</p>\n </div>\n </div>\n <div class="col-md-4">\n <div class="fusio-intro-column">\n <div class="fusio-intro-column-icon text-primary">\n <i class="bi bi-box-fill"></i>\n </div>\n <h3><a href="./api" class="link-primary">API</a></h3>\n <p>Dive directly into the<br>complete API reference.</p>\n </div>\n </div>\n <div class="col-md-4">\n <div class="fusio-intro-column">\n <div class="fusio-intro-column-icon text-primary">\n <i class="bi bi-chat-fill"></i>\n </div>\n <h3><a href="./support" class="link-primary">Support</a></h3>\n <p>Find all available<br>support options if you get stuck.</p>\n </div>\n </div>\n</div>', NULL, '[[regtime]]'), (2, NULL, 1, 'Getting started', 'getting-started', '\n<p class="lead">Learn how to start using this API. Explore the endpoints, sign up for an account, and connect with the\ncommunity.</p>\n\n<h3>Quickstart</h3>\n\n<p>This is a quick introduction to help you get started using this API.</p>\n\n<ul>\n <li><a href="./register">Signup for a new account</a></li>\n <li><a href="./authorization">Learn how to obtain an Access-Token</a></li>\n <li><a href="./api">Explore the API documentation</a></li>\n <li><a href="./sdk">Download an SDK</a></li>\n</ul>', NULL, '[[regtime]]'), (3, NULL, 1, 'API', 'api', '\n<iframe src="{APPS_URL}/redoc/" width="100%" height="1024px" style="border:0"></iframe>', NULL, '[[regtime]]'), (4, NULL, 1, 'Authorization', 'authorization', '\n<p class="lead">To access protected parts of the API you need to obtain an access token. The following page shows how\nto obtain an access token.</p>\n\n<h3>Basic</h3>\n\n<p>The most basic way to obtain an access token is to use your personal credentials.</p>\n\n<p><b>Request</b></p>\n<pre class="bg-dark text-white p-2">POST /consumer/login\nContent-Type: application/json\n\n{\n "username": "[username]",\n "password": "[password]"\n}\n</pre>\n\n<p><b>Response</b></p>\n<pre class="bg-dark text-white p-2">\n{\n "token": "",\n "expires_in": "",\n "refresh_token": ""\n}\n</pre>\n\n<h3>OAuth2</h3>\n\n<p>It is also possible to use the <a href="https://tools.ietf.org/html/rfc6749">OAuth2</a> authorization endpoint.</p>\n\n<h4>Client credentials</h4>\n\n<p><b>Request</b></p>\n<pre class="bg-dark text-white p-2">POST /authorization/token\nAuthorization: Basic czZCaGRSa3F0MzpnWDFmQmF0M2JW\nContent-Type: application/x-www-form-urlencoded\n\ngrant_type=client_credentials\n</pre>\n\n<p>As Basic authorization header you need to provide the <code>[app key] + ":" + [app secret]</code> as <code>base64</code>\nencoded string. It is also possible to provide your username and password but in general it is recommended to use the\napp key and secret since the app access can always be revoked later on.</p>\n\n<p><b>Response</b></p>\n<pre class="bg-dark text-white p-2">\n{\n "access_token": "",\n "token_type": "bearer",\n "expires_in": 3600,\n "refresh_token": ""\n}\n</pre>\n\n<h4>Refresh token</h4>\n\n<p>Most token responses always include a refresh token. You can use this refresh token to extend an access token before\nit expires.</p>\n\n<p><b>Request</b></p>\n<pre class="bg-dark text-white p-2">POST /authorization/token\nAuthorization: Basic czZCaGRSa3F0MzpnWDFmQmF0M2JW\nContent-Type: application/x-www-form-urlencoded\n\ngrant_type=refresh_token&refresh_token=[refresh_token]\n</pre>\n\n<p>Like at the client credentials call the Basic header must contain the base64 encode app key and secret.</p>\n\n<p><b>Response</b></p>\n<pre class="bg-dark text-white p-2">\n{\n "access_token": "",\n "token_type": "bearer",\n "expires_in": 3600,\n "refresh_token": ""\n}\n</pre>\n\n<p>As response you will get a new access token.</p>', NULL, '[[regtime]]'), (5, NULL, 1, 'Support', 'support', '\n<p class="lead">This API was build with <a href="https://www.fusio-project.org">Fusio</a> please visit the website of\nthe API provider to see available support options.</p>', NULL, '[[regtime]]'), (6, NULL, 1, 'SDK', 'sdk', '\n<p class="lead">At the following page you can download the automatically generated client SDKs which help you to\nintegrate the API into your project.</p>\n\n<div class="card float-start" style="width:14rem;margin-right:1rem;margin-bottom:1rem">\n <h5 class="card-header">PHP</h5>\n <img src="assets/sdk/client-php.png" class="card-img-top" style="padding:16px;">\n <div class="card-body">\n <div class="btn-group" role="group">\n <a href="{BASE_URL}/sdk/sdk-client-php-default.zip" class="btn btn-primary">Download</a>\n </div>\n </div>\n</div>\n\n<div class="card float-start" style="width:14rem;margin-right:1rem;margin-bottom:1rem">\n <h5 class="card-header">TypeScript</h5>\n <img src="assets/sdk/client-typescript.png" class="card-img-top" style="padding:16px;">\n <div class="card-body">\n <div class="btn-group" role="group">\n <a href="{BASE_URL}/sdk/sdk-client-typescript-default.zip" class="btn btn-primary">Download</a>\n </div>\n </div>\n</div>\n\n<div class="card float-start" style="width:14rem;margin-right:1rem;margin-bottom:1rem">\n <h5 class="card-header">OpenAPI</h5>\n <img src="assets/sdk/spec-openapi.png" class="card-img-top" style="padding:16px;">\n <div class="card-body">\n <div class="btn-group" role="group">\n <a href="{BASE_URL}/sdk/sdk-spec-openapi-default.zip" class="btn btn-primary">Download</a>\n </div>\n </div>\n</div>\n\n<div style="clear:both"></div>', NULL, '[[regtime]]');
-- -- Constraints for table `fusio_webhook_response` -- ALTER TABLE `fusio_webhook_response` ADD CONSTRAINT `webhook_response_webhook_id` FOREIGN KEY (`webhook_id`) REFERENCES `fusio_webhook` (`id`);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;