# =======================================
# virgil
# =======================================
# sf_guard_user
INSERT IGNORE INTO sf_guard_user (id, username, algorithm, salt, password, created_at, last_login, is_active, is_super_admin, is_validated)
VALUES (NULL, 'virgil', 'sha1', '33f194cbda5645ef180308b89b223596', '78314bfea8012e8258268dfdb3d2fea2643ff922', now(), NULL, 1, 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, "virgil", "Virgil", "MOULANIER", "virgil.moulanier@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 = "virgil";
# 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 = "virgil" 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 = "virgil";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 2 FROM sf_guard_user WHERE username = "virgil";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 3 FROM sf_guard_user WHERE username = "virgil";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 4 FROM sf_guard_user WHERE username = "virgil";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 5 FROM sf_guard_user WHERE username = "virgil";
INSERT IGNORE INTO sf_guard_user_group (user_id, group_id) SELECT id, 6 FROM sf_guard_user WHERE username = "virgil";
