Introduction

snub use SQLite database for storing all files information. On this page is described snub database format.

Details

Each installed package has it's own table. Table name consist from package name and an unique 9 chars mcookie. Example: zlib_8w2s7i9dc

Such table has the following fields:

'original_full_file_name text', 'file_name text', 'each_file_md5sum text', 'file_inode integer', 'file_access_rights integer', 'file_date integer', 'file_time integer', 'file_owner integer', 'file_group integer', 'file_type text', 'table_mcookie text'

Where file_type may be - 'd'(directory), 'f'(regular file), 'l'(symbolic link). Other are self explanatory. Also each record related to an package in database, has that package unique mcookie. From example above, each record will bear 8w2s7i9dc in filed table_mcookie .

Except that, snub is keep 3 service tables with names:

service_tables_list

'tables text', 'creator text', 'creator_version text', 'creation_date integer', 'creation_time integer'

packages_list_table

'package_name text', 'package_base_name text', 'package_doted_full_version text', 'sql_package_name text', 'package_root text', 'user_uid text', 'user_name text', 'package_compressed_size integer', 'package_uncompressed_size integer', 'package_date integer', 'package_time integer', 'package_md5sum text', 'package_installed_from_path text', 'package_full_name text', 'package_arch text','table_mcookie text'

packages_short_names_table

'package_short_name text', 'package_name text', 'sql_package_name text', 'table_mcookie text'

all_installed_files_table

'full_file_name', 'file_name', 'base_file_name', 'file_type', 'table_mcookie'