Dumped on 2008-05-20

Index of database - mig_tags

public

tags_linktags
tags_sabrosus
tags_tags
vhffs_acl
vhffs_boxes
vhffs_cvs
vhffs_dns
vhffs_dns_rr
vhffs_dns_soa
vhffs_forum
vhffs_forward
vhffs_git
vhffs_groups
vhffs_history
vhffs_httpd
vhffs_mailings
vhffs_ml
vhffs_ml_subscribers
vhffs_mxdomain
vhffs_mysql
vhffs_object
vhffs_passwd
vhffs_pgsql
vhffs_repository
vhffs_shadow
vhffs_svn
vhffs_user_group
vhffs_users

Table: tags_linktags

table de lien objets / tags

tags_linktags Structure
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: tags_sabrosus

table principale des objets taggués

tags_sabrosus Structure
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

Table: tags_tags

Liste des tags

tags_tags Structure
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

Table: vhffs_acl

vhffs_acl Structure
F-Key	Name	Type	Description
vhffs_object.object_id	granted_oid	integer	PRIMARY KEY
	perm	integer	NOT NULL
vhffs_object.object_id	target_oid	integer	PRIMARY KEY

Permissions which apply to vhffs_acl
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
vhffs	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: vhffs_boxes

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

Table: vhffs_cvs

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

Table: vhffs_dns

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:

vhffs_dns_rr

Permissions which apply to vhffs_dns
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
vhffs	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: vhffs_dns_rr

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

View: vhffs_dns_soa

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

View: vhffs_forum

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

Table: vhffs_forward

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

Table: vhffs_git

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

Table: vhffs_groups

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:

vhffs_object

vhffs_user_group

Permissions which apply to vhffs_groups
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
vhffs	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: vhffs_history

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

Table: vhffs_httpd

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

Table: vhffs_mailings

vhffs_mailings Structure
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

Table: vhffs_ml

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:

vhffs_ml_subscribers

Permissions which apply to vhffs_ml
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
vhffs	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: vhffs_ml_subscribers

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

Table: vhffs_mxdomain

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:

vhffs_boxes

vhffs_forward

vhffs_ml

Permissions which apply to vhffs_mxdomain
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
vhffs	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

Table: vhffs_mysql

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

Table: vhffs_object

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:

vhffs_acl

vhffs_cvs

vhffs_dns

vhffs_git

vhffs_groups

vhffs_history

vhffs_httpd

vhffs_ml

vhffs_mxdomain

vhffs_mysql

vhffs_pgsql

vhffs_repository

vhffs_svn

vhffs_users

Permissions which apply to vhffs_object
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
vhffs	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

View: vhffs_passwd

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

Table: vhffs_pgsql

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

Table: vhffs_repository

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

View: vhffs_shadow

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

Table: vhffs_svn

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

Table: vhffs_user_group

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

Table: vhffs_users

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:

vhffs_object

vhffs_user_group

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