SET @@global.sql_mode= '';
update acl_user set password='$2y$09$2dRrFiMuEg.FF9zlMgfcn.KJ2n8vmv.0dy8qZZbTXD2wpMaS3GoeW' where username='admin';
UPDATE `configuration` SET `config_value` = 1 WHERE `config_key` = 'configuration_enforce_special_list_of_products';
INSERT IGNORE INTO `customer` (`email`, `first_name`, `birthday`, `gender`, `password`, `is_confirmed`, `created_at`, `fk_language`, `is_test`, `is_email_confirmed`)
VALUES ("qaa_dt_user@lzdtest.net", "QA Test", "1975-08-12", "male",
"$2y$09$oXqychgdDXAWG9XLNr5XuOVCtJ82I9Yc9GUlbEskWF.l85oYboXhG", "1", "NOW()", "1", "", "1");
SET @MYUSER = (SELECT id_customer FROM customer WHERE email = 'qaa_dt_user@lzdtest.net');
INSERT IGNORE INTO customer_email
SET fk_customer = @MYUSER, email = 'qaa_dt_user@lzdtest.net', is_confirmed = 1, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO perpetual_cart
SET fk_customer = @MYUSER, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO newsletter_subscription
SET fk_customer = @MYUSER, email = 'qaa_dt_user@lzdtest.net', status = 'nonsubscribed', fk_newsletter_category = 1;
INSERT IGNORE INTO `customer` (`email`, `first_name`, `birthday`, `gender`, `password`, `is_confirmed`, `created_at`, `fk_language`, `is_test`, `is_email_confirmed`)
VALUES ("qaa_dt_new_user@lzdtest.net", "QA Test new", "1975-08-12", "male",
"$2y$09$oXqychgdDXAWG9XLNr5XuOVCtJ82I9Yc9GUlbEskWF.l85oYboXhG", "1", "NOW()", "1", "", "1");
SET @MYUSER = (SELECT id_customer FROM customer WHERE email = 'qaa_dt_new_user@lzdtest.net');
INSERT IGNORE INTO customer_email
SET fk_customer = @MYUSER, email = 'qaa_dt_new_user@lzdtest.net', is_confirmed = 1, created_at = NOW(),
updated_at    = NOW();
INSERT IGNORE INTO perpetual_cart
SET fk_customer = @MYUSER, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO newsletter_subscription
SET fk_customer = @MYUSER, email = 'qaa_dt_new_user@lzdtest.net', status = 'nonsubscribed', fk_newsletter_category = 1;
INSERT IGNORE INTO `customer` (`email`, `first_name`, `birthday`, `gender`, `password`, `is_confirmed`, `created_at`, `fk_language`, `is_test`, `is_email_confirmed`)
VALUES ("qaa_dt_bu_user@lzdtest.net", "QA Test bu", "1975-08-12", "male",
"$2y$09$oXqychgdDXAWG9XLNr5XuOVCtJ82I9Yc9GUlbEskWF.l85oYboXhG", "1", "NOW()", "1", "", "1");
SET @MYUSER = (SELECT id_customer FROM customer WHERE email = 'qaa_dt_bu_user@lzdtest.net');
INSERT IGNORE INTO customer_email
SET fk_customer = @MYUSER, email = 'qaa_dt_bu_user@lzdtest.net', is_confirmed = 1, created_at = NOW(),
updated_at    = NOW();
INSERT IGNORE INTO perpetual_cart
SET fk_customer = @MYUSER, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO newsletter_subscription
SET fk_customer = @MYUSER, email = 'qaa_dt_bu_user@lzdtest.net', status = 'nonsubscribed', fk_newsletter_category = 1;
INSERT IGNORE INTO `customer` (`email`, `first_name`, `birthday`, `gender`, `password`, `is_confirmed`, `created_at`, `fk_language`, `is_test`, `is_email_confirmed`)
VALUES ("qaa_mt_user@lzdtest.net", "QA Test", "1975-08-12", "male",
"$2y$09$oXqychgdDXAWG9XLNr5XuOVCtJ82I9Yc9GUlbEskWF.l85oYboXhG", "1", "NOW()", "1", "", "1");
SET @MYUSER = (SELECT id_customer FROM customer WHERE email = 'qaa_mt_user@lzdtest.net');
INSERT IGNORE INTO customer_email
SET fk_customer = @MYUSER, email = 'qaa_mt_user@lzdtest.net', is_confirmed = 1, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO perpetual_cart
SET fk_customer = @MYUSER, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO newsletter_subscription
SET fk_customer = @MYUSER, email = 'qaa_mt_user@lzdtest.net', status = 'nonsubscribed', fk_newsletter_category = 1;
INSERT IGNORE INTO `customer` (`email`, `first_name`, `birthday`, `gender`, `password`, `is_confirmed`, `created_at`, `fk_language`, `is_test`, `is_email_confirmed`)
VALUES ("qaa_mt_new_user@lzdtest.net", "QA Test new", "1975-08-12", "male",
"$2y$09$oXqychgdDXAWG9XLNr5XuOVCtJ82I9Yc9GUlbEskWF.l85oYboXhG", "1", "NOW()", "1", "", "1");
SET @MYUSER = (SELECT id_customer FROM customer WHERE email = 'qaa_mt_new_user@lzdtest.net');
INSERT IGNORE INTO customer_email
SET fk_customer = @MYUSER, email = 'qaa_mt_new_user@lzdtest.net', is_confirmed = 1, created_at = NOW(),
updated_at    = NOW();
INSERT IGNORE INTO perpetual_cart
SET fk_customer = @MYUSER, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO newsletter_subscription
SET fk_customer = @MYUSER, email = 'qaa_mt_new_user@lzdtest.net', status = 'nonsubscribed', fk_newsletter_category = 1;
INSERT IGNORE INTO `customer` (`email`, `first_name`, `birthday`, `gender`, `password`, `is_confirmed`, `created_at`, `fk_language`, `is_test`, `is_email_confirmed`)
VALUES ("qaa_mt_bu_user@lzdtest.net", "QA Test bu", "1975-08-12", "male",
"$2y$09$oXqychgdDXAWG9XLNr5XuOVCtJ82I9Yc9GUlbEskWF.l85oYboXhG", "1", "NOW()", "1", "", "1");
SET @MYUSER = (SELECT id_customer FROM customer WHERE email = 'qaa_mt_bu_user@lzdtest.net');
INSERT IGNORE INTO customer_email
SET fk_customer = @MYUSER, email = 'qaa_mt_bu_user@lzdtest.net', is_confirmed = 1, created_at = NOW(),
updated_at    = NOW();
INSERT IGNORE INTO perpetual_cart
SET fk_customer = @MYUSER, created_at = NOW(), updated_at = NOW();
INSERT IGNORE INTO newsletter_subscription
SET fk_customer = @MYUSER, email = 'qaa_mt_bu_user@lzdtest.net', status = 'nonsubscribed', fk_newsletter_category = 1;