# =======================================
# manon
# =======================================
# sf_guard_user
INSERT IGNORE INTO sf_guard_user (id, username, algorithm, salt, password, created_at, last_login, is_active, is_super_admin)
VALUES (NULL, 'manon.pian@easycreadoc.com', 'sha1', '241280bfb085d6a15ac9d81094d2dcdb', '6ed22626d26944eecbbc7e947f66cd4b3ee87478', now(), NULL, 1, 1);
# user_history
INSERT IGNORE INTO user_history (id, user_id, hierarchy_history_id, printer_history_id, login, firstname, lastname, email, 
								 position, phone, fax, cellphone, validation_level, delivery_name, delivery_address, delivery_zipcode, delivery_city,
								 delivery_country, bill_name, bill_address, bill_zipcode, bill_city, bill_country, created_at, updated_at,
								 source_created_at, source_updated_at, source_removed_at) 
								SELECT NULL, id, 1, NULL, "manon.pian@easycreadoc.com", "Manon", "Pian", "manon.pian@alveos.fr",
									    "Admin Alveos", "01 79 97 91 24","","",NULL,"Alveos","2 rue Troyon","92310","Sevres",
									    "FR","Alveos","2 rue Troyon","92310","Sevres","FR",now(),now(),
									    now(),now(),NULL FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
# sf_guard_user_profile
INSERT IGNORE INTO sf_guard_user_profile (id, user_id, hierarchy_id, printer_id, firstname, lastname, email, 
										  position, phone, fax, cellphone, validation_level, delivery_name, delivery_address, delivery_zipcode, delivery_city,
										  delivery_country, bill_name, bill_address, bill_zipcode, bill_city, bill_country, created_at, updated_at, 
										  available_points, token, allow_notifications) 
										 SELECT NULL,user_id, 1, NULL, firstname, lastname, email, 
												 position, phone, fax, cellphone, validation_level, delivery_name, delivery_address, delivery_zipcode, delivery_city,
												 delivery_country, bill_name, bill_address, bill_zipcode, bill_city, bill_country, created_at, updated_at,
												 NULL, NULL, 0 FROM user_history WHERE login = "manon.pian@easycreadoc.com" ORDER BY id DESC limit 1;
# sf_guard_user_group
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 1 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 2 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 3 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 4 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 5 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 6 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 7 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 8 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 9 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 10 FROM sf_guard_user WHERE username = "manon.pian@easycreadoc.com";
