home *** CD-ROM | disk | FTP | other *** search
/ DOS/V Power Report 1997 May / VPR9705A.ISO / VPR_DATA / PROGRAM / CBTRIAL / SETUP / DATA.Z / DBX.DBI < prev    next >
Windows Setup INFormation  |  1997-02-14  |  18KB  |  381 lines
  1.  
  2.  
  3. [Version]
  4. DbXVersion=1.02
  5.  
  6. [Properties]
  7. NET PROTOCOL:Values1=TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  8. NET PROTOCOL:Values2=APPC,ASYNC
  9. OPEN MODE:Values=READ/WRITE,READ ONLY
  10. SHARE MODE:Values=EXCLUSIVE,SHARED
  11. STRICTINTEGRTY:Values=FALSE,TRUE
  12. SQLPASSTHRU MODE:Values=NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  13. LIST SYNONYMS:Values=NONE,ALL,PRIVATE
  14. BLOB EDIT LOGGING:Values=FALSE,TRUE
  15. DEFAULT DRIVER:Values=PARADOX,DBASE
  16. ENABLE SCHEMA CACHE:Values=FALSE,TRUE
  17.  
  18.  
  19.  
  20. [Standard Properties]
  21. DriverType:Values=PARADOX="Paradox",DBASE="dBase"
  22. BooleanYesNo:Values=0="No",-1="Yes"
  23. FieldVChecks:Values=0="",1="Has Validity Checks",2=""
  24. FieldRights:Values=0="Read/Write",1="Read Only",2="None",3=""
  25. PrimaryIndex:Values=="<Primary>"
  26. LookupType:Values1=0="None",1="Current Field",2="All Corresponding"
  27. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  28. ReferenceType:Values=0="Master Of",1="Detail Of"
  29. ReferenceQual:Values=0="Restrict",1="Cascade"
  30. PrivilegeType:Values1=0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  31. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=""
  32. FamilyRightsType:Values=0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  33. FamilyMemberType:Values1=0="Unknown",1="Table",2="Index",3="Form",4="Report"
  34. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  35. FamilyMemberType:Values3=8="Blob File"
  36.  
  37. Standard:Objects=O:"Tables"=Table
  38.  
  39. Table:Attrs1=TYPE="Type"::NR:VM:DriverType,DATE="Date",TIME="Time",VERSION="Version":2
  40. Table:Attrs2=VALID="Valid":2::VM:BooleanYesNo,STRUCTURE="Structure":2
  41. Table:Attrs3=PROTECTED="Protected":2::VM:BooleanYesNo
  42. Table:Name=FILENAME,EXTENSION
  43. Table:Objects1=O:"Fields"=Column,O:"Indices"=Index,O:"Validity Checks"=ValCheck
  44. Table:Objects2=O:"Referential Constraints"=Reference,O:"Security Specs"=Security
  45. Table:Objects3=O:"Family Members"=Family
  46.  
  47. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  48. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  49. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  50.  
  51. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  52. Column:Attrs2=LENGTH="Physical Length"
  53. Column:Name=NAME
  54.  
  55. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  56. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  57. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  58. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  59. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  60. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  61.  
  62. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  63. Index:Attrs2=PRIMARY="Primary Key":::VM:BooleanYesNo,UNIQUE="Unique"::NR:VM:BooleanYesNo
  64. Index:Attrs3=AUTO="Maintained":2::VM:BooleanYesNo
  65. Index:Attrs4=OUTOFDATE="Out of Date":2::VM:BooleanYesNo
  66. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Block Size":2
  67. Index:Attrs6=CASEINSENSITIVE="Case Insensitive":2:NR:VM:BooleanYesNo
  68. Index:Attrs7=DESCENDING="Descending":2:NR:VM:BooleanYesNo
  69. Index:Attrs8=EXPRESSION="Expression":2:N
  70. Index:Attrs9=CONDITION="Subset Condition":2:N
  71. Index:Name=Name,Tag
  72.  
  73. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  74. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  75. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  76. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  77.  
  78. ValCheck:Attrs1=FIELDNUM="Field":2:NR,REQUIRED="Required":1:NR:VM:BooleanYesNo
  79. ValCheck:Attrs2=MINVALUE="Min Value":1:N,MAXVALUE="Max Value":1:N
  80. ValCheck:Attrs3=DEFAULT="Default Value":1:N,PICTURE="Picture":2:N
  81. ValCheck:Name="Field"
  82.  
  83. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  84.  
  85. Family:Attrs=TYPE="Type":1::VM:FamilyMemberType,NAME="Object Name":1
  86. Family:Name=FILENAME
  87.  
  88. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  89. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  90. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  91.  
  92. Reference:Attrs1=TYPE="Reference Type":1::VM:ReferenceType
  93. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  94. Reference:Attrs3=MODOP="Modify Operation":1:NR:VM:ReferenceQual
  95. Reference:Attrs4=DELOP="Delete Operation":1:NR:VM:ReferenceQual
  96. Reference:Name=NAME
  97.  
  98. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  99. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  100.  
  101. Security:Attrs1=TYPE="Table Rights":1:NR:VM:PrivilegeType
  102. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:VS:FamilyRightsType:$0F
  103. Security:Name=PASSWORD
  104.  
  105. [ODBC Properties]
  106. DriverType:Values=PARADOX="Paradox",DBASE="dBase"
  107. BooleanYesNo:Values=0="No",-1="Yes"
  108. FieldVChecks:Values=0="",1="Has Validity Checks",2=""
  109. FieldRights:Values=0="Read/Write",1="Read Only",2="None",3=""
  110. PrimaryIndex:Values=="<Primary>"
  111. LookupType:Values1=0="None",1="Current Field",2="All Corresponding"
  112. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  113. ReferenceType:Values=0="Master Of",1="Detail Of"
  114. ReferenceQual:Values=0="Restrict",1="Cascade"
  115. PrivilegeType:Values1=0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  116. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=""
  117. FamilyRightsType:Values=0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  118.  
  119. ODBC:Objects=O:"Tables"=Table,O:"Stored Procedures"=Procedure
  120.  
  121. Table:Attrs1=TYPE="Type"::NR:VM:DriverType,DATE="Date",TIME="Time",VERSION="Version":2
  122. Table:Attrs2=VALID="Valid":2::VM:BooleanYesNo,STRUCTURE="Structure":2
  123. Table:Attrs3=PROTECTED="Protected":2::VM:BooleanYesNo
  124. Table:Name=FILENAME,EXTENSION
  125. Table:Objects1=O:"Fields"=Column,O:"Indices"=Index,O:"Validity Checks"=ValCheck
  126. Table:Objects2=O:"Referential Constraints"=Reference,O:"Security Specs"=Security
  127.  
  128. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  129. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  130. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  131.  
  132. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  133. Column:Attrs2=LENGTH="Physical Length"
  134. Column:Name=NAME
  135.  
  136. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  137. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  138. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  139. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  140. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  141. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  142.  
  143. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  144. Index:Attrs2=PRIMARY="Primary Key":::VM:BooleanYesNo,UNIQUE="Unique"::NR:VM:BooleanYesNo
  145. Index:Attrs3=AUTO="Maintained":2::VM:BooleanYesNo
  146. Index:Attrs4=OUTOFDATE="Out of Date":2::VM:BooleanYesNo
  147. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Block Size":2
  148. Index:Attrs6=CASEINSENSITIVE="Case Insensitive":2:NR:VM:BooleanYesNo
  149. Index:Attrs7=DESCENDING="Descending":2:NR:VM:BooleanYesNo
  150. Index:Attrs8=EXPRESSION="Expression":2:N
  151. Index:Attrs9=CONDITION="Subset Condition":2:N
  152. Index:Name=Name,Tag
  153.  
  154. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  155. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  156. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  157. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  158.  
  159. ValCheck:Attrs1=FIELDNUM="Field":2:NR,REQUIRED="Required":1:NR:VM:BooleanYesNo
  160. ValCheck:Attrs2=MINVALUE="Min Value":1:N,MAXVALUE="Max Value":1:N
  161. ValCheck:Attrs3=DEFAULT="Default Value":1:N,PICTURE="Picture":2:N
  162. ValCheck:Name="Field"
  163.  
  164. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  165. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  166. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  167.  
  168. Reference:Attrs1=TYPE="Reference Type":1::VM:ReferenceType
  169. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  170. Reference:Attrs3=MODOP="Modify Operation":1:NR:VM:ReferenceQual
  171. Reference:Attrs4=DELOP="Delete Operation":1:NR:VM:ReferenceQual
  172. Reference:Name=NAME
  173.  
  174. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  175. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  176.  
  177. Security:Attrs1=TYPE="Table Rights":1:NR:VM:PrivilegeType
  178. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:VS:FamilyRightsType:$0F
  179. Security:Name=PASSWORD
  180.  
  181. Procedure:Name=NAME
  182.  
  183.  
  184.  
  185.  
  186. [InterBase Properties]
  187. FieldType:Values1=7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  188. FieldType:Values2=11=double,14=CHAR,27=DOUBLE,35=DATE
  189. FieldType:Values3=37=VARCHAR,40=CSTRING,261=BLOB
  190. FieldSubType:Values1=0=,1="Text",2="BLR",3="ACL",4="Ranges",5="Summary"
  191. FieldSubType:Values2=6="Format",7="Transaction Desc",8="Ext File Desc"
  192. Boolean01:Values=="No",0="No",1="Yes"
  193. BlankYes:Values=="Yes",1="No"
  194. ParameterType:Values=0="Input",1="Output"
  195. TriggerType:Values1=1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  196. TriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  197.  
  198. InterBase:Objects1=O:"Domains"=Domain,O:"Tables"=Table,O:"Views"=View
  199. InterBase:Objects2=O:"Stored Procedures"=Procedure,O:"Triggers"=Trigger
  200. InterBase:Objects3=O:"Generators"=Generator,O:"Exceptions"=Exception
  201.  
  202. Table:Root=RDB$RELATIONS
  203. View:Root=RDB$RELATIONS
  204. Procedure:Root=RDB$PROCEDURES
  205. Trigger:Root=RDB$TRIGGERS
  206. PrimaryKey:Root=RDB$RELATION_CONSTRAINTS
  207. ForeignKey:Root=RDB$RELATION_CONSTRAINTS
  208. UniqueConstraint:Root=RDB$RELATION_CONSTRAINTS
  209. CheckConstraint:Root=RDB$RELATION_CONSTRAINTS
  210. Exception:Root=RDB$EXCEPTIONS
  211. Generator:Root=RDB$GENERATORS
  212. Index:Root=RDB$INDICES
  213. IndexColumn:Root=RDB$INDEX_SEGMENTS
  214. Column:Root=RDB$RELATION_FIELDS
  215. Domain:Root=RDB$FIELDS
  216. Enumeration:Root=RDB$TYPES
  217. FormalParameter:Root=RDB$PROCEDURE_PARAMETERS
  218.  
  219. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner",RDB$DESCRIPTION="Description"
  220. RDB$RELATIONS:Objects=T:"Columns"=Column
  221. RDB$RELATIONS:Name=RDB$RELATION_NAME
  222. RDB$RELATIONS:Reference:"Columns"=RDB$RELATION_NAME=RDB$RELATION_NAME
  223. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  224.  
  225. RDB$RELATION_FIELDS:Keys=RDB$FIELD_POSITION
  226. RDB$RELATION_FIELDS:Objects=T:"Domain"=Domain
  227. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  228. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  229.  
  230. RDB$FIELDS:Objects=T:"Values"=Enumeration
  231. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE="Type":::VM:FieldType
  232. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE="Subtype":::VM:FieldSubType
  233. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH="Length",RDB$FIELD_SCALE="Scale"
  234. RDB$FIELDS:Attrs4=RDB$NULL_FLAG="Nulls"::R:VM:BlankYes
  235. RDB$FIELDS:Attrs5=RDB$SEGMENT_LENGTH="Segment Size":2
  236. RDB$FIELDS:Attrs6=RDB$DEFAULT_SOURCE="Default":2:R
  237. RDB$FIELDS:Attrs7=RDB$VALIDATION_SOURCE="Constraint":2:R
  238. RDB$FIELDS:Attrs8=RDB$DESCRIPTION="Description"
  239. RDB$FIELDS:Name=RDB$FIELD_NAME
  240. RDB$FIELDS:Reference:"Values"=RDB$FIELD_NAME=RDB$FIELD_NAME
  241.  
  242. RDB$INDICES:Objects=T:"Columns"=IndexColumn
  243. RDB$INDICES:Attrs=RDB$UNIQUE_FLAG="Unique":::VM:Boolean01
  244. RDB$INDICES:Name=RDB$INDEX_NAME
  245. RDB$INDICES:Reference:"Columns"=RDB$INDEX_NAME=RDB$INDEX_NAME
  246. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  247.  
  248. RDB$INDEX_SEGMENTS:Keys=RDB$FIELD_POSITION
  249. RDB$INDEX_SEGMENTS:Name=RDB$FIELD_NAME
  250.  
  251. RDB$PROCEDURES:Objects=T:"Parameters"=FormalParameter
  252. RDB$PROCEDURES:Attrs=RDB$OWNER_NAME="Owner"
  253. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  254. RDB$PROCEDURES:Reference:"Parameters"=RDB$PROCEDURE_NAME=RDB$PROCEDURE_NAME
  255. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  256.  
  257. RDB$PROCEDURE_PARAMETERS:Keys=RDB$PARAMETER_TYPE,RDB$PARAMETER_NUMBER
  258. RDB$PROCEDURE_PARAMETERS:Objects=T:"Domain"=Domain
  259. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  260. RDB$PROCEDURE_PARAMETERS:Attrs=RDB$PARAMETER_TYPE="Parameter Kind":::VM:ParameterType
  261. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  262.  
  263. FormalParameter:Attrs:Q1="Type":2::VM:FieldType
  264. FormalParameter:Attrs:Q2="Subtype":2::VM:FieldSubType
  265. FormalParameter:Attrs:Q3="Length":2,"Scale":2
  266. FormalParameter:AttrReference:"Type"1=select RDB$FIELD_TYPE from RDB$FIELDS
  267. FormalParameter:AttrReference:"Type"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  268. FormalParameter:AttrReference:"Subtype"1=select RDB$FIELD_SUB_TYPE from RDB$FIELDS
  269. FormalParameter:AttrReference:"Subtype"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  270. FormalParameter:AttrReference:"Length"1=select RDB$FIELD_LENGTH from RDB$FIELDS
  271. FormalParameter:AttrReference:"Length"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  272. FormalParameter:AttrReference:"Scale"1=select RDB$FIELD_SCALE from RDB$FIELDS
  273. FormalParameter:AttrReference:"Scale"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  274.  
  275. RDB$TYPES:Keys=RDB$TYPE
  276. RDB$TYPES:Attrs=RDB$TYPE="Value"
  277. RDB$TYPES:Name=RDB$TYPE_NAME
  278. RDB$TYPES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  279.  
  280. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  281. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  282.  
  283. Generator:Attrs:Q="Current Value":2
  284. Generator:AttrReference:"Current Value"1=select distinct gen_id(%VRDB$GENERATOR_NAME%, 0)
  285. Generator:AttrReference:"Current Value"2=from RDB$GENERATORS
  286.  
  287. RDB$EXCEPTIONS:Keys=RDB$EXCEPTION_NUMBER
  288. RDB$EXCEPTIONS:Attrs=RDB$EXCEPTION_NUMBER="Code",RDB$MESSAGE="Message"
  289. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  290.  
  291. RDB$TRIGGERS:Objects=T:"Table"=Table
  292. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE="Type":::VM:TriggerType
  293. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE="Sequence"
  294. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  295. RDB$TRIGGERS:Reference:"Table"=RDB$RELATION_NAME=RDB$RELATION_NAME
  296. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  297.  
  298. RDB$RELATION_CONSTRAINTS:Objects=T:"Table"=Table,T:"Columns"=IndexColumn
  299. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  300. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  301. RDB$RELATION_CONSTRAINTS:Attrs3=RDB$INDEX_NAME="Index"
  302. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  303. RDB$RELATION_CONSTRAINTS:Reference:"Table"=RDB$RELATION_NAME=RDB$RELATION_NAME
  304. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME=RDB$INDEX_NAME
  305.  
  306. RDB$REF_CONSTRAINTS:Objects=T:"Primary Key"=PrimaryKey,T:"Foreign Key"=ForeignKey
  307. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  308. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  309. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  310. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  311. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  312. RDB$REF_CONSTRAINTS:Name=RDB$CONST_NAME_UQ
  313. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  314. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  315.  
  316. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  317. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  318.  
  319. Table:Values=RDB$VIEW_SOURCE:is null
  320. Table:Objects1=T:"Indices"=Index,T:"Primary Key"=PrimaryKey
  321. Table:Objects2=T:"Foreign Keys"=ForeignKey,T:"Check Constraints"=CheckConstraint
  322. Table:Objects3=T:"Unique Constraints"=UniqueConstraint,T:"Triggers"=Trigger
  323. Table:Actions=Data
  324. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  325. Table:Reference:"Primary Key"=RDB$RELATION_NAME=RDB$RELATION_NAME
  326. Table:Reference:"Foreign Keys"=RDB$RELATION_NAME=RDB$RELATION_NAME
  327. Table:Reference:"Check Constraints"=RDB$RELATION_NAME=RDB$RELATION_NAME
  328. Table:Reference:"Unique Constraints"=RDB$RELATION_NAME=RDB$RELATION_NAME
  329. Table:Reference:"Triggers"=RDB$RELATION_NAME=RDB$RELATION_NAME
  330. Table:Actions:Delete=DROP TABLE %N%
  331. Table:Actions:Save=COMMIT
  332.  
  333. View:Values=RDB$VIEW_SOURCE:is not null
  334. View:Actions=Data
  335. View:Attrs:Q="Text"
  336. View:AttrReference:"Text"1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  337. View:AttrReference:"Text"2=where RDB$RELATION_ID=%CRDB$RELATION_ID%
  338. View:Actions:Delete=DROP VIEW %N%
  339. View:Actions:Save=COMMIT
  340.  
  341. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_SCALE="Scale":RDB$RELATION_NAME
  342. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_LENGTH="Length":"Scale"
  343. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_SUB_TYPE="Subtype":"Length"
  344. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_TYPE="Type":"Subtype"
  345. Column:AttrReference:"Scale"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  346. Column:AttrReference:"Length"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  347. Column:AttrReference:"Subtype"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  348. Column:AttrReference:"Type"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  349.  
  350. Procedure:Actions=
  351. Procedure:Attrs:Q="Text"
  352. Procedure:AttrReference:"Text"1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  353. Procedure:AttrReference:"Text"2=where RDB$PROCEDURE_NAME=%CRDB$PROCEDURE_NAME%
  354.  
  355. UniqueConstraint:Values=RDB$CONSTRAINT_TYPE:=UNIQUE
  356.  
  357. CheckConstraint:Values=RDB$CONSTRAINT_TYPE:=CHECK
  358. CheckConstraint:Attrs:Q="Text"
  359. CheckConstraint:AttrReference:"Text"1=select t.RDB$TRIGGER_SOURCE
  360. CheckConstraint:AttrReference:"Text"2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  361. CheckConstraint:AttrReference:"Text"3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  362. CheckConstraint:AttrReference:"Text"4=t.RDB$TRIGGER_TYPE=1 and
  363. CheckConstraint:AttrReference:"Text"5=c.RDB$CONSTRAINT_NAME=%CRDB$CONSTRAINT_NAME%
  364.  
  365. PrimaryKey:Values=RDB$CONSTRAINT_TYPE:=PRIMARY KEY
  366.  
  367. ForeignKey:Values=RDB$CONSTRAINT_TYPE:=FOREIGN KEY
  368. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION="Match Option"
  369. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE="Update Rule"
  370. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE="Delete Rule"
  371. ForeignKey:AttrReference:"Match Option"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  372. ForeignKey:AttrReference:"Update Rule"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  373. ForeignKey:AttrReference:"Delete Rule"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  374.  
  375. Trigger:Actions=
  376. Trigger:Attrs:Q="Text"
  377. Trigger:AttrReference:"Text"1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  378. Trigger:AttrReference:"Text"2=where RDB$TRIGGER_NAME=%CRDB$TRIGGER_NAME%
  379.  
  380.  
  381.