代码拉取完成，页面将自动刷新
<?xml version="1.0" encoding="UTF-8"?>
<?PowerDesigner AppLocale="UTF16" Code="PGSQL9" Family="ANSI" HasExtendedMetaClass="FALSE" ID="{83063C86-4E0A-4954-BF00-620C0D0F02D8}" LastModificationDate="1341906213" Name="openGauss" Objects="308" Symbols="0" Type="{4BA9F647-DAB1-11D1-9944-006097355D9B}" signature="XDB_XML" version="16.6.0.4971"?>
<!-- do not edit this file -->
<DBMS xmlns:a="attribute" xmlns:c="collection" xmlns:o="object">
<o:DBMS Id="o1">
<a:ObjectID>83063C86-4E0A-4954-BF00-620C0D0F02D8</a:ObjectID>
<a:Name>openGauss 1.1.0</a:Name>
<a:Code>PGSQL9</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341906213</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Family>ANSI</a:Family>
<a:CheckGlobalScript>'******************************************************************************
'* Purpose: This VB-Script holds global definitions shared by all the custom-
'* checks scripts of the model extension.
'******************************************************************************
Option Explicit ' This is to ensure all used variables are defined
</a:CheckGlobalScript>
<c:Categories>
<o:TargetCategory Id="o2">
<a:ObjectID>F1A020C1-477C-4FE6-B187-7FC7D46FE484</a:ObjectID>
<a:Name>General</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Target DBMS identification</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o3">
<a:ObjectID>EA3C706C-F552-4CC5-8A17-AB0A2D0F4BDE</a:ObjectID>
<a:Name>SqlSupport</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL syntax allowed. This does not impact the script generation, but it impacts the SQL Preview</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o4">
<a:ObjectID>7868A7BA-E474-4E27-BDF3-1104AFABF7C0</a:ObjectID>
<a:Name>EnableCheck</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Determines if the generation of check parameters is authorized or not</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o5">
<a:ObjectID>714677D5-B508-4B87-AB65-AF6E66C5C151</a:ObjectID>
<a:Name>Enableconstname</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Determines if constraint names are used during the generation</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o6">
<a:ObjectID>AB1F411F-11C4-4EDD-8A76-7A79B81D042D</a:ObjectID>
<a:Name>UniqConstName</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Determines if unique constraint names for objects are authorized or not</a:Comment>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o7">
<a:ObjectID>68C5494A-C8AB-4FC7-A431-3EAF5B4C44D6</a:ObjectID>
<a:Name>EnableIntegrity</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Allows integrity constraints in the DBMS. This controls whether generation parameters for primary, foreign, and alternate keys are grayed or available</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o8">
<a:ObjectID>09CC7C62-0030-4BD4-BB4D-24373F684A76</a:ObjectID>
<a:Name>EnableMultiCheck</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Determines if the generation of multiple check parameters is authorized or not</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o9">
<a:ObjectID>CC013A88-7C22-4315-9C88-0B17EC54F8D0</a:ObjectID>
<a:Name>Script</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>DBMS characteristics, command definition, and data type translations for the Script generation and reverse engineering</a:Comment>
<c:Categories>
<o:TargetCategory Id="o10">
<a:ObjectID>5FD38E36-8DC0-4299-974F-F28B32CCF6C1</a:ObjectID>
<a:Name>Sql</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains sub-categories Syntax, Format, File and Keywords. Each sub-category contains entries whose values define general syntax for the database</a:Comment>
<c:Categories>
<o:TargetCategory Id="o11">
<a:ObjectID>5C4F8EE0-FFDE-4901-A42E-08330F43BE4E</a:ObjectID>
<a:Name>Syntax</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains general parameters for SQL syntax</a:Comment>
<c:Categories>
<o:CharacterTargetItem Id="o12">
<a:ObjectID>1207496B-6D26-4E86-B310-FC0B82E8E494</a:ObjectID>
<a:Name>Terminator</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>End of command character</a:Comment>
<a:CharacterTargetItem.Value>;</a:CharacterTargetItem.Value>
</o:CharacterTargetItem>
<o:StringTargetItem Id="o13">
<a:ObjectID>30DA977E-0C12-41F8-A871-734B9C92752B</a:ObjectID>
<a:Name>BlockTerminator</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>End of block character</a:Comment>
</o:StringTargetItem>
<o:CharacterTargetItem Id="o14">
<a:ObjectID>E5E60CF7-3FDB-4F4A-ACFA-E61497BB94F8</a:ObjectID>
<a:Name>Delimiter</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Field separation character. Example: col1, col2, col3</a:Comment>
<a:CharacterTargetItem.Value>,</a:CharacterTargetItem.Value>
</o:CharacterTargetItem>
<o:CharacterTargetItem Id="o15">
<a:ObjectID>02FCF451-A3F8-4443-854F-39B46B4E90D0</a:ObjectID>
<a:Name>Quote</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Character used to enclose string values</a:Comment>
<a:CharacterTargetItem.Value>'</a:CharacterTargetItem.Value>
</o:CharacterTargetItem>
<o:CharacterTargetItem Id="o16">
<a:ObjectID>53DCF79F-F968-4CFB-8081-100F8BE9598E</a:ObjectID>
<a:Name>SqlContinue</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Continuation character</a:Comment>
</o:CharacterTargetItem>
<o:StringTargetItem Id="o17">
<a:ObjectID>941E4818-62E6-468B-AF8F-682C2B802D75</a:ObjectID>
<a:Name>LineComment</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Characters used to enclose a single line comment</a:Comment>
<a:StringTargetItem.Value>--</a:StringTargetItem.Value>
</o:StringTargetItem>
<o:StringTargetItem Id="o18">
<a:ObjectID>EE966B5D-7C62-4EAA-837C-BEEC61F23DD8</a:ObjectID>
<a:Name>BlockComment</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Characters used to enclose a multi-line comment</a:Comment>
<a:StringTargetItem.Value>/* */</a:StringTargetItem.Value>
</o:StringTargetItem>
<o:BooleanTargetItem Id="o19">
<a:ObjectID>7A611A4A-F0EF-4AF8-9A14-CACDA6F94A83</a:ObjectID>
<a:Name>UseBlockTerm</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Use end of block character by default</a:Comment>
</o:BooleanTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o20">
<a:ObjectID>B9BD47AF-E067-4888-91D0-369F4FC676FD</a:ObjectID>
<a:Name>Format</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains entries that define script formatting</a:Comment>
<c:Categories>
<o:StringTargetItem Id="o21">
<a:ObjectID>BE0A4657-577C-40DA-823D-DFE9D65EA0FE</a:ObjectID>
<a:Name>IllegalChar</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Invalid characters for names</a:Comment>
<a:StringTargetItem.Value>" +-*/!=<>'"()[]".</a:StringTargetItem.Value>
</o:StringTargetItem>
<o:BooleanTargetItem Id="o22">
<a:ObjectID>884832B1-A23F-4D99-9D32-3300C16BEFCD</a:ObjectID>
<a:Name>UpperCaseOnly</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Uppercase only</a:Comment>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o23">
<a:ObjectID>410153CC-039A-4BCC-A9DA-73A14758BB96</a:ObjectID>
<a:Name>LowerCaseOnly</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Lowercase only</a:Comment>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o24">
<a:ObjectID>270DB985-97B4-4796-B3AC-8E008529FBC5</a:ObjectID>
<a:Name>EnableOwnerPrefix</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Object codes can have a prefix made of the object owner code</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o25">
<a:ObjectID>3025ED8F-2ED3-44A9-824D-5BCD6D6FD1B9</a:ObjectID>
<a:Name>File</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains header, footer and usage text entries used during the generation</a:Comment>
<c:Categories>
<o:TextTargetItem Id="o26">
<a:ObjectID>F615AB51-5D07-436F-8C4D-F43C8B7C5FDD</a:ObjectID>
<a:Name>Header</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Header text for a database generation script</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o27">
<a:ObjectID>71AC941F-F3B7-4278-BC51-DF34D6EF42CF</a:ObjectID>
<a:Name>Footer</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Footer text for a database generation script</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o28">
<a:ObjectID>F43D615E-3EBD-4C14-9199-5914CBEAA5DD</a:ObjectID>
<a:Name>EnableMultiFile</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Multi-script allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:StringTargetItem Id="o29">
<a:ObjectID>FA22FD3F-AB4C-4DC2-86E9-10ED4592C386</a:ObjectID>
<a:Name>ScriptExt</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Main script extension in database generation</a:Comment>
<a:StringTargetItem.Value>sql</a:StringTargetItem.Value>
</o:StringTargetItem>
<o:StringTargetItem Id="o30">
<a:ObjectID>E532FCE4-F3B1-4CD0-BBD8-6006C09F4ACB</a:ObjectID>
<a:Name>TableExt</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Other scripts extension in database generation</a:Comment>
<a:StringTargetItem.Value>tab</a:StringTargetItem.Value>
</o:StringTargetItem>
<o:StringTargetItem Id="o31">
<a:ObjectID>7AE42F8F-8544-4AB1-B396-D843BE10CE7E</a:ObjectID>
<a:Name>StartCommand</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for executing a script</a:Comment>
</o:StringTargetItem>
<o:TextTargetItem Id="o32">
<a:ObjectID>8391BA96-63E7-43A6-B37C-7C65B9525CC9</a:ObjectID>
<a:Name>Usage1</a:Name>
<a:TextTargetItem.Value> (1) Go to the directory %PATHSCRIPT%
(2) Start the SQL interpreter
(3) Run the database creation script:
%NAMESCRIPT%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Usage for a single script in database generation</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o33">
<a:ObjectID>29E46CF1-DB88-4860-ABD2-09D9933D3FC6</a:ObjectID>
<a:Name>Usage2</a:Name>
<a:TextTargetItem.Value> (1) Go to the directory %PATHSCRIPT%
(2) Start the SQL interpreter
(3) Run the database creation scripts</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Usage for multiple scripts in database generation</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o34">
<a:ObjectID>CF7B9B8A-86B0-42F1-883E-BB792C02DFE1</a:ObjectID>
<a:Name>Keywords</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains the list of reserved words and functions available in SQL</a:Comment>
<c:Categories>
<o:TextTargetItem Id="o35">
<a:ObjectID>C65EFCC0-604A-4E47-B059-EA77B400FCDE</a:ObjectID>
<a:Name>ReservedDefault</a:Name>
<a:TextTargetItem.Value>CURRENT_USER
SESSION_USER
USER
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
NULL</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Reserved default values</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o36">
<a:ObjectID>B8C734A3-0407-4828-A3AF-9EC38A4A7084</a:ObjectID>
<a:Name>GroupFunc</a:Name>
<a:TextTargetItem.Value>avg()
count()
max()
min()
sum()</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of SQL functions to use with group keywords.</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o37">
<a:ObjectID>1997444A-6E38-441F-BB1A-01CFFAC96EC4</a:ObjectID>
<a:Name>NumberFunc</a:Name>
<a:TextTargetItem.Value>abs()
degrees()
exp()
ln()
log()
pi()
pow()
radians()
round()
sqrt()
cbrt()
trunc()
float()
float4()
integer()
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of SQL functions used on numbers</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o38">
<a:ObjectID>08A5913D-0845-4676-B284-5E02B34DFC49</a:ObjectID>
<a:Name>CharFunc</a:Name>
<a:TextTargetItem.Value>char()
char_length()
character_length()
initcap()
lower()
lpad()
ltrim()
octet_length()
position()
rpad()
rtrim()
substr()
substring()
text()
textpos()
translate()
trim()
upper()
varchar()
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of SQL functions for characters and strings</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o39">
<a:ObjectID>4E9B8DD2-C3C8-431A-83B1-84AEDB98B887</a:ObjectID>
<a:Name>DateFunc</a:Name>
<a:TextTargetItem.Value>abstime()
age()
date_part()
date_trunc()
interval()
isfinite()
reltime()
timestamp()
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of SQL functions for dates</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o40">
<a:ObjectID>50363314-58C8-4960-BA9D-4F69F83815FB</a:ObjectID>
<a:Name>ConvertFunc</a:Name>
<a:TextTargetItem.Value>to_char()
to_date()
to_timestamp()
to_number()</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of SQL functions used to convert values between hex and integer and handling strings</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o41">
<a:ObjectID>E0B49A16-9386-4F77-ABD8-B00A609C8F41</a:ObjectID>
<a:Name>OtherFunc</a:Name>
<a:TextTargetItem.Value>coalesce()
nullif()
area()
box()
center()
circle()
diameter()
height()
isclosed()
isoldpath()
isopen()
length()
lseg()
npoint()
path()
pclose()
point()
polygon()
popen()
radius()
revertpoly()
upgradepath()
upgradepoly()
width()
broadcast()
host()
masklen()
netmask()
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of other SQL functions</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o42">
<a:ObjectID>8763140B-F7FB-4D02-9792-2F532B3C42DE</a:ObjectID>
<a:Name>ListOperators</a:Name>
<a:TextTargetItem.Value>-
!
!!
#
%
&
*
*=
/
@
^
|
|/
||
||/
~
+
<
< all
< any
<<
<=
<= all
<= any
<>
<> all
<> any
=
= all
= any
=*
>
> all
> any
>=
>= all
>= any
>>
and
between
exists
in
is
is not
like
not
not between
not exists
not in
not like
or</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of operators for comparing values, boolean, and various semantic operators</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o43">
<a:ObjectID>6B334218-ED13-4F55-93CC-9B462934CDCD</a:ObjectID>
<a:Name>Commit</a:Name>
<a:TextTargetItem.Value>commit</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for validating the transaction by OBDC</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o44">
<a:ObjectID>F9D5F8F9-A693-4FD9-897D-A61D7150C44E</a:ObjectID>
<a:Name>ReservedWord</a:Name>
<a:TextTargetItem.Value>ALL
ANALYSE
ANALYZE
AND
ANY
AS
ASC
AUTHORIZATION
BETWEEN
BIGINT
BINARY
BIT
BOOLEAN
BOTH
CASE
CAST
CHAR
CHARACTER
CHECK
COALESCE
COLLATE
COLUMN
CONSTRAINT
CONVERT
CREATE
CROSS
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
DEC
DECIMAL
DEFAULT
DEFERRABLE
DESC
DISTINCT
DO
ELSE
END
EXCEPT
EXISTS
EXTRACT
FALSE
FLOAT
FOR
FOREIGN
FREEZE
FROM
FULL
GRANT
GROUP
HAVING
ILIKE
IN
INITIALLY
INNER
INT
INTEGER
INTERSECT
INTERVAL
INTO
IS
ISNULL
JOIN
LEADING
LEFT
LIKE
LIMIT
LOCALTIME
LOCALTIMESTAMP
NATURAL
NCHAR
NEW
NONE
NOT
NOTNULL
NULL
NULLIF
NUMERIC
OFF
OFFSET
OLD
ON
ONLY
OR
ORDER
OUTER
OVERLAPS
OVERLAY
PLACING
POSITION
PRIMARY
REAL
REFERENCES
RIGHT
ROW
SELECT
SESSION_USER
SETOF
SIMILAR
SMALLINT
SOME
SUBSTRING
TABLE
THEN
TIME
TIMESTAMP
TO
TRAILING
TREAT
TRIM
TRUE
UNION
UNIQUE
USER
USING
VARCHAR
VERBOSE
WHEN
WHERE</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Reserved words</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o45">
<a:ObjectID>E16BAC33-A1FB-4D41-A754-3AB61E287A6A</a:ObjectID>
<a:Name>Objects</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains sub-categories for each type of object in the database, for example: Table, or Reference. Each sub-category contains entries whose values define database commands and object-related characteristics</a:Comment>
<c:Categories>
<o:TargetCategory Id="o46">
<a:ObjectID>5787687A-ED79-4140-AFDB-1BC438B4E1B2</a:ObjectID>
<a:Name>Table</a:Name>
<a:Code>TABL</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"TABLE" // generated code of the table
"TNAME" // name of the table
"TCODE" // code of the table
"TLABL" // comment of the table
"PKEYCOLUMNS" // list of primary key columns. Eg: A, B
"TABLDEFN" // complete body of the table definition. Contains definition of columns, checks and keys
</a:Comment>
<c:Categories>
<o:IntegerTargetItem Id="o47">
<a:ObjectID>D25D7DD8-E18F-4E6C-8EDF-9ECED15275D7</a:ObjectID>
<a:Name>Maxlen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum object code length</a:Comment>
<a:IntegerTargetItem.Value>31</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:TextTargetItem Id="o48">
<a:ObjectID>4B9BC540-BD54-44B9-99E6-999BD9EBF5E3</a:ObjectID>
<a:Name>ConstName</a:Name>
<a:TextTargetItem.Value>CKT_%.U26:TABLE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Constraint name template for check of table</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o49">
<a:ObjectID>F5049524-C037-4724-9519-F2C985F2BFD3</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create [%Temporary% ]table [%QUALIFIER%]%TABLE% (
%TABLDEFN%
)
[%OPTIONS%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a table. Example: create table %TABLE%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o50">
<a:ObjectID>D3C15873-790A-4ACD-BC92-859B7C7C1F0E</a:ObjectID>
<a:Name>Options</a:Name>
<a:TextTargetItem.Value>inherits : composite=yes, parenthesis=yes, separator=yes
{
<parent_table> %s : multiple=yes
}
<special_columns> %s : list=with oids|without oids
on commit %s : list=preserve rows|delete rows|drop
tablespace %s : category=tablespace</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Available options for creating a table</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o51">
<a:ObjectID>BCC29DEE-6F1F-45EE-B38B-41EFD1FFF636</a:ObjectID>
<a:Name>TableComment</a:Name>
<a:TextTargetItem.Value>comment on table [%QUALIFIER%]%TABLE% is
%.q:COMMENT%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1244729550</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Command for adding a table comment</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o52">
<a:ObjectID>71513402-ADFB-4CE2-A73C-56D3D8E26CC8</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop table [%QUALIFIER%]%TABLE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a table. Example: drop table %TABLE%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o53">
<a:ObjectID>5A2D175A-FB8B-4182-A24B-3A863BEB2A49</a:ObjectID>
<a:Name>Rename</a:Name>
<a:TextTargetItem.Value>alter table [%QUALIFIER%]%OLDTABL%
rename to %NEWTABL%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1244729550</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Command for renaming a table</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o54">
<a:ObjectID>9E059BBF-C0DD-4A20-85E0-FEBA2D8A9435</a:ObjectID>
<a:Name>AlterTableHeader</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Alter table header</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o55">
<a:ObjectID>080E3432-3F41-470A-B7A0-C83594DE3E52</a:ObjectID>
<a:Name>AlterTableFooter</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Alter table footer</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o56">
<a:ObjectID>7524AF71-E973-4D57-98BF-86C82A19CF11</a:ObjectID>
<a:Name>DefineTableCheck</a:Name>
<a:TextTargetItem.Value>[constraint %CONSTNAME% ]check (%.A:CONSTRAINT%)</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Allows to customize the script of table check constraints</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o57">
<a:ObjectID>DC6A6F24-AE59-494D-986E-7727698D9C48</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Table allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o58">
<a:ObjectID>8B726C93-8587-4D14-89DD-AB4744CF7677</a:ObjectID>
<a:Name>AddTableCheck</a:Name>
<a:TextTargetItem.Value>alter table [%QUALIFIER%]%TABLE%
add [constraint %CONSTNAME% ]check (%.A:CONSTRAINT%)</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1244729550</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Allows to customize the script for modifying table constraints within an alter table statement</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o59">
<a:ObjectID>BA26AAF4-1E2B-40AF-BE30-F3B8F1BD6E95</a:ObjectID>
<a:Name>DropTableCheck</a:Name>
<a:TextTargetItem.Value>alter table [%QUALIFIER%]%TABLE%
drop constraint %CONSTNAME%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1244729550</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Command for dropping a table check in an alter table statement</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o60">
<a:ObjectID>B99A5700-27CC-45D8-B3C9-04218133C0D9</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, TABLE_TYPE, COMMENT}
select
pg_get_userbyid(t.relowner),
t.relname,
case substring(t.relname from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE'
end::varchar,
obj_description(t.oid, 'pg_class')
from
pg_class t
where
t.relkind = 'r'
[ and pg_get_userbyid(t.relowner) = %.q:SCHEMA%]
order by 1, 2</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908013</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o61">
<a:ObjectID>81F8F744-2727-402B-BC1A-5B056B1E571E</a:ObjectID>
<a:Name>AfterCreate</a:Name>
<a:TextTargetItem.Value>[%OWNER%?%SetOwnership%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1257761737</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Commands executed after create statement</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o62">
<a:ObjectID>D46478F3-F5A2-45CA-811E-BCE8CF3780F0</a:ObjectID>
<a:Name>SqlChckQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, CONSTNAME, CONSTRAINT}
select
pg_get_userbyid(t.relowner),
t.relname,
k.conname,
k.consrc
from
pg_constraint k
join pg_class t on (t.oid = k.conrelid)
where
k.contype = 'c'
and k.conrelid != 0
[ and pg_get_userbyid(t.relowner) = %.q:OWNER%]
[ and t.relname = %.q:TABLE%]
and array_dims(k.conkey) != '[1:1]' -- a table constraint applies on more than one column !
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to reverse object check constraints</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o63">
<a:ObjectID>3B8C614F-A6CB-47E9-A1C9-4AD0464951C1</a:ObjectID>
<a:Name>SetOwnership</a:Name>
<a:TextTargetItem.Value>.ifnot(%Owner.Schema%)
[-- set table ownership
]alter table [%QUALIFIER%]%TABLE% owner to [%R%?%NEWOWNER%:%OWNER%]
;
.endif()</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1257761811</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
</o:TextTargetItem>
<o:TextTargetItem Id="o64">
<a:ObjectID>070CDD2B-026F-46B2-B53A-F06EB48A65C4</a:ObjectID>
<a:Name>ReversedStatements</a:Name>
<a:TextTargetItem.Value>SetOwnership</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Additional statements to be reversed by script</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o65">
<a:ObjectID>DCBEC306-5F49-4294-B8B8-CFA0610D68B7</a:ObjectID>
<a:Name>SqlOptsQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, OPTIONS}
select
pg_get_userbyid(t.relowner),
t.relname,
case (t.relhasoids) when '1' then 'with oids' else 'without oids' end
||case when (t.reltablespace = 0) then '' else ' tablespace ' || (select s.spcname from pg_tablespace s where s.oid = t.reltablespace) end as coln
from
pg_class t
where
t.relkind = 'r'
[ and pg_get_userbyid(t.relowner) = %.q:SCHEMA%]
order by 1, 2</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to reverse object physical options</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o66">
<a:ObjectID>D469C1EC-3699-4486-B3C1-22A547A4D775</a:ObjectID>
<a:Name>Index</a:Name>
<a:Code>INDX</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
(parent table items are also available for indexes)
"INDEX" // generated code of the index
"INDEXNAME" // index name
"INDEXCODE" // index code
"UNIQUE" // keyword "unique" when the index is unique
"INDEXTYPE" // index type (available only for a few DBMS)
"INDEXKEY" // keywords "primary", "unique" or "foreign" depending on the index origin
"CIDXLIST" // list of index columns. Eg: A asc, B desc, C asc
"CLUSTER" // keyword "cluster" when the index is cluster
For index columns, the following system variables are available:
"ASC" // keywords "ASC" or "DESC" depending on sort order
"ISASC" // TRUE if the index column sort is ascending
</a:Comment>
<c:Categories>
<o:IntegerTargetItem Id="o67">
<a:ObjectID>6A266B2C-8C89-4333-B581-01FE4683BD49</a:ObjectID>
<a:Name>Maxlen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum object code length</a:Comment>
<a:IntegerTargetItem.Value>31</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:IntegerTargetItem Id="o68">
<a:ObjectID>158351C4-310E-4E60-AD98-A8AE9C963ABF</a:ObjectID>
<a:Name>MaxColIndex</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum number of columns in an index</a:Comment>
<a:IntegerTargetItem.Value>16</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:BooleanTargetItem Id="o69">
<a:ObjectID>A6311922-FFDD-48A8-BFF1-99B7FA752D4D</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Index allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o70">
<a:ObjectID>63D26606-B484-4A2C-AC86-C366BF8E2124</a:ObjectID>
<a:Name>EnableAscDesc</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>ASC, DESC keywords allowed</a:Comment>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o71">
<a:ObjectID>E67A82C2-24E0-4C5E-AB7C-CAEE31E7DDCF</a:ObjectID>
<a:Name>UniqName</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Unique index name in the database</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o72">
<a:ObjectID>C26CDC7E-654B-40BD-AB1E-A55CD2DF68D3</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create [%UNIQUE%] index %INDEX% on %TABLE%[ using %INDEXTYPE%] (
%CIDXLIST%
)
[%OPTIONS%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating an index. Example: create index %INDEX%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o73">
<a:ObjectID>AA8102D0-D4B0-4812-B4F4-25318309F35B</a:ObjectID>
<a:Name>AddColIndex</a:Name>
<a:TextTargetItem.Value>%COLUMN%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for defining an index column</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o74">
<a:ObjectID>A496C837-C471-4255-A9A1-E7ADA47099A2</a:ObjectID>
<a:Name>Options</a:Name>
<a:TextTargetItem.Value>tablespace %s : category=tablespace
where %s</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Default options for creating an index</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o75">
<a:ObjectID>89E10A37-4899-40B7-BDEF-EF62CC4EEA5A</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop index %INDEX%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping an index. Example: drop index %INDEX%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o76">
<a:ObjectID>A3892D84-13EC-4B8D-88D6-C7F04A4F2FD7</a:ObjectID>
<a:Name>IndexType</a:Name>
<a:TextTargetItem.Value>BTREE
RTREE
HASH</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>List of types available for an index</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o77">
<a:ObjectID>19D48614-2538-48BD-80E4-E9E932CEEDE5</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, INDEX, UNIQUE, INDEXTYPE, CIDXLIST}
select
pg_get_userbyid(t.relowner),
t.relname,
i.relname,
case when (x.indisunique) then 'unique' else '' end,
(select c.amname from pg_am c where c.oid = i.relam),
pg_get_indexdef(x.indexrelid, 1, True)
|| case when (x.indnatts > 1) then ', ' || pg_get_indexdef(x.indexrelid, 2, True) else '' end
|| case when (x.indnatts > 2) then ', ' || pg_get_indexdef(x.indexrelid, 3, True) else '' end
|| case when (x.indnatts > 3) then ', ' || pg_get_indexdef(x.indexrelid, 4, True) else '' end
|| case when (x.indnatts > 4) then ', ' || pg_get_indexdef(x.indexrelid, 5, True) else '' end
|| case when (x.indnatts > 5) then ', ' || pg_get_indexdef(x.indexrelid, 6, True) else '' end
|| case when (x.indnatts > 6) then ', ' || pg_get_indexdef(x.indexrelid, 7, True) else '' end
|| case when (x.indnatts > 7) then ', ' || pg_get_indexdef(x.indexrelid, 8, True) else '' end as coln
from
pg_class t
join pg_index x on (x.indrelid = t.oid and x.indisprimary is false)
join pg_class i on (i.oid = x.indexrelid)
where 1=1
[ and pg_get_userbyid(t.relowner)=%.q:OWNER%]
[ and t.relname=%.q:TABLE%]
order by 1, 2, 3
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o78">
<a:ObjectID>690BA164-502C-4CD7-87D2-9D103EC03A9D</a:ObjectID>
<a:Name>EnableFunction</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Function-based indexes allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o79">
<a:ObjectID>F6066718-C8EF-4569-9A40-03BC0A51237D</a:ObjectID>
<a:Name>SqlOptsQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, INDEX, OPTIONS}
select
pg_get_userbyid(t.relowner),
t.relname,
i.relname,
case when (i.reltablespace = 0) then '' else 'tablespace ' || (select s.spcname from pg_tablespace s where s.oid = i.reltablespace) end
||case when (x.indpred is null) then '' else ' where ' || pg_get_expr(x.indpred, t.oid, false) end as coln
from
pg_class t
join pg_index x on (x.indrelid = t.oid and x.indisprimary is false)
join pg_class i on (i.oid = x.indexrelid)
where (i.reltablespace != 0) or (x.indpred is not null)
[ and pg_get_userbyid(t.relowner) = %.q:OWNER%]
[ and t.relname = %.q:TABLE%]
[ and i.relname = %.q:INDEX%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to reverse object physical options</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o80">
<a:ObjectID>12961F66-AA6A-46EF-B73E-0429D5753729</a:ObjectID>
<a:Name>Sequence</a:Name>
<a:Code>SQNC</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"SQNC" // generated code of the sequence
</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o81">
<a:ObjectID>2590B828-ED12-472D-BD57-6C94ACB0018D</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Sequence allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o82">
<a:ObjectID>E8D096B7-6265-4F0A-827E-AA7D09CD2D75</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create sequence %SQNC%
[%OPTIONS%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command to create a sequence</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o83">
<a:ObjectID>04BD7462-001C-4E2A-9549-28DB02D36F04</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop sequence %SQNC%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command to drop a sequence</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o84">
<a:ObjectID>15DD78FF-1E58-44E3-8F0F-3B3B308D4E0F</a:ObjectID>
<a:Name>Options</a:Name>
<a:TextTargetItem.Value>increment %d
minvalue %d
maxvalue %d
start %d
cache %d
cycle
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Options for creating a sequence</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o85">
<a:ObjectID>E063B299-96AF-4761-8BAF-F0C68AEBF420</a:ObjectID>
<a:Name>DefOptions</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Default values for sequence options</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o86">
<a:ObjectID>1BE49214-419D-45F0-A7C4-5317B5191708</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{SQNC}
select
s.relname
from
pg_class s
where
s.relkind = 'S'
order by 1</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o87">
<a:ObjectID>089823CE-5C3C-4E6C-8ADC-853E7EFEB8A5</a:ObjectID>
<a:Name>SqlAttrQuery</a:Name>
<a:TextTargetItem.Value>{SQNC, OPTIONS}
select
s.sequence_name,
('increment ' || (increment_by::varchar))::varchar
from
[%QUALIFIER%]%SQNC% s
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to reverse object attributes</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o88">
<a:ObjectID>780D038C-ECD5-4745-8A4A-101DB3C07F68</a:ObjectID>
<a:Name>Rename</a:Name>
<a:TextTargetItem.Value>rename %OLDNAME% to %NEWNAME%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for renaming a sequence</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o89">
<a:ObjectID>FF3844ED-6B0B-40E6-937B-917D5CB424A8</a:ObjectID>
<a:Name>Column</a:Name>
<a:Code>COLN</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
(parent table items are also available for columns)
"COLUMN" // generated code of the column
"COLNNO" // position of the column in the list of columns of the table
"COLNNAME" // name of the column
"COLNCODE" // code of the column
"PRIMARY" // keyword "primary" if the column is primary
"ISPKEY" // TRUE if the column is part of the primary key
"FOREIGN" // TRUE if the column is part of one foreign key
</a:Comment>
<c:Categories>
<o:IntegerTargetItem Id="o90">
<a:ObjectID>828D9749-94BF-484F-A06C-5C7B1F960903</a:ObjectID>
<a:Name>Maxlen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum object code length</a:Comment>
<a:IntegerTargetItem.Value>31</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:BooleanTargetItem Id="o91">
<a:ObjectID>CB82A9E9-FDD3-49DA-BA2F-8DFF3D31F8B8</a:ObjectID>
<a:Name>EnableDefault</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Default values allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o92">
<a:ObjectID>09695073-87B8-48F8-98FF-93E405631B92</a:ObjectID>
<a:Name>ConstName</a:Name>
<a:TextTargetItem.Value>CKC_%.U17:COLUMN%_%.U8:TABLE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Constraint name template for a column check parameter</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o93">
<a:ObjectID>8AC0DE6C-5EC7-4F0D-A25F-9446CC0E9101</a:ObjectID>
<a:Name>Add</a:Name>
<a:TextTargetItem.Value>%20:COLUMN% [%IDENTITY%?SERIAL:%20:DATATYPE%][.Z:[ %NULL%][ %NOTNULL%][ default %DEFAULT%]
[%CONSTDEFN%]]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for defining a table column</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o94">
<a:ObjectID>1A0A97C8-7902-4E80-85DE-03EB9F1C78B9</a:ObjectID>
<a:Name>ColumnComment</a:Name>
<a:TextTargetItem.Value>comment on column %TABLE%.%COLUMN% is
%.q:COMMENT%
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for adding a column comment</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o95">
<a:ObjectID>2F9C3E97-9D17-4AA8-A23F-B766F9C7EE8E</a:ObjectID>
<a:Name>Rename</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
rename %OLDCOLN% to %NEWCOLN%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for renaming a column</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o96">
<a:ObjectID>6484FA2C-0C2D-4297-B18B-C4CE8E6E33DB</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
add[ column] %COLUMN% %DATATYPE%[%DEFAULT%? default %DEFAULT%] </a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1370501484</a:ModificationDate>
<a:Modifier>I063968</a:Modifier>
<a:Comment>Command for adding a column</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o97">
<a:ObjectID>69CDADE9-BDB7-45A9-9992-0DA3A03A3A37</a:ObjectID>
<a:Name>Drop</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a column
Not yet supported. Should be
alter table %TABLE% drop[ column] %COLUMN% [restrict | cascade]
</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o98">
<a:ObjectID>827206FF-8FAC-4D38-A0A3-BEA2E85EBDCC</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Column allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o99">
<a:ObjectID>A0B859F4-3181-4865-9A5B-80B41DA085CA</a:ObjectID>
<a:Name>ModifyColnDflt</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
alter[ column] %COLUMN% [%DEFAULT%?set default %DEFAULT%:drop default]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for modifying a column default in an alter table statement</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o100">
<a:ObjectID>B18B751A-E445-443A-B4C6-99B933BFD22A</a:ObjectID>
<a:Name>EnableIdentity</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Identity keyword entry support. Identity columns are serial counters maintains by the database</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o101">
<a:ObjectID>73CB8FE3-BCD6-4A0A-9A77-3370E9690128</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, COLUMN, DTTPCODE, LENGTH, PREC, ISMAND, DEFAULT, COMMENT}
select
pg_get_userbyid(t.relowner),
t.relname,
c.attname,
case(c.attndims) when 0 then d.typname else (select x.typname from pg_type x where x.oid = d.typelem) || '[]' end,
case(c.atttypmod >> 16) when 0 then (c.atttypmod - ((c.atttypmod >> 16)<<16) - 4) else (c.atttypmod >> 16) end,
case(c.atttypmod >> 16) when 0 then 0 else (c.atttypmod - 65536 * (c.atttypmod / 65536) - 4) end,
CAST(NULLIF(c.attnotnull,false) as VARCHAR(10)),
case(c.atthasdef)
when true then (select adsrc::varchar from pg_attrdef f where f.adrelid = t.oid and f.adnum = c.attnum)::varchar
else '' end::varchar as coln,
col_description(t.oid, c.attnum)
from
pg_class t
join pg_attribute c on (c.attrelid = t.oid and c.attnum > 0 and c.attisdropped is false)
join pg_type d on (d.oid = c.atttypid)
where t.relkind = 'r'
[ and pg_get_userbyid(t.relowner) = %.q:OWNER%]
[ and t.relname = %.q:TABLE%]
order by 1, 2, c.attnum</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1614343383</a:ModificationDate>
<a:Modifier>w00484080</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o102">
<a:ObjectID>32224D8A-DF82-45F5-B446-39F2272E16EA</a:ObjectID>
<a:Name>SqlChckQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, COLUMN, CONSTNAME, CONSTRAINT}
select
pg_get_userbyid(t.relowner), t.relname, c.attname, k.conname, k.consrc
from
pg_constraint k
join pg_class t on (t.oid = k.conrelid)
join pg_attribute c on (c.attrelid = t.oid and c.attnum > 0 and c.attnum = k.conkey[1])
where
k.contype = 'c'
and k.conrelid != 0
and array_dims(k.conkey) = '[1:1]' -- a column constraint applies on only one column !
[ and pg_get_userbyid(t.relowner) = %.q:OWNER%]
[ and t.relname = %.q:TABLE%]
[ and c.attname = %.q:COLUMN%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341909104</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to reverse object check constraints</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o103">
<a:ObjectID>A7FBC232-1BEB-4789-8E22-0148B2ABA21E</a:ObjectID>
<a:Name>DefineColnChck</a:Name>
<a:TextTargetItem.Value>[%R%?[[foreign key (%S%) ]references %S%[(%S%)][ with no index]][%ISPKEY%?[constraint %PKNAME% ]primary key ][%ISAKEY%?[constraint %AKNAME% ]unique ]][[constraint %CONSTNAME%] check (%.A:CONSTRAINT%)]
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Allows to customize the script of column check constraints</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:IntegerTargetItem Id="o104">
<a:ObjectID>4F5CF591-46F1-489C-BB52-8456FC8F6387</a:ObjectID>
<a:Name>MaxConstLen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum constraint name length</a:Comment>
<a:IntegerTargetItem.Value>31</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:BooleanTargetItem Id="o105">
<a:ObjectID>162F26E6-8FF1-42AD-B4E8-F671074E05DF</a:ObjectID>
<a:Name>EnableOption</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Physical options allowed YES/NO</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TargetCategory Id="o106">
<a:ObjectID>00D9D8AE-E5D1-456C-9E00-6413C2F27450</a:ObjectID>
<a:Name>Reference</a:Name>
<a:Code>REFR</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"REFR" // generated code of the reference
"REFNAME" // reference name
"PARENT" // generated code of the parent table
"PNAME" // name of the parent table
"PCODE" // code of the parent table
"CHILD" // generated code of the reference
"CNAME" // name of the child table
"CCODE" // code of the child table
"PQUALIFIER" // qualifier of the parent table. See QUALIFIER
"CQUALIFIER" // qualifier of the child table. See QUALIFIER
"REFRNAME" // Reference name
"REFRCODE" // Reference code
"FKCONSTRAINT" // Reference constraint name (foreign key)
"PKCONSTRAINT" // constraint name of the parent key used to reference object
"CKEYCOLUMNS" // list of parent key columns. Eg: C1, C2, C3
"FKEYCOLUMNS" // list of child foreign key columns. Eg:
"UPDCONST" // Update declarative constraint. Keywords "restrict", "cascade", "set null" or "set default"
"DELCONST" // Delete declarative constraint. Keywords "restrict", "cascade", "set null" or "set default"
"MINCARD" // Min cardinality
"MAXCARD" // Max cardinality
"POWNER" // Parent table owner
"COWNER" // child table owner
"CHCKONCMMT" // TRUE when check on commit is selected on the reference (ASA 6.0 specific)
For reference joins (couple of column in a reference),
the following system variables are available:
"CKEYCOLUMN" // generated code of the parent table column (primary key)
"FKEYCOLUMN" // generated code of the child table column (foreign key)
"PK" // primary key column generated code
"PKNAME" // primary key column name
"FK" // foreign key column generated code
"FKNAME" // foreign key column name
"AK" // alternate key column code (same as PK)
"AKNAME" // alternate key column name (same as PKNAME)
"COLTYPE" // primary column column datatype
"DEFAULT" // foreign key column default value
</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o107">
<a:ObjectID>EB1D6CAE-4F39-40A9-A085-7E520D794CC3</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Foreign key allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o108">
<a:ObjectID>9CFA076E-382C-4E94-BD87-C8B9A0279178</a:ObjectID>
<a:Name>FKAutoIndex</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Foreign key is auto-indexed</a:Comment>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o109">
<a:ObjectID>2C3A75D2-AF8F-4B73-8811-088384CF5768</a:ObjectID>
<a:Name>ConstName</a:Name>
<a:TextTargetItem.Value>FK_%.U8:CHILD%_%.U9:REFR%_%.U8:PARENT%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Constraint name template for foreign keys</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o110">
<a:ObjectID>EC2AEA60-0853-4A0D-A257-CF973D2C1422</a:ObjectID>
<a:Name>CheckOnCommit</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Referential integrity test differed after the COMMIT</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o111">
<a:ObjectID>D2D10DAE-E158-45A1-A6C6-494BE005B975</a:ObjectID>
<a:Name>Add</a:Name>
<a:TextTargetItem.Value>[constraint %CONSTNAME% ]foreign key (%FKEYCOLUMNS%)
references %PARENT%[ (%CKEYCOLUMNS%)]
[ on delete %DELCONST%][ on update %UPDCONST%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for defining a foreign key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o112">
<a:ObjectID>78ED96D5-7585-4E89-91E2-BAA53B8B5A28</a:ObjectID>
<a:Name>DclUpdIntegrity</a:Name>
<a:TextTargetItem.Value>RESTRICT
CASCADE
SET NULL
SET DEFAULT
NONE</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Declarative referential integrity constraint allowed for update</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o113">
<a:ObjectID>317E3894-CA93-4320-8BDD-0B71E3C76394</a:ObjectID>
<a:Name>DclDelIntegrity</a:Name>
<a:TextTargetItem.Value>RESTRICT
CASCADE
SET NULL
SET DEFAULT
NONE</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Declarative referential integrity constraint allowed for delete</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o114">
<a:ObjectID>D60B0ACA-00FB-4AB4-809C-38AD4FEADB2D</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
add [constraint %CONSTNAME% ]foreign key (%FKEYCOLUMNS%)
references %PARENT%[ (%CKEYCOLUMNS%)]
[ on delete %DELCONST%][ on update %UPDCONST%][%Deferrable%? deferrable[%ForeignKeyConstraintDeferred%? initially deferred: initially immediate]]
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for adding a foreign key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o115">
<a:ObjectID>CCBCF292-6A8A-496A-AB10-81DC9B1D60A0</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{POWNER, PARENT, COWNER, CHILD, CONSTNAME, Deferrable, ForeignKeyConstraintDeferred, UPDCONST, DELCONST, FKEYCOLUMNS, CKEYCOLUMNS}
select
pg_get_userbyid(p.relowner),
p.relname,
pg_get_userbyid(c.relowner),
c.relname,
k.conname,
case when (k.condeferrable) then 'true' else 'false' end,
case when (k.condeferred) then 'true' else 'false' end,
case(k.confupdtype) when 'r' then 'restrict' when 'c' then 'cascade' when 'n' then 'set null' when 'd' then 'set default' else 'no action' end::varchar as colnA,
case(k.confdeltype) when 'r' then 'restrict' when 'c' then 'cascade' when 'n' then 'set null' when 'd' then 'set default' else 'no action' end::varchar as colnB,
substring(substring(pg_get_constraintdef(k.oid) from 'FOREIGN KEY (.*) REFERENCES') from 2 for char_length(substring(pg_get_constraintdef(k.oid) from 'FOREIGN KEY (.*) REFERENCES')) - 2) as colnC,
substring(substring(pg_get_constraintdef(k.oid) from 'REFERENCES '||p.relname||'(.*)') from 2 for position(')' in substring(pg_get_constraintdef(k.oid) from 'REFERENCES '||p.relname||'(.*)') ) - 2) as colnD
from
pg_constraint k
join pg_class p on (p.oid = k.confrelid)
join pg_class c on (c.oid = k.conrelid)
where
k.contype = 'f'
[ and pg_get_userbyid(c.relowner) = %.q:OWNER%]
[ and c.relname=%.q:TABLE%]
order by 1, 2, 3, 4, 5</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o116">
<a:ObjectID>394D6E77-60DA-41C7-89D4-FB9783581615</a:ObjectID>
<a:Name>PKey</a:Name>
<a:Code>PKEY</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
(parent table items are also available for keys)
"PKEYCOLUMNS" // list of primary key columns. Eg: A, B
"ISPKEY" // TRUE when the key is the primary key of the table
"KEY" // constraint name
"PKEY" // constraint name for primary key
"AKEY" // constraint name for alternate key
"ISMULTICOLN" // TRUE if key has more than one column
"CLUSTER" // keyword cluster</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o117">
<a:ObjectID>FD4344E9-E9CC-4B7C-9BB0-4E4EED0CEE72</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Primary key allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o118">
<a:ObjectID>35F0CA00-8A94-4D42-A911-F9BCFF8C206D</a:ObjectID>
<a:Name>PkAutoIndex</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Primary key is auto-indexed</a:Comment>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o119">
<a:ObjectID>9E64641C-FC08-4E73-9433-D69D614EC61D</a:ObjectID>
<a:Name>ConstName</a:Name>
<a:TextTargetItem.Value>PK_%.U27:TABLE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Constraint name template for primary keys</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o120">
<a:ObjectID>7F2E72C1-2E4C-4159-8942-AAFA742A4131</a:ObjectID>
<a:Name>Add</a:Name>
<a:TextTargetItem.Value>[constraint %CONSTNAME% ]primary key (%PKEYCOLUMNS%)</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for defining a primary key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o121">
<a:ObjectID>303ED984-E4BB-4FAA-BF86-95DBBBCCF697</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
add [constraint %CONSTNAME% ]primary key (%PKEYCOLUMNS%)
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for adding a primary key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o122">
<a:ObjectID>C02EC114-6CBB-45B1-B4B5-6B7E3CEBED89</a:ObjectID>
<a:Name>Options</a:Name>
<a:TextTargetItem.Value>using index tablespace %s</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Available options for creating a primary key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o123">
<a:ObjectID>6CBAA878-3E66-4E06-B35F-9BCA1250C13A</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
drop constraint %CONSTNAME%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a primary key</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o124">
<a:ObjectID>5CA1DDBD-771A-4DEE-99A2-325F82A15288</a:ObjectID>
<a:Name>Key</a:Name>
<a:Code>KEY</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
(parent table items are also available for keys)
"COLUMNS" // List of columns of the key. Eg: "A, B, C"
"ISPKEY" // TRUE when the key is the primary key of the table
"KEY" // constraint name
"PKEY" // constraint name for primary key
"AKEY" // constraint name for alternate key
"ISMULTICOLN" // TRUE if key has more than one column
"CLUSTER" // keyword cluster
</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o125">
<a:ObjectID>B6AA8161-11E3-42C4-AD8C-5B8E0804508A</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>UNIQUE constraint allowed for tables</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o126">
<a:ObjectID>29F6C46C-6412-4DE9-97FC-6BF9ED12C4F6</a:ObjectID>
<a:Name>UniqConstAutoIndex</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>UNIQUE constraint is auto-indexed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o127">
<a:ObjectID>FE710D18-9664-4853-860B-089C2AC56D43</a:ObjectID>
<a:Name>ConstName</a:Name>
<a:TextTargetItem.Value>AK_%.U18:AKEY%_%.U8:TABLE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Constraint name template for alternate keys</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o128">
<a:ObjectID>3E8D0AD3-B254-4556-9885-B6D603C45759</a:ObjectID>
<a:Name>Add</a:Name>
<a:TextTargetItem.Value>[constraint %CONSTNAME% ]unique (%COLUMNS%)</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for defining an alternate key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o129">
<a:ObjectID>B946017B-7EB2-4E25-8864-27BFB6774ED0</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
add [constraint %CONSTNAME% ]unique (%COLUMNS%)</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for adding an alternate key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o130">
<a:ObjectID>BDE692C1-B51D-48EB-81FB-0BFCF3B49572</a:ObjectID>
<a:Name>Options</a:Name>
<a:TextTargetItem.Value>using index tablespace %s
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Available options for an alternate key</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o131">
<a:ObjectID>619ECBA7-A1D2-4EE3-B8C9-F811E7CC0290</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER ID, TABLE ID, CONSTNAME ID, ISPKEY ID, COLUMNS ...}
select
pg_get_userbyid(t.relowner),
t.relname,
i.relname,
CAST(NULLIF(x.indisprimary,false) as VARCHAR(10)),
a.attname || ','::varchar
from
pg_index x
join pg_class t on (t.oid = x.indrelid and t.relkind = 'r')
join pg_class i on (i.oid = x.indexrelid)
join pg_attribute a on (a.attrelid = i.oid)
where x.indisprimary is true
[ and pg_get_userbyid(t.relowner)=%.q:OWNER%]
[ and t.relname=%.q:TABLE%]
order by 1, 2, 3, a.attnum
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1614343383</a:ModificationDate>
<a:Modifier>w00484080</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o132">
<a:ObjectID>C32D12FB-648F-4281-B1D7-0BE9540242C9</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>alter table %TABLE%
drop constraint %CONSTNAME%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping an alternate key</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o133">
<a:ObjectID>5C93D4F0-AD9E-4ACC-90D2-F4A90002BE81</a:ObjectID>
<a:Name>Database</a:Name>
<a:Code>DTBS</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"DATABASE" // generated code of the database
</a:Comment>
<c:Categories>
<o:TextTargetItem Id="o134">
<a:ObjectID>D00C6FC9-2B52-4462-B5B2-C46605197C05</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create database %DATABASE%
[ [%R%?with ][.Z:[ template[ =] %Template%][ encoding[ =] %.q:Encoding%][ tablespace[ =] %OPTIONS%]]]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a database. Example: create database %DATABASE%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o135">
<a:ObjectID>1347A7DC-CC8D-4365-B8B7-AC815C936A87</a:ObjectID>
<a:Name>OpenDatabase</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for opening a database. Example: open database %DATABASE%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o136">
<a:ObjectID>883CDA80-551C-43E7-A0FA-19468A55E254</a:ObjectID>
<a:Name>CloseDatabase</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for closing a database. Example: close database</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o137">
<a:ObjectID>527489B6-A8CA-491E-82A9-FB300D10904D</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop database %DATABASE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a database. Example: drop database %DATABASE%</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o138">
<a:ObjectID>6271B61C-5571-4923-AD35-50AE6044E279</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Database allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o139">
<a:ObjectID>7B94D113-E137-4FF2-B383-A8FB0E129E1D</a:ObjectID>
<a:Name>EnableManyDatabases</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Many databases allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o140">
<a:ObjectID>43028201-52E6-4DC1-B48D-EBECCDC7EE94</a:ObjectID>
<a:Name>Options</a:Name>
<a:TextTargetItem.Value><tablespace> %s : category=TABLESPACE</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Available options for creating a database</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o141">
<a:ObjectID>E616EC6E-2767-4410-BC15-764AA6B67647</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{DATABASE, COMMENT, Encoding, OPTIONS}
select
d.datname,
obj_description(d.oid, 'pg_database'),
pg_encoding_to_char(d.encoding),
(select t.spcname from pg_tablespace t where t.oid = d.dattablespace)
from
pg_database d
order by 1</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o142">
<a:ObjectID>6D6DC36E-2660-47B5-9731-E97BB1AFC19C</a:ObjectID>
<a:Name>View</a:Name>
<a:Code>VIEW</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"VIEW" // generated code of the view
"VIEWNAME" // view name
"VIEWCODE" // view code
"VIEWCOLN" // List of columns of the view. Eg: "A, B, C"
"SQL" // SQL text of the view. Eg: Select * from T1
"VIEWCHECK" // Keyword "with check option" if selected on the view
"SCRIPT" // complete view creation order. Eg: create view V1 as select * from T1
</a:Comment>
<c:Categories>
<o:TextTargetItem Id="o143">
<a:ObjectID>60C4C986-06CB-4FB0-80C1-7444D0E2DD0F</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create[ or replace] view %VIEW%[ (%VIEWCOLN%)] as
%SQL%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a view. Example: create view %VIEW%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o144">
<a:ObjectID>D7F80660-A729-463E-8715-6602F92DAA4A</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop view %VIEW%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a view. Example: drop view %VIEW%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o145">
<a:ObjectID>A2DF1F7F-1FE8-4053-898C-741F30BD0E32</a:ObjectID>
<a:Name>ViewComment</a:Name>
<a:TextTargetItem.Value>comment on view %VIEW% is
%.q:COMMENT%
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for adding a view comment.</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o146">
<a:ObjectID>A65C3C8D-4FF8-4BAC-B525-7B7C0A85BA0E</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, VIEW}
select
pg_get_userbyid(t.relowner),
t.relname
from
pg_class t
where t.relkind = 'v'
[ and pg_get_userbyid(t.relowner) = %.q:SCHEMA%]
order by 1, 2</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o147">
<a:ObjectID>9E32900C-BF73-416C-8A2B-EF1770CB4D13</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>View allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o148">
<a:ObjectID>FAED4860-650D-4088-B0E6-574FD05B32A5</a:ObjectID>
<a:Name>SqlAttrQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, VIEW, SQL}
select
pg_get_userbyid(v.relowner),
v.relname,
pg_get_viewdef(v.oid)
from
pg_class v
where v.relkind = 'v'
[ and pg_get_userbyid(v.relowner) = %.q:OWNER%]
[ and v.relname = %.q:VIEW%]
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to reverse object attributes</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o149">
<a:ObjectID>7B673B74-71BD-423E-80F6-670FFCDA0C25</a:ObjectID>
<a:Name>SetOwnership</a:Name>
<a:TextTargetItem.Value>[-- set view ownership
]alter table %VIEW% owner to %OWNER%
;</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
</o:TextTargetItem>
<o:TextTargetItem Id="o150">
<a:ObjectID>4AD2B5CD-4B14-41DE-AA40-2A9977165E28</a:ObjectID>
<a:Name>AfterCreate</a:Name>
<a:TextTargetItem.Value>[%OWNER%?%SetOwnership%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Commands executed after create statement</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o151">
<a:ObjectID>B5AABC8F-D6D9-49DE-8200-FC6813E9259F</a:ObjectID>
<a:Name>ReversedStatements</a:Name>
<a:TextTargetItem.Value>SetOwnership</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Additional statements to be reversed by script</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o152">
<a:ObjectID>315292D9-F98A-4EE5-B761-6515CB98B37C</a:ObjectID>
<a:Name>Domain</a:Name>
<a:Code>PDMDOMN</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"DOMAIN" // generated code of the domain (also available for columns)
SQL Server specific domain system variables:
"RULENAME" // name of the rule object associated with the domain
"DEFAULTNAME" // name of the default object associated with the domain
</a:Comment>
<c:Categories>
<o:TextTargetItem Id="o153">
<a:ObjectID>609E7A72-CC2A-4D04-A138-92795CBEACC9</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>[%Stereotype%=CompositeType?create type [%QUALIFIER%]%DOMAIN% as (%CompositeDefinition%):[%Stereotype%=BaseType?create type [%QUALIFIER%]%DOMAIN% ([.Z:[
input=%ExtTypeInput%,][
output=%ExtTypeOutput%,][
internallength=%ExtTypeLength%][,
default=%DEFAULT%][,
element=%ExtTypeElement%][,
delimiter=%.q:ExtTypeDelimiter%][,
send=%ExtTypeSend%][,
receive=%ExtTypeReceive%][%ExtTypePassedByValue%?, passedbyvalue]]
):create domain [%QUALIFIER%]%DOMAIN%[ as] %DATATYPE%]]
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a user defined data type</a:Comment>
</o:TextTargetItem>
<o:IntegerTargetItem Id="o154">
<a:ObjectID>C4EF9C30-D684-4430-AE35-A4EE0A89648B</a:ObjectID>
<a:Name>Maxlen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum object code length</a:Comment>
<a:IntegerTargetItem.Value>30</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:BooleanTargetItem Id="o155">
<a:ObjectID>EB4A3477-D194-4ADC-8684-4E398F454C2E</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>User defined data types allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o156">
<a:ObjectID>46CB428B-DC23-4DBE-98CB-EA7BD9DA1E64</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>[%Stereotype%=BaseType?drop type %DOMAIN%:drop domain %DOMAIN%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a user defined data type</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o157">
<a:ObjectID>F776AAE4-1B7D-4417-ADA0-925918FA8C46</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, DOMAIN, DTTPCODE, Stereotype}
select
pg_get_userbyid(d.typowner),
d.typname,
case (d.typtype) when 'd' then (select t.typname from pg_type t where t.oid = d.typBaseType) else '' end,
case (d.typtype) when 'b' then 'BaseType' when 'c' then 'CompositeType' else '' end
from
pg_type d
left outer join pg_class r on (r.oid = d.typrelid)
where
(d.typtype in ('b', 'd') or (d.typtype = 'c' and r.relkind = 'c'))
[ and pg_get_userbyid(d.typowner) = %.q:SCHEMA%]
order by 1, 2</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341908522</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o158">
<a:ObjectID>AFA53FAE-E05C-4C4B-BB73-A8EC404CFFE6</a:ObjectID>
<a:Name>EnableOwner</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Owner allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o159">
<a:ObjectID>E2BAA09E-4664-4153-A28C-A206743C8BD5</a:ObjectID>
<a:Name>EnableCheck</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Allows the creation of checks on the domain</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o160">
<a:ObjectID>DA4BAC34-7D11-4D74-9A58-5142566F9D88</a:ObjectID>
<a:Name>SqlCompositeTypeColnList</a:Name>
<a:TextTargetItem.Value>{OWNER ID, DOMAIN ID, CompositeDefinition ...}
select
pg_get_userbyid(r.relowner),
r.relname,
c.attname || ' ' || t.typname || ', '
from
pg_class r
join pg_attribute c on (c.attrelid = r.oid)
join pg_type t on (t.oid = c.atttypid)
where
r.relkind = 'c'
[ and r.relname = %.q:DOMAIN%]
[ and pg_get_userbyid(r.relowner) = %.q:OWNER%]
order by 1, 2, c.attnum</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
</o:TextTargetItem>
<o:TextTargetItem Id="o161">
<a:ObjectID>F67508D3-3C78-4C24-BC4B-55D90C64689A</a:ObjectID>
<a:Name>ReversedQueries</a:Name>
<a:TextTargetItem.Value>SqlCompositeTypeColnList</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Additional attributes queries to be called by ODBC</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o162">
<a:ObjectID>330B7CDB-EF27-4ADE-BBFB-56329E4AE80A</a:ObjectID>
<a:Name>UddtComment</a:Name>
<a:TextTargetItem.Value>comment on [%Stereotype%=BaseType?type:[%Stereotype%=CompositeType?type:domain]] %DOMAIN% is
%.q:COMMENT%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>command for adding a user-defined data type comment</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o163">
<a:ObjectID>2D803C02-6E8E-42E3-884C-99D8D9D11B0A</a:ObjectID>
<a:Name>Procedure</a:Name>
<a:Code>PROC</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"PROC" // generated code of the procedure (also available for trigger when the trigger is implemented with a procedure)
"FUNC" // generated code of the procedure if the procedure is a function (with return value)
"PROCPRMS" // list of parameters of the procedure (also available for function)
</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o164">
<a:ObjectID>4975CC75-CAB7-4FAC-9989-EC181498F4EB</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Procedure allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:BooleanTargetItem Id="o165">
<a:ObjectID>B227AD93-0969-43CE-B311-735CF6FA3BA7</a:ObjectID>
<a:Name>EnableFunc</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Function allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:IntegerTargetItem Id="o166">
<a:ObjectID>FDA1A9E3-3694-48FD-A788-228D53B19829</a:ObjectID>
<a:Name>Maxlen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum object code length</a:Comment>
<a:IntegerTargetItem.Value>31</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:IntegerTargetItem Id="o167">
<a:ObjectID>567B59B0-D391-4E8B-B6EB-F9280D8458C8</a:ObjectID>
<a:Name>MaxFuncLen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Function name length</a:Comment>
<a:IntegerTargetItem.Value>31</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:TextTargetItem Id="o168">
<a:ObjectID>93FB86F2-AFA3-40FB-A122-704F47E14567</a:ObjectID>
<a:Name>DropFunc</a:Name>
<a:TextTargetItem.Value>drop function %FUNC% ( <type> )</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a function. Example: drop function %FUNC%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o169">
<a:ObjectID>68DA6237-E801-4609-8DF3-9913541D763C</a:ObjectID>
<a:Name>CustomFunc</a:Name>
<a:TextTargetItem.Value>CREATE FUNCTION %FUNC% ( <type> )
RETURNS <type>
AS '%SCRIPT%'
LANGUAGE '%ProcLanguage%'
;</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a function</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o170">
<a:ObjectID>251982F3-DE0C-4FAA-A131-7DBFE0759575</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, PROC, FUNC}
select
pg_get_userbyid(p.proowner),
p.proname,
case(pronargs) when 0 then '' else p.proname end
from
pg_proc p
join pg_language l on (l.oid = p.prolang and l.lanname <> 'internal')
[where pg_get_userbyid(p.proowner) = %.q:SCHEMA%]
order by 1, 2, 3</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o171">
<a:ObjectID>192AC9A1-15B6-4DF7-BC4C-B516BDAF88FB</a:ObjectID>
<a:Name>SqlAttrQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, PROC, ProcLanguage, TRGDEFN}
select
pg_get_userbyid(p.proowner),
p.proname,
l.lanname,
p.prosrc::varchar
from
pg_proc p
join pg_language l on (l.oid = p.prolang and l.lanname <> 'internal')
where 1=1
[ and pg_get_userbyid(p.proowner) = %.q:OWNER%]
[ and p.proname = %.q:PROC%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to reverse object attributes</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o172">
<a:ObjectID>40FF2B3A-67ED-44EF-A265-8A9E228E7687</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create procedure %PROC%[(%PROCPRMS%)]
as %.q:TRGDEFN%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a procedure. Example: create procedure %PROC% %TRGDEFN%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o173">
<a:ObjectID>AAEB8CBB-C876-4B6D-BE50-E6E73BC964D8</a:ObjectID>
<a:Name>CreateFunc</a:Name>
<a:TextTargetItem.Value>create[ or replace] function %FUNC%[(%PROCPRMS%)]
%TRGDEFN%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a function. Example: create function %FUNC% %TRGDEFN%</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o174">
<a:ObjectID>8FF2CB5D-C3CB-4D91-BE5B-64EE3E717750</a:ObjectID>
<a:Name>User</a:Name>
<a:Code>USER</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"USER" // generated code of the user
</a:Comment>
<c:Categories>
<o:IntegerTargetItem Id="o175">
<a:ObjectID>E6F5A60D-CA9F-44E1-8E1C-126237EE8264</a:ObjectID>
<a:Name>Maxlen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum object code length</a:Comment>
<a:IntegerTargetItem.Value>31</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:BooleanTargetItem Id="o176">
<a:ObjectID>D9017676-BDD5-453E-924C-0D0D36CC2448</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>User allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o177">
<a:ObjectID>F8617015-368F-4D56-9D87-9FE3DADBC19A</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{USER, Schema, SysId, CreateDB, CreateUser, Validity, Owner}
select
usename, 'false',
usesysid,
case (usecreatedb) when true then 'true' else 'false' end,
case (usesuper) when true then 'true' else 'false' end,
to_char(valuntil, 'DD/MM/YYYY HH24:MI:SS'),
''
from
pg_user
[where
UPPER(usename) = %.qU:SCHEMA%]
union select
nspname, 'true',
0,
'',
'',
'',
pg_get_userbyid(nspowner)
from
pg_namespace
[where UPPER(nspname) = %.qU:SCHEMA%]
order by 1</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o178">
<a:ObjectID>AE3804C2-2F0E-498E-AE13-BFE9F75A1DB7</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>[%CanCreate%?[%Schema%?create schema %USER%[ authorization %Owner.Code%]:create user %USER%[%R%? with][.Z:[ sysid %SysId%][%CreateDB%? createdb:[%R%? nocreatedb]][%CreateUser%? createuser:[%R%? nocreateuser]][
[%EncryptedPassword%? encrypted: unencrypted] password %.q:PASSWORD%][ valid until %.q:Validity%]]
]]
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1246366826</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Command for creating a user</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o179">
<a:ObjectID>0C08C855-C137-4B0C-91DD-5C84925F17C8</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>[%CanCreate%?drop [%Schema%?schema:user] %USER%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1246367139</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Command for dropping a user</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o180">
<a:ObjectID>3F101A42-CA85-4BEA-A518-927051455323</a:ObjectID>
<a:Name>Trigger</a:Name>
<a:Code>TRGR</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
(parent table items are also available for indexes)
trigger object specific items
"ORDER" // order number of the trigger (to sort the triggers when the DBMS supports more than one trigger of one type)
"TRIGGER" // generated code of trigger
"TRGTYPE" // trigger type (keywords "beforeinsert", "afterupdate", ...)
"TRGEVENT" // trigger event (keywords "insert", "update", "delete")
"TRGTIME" // trigger time (keywords NULL, "before", "after")
inside the body of the trigger, macros redefine variables on objects
"REFNO" // reference position in the list of references of the table
customized error messages management
"ERRNO" // error number for standard error
"ERRMSG" // error message for standard error
"MSGTAB" // name of the table containing user-defined error messages
"MSGNO" // in the user-defined error table, name of the column containing the error numbers
"MSGTXT" // in the user-defined error table, name of the column containing the error messages
"SCRIPT" // body of trigger or procedure
"TRGDEFN" // complete body of the trigger definition. Contains variable declarations and body of trigger or procedure
</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o181">
<a:ObjectID>E19DFCA9-7B9C-4C66-94E1-6219E6D60F2A</a:ObjectID>
<a:Name>EnableMultiEvent</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Multiple event allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o182">
<a:ObjectID>7F592BF2-1A0B-45C8-85FC-65AB6BF27D7A</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop trigger %TRIGGER% on [%QUALIFIER%]%TABLE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a trigger. Example: drop trigger %TRIGGER%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o183">
<a:ObjectID>6D51FD27-F0DA-4172-B79C-881FD8691D28</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, TRIGGER, TRGEVENT, TRGTIME}
select
pg_get_userbyid(t.relowner),
t.relname,
g.tgname,
case (g.tgtype & 28)
when 4 then 'insert' when 8 then 'delete' when 16 then 'update'
when 12 then 'insert or delete' when 20 then 'insert or update' when 24 then 'delete or update'
when 28 then 'insert or delete or update' else '' end::varchar as coln,
case (g.tgtype & 2)
when 2 then 'before' when 0 then 'after' else '' end::varchar
from
pg_trigger g
join pg_class t on (t.oid = g.tgrelid and t.relkind = 'r')
where g.tgconstraint = 0
[ and pg_get_userbyid(t.relowner) = %.q:SCHEMA%]
order by 1, 2</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341907281</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o184">
<a:ObjectID>1A74C1FB-8DBF-49E1-8CC1-C218CBB058A6</a:ObjectID>
<a:Name>SqlAttrQuery</a:Name>
<a:TextTargetItem.Value>{OWNER, TABLE, TRIGGER, SCRIPT}
select
pg_get_userbyid(t.relowner),
t.relname,
g.tgname,
pg_get_triggerdef(g.oid)
from
pg_trigger g
join pg_class t on (t.oid = g.tgrelid and t.relkind = 'r')
where g.tgconstraint = 0
[ and pg_get_userbyid(t.relowner) = %.q:SCHEMA%]
[ and t.relname = %.q:TABLE%]
[ and g.tgname = %.q:TRIGGER%]
order by 1, 2</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1341909260</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>SQL query to reverse object attributes</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o185">
<a:ObjectID>CE4F0440-B491-4676-9435-73737B55A8FF</a:ObjectID>
<a:Name>UseErrorMsgTable</a:Name>
<a:TextTargetItem.Value>let errno = %ERRNO%;
select %MSGTXT%
into errmsg
from %MSGTAB%
where %MSGNO% = %ERRNO%;
raise exception -746, 0, errmsg;</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Errors handling using an error messages table</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o186">
<a:ObjectID>5989F402-A130-4D39-AA84-E13023A49577</a:ObjectID>
<a:Name>UseErrorMsgText</a:Name>
<a:TextTargetItem.Value>let errno = %ERRNO%;
let errmsg = "%ERRMSG%";
raise exception -746, 0, errmsg;</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Errors handling using fixed error messages</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o187">
<a:ObjectID>00CC31F8-67B8-419E-82C9-CB8BDBE3C7ED</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create trigger %TRIGGER% %TRGTIME% %TRGEVENT% on %TABLE%
%TRGDEFN%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a trigger. Example: create trigger on [%QUALIFIER%]%TABLE% %TRGDEFN%</a:Comment>
</o:TextTargetItem>
<o:IntegerTargetItem Id="o188">
<a:ObjectID>BCE86A5F-400D-4EF5-AFEA-7A66DE9E65D1</a:ObjectID>
<a:Name>Maxlen</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Maximum object code length</a:Comment>
<a:IntegerTargetItem.Value>30</a:IntegerTargetItem.Value>
</o:IntegerTargetItem>
<o:TextTargetItem Id="o189">
<a:ObjectID>5D052D24-6CFE-4A8F-8662-E5599DBEB469</a:ObjectID>
<a:Name>DefaultTriggerName</a:Name>
<a:TextTargetItem.Value>%TEMPLATE%_%.L:TABLE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Default trigger name</a:Comment>
</o:TextTargetItem>
<o:BooleanTargetItem Id="o190">
<a:ObjectID>802E3B4B-7A6E-451C-B065-37C52B07E693</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Trigger allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:StringTargetItem Id="o191">
<a:ObjectID>34C945EE-91C3-44A0-990B-52391394D184</a:ObjectID>
<a:Name>EventDelimiter</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Events separation character.</a:Comment>
<a:StringTargetItem.Value>or</a:StringTargetItem.Value>
</o:StringTargetItem>
<o:TextTargetItem Id="o192">
<a:ObjectID>DE6F260F-ADD8-4CE8-8FC3-58D9D68CE6C0</a:ObjectID>
<a:Name>Time</a:Name>
<a:TextTargetItem.Value>before
after</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Extended trigger times list.</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o193">
<a:ObjectID>A19C9B0A-3FF2-43AE-8340-BF77D513A2E9</a:ObjectID>
<a:Name>Event</a:Name>
<a:TextTargetItem.Value>insert
delete
update</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Extended trigger events list.</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o194">
<a:ObjectID>7D1D2CDF-E58B-42B2-9016-5108F01CE18C</a:ObjectID>
<a:Name>Tablespace</a:Name>
<a:Code>TSPC</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The following system variables are available:
"TABLESPACE" // generated code of the tablespace
</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o195">
<a:ObjectID>0000D97B-6EF3-4C81-AC59-0AC769EF1889</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Tablespace allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o196">
<a:ObjectID>2BE7A654-B74D-4D5B-AA49-D6D2A546B6FE</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create tablespace %TABLESPACE%
[ owner %TbspOwner%
] location %.q:TbspLocation%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a tablespace. Example: create tablespace %TABLESPACE%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o197">
<a:ObjectID>0E7909E4-9E5E-4A10-80C0-CC8E1F8DD69C</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop tablespace %TABLESPACE%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a tablespace. Example: drop tablespace %TABLESPACE%</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o198">
<a:ObjectID>CD05E302-8958-41BF-9042-81185E8C6753</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{TABLESPACE, TbspOwner, TbspLocation}
select
t.spcname,
pg_get_userbyid(t.spcowner),
t.spclocation
from
pg_tablespace t
order by 1</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o199">
<a:ObjectID>7837BA9D-D967-437A-95C3-C44DA43469A8</a:ObjectID>
<a:Name>Group</a:Name>
<a:Code>GRPE</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Manages the group object.</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o200">
<a:ObjectID>B2F69FF7-ECB8-4F16-82E5-E8BE6E333B20</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Group allowed</a:Comment>
<a:Value>1</a:Value>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o201">
<a:ObjectID>92FE7ABE-3D9C-4D59-BBB1-0AE7F543E719</a:ObjectID>
<a:Name>Create</a:Name>
<a:TextTargetItem.Value>create group %GROUP%
[ [%R%?with ] sysid %SysId%]</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for creating a group.</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o202">
<a:ObjectID>6B19B14B-B135-4310-9025-3783B7F72E25</a:ObjectID>
<a:Name>Drop</a:Name>
<a:TextTargetItem.Value>drop group %GROUP%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for dropping a group.</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o203">
<a:ObjectID>BCE6A1C0-AD38-4AF6-8918-112A9109D421</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:TextTargetItem.Value>{GROUP}
select
groname
from
pg_group
order by 1</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to list objects</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o204">
<a:ObjectID>44322879-5000-42F5-AB39-4DE022512CA5</a:ObjectID>
<a:Name>Bind</a:Name>
<a:TextTargetItem.Value>alter group %GROUP% add user %USER%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for adding a member to a group</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o205">
<a:ObjectID>880E598B-C369-4F64-8BEF-85689387E12A</a:ObjectID>
<a:Name>Unbind</a:Name>
<a:TextTargetItem.Value>alter group %GROUP% drop user %USER%</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Command for removing a member from a group</a:Comment>
</o:TextTargetItem>
<o:TextTargetItem Id="o206">
<a:ObjectID>B29585AC-4B80-456A-97F0-5FBCD48641A5</a:ObjectID>
<a:Name>SqlListChildrenQuery</a:Name>
<a:TextTargetItem.Value>{GROUP, MEMBER}
select
g.groname,
u.usename
from
pg_group g
join pg_user u on (u.usesysid = any(g.grolist))
[where g.groname = %.q:GROUP%]
</a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>SQL query to list members of the group</a:Comment>
</o:TextTargetItem>
</c:Categories>
</o:TargetCategory>
<o:OrderTargetItem Id="o207">
<a:ObjectID>EDE2756E-AD00-4A2F-B677-CF1436597E81</a:ObjectID>
<a:Name>GenerationOrder</a:Name>
<a:TextTargetItem.Value><Order>
<Metaclass Name="Storage" />
<Metaclass Name="Tablespace" />
<Metaclass Name="Database">
<Metaclass Name="Database::Permission" />
</Metaclass>
<Metaclass Name="Role" />
<Metaclass Name="Group" />
<Metaclass Name="User" />
<Metaclass Name="BusinessRule" />
<Metaclass Name="Sequence">
<Metaclass Name="Sequence::Permission" />
</Metaclass>
<Metaclass Name="AbstractDataType">
<Metaclass Name="AbstractDataType::Permission" />
</Metaclass>
<Metaclass Name="PhysicalDefault" />
<Metaclass Name="PhysicalDomain" />
<Metaclass Name="Table">
<Metaclass Name="Table::Key" />
<Metaclass Name="Table::Index" />
<Metaclass Name="Table::Permission" />
</Metaclass>
<Metaclass Name="View">
<Metaclass Name="View::ViewIndex" />
<Metaclass Name="View::Permission" />
</Metaclass>
<Metaclass Name="Reference" />
<Metaclass Name="JoinIndex" />
<Metaclass Name="Synonym">
<Metaclass Name="Synonym::Permission" />
</Metaclass>
<Metaclass Name="Dimension" />
<Metaclass Name="Procedure">
<Metaclass Name="Procedure::Permission" />
</Metaclass>
<Metaclass Name="DatabasePackage">
<Metaclass Name="DatabasePackage::Permission" />
</Metaclass>
<Metaclass Name="Table::Trigger" />
<Metaclass Name="View::Trigger" />
<Metaclass Name="WebService" />
</Order></a:TextTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1263300423</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>This list defines the objects generation order.</a:Comment>
</o:OrderTargetItem>
</c:Categories>
</o:TargetCategory>
<o:TargetCategory Id="o208">
<a:ObjectID>1C9264F0-50A8-45F8-BAB8-A6810D27D506</a:ObjectID>
<a:Name>DataType</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains data type translation entries. These entries list the correspondence between internal data types and the target database data types</a:Comment>
<c:Categories>
<o:MapTargetItem Id="o209">
<a:ObjectID>0BBE373C-5AAD-4A7A-853A-7BE50EA05FC0</a:ObjectID>
<a:Name>AmcdDataType</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1240989401</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Data types translation table from internal data types to target database data types.
%n is the length of the data type
%s is the size of the data type
%p is the precision of the data type</a:Comment>
<a:MapTargetItem.Value><UNDEF>=<Undefined>
A=CHAR(1)
A%n=CHAR(%n)
VA%n=VARCHAR(%n)
LA=VARCHAR(1)
LA%n=VARCHAR(%n)
LVA=VARCHAR(1)
LVA%n=VARCHAR(%n)
BT=INT2
BT%n=INT2
SI=INT2
I=INT4
LI=INT8
N=NUMERIC
N%n=NUMERIC(%n)
N%s,%p=NUMERIC(%s,%p)
DC=DECIMAL
DC%n=DECIMAL(%n)
DC%s,%p=DECIMAL(%s,%p)
SF=FLOAT4
F=FLOAT8
F%n=FLOAT8
LF=FLOAT8
MN=MONEY
MN%n=MONEY
MN%s,%p=MONEY
D=DATE
T=TIME
DT=DATE
TS=DATE
BL=BOOL
NO=SERIAL
NO%n=SERIAL
BIN%n=CHAR(%n)
LBIN=CHAR
LBIN%n=CHAR(%n)
TXT=TEXT
TXT%n=TEXT
MBT=CHAR
MBT%n=CHAR(%n)
VMBT=VARCHAR(254)
VMBT%n=VARCHAR(%n)
PIC=CHAR(254)
PIC%n=CHAR(%n)
BMP=CHAR(254)
BMP%n=CHAR(%n)
OLE=CHAR(254)
OLE%n=CHAR(%n)
*=CHAR(10)
POINT=POINT
LINE=LINE
SEGMENT=LSEG
RECTANGLE=BOX
POLYGON=POLYGON
CIRCLE=CIRCLE</a:MapTargetItem.Value>
<a:List><UNDEF>
A
A%n
VA%n
LA
LA%n
LVA
LVA%n
BT
BT%n
SI
I
LI
N
N%n
N%s,%p
DC
DC%n
DC%s,%p
SF
F
F%n
LF
MN
MN%n
MN%s,%p
D
T
DT
TS
BL
NO
NO%n
BIN%n
LBIN
LBIN%n
TXT
TXT%n
MBT
MBT%n
VMBT
VMBT%n
PIC
PIC%n
BMP
BMP%n
OLE
OLE%n
POINT
LINE
SEGMENT
RECTANGLE
POLYGON
CIRCLE
</a:List>
</o:MapTargetItem>
<o:MapTargetItem Id="o210">
<a:ObjectID>8152888C-EC21-4CE9-BE44-BB0185B56336</a:ObjectID>
<a:Name>PhysDataType</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1240989401</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>Data types translation table from target database data types to internal data types.</a:Comment>
<a:MapTargetItem.Value><Undefined>=<UNDEF>
DECIMAL=DC
DECIMAL(%n)=DC%n
DECIMAL(%s,%p)=DC%s,%p
FLOAT4=F7
FLOAT8=F16
INT2=SI
INT4=I
INT8=LI
NUMERIC=N
NUMERIC(%n)=N%n
NUMERIC(%s,%p)=N%s,%p
SERIAL=NO
MONEY=MN
CHAR=A1
CHAR(%n)=A%n
TEXT=TXT
VARCHAR(%n)=VA%n
TIMESTAMP=TS
TIMESTAMP WITH TIME ZONE=TS
INTERVAL=DT
DATE=D
TIME=T
TIME WITH TIME ZONE=T
BOOL=BL
POINT=POINT
LINE=LINE
LSEG=SEGMENT
BOX=RECTANGLE
PATH=A248
POLYGON=POLYGON
CIRCLE=CIRCLE
CIDR=A10
INET=A10
*=A10</a:MapTargetItem.Value>
<a:List><Undefined>
DECIMAL
DECIMAL(%n)
DECIMAL(%s,%p)
FLOAT4
FLOAT8
INT2
INT4
INT8
NUMERIC
NUMERIC(%n)
NUMERIC(%s,%p)
SERIAL
MONEY
CHAR
CHAR(%n)
TEXT
VARCHAR(%n)
TIMESTAMP
TIMESTAMP WITH TIME ZONE
INTERVAL
DATE
TIME
TIME WITH TIME ZONE
BOOL
POINT
LINE
LSEG
BOX
PATH
POLYGON
CIRCLE
CIDR
INET
</a:List>
</o:MapTargetItem>
<o:MapTargetItem Id="o211">
<a:ObjectID>7743713B-3320-4EE4-9E87-3AFB729355D7</a:ObjectID>
<a:Name>PhysDttpSize</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Table of storage sizes of target database data type</a:Comment>
</o:MapTargetItem>
<o:MapTargetItem Id="o212">
<a:ObjectID>87D4DC23-7078-4D7D-94A4-B3210DA8CC3E</a:ObjectID>
<a:Name>OdbcPhysDataType</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Data types translation table from ODBC data types to target database data types.</a:Comment>
<a:MapTargetItem.Value>bpchar(%n)=char(%n)</a:MapTargetItem.Value>
<a:List>bpchar(%n)
</a:List>
</o:MapTargetItem>
</c:Categories>
</o:TargetCategory>
</c:Categories>
</o:TargetCategory>
<o:ProfileTargetItem Id="o213">
<a:ObjectID>CDC2B06C-5AC1-4D4C-88AF-2C88898BDB26</a:ObjectID>
<a:Name>Profile</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TargetCategory Id="o214">
<a:ObjectID>815871BB-A068-41E2-BA52-205B50A0AD52</a:ObjectID>
<a:Name>Shared</a:Name>
<a:Code>Shared</a:Code>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o215">
<a:TypePublicName>ExtendedAttributeTypeTargetItem</a:TypePublicName>
<a:ObjectID>8995054D-72B6-4201-B86A-98DB680FB1BD</a:ObjectID>
<a:Name>Extended Attribute Types</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTypeTargetItem Id="o216">
<a:ObjectID>94C33C46-EC2F-4743-8D37-18C5B6666938</a:ObjectID>
<a:Name>ProcLanguageList</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Predefined list of language that the function is implemented in. (See also Extended Attribute ProcLanguage.)</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTypeTargetItem.Value>sql</a:ExtendedAttributeTypeTargetItem.Value>
<a:ExtendedAttributeTypeTargetItem.ListOfValues>sql
c
internal</a:ExtendedAttributeTypeTargetItem.ListOfValues>
</o:ExtendedAttributeTypeTargetItem>
<o:ExtendedAttributeTypeTargetItem Id="o217">
<a:ObjectID>9984F847-6977-4648-826F-78BC26C6C4CD</a:ObjectID>
<a:Name>TemporaryState</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>This list stores all possible states for Temporary attribute.
Optionally, GLOBAL or LOCAL can be written before TEMPORARY or TEMP. This makes no difference in opengauss.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTypeTargetItem.ListOfValues>temp
temporary
local temp
local temporary
global temp
global temporary</a:ExtendedAttributeTypeTargetItem.ListOfValues>
</o:ExtendedAttributeTypeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:TargetCategory>
<o:MetaClassTargetItem Id="o218">
<a:ObjectID>1C98415B-16D6-425F-8303-C2FF48130BBE</a:ObjectID>
<a:Name>PhysicalDomain</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o219">
<a:TypePublicName>StereotypeTargetItem</a:TypePublicName>
<a:ObjectID>ADAC425E-EB22-4640-8A4F-D9CD71687A79</a:ObjectID>
<a:Name>Stereotypes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:StereotypeTargetItem Id="o220">
<a:ObjectID>0F50EE1C-651C-4508-B05E-AA4FB19D3130</a:ObjectID>
<a:Name>BaseType</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o221">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>7C56205A-F82D-4439-9C47-AA7E39B8C1B9</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o222">
<a:ObjectID>3954A652-B44B-4642-88E7-CE8099392324</a:ObjectID>
<a:Name>ExtTypeInput</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The name of a function, created by CREATE FUNCTION, which converts data from its external form to the type's internal form.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o223">
<a:ObjectID>D596DD04-D85D-4A04-A7EC-349BC723BD2F</a:ObjectID>
<a:Name>ExtTypeOutput</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The name of a function, created by CREATE FUNCTION, which converts data from its internal form to a form suitable for display.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o224">
<a:ObjectID>B5F0DA75-D422-4AE5-97E2-7379ACA74F9D</a:ObjectID>
<a:Name>ExtTypeLength</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>A literal value, which specifies the internal length of the new type.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>10</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o225">
<a:ObjectID>BE7B22DF-64C1-4C0B-B2EA-AF35795600FA</a:ObjectID>
<a:Name>ExtTypeElement</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The type being created is an array; this specifies the type of the array elements.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o226">
<a:ObjectID>DE189C84-B4B4-44F5-80D7-794AE7E5FAA8</a:ObjectID>
<a:Name>ExtTypeDelimiter</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The delimiter character for the array.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o227">
<a:ObjectID>00878568-A073-4D54-A848-DD34908584D5</a:ObjectID>
<a:Name>ExtTypeSend</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The name of a function, created by CREATE FUNCTION, which converts data of this type into a form suitable for transmission to another machine.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o228">
<a:ObjectID>A557019E-E970-424C-8772-69236830584E</a:ObjectID>
<a:Name>ExtTypeReceive</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The name of a function, created by CREATE FUNCTION, which converts data of this type from a form suitable for transmission from another machine to internal form.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o229">
<a:ObjectID>DA5B44D4-E590-4A53-828F-EC8963669BB2</a:ObjectID>
<a:Name>ExtTypePassedByValue</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>indicates that operators and functions which use this data type should be passed an argument by value rather than by reference.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.Value>FALSE</a:ExtendedAttributeTargetItem.Value>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o230">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>EBF9D66B-A877-4182-902E-FDD810E82BF1</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o231">
<a:ObjectID>1402B726-1615-42A2-9D4D-DFD6811689A2</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Attribute="ExtTypeLength" AttributeID="{B5F0DA75-D422-4AE5-97E2-7379ACA74F9D}" Name="ExtTypeLength" Caption="Length" GrayHiddenAttributes="No" />
<ExtendedAttribute Attribute="ExtTypeElement" AttributeID="{BE7B22DF-64C1-4C0B-B2EA-AF35795600FA}" Name="ExtTypeElement" Caption="Array Element type" GrayHiddenAttributes="No" />
<ExtendedAttribute Attribute="ExtTypeDelimiter" AttributeID="{DE189C84-B4B4-44F5-80D7-794AE7E5FAA8}" Name="ExtTypeDelimiter" Caption="Array delimiter" GrayHiddenAttributes="No" />
<ExtendedAttribute Attribute="ExtTypePassedByValue" AttributeID="{DA5B44D4-E590-4A53-828F-EC8963669BB2}" Name="ExtTypePassedByValue" Caption="By Value" GrayHiddenAttributes="No" />
<Separator Name="Separator1" />
<ExtendedAttribute Attribute="ExtTypeInput" AttributeID="{3954A652-B44B-4642-88E7-CE8099392324}" Name="ExtTypeInput" Caption="Input function" GrayHiddenAttributes="No" />
<ExtendedAttribute Attribute="ExtTypeOutput" AttributeID="{D596DD04-D85D-4A04-A7EC-349BC723BD2F}" Name="ExtTypeOutput" Caption="Output function" GrayHiddenAttributes="No" />
<ExtendedAttribute Attribute="ExtTypeSend" AttributeID="{00878568-A073-4D54-A848-DD34908584D5}" Name="ExtTypeSend" Caption="Send function" GrayHiddenAttributes="No" />
<ExtendedAttribute Attribute="ExtTypeReceive" AttributeID="{A557019E-E970-424C-8772-69236830584E}" Name="ExtTypeReceive" Caption="Receive function" GrayHiddenAttributes="No" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:StereotypeTargetItem>
<o:StereotypeTargetItem Id="o232">
<a:ObjectID>6DAAC25D-4FAB-425C-A545-5C5DD08DCFFF</a:ObjectID>
<a:Name>CompositeType</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o233">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>4F0F83D1-D45D-4A84-9904-35BB9E96F981</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o234">
<a:ObjectID>F09B1253-9E0E-48DD-94C5-7EB645E424C9</a:ObjectID>
<a:Name>CompositeDefinition</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The composite type is specified by a list of attribute names and data types. This is essentially the same as the row type of a table, but using CREATE TYPE avoids the need to create an actual table when all that is wanted is to define a type. A stand-alone composite type is useful as the argument or return type of a function.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o235">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>EF4CD3F3-26DA-4F9D-8318-D1BBA1AFE4EB</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o236">
<a:ObjectID>166747AD-2DF7-46FB-A33D-1DF60DFCFADB</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Attribute="CompositeDefinition" AttributeID="{F09B1253-9E0E-48DD-94C5-7EB645E424C9}" Name="Definition" Caption="Definition" GrayHiddenAttributes="No" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:StereotypeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o237">
<a:ObjectID>CCF5FE55-2BCB-4591-A512-B232444428CF</a:ObjectID>
<a:Name>Procedure</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o238">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>08020C9D-AE04-4063-ADDF-3BB6FB1FF63D</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o239">
<a:ObjectID>09E77E7F-0834-4FFF-A0EB-3FE1A3FA16B1</a:ObjectID>
<a:Name>ProcLanguage</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The name of the language that the function is implemented in. May be SQL, C, internal, or the
name of a user-defined procedural language. (See also extended attribute type ProcLanguageList.)</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>-1</a:ExtendedAttributeTargetItem.DataType>
<a:ExtendedAttributeTargetItem.Value>sql</a:ExtendedAttributeTargetItem.Value>
<a:ValidateDataType>0</a:ValidateDataType>
<c:ExtendedAttributeType>
<o:ExtendedAttributeTypeTargetItem Ref="o216"/>
</c:ExtendedAttributeType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o240">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>0BA45BFD-1CF5-4D99-B6FB-AB6E8B510D0F</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o241">
<a:ObjectID>632C0A96-5390-4ABF-B891-B723954AFA3D</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<GroupBox Name="GroupBox1" Caption="Language" ControlAsLabel="No" >
<StaticText Name="StaticText1" Caption="Choose here the name of the language that the function is implemented in." />
<StaticText Name="StaticText3" Caption="May be SQL, C, internal, or the name of a user-defined procedural language." />
<ExtendedAttribute Name="ProcLanguage" Caption="Language" Attribute="ProcLanguage" AttributeID="{09E77E7F-0834-4FFF-A0EB-3FE1A3FA16B1}" GrayHiddenAttributes="Yes" />
</GroupBox>
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o242">
<a:ObjectID>D6A943D2-2621-4BAD-8B30-F90E7FC2FB95</a:ObjectID>
<a:Name>Tablespace</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o243">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>8BA82F30-4EA2-4A6D-B7B9-D5EDE8FBA4C6</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o244">
<a:ObjectID>6A4623D4-04FD-49E4-BBB2-26B246E58EAF</a:ObjectID>
<a:Name>TbspLocation</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The directory that will be used for the tablespace. The directory must be specified by an absolute path name.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o245">
<a:ObjectID>8B7D44B4-EC82-41B9-9443-CC961DEE9E81</a:ObjectID>
<a:Name>TbspOwner</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The name of the user who will own the tablespace. If omitted, defaults to the user executing the command. Only superusers may create tablespaces, but they can assign ownership of tablespaces to non-superusers.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o246">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>8C308551-D020-4376-A081-F598F6B78A23</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o247">
<a:ObjectID>83A3A92E-36CE-46F3-A9F6-F04DBFBAC1C4</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Attribute="TbspLocation" AttributeID="{6A4623D4-04FD-49E4-BBB2-26B246E58EAF}" Name="TbspLocation" Caption="Location" GrayHiddenAttributes="No" />
<ExtendedAttribute Attribute="TbspOwner" AttributeID="{8B7D44B4-EC82-41B9-9443-CC961DEE9E81}" Name="TbspOwner" Caption="Owner" GrayHiddenAttributes="No" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o248">
<a:TypePublicName>CustomCheckTargetItem</a:TypePublicName>
<a:ObjectID>A643B629-0C06-4935-97B2-BECCC51FA9D4</a:ObjectID>
<a:Name>Custom Checks</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:CustomCheckTargetItem Id="o249">
<a:ObjectID>4447EEA6-F62F-416E-9A45-E707E0A8A3EF</a:ObjectID>
<a:Name>Mandatory Tablespace Location</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpMessage>This check ensures that the Location extended attribute is set for the tablespace</a:HelpMessage>
<a:OutputMessage>The following tablespaces have no location defined</a:OutputMessage>
<a:CheckScript>Function %Check%(obj)
' Check that the extended attribute "TbspLocation" is filled.
' The contents of the attribute is not controlled.
%Check% = (obj.GetExtendedAttribute("TbspLocation") <> "")
End Function</a:CheckScript>
<a:AutoFixScrpt>Function %Fix%(obj, outmsg)
' Implement your automatic correction on <obj> here
' filling <outmsg> as you wish
' and return True if successful.
outmsg = "Automatic correction not implemented"
%Fix% = False
End Function</a:AutoFixScrpt>
</o:CustomCheckTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o250">
<a:ObjectID>C5C915C9-3817-4DDB-95E2-5CCBD01C091C</a:ObjectID>
<a:Name>IndexColumn</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o251">
<a:TypePublicName>CustomCheckTargetItem</a:TypePublicName>
<a:ObjectID>6B0A0403-6F86-4876-9CB0-9AED66E3CA2E</a:ObjectID>
<a:Name>Custom Checks</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:CustomCheckTargetItem Id="o252">
<a:ObjectID>8422D3FA-4033-45AA-95A4-F0DDA1A40A64</a:ObjectID>
<a:Name>Index expression enclosed in parenthesis</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpMessage>This check ensures that index column expression are always enclosed in parenthesis</a:HelpMessage>
<a:OutputMessage>The following indexes column have an invalid expression:</a:OutputMessage>
<a:CheckScript>Function %Check%(obj)
if (obj.Expression <> "") then
%Check% = (left(obj.Expression, 1) & right(obj.Expression, 1) = "()")
else
%Check% = True
end if
End Function</a:CheckScript>
<a:AutoFixScrpt>Function %Fix%(obj, outmsg)
obj.Expression = "( " & obj.Expression & " )"
outmsg = "Parenthesis have been added around column index expression"
%Fix% = True
End Function</a:AutoFixScrpt>
<a:DefaultAutoFixExecution>1</a:DefaultAutoFixExecution>
<a:EnableAutoFix>1</a:EnableAutoFix>
</o:CustomCheckTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o253">
<a:ObjectID>ACD56323-30AB-4823-B61B-03AD25AF177B</a:ObjectID>
<a:Name>Table</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o254">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>7FB938DF-E6B5-4DFA-A865-A7175805E4D6</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o255">
<a:ObjectID>04B573C8-8062-4FFC-8C07-AA34F76050C2</a:ObjectID>
<a:Name>Temporary</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>If specified, the table is created as a temporary table. Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transaction</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>-1</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
<c:ExtendedAttributeType>
<o:ExtendedAttributeTypeTargetItem Ref="o217"/>
</c:ExtendedAttributeType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o256">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>033A27B6-2884-45DD-83BC-65E79E967C47</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o257">
<a:ObjectID>4E49596A-0533-4E72-8AE6-1315208D0BBF</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Name="Temporary" Caption="Temporary state" Attribute="Temporary" AttributeID="{04B573C8-8062-4FFC-8C07-AA34F76050C2}" GrayHiddenAttributes="Yes" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o258">
<a:TypePublicName>MethodTargetItem</a:TypePublicName>
<a:ObjectID>B74022BD-ECA7-4557-B8D0-8713FD87874B</a:ObjectID>
<a:Name>Methods</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:MethodTargetItem Id="o259">
<a:ObjectID>3C7A869B-607A-433B-859A-748E99F6EAEE</a:ObjectID>
<a:Name>SetPublicSchema</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1244729286</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:MethodScript>Sub %Method%(obj)
Dim pub
for each pub in obj.Model.Users
if (LCase(pub.Code) = "public") then Exit For
next
if Not(isObject(pub)) then
Set pub = obj.Model.Users.CreateNew()
pub.SetExtendedAttribute "%CurrentTargetCode%.Schema", True
pub.SetNameAndCode "public", "public", False
end if
Set obj.Owner = pub
End Sub</a:MethodScript>
</o:MethodTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o260">
<a:ObjectID>269A9BBC-165B-467F-ABC9-DD53C67FC88F</a:ObjectID>
<a:Name>Reference</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o261">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>FB33CA15-0879-43BA-8B1F-545AD3EAFDFA</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o262">
<a:ObjectID>6D3919F1-F3EA-49D8-8E50-7AC8380DC462</a:ObjectID>
<a:Name>Deferrable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>This controls whether the constraint can be deferred. A constraint that is not deferrable will be checked immediately after every command. Checking of constraints that are deferrable may be postponed until the end of the transaction.
Only foreign key constraints currently accept this clause. All other constraint types are not deferrable.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.Value>false</a:ExtendedAttributeTargetItem.Value>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o263">
<a:ObjectID>E93DB726-E4A4-46A4-9219-548CAA66F2A0</a:ObjectID>
<a:Name>ForeignKeyConstraintDeferred</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>If a constraint is deferrable, this clause specifies the default time to check the constraint.
False means the constraint is INITIALLY IMMEDIATE, it is checked after each statement. This is the default.
True means the constraint is INITIALLY DEFERRED, it is checked only at the end of the transaction. </a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.Value>false</a:ExtendedAttributeTargetItem.Value>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o264">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>E4F188B9-21A4-4DC5-B9D0-1298AAC67E48</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o265">
<a:ObjectID>86AF89FA-E313-4725-AE1E-08C0AAFEE0BB</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Name="Deferrable" Caption="Deferrable" Attribute="Deferrable" AttributeID="{6D3919F1-F3EA-49D8-8E50-7AC8380DC462}" GrayHiddenAttributes="Yes" />
<ExtendedAttribute Name="ForeignKeyConstraintDeferred" Caption="Foreign key constraint deferred" Attribute="ForeignKeyConstraintDeferred" AttributeID="{E93DB726-E4A4-46A4-9219-548CAA66F2A0}" GrayHiddenAttributes="Yes" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o266">
<a:ObjectID>7F47B72E-AE21-435D-83AC-1FCFD007BBEB</a:ObjectID>
<a:Name>Database</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o267">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>8AB877B5-6E4E-424A-A234-6DD9DC4D6EB4</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o268">
<a:ObjectID>406ADDC6-D29B-4555-A539-15BC5B712A26</a:ObjectID>
<a:Name>Template</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The name of the template from which to create the new database, or DEFAULT to use the default template</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o269">
<a:ObjectID>5B507946-57A3-42B3-BEBF-00E549563D32</a:ObjectID>
<a:Name>Encoding</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Character set encoding to use in the new database. Specify a string constant (e.g., 'SQL_ASCII'), or an integer encoding number, or DEFAULT to use the default encoding</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>12</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o270">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>9EAAD069-88CB-4CAC-8765-F86B5891DCBA</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o271">
<a:ObjectID>81D28ABD-0696-418A-9A37-43CC32CDE7DC</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Name="Template" Caption="Template" Attribute="Template" AttributeID="{406ADDC6-D29B-4555-A539-15BC5B712A26}" GrayHiddenAttributes="Yes" />
<ExtendedAttribute Name="Encoding" Caption="Encoding" Attribute="Encoding" AttributeID="{5B507946-57A3-42B3-BEBF-00E549563D32}" GrayHiddenAttributes="Yes" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o272">
<a:ObjectID>16AB5309-2509-4C3E-AE19-BB18CC382404</a:ObjectID>
<a:Name>Group</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o273">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>96DD5873-228F-460D-9602-0A3CF94FABF1</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o274">
<a:ObjectID>E6FC2DB5-17D5-4FD1-B8DE-A0ED011588DE</a:ObjectID>
<a:Name>SysId</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The SYSID clause can be used to choose the opengauss group ID of the new group. This is normally not necessary, but may be useful if you need to recreate a group referenced in the permissions of some object.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>10</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o275">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>8BB37684-F2F8-4866-8F43-5ABC9B681689</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o276">
<a:ObjectID>FE43BCEE-E961-4DFE-B597-7C5B3D57F55A</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Attribute="SysId" AttributeID="{E6FC2DB5-17D5-4FD1-B8DE-A0ED011588DE}" Name="SysId" Caption="Group identifier (id)" GrayHiddenAttributes="Yes" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o277">
<a:ObjectID>EEA405CC-F187-4546-909F-60D33599A4DF</a:ObjectID>
<a:Name>User</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o278">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>CC851CCE-CF77-4A16-9215-E9408BE04646</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1246366865</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o279">
<a:ObjectID>947DD0F5-B5A2-4BF9-BA50-736D57126F7B</a:ObjectID>
<a:Name>Schema</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Indicates if selected user is a schema or not.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.Value>false</a:ExtendedAttributeTargetItem.Value>
<a:Label>Is schema</a:Label>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o280">
<a:ObjectID>FAFA5191-4B2E-4087-BCE3-6EF3058B19BA</a:ObjectID>
<a:Name>CanCreate</a:Name>
<a:CreationDate>1246366826</a:CreationDate>
<a:Creator>mledier</a:Creator>
<a:ModificationDate>1246367214</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:Comment>If user can be created in database.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:Computed>1</a:Computed>
<a:ComputedAccessType>RO</a:ComputedAccessType>
<a:GetMethodScript>Function %Get%(obj)
%Get% = (LCase(obj.Code) <> "public")
End Function</a:GetMethodScript>
<a:Label>Can create</a:Label>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o281">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>A68579A4-53A6-4AEE-81DB-6DF3BC0C6E9C</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1246366881</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o282">
<a:ObjectID>A1FB5438-65BB-48B7-A086-FF0BDB9FF81D</a:ObjectID>
<a:Name>General</a:Name>
<a:Code>GENERAL</a:Code>
<a:FormTargetItem.Value><Form >
<StandardNameAndCode Attribute="NameAndCode" SizeInChars="1" HorizontalResize="true" />
<StandardAttribute Attribute="Comment" Caption="Comment:" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
<StandardAttribute Attribute="Stereotype" Caption="Stereotype:" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
<StandardAttribute Attribute="Password" Caption="Password:" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
<HorizontalLayout Name="HorizontalLayout1" >
<ExtendedAttribute Attribute="Schema" Caption="Is schema" AttributeID="{947DD0F5-B5A2-4BF9-BA50-736D57126F7B}" GrayHiddenAttributes="Yes" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" Display="Checkbox" LeftText="Yes" />
<ExtendedAttribute Attribute="Owner" Caption="Owner" AttributeID="{3358B5FA-08C0-4DFB-869C-FEEFEB1C49BB}" GrayHiddenAttributes="No" SizeInChars="1" HorizontalResize="Yes" />
</HorizontalLayout> <StandardAttribute Attribute="KeywordList" Caption="Keywords" SizeInChars="1" LineNumber="3" HorizontalResize="Yes" VerticalResize="true" LeftText="false" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>1276524800</a:ModificationDate>
<a:Modifier>obalen</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:FormType>GENERAL</a:FormType>
<a:HelpFile>24912</a:HelpFile>
</o:FormTargetItem>
<o:FormTargetItem Id="o283">
<a:ObjectID>8E605CC9-9153-4D30-96C1-0B0D713729C0</a:ObjectID>
<a:Name>Hidden</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Attribute="CanCreate" Caption="Can create" AttributeID="{FAFA5191-4B2E-4087-BCE3-6EF3058B19BA}" GrayHiddenAttributes="Yes" Display="Checkbox" LeftText="No" />
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>1246366865</a:CreationDate>
<a:Creator>mledier</a:Creator>
<a:ModificationDate>1257761859</a:ModificationDate>
<a:Modifier>mledier</a:Modifier>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:FormType>Dialog</a:FormType>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o284">
<a:TypePublicName>CriterionTargetItem</a:TypePublicName>
<a:ObjectID>B186F72A-EBB8-4762-AEE6-A159D0BD2065</a:ObjectID>
<a:Name>Criteria</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:CriterionTargetItem Id="o285">
<a:ObjectID>066ABFE6-7605-44F9-9247-10E90A158571</a:ObjectID>
<a:Name>isSchema</a:Name>
<a:CriterionTargetItem.Value>(%Schema%)</a:CriterionTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o286">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>F855AC43-4986-451F-AD18-2B3151BF9597</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o287">
<a:ObjectID>3358B5FA-08C0-4DFB-869C-FEEFEB1C49BB</a:ObjectID>
<a:Name>Owner</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Owner of the schema</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>15</a:ExtendedAttributeTargetItem.DataType>
<a:DestinationClassID>4BA9F642-DAB1-11D1-9944-006097355D9B</a:DestinationClassID>
<a:Label>Owner</a:Label>
<a:ValidateDataType>0</a:ValidateDataType>
<c:ExtendedCollection>
<o:ExtendedCollectionTargetItem Ref="o288"/>
</c:ExtendedCollection>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o289">
<a:TypePublicName>ExtendedCollectionTargetItem</a:TypePublicName>
<a:ObjectID>AC0619DB-1C44-4A62-9746-D9EE1B446AD7</a:ObjectID>
<a:Name>Extended Collections</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedCollectionTargetItem Id="o288">
<a:ObjectID>4E7637E8-52C0-48F5-9218-E17C22025290</a:ObjectID>
<a:Name>Owner</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:InverseCollectionName>Schemas</a:InverseCollectionName>
<a:DestinationClassID>4BA9F642-DAB1-11D1-9944-006097355D9B</a:DestinationClassID>
</o:ExtendedCollectionTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:CriterionTargetItem>
<o:CriterionTargetItem Id="o290">
<a:ObjectID>60BBFAB7-C4BD-449F-AA31-C2ABF4D22667</a:ObjectID>
<a:Name>isUser</a:Name>
<a:CriterionTargetItem.Value>(%Schema%==false)</a:CriterionTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o291">
<a:TypePublicName>FormTargetItem</a:TypePublicName>
<a:ObjectID>D36A8DBE-B11A-4D49-B6AB-1081192A5722</a:ObjectID>
<a:Name>Forms</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:FormTargetItem Id="o292">
<a:ObjectID>002FACA9-83F6-4E6C-B3A7-5E79A15E210F</a:ObjectID>
<a:Name>opengauss</a:Name>
<a:FormTargetItem.Value><Form >
<ExtendedAttribute Attribute="SysId" Caption="User identifier (id)" AttributeID="{8F48507A-7C0D-4822-A566-2D7767715205}" GrayHiddenAttributes="Yes" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
<GroupBox Name="GroupBox2" Caption="Special permission" ControlAsLabel="No" >
<HorizontalLayout Name="HorizontalLayout1" Indentation="0" >
<ExtendedAttribute Attribute="CreateDB" Caption="Create database" AttributeID="{8A4EBE2D-8EDB-438E-8160-E66B06BDED64}" GrayHiddenAttributes="Yes" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
<ExtendedAttribute Attribute="CreateUser" Caption="Create user" AttributeID="{664FD4CF-0D90-4BA0-B7EF-A21C2C16B995}" GrayHiddenAttributes="Yes" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
</HorizontalLayout>
</GroupBox>
<GroupBox Name="GroupBox1" Caption="Security" ControlAsLabel="No" >
<ExtendedAttribute Attribute="Validity" Caption="Validity" AttributeID="{E21C45EE-516B-4540-9EC1-B88EFE86A7C9}" GrayHiddenAttributes="Yes" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
<ExtendedAttribute Attribute="EncryptedPassword" Caption="Encrypted password" AttributeID="{89E80C1A-9E8C-4BD5-BCA4-8FCE7EB7D6D7}" GrayHiddenAttributes="Yes" SizeInChars="1" LineNumber="3" HorizontalResize="true" VerticalResize="true" LeftText="false" />
</GroupBox>
</Form>
</a:FormTargetItem.Value>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
</o:FormTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
<o:TypedCategoryTargetItem Id="o293">
<a:TypePublicName>ExtendedAttributeTargetItem</a:TypePublicName>
<a:ObjectID>5D39E586-E369-4646-BA41-950BF52CEE33</a:ObjectID>
<a:Name>Extended Attributes</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:ExtendedAttributeTargetItem Id="o294">
<a:ObjectID>8A4EBE2D-8EDB-438E-8160-E66B06BDED64</a:ObjectID>
<a:Name>CreateDB</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Defines a user's ability to create databases.
If TRUE, the user is allowed to create databases.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.Value>false</a:ExtendedAttributeTargetItem.Value>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o295">
<a:ObjectID>664FD4CF-0D90-4BA0-B7EF-A21C2C16B995</a:ObjectID>
<a:Name>CreateUser</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>If TRUE, the user is allowed to create new users.
This option also turns the user into a superuser who can override all access restrictions.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.Value>false</a:ExtendedAttributeTargetItem.Value>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o296">
<a:ObjectID>89E80C1A-9E8C-4BD5-BCA4-8FCE7EB7D6D7</a:ObjectID>
<a:Name>EncryptedPassword</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Control whether the password is stored encrypted in the system catalogs.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.Value>true</a:ExtendedAttributeTargetItem.Value>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o297">
<a:ObjectID>8F48507A-7C0D-4822-A566-2D7767715205</a:ObjectID>
<a:Name>SysId</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>The SYSID clause can be used to choose the opengauss user ID of the new user. This is normally not necessary, but may be useful if you need to recreate the owner of an orphaned object.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>10</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
<o:ExtendedAttributeTargetItem Id="o298">
<a:ObjectID>E21C45EE-516B-4540-9EC1-B88EFE86A7C9</a:ObjectID>
<a:Name>Validity</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>This clause sets an absolute time after which the user's password is no longer valid. If this clause is omitted the password will be valid for all time.</a:Comment>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:ExtendedAttributeTargetItem.DataType>2</a:ExtendedAttributeTargetItem.DataType>
<a:ValidateDataType>0</a:ValidateDataType>
</o:ExtendedAttributeTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:CriterionTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
<o:MetaClassTargetItem Id="o299">
<a:ObjectID>62B3BA47-41C9-42A1-B298-23FF4E128490</a:ObjectID>
<a:Name>Model</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:TypedCategoryTargetItem Id="o300">
<a:TypePublicName>EventHandlerTargetItem</a:TypePublicName>
<a:ObjectID>128243FB-D24B-4635-B002-E7705C4500CF</a:ObjectID>
<a:Name>Event Handlers</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<c:Categories>
<o:EventHandlerTargetItem Id="o301">
<a:ObjectID>CEE1267A-8981-4459-9BA1-2D512C7DB04D</a:ObjectID>
<a:Name>AfterDatabaseReverseEngineer</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:TargetCategory.Type>1</a:TargetCategory.Type>
<a:HandlerScript>Function %AfterDatabaseReverseEngineer%(model)
Dim tab
For each tab in model.Tables
if (tab.Owner is Nothing) then
tab.ExecuteCustomMethod("%CurrentTargetCode%.SetPublicSchema")
end if
Next
%AfterDatabaseReverseEngineer% = True
End Function</a:HandlerScript>
</o:EventHandlerTargetItem>
</c:Categories>
</o:TypedCategoryTargetItem>
</c:Categories>
</o:MetaClassTargetItem>
</c:Categories>
</o:ProfileTargetItem>
<o:TargetCategory Id="o302">
<a:ObjectID>F45EAD0C-A5E6-4DA5-BF2C-D37E197C36B6</a:ObjectID>
<a:Name>Odbc</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>DBMS characteristics, command definition, and data type translations for the ODBC generation and reverse engineering</a:Comment>
<c:Categories>
<o:TargetCategory Id="o303">
<a:ObjectID>93397FEC-B239-43E0-808E-6C37FE1D55D9</a:ObjectID>
<a:Name>Objects</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Contains sub-categories for each type of object in the database, for example: Table, or Reference. Each sub-category contains entries whose values define database commands and object-related characteristics</a:Comment>
<c:Categories>
<o:TargetCategory Id="o304">
<a:ObjectID>B561F06F-8EA2-4923-9026-BA6D50FCC935</a:ObjectID>
<a:Name>Qualifier</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Manages the use of qualifier in ODBC reverse engineering</a:Comment>
<c:Categories>
<o:BooleanTargetItem Id="o305">
<a:ObjectID>D3ECF29D-3212-414B-B983-755D3A28E865</a:ObjectID>
<a:Name>Enable</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Allows using the qualifier combo box during ODBC reverse engineering</a:Comment>
</o:BooleanTargetItem>
<o:TextTargetItem Id="o306">
<a:ObjectID>6DBE6644-748C-411E-8D24-C9762EF859BA</a:ObjectID>
<a:Name>SqlListQuery</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Query to retrieve qualifier during ODBC reverse engineering</a:Comment>
</o:TextTargetItem>
<o:StringTargetItem Id="o307">
<a:ObjectID>69A5288F-87C6-4041-A68A-E9DDCC5629A4</a:ObjectID>
<a:Name>Label</a:Name>
<a:CreationDate>0</a:CreationDate>
<a:Creator/>
<a:ModificationDate>0</a:ModificationDate>
<a:Modifier/>
<a:Comment>Label for <All> in qualifier selection list</a:Comment>
<a:StringTargetItem.Value>All catalogs</a:StringTargetItem.Value>
</o:StringTargetItem>
</c:Categories>
</o:TargetCategory>
</c:Categories>
</o:TargetCategory>
</c:Categories>
</o:TargetCategory>
</c:Categories>
</o:DBMS>
</DBMS>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手