-- スタッフ追加
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("s2700022",0,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","恵理香","室屋","staff","22","2701","1","11");

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("s2700023",0,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","靖直","古川","staff","22","2701","1","11");

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("s2700024",0,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","純子","山下","staff","22","2701","1","11");

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("s2700025",0,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","まみ","吹野","staff","22","2701","1","11");

-- ユーザ追加
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("s2700022","s2700022",NULL,NULL,"off","0",NULL,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","Active","",0,0,0,"s2700022","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("s2700023","s2700023",NULL,NULL,"off","0",NULL,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","Active","",0,0,0,"s2700023","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("s2700024","s2700024",NULL,NULL,"off","0",NULL,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","Active","",0,0,0,"s2700024","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("s2700025","s2700025",NULL,NULL,"off","0",NULL,"2016-09-21 00:00:00","2016-09-21 00:00:00","1","1","Active","",0,0,0,"s2700025","staff");

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

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

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

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

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2510", "s2700022", "2510", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2599", "s2700022", "2599", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2608", "s2700022", "2608", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2609", "s2700022", "2609", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2610", "s2700022", "2610", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2699", "s2700022", "2699", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2701", "s2700022", "2701", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2702", "s2700022", "2702", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2703", "s2700022", "2703", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2704", "s2700022", "2704", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2705", "s2700022", "2705", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2706", "s2700022", "2706", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2707", "s2700022", "2707", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2708", "s2700022", "2708", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2709", "s2700022", "2709", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2710", "s2700022", "2710", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2711", "s2700022", "2711", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700022_2799", "s2700022", "2799", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2510", "s2700023", "2510", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2599", "s2700023", "2599", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2608", "s2700023", "2608", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2609", "s2700023", "2609", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2610", "s2700023", "2610", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2699", "s2700023", "2699", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2701", "s2700023", "2701", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2702", "s2700023", "2702", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2703", "s2700023", "2703", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2704", "s2700023", "2704", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2705", "s2700023", "2705", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2706", "s2700023", "2706", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2707", "s2700023", "2707", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2708", "s2700023", "2708", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2709", "s2700023", "2709", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2710", "s2700023", "2710", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2711", "s2700023", "2711", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700023_2799", "s2700023", "2799", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2510", "s2700024", "2510", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2599", "s2700024", "2599", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2608", "s2700024", "2608", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2609", "s2700024", "2609", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2610", "s2700024", "2610", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2699", "s2700024", "2699", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2701", "s2700024", "2701", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2702", "s2700024", "2702", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2703", "s2700024", "2703", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2704", "s2700024", "2704", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2705", "s2700024", "2705", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2706", "s2700024", "2706", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2707", "s2700024", "2707", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2708", "s2700024", "2708", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2709", "s2700024", "2709", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2710", "s2700024", "2710", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2711", "s2700024", "2711", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700024_2799", "s2700024", "2799", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2510", "s2700025", "2510", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2599", "s2700025", "2599", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2608", "s2700025", "2608", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2609", "s2700025", "2609", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2610", "s2700025", "2610", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2699", "s2700025", "2699", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2701", "s2700025", "2701", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2702", "s2700025", "2702", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2703", "s2700025", "2703", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2704", "s2700025", "2704", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2705", "s2700025", "2705", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2706", "s2700025", "2706", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2707", "s2700025", "2707", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2708", "s2700025", "2708", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2709", "s2700025", "2709", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2710", "s2700025", "2710", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2711", "s2700025", "2711", "2016-09-21 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700025_2799", "s2700025", "2799", "2016-09-21 00:00:00", 0);