This table describes signature and version information of files. It is linked to a file entry through the realfiles table.
|
Field name |
Data type |
Description |
|
id_snapshot |
number |
Identifier of the network snapshot. |
|
id_realfile |
number |
Identifier of the file to link the record with the realfile entry. |
|
file_ver |
string |
Version of the file. |
|
product_ver |
string |
Version of the product. |
|
OS |
string |
Name of the operating system the file is designed for. |
|
type |
string |
Main type of the file. |
|
subtype |
string |
Subtype of the file (depending on the main type). |
|
comments |
string |
Comments of the file. |
|
company |
string |
Company that designed the file. |
|
file_desc |
string |
Textual description of the file. |
|
product_name |
string |
Name of the product the file is part of. |
|
internal_name |
string |
Internal name of the file. |
|
copyright |
string |
Copyright of the product/file. |
|
trademarks |
string |
Trademarks of the product/file. |
For example, to view the name of the company which designed the file USER32.DLL, use the following SQL query:
SELECT versions.company
FROM versions, realfiles
WHERE
versions.id_realfile = realfiles.id_realfile AND
realfiles.pathname = 'C:\WINNT\System32\USER32.DLL'