CREATE TABLE `psi_packaging` (
  `pkg_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pkg_date` date DEFAULT NULL,
  `pkg_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_brand_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_product_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_competitors` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_competitor_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_competitor_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_competitor_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_competitor_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_competitor_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_competitor_6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_selling_point` tinyint(1) unsigned DEFAULT '0',
  `pkg_selling_point_others` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_performance` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_distribution` tinyint(1) unsigned DEFAULT '0',
  `pkg_ingredients` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_volume` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_packaging_material` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_label_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_preferred_colors` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_other_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_market_location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pkg_market_products_sold` bigint(20) unsigned DEFAULT '0',
  `pkg_market_date_established` date DEFAULT NULL,
  `pkg_sales_before_intervention` double unsigned DEFAULT '0',
  `pkg_sales_after_intervention` double unsigned DEFAULT '0',
  `pkg_employment_after_direct` bigint(20) unsigned DEFAULT '0',
  `pkg_employment_after_indirect` bigint(20) unsigned DEFAULT '0',
  `pkg_employment_after_months_employed` bigint(20) unsigned DEFAULT '0',
  `pkg_avg_productivity_improvement` double unsigned DEFAULT '0',
  `coop_id` bigint(20) unsigned DEFAULT '0',
  `prj_id` bigint(20) unsigned DEFAULT '0',
  `ug_id` bigint(20) unsigned DEFAULT '0',
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  `pkg_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `pkg_no_new_markets` int(10) unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `pkg_cost` decimal(65,3) unsigned DEFAULT '0.000',
  PRIMARY KEY (`pkg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=340 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

