-- スタッフ追加
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("s2300019",0,"2016-07-14 00:00:00","2016-07-14 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("s2300020",0,"2016-07-14 00:00:00","2016-07-14 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("s2300021",0,"2016-07-14 00:00:00","2016-07-14 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("s2300019","s2300019",NULL,NULL,"off","0",NULL,"2016-07-14 00:00:00","2016-07-14 00:00:00","1","1","Active","",0,0,0,"s2300019","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("s2300020","s2300020",NULL,NULL,"off","0",NULL,"2016-07-14 00:00:00","2016-07-14 00:00:00","1","1","Active","",0,0,0,"s2300020","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("s2300021","s2300021",NULL,NULL,"off","0",NULL,"2016-07-14 00:00:00","2016-07-14 00:00:00","1","1","Active","",0,0,0,"s2300021","staff");

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

INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s2300020", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s2300020", "2016-07-14 00:00:00", 0);

INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s2300021", "820ed886-5b32-0d30-1cbe-550f7803f2b8", "s2300021", "2016-07-14 00:00:00", 0);

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2301", "s2300019", "2301", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2302", "s2300019", "2302", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2303", "s2300019", "2303", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2304", "s2300019", "2304", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2305", "s2300019", "2305", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2306", "s2300019", "2306", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2307", "s2300019", "2307", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2308", "s2300019", "2308", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2309", "s2300019", "2309", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2310", "s2300019", "2310", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2311", "s2300019", "2311", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2399", "s2300019", "2399", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_1601", "s2300019", "1601", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_1699", "s2300019", "1699", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_1701", "s2300019", "1701", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_1799", "s2300019", "1799", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2112", "s2300019", "2112", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2113", "s2300019", "2113", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2114", "s2300019", "2114", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2115", "s2300019", "2115", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2116", "s2300019", "2116", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2199", "s2300019", "2199", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2314", "s2300019", "2314", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2315", "s2300019", "2315", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300019_2317", "s2300019", "2317", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2301", "s2300020", "2301", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2302", "s2300020", "2302", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2303", "s2300020", "2303", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2304", "s2300020", "2304", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2305", "s2300020", "2305", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2306", "s2300020", "2306", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2307", "s2300020", "2307", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2308", "s2300020", "2308", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2309", "s2300020", "2309", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2310", "s2300020", "2310", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2311", "s2300020", "2311", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2399", "s2300020", "2399", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_1601", "s2300020", "1601", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_1699", "s2300020", "1699", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_1701", "s2300020", "1701", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_1799", "s2300020", "1799", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2112", "s2300020", "2112", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2113", "s2300020", "2113", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2114", "s2300020", "2114", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2115", "s2300020", "2115", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2116", "s2300020", "2116", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2199", "s2300020", "2199", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2314", "s2300020", "2314", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2315", "s2300020", "2315", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300020_2317", "s2300020", "2317", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2301", "s2300021", "2301", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2302", "s2300021", "2302", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2303", "s2300021", "2303", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2304", "s2300021", "2304", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2305", "s2300021", "2305", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2306", "s2300021", "2306", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2307", "s2300021", "2307", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2308", "s2300021", "2308", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2309", "s2300021", "2309", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2310", "s2300021", "2310", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2311", "s2300021", "2311", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2399", "s2300021", "2399", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_1601", "s2300021", "1601", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_1699", "s2300021", "1699", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_1701", "s2300021", "1701", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_1799", "s2300021", "1799", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2112", "s2300021", "2112", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2113", "s2300021", "2113", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2114", "s2300021", "2114", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2115", "s2300021", "2115", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2116", "s2300021", "2116", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2199", "s2300021", "2199", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2314", "s2300021", "2314", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2315", "s2300021", "2315", "2016-07-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300021_2317", "s2300021", "2317", "2016-07-14 00:00:00", 0);