SQWareRepository:mysql

From Wiki_dbSQWare
Revision as of 18:03, 8 August 2015 by Mpayan (talk | contribs) (Replaced content with '{{SQWareRepositoryPresSgbd|Mysql|database|instances|mys}} == Specific database content for MySQL ==')
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwmys_% or isqwmys_% are specific for Mysql.
Installation guide for SQWareRepository for Mysql

Naming convention

All specific objects for Mysql are named with prefixes:

  • tsqwmys_% : for tables
  • isqwmys_% : for index
  • isqwmys_%_u : for uniques
  • isqwmys_%_pk : for primary key


Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


Specific database content for MySQL

Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareRepository:mysql&oldid=7254"