Difference between revisions of "Template:SQWareRepositoryPresSgbd"

From Wiki_dbSQWare
Jump to: navigation, search
(Naming convention)
(Presentation)
Line 1: Line 1:
 
== Presentation ==
 
== Presentation ==
 
It is the repository module, and stores rdbms indicators for all RDBMS.<br>
 
It is the repository module, and stores rdbms indicators for all RDBMS.<br>
 +
It is a MySQL database.<br>
 
Objects prefix by tsqw_% or isqw_% are generic.<br>
 
Objects prefix by tsqw_% or isqw_% are generic.<br>
 
Objects prefix by tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for {{{1}}}.<br>
 
Objects prefix by tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for {{{1}}}.<br>

Revision as of 14:58, 8 August 2015

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 tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for {{{1}}}.
[[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository™ for {{{1}}} ]]

Naming convention

All specific objects for {{{1}}} are named with prefixes:

  • tsqw{{{4}}}_% : for tables
  • isqw{{{4}}}_% : for index
  • isqw{{{4}}}_%_u : for uniques
  • isqw{{{4}}}_%_pk : for primary key


Nuvola apps important.png
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.