-- スタッフ追加
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("s1200015",0,"2015-11-25 00:00:00","2015-11-25 00:00:00","1","1","教室長","水戸","staff","23","0799","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("s1200015","s1200015",NULL,NULL,"off","0",NULL,"2015-11-25 00:00:00","2015-11-25 00:00:00","1","1","Active","",0,0,0,"s1200015","staff");

-- ユーザ権限
INSERT INTO acl_roles_users (id, role_id, user_id, date_modified, deleted) VALUES("sacl_1200015", "552cdd76-eb4c-3666-4f6e-550f79dd0922", "s1200015", "2015-11-25 00:00:00", 0);

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200015_0799", "s1200015", "0799", "2015-11-25 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200015_0824", "s1200015", "0824", "2015-11-25 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200015_0899", "s1200015", "0899", "2015-11-25 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200015_1221", "s1200015", "1221", "2015-11-25 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200015_1222", "s1200015", "1222", "2015-11-25 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200015_1223", "s1200015", "1223", "2015-11-25 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200015_1299", "s1200015", "1299", "2015-11-25 00:00:00", 0);