CREATE TABLE `users` (
`id_User` int(11) NOT NULL,
`login` varchar(45) COLLATE utf8_bin NOT NULL,
`email` varchar(45) COLLATE utf8_bin NOT NULL,
`password` varchar(45) COLLATE utf8_bin NOT NULL,
`status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TRIGGER `before_insert_user` BEFORE INSERT ON `users`
DECLARE some_var int(11) default 0;
FOR EACH ROW
SELECT COUNT(*) INTO some_var FROM users WHERE users.email=NEW.email AND
users.login=NEW.login
IF (some_var > 0)
    THEN
    SIGNAL SQLSTATE '45000'
    SET MESSAGE_TEXT = 'Error for inserting login or email';
END IF;
END