are the hosting-plan table IDs linked to other functions in imscp, or can I create them for one server and copy / import it to another?
Hosting plans linked to other functions?
- fulltilt
- Closed
- Thread is marked as Resolved.
-
-
are the hosting-plan table IDs linked to other functions in imscp, or can I create them for one server and copy / import it to another?Hello ;
The hosting_plans table has a foreign key which refers to the owner of the hosting plan (reseller_id), which can be either a reseller (resseler_id > 0) or the administrator(s) (if set to zero).
The administrator as the resellers are defined in the admin table.
Ref:
Code- CREATE TABLE IF NOT EXISTS `hosting_plans` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
- `name` varchar(255) collate utf8_unicode_ci DEFAULT NULL,
- `props` text collate utf8_unicode_ci,
- `description` text collate utf8_unicode_ci,
- `status` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-