-- 校舎追加
-- 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
	("1322", "1322","2016-11-28 00:00:00", "2016-11-28 00:00:00", "1", "1", "日暮里", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "東京都", NULL),
	("1421", "1421","2016-11-28 00:00:00", "2016-11-28 00:00:00", "1", "1", "本郷台", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "神奈川県", NULL),
	("1422", "1422","2016-11-28 00:00:00", "2016-11-28 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
	("1322", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	("1421", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	("1422", 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_1322", "1", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1421", "1", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1422", "1", "1422", "2016-11-28 00:00:00", 0);

-- users_schools 権限追加　管理者 権限変更ユーザ  給与計算 担当者 
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1322", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1421", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1422", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1422", "2016-11-28 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1322", "2b7be457-2364-8849-810d-56778b7f9f8a", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1421", "2b7be457-2364-8849-810d-56778b7f9f8a", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1422", "2b7be457-2364-8849-810d-56778b7f9f8a", "1422", "2016-11-28 00:00:00", 0);

-- 管理者　一般ユーザ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1318", "s1320002", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1319", "s1320002", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1320", "s1320002", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_0101", "s1320002", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_0102", "s1320002", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_0111", "s1320002", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1322", "s1320002", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1421", "s1320002", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1422", "s1320002", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1318", "s1320003", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1319", "s1320003", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1320", "s1320003", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_0101", "s1320003", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_0102", "s1320003", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_0111", "s1320003", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1322", "s1320003", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1421", "s1320003", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1422", "s1320003", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1318", "s1320004", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1319", "s1320004", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1320", "s1320004", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_0101", "s1320004", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_0102", "s1320004", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_0111", "s1320004", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1322", "s1320004", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1421", "s1320004", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1422", "s1320004", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1318", "s1320005", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1319", "s1320005", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1320", "s1320005", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_0101", "s1320005", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_0102", "s1320005", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_0111", "s1320005", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1322", "s1320005", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1421", "s1320005", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1422", "s1320005", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1318", "s1320006", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1319", "s1320006", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1320", "s1320006", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_0101", "s1320006", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_0102", "s1320006", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_0111", "s1320006", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1322", "s1320006", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1421", "s1320006", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1422", "s1320006", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1318", "s1320007", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1319", "s1320007", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1320", "s1320007", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_0101", "s1320007", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_0102", "s1320007", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_0111", "s1320007", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1322", "s1320007", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1421", "s1320007", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1422", "s1320007", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1318", "s1320008", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1319", "s1320008", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1320", "s1320008", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_0101", "s1320008", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_0102", "s1320008", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_0111", "s1320008", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1322", "s1320008", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1421", "s1320008", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1422", "s1320008", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1318", "s1320009", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1319", "s1320009", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1320", "s1320009", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_0101", "s1320009", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_0102", "s1320009", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_0111", "s1320009", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1322", "s1320009", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1421", "s1320009", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1422", "s1320009", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1318", "s1320010", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1319", "s1320010", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1320", "s1320010", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_0101", "s1320010", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_0102", "s1320010", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_0111", "s1320010", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1322", "s1320010", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1421", "s1320010", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1422", "s1320010", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1318", "s1320011", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1319", "s1320011", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1320", "s1320011", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_0101", "s1320011", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_0102", "s1320011", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_0111", "s1320011", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1322", "s1320011", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1421", "s1320011", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1422", "s1320011", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1318", "s1320012", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1319", "s1320012", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1320", "s1320012", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_0101", "s1320012", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_0102", "s1320012", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_0111", "s1320012", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1322", "s1320012", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1421", "s1320012", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1422", "s1320012", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1318", "s1320013", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1319", "s1320013", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1320", "s1320013", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_0101", "s1320013", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_0102", "s1320013", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_0111", "s1320013", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1322", "s1320013", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1421", "s1320013", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1422", "s1320013", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1318", "s1320014", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1319", "s1320014", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1320", "s1320014", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_0101", "s1320014", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_0102", "s1320014", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_0111", "s1320014", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1322", "s1320014", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1421", "s1320014", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1422", "s1320014", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1318", "s1320015", "1318", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1319", "s1320015", "1319", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1320", "s1320015", "1320", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_0101", "s1320015", "0101", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_0102", "s1320015", "0102", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_0111", "s1320015", "0111", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1322", "s1320015", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1421", "s1320015", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1422", "s1320015", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1322", "s0100001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1421", "s0100001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1422", "s0100001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1322", "s0400001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1421", "s0400001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1422", "s0400001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1322", "s1100001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1421", "s1100001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1422", "s1100001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1322", "s1200001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1421", "s1200001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1422", "s1200001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1322", "s1310001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1421", "s1310001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1422", "s1310001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1322", "s1320001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1421", "s1320001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1422", "s1320001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1322", "s1400001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1421", "s1400001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1422", "s1400001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1322", "s2200001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1421", "s2200001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1422", "s2200001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1322", "s2300001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1421", "s2300001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1422", "s2300001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1322", "s2700001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1421", "s2700001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1422", "s2700001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1322", "s2800001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1421", "s2800001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1422", "s2800001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1322", "s4000001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1421", "s4000001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1422", "s4000001", "1422", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1322", "s4700001", "1322", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1421", "s4700001", "1421", "2016-11-28 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1422", "s4700001", "1422", "2016-11-28 00:00:00", 0);