Difference between revisions of "SQWareRepository:ingres"

From Wiki_dbSQWare
Jump to: navigation, search
(Replaced content with '{{SQWareRepositoryPresSgbd|Ingres|database|INGRES_SID|ing}} == Specific database content for Ingres ==')
 
Line 1: Line 1:
 
{{SQWareRepositoryPresSgbd|Ingres|database|INGRES_SID|ing}}
 
{{SQWareRepositoryPresSgbd|Ingres|database|INGRES_SID|ing}}
 
== Specific database content for Ingres ==
 
== Specific database content for Ingres ==
 +
 +
{{SQWareRepositoryTables|tsqwing_VolDb|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
database_name varchar(80)
 +
gather_date datetime
 +
size_db decimal(12,2)
 +
</pre>
 +
}}

Latest revision as of 18:09, 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 tsqwing_% or isqwing_% are specific for Ingres.
Installation guide for SQWareRepository for Ingres

Naming convention

All specific objects for Ingres are named with prefixes:

  • tsqwing_% : for tables
  • isqwing_% : for index
  • isqwing_%_u : for uniques
  • isqwing_%_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.


Specific database content for Ingres

tsqwing_VolDb

This table contains : ...
Desc of tsqwing_VolDb :

Field Type
dbalias varchar(80)
database_name varchar(80)
gather_date datetime
size_db decimal(12,2)