CREATE TABLE IF NOT EXISTS `extraplan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `stripe_plan` varchar(255) DEFAULT NULL,
  `category` varchar(50) DEFAULT NULL,
  `type` enum('monthly','one-time') DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `default_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `default_amount` int(11) NOT NULL DEFAULT 1,
  `image` varchar(255) DEFAULT NULL,
  `isdefault` tinyint(1) NOT NULL DEFAULT 0,
  `infoextra` longtext DEFAULT NULL,
  `independent` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_extraplan_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
