alter table opl_deletedItem add forced tinyint(1) not null default 0 after data;
alter table opl_file change fileType fileType enum('audio','image','video') NOT NULL DEFAULT 'image';
alter table opl_item change status status enum('active','deleted','purged','damaged','lost','replaced','missing','in process') NOT NULL DEFAULT 'active';
alter table opl_userHistory change action action enum('add','edit','delete','move') DEFAULT NULL;

CREATE TABLE `opl_inspection` (
  `iid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(55) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `data` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `removed` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `u_ind` (`iid`,`name`,`data`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

alter table opl_userHistory add note text after status;
