Hosting plans linked to other functions?


  • 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
    1. CREATE TABLE IF NOT EXISTS `hosting_plans` (
    2. `id` int(10) unsigned NOT NULL auto_increment,
    3. `reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
    4. `name` varchar(255) collate utf8_unicode_ci DEFAULT NULL,
    5. `props` text collate utf8_unicode_ci,
    6. `description` text collate utf8_unicode_ci,
    7. `status` int(10) unsigned NOT NULL DEFAULT '0',
    8. PRIMARY KEY (`id`)
    9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    Edited once, last by Nuxwin ().