since i don't have the time to develope this module at the moment i want to explain how the database is constructed, so that someone else is able to contiue on this module.

First of all: Why do we need this module?
-----------------------------------------
At the moment it is possible for a customer to register every domain, even subdomains belonging to other customers!
With the "domain"-module it is possible to assign domains to customers and to implement domain-robot-tools.

The next step would be to implement selector boxes to other modules like "dns", "mail", etc. where the customer can only select domains which belong to him.

THE TABLES:
-----------

domain
______

- domain_provider_id: reference to table domain_provider; over which provider was the domain ordered!
- provider_domain_id: reference-id from the domain-provider
- ...
- added_at: record creation date
- connected_at: date at which the domain was connected - important for billing!
- disconnected_at: empty by default. Date when the domain was canceled.
- status: status-info from the registrar


domain_handle
-------------
most registrars work with handles. In this table we assign handles from different registrars (DENIC, etc.) to the ispc-clients


domain_provider
---------------
the domainprovider is the one where the domains are ordere at (Hetzner, 1und1, HostEurope, etc.)

- provider: name of the Provider
- is_extern: BOOL; Only True if the client has ordered the domain somewhere else on his own and want's to use the domain on the ISPC-Server. - IMPORTANT FOR DOMAIN-BILLING!
- domainrobot_interface: for future development - describes the Providers domainrobot-interface: could be NULL, EMAIL, SOAP, XML, etc.

domain_tld
----------
all available TopLevelDomains

- tld: The TopLevelDomain (without dot: e.g.: "de" NOT ".de")
- domain_provider: reference to table domain_provider; which provider is responsible for registration
- domain_registrar: who is the domain registrar (DENIC, EURID, etc.); same name as in domain_handle - IMPORTANT for Table domain_handle: e.g.: When the domain test.de is ordered only DENIC-Handles from the Customer are displayed and valid!



cheers

if you have any question you can contact me over the forum.
http://www.howtoforge.com/forums/member.php?u=50859

2009-04-11