prestashop_database_management_tool_adminer

Hi All, Greetings of the day. The module helps to integrate Database Management Tool Adminer in the back-office. This helps to run SQL queries, and database backups, and perform various jobs such as SELECT/INSERT/UPDATE/DELETE database tables and columns in tables. Also, get information and search data in different tables and databases. It is a fully functional database administration panel available in many databases. It works with very huge/big database sizes in GB for example 4 GB database. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement. Features ­ Create, drop and alter tables ­ Delete, edit and add fields as well as manage keys on fields ­ Execute any SQL statement ­ Query your databases ­ Manage privileges ­ Export data into various formats ­ Back up and restore your databases ­ Connect to a database server with a username and password ­ Select an existing database or create a new one ­ List fields, indexes, foreign keys and triggers of table ­ Change name, engine, collation, auto_increment, and comment of table ­ Alter name, type, collation, comment and default values of columns ­ Add and drop tables and columns ­ Create, alter, drop and search by indexes including full-text ­ Create, alter, drop and link lists by foreign keys ­ Create, alter, drop and select from views ­ Create, alter, drop and call stored procedures and functions ­ Create, alter and drop triggers ­ List data in tables with search, aggregate, sort and limit results ­ Insert new records, update and delete the existing ones ­ Supports all data types, and blobs through file transfer ­ Execute any SQL command from a text field or a file ­ Export table structure, data, views, routines, and databases to SQL or CSV ­ Print database schema connected by foreign keys ­ Show processes and kill them ­ Display users and rights