[Names] # # DefineColumns File for Index Server and Site Server Search. # These are default property names (Catalog Columns) that are # NOT BUILT-IN to Index Server or Site Server Search. # # Index Server and Site Server Search read this file when the following # registry key points to it: # #HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\ContentIndexCommon\DefaultColumnFile # The value of this reg key is the full path to this file as a REG_SZ. # # This file is parsed on a line by line basis. Each line # must have the following form: # # FriendlyName [ "(" [ Type ] ")" ] ["="] PropertySetGuid PropertySpec # # where: # FriendlyName - A whitespace delimited alias for the property # # Type DBTYPE_Type # where Type is a string specifying the property type # for comparison purposes. See list of DBTYPEs below. # The default type is DBTYPE_WSTR | DBTYPE_BYREF. # # PropertySetGuid - A GUID in the standard form. # # PropertySpec - Either a property name or PropID. # Quotation marks around a PropertySpec denote # a property name. Unless property name starts # with an integer, quotation marks are optional. # # Blank lines are allowed, and comments are recognized as any line # with "#" as the first non-whitespace character. # # The "=" is optional, but it looks nice. # # DBTYPEs supported include: # # DBTYPE_I1 # DBTYPE_UI1 # DBTYPE_I2 # DBTYPE_UI2 # DBTYPE_I4 # DBTYPE_UI4 # DBTYPE_I8 # DBTYPE_UI8 # DBTYPE_R4 # DBTYPE_R8 # DBTYPE_CY # DBTYPE_DATE # VT_FILETIME # DBTYPE_BOOL # DBTYPE_GUID # # DBTYPE_STR # DBTYPE_WSTR # DBTYPE_BSTR # # DBTYPE_BYREF # DBTYPE_VECTOR # # Strings should be specified as: # # DBTYPE_WSTR | DBTYPE_BYREF # DBTYPE_STR | DBTYPE_BYREF # # # History # ======= # # ?????? ???????? Created # 9/1/1999 KrishnaN Added URI properties ### ************************************************************************************* ### IMPORTANT! ### If you uncomment the properties that are built into Index Server or Site Server Search, ### the entire DefineColumns.txt file will be ignored. ### ************************************************************************************* ### Properties not defined in the Search schema ### # Contents (DBTYPE_WSTR | DBTYPE_BYREF) = B725F130-47EF-101A-A5F1-02608C9EEBAC 19 # Plain text for use in full-text search # From the Storage property set # Not defined in default Search schema, as its behavior is not modifiable # It is always searchable (index="yes"), never retrievable (retrieve=no) # Commented out here because it is an Index Server built-in property FileSize (DBTYPE_I8) = b725f130-47ef-101a-a5f1-02608c9eebac 12 # File size in bytes, alternate name for Index Server's 'Size' property # From the Storage propset # Not defined in default Search schema, as its behavior is not modifiable # It is always searchable (index="yes")and retrievable (retrieve=yes) # RankVector (DBTYPE_VECTOR | DBTYPE_UI4) = 49691c90-7e17-101a-a91c-08002b2ecda9 2 # Relevance ranks of individual components of a vector query # From the Query propset # Query-time only, not defined in Search schema, retrievable but not searchable # Commented out here because it is an Index Server built-in property # Rank (DBTYPE_I4) = 49691c90-7e17-101a-a91c-08002b2ecda9 3 # Relevance rank of row. Ranges from 0-1000. Larger numbers = better matches # From the Query propset # Query-time only, not defined in Search schema, retrievable but not searchable # Commented out here because it is an Index Server built-in property # HitCount (DBTYPE_UI4) = 49691c90-7e17-101a-a91c-08002b2ecda9 4 # Number of hits (words matching query) in file # From the Query propset # Query-time only, not defined in Search schema, retrievable but not searchable # Commented out here because it is an Index Server built-in property # All (DBTYPE_WSTR | DBTYPE_BYREF) = 49691c90-7e17-101a-a91c-08002b2ecda9 6 # Searches across all properties for # From the Query propset # Query-time only, not defined in Search schema, searchable but not retrievable # Commented out here because it is an Index Server built-in property CatalogName (DBTYPE_WSTR | DBTYPE_BYREF) = 49691c90-7e17-101a-a91c-08002b2ecda9 10 # Name of the catalog from which a row came. # Allows one to display the source of a hit. # This is an output property only. Cannot be queried upon. ### Commonly used properties ### # DocAddress (DBTYPE_WSTR | DBTYPE_BYREF) = 49691c90-7e17-101a-a91c-08002b2ecda9 9 # Absolute URL or UNC path to the document # This is an alternate name for Index Server's VPath property # to indicate Site Server Search's expanded use of the property: # a URL instead of a relative path. # from the Query propset # Defined in default Search schema with index="yes" and retrieve="yes" URL (DBTYPE_WSTR | DBTYPE_BYREF) = 49691c90-7e17-101a-a91c-08002b2ecda9 9 # Absolute URL or UNC path to the document # This is an alternate name for DocAddress and VPath used by # the ADO SQL query interface. # from the Query propset # Defined in default Search schema with index="yes" and retrieve="yes" # Description (DBTYPE_WSTR | DBTYPE_BYREF) = 560c36c0-503a-11cf-baa1-00004c752a9a 2 # Contents of HTML meta name=description tag if present, otherwise an # automatically constructed description based on the document subject # and contents. Alternate name for Index Server's 'Characterization' property. # Also refered to as 'abstract'. # From the Characterization propset # Defined in default Search schema with index="yes" and retrieve="yes" ### Summary Information Property Set (MS OFFICE PROPERTIES) ### # DocTitle (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 2 # Document title # SummaryInfo propset # Defined in default Search schema with index="yes" and retrieve="yes" # Commented out here because it is an Index Server built-in property # DocSubject (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 3 # Document subject # From the SummaryInfo propset # Defined in default Search schema with index="yes" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocAuthor (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 4 # Original author of document # From the SummaryInfo propset # Defined in default Search schema with index="yes" and retrieve="yes" # Commented out here because it is an Index Server built-in property # DocKeywords (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 5 # Document keywords # From the SummaryInfo propset # Defined in default Search schema with index="yes" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocComments (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 6 # Editorial comments about document. MS Word auto-summary goes in here too. # From the SummaryInfo propset # Defined in default Search schema with index="yes" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocTemplate (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 7 # Document template # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocLastAuthor (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 8 # Person who last saved document # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocRevNumber (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 9 # Document revision number # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocEditTime (VT_FILETIME) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 10 # Total time spent editting document # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocLastPrinted (VT_FILETIME) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 11 # Date/time document was last printed # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocCreatedTm (VT_FILETIME) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 12 # Date/time file was originally created # From the SummaryInfo propset (Office Docs) # Defined in default Search schema with index="yes" and retrieve="yes" # Commented out here because it is an Index Server built-in property # DocLastSavedTm (VT_FILETIME) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 13 # Date/time file was last saved # From the SummaryInfo propset (Office Docs) # Defined in default Search schema with index="yes" and retrieve="yes" # Commented out here because it is an Index Server built-in property # DocPageCount (DBTYPE_I4) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 14 # Total number of pages in document # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocWordCount (DBTYPE_I4) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 15 # Total number of words in document # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocCharCount (DBTYPE_I4) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 16 # Total number of characters in document # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocThumbnail (VT_CF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 17 # Not supported # From the SummaryInfo propset # Not defined in default Search schema # Commented out here because it is NOT supported in Index Server or Search # DocAppName (DBTYPE_STR | DBTYPE_BYREF) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 18 # Name of app that created the file # From the SummaryInfo propset # Defined in default schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # Security (DBTYPE_I4) = f29f85e0-4ff9-1068-ab91-08002b27b3d9 19 # Access control information # From the SummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is not commonly used ### Document Summary Information Property Set (MS OFFICE) ### # DocCategory (DBTYPE_STR | DBTYPE_BYREF) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 2 # MS Office - user-defined category string # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocPresentationTarget (DBTYPE_STR | DBTYPE_BYREF) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 3 # PowerPoint presentation format - (35mm, printer, video, etc.) # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocByteCount (DBTYPE_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 4 # Number of bytes in the document # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocLineCount (DBTYPE_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 5 # Number of lines in document # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocParaCount (DBTYPE_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 6 # Number of paragraphs in document # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocSlideCount (DBTYPE_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 7 # Number of slides in document # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocNoteCount (DBTYPE_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 8 # Number of notes associated with a PowerPoint document # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocHiddenCount (DBTYPE_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 9 # Number of hidden slides in a PowerPoint document # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # MMClips (DBTYPE_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 10 # Number of multimedia clips in a PowerPoint document # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is not commonly used # ScaleCrop (DBTYPE_BOOL) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 11 # Set to True(-1) for thumbnail scaling, False(0) for cropping. For FindFile 2.0 # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is not commonly used # HeadingPairs (VT_LPSTR, VT_I4) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 12 # Internal property for indenting groups of headings in Office docs # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is not commonly used # DocPartTitles (DBTYPE_STR | DBTYPE_VECTOR) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 13 # Names of document parts; e.g., Excel sheet names, PowerPoint slide titles. # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocManager (DBTYPE_STR | DBTYPE_BYREF) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 14 # Manager of the project, from Project # From the DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # DocCompany (DBTYPE_STR | DBTYPE_BYREF) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 15 # Company name, from Project # DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property # LinksUpToDate (DBTYPE_BOOL) = d5cdd502-2e9c-101b-9397-08002b2cf9ae 16 # Custom links are up to date, all app's # DocSummaryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is not commonly used # Storage Property Set (File properties) # ClassID (DBTYPE_GUID) = b725f130-47ef-101a-a5f1-02608c9eebac 3 # Class ID of app that created the file # From the Storage propset # Not available in Site Server Search. Not defined in the default Search schema. # Commented out here because it is an Index Server built-in property # FileName (DBTYPE_WSTR | DBTYPE_BYREF) = b725f130-47ef-101a-a5f1-02608c9eebac 10 # Long file name # From the Storage propset # Defined in default Search schema with index="yes" and retrieve="yes" # Commented out here because it is an Index Server built-in property # Path (DBTYPE_WSTR | DBTYPE_BYREF) = b725f130-47ef-101a-a5f1-02608c9eebac 11 # Full physical path to file, including filename # From the Storage propset # Not available in Site Server Search. Not defined in the default Search schema. # Commented out here because it is an Index Server built-in property # FileSize is listed above with the properties not defined in the Search schema # FileAttributes (DBTYPE_UI4) = b725f130-47ef-101a-a5f1-02608c9eebac 13 # As doc'd in Win32 SDK. Alternate name for Index Server's 'Attrib' property. # From the Storage propset # Not available in Site Server Search. Not defined in the default Search schema. # Commented out here because it is not commonly used. # FileWrite (VT_FILETIME) = b725f130-47ef-101a-a5f1-02608c9eebac 14 # Date/time file was last written # alternate name for Index Server's 'Write' property. # From the Storage propset # Defined in default Search schema with index="yes" and retrieve="yes" # Contents property is listed above with the # properties not defined in the Search schema # ShortFileName (DBTYPE_WSTR | DBTYPE_BYREF) = b725f130-47ef-101a-a5f1-02608c9eebac 20 # 8.3 filename # From the Storage propset # Not available in Site Server Search. Not defined in the default Search schema. # Commented out here because it is an Index Server built-in property. ### Site Server Search Info and Gatherer Properties ### # DetectedLanguage (DBTYPE_UI4) = c82bf596-b831-11d0-b733-00aa00a1ebd2 2 # Automatically detected language. See the Search documentation. # From the NetLibraryInfo propset # Defined in default Search schema with index="yes" and retrieve="yes" HTMLComment (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf596-b831-11d0-b733-00aa00a1ebd2 3 # The HTML comment tag # From the NetLibraryInfo propset # Defined in default Search schema with index="no" and retrieve="no" # CrawlNumberModified (DBTYPE_I4) = 0b63e350-9ccc-11d0-bcdb-00805fccce04 4 # Crawl number when this document was last modified and added to a catalog. # Used in 'search since' queries # From the NetLibrary propset # Defined in default Search schema with index="yes" and retrieve="yes" # A Search catalog's CrawlNumber is an ADO recordset property, so it is # NOT defined in the Search schema or this file. CrawlNumberModified is # used for finding documents that have been cataloged since a user's # last visit. See the Search documentation for more information. # MimeType (DBTYPE_WSTR | DBTYPE_BYREF) = 0b63e350-9ccc-11d0-bcdb-00805fccce04 5 # The documents MIME type, if known # From the NetLibrary propset # Defined in default Search schema with index="yes" and retrieve="yes" # DocSignature (DBTYPE_WSTR | DBTYPE_BYREF) = 0b63e350-9ccc-11d0-bcdb-00805fccce04 6 # MD5 digest, a checksum on the document that can be used to # eliminate duplicates. # From the NetLibrary propset # Defined in default Search schema with index="yes" and retrieve="yes" SiteName (DBTYPE_WSTR | DBTYPE_BYREF) = 0b63e343-9ccc-11d0-bcdb-00805fccce04 4 # Site name extracted from doc's URL. Used for sorting and grouping by site # From Gatherer propset # Defined in default Search schema with index="yes" and retrieve="yes" DefaultCodePage (DBTYPE_UI4) = 0b63e343-9ccc-11d0-bcdb-00805fccce04 "DefaultCodePage" # Automatically detected code page for the document # From Gatherer propset # Defined in default Search schema with index="no" and retrieve="yes" # HTML Properties # HTMLHeading1 (DBTYPE_WSTR | DBTYPE_BYREF) = 70eb7a10-55d9-11cf-b75b-00aa0051fe20 3 # From the HTMLInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property. # HTMLHeading2 (DBTYPE_WSTR | DBTYPE_BYREF) = 70eb7a10-55d9-11cf-b75b-00aa0051fe20 4 # HTMLInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property. # HTMLHeading3 (DBTYPE_WSTR | DBTYPE_BYREF) = 70eb7a10-55d9-11cf-b75b-00aa0051fe20 5 # HTMLInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property. # HTMLHeading4 (DBTYPE_WSTR | DBTYPE_BYREF) = 70eb7a10-55d9-11cf-b75b-00aa0051fe20 6 # HTMLInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property. # HTMLHeading5 (DBTYPE_WSTR | DBTYPE_BYREF) = 70eb7a10-55d9-11cf-b75b-00aa0051fe20 7 # HTMLInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property. # HTMLHeading6 (DBTYPE_WSTR | DBTYPE_BYREF) = 70eb7a10-55d9-11cf-b75b-00aa0051fe20 8 # HTMLInfo propset # Defined in default Search schema with index="no" and retrieve="no" # Commented out here because it is an Index Server built-in property. # Img_Alt (DBTYPE_WSTR | DBTYPE_BYREF) = 70eb7a10-55d9-11cf-b75b-00aa0051fe20 "IMG.ALT" # Image alternate text # HTMLInfo propset # Defined in default Search schema with index="no" and retrieve="no" # A_HREF (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf597-b831-11d0-b733-00aa00a1ebd2 "A.HREF" # Text of the anchor HRef. Alternate name for Index Server's HTML_HRef # LinkInformation propset # Defined in default Search schema with index="yes" and retrieve="no" # HTMLHRef (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf597-b831-11d0-b733-00aa00a1ebd2 "A.HREF" # Same as A_HRef above # LinkInformation propset # Defined in default Search schema with index="no" and retrieve="no" Base_HREF (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf597-b831-11d0-b733-00aa00a1ebd2 "BASE.HREF" # URL from base tag # LinkInformation propset # Defined in default Search schema with index="no" and retrieve="no" Link_HREF (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf597-b831-11d0-b733-00aa00a1ebd2 "LINK.HREF" # URL from link tag # LinkInformation propset # Defined in default Search schema with index="no" and retrieve="no" Meta_URL (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf597-b831-11d0-b733-00aa00a1ebd2 "META.URL" # URL from tag # LinkInformation propset # Defined in default Search schema with index="no" and retrieve="no" Frame_Src (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf597-b831-11d0-b733-00aa00a1ebd2 "FRAME.SRC" # URL from tag # LinkInformation propset # Defined in default Search schema with index="no" and retrieve="no" IFrame_Src (DBTYPE_WSTR | DBTYPE_BYREF) = c82bf597-b831-11d0-b733-00aa00a1ebd2 "IFRAME.SRC" # URL from