-- 校舎追加 -- resource 校舎追加 INSERT INTO resource (id, school_id, date_entered, date_modified, modified_user_id, created_by, name, shortname, description, category, location, deleted, capacity, resource_attributes, common_code, activation_key, area_id, resource_code) VALUES ("0934", "0934", "2016-09-09 00:00:00", "2016-09-09 00:00:00", "1", "1", "小山", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "栃木県", NULL); INSERT INTO resource (id, school_id, date_entered, date_modified, modified_user_id, created_by, name, shortname, description, category, location, deleted, capacity, resource_attributes, common_code, activation_key, area_id, resource_code) VALUES ("1136", "1136", "2016-09-09 00:00:00", "2016-09-09 00:00:00", "1", "1", "朝霞(伸英)", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "埼玉県", NULL); INSERT INTO resource (id, school_id, date_entered, date_modified, modified_user_id, created_by, name, shortname, description, category, location, deleted, capacity, resource_attributes, common_code, activation_key, area_id, resource_code) VALUES ("1137", "1137", "2016-09-09 00:00:00", "2016-09-09 00:00:00", "1", "1", "草加", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "埼玉県", NULL); INSERT INTO resource (id, school_id, date_entered, date_modified, modified_user_id, created_by, name, shortname, description, category, location, deleted, capacity, resource_attributes, common_code, activation_key, area_id, resource_code) VALUES ("1536", "1536", "2016-09-09 00:00:00", "2016-09-09 00:00:00", "1", "1", "長岡", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "新潟県", NULL); INSERT INTO resource (id, school_id, date_entered, date_modified, modified_user_id, created_by, name, shortname, description, category, location, deleted, capacity, resource_attributes, common_code, activation_key, area_id, resource_code) VALUES ("1537", "1537", "2016-09-09 00:00:00", "2016-09-09 00:00:00", "1", "1", "三条", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "新潟県", NULL); -- resource_sub1 校舎追加 INSERT INTO resource_sub1 (id_sub1, tel_c, address_c, rules_c, fax_c, id_label_c, last_student_id_c, last_invoice_id_c, last_teacher_id_c, rules_teacher_c, rules_staff_c, bank_account_c, bank_account_receipt_c, tantosha_c, shimebi_c) VALUES ("0934", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO resource_sub1 (id_sub1, tel_c, address_c, rules_c, fax_c, id_label_c, last_student_id_c, last_invoice_id_c, last_teacher_id_c, rules_teacher_c, rules_staff_c, bank_account_c, bank_account_receipt_c, tantosha_c, shimebi_c) VALUES ("1136", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO resource_sub1 (id_sub1, tel_c, address_c, rules_c, fax_c, id_label_c, last_student_id_c, last_invoice_id_c, last_teacher_id_c, rules_teacher_c, rules_staff_c, bank_account_c, bank_account_receipt_c, tantosha_c, shimebi_c) VALUES ("1137", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO resource_sub1 (id_sub1, tel_c, address_c, rules_c, fax_c, id_label_c, last_student_id_c, last_invoice_id_c, last_teacher_id_c, rules_teacher_c, rules_staff_c, bank_account_c, bank_account_receipt_c, tantosha_c, shimebi_c) VALUES ("1536", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO resource_sub1 (id_sub1, tel_c, address_c, rules_c, fax_c, id_label_c, last_student_id_c, last_invoice_id_c, last_teacher_id_c, rules_teacher_c, rules_staff_c, bank_account_c, bank_account_receipt_c, tantosha_c, shimebi_c) VALUES ("1537", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- users_schools 権限追加 アドミン INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_0934", "1", "0934", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 管理者 権限変更ユーザ 給与計算 担当者 INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_0934", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_0934", "2b7be457-2364-8849-810d-56778b7f9f8a", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_0934", "s0100001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_0934", "s0400001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_0934", "s1100001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_0934", "s1200001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_0934", "s1310001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_0934", "s1320001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_0934", "s1400001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_0934", "s2200001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_0934", "s2300001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_0934", "s2700001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_0934", "s2800001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_0934", "s4000001", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_0934", "s4700001", "0934", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 アドミン INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1136", "1", "1136", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 管理者 権限変更ユーザ 給与計算 担当者 INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1136", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1136", "2b7be457-2364-8849-810d-56778b7f9f8a", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1136", "s0100001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1136", "s0400001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1136", "s1100001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1136", "s1200001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1136", "s1310001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1136", "s1320001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1136", "s1400001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1136", "s2200001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1136", "s2300001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1136", "s2700001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1136", "s2800001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1136", "s4000001", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1136", "s4700001", "1136", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 アドミン INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1137", "1", "1137", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 管理者 権限変更ユーザ 給与計算 担当者 INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1137", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1137", "2b7be457-2364-8849-810d-56778b7f9f8a", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1137", "s0100001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1137", "s0400001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1137", "s1100001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1137", "s1200001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1137", "s1310001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1137", "s1320001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1137", "s1400001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1137", "s2200001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1137", "s2300001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1137", "s2700001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1137", "s2800001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1137", "s4000001", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1137", "s4700001", "1137", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 アドミン INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1536", "1", "1536", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 管理者 権限変更ユーザ 給与計算 担当者 INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1536", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1536", "2b7be457-2364-8849-810d-56778b7f9f8a", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1536", "s0100001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1536", "s0400001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1536", "s1100001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1536", "s1200001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1536", "s1310001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1536", "s1320001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1536", "s1400001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1536", "s2200001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1536", "s2300001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1536", "s2700001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1536", "s2800001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1536", "s4000001", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1536", "s4700001", "1536", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 アドミン INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1537", "1", "1537", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 管理者 権限変更ユーザ 給与計算 担当者 INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1537", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1537", "2b7be457-2364-8849-810d-56778b7f9f8a", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1537", "s0100001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1537", "s0400001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1537", "s1100001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1537", "s1200001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1537", "s1310001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1537", "s1320001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1537", "s1400001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1537", "s2200001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1537", "s2300001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1537", "s2700001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1537", "s2800001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1537", "s4000001", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1537", "s4700001", "1537", "2016-09-09 00:00:00", 0); -- users_schools 権限追加 スタッフ INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100002_0934", "s1100002", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100002_1136", "s1100002", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100002_1137", "s1100002", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100002_1536", "s1100002", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100002_1537", "s1100002", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100005_0934", "s1100005", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100005_1136", "s1100005", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100005_1137", "s1100005", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100005_1536", "s1100005", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100005_1537", "s1100005", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100006_0934", "s1100006", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100006_1136", "s1100006", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100006_1137", "s1100006", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100006_1536", "s1100006", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100006_1537", "s1100006", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100007_0934", "s1100007", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100007_1136", "s1100007", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100007_1137", "s1100007", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100007_1536", "s1100007", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100007_1537", "s1100007", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100008_0934", "s1100008", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100008_1136", "s1100008", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100008_1137", "s1100008", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100008_1536", "s1100008", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100008_1537", "s1100008", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100009_0934", "s1100009", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100009_1136", "s1100009", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100009_1137", "s1100009", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100009_1536", "s1100009", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100009_1537", "s1100009", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100011_0934", "s1100011", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100011_1136", "s1100011", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100011_1137", "s1100011", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100011_1536", "s1100011", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100011_1537", "s1100011", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_0934", "s1100020", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1136", "s1100020", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1137", "s1100020", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1536", "s1100020", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1537", "s1100020", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_0934", "s1100024", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1136", "s1100024", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1137", "s1100024", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1536", "s1100024", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1537", "s1100024", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_0934", "s1100025", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1136", "s1100025", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1137", "s1100025", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1536", "s1100025", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1537", "s1100025", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_0934", "s1100026", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1136", "s1100026", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1137", "s1100026", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1536", "s1100026", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1537", "s1100026", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100021_0934", "s1100021", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100021_1136", "s1100021", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100021_1137", "s1100021", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100021_1536", "s1100021", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100021_1537", "s1100021", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100014_0934", "s1100014", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100014_1136", "s1100014", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100014_1137", "s1100014", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100014_1536", "s1100014", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100014_1537", "s1100014", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100015_0934", "s1100015", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100015_1136", "s1100015", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100015_1137", "s1100015", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100015_1536", "s1100015", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100015_1537", "s1100015", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100016_0934", "s1100016", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100016_1136", "s1100016", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100016_1137", "s1100016", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100016_1536", "s1100016", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100016_1537", "s1100016", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100018_0934", "s1100018", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100018_1136", "s1100018", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100018_1137", "s1100018", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100018_1536", "s1100018", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100018_1537", "s1100018", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100022_0934", "s1100022", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100022_1136", "s1100022", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100022_1137", "s1100022", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100022_1536", "s1100022", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100022_1537", "s1100022", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100023_0934", "s1100023", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100023_1136", "s1100023", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100023_1137", "s1100023", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100023_1536", "s1100023", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100023_1537", "s1100023", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500003_0934", "s1500003", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500003_1136", "s1500003", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500003_1137", "s1500003", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500003_1536", "s1500003", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500003_1537", "s1500003", "1537", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500005_0934", "s1500005", "0934", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500005_1136", "s1500005", "1136", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500005_1137", "s1500005", "1137", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500005_1536", "s1500005", "1536", "2016-09-09 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500005_1537", "s1500005", "1537", "2016-09-09 00:00:00", 0);