Dumped on 2008-05-20
table de lien objets / tags
tags_linktags Structure
F-Key |
Name |
Type |
Description |
|
link_id |
integer |
NOT NULL
identifiant objet
|
|
tag_id |
integer |
NOT NULL
identifiant tag
|
|
date_added |
timestamp without time zone |
date d'ajout du tag à l'objet
|
Index -
Schema public
table principale des objets taggués
tags_sabrosus Structure
F-Key |
Name |
Type |
Description |
|
id_enlace |
integer |
NOT NULL
identifiant du lien
|
|
title |
character varying |
NOT NULL
titre de l'objet (webarea sans le http)
|
|
enlace |
character varying |
NOT NULL
lien webarea (avec http en plus du titre sinon idem)
|
|
descripcion |
character varying |
NOT NULL
description (pas besoin de la récupérer)
|
|
fecha |
timestamp without time zone |
DEFAULT now()
date d'ajout (pas besoin de la récupérer)
|
|
privado |
integer |
NOT NULL
affichage public (ou pas, pas besoin de le récupérer)
|
Index -
Schema public
Liste des tags
tags_tags Structure
F-Key |
Name |
Type |
Description |
|
id |
integer |
NOT NULL
identifiant du tag
|
|
tag |
character varying |
libellé du tag
|
|
level |
integer |
filtrage tag : 0 for all, 1 for user, 2 for admin
|
|
date_creation |
timestamp without time zone |
DEFAULT now()
date of creation of tag
|
Index -
Schema public
Permissions which apply to vhffs_acl
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_boxes Structure
F-Key |
Name |
Type |
Description |
vhffs_mxdomain.domain
|
domain |
character varying |
PRIMARY KEY
|
|
local_part |
character varying |
PRIMARY KEY
|
|
domain_hash |
character varying |
NOT NULL
|
|
password |
character varying |
NOT NULL
|
|
mbox_name |
character varying |
NOT NULL
|
|
nospam |
boolean |
|
|
novirus |
boolean |
|
|
state |
integer |
NOT NULL
|
|
allowpop |
boolean |
NOT NULL
DEFAULT true
|
|
allowimap |
boolean |
NOT NULL
DEFAULT true
|
Permissions which apply to vhffs_boxes
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_cvs Structure
F-Key |
Name |
Type |
Description |
|
cvs_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_cvs_cvs_id_seq'::regclass)
|
|
cvsroot |
character varying |
UNIQUE
NOT NULL
|
|
public |
boolean |
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
Permissions which apply to vhffs_cvs
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_dns Structure
F-Key |
Name |
Type |
Description |
|
dns_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_dns_dns_id_seq'::regclass)
|
|
domain |
character varying(255) |
UNIQUE
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
|
ns |
character varying(255) |
NOT NULL
|
|
mbox |
character varying(255) |
NOT NULL
|
|
serial |
integer |
NOT NULL
DEFAULT 1
|
|
refresh |
integer |
NOT NULL
DEFAULT 28800
|
|
retry |
integer |
NOT NULL
DEFAULT 7200
|
|
expire |
integer |
NOT NULL
DEFAULT 604800
|
|
minimum |
integer |
NOT NULL
DEFAULT 86400
|
|
ttl |
integer |
NOT NULL
DEFAULT 86400
|
Tables referencing this one via Foreign Key Constraints:
Permissions which apply to vhffs_dns
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_dns_rr Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
vhffs_dns.dns_id
|
zone |
integer |
NOT NULL
|
|
name |
character varying(64) |
NOT NULL
|
|
type |
character varying(5) |
NOT NULL
|
|
data |
character varying(128) |
NOT NULL
|
|
aux |
integer |
NOT NULL
|
|
ttl |
integer |
NOT NULL
DEFAULT 86400
|
vhffs_dns_rr Constraints
Name |
Constraint |
vhffs_dns_rr_type |
CHECK (((((((((((("type")::text = 'A'::text) OR (("type")::text = 'AAAA'::text)) OR (("type")::text = 'CNAME'::text)) OR (("type")::text = 'HINFO'::text)) OR (("type")::text = 'MX'::text)) OR (("type")::text = 'NS'::text)) OR (("type")::text = 'PTR'::text)) OR (("type")::text = 'RP'::text)) OR (("type")::text = 'SRV'::text)) OR (("type")::text = 'TXT'::text))) |
Permissions which apply to vhffs_dns_rr
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_dns_soa Structure
F-Key |
Name |
Type |
Description |
|
id |
integer |
|
|
origin |
text |
|
|
ns |
character varying(255) |
|
|
mbox |
character varying(255) |
|
|
serial |
integer |
|
|
refresh |
integer |
|
|
retry |
integer |
|
|
expire |
integer |
|
|
minimum |
integer |
|
|
ttl |
integer |
|
SELECT dns.dns_id AS id
, (
(dns."domain")::text || '.'::text
) AS origin
, dns.ns
, dns.mbox
, dns.serial
, dns.refresh
, dns.retry
, dns.expire
, dns.minimum
, dns.ttl
FROM (vhffs_dns dns
JOIN vhffs_object o
ON (
(o.object_id = dns.object_id)
)
)
WHERE (o.state = 6);
Permissions which apply to vhffs_dns_soa
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_forum Structure
F-Key |
Name |
Type |
Description |
|
username |
character varying(50) |
|
|
passwd |
character varying(40) |
|
|
firstname |
character varying(250) |
|
|
lastname |
character varying(250) |
|
|
mail |
character varying(200) |
|
|
date_creation |
bigint |
|
|
state |
integer |
|
SELECT users.username
, users.passwd
, users.firstname
, users.lastname
, users.mail
,"object".date_creation
,"object".state
FROM vhffs_users users
, vhffs_object "object"
WHERE ("object".object_id = users.object_id);
Permissions which apply to vhffs_forum
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_forward Structure
F-Key |
Name |
Type |
Description |
vhffs_mxdomain.domain
|
domain |
character varying |
PRIMARY KEY
|
|
local_part |
character varying |
PRIMARY KEY
|
|
remote_name |
character varying |
NOT NULL
|
|
password |
character varying |
NOT NULL
|
Permissions which apply to vhffs_forward
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_git Structure
F-Key |
Name |
Type |
Description |
|
git_id |
serial |
PRIMARY KEY
|
|
reponame |
character varying |
UNIQUE
NOT NULL
|
|
public |
integer |
NOT NULL
|
|
ml_name |
character varying |
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
Index -
Schema public
vhffs_groups Structure
F-Key |
Name |
Type |
Description |
|
gid |
serial |
PRIMARY KEY
|
|
groupname |
character varying(50) |
UNIQUE
NOT NULL
DEFAULT ' '::character varying
|
|
passwd |
character varying(20) |
|
|
quota |
integer |
NOT NULL
|
|
quota_used |
integer |
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
|
realname |
character varying(100) |
|
Tables referencing this one via Foreign Key Constraints:
Permissions which apply to vhffs_groups
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_history Structure
F-Key |
Name |
Type |
Description |
|
history_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_history_history_id_seq'::regclass)
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
|
message |
character varying(200) |
|
|
date |
bigint |
NOT NULL
|
Permissions which apply to vhffs_history
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_httpd Structure
F-Key |
Name |
Type |
Description |
|
httpd_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_httpd_httpd_id_seq'::regclass)
|
|
servername |
character varying(200) |
UNIQUE
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
Permissions which apply to vhffs_httpd
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_mailings Structure
F-Key |
Name |
Type |
Description |
|
id_mailing |
serial |
PRIMARY KEY
|
|
subject |
character varying |
NOT NULL
|
|
message |
text |
NOT NULL
|
|
state |
integer |
NOT NULL
|
|
date |
bigint |
|
Permissions which apply to vhffs_mailings
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_ml Structure
F-Key |
Name |
Type |
Description |
|
ml_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_ml_ml_id_seq'::regclass)
|
|
local_part |
character varying |
UNIQUE#1
NOT NULL
|
vhffs_mxdomain.domain
|
domain |
character varying |
UNIQUE#1
NOT NULL
|
|
prefix |
character varying |
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
|
open_archive |
boolean |
|
|
reply_to |
boolean |
|
|
signature |
character varying(250) |
|
|
sub_ctrl |
integer |
NOT NULL
|
|
post_ctrl |
integer |
NOT NULL
DEFAULT 3
|
Tables referencing this one via Foreign Key Constraints:
Permissions which apply to vhffs_ml
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_ml_subscribers Structure
F-Key |
Name |
Type |
Description |
|
sub_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_ml_subscribers_sub_id_seq'::regclass)
|
|
member |
character varying |
UNIQUE#1
NOT NULL
|
|
perm |
integer |
NOT NULL
|
|
hash |
character varying |
|
vhffs_ml.ml_id
|
ml_id |
integer |
UNIQUE#1
NOT NULL
|
|
language |
character varying(16) |
|
Permissions which apply to vhffs_ml_subscribers
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_mxdomain Structure
F-Key |
Name |
Type |
Description |
|
mxdomain_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_mxdomain_mxdomain_id_seq'::regclass)
|
|
domain |
character varying |
UNIQUE
|
|
boxes_path |
character varying |
NOT NULL
|
|
catchall |
character varying |
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Permissions which apply to vhffs_mxdomain
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_mysql Structure
F-Key |
Name |
Type |
Description |
|
mysql_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_mysql_mysql_id_seq'::regclass)
|
|
dbname |
character varying(200) |
UNIQUE
NOT NULL
|
|
dbuser |
character varying(200) |
UNIQUE
NOT NULL
|
|
dbpass |
character varying(32) |
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
Permissions which apply to vhffs_mysql
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_object Structure
F-Key |
Name |
Type |
Description |
|
object_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_object_object_id_seq'::regclass)
|
vhffs_users.uid
|
owner_uid |
integer |
NOT NULL
|
|
description |
text |
|
vhffs_groups.gid
|
owner_gid |
integer |
NOT NULL
|
|
type |
integer |
NOT NULL
|
|
state |
integer |
NOT NULL
|
|
refuse_reason |
text |
|
|
date_creation |
bigint |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Permissions which apply to vhffs_object
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_passwd Structure
F-Key |
Name |
Type |
Description |
|
uid |
integer |
|
|
gid |
integer |
|
|
username |
character varying(50) |
|
|
shell |
character varying(20) |
|
|
passwd |
"unknown" |
|
|
homedir |
character varying(40) |
|
SELECT vhffs_users.uid
, vhffs_users.gid
, vhffs_users.username
, vhffs_users.shell
,'*' AS passwd
, vhffs_users.homedir
FROM vhffs_users;
Permissions which apply to vhffs_passwd
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_pgsql Structure
F-Key |
Name |
Type |
Description |
|
pgsql_id |
integer |
PRIMARY KEY
DEFAULT nextval('vhffs_pgsql_pgsql_id_seq'::regclass)
|
|
dbname |
character varying(200) |
UNIQUE
NOT NULL
DEFAULT ' '::character varying
|
|
dbpass |
character varying(32) |
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
|
dbencoding |
character varying(20) |
NOT NULL
DEFAULT 'LATIN1'::character varying
|
|
dbuser |
character varying(200) |
NOT NULL
|
Permissions which apply to vhffs_pgsql
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_repository Structure
F-Key |
Name |
Type |
Description |
|
repository_id |
serial |
PRIMARY KEY
|
|
name |
character varying |
UNIQUE
NOT NULL
|
|
quota |
integer |
NOT NULL
|
|
quota_used |
integer |
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
Permissions which apply to vhffs_repository
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_shadow Structure
F-Key |
Name |
Type |
Description |
|
uid |
integer |
|
|
gid |
integer |
|
|
username |
character varying(50) |
|
|
shell |
character varying(20) |
|
|
passwd |
character varying(40) |
|
|
newtok |
"unknown" |
|
|
expired |
"unknown" |
|
|
homedir |
character varying(40) |
|
SELECT vhffs_users.uid
, vhffs_users.gid
, vhffs_users.username
, vhffs_users.shell
, vhffs_users.passwd
,'0' AS newtok
,'0' AS expired
, vhffs_users.homedir
FROM vhffs_users;
Permissions which apply to vhffs_shadow
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_svn Structure
F-Key |
Name |
Type |
Description |
|
svn_id |
serial |
PRIMARY KEY
|
|
reponame |
character varying |
UNIQUE
NOT NULL
|
|
public |
integer |
NOT NULL
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
|
ml_name |
character varying |
|
Permissions which apply to vhffs_svn
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_user_group Structure
F-Key |
Name |
Type |
Description |
vhffs_users.uid
|
uid |
integer |
PRIMARY KEY
|
vhffs_groups.gid
|
gid |
integer |
PRIMARY KEY
|
|
state |
integer |
NOT NULL
|
Permissions which apply to vhffs_user_group
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
vhffs_users Structure
F-Key |
Name |
Type |
Description |
|
uid |
serial |
PRIMARY KEY
|
|
gid |
integer |
NOT NULL
|
|
username |
character varying(50) |
UNIQUE
NOT NULL
DEFAULT ' '::character varying
|
|
shell |
character varying(20) |
NOT NULL
DEFAULT ' '::character varying
|
|
passwd |
character varying(40) |
NOT NULL
DEFAULT ' '::character varying
|
|
homedir |
character varying(40) |
NOT NULL
DEFAULT ' '::character varying
|
|
admin |
integer |
NOT NULL
|
|
firstname |
character varying(250) |
|
|
lastname |
character varying(250) |
|
|
address |
text |
|
|
zipcode |
character varying(16) |
|
|
city |
character varying(250) |
|
|
country |
character varying(250) |
|
|
mail |
character varying(200) |
|
|
gpg_key |
character varying(250) |
|
|
note |
integer |
|
|
language |
character varying(16) |
|
|
theme |
character varying(250) |
|
vhffs_object.object_id
|
object_id |
integer |
NOT NULL
|
|
lastloginpanel |
bigint |
|
Tables referencing this one via Foreign Key Constraints:
Permissions which apply to vhffs_users
User |
Select |
Insert |
Update |
Delete |
Reference |
Rule |
Trigger |
vhffs |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
♦ |
Index -
Schema public
Generated by PostgreSQL Autodoc
W3C HTML 4.01 Strict