
START TRANSACTION;

ALTER TABLE `listings` ADD `o_allow_cash` tinyint(1) unsigned DEFAULT '0' AFTER `o_allow_bank`;

INSERT INTO `options` (`foreign_id`, `key`, `tab_id`, `value`, `label`, `type`, `order`, `is_visible`, `style`) VALUES
(1, 'o_time_format', 1, 'H:i|G:i|h:i|h:i a|h:i A|g:i|g:i a|g:i A::H:i', 'H:i (09:45)|G:i (9:45)|h:i (09:45)|h:i a (09:45 am)|h:i A (09:45 AM)|g:i (9:45)|g:i a (9:45 am)|g:i A (9:45 AM)', 'enum', 8, 1, NULL);

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "publish_status_ARRAY_T");
UPDATE `multi_lang` SET `content` = 'Active' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "publish_status_ARRAY_F");
UPDATE `multi_lang` SET `content` = 'Hidden' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;