DROP TABLE IF EXISTS `anomfoundcopy`; CREATE TABLE `anomfoundcopy` ( `vectorId` int(11) NOT NULL default '0', `refID` int(11) NOT NULL default '0', `anomalyID` int(11) NOT NULL default '0', `assetType` int(20) NOT NULL default '0', `assetID` bigint(11) unsigned default '0', `valueID` bigint(11) unsigned default '0', `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `anomalyOrigin` tinyint(4) NOT NULL default '0', `taskId` int(11) NOT NULL default '-1', KEY `AssetType` (`assetType`), KEY `taskId` (`taskId`), KEY `vectorID` (`vectorId`) ) ENGINE=MyISAM; DROP TABLE IF EXISTS tempVectorsToDelete; CREATE TABLE tempVectorsToDelete (`vector_id` int(11) NOT NULL default '0', KEY `vectorId` (`vector_Id`) ) TYPE=MyISAM; INSERT INTO `anomfoundcopy` VALUES ('15095', '73' , '5', '2', '360875', '496364', '2006-12-12 08:06:08', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15095', '73' , '5', '2', '360910', '294967', '2006-12-12 08:06:08', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15095', '73' , '2', '2', '152996', '1', '2006-12-12 08:06:08', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '367922', '160656', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '367921', '160656', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '367920', '160656', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '367919', '56888', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '367918', '160656', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '367917', '56888', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '367916', '160656', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '347527', '49438', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '347501', '156617', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '347500', '156616', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '347499', '156615', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '347498', '52637', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '347497', '156614', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '329831', '147608', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '329830', '147607', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '313373', '49862', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '313365', '143717', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '312420', '143577', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '312419', '143576', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '312418', '143575', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15116', '73' , '1', '2', '312417', '143574', '2006-12-12 08:05:39', '3', '17'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4084', '2311663', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4085', '2311664', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4086', '3326', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4087', '214168', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4089', '987', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4090', '655', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4091', '2312150', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4092', '2311665', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4093', '2311666', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4094', '2311667', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4095', '2311668', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4096', '2312151', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4097', '2312152', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4098', '2312153', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4099', '399', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4100', '214174', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4101', '2311669', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4102', '3331', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4103', '995', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4104', '2311670', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4105', '214181', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4106', '2311671', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4107', '1000', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4108', '215609', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4109', '3332', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4110', '215610', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4111', '3333', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4112', '215611', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4113', '214183', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4114', '3334', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4117', '1002', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4118', '214184', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4119', '214186', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4120', '214187', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4123', '1007', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4124', '2311672', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4125', '393', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4126', '1009', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4127', '1010', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4128', '1011', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4129', '2311673', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4130', '1013', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4131', '2311674', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4132', '214191', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4133', '400', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4134', '2312064', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4135', '2312156', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4136', '2312157', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4139', '2311675', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4140', '1025', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4141', '401', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4142', '2311676', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4143', '214195', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4144', '2311677', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4145', '2311631', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4146', '2311632', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4147', '2312158', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4148', '1032', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4149', '1033', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4150', '1026', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4151', '1034', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4152', '2311678', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4154', '214198', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4155', '214199', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4156', '1038', '2006-12-11 21:10:11', '10', '931'); INSERT INTO `anomfoundcopy` VALUES ('15250', '65' , '1', '1', '4157', '2311679', '2006-12-11 21:10:11', '10', '931'); INSERT INTO tempVectorsToDelete VALUES (15116); DELETE QUICK anomfoundcopy FROM anomfoundcopy , tempVectorsToDelete WHERE tempVectorsToDelete.vector_id = anomfoundcopy.vectorId AND ( anomfoundcopy.taskId = 17);