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 {{{1}}}.<br>
+
It is the repository module, and stores rdbms indicators for all RDBMS.<br>
It's a {{{1}}} {{{2}}}. It is currently the only type of supported RDBMS for dbSQWare® repository for {{{1}}}.<br>
+
Objects prefix by tsqw_% or isqw_% are generic.<br>
Each scheme is managed in the same type of RDBMS that managed to avoid client deployment problem (Oracle in Oracle, Sybase, Sybase ...). One exemption is Ingres, Ingres indicators are managed in a MySql database.<br>
+
Objects prefix by tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for {{{1}}}.<br>
The first task is to insert the informations of {{{1}}} {{{3}}} in the repository. It's tsqw_Repository table which contain basic informations of {{{3}}} to manage.<br>
 
 
[[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository™ for {{{1}}} ]]<br>
 
[[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository™ for {{{1}}} ]]<br>
 
<br>
 
<br>

Revision as of 15:55, 8 August 2015

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
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 objects 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.