CREATE TABLE `psi_units` (
  `unit_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `unit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `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,
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`unit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_units (unit_id, unit_name, encoder, date_encoded, updater, last_updated, region_id, synched, sync_date) VALUES
(1, 'Kilograms', '', NULL, '', NULL, 6, 0, NULL),
(2, 'Liters', '', NULL, '', NULL, 6, 0, NULL),
(3, 'Pieces', '', NULL, '', NULL, 6, 0, NULL),
(6, 'Bottle', 'Neil Adamson V Lameyra', '2018-07-05 08:18:19', 'Neil Adamson V Lameyra', '2018-07-05 08:18:19', 6, 0, NULL),
(7, 'Box/Pack', 'Neil Adamson V Lameyra', '2018-07-05 08:37:11', 'Neil Adamson V Lameyra', '2018-07-05 08:37:11', 6, 0, NULL),
(8, 'liters', 'Neil Adamson V Lameyra', '2018-07-05 09:28:26', 'Neil Adamson V Lameyra', '2018-07-05 09:28:26', 6, 0, NULL),
(9, 'Sack', 'Neil Adamson V Lameyra', '2018-07-05 09:31:38', 'Neil Adamson V Lameyra', '2018-07-05 09:31:38', 6, 0, NULL),
(10, 'Sheet', 'Neil Adamson V Lameyra', '2018-07-05 09:44:58', 'Neil Adamson V Lameyra', '2018-07-05 09:44:58', 6, 0, NULL),
(11, 'Loaves', 'Neil Adamson V Lameyra', '2018-07-05 10:04:29', 'Neil Adamson V Lameyra', '2018-07-05 10:04:29', 6, 0, NULL),
(12, 'Case', 'Neil Adamson V Lameyra', '2018-07-05 10:07:19', 'Neil Adamson V Lameyra', '2018-07-05 10:07:19', 6, 0, NULL),
(13, 'grams', 'Neil Adamson V Lameyra', '2018-07-10 10:19:13', 'Neil Adamson V Lameyra', '2018-07-10 10:19:13', 6, 0, NULL),
(14, 'grams', 'Neil Adamson V Lameyra', '2018-07-10 10:19:14', 'Neil Adamson V Lameyra', '2018-07-10 10:19:14', 6, 0, NULL),
(15, 'Trays', 'John Michael A. Florendo', '2018-07-26 15:12:10', 'John Michael A. Florendo', '2018-07-26 15:12:10', 6, 0, NULL),
(16, 'bag/s', 'Neil Adamson V Lameyra', '2019-02-01 09:13:25', 'Neil Adamson V Lameyra', '2019-02-01 09:13:25', 6, 0, NULL);
