 INSERT INTO queue_type ( `type` ) VALUES ( 'order-pexcard-funds' );
 INSERT INTO queue_type ( `type` ) VALUES ( 'notification-minutes-way' );
 
-ALTER TABLE `queue` ADD COLUMN `id_queue_type` int(11) unsigned DEFAULT NULL;
-ALTER TABLE `queue` ADD KEY `id_queue_type` (`id_queue_type`);
-ALTER TABLE `queue` ADD CONSTRAINT `queue_ibfk_3` FOREIGN KEY (`id_queue_type`) REFERENCES `queue_type` (`id_queue_type`) ON DELETE CASCADE ON UPDATE CASCADE;
-
-UPDATE queue q INNER JOIN queue_type qt ON q.`type` = qt.`type` SET q.id_queue_type = qt.id_queue_type;
-
 INSERT INTO queue_type ( `type` ) VALUES ( 'notification-driver-priority' );
 
 INSERT INTO `report` (`title`, `content`, `active`)
 VALUES ('Communities closed', 'SELECT name as Community, \'yes\' as \'Closed\' FROM community WHERE close_all_restaurants AND active = 1 ORDER BY name ASC\n', 1);
-
 
 INSERT INTO `report` (`title`, `content`, `active`)
 VALUES ('Communities with 3rd Party Delivery restaurants closed', 'SELECT name as Community, \'yes\' as \'Closed\' FROM community WHERE close_3rd_party_delivery_restaurants AND active = 1 ORDER BY name ASC', 1);



INSERT INTO `order_forecast_type` VALUES (1,'Mean based on EW weighting with decay constant of 4 wks');


INSERT INTO `group` (`name`, `description`) VALUES ( 'restaurant', 'Restaurant group' );

INSERT INTO `community` (`id_community`, `name`, `permalink`, `loc_lat`, `loc_lon`, `active`, `private`, `prep`, `name_alt`, `range`, `image`, `driver_group`, `timezone`, `close_all_restaurants`, `close_all_restaurants_note`, `close_3rd_party_delivery_restaurants`, `close_3rd_party_delivery_restaurants_note`, `close_all_restaurants_id_admin`, `close_3rd_party_delivery_restaurants_id_admin`)
VALUES

	(119,'Community notification','Crunchbutton_Cron_Job_CommunityNotification','2016-06-01 18:00:00','minute',1,'running','2016-10-17 02:13:00','2016-10-16 12:58:00',192671,'live'),
	(120,'Support Action','Crunchbutton_Cron_Job_SupportAction','2016-10-04 21:00:00','minute',0,'idle','2016-10-10 18:26:00','2016-10-10 18:25:07',8469,'live');

