-- スタッフ追加
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("s1100024",0,"2016-08-26 00:00:00","2016-08-26 00:00:00","1","1","愛利","西野","staff","26","1125","1","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("s1100025",0,"2016-08-26 00:00:00","2016-08-26 00:00:00","1","1","恵子","目次","staff","26","1125","1","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("s1100026",0,"2016-08-26 00:00:00","2016-08-26 00:00:00","1","1","真弓","石川","staff","26","1125","1","08");

-- ユーザ追加
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("s1100024","s1100024",NULL,NULL,"off","0",NULL,"2016-08-26 00:00:00","2016-08-26 00:00:00","1","1","Active","",0,0,0,"s1100024","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("s1100025","s1100025",NULL,NULL,"off","0",NULL,"2016-08-26 00:00:00","2016-08-26 00:00:00","1","1","Active","",0,0,0,"s1100025","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("s1100026","s1100026",NULL,NULL,"off","0",NULL,"2016-08-26 00:00:00","2016-08-26 00:00:00","1","1","Active","",0,0,0,"s1100026","staff");

-- ユーザ権限
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s1100024", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1100024", "2016-08-26 00:00:00", 0);

INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s1100025", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1100025", "2016-08-26 00:00:00", 0);

INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s1100026", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1100026", "2016-08-26 00:00:00", 0);

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_0933", "s1100024", "0933", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_0999", "s1100024", "0999", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1032", "s1100024", "1032", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1033", "s1100024", "1033", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1099", "s1100024", "1099", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1125", "s1100024", "1125", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1126", "s1100024", "1126", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1127", "s1100024", "1127", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1128", "s1100024", "1128", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1129", "s1100024", "1129", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1130", "s1100024", "1130", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1131", "s1100024", "1131", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1132", "s1100024", "1132", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1133", "s1100024", "1133", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1134", "s1100024", "1134", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1135", "s1100024", "1135", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1199", "s1100024", "1199", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1501", "s1100024", "1501", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1535", "s1100024", "1535", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1599", "s1100024", "1599", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_2034", "s1100024", "2034", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_2035", "s1100024", "2035", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_2036", "s1100024", "2036", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_2099", "s1100024", "2099", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_0933", "s1100025", "0933", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_0999", "s1100025", "0999", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1032", "s1100025", "1032", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1033", "s1100025", "1033", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1099", "s1100025", "1099", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1125", "s1100025", "1125", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1126", "s1100025", "1126", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1127", "s1100025", "1127", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1128", "s1100025", "1128", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1129", "s1100025", "1129", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1130", "s1100025", "1130", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1131", "s1100025", "1131", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1132", "s1100025", "1132", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1133", "s1100025", "1133", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1134", "s1100025", "1134", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1135", "s1100025", "1135", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1199", "s1100025", "1199", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1501", "s1100025", "1501", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1535", "s1100025", "1535", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1599", "s1100025", "1599", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_2034", "s1100025", "2034", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_2035", "s1100025", "2035", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_2036", "s1100025", "2036", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_2099", "s1100025", "2099", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_0933", "s1100026", "0933", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_0999", "s1100026", "0999", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1032", "s1100026", "1032", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1033", "s1100026", "1033", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1099", "s1100026", "1099", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1125", "s1100026", "1125", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1126", "s1100026", "1126", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1127", "s1100026", "1127", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1128", "s1100026", "1128", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1129", "s1100026", "1129", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1130", "s1100026", "1130", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1131", "s1100026", "1131", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1132", "s1100026", "1132", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1133", "s1100026", "1133", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1134", "s1100026", "1134", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1135", "s1100026", "1135", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1199", "s1100026", "1199", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1501", "s1100026", "1501", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1535", "s1100026", "1535", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1599", "s1100026", "1599", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_2034", "s1100026", "2034", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_2035", "s1100026", "2035", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_2036", "s1100026", "2036", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_2099", "s1100026", "2099", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1032", "s1100020", "1032", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1033", "s1100020", "1033", "2016-08-26 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1099", "s1100020", "1099", "2016-08-26 00:00:00", 0);