CREATE TABLE IF NOT EXISTS `article_helpful_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`article_id` int(11) NOT NULL,
`status` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
`created_by` int(11) NOT NULL DEFAULT 0,
`created_at` datetime NOT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;#

ALTER TABLE `estimates` ADD `public_key` TEXT NOT NULL AFTER `deleted`;#

ALTER TABLE `contracts` ADD `staff_signed_by` INT(11) NOT NULL DEFAULT '0' AFTER `accepted_by`;#

UPDATE `estimates` SET public_key = SUBSTRING(MD5(RAND()) FROM 1 FOR 10);#

ALTER TABLE `events` ADD `files` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `rejected_by`;#