-- スタッフ追加
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("s0100026",0,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","祐子","波多野","staff","22","0101","1","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("s0100027",0,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","光輝","和田","staff","22","0101","1","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("s0100028",0,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","ひとみ","橋立","staff","22","0101","1","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("s0100029",0,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","あゆみ","菊池","staff","22","0101","1","03");

-- ユーザ追加
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("s0100026","s0100026",NULL,NULL,"off","0",NULL,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","Active","",0,0,0,"s0100026","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("s0100027","s0100027",NULL,NULL,"off","0",NULL,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","Active","",0,0,0,"s0100027","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("s0100028","s0100028",NULL,NULL,"off","0",NULL,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","Active","",0,0,0,"s0100028","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("s0100029","s0100029",NULL,NULL,"off","0",NULL,"2016-09-05 00:00:00","2016-09-05 00:00:00","1","1","Active","",0,0,0,"s0100029","staff");

-- ユーザ権限
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s0100026", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s0100026", "2016-09-05 00:00:00", 0);

INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s0100027", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s0100027", "2016-09-05 00:00:00", 0);

INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s0100028", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s0100028", "2016-09-05 00:00:00", 0);

INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s0100029", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s0100029", "2016-09-05 00:00:00", 0);

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0101", "s0100026", "0101", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0102", "s0100026", "0102", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0103", "s0100026", "0103", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0104", "s0100026", "0104", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0105", "s0100026", "0105", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0106", "s0100026", "0106", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0107", "s0100026", "0107", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0108", "s0100026", "0108", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0109", "s0100026", "0109", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0110", "s0100026", "0110", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0199", "s0100026", "0199", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0101", "s0100027", "0101", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0102", "s0100027", "0102", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0103", "s0100027", "0103", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0104", "s0100027", "0104", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0105", "s0100027", "0105", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0106", "s0100027", "0106", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0107", "s0100027", "0107", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0108", "s0100027", "0108", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0109", "s0100027", "0109", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0110", "s0100027", "0110", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0199", "s0100027", "0199", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0101", "s0100028", "0101", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0102", "s0100028", "0102", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0103", "s0100028", "0103", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0104", "s0100028", "0104", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0105", "s0100028", "0105", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0106", "s0100028", "0106", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0107", "s0100028", "0107", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0108", "s0100028", "0108", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0109", "s0100028", "0109", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0110", "s0100028", "0110", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0199", "s0100028", "0199", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0101", "s0100029", "0101", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0102", "s0100029", "0102", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0103", "s0100029", "0103", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0104", "s0100029", "0104", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0105", "s0100029", "0105", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0106", "s0100029", "0106", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0107", "s0100029", "0107", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0108", "s0100029", "0108", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0109", "s0100029", "0109", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0110", "s0100029", "0110", "2016-09-05 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0199", "s0100029", "0199", "2016-09-05 00:00:00", 0);