CREATE TABLE `psi_science_promotions` (
  `promo_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `promo_month` int(10) unsigned DEFAULT '1',
  `promo_year` int(10) unsigned DEFAULT '0',
  `promo_count` bigint(20) unsigned DEFAULT '0',
  `promo_remarks` text COLLATE utf8mb4_unicode_ci,
  `promo_type_id` bigint(20) unsigned DEFAULT '0',
  `encoder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`promo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_science_promotions (promo_id, promo_month, promo_year, promo_count, promo_remarks, promo_type_id, encoder, date_encoded, updater, last_updated, region_id, synched, sync_date) VALUES
(1, 7, 2012, 15, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In tincidunt interdum dolor viverra fringilla. ^___^', 1, 'Solejaena Herrera', '2013-12-09 15:09:57', 'Solejaena Herrera', '2013-12-09 16:41:03', 6, 0, NULL);
