Pastebin
Paste #2486: libnss-pgsql2 table layout
< previous paste - next paste>
Pasted by tdn
Table "public.backupuser"
Column | Type | Modifiers
----------------+-----------------------------+-----------------------------------------------------
username | text | not null
fk_customer_id | integer | not null
unix_uid | integer | not null default nextval('unix_user_id'::regclass)
unix_gid | integer | not null default nextval('unix_group_id'::regclass)
unix_groupname | text | not null
unix_homedir | text | not null
unix_shell | text | not null default '/bin/rsyncsh'::text
unix_gecos | text | not null
ssh_key | text | not null
pass_type | text | not null
pass_salt | text | not null
pass_hash | text | not null
enabled | boolean | not null default true
hostname | text | not null default 'backup.sikkerhed.org'::text
description | text | not null
quota | integer | not null
enable_cleanup | boolean | not null default true
num_recent | integer | not null default 7
num_years | integer | not null default 100
num_months | integer | not null default 12
num_weeks | integer | not null default 0
num_days | integer | not null default 7
num_hours | integer | not null default 0
ctime | timestamp without time zone | not null default now()
mtime | timestamp without time zone | not null default now()
Indexes:
"pkbackupuser" PRIMARY KEY, btree (username)
Foreign-key constraints:
"fk_backupuser_customer" FOREIGN KEY (fk_customer_id) REFERENCES customer(id)
Triggers:
update_backupuser_mtime BEFORE UPDATE ON backupuser FOR EACH ROW EXECUTE PROCEDURE update_mtime()
New Paste
Go to most recent paste.
