Jump to content

Registrar module development - quick job


Recommended Posts

Hi,

 

I need a php coder for developing a registrar module.

 

I have already installed jwhoisserver and is runnning well.

 

jwhoisserver uses mysql to store domain information, including NameServers. So what I need is just to get the module to read/change/insert the information on that same database.

Find below the database structure.

This should be a peace of cake!

 



CREATE TABLE IF NOT EXISTS `country` (
 `country_key` int(3) unsigned NOT NULL AUTO_INCREMENT,
 `short` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
 `country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`country_key`),
 UNIQUE KEY `unique_country` (`short`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=247 ;

-- --------------------------------------------------------

--
-- Table structure for table `domain`
--

CREATE TABLE IF NOT EXISTS `domain` (
 `domain_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `domain` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `registered_date` datetime NOT NULL,
 `registerexpire_date` datetime NOT NULL,
 `changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `holder` bigint(20) unsigned NOT NULL,
 `admin_c` bigint(20) unsigned NOT NULL,
 `tech_c` bigint(20) unsigned NOT NULL,
 `zone_c` bigint(20) unsigned NOT NULL,
 `mntnr_fkey` bigint(20) unsigned NOT NULL,
 `publicviewabledata` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`domain_key`),
 UNIQUE KEY `UQ_domain_1` (`domain`),
 KEY `admin_c` (`admin_c`),
 KEY `mntnr_fkey` (`mntnr_fkey`),
 KEY `tech_c` (`tech_c`),
 KEY `zone_c` (`zone_c`),
 KEY `holder` (`holder`),
 KEY `privacyidx` (`publicviewabledata`),
 KEY `disabledidx` (`disabled`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `inetnum`
--

CREATE TABLE IF NOT EXISTS `inetnum` (
 `inetnumstart` int(10) unsigned NOT NULL,
 `inetnumend` int(10) unsigned NOT NULL,
 `bytelength` tinyint(3) unsigned NOT NULL DEFAULT '4',
 `netname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `admin_c` bigint(20) unsigned NOT NULL,
 `tech_c` bigint(20) unsigned NOT NULL,
 `source` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'LOCAL',
 PRIMARY KEY (`inetnumstart`,`inetnumend`,`bytelength`),
 UNIQUE KEY `UQ_inetnum_netname` (`netname`),
 KEY `admin_c` (`admin_c`),
 KEY `tech_c` (`tech_c`),
 KEY `IX_inetnum_bitlength` (`bytelength`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mntnr`
--

CREATE TABLE IF NOT EXISTS `mntnr` (
 `mntnr_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `pcode` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
 `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `country_fkey` int(3) unsigned NOT NULL DEFAULT '0',
 `phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
 `fax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`mntnr_key`),
 UNIQUE KEY `UQ_mntnr_login` (`login`),
 KEY `country_fkey` (`country_fkey`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `nameserver`
--

CREATE TABLE IF NOT EXISTS `nameserver` (
 `nameserver_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `nameserver` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `domain_fkey` bigint(20) unsigned NOT NULL,
 PRIMARY KEY (`nameserver_key`),
 UNIQUE KEY `UQ_nameserver` (`nameserver`),
 KEY `domain_fkey` (`domain_fkey`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `person`
--

CREATE TABLE IF NOT EXISTS `person` (
 `person_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `type_fkey` int(2) unsigned NOT NULL DEFAULT '0',
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `pcode` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
 `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `country_fkey` int(3) unsigned NOT NULL DEFAULT '0',
 `phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
 `fax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `mntnr_fkey` bigint(20) unsigned NOT NULL DEFAULT '0',
 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`person_key`),
 KEY `country_fkey` (`country_fkey`),
 KEY `mntnr_fkey` (`mntnr_fkey`),
 KEY `type_fkey` (`type_fkey`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- Table structure for table `type`
--

CREATE TABLE IF NOT EXISTS `type` (
 `type_key` int(2) unsigned NOT NULL AUTO_INCREMENT,
 `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`type_key`),
 UNIQUE KEY `unique_type` (`type`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `domain`
--
ALTER TABLE `domain`
 ADD CONSTRAINT `FK_domain_1` FOREIGN KEY (`admin_c`) REFERENCES `person` (`person_key`) ON DELETE NO ACTION ON UPDATE NO ACTION,
 ADD CONSTRAINT `FK_domain_mntnr` FOREIGN KEY (`mntnr_fkey`) REFERENCES `mntnr` (`mntnr_key`) ON DELETE NO ACTION ON UPDATE NO ACTION,
 ADD CONSTRAINT `FK_domain_person_techc` FOREIGN KEY (`tech_c`) REFERENCES `person` (`person_key`) ON DELETE NO ACTION ON UPDATE NO ACTION,
 ADD CONSTRAINT `FK_domain_person_zonec` FOREIGN KEY (`zone_c`) REFERENCES `person` (`person_key`) ON DELETE NO ACTION ON UPDATE NO ACTION,
 ADD CONSTRAINT `FK_domain_6` FOREIGN KEY (`holder`) REFERENCES `person` (`person_key`);

--
-- Constraints for table `inetnum`
--
ALTER TABLE `inetnum`
 ADD CONSTRAINT `FK_inetnum_1` FOREIGN KEY (`admin_c`) REFERENCES `person` (`person_key`),
 ADD CONSTRAINT `FK_inetnum_2` FOREIGN KEY (`tech_c`) REFERENCES `person` (`person_key`);

--
-- Constraints for table `mntnr`
--
ALTER TABLE `mntnr`
 ADD CONSTRAINT `FK_mntnr_country` FOREIGN KEY (`country_fkey`) REFERENCES `country` (`country_key`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `nameserver`
--
ALTER TABLE `nameserver`
 ADD CONSTRAINT `FK_nameserver_1` FOREIGN KEY (`domain_fkey`) REFERENCES `domain` (`domain_key`);

--
-- Constraints for table `person`
--
ALTER TABLE `person`
 ADD CONSTRAINT `FK_person_country` FOREIGN KEY (`country_fkey`) REFERENCES `country` (`country_key`) ON DELETE NO ACTION ON UPDATE NO ACTION,
 ADD CONSTRAINT `FK_person_mntnr` FOREIGN KEY (`mntnr_fkey`) REFERENCES `mntnr` (`mntnr_key`) ON DELETE NO ACTION ON UPDATE NO ACTION,
 ADD CONSTRAINT `FK_person_type` FOREIGN KEY (`type_fkey`) REFERENCES `type` (`type_key`) ON DELETE NO ACTION ON UPDATE NO ACTION;


Link to comment
Share on other sites

  • 6 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated