View Single Post
  #7  
Old 17th July 2006, 17:24
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,777
Thanks: 821
Thanked 5,332 Times in 4,184 Posts
Default

Please have a look at the developer forum, there are several posts that explain the table logic. The tables are generally connected this way:

permissions are stored in isp_nodes for the websites, co-domains and users.

example:

isp_isp_web is connected to isp_nodes with the doc_id and doctype_id
isp_isp_domain is connected to isp_nodes with the doc_id and doctype_id
isp_isp_user is connected to isp_nodes with the doc_id and doctype_id

Next are the relations between websites and co-domains (isp_isp_domain) and users (isp_isp_user), these relations are stored in the isp_dep table.

Example website => co-domain relation:

isp_isp_web.doc_id = isp_dep.parent_doc_id
isp_isp_web.doctype_id = isp_dep.parent_doctype_id
isp_isp_domain.doc_id = isp_dep.child_doc_id
isp_isp_domain.doctype_id = isp_dep.child_doctype_id

the same with users:

isp_isp_web.doc_id = isp_dep.parent_doc_id
isp_isp_web.doctype_id = isp_dep.parent_doctype_id
isp_isp_user.doc_id = isp_dep.child_doc_id
isp_isp_user.doctype_id = isp_dep.child_doctype_id

I hope this helps a bit.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote