CREATE TABLE `vps_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT 0,
  `type` varchar(50) NOT NULL COMMENT 'os, control_panel, backup, extra_ip',
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) DEFAULT 0.00,
  `rank` int(11) DEFAULT 0,
  `status` varchar(20) DEFAULT 'active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=579 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

CREATE TABLE `products` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(50) DEFAULT NULL,
  `type_id` int(11) unsigned NOT NULL DEFAULT 0,
  `category` int(11) unsigned NOT NULL DEFAULT 0,
  `categories` text DEFAULT NULL,
  `status` varchar(40) NOT NULL DEFAULT 'active',
  `visibility` varchar(30) NOT NULL DEFAULT 'visible',
  `ctime` datetime NOT NULL DEFAULT '1881-05-19 00:00:00',
  `rank` int(6) unsigned NOT NULL DEFAULT 0,
  `stock` varchar(11) DEFAULT NULL,
  `override_usrcurrency` int(1) NOT NULL DEFAULT 0,
  `taxexempt` int(1) unsigned NOT NULL DEFAULT 0,
  `upgrade` int(1) unsigned NOT NULL DEFAULT 0,
  `options` text DEFAULT NULL,
  `affiliate_disable` int(1) unsigned NOT NULL DEFAULT 0,
  `affiliate_rate` decimal(10,2) unsigned NOT NULL DEFAULT 0.00,
  `upgradeable_products` varchar(300) DEFAULT NULL,
  `addons` varchar(300) DEFAULT NULL,
  `requirements` varchar(300) DEFAULT NULL,
  `module` varchar(100) NOT NULL DEFAULT 'none',
  `module_data` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `subdomains` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=265 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci