-- スタッフ追加
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1100020",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","麻子","松下","staff","26","1125","9","08");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1100021",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","教室","高崎","staff","26","1032","9","08");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1100022",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","涼","立石","staff","26","2034","9","08");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1100023",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","千恵","土田","staff","26","1535","9","08");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1400014",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","直子","平木","staff","22","1414","9","06");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1330001",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","","管理者（研修開発）","staff","20","1301","9","16");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1330002",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","","責任者（研修開発）","staff","21","1301","9","16");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1330003",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","麻衣","村瀬","staff","21","1301","5","16");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1330004",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","奈緒","松本","staff","22","1301","5","16");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s0100024",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","弘子","増永","staff","22","101","9","03");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s0100025",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","美咲","重森","staff","22","101","9","03");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s2200007",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","淳子","尾崎","staff","22","2237","9","10");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s2200008",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","美央","鈴木","staff","22","2237","9","10");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s0400008",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","絵理奈","��橋","staff","26","401","1","04");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1200018",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","一博","鈴木","staff","26","1221","1","07");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1200019",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","菜緒子","岡田","staff","26","1221","1","07");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1200020",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","育美","佐野","staff","26","1221","1","07");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s4000026",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","仁","吉村","staff","22","4001","9","14");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s4000027",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","靖子","嶋田","staff","22","4001","9","14");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s4000028",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","幸恵","石松","staff","22","4001","9","14");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s4000029",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","千晃","廣瀬","staff","22","4001","9","14");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s4000030",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","尚子","市原","staff","23","4001","9","14");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1310014",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","真美","長谷部","staff","26","1301","1","01");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1310015",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","祐子","山田","staff","26","1301","1","01");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1310016",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","祐樹","山下","staff","26","1301","1","01");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1310017",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","朋子","野中","staff","26","1301","1","01");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s1310018",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","優花","伊藤","staff","26","1301","1","01");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s2300016",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","志磨","横山","staff","22","2301","9","09");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s2300017",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","知波","加納","staff","22","2301","9","09");
INSERT INTO contacts (id,deleted,date_entered,date_modified,modified_user_id,created_by,first_name,last_name,smsgroup,contact_status,school_id,branch,shisya) VALUES("s2300018",0,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","友喜","三島","staff","22","2301","9","09");

-- ユーザ追加
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1100020","s1100020",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1100020","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1100021","s1100021",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1100021","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1100022","s1100022",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1100022","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1100023","s1100023",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1100023","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1400014","s1400014",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1400014","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1330001","s1330001",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1330001","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1330002","s1330002",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1330002","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1330003","s1330003",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1330003","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1330004","s1330004",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1330004","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s0100024","s0100024",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s0100024","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s0100025","s0100025",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s0100025","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s2200007","s2200007",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s2200007","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s2200008","s2200008",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s2200008","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s0400008","s0400008",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s0400008","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1200018","s1200018",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1200018","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1200019","s1200019",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1200019","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1200020","s1200020",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1200020","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s4000026","s4000026",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s4000026","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s4000027","s4000027",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s4000027","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s4000028","s4000028",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s4000028","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s4000029","s4000029",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s4000029","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s4000030","s4000030",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s4000030","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1310014","s1310014",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1310014","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1310015","s1310015",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1310015","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1310016","s1310016",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1310016","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1310017","s1310017",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1310017","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s1310018","s1310018",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s1310018","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s2300016","s2300016",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s2300016","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s2300017","s2300017",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s2300017","staff");
INSERT INTO users (id,user_name,user_password,user_hash,is_admin,receive_notifications,description,date_entered,date_modified,modified_user_id,created_by,status,user_preferences,deleted,portal_only,is_group,contact_id,smsgroup) VALUES("s2300018","s2300018",NULL,NULL,"off","0",NULL,"2016-04-06 00:00:00","2016-04-06 00:00:00","1","1","Active","",0,0,0,"s2300018","staff");

-- ユーザ権限
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1100020", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1100020", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1100021", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1100021", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1100022", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1100022", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1100023", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1100023", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1400014", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s1400014", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1330001", "66ba5566-afb1-ffdc-075a-550f753f8776", "s1330001", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1330002", "125de3fa-bdeb-91e3-a5de-550f7716b9c9", "s1330002", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1330003", "125de3fa-bdeb-91e3-a5de-550f7716b9c9", "s1330003", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1330004", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s1330004", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_0100024", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s0100024", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_0100025", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s0100025", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_2200007", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s2200007", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_2200008", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s2200008", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_0400008", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s0400008", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1200018", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1200018", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1200019", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1200019", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1200020", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1200020", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_4000026", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s4000026", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_4000027", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s4000027", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_4000028", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s4000028", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_4000029", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s4000029", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_4000030", "552cdd76-eb4c-3666-4f6e-550f79dd0922", "s4000030", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1310014", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1310014", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1310015", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1310015", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1310016", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1310016", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1310017", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1310017", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1310018", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1310018", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_2300016", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s2300016", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_2300017", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s2300017", "2016-04-06 00:00:00", 0);
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_2300018", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s2300018", "2016-04-06 00:00:00", 0);

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1330003_1301", "s1330003", "1301", "2016-04-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1330004_1301", "s1330004", "1301", "2016-04-06 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1100020_",resource.id), "s1100020",resource.id,"2016-04-06 00:00:00","0" FROM resource WHERE area_id LIKE "%埼玉%" OR area_id LIKE "%栃木%" OR area_id LIKE "%新潟%" OR area_id LIKE "%長野%" ;
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1100021_",resource.id), "s1100021",resource.id,"2016-04-06 00:00:00","0" FROM resource WHERE area_id LIKE "%埼玉%" OR area_id LIKE "%栃木%" OR area_id LIKE "%新潟%" OR area_id LIKE "%長野%" ;
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1100022_",resource.id), "s1100022",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%埼玉%" OR area_id LIKE "%栃木%" OR area_id LIKE "%新潟%" OR area_id LIKE "%長野%" ;
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1100023_",resource.id), "s1100023",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%埼玉%" OR area_id LIKE "%栃木%" OR area_id LIKE "%新潟%" OR area_id LIKE "%長野%" ;

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1400014_",resource.id), "s1400014",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%神奈川%" ;

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s0100024_",resource.id), "s0100024",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%北海道%" ;
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s0100025 _",resource.id), "s0100025 ",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%北海道%" ;

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s2200007_",resource.id), "s2200007",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%静岡%" ;
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s2200008_",resource.id), "s2200008",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%静岡%" ;

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s0400008_",resource.id), "s0400008",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%青森%" OR area_id LIKE "%岩手%" OR area_id LIKE "%宮城%" OR area_id LIKE "%秋田%" OR area_id LIKE "%山形%" OR area_id LIKE "%福島%";

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1200018_",resource.id), "s1200018",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%茨城%" OR area_id LIKE "%千葉%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1200019_",resource.id), "s1200019",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%茨城%" OR area_id LIKE "%千葉%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1200020_",resource.id), "s1200020",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%茨城%" OR area_id LIKE "%千葉%";

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s4000026_",resource.id), "s4000026",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%山口%" OR area_id LIKE "%福岡%" OR area_id LIKE "%佐賀%" OR area_id LIKE "%長崎%" OR area_id LIKE "%熊本%" OR area_id LIKE "%大分%" OR area_id LIKE "%宮崎%" OR area_id LIKE "%鹿児島%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s4000027_",resource.id), "s4000027",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%山口%" OR area_id LIKE "%福岡%" OR area_id LIKE "%佐賀%" OR area_id LIKE "%長崎%" OR area_id LIKE "%熊本%" OR area_id LIKE "%大分%" OR area_id LIKE "%宮崎%" OR area_id LIKE "%鹿児島%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s4000028_",resource.id), "s4000028",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%山口%" OR area_id LIKE "%福岡%" OR area_id LIKE "%佐賀%" OR area_id LIKE "%長崎%" OR area_id LIKE "%熊本%" OR area_id LIKE "%大分%" OR area_id LIKE "%宮崎%" OR area_id LIKE "%鹿児島%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s4000029_",resource.id), "s4000029",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%山口%" OR area_id LIKE "%福岡%" OR area_id LIKE "%佐賀%" OR area_id LIKE "%長崎%" OR area_id LIKE "%熊本%" OR area_id LIKE "%大分%" OR area_id LIKE "%宮崎%" OR area_id LIKE "%鹿児島%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s4000030_",resource.id), "s4000030",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%山口%" OR area_id LIKE "%福岡%" OR area_id LIKE "%佐賀%" OR area_id LIKE "%長崎%" OR area_id LIKE "%熊本%" OR area_id LIKE "%大分%" OR area_id LIKE "%宮崎%" OR area_id LIKE "%鹿児島%";

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1310014_",resource.id), "s1310014",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%東京%" OR area_id LIKE "%山梨%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1310015_",resource.id), "s1310015",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%東京%" OR area_id LIKE "%山梨%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1310016_",resource.id), "s1310016",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%東京%" OR area_id LIKE "%山梨%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1310017_",resource.id), "s1310017",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%東京%" OR area_id LIKE "%山梨%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s1310018_",resource.id), "s1310018",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%東京%" OR area_id LIKE "%山梨%";

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s2300016_",resource.id), "s2300016",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%富山%" OR area_id LIKE "%石川%" OR area_id LIKE "%岐阜%" OR area_id LIKE "%愛知%" OR area_id LIKE "%三重%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s2300017 _",resource.id), "s2300017 ",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%富山%" OR area_id LIKE "%石川%" OR area_id LIKE "%岐阜%" OR area_id LIKE "%愛知%" OR area_id LIKE "%三重%";
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) SELECT CONCAT("s2300018_",resource.id), "s2300018",resource.id,"2016-04-06 00:00:00","0"FROM resource WHERE area_id LIKE "%富山%" OR area_id LIKE "%石川%" OR area_id LIKE "%岐阜%" OR area_id LIKE "%愛知%" OR area_id LIKE "%三重%";