How to create MySQL Database for your Backend
MySQL and Configure.IT
MySQL is the most popular database system used with PHP. Configure.IT uses MySQL as the core backbone for backend of your apps. The combination of Configure.IT and MySQL gives unmet options to create just about any kind of application!
Important Existing Database
User can import existing database from remote server. Select any remote server from the list (you will be listed with the remote servers that you have added). Tables would be listed according to the selected remote server.
Creating New Tables
User can create/delete tables. User can copy tables from another project as well (Only Structure OR Data and Structure).
User can add common fields.If you want to use it then just select it. It will be added your in table. You can add custom field as well.
“SMART” way to create tables
While creating custom fields, it uses ‘Intelligent Data type selection’ based on ‘field name’. if you want to set data type as “Varchar” for your field, you have to take field name like “vName”. It would consider “v” as “varchar” from “vName”.
Table Relationships
User can create Relations with other Tables. It will show in dropdown box. If user relates a table with another table from database, there is no need to relate it in admin module while creating module using this table.
Views
User can add Views by providing proper view name, table name, columns, algorithm and its definition.
Triggers
User can add triggers by providing trigger name, table, time (before / after), type (insert / update / delete), definition and definer.
Functions
User can add functions by providing function name, return type, return length/values, parameters, definition etc.
Stored Procedures
User can add stored procedures by providing procedure name, parameters (IN/OUT), definition, definer etc.
Click here to learn more about Database Configuration
About Configure.IT
Configure.IT is a cross-platform Mobile App Development Tools that empowers developing 100% native, customizable and extendible apps and backend, without writing code. The solution provides infrastructure free solution for developers, startups and enterprises, to build mobile solutions that doesn’t require great skills, experience and technology expertise.
Take a look at the brief introduction video here
