Re: [Firebird-devel] XML Load/Dump Utility

[Lester C. <le...@ls...>]

Jim Starkey wrote:

> <?xml version="1.0" encoding="US-ASCII"?>
> <database>
>   <metadata>
>      <table name="RDB$TRIGGERS">
>         <column name="RDB$TRIGGER_NAME" type="char" precision="32"/>
>         <column name="RDB$RELATION_NAME" type="char" precision="32"/>
>         <column name="RDB$TRIGGER_SEQUENCE" type="smallint"/>
>         <column name="RDB$TRIGGER_TYPE" type="smallint"/>
>         <column name="RDB$TRIGGER_SOURCE" type="clob"/>
>         <column name="RDB$TRIGGER_BLR" type="blob"/>
>         <column name="RDB$DESCRIPTION" type="clob"/>
>         <column name="RDB$TRIGGER_INACTIVE" type="smallint"/>
>         <column name="RDB$SYSTEM_FLAG" type="smallint"/>
>         <column name="RDB$FLAGS" type="smallint"/>
>         <index name="RDB$INDEX_38">
>            <column name="RDB$RELATION_NAME"/>
>         </index>
>         <index name="RDB$INDEX_8" type="unique">
>            <column name="RDB$TRIGGER_NAME"/>
>         </index>
>      </table>
>   </metadata>
>   <data>
>      <rows table="RDB$TRIGGERS">
>         <row>
>            <column name="RDB$TRIGGER_NAME">RDB$TRIGGER_1</column>
>            <column name="RDB$RELATION_NAME">RDB$USER_PRIVILEGES</column>
>            <column name="RDB$TRIGGER_SEQUENCE">0</column>
>            <column name="RDB$TRIGGER_TYPE">3</column>
>            <column name="RDB$TRIGGER_BLR" 
> encoding="base64">/F6.H.**</column>
>            <column name="RDB$SYSTEM_FLAG">1</column>
>         </row>
>         <row>
>            <column name="RDB$TRIGGER_NAME">RDB$TRIGGER_8</column>
>            <column name="RDB$RELATION_NAME">RDB$USER_PRIVILEGES</column>
>            <column name="RDB$TRIGGER_SEQUENCE">0</column>
>            <column name="RDB$TRIGGER_TYPE">5</column>
>            <column name="RDB$TRIGGER_BLR" 
> encoding="base64">/EUvDFQ.1Z72EWF4GIJAF3xCEIp3/oA/GVBGF26YIYJAEJF7HotTFYZ3H2FH 
> 
> .oQu9lQ12J72EWFGFIl/J2ZDHZxCEIp33k.FIYF07373H23IGIxCLot/HIIj
> 3kACIYF072N7FIl2Lot/HIIL..tGF26YFYZ3H2FTHY3BFTw001QL.l7GF26Y
> IoJ1JJ77J3ZTEol/IpAJ1UY.Ip3A72RGEItI.UR1.IcIIYF073B3EpJGGJFN
> LoBAEJBHFJA2FmwL//7GF26YIoJ1JJ77J3ZTEol/IpAL.l7GF26YIoJ1JJ77
> J3ZTEol/IpDz.UI2zkc1/E6/9FQ32Z72EWFHFIBJIYZIKJx1H23HIzzzzzzz
> H.**</column>
>            <column name="RDB$SYSTEM_FLAG">1</column>
>         </row>

Looking nice - but what about
default="xxx"
and how about 'Not Null'?

Also Primary Key?


-- 
Lester Caine
-----------------------------
L.S.Caine Electronic Services