Public feed
#892853
bacula=# \d file
Table "public.file"
Column | Type | Modifiers
------------+---------+-------------------------------------------------------
fileid | integer | not null default nextval('file_fileid_seq'::regclass)
fileindex | integer | not null default 0
jobid | integer | not null
pathid | integer | not null
markid | integer | not null default 0
lstat | text | not null
md5 | text | not null
filenameid | integer | not null
Indexes:
"file_pkey" PRIMARY KEY, btree (fileid)
"file_filenameid_idx" btree (filenameid)
"file_jobid_idx" btree (jobid)
"file_jpfid_idx" btree (jobid, pathid, filenameid)
"file_pathid" btree (pathid)
"file_pathid_idx" btree (pathid)
"testing" btree ((fileid::bigint))
bacula=# \d filename
Table "public.filename"
Column | Type | Modifiers
------------+---------+---------------------------------------------------------------
filenameid | integer | not null default nextval('filename_filenameid_seq'::regclass)
name | text | not null
Indexes:
"filename_pkey" PRIMARY KEY, btree (filenameid)
"filename_name_idx" btree (name)
bacula=#