-- 校舎追加
-- 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
	("0111", "0111","2016-11-09 00:00:00", "2016-11-09 00:00:00", "1", "1", "札幌駅前クレスト教室", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "北海道", NULL),
	("0112", "0112","2016-11-09 00:00:00", "2016-11-09 00:00:00", "1", "1", "小樽教室", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "北海道", NULL),
	("0113", "0113","2016-11-09 00:00:00", "2016-11-09 00:00:00", "1", "1", "帯広長崎屋教室", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "北海道", NULL),
	("0114", "0114","2016-11-09 00:00:00", "2016-11-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
	("0111", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	("0112", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	("0113", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	("0114", 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_0111", "1", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_0112", "1", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_0113", "1", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_0114", "1", "0114", "2016-11-09 00:00:00", 0);

-- users_schools 権限追加　管理者 権限変更ユーザ  給与計算 担当者 
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_0111", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_0112", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_0113", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_0114", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "0114", "2016-11-09 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_0111", "2b7be457-2364-8849-810d-56778b7f9f8a", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_0112", "2b7be457-2364-8849-810d-56778b7f9f8a", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_0113", "2b7be457-2364-8849-810d-56778b7f9f8a", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_0114", "2b7be457-2364-8849-810d-56778b7f9f8a", "0114", "2016-11-09 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_0111", "s0100001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_0112", "s0100001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_0113", "s0100001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_0114", "s0100001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_0111", "s0400001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_0112", "s0400001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_0113", "s0400001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_0114", "s0400001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_0111", "s1100001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_0112", "s1100001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_0113", "s1100001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_0114", "s1100001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_0111", "s1200001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_0112", "s1200001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_0113", "s1200001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_0114", "s1200001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_0111", "s1310001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_0112", "s1310001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_0113", "s1310001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_0114", "s1310001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_0111", "s1320001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_0112", "s1320001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_0113", "s1320001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_0114", "s1320001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_0111", "s1400001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_0112", "s1400001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_0113", "s1400001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_0114", "s1400001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_0111", "s2200001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_0112", "s2200001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_0113", "s2200001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_0114", "s2200001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_0111", "s2300001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_0112", "s2300001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_0113", "s2300001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_0114", "s2300001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_0111", "s2700001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_0112", "s2700001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_0113", "s2700001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_0114", "s2700001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_0111", "s2800001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_0112", "s2800001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_0113", "s2800001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_0114", "s2800001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_0111", "s4000001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_0112", "s4000001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_0113", "s4000001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_0114", "s4000001", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_0111", "s4700001", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_0112", "s4700001", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_0113", "s4700001", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_0114", "s4700001", "0114", "2016-11-09 00:00:00", 0);

-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100002_0111", "s0100002", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100002_0112", "s0100002", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100002_0113", "s0100002", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100002_0114", "s0100002", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100003_0111", "s0100003", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100003_0112", "s0100003", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100003_0113", "s0100003", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100003_0114", "s0100003", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100004_0111", "s0100004", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100004_0112", "s0100004", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100004_0113", "s0100004", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100004_0114", "s0100004", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100005_0111", "s0100005", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100005_0112", "s0100005", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100005_0113", "s0100005", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100005_0114", "s0100005", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100006_0111", "s0100006", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100006_0112", "s0100006", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100006_0113", "s0100006", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100006_0114", "s0100006", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100007_0111", "s0100007", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100007_0112", "s0100007", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100007_0113", "s0100007", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100007_0114", "s0100007", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100008_0111", "s0100008", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100008_0112", "s0100008", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100008_0113", "s0100008", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100008_0114", "s0100008", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100009_0111", "s0100009", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100009_0112", "s0100009", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100009_0113", "s0100009", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100009_0114", "s0100009", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100010_0111", "s0100010", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100010_0112", "s0100010", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100010_0113", "s0100010", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100010_0114", "s0100010", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100011_0111", "s0100011", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100011_0112", "s0100011", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100011_0113", "s0100011", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100011_0114", "s0100011", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100012_0111", "s0100012", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100012_0112", "s0100012", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100012_0113", "s0100012", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100012_0114", "s0100012", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100013_0111", "s0100013", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100013_0112", "s0100013", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100013_0113", "s0100013", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100013_0114", "s0100013", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100014_0111", "s0100014", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100014_0112", "s0100014", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100014_0113", "s0100014", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100014_0114", "s0100014", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100015_0111", "s0100015", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100015_0112", "s0100015", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100015_0113", "s0100015", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100015_0114", "s0100015", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100016_0111", "s0100016", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100016_0112", "s0100016", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100016_0113", "s0100016", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100016_0114", "s0100016", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100017_0111", "s0100017", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100017_0112", "s0100017", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100017_0113", "s0100017", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100017_0114", "s0100017", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100018_0111", "s0100018", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100018_0112", "s0100018", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100018_0113", "s0100018", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100018_0114", "s0100018", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100019_0111", "s0100019", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100019_0112", "s0100019", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100019_0113", "s0100019", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100019_0114", "s0100019", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100020_0111", "s0100020", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100020_0112", "s0100020", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100020_0113", "s0100020", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100020_0114", "s0100020", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100021_0111", "s0100021", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100021_0112", "s0100021", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100021_0113", "s0100021", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100021_0114", "s0100021", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100022_0111", "s0100022", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100022_0112", "s0100022", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100022_0113", "s0100022", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100022_0114", "s0100022", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100023_0111", "s0100023", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100023_0112", "s0100023", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100023_0113", "s0100023", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100023_0114", "s0100023", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100024_0111", "s0100024", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100024_0112", "s0100024", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100024_0113", "s0100024", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100024_0114", "s0100024", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100025_0111", "s0100025", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100025_0112", "s0100025", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100025_0113", "s0100025", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100025_0114", "s0100025", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0111", "s0100026", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0112", "s0100026", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0113", "s0100026", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100026_0114", "s0100026", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0111", "s0100027", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0112", "s0100027", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0113", "s0100027", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100027_0114", "s0100027", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0111", "s0100028", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0112", "s0100028", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0113", "s0100028", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100028_0114", "s0100028", "0114", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0111", "s0100029", "0111", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0112", "s0100029", "0112", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0113", "s0100029", "0113", "2016-11-09 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100029_0114", "s0100029", "0114", "2016-11-09 00:00:00", 0);