0.6-0.7.update.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `sender` (
  `id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `email` text NOT NULL,
  `name` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `sender`
 ADD PRIMARY KEY (`id`), ADD KEY `group_id` (`group_id`);

ALTER TABLE `sender`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;

ALTER TABLE `sender`
ADD CONSTRAINT `sender_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `campaign` ADD `sender_id` int(11) NOT NULL DEFAULT '0' ;

ALTER TABLE `campaign` ADD KEY `sender_id` (`sender_id`);

ALTER TABLE `campaign`
DROP `from`,
DROP `from_name`;

UPDATE `auth_right` SET `name` = 'get-log-utm' WHERE `auth_right`.`id` = 21;