Difference between revisions of "Template:SQWareRepositoryPresSgbd"
Expdbtools (talk | contribs) (→Presentation) |
Expdbtools (talk | contribs) (→Presentation) |
||
(2 intermediate revisions by the same user not shown) | |||
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> | ||
− | [[Installation#SQWareRepository for {{{1}}} | Installation guide for | + | [[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository for {{{1}}} ]]<br> |
<br> | <br> | ||
== Naming convention == | == Naming convention == | ||
− | All objects are named with prefixes: | + | All specific objects for {{{1}}} are named with prefixes: |
* tsqw{{{4}}}_% : for tables | * tsqw{{{4}}}_% : for tables | ||
* isqw{{{4}}}_% : for index | * isqw{{{4}}}_% : for index |
Latest revision as of 19:15, 22 December 2017
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