home *** CD-ROM | disk | FTP | other *** search
/ PC Expert 29 / Pce29cd.iso / RUNIMAGE / DELPHI40 / BIN / DBX.DBI < prev    next >
Windows Setup INFormation  |  1998-06-16  |  40KB  |  882 lines
  1.  
  2.  
  3. [Version]
  4. DbXName="Database Explorer"
  5. DbXDR=True
  6. DbXVersion=3.00
  7.  
  8. [Properties]
  9. DEFAULT DRIVER:Values=Closed,PARADOX,DBASE,FOXPRO,ASCIIDRV
  10. NET PROTOCOL:Values1=Closed,TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  11. NET PROTOCOL:Values2=APPC,ASYNC
  12. OPEN MODE:Values=Closed,READ/WRITE,READ ONLY
  13. SHARE MODE:Values=Closed,EXCLUSIVE,SHARED
  14. STRICTINTEGRTY:Values=Closed,FALSE,TRUE
  15. SQLPASSTHRU MODE:Values=Closed,NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  16. LIST SYNONYMS:Values=Closed,NONE,ALL,PRIVATE
  17. BLOB EDIT LOGGING:Values=Closed,FALSE,TRUE
  18. ENABLE SCHEMA CACHE:Values=Closed,FALSE,TRUE
  19. ENABLE BCD:Values=Closed,FALSE,TRUE
  20. ENABLE INTEGERS:Values=Closed,FALSE,TRUE
  21. LOCAL SHARE:Values=Closed,FALSE,TRUE
  22. MTS POOLING:Values=Closed,FALSE,TRUE
  23. OBJECT MODE:Values=Closed,FALSE,TRUE
  24. AUTO ODBC:Values=Closed,FALSE,TRUE
  25. FOURDIGITYEAR:Values=Closed,FALSE,TRUE
  26. YEARBIASED:Values=Closed,FALSE,TRUE
  27. LEADINGZEROM:Values=Closed,FALSE,TRUE
  28. LEADINGZEROD:Values=Closed,FALSE,TRUE
  29. TWELVEHOUR:Values=Closed,FALSE,TRUE
  30. SECONDS:Values=Closed,FALSE,TRUE
  31. MILSECONDS:Values=Closed,FALSE,TRUE
  32. LEADINGZERON:Values=Closed,FALSE,TRUE
  33. COLLCHAR:Values=Closed,0,1,2
  34. DBNLS:Values=Closed,0,1,2
  35. SQLQRYMODE:Values=Closed,LOCAL,SERVER
  36.  
  37. :HelpContext=4039
  38. DB2:HelpContext=4038
  39. INFORMIX:HelpContext=4035
  40. INTRBASE:HelpContext=4037
  41. MSACCESS:HelpContext=4042
  42. MSSQL:HelpContext=4036
  43. ORACLE:HelpContext=4034
  44. STANDARD:HelpContext=4045
  45. SYBASE:HelpContext=4033
  46.  
  47.  
  48. [DATAREP Properties]
  49. BDETypes:Values1=Closed,1=ZString,2=Date,3=Blob,4=Bool,5=Int16,6=Int32
  50. BDETypes:Values2=7=Float,8=BCD,9=Bytes,10=Time,11=TimeStamp,12=UInt16
  51. BDETypes:Values3=13=UInt32,14=IEEE Float,15=VarBytes,16=LockInfo
  52. BDETypes:Values4=17=Cursor,18=Int64,19=UInt64,20=ADT,21=Array,22=Ref,23=Table
  53.  
  54. BDESubTypes:Values1=Closed,0=,1=Password,21=Money,22=Memo,23=Binary
  55. BDESubTypes:Values2=24=Formatted Memo,25=OLE Object,26=Graphic
  56. BDESubTypes:Values3=27=DBase OLE Object,28=Typed Binary,29=Auto Increment
  57.  
  58. TScale:Values=Open,0=
  59. TBooleanTF:Values=Closed,0=False,-1=True
  60. TAlignment:Values=Closed,0=taLeftJustify,1=taRightJustify,2=taCenter
  61.  
  62. TFieldType:Values1=Closed,0=ftUnknown,1=ftString,2=ftSmallint,3=ftInteger
  63. TFieldType:Values2=4=ftWord,5=ftBoolean,6=ftFloat,7=ftCurrency,8=ftBCD
  64. TFieldType:Values3=9=ftDate,10=ftTime,11=ftDateTime,12=ftBytes
  65. TFieldType:Values4=13=ftVarBytes,14=ftAutoInc,15=ftBlob,16=ftMemo
  66. TFieldType:Values5=17=ftGraphic,18=ftFmtMemo,19=ftParadoxOle
  67. TFieldType:Values6=20=ftDBaseOle,21=ftTypedBinary
  68.  
  69. TBlobType:Values1=Closed,15=ftBlob,16=ftMemo,17=ftGraphic,18=ftFmtMemo
  70. TBlobType:Values2=19=ftParadoxOle,20=ftDBaseOle,21=ftTypedBinary
  71.  
  72. DRDATABASES:Reference="Databases"
  73. DREXTFIELDS:Reference="Attribute Sets"
  74. DBTABLES:Reference="Tables"
  75. TABLEFLDS:Reference="Fields"
  76. FLDEXTFIELD:Reference="Attribute Set"
  77. EXTFIELDFLDS:Reference="Referencing Fields"
  78. PARENTEXTFIELD:Reference="Based On"
  79. CHILDEXTFIELD:Reference="Referencing Attribute Sets"
  80.  
  81. DATABASE:Category=Database
  82. DATABASE:NameRE=.*
  83. DATABASE:Attrs=DBPATH="Path":0:-E,DBTYPE="Type"::-E
  84.  
  85. TABLE:Category=Dataset
  86. TABLE:NameRE=.*
  87. TABLE:Attrs=PATH=:0,DRIVERTYPE="Type"::-E,ISFILE=:0,ISVIEW=:0,ISSYNONYM=:0
  88.  
  89. FIELD:Category=Column
  90. FIELD:Attrs1=PHYTYPE="Physical Type"::-E
  91. FIELD:Attrs2=LOGTYPE="Logical Type"::-E:::VM=BDETypes
  92. FIELD:Attrs3=LOGSUBTYPE="Logical Subtype"::-E:::VM=BDESubTypes
  93. FIELD:Attrs4=UNITS1="Size"::-E
  94. FIELD:Attrs5=UNITS2="Scale"::-E:::VM=TScale
  95. FIELD:Attrs6=DEFVAL=:2:-E
  96. FIELD:Attrs7=MINVAL=:2:-E
  97. FIELD:Attrs8=MAXVAL=:2:-E
  98. FIELD:Attrs9=REQUIRED=:2:-E:::VM=TBooleanTF
  99. FIELD:Attrs10=READONLY=:2:-E:::VM=TBooleanTF
  100.  
  101. EXTFIELD:NameRE=.*
  102. EXTFIELD:Attrs1=FIELDCLASS=:1
  103. EXTFIELD:Attrs2=CONTROLCLASS=:1
  104. EXTFIELD:Attrs3=ALIGNMENT=:2::::VM=TAlignment
  105. EXTFIELD:Attrs4=DISPLABEL=:2
  106. EXTFIELD:Attrs5=DISPWIDTH=:2
  107. EXTFIELD:Attrs6=READONLY=:2::::VM=TBooleanTF
  108. EXTFIELD:Attrs7=REQUIRED=:2::::VM=TBooleanTF
  109. EXTFIELD:Attrs8=VISIBLE=:2::::VM=TBooleanTF
  110. EXTFIELD:Attrs9=TRANSLITERATE=:2::::VM=TBooleanTF
  111. EXTFIELD:Attrs10=EDITMASK=:2
  112. EXTFIELD:Attrs11=DISPFORMAT=:2
  113. EXTFIELD:Attrs12=EDITFORMAT=:2
  114. EXTFIELD:Attrs13=MINVAL=:2
  115. EXTFIELD:Attrs14=MAXVAL=:2
  116. EXTFIELD:Attrs15=CURRENCY=:2::::VM=TBooleanTF
  117. EXTFIELD:Attrs16=PRECISION=:2
  118. EXTFIELD:Attrs17=DISPLAYVALUES=:2
  119. EXTFIELD:Attrs18=BLOBTYPE=:2::::VM=TBlobType
  120.  
  121. [DATAREP 20 Properties]
  122. TABLECONSTRS:Reference="Check Constraints"
  123.  
  124. CONSTRAINT:NameRE=.*
  125. CONSTRAINT:Attrs1=SRVCHECK=:2:-E
  126. CONSTRAINT:Attrs2=LOCCHECK=:2
  127. CONSTRAINT:Attrs3=ERRORSTR=:2
  128.  
  129. EXTFIELD:Attrs1=SRVDOMAINNAME=:1:-E
  130. EXTFIELD:Attrs2=FIELDCLASS=:1
  131. EXTFIELD:Attrs3=CONTROLCLASS=:1
  132. EXTFIELD:Attrs4=ALIGNMENT=:2::::VM=TAlignment
  133. EXTFIELD:Attrs5=DISPLABEL=:2
  134. EXTFIELD:Attrs6=DISPWIDTH=:2
  135. EXTFIELD:Attrs7=READONLY=:2::::VM=TBooleanTF
  136. EXTFIELD:Attrs8=REQUIRED=:2::::VM=TBooleanTF
  137. EXTFIELD:Attrs9=VISIBLE=:2::::VM=TBooleanTF
  138. EXTFIELD:Attrs10=TRANSLITERATE=:2::::VM=TBooleanTF
  139. EXTFIELD:Attrs11=EDITMASK=:2
  140. EXTFIELD:Attrs12=DISPFORMAT=:2
  141. EXTFIELD:Attrs13=EDITFORMAT=:2
  142. EXTFIELD:Attrs14=MINVAL=:2
  143. EXTFIELD:Attrs15=MAXVAL=:2
  144. EXTFIELD:Attrs16=CURRENCY=:2::::VM=TBooleanTF
  145. EXTFIELD:Attrs17=PRECISION=:2
  146. EXTFIELD:Attrs18=DISPLAYVALUES=:2
  147. EXTFIELD:Attrs19=BLOBTYPE=:2::::VM=TBlobType
  148. EXTFIELD:Attrs20=DEFAULT=:2
  149. EXTFIELD:Attrs21=SRVCHECK=:2:-E
  150. EXTFIELD:Attrs22=LOCCHECK=:2
  151. EXTFIELD:Attrs23=ERRORSTR=:2
  152.  
  153. [STANDARD Properties]
  154. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  155. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  156. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  157. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  158. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  159. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  160. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  161. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  162. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  163. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  164. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  165. FamilyMemberType:Values1=Closed,0="Unknown",1="Table",2="Index",3="Form",4="Report"
  166. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  167. FamilyMemberType:Values3=8="Blob File"
  168.  
  169. STANDARD:Objects=O:C:0M::"Tables":Table
  170.  
  171. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  172. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  173. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  174. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  175. Table:Dataset5=PROTECTED=Word,VALID=Word
  176.  
  177. Table:Category=Dataset
  178. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  179. Table:Attrs2=DATE="Date"
  180. Table:Attrs3=TIME="Time"
  181. Table:Attrs4=VERSION="Version":2
  182. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  183. Table:Attrs6=STRUCTURE="Structure":2
  184. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  185. Table:Name=FILENAME,EXTENSION
  186. Table:Objects1=O:P:1M::"Fields":Column
  187. Table:Objects2=O:O:0M::"Indices":Index
  188. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  189. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  190. Table:Objects5=O:O:0M::"Security Specs":Security
  191. Table:Objects6=O:C:1M::"Family Members":Family
  192.  
  193. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  194. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  195. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  196.  
  197. Column:Category=Column
  198. Column:Order=FIELDNUM
  199. Column:Attrs1=FIELDNUM="Order":2:NR
  200. Column:Attrs2=TYPE="Type":1:NR
  201. Column:Attrs3=UNITS1="Size":1:N
  202. Column:Attrs4=UNITS2="Scale":1:N
  203. Column:Attrs5=LENGTH="Physical Length"
  204. Column:Name=NAME
  205.  
  206. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  207. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  208. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  209. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  210. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  211. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  212.  
  213. Index:Category=Index
  214. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  215. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  216. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  217. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  218. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  219. Index:Attrs6=FORMAT="Format":2
  220. Index:Attrs7=BLOCKSIZE="Block Size":2
  221. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  222. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  223. Index:Attrs10=EXPRESSION="Expression":2:N
  224. Index:Attrs11=CONDITION="Subset Condition":2:N
  225. Index:Name=NAME
  226. Index:OnAfterLoad=GetIndexInfo
  227.  
  228. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  229. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  230. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  231. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  232.  
  233. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  234. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  235. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  236. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  237. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  238. ValCheck:Attrs6=PICTURE="Picture":2:N
  239. ValCheck:Name=FIELDNUM
  240.  
  241. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  242.  
  243. Family:Attrs1=TYPE="Type":1::::VM=FamilyMemberType
  244. Family:Attrs2=NAME="Object Name":1
  245. Family:Name=FILENAME
  246.  
  247. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  248. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  249. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  250.  
  251. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  252. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  253. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  254. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  255. Reference:Name=NAME
  256. Reference:OnAfterLoad=GetReferenceInfo
  257.  
  258. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  259. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  260.  
  261. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  262. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  263. Security:Name=PASSWORD
  264.  
  265. [MSACCESS Properties]
  266. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  267. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  268. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  269. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  270. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  271. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  272. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  273. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  274. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  275. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  276. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  277.  
  278. MSACCESS:Objects=O:C:0M::"Tables":Table
  279.  
  280. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  281. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  282. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  283. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  284. Table:Dataset5=PROTECTED=Word,VALID=Word
  285.  
  286. Table:Category=Dataset
  287. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  288. Table:Attrs2=DATE="Date"
  289. Table:Attrs3=TIME="Time"
  290. Table:Attrs4=VERSION="Version":2
  291. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  292. Table:Attrs6=STRUCTURE="Structure":2
  293. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  294. Table:Name=FILENAME,EXTENSION
  295. Table:Objects1=O:P:1M::"Fields":Column
  296. Table:Objects2=O:O:0M::"Indices":Index
  297. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  298. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  299. Table:Objects5=O:O:0M::"Security Specs":Security
  300.  
  301. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  302. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  303. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  304.  
  305. Column:Category=Column
  306. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  307. Column:Attrs2=LENGTH="Physical Length"
  308. Column:Name=NAME
  309.  
  310. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  311. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  312. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  313. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  314. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  315. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  316.  
  317. Index:Category=Index
  318. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  319. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  320. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  321. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  322. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  323. Index:Attrs6=FORMAT="Format":2
  324. Index:Attrs7=BLOCKSIZE="Block Size":2
  325. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  326. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  327. Index:Attrs10=EXPRESSION="Expression":2:N
  328. Index:Attrs11=CONDITION="Subset Condition":2:N
  329. Index:Name=NAME
  330. Index:OnAfterLoad=GetIndexInfo
  331.  
  332. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  333. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  334. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  335. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  336.  
  337. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  338. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  339. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  340. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  341. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  342. ValCheck:Attrs6=PICTURE="Picture":2:N
  343. ValCheck:Name=FIELDNUM
  344.  
  345. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  346. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  347. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  348.  
  349. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  350. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  351. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  352. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  353. Reference:Name=NAME
  354. Reference:OnAfterLoad=GetReferenceInfo
  355.  
  356. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  357. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  358.  
  359. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  360. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  361. Security:Name=PASSWORD
  362.  
  363. [ODBC Properties]
  364. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  365. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  366. FieldVChecks:Values=Closed,0=,1="Has Validity Checks",2=
  367. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=
  368. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  369. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  370. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  371. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  372. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  373. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  374. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  375.  
  376. ODBC:Objects1=O:C:0M::"Tables":Table
  377. ODBC:Objects2=O:C:0M::"Procedures":Procedure
  378.  
  379. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  380. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  381. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  382. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  383. Table:Dataset5=PROTECTED=Word,VALID=Word
  384.  
  385. Table:Category=Dataset
  386. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  387. Table:Attrs2=DATE="Date"
  388. Table:Attrs3=TIME="Time"
  389. Table:Attrs4=VERSION="Version":2
  390. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  391. Table:Attrs6=STRUCTURE="Structure":2
  392. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  393. Table:Name=FILENAME,EXTENSION
  394. Table:Objects1=O:P:1M::"Fields":Column
  395. Table:Objects2=O:O:0M::"Indices":Index
  396. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  397. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  398. Table:Objects5=O:O:0M::"Security Specs":Security
  399.  
  400. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  401. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  402. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  403.  
  404. Column:Category=Column
  405. Column:Order=FIELDNUM
  406. Column:Attrs1=FIELDNUM="Order":2:NR
  407. Column:Attrs2=TYPE="Type":1:NR
  408. Column:Attrs3=UNITS1="Size":1:N
  409. Column:Attrs4=UNITS2="Scale":1:N
  410. Column:Attrs5=LENGTH="Physical Length"
  411. Column:Name=NAME
  412.  
  413. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  414. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  415. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  416. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  417. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  418. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  419.  
  420. Index:Category=Index
  421. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  422. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  423. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  424. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  425. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  426. Index:Attrs6=FORMAT="Format":2
  427. Index:Attrs7=BLOCKSIZE="Block Size":2
  428. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  429. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  430. Index:Attrs10=EXPRESSION="Expression":2:N
  431. Index:Attrs11=CONDITION="Subset Condition":2:N
  432. Index:Name=NAME
  433. Index:OnAfterLoad=GetIndexInfo
  434.  
  435. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  436. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  437. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  438. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  439.  
  440. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  441. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  442. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  443. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  444. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  445. ValCheck:Attrs6=PICTURE="Picture":2:N
  446. ValCheck:Name=FIELDNUM
  447.  
  448. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  449. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  450. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  451.  
  452. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  453. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  454. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  455. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  456. Reference:Name=NAME
  457. Reference:OnAfterLoad=GetReferenceInfo
  458.  
  459. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  460. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  461.  
  462. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  463. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  464. Security:Name=PASSWORD
  465.  
  466. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  467.  
  468. Procedure:Category=Executable
  469. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  470. Procedure:EAttrs=Data
  471. Procedure:Name=NAME
  472.  
  473.  
  474.  
  475.  
  476. [INTRBASE Properties]
  477. TFieldType:Values1=Closed,7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  478. TFieldType:Values2=11=DOUBLE PRECISION,14=`'CHAR('=Length')'`:CHAR,27=NUMERIC
  479. TFieldType:Values3=35=DATE,37=`'VARCHAR('=Length')'`:VARCHAR
  480. TFieldType:Values4=40=`'CSTRING('=Length')'`:CSTRING
  481. TFieldType:Values5=261=`'BLOB'``!' SUB_TYPE ' =SubType`:BLOB
  482. TFieldSubType:Values1=Closed,0=0:,1=1:"Text",2=2:"BLR",3=3:"ACL",4=4:"Ranges",5=5:"Summary"
  483. TFieldSubType:Values2=6=6:"Format",7=7:"Transaction Desc",8=8:"Ext File Desc"
  484. TNulls:Values=Closed,=:"Yes",1=NOT NULL:"No"
  485. TUniqueIndex:Values=Closed,=:"No",0=:"No",1=UNIQUE:"Yes"
  486. TDescendingIndex:Values=Closed,=ASCENDING:"No",1=DESCENDING:"Yes"
  487. TTriggerType:Values1=Closed,1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  488. TTriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  489. TParamKind:Values=Closed,0=:"Input",1=:"Output"
  490. TFnParamKind:Values=Closed,0=BY VALUE:"Value",1=:"Reference",3=:"Handle"
  491.  
  492. INTRBASE:Comments=/*,*/
  493.  
  494. INTRBASE:Objects1=O:C:0M::"Domains":Type
  495. INTRBASE:Objects2=O:C:0M::"Tables":Table
  496. INTRBASE:Objects3=O:C:0M::"Views":View
  497. INTRBASE:Objects4=O:C:0M::"Procedures":Procedure
  498. INTRBASE:Objects5=O:C:0M::"Functions":Function
  499. INTRBASE:Objects6=O:C:0M::"Generators":Generator
  500. INTRBASE:Objects7=O:C:0M::"Exceptions":Exception
  501. INTRBASE:Objects8=O:C:0M::"Blob Filters":BlobFilter
  502.  
  503. RDB$RELATIONS:Name=RDB$RELATION_NAME
  504. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner"
  505. RDB$RELATIONS:Attrs2=RDB$DESCRIPTION="Description"
  506. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  507.  
  508. RDB$RELATION_FIELDS:Key=RDB$RELATION_NAME,RDB$FIELD_NAME
  509. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  510. RDB$RELATION_FIELDS:Order=RDB$FIELD_POSITION
  511. RDB$RELATION_FIELDS:Objects=P:R:M1::"Domain":Type
  512. RDB$RELATION_FIELDS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  513. RDB$RELATION_FIELDS:Attrs2=RDB$DEFAULT_SOURCE=Default="Default"::E
  514. RDB$RELATION_FIELDS:Attrs3=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  515. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE
  516.  
  517. RDB$FIELDS:Name=RDB$FIELD_NAME
  518. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  519. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  520. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH=Length="Length"::E
  521. RDB$FIELDS:Attrs4=RDB$FIELD_SCALE=Scale="Scale"::E
  522. RDB$FIELDS:Attrs5=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  523. RDB$FIELDS:Attrs6=RDB$SEGMENT_LENGTH=SegmentSize="Segment Size":2:E
  524. RDB$FIELDS:Attrs7=RDB$DEFAULT_SOURCE=Default="Default":2:E
  525. RDB$FIELDS:Attrs8=RDB$VALIDATION_SOURCE=Rule="Constraint":2:E
  526. RDB$FIELDS:Attrs9=RDB$DESCRIPTION=Description="Description"
  527.  
  528. RDB$FIELD_DIMENSIONS:Key=RDB$FIELD_NAME,RDB$DIMENSION
  529. RDB$FIELD_DIMENSIONS:Name=RDB$DIMENSION
  530. RDB$FIELD_DIMENSIONS:Order=RDB$DIMENSION
  531. RDB$FIELD_DIMENSIONS:Attrs1=RDB$DIMENSION="Order":2:ER
  532. RDB$FIELD_DIMENSIONS:Attrs2=RDB$LOWER_BOUND=LowerBound="Lower Bound"::ER
  533. RDB$FIELD_DIMENSIONS:Attrs3=RDB$UPPER_BOUND=UpperBound="Upper Bound"::ER
  534.  
  535. RDB$FUNCTIONS:Name=RDB$FUNCTION_NAME
  536. RDB$FUNCTIONS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  537. RDB$FUNCTIONS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  538. RDB$FUNCTIONS:Attrs3=RDB$QUERY_NAME=AlternateName="Alternate Name"
  539. RDB$FUNCTIONS:Attrs4=RDB$DESCRIPTION=Description="Description":2
  540. RDB$FUNCTIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  541.  
  542. RDB$FUNCTION_ARGUMENTS:Key=RDB$FUNCTION_NAME,RDB$ARGUMENT_POSITION
  543. RDB$FUNCTION_ARGUMENTS:Name=RDB$ARGUMENT_POSITION
  544. RDB$FUNCTION_ARGUMENTS:Order=RDB$ARGUMENT_POSITION
  545. RDB$FUNCTION_ARGUMENTS:Attrs1=RDB$ARGUMENT_POSITION="Order":2:ER
  546. RDB$FUNCTION_ARGUMENTS:Attrs2=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  547. RDB$FUNCTION_ARGUMENTS:Attrs3=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  548. RDB$FUNCTION_ARGUMENTS:Attrs4=RDB$FIELD_LENGTH=Length="Length"::E
  549. RDB$FUNCTION_ARGUMENTS:Attrs5=RDB$FIELD_SCALE=Scale="Scale"::E
  550.  
  551. RDB$FILTERS:Name=RDB$FUNCTION_NAME
  552. RDB$FILTERS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  553. RDB$FILTERS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  554. RDB$FILTERS:Attrs3=RDB$INPUT_SUB_TYPE=InputType="Input"::ER:::VM=TFieldSubType
  555. RDB$FILTERS:Attrs4=RDB$OUTPUT_SUB_TYPE=OutputType="Output"::ER:::VM=TFieldSubType
  556. RDB$FILTERS:Attrs5=RDB$DESCRIPTION=Description="Description":2
  557. RDB$FILTERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  558.  
  559. RDB$INDICES:Name=RDB$INDEX_NAME
  560. RDB$INDICES:Objects=T:P:1M::"Columns":IndexColumn
  561. RDB$INDICES:Attrs1=RDB$UNIQUE_FLAG=Unique="Unique"::E:::VM=TUniqueIndex
  562. RDB$INDICES:Attrs2=RDB$INDEX_TYPE=Descending="Descending"::E:::VM=TDescendingIndex
  563. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  564.  
  565. RDB$INDEX_SEGMENTS:Key=RDB$INDEX_NAME,RDB$FIELD_NAME
  566. RDB$INDEX_SEGMENTS:Name=Column
  567. RDB$INDEX_SEGMENTS:Order=RDB$FIELD_POSITION
  568. RDB$INDEX_SEGMENTS:Objects1=P:R:M1::"Column":Column:<<>Column
  569. RDB$INDEX_SEGMENTS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  570. RDB$INDEX_SEGMENTS:Reference:"Column"=,RDB$FIELD_NAME
  571.  
  572. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  573. RDB$PROCEDURES:Attrs1=RDB$OWNER_NAME="Owner"
  574. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  575.  
  576. RDB$PROCEDURE_PARAMETERS:Key=RDB$PROCEDURE_NAME,RDB$PARAMETER_NAME
  577. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  578. RDB$PROCEDURE_PARAMETERS:Order=RDB$PARAMETER_NUMBER
  579. RDB$PROCEDURE_PARAMETERS:Objects=P:R:M1::"Domain":Type
  580. RDB$PROCEDURE_PARAMETERS:Attrs1=RDB$PARAMETER_NUMBER="Order":2
  581. RDB$PROCEDURE_PARAMETERS:Attrs2=RDB$PARAMETER_TYPE=Kind="Kind":1:ER:::VM=TParamKind
  582. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE
  583.  
  584. RDB$TYPES:Key=RDB$FIELD_NAME,RDB$TYPE
  585. RDB$TYPES:Name=RDB$TYPE_NAME
  586. RDB$TYPES:Order=RDB$TYPE
  587. RDB$TYPES:Attrs=RDB$TYPE="Value"
  588.  
  589. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  590. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  591.  
  592. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  593. RDB$EXCEPTIONS:Attrs1=RDB$MESSAGE=Message="Message"::E
  594.  
  595. RDB$TRIGGERS:Key=RDB$RELATION_NAME,RDB$TRIGGER_NAME
  596. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  597. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE=Type="Type"::ER:::VM=TTriggerType
  598. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE=Position="Position"::ER
  599. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  600.  
  601. RDB$RELATION_CONSTRAINTS:Key=RDB$RELATION_NAME,RDB$CONSTRAINT_NAME
  602. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  603. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  604. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  605. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME
  606.  
  607. RDB$REF_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  608. RDB$REF_CONSTRAINTS:Objects1=P:R:01::"Primary Key":PrimaryKey
  609. RDB$REF_CONSTRAINTS:Objects2=P:R:11::"Foreign Key":ForeignKey
  610. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  611. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  612. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  613. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  614. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  615. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  616. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  617.  
  618. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  619. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  620.  
  621. Table:Definition=Root=RDB$RELATIONS
  622. View:Definition=Root=RDB$RELATIONS
  623. Procedure:Definition=Root=RDB$PROCEDURES
  624. Function:Definition=Root=RDB$FUNCTIONS
  625. Trigger:Definition=Root=RDB$TRIGGERS
  626. PrimaryKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  627. ForeignKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  628. UniqueConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  629. CheckConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  630. Exception:Definition=Root=RDB$EXCEPTIONS
  631. Generator:Definition=Root=RDB$GENERATORS
  632. Index:Definition=Root=RDB$INDICES
  633. IndexColumn:Definition=Root=RDB$INDEX_SEGMENTS
  634. Column:Definition=Root=RDB$RELATION_FIELDS
  635. Type:Definition=Root=RDB$FIELDS
  636. Enumeration:Definition=Root=RDB$TYPES
  637. Parameter:Definition=Root=RDB$PROCEDURE_PARAMETERS
  638. FunctionParameter:Definition=Root=RDB$FUNCTION_ARGUMENTS
  639. FunctionResult:Definition=Root=RDB$FUNCTION_ARGUMENTS
  640. BlobFilter:Definition=Root=RDB$FILTERS
  641. Dimension:Definition=Root=RDB$FIELD_DIMENSIONS
  642.  
  643. Exception:Warning=Loss
  644. Exception:EAttrs=Text,New,Delete,Modify,Rename,Save
  645. Exception:Text:Get=CREATE EXCEPTION `\N '  ' N \N`  "`=Message`"
  646. Exception:Text:RE=CREATE EXCEPTION\_+(\w+)\_+"(.*)"
  647. Exception:Text:Set=*N=1,Message=2
  648. Exception:Delete:Text=DROP EXCEPTION `O`
  649.  
  650. Generator:Attrs:Q=gen_id=Integer::"Current Value":2:ER
  651. Generator:AttrReference:gen_id=select distinct gen_id(`O`, 0) from RDB$GENERATORS
  652. Generator:Warning=Loss
  653. Generator:EAttrs=Text,New:';',Delete,Modify,Rename,Save
  654. Generator:Text:Init1=CREATE GENERATOR `EDefaultName ';' \N`
  655. Generator:Text:Init2=SET GENERATOR `EDefaultName` TO 0
  656. Generator:Text:Get=CREATE GENERATOR `N`;`\N 'SET GENERATOR ' N ' TO ' =gen_id`
  657. Generator:Text:RE=CREATE GENERATOR\_+(\w+);(\_*SET GENERATOR \w+ TO (\w*))?\_*$
  658. Generator:Text:Set=*N=1,gen_id=3
  659. Generator:Delete:Text1=DELETE FROM RDB$GENERATORS
  660. Generator:Delete:Text2=WHERE RDB$GENERATOR_NAME=`OQ`
  661.  
  662. Table:Category=Dataset
  663. Table:Values=A.RDB$VIEW_SOURCE IS NULL
  664. Table:Objects1=T:P:1M::"Columns":Column
  665. Table:Objects2=T:O:0M::"Indices":Index
  666. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  667. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  668. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  669. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  670. Table:Objects7=T:O:0M::"Triggers":Trigger
  671. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  672. Table:Warning=DataLoss
  673. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  674. Table:Text:Get=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  675. Table:Text:RE=CREATE TABLE\_+(\w+)\_*(\(.*\))
  676. Table:Text:Set=*N=1
  677. Table:Delete:Text=DROP TABLE `O`
  678.  
  679. View:Category=Dataset
  680. View:Values=A.RDB$VIEW_SOURCE IS NOT NULL
  681. View:Objects=T:P:0M:NMDR:"Columns":Column
  682. View:Attrs:Q=Text=Memo::"Text"::ER
  683. View:AttrReference:Text1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  684. View:AttrReference:Text2=where RDB$RELATION_ID=`:RDB$RELATION_ID`
  685. View:Warning=Loss
  686. View:EAttrs=Data,Text,New,Modify,Rename,Delete,Save
  687. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  688. View:Text:Get=CREATE VIEW `N` `'('[Column:%s,%s:\N '  ' N] \N ') '`AS`=Text`
  689. View:Text:RE=CREATE VIEW\_+(\w+)\_*(\(.*\))?\_+AS(.*)
  690. View:Text:Set=Text=3,*N=1
  691. View:Delete:Text=DROP VIEW `O`
  692.  
  693. Index:Category=Index
  694. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  695. Index:Text:Get1=CREATE `!=Unique ' ' ``!=Descending ' ' `INDEX `N`
  696. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:*]`)
  697. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  698. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  699. Index:Delete:Text=DROP INDEX `O`
  700.  
  701. Column:Category=Column
  702. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:E::PResetType
  703. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:E::PResetType
  704. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:E::PResetType
  705. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:E::PResetType
  706. Column:Attrs:R=Type:"Domain":"Type":1:E::PSetType
  707. Column:OnAfterLoad=ColumnLoaded
  708. Column:OnCopyFrom=CopyWithDomain
  709. Column:AttrReference:FieldType=RDB$FIELD_SOURCE
  710. Column:AttrReference:SubType=RDB$FIELD_SOURCE
  711. Column:AttrReference:Length=RDB$FIELD_SOURCE
  712. Column:AttrReference:Scale=RDB$FIELD_SOURCE
  713. Column:EAttrs=Text,New,Delete,Modify,Rename
  714. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  715.  
  716. IndexColumn:Category=ColumnReference
  717. IndexColumn:Attrs:R=Column:::2:ER
  718. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  719. IndexColumn:Text:Get=`N`
  720.  
  721. Type:Category=Type
  722. Type:Objects1=T:P:0M::"Dimensions":Dimension
  723. Type:Objects2=T:C:0M::"Values":Enumeration
  724. ; Convert DEFAULT (.*) in Default and CHECK \((.*)\) in Rule
  725. Type:OnAfterLoad=TypeLoaded
  726. Type:Reference:"Dimensions":Text=`' [' [Dimension:%s, %s:*] ']'`
  727. Type:Warning=Loss
  728. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  729. Type:Text:Get1=CREATE DOMAIN `N` AS` \N '  ' EPhysicalType`
  730. Type:Text:Get2=`!\N '  DEFAULT '=Default`
  731. Type:Text:Get3=`!\N '  ' =Null`
  732. Type:Text:Get4=`!\N '  CHECK (' =Rule ')'`
  733. Type:Delete:Text=DROP DOMAIN `O`
  734.  
  735. Dimension:EAttrs=Text,New,Delete,Modify,Rename
  736. Dimension:Text:Get=`=LowerBound ':' =UpperBound`
  737.  
  738. Procedure:Category=Executable
  739. Procedure:Objects=T:P:0M::"Parameters":Parameter
  740. Procedure:Reference:"Parameters":Text1=`!'(' \N {>Parameter} EParametersIn \N')'`
  741. Procedure:Reference:"Parameters":Text2=`!'RETURNS (' \N {>Parameter} EParametersOut \N ')'`
  742. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  743. Procedure:AttrReference:Text1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  744. Procedure:AttrReference:Text2=where RDB$PROCEDURE_NAME=`OQ`
  745. Procedure:Warning=Loss
  746. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  747. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS`\N`BEGIN`\N`END
  748. Procedure:Text:Get1=CREATE PROCEDURE `N`
  749. Procedure:Text:Get2=`{>Parameter} *`
  750. Procedure:Text:Get3=AS `=Text`
  751. Procedure:Text:RE=CREATE PROCEDURE\_+(\w+)\_*(.*)\_AS\_(.*)
  752. Procedure:Text:Set=Text=3,*>Parameter=2,*N=1
  753. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  754. Procedure:Modify:Set=1=`'ALTER'`
  755. Procedure:Delete:Text=DROP PROCEDURE `O`
  756.  
  757. Parameter:Category=Column
  758. Parameter:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:-E::PResetType
  759. Parameter:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:-E::PResetType
  760. Parameter:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:-E::PResetType
  761. Parameter:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:-E::PResetType
  762. Parameter:Attrs:R=Type:"Domain":"Type":1:::PSetType
  763. Parameter:AttrReference:FieldType=RDB$FIELD_SOURCE
  764. Parameter:AttrReference:SubType=RDB$FIELD_SOURCE
  765. Parameter:AttrReference:Length=RDB$FIELD_SOURCE
  766. Parameter:AttrReference:Scale=RDB$FIELD_SOURCE
  767. Parameter:EAttrs=Text
  768. Parameter:Text:Get=`N ' ' EType`
  769. Parameter:OnAfterLoad=AdjustTypeInfo
  770. Parameter:OnCopyFrom=CopyWithDomain
  771.  
  772. Function:Category=Executable
  773. Function:Objects1=T:P:0M::"Parameters":FunctionParameter
  774. Function:Objects2=T:P:11::"Result":FunctionResult
  775. Function:Reference:"Parameters":Text=`[FunctionParameter:%s, %s:*]`
  776. Function:Reference:"Result":Text=`[FunctionResult::*]`
  777. Function:Warning=Loss
  778. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  779. Function:Text:Get1=DECLARE EXTERNAL FUNCTION `N \N`
  780. Function:Text:Get2=`!'  ' {>FunctionParameter} * \N`
  781. Function:Text:Get3=`'  RETURNS ' {>FunctionResult} * \N`
  782. Function:Text:Get4= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  783. Function:Delete:Text=DROP EXTERNAL FUNCTION `O`
  784.  
  785. FunctionParameter:Category=Column
  786. FunctionParameter:Values=A.RDB$ARGUMENT_POSITION <> `:RDB$RETURN_ARGUMENT`
  787. FunctionParameter:EAttrs=Text,New,Delete,Modify,Rename
  788. FunctionParameter:Text:Get=`EPhysicalType`
  789.  
  790. FunctionResult:Category=Column
  791. FunctionResult:Values=A.RDB$ARGUMENT_POSITION = `:RDB$RETURN_ARGUMENT`
  792. FunctionResult:Attrs=RDB$MECHANISM=Kind="Kind"::E:::VM=TFnParamKind
  793. FunctionResult:EAttrs=Text,New,Delete,Modify,Rename
  794. FunctionResult:Text:Get=`EPhysicalType``! ' ' =Kind`
  795.  
  796. BlobFilter:Category=Executable
  797. BlobFilter:Warning=Loss
  798. BlobFilter:EAttrs=Text,New,Delete,Modify,Rename,Save
  799. BlobFilter:Text:Get1=DECLARE FILTER `N \N`
  800. BlobFilter:Text:Get2= INPUT_TYPE `=InputType`  OUTPUT_TYPE `=OutputType``\N`
  801. BlobFilter:Text:Get3= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  802. BlobFilter:Delete:Text=DROP FILTER `O`
  803.  
  804. CheckConstraint:Category=Expression
  805. CheckConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'CHECK'
  806. CheckConstraint:Attrs:Q=Text=Memo::"Constraint Text":2:ER:PStripCheck
  807. CheckConstraint:AttrReference:Text1=select t.RDB$TRIGGER_SOURCE
  808. CheckConstraint:AttrReference:Text2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  809. CheckConstraint:AttrReference:Text3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  810. CheckConstraint:AttrReference:Text4=t.RDB$TRIGGER_TYPE=1 and
  811. CheckConstraint:AttrReference:Text5=c.RDB$CONSTRAINT_NAME=`OQ`
  812. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  813. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  814. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  815. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  816. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  817. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  818.  
  819. UniqueConstraint:Category=UniqueConstraint
  820. UniqueConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'UNIQUE'
  821. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  822. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  823. UniqueConstraint:Reference:"Columns"=RDB$INDEX_NAME
  824. UniqueConstraint:Reference:"Index"=RDB$INDEX_NAME
  825. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  826. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  827. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [IndexColumn:%s, %s:N] ')'`
  828. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  829.  
  830. PrimaryKey:Category=PrimaryKey
  831. PrimaryKey:Values=A.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  832. PrimaryKey:Objects1=T:P:1M::"Columns":IndexColumn
  833. PrimaryKey:Objects2=P:R:M1::"Index":Index:<>Index
  834. PrimaryKey:Reference:"Columns"=RDB$INDEX_NAME
  835. PrimaryKey:Reference:"Index"=RDB$INDEX_NAME
  836. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  837. PrimaryKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  838. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [IndexColumn:%s, %s:N] ')'`
  839. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  840.  
  841. ForeignKey:Category=ForeignKey
  842. ForeignKey:Values=A.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
  843. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  844. ForeignKey:Objects2=T:P:1M::"Columns":IndexColumn
  845. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  846. ForeignKey:Reference:"Index"=RDB$INDEX_NAME
  847. ForeignKey:Reference:"Columns"=RDB$INDEX_NAME
  848. ForeignKey:Reference:"Reference Table"=ReferenceTable
  849. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION=MatchOption
  850. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE=UpdateRule
  851. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE=DeleteRule
  852. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  853. ForeignKey:Attrs:R=Table::::ER
  854. ForeignKey:AttrReference:ReferenceTable1=select RDB$RELATION_NAME
  855. ForeignKey:AttrReference:ReferenceTable2=from RDB$REF_CONSTRAINTS A, RDB$RELATION_CONSTRAINTS B
  856. ForeignKey:AttrReference:ReferenceTable3=where A.RDB$CONST_NAME_UQ = B.RDB$CONSTRAINT_NAME
  857. ForeignKey:AttrReference:ReferenceTable4=and A.RDB$CONSTRAINT_NAME = `:RDB$CONSTRAINT_NAME`
  858. ForeignKey:AttrReference:MatchOption=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  859. ForeignKey:AttrReference:UpdateRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  860. ForeignKey:AttrReference:DeleteRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  861. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  862. ForeignKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  863. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [IndexColumn:%s, %s:N] ')'`
  864. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  865. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  866.  
  867. Trigger:Category=Executable
  868. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  869. Trigger:AttrReference:Text1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  870. Trigger:AttrReference:Text2=where RDB$TRIGGER_NAME=`OQ`
  871. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  872. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName` FOR `{<}N`
  873. Trigger:Text:Init2=AFTER UPDATE POSITION 0 AS`\N`BEGIN`\N`END
  874. Trigger:Text:Get1=CREATE TRIGGER `N` FOR `{<}N`
  875. Trigger:Text:Get2=`=Type` POSITION `=Position` `=Text`
  876. Trigger:Text:RE=CREATE\_+TRIGGER\_+(\w+)\_+FOR\_+(\w+)\_+(\w+\_\w+)\_+POSITION\_+(\w+)\_+(.*)
  877. Trigger:Text:Set=*N=1,2=`{<}N`,Type=3,Position=4,Text=5
  878. Trigger:Delete:Text=DROP TRIGGER `O`
  879.  
  880.  
  881.  
  882.