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()