-- スタッフ追加
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("s1200021",0,"2016-11-14 00:00:00","2016-11-14 00:00:00","1","1","俊典","佐分","staff","26","1221","1","07");

-- ユーザ追加
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("s1200021","s1200021",NULL,NULL,"off","0",NULL,"2016-11-14 00:00:00","2016-11-14 00:00:00","1","1","Active","",0,0,0,"s1200021","staff");

-- ユーザ権限
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_s1200021", "e2fbc4e9-e4d0-e9df-e1c2-5534ab3da78e", "s1200021", "2016-11-14 00:00:00", 0);

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1221", "s1200021", "1221", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1222", "s1200021", "1222", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1223", "s1200021", "1223", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1224", "s1200021", "1224", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1225", "s1200021", "1225", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1226", "s1200021", "1226", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1227", "s1200021", "1227", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1228", "s1200021", "1228", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1229", "s1200021", "1229", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1230", "s1200021", "1230", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1231", "s1200021", "1231", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1232", "s1200021", "1232", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1233", "s1200021", "1233", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1234", "s1200021", "1234", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1235", "s1200021", "1235", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1236", "s1200021", "1236", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1237", "s1200021", "1237", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1238", "s1200021", "1238", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1239", "s1200021", "1239", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1299", "s1200021", "1299", "2016-11-14 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200021_1240", "s1200021", "1240", "2016-11-14 00:00:00", 0);