#jmkk特有の処理
delete from warehouses_customers where warehouse_id=1 ;
#3:全員
#4:営業
#5:サポート
#6:システム
#7:ロジスティクス
#8:経理
insert into roles_users set user_id=4, role_id=3, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=4, role_id=4, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=4, role_id=5, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=4, role_id=7, created_at=NOW(), updated_at=NOW();

insert into roles_users set user_id=7, role_id=1, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=7, role_id=3, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=7, role_id=4, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=7, role_id=5, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=7, role_id=6, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=7, role_id=7, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=7, role_id=8, created_at=NOW(), updated_at=NOW();

insert into roles_users set user_id=8, role_id=3, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=8, role_id=4, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=8, role_id=5, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=8, role_id=6, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=8, role_id=7, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=8, role_id=8, created_at=NOW(), updated_at=NOW();

insert into roles_users set user_id=9, role_id=3, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=9, role_id=4, created_at=NOW(), updated_at=NOW();

insert into roles_users set user_id=10, role_id=1, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=10, role_id=3, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=10, role_id=4, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=10, role_id=5, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=10, role_id=6, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=10, role_id=7, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=10, role_id=8, created_at=NOW(), updated_at=NOW();

insert into roles_users set user_id=11, role_id=3, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=11, role_id=4, created_at=NOW(), updated_at=NOW();

insert into roles_users set user_id=12, role_id=3, created_at=NOW(), updated_at=NOW();
insert into roles_users set user_id=12, role_id=4, created_at=NOW(), updated_at=NOW();
