CREATE TABLE IF NOT EXISTS `measurement_units` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `unit_name` varchar(50) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `measurement_units` (`unit_name`, `status`, `created_at`, `updated_at`) VALUES
('Centimeter', 'active', NOW(), NOW()),
('Inches', 'active', NOW(), NOW());