Share, discuss and vote for what you would like to see added to WHMCS
DB.hosting (id int(10) unsigned NOT NULL AUTO_INCREMENT,customer_id int(10) unsigned NOT NULL,package_id smallint(4) unsigned NOT NULL,webserver_id smallint(4) unsigned NOT NULL,mailserver_id smallint(4) unsigned NOT NULL,mysqlserver_id smallint(4) unsigned NOT NULL,backupserver_id smallint(4) unsigned NOT NULL,status enum('notValidated','Validated','Active','Blocked','Reserved','Suspended','pendingCreate','pendingDelete','pendingUpdate') NOT NULL DEFAULT 'notValidated',billing_cycle enum('1','3','6','12','24') NOT NULL DEFAULT '3',domains smallint(3) unsigned NOT NULL DEFAULT '0',subdomains smallint(3) unsigned NOT NULL DEFAULT '0',website_aliases smallint(3) unsigned NOT NULL DEFAULT '0',disk_space_allocated int(10) unsigned NOT NULL DEFAULT '1',website_disk_space_used bigint(20) unsigned NOT NULL DEFAULT '0',mail_disk_space_used bigint(20) unsigned NOT NULL DEFAULT '0',mysql_disk_space_used bigint(20) unsigned NOT NULL DEFAULT '0',daily_data_transfer_allocated smallint(4) unsigned NOT NULL DEFAULT '1',daily_data_transfer_used bigint(20) unsigned NOT NULL DEFAULT '0',monthly_data_transfer_allocated smallint(5) unsigned NOT NULL DEFAULT '1',monthly_data_transfer_used bigint(20) unsigned NOT NULL DEFAULT '0',email_accounts smallint(3) unsigned NOT NULL DEFAULT '0',ftp_accounts smallint(3) unsigned NOT NULL DEFAULT '0',mysql_databases smallint(3) unsigned NOT NULL DEFAULT '0',mailbox_quota smallint(5) unsigned NOT NULL DEFAULT '1',php_as enum('apache','fast_cgi') NOT NULL DEFAULT 'apache',cgi_support enum('0','1') NOT NULL DEFAULT '0',notes text,comments text,creation_date datetime NOT NULL,updated_date TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,expiration_date datetime,grace_period smallint(3) unsigned NOT NULL DEFAULT '0',cron_output_mailto varchar(255),auto_delete enum('0','1') NOT NULL DEFAULT '0',auto_renew enum('0','1') NOT NULL DEFAULT '0',id),hosting_ibfk_1 FOREIGN KEY (customer_id) REFERENCES customer (id) ON DELETE RESTRICT,hosting_ibfk_2 FOREIGN KEY (package_id) REFERENCES package (id) ON DELETE RESTRICT,hosting_ibfk_3 FOREIGN KEY (webserver_id) REFERENCES webserver (id) ON DELETE RESTRICT,hosting_ibfk_4 FOREIGN KEY (mailserver_id) REFERENCES mailserver (id) ON DELETE RESTRICT,hosting_ibfk_5 FOREIGN KEY (mysqlserver_id) REFERENCES mysqlserver (id) ON DELETE RESTRICT,hosting_ibfk_6 FOREIGN KEY (backupserver_id) REFERENCES backupserver (id) ON DELETE RESTRICT
Featured Comment