-- 校舎追加
-- 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
	("1034", "1034", "2016-12-06 00:00:00", "2016-12-06 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
	("1034", 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_1034", "1", "1034", "2016-12-06 00:00:00", 0);

-- users_schools 権限追加　管理者 アドミンユーザ 給与計算 担当者 
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1034", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s9990001_1034", "2b7be457-2364-8849-810d-56778b7f9f8a", "1034", "2016-12-06 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1034", "s0100001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1034", "s0400001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1034", "s1100001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1034", "s1200001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1034", "s1310001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1034", "s1320001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1034", "s1400001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1034", "s2200001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1034", "s2300001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1034", "s2700001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1034", "s2800001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1034", "s4000001", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1034", "s4700001", "1034", "2016-12-06 00:00:00", 0);


-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100002_1034", "s1100002", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100005_1034", "s1100005", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100006_1034", "s1100006", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100007_1034", "s1100007", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100008_1034", "s1100008", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100009_1034", "s1100009", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100011_1034", "s1100011", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100020_1034", "s1100020", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100024_1034", "s1100024", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100025_1034", "s1100025", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100026_1034", "s1100026", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100021_1034", "s1100021", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100014_1034", "s1100014", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100015_1034", "s1100015", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100016_1034", "s1100016", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100018_1034", "s1100018", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100022_1034", "s1100022", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100023_1034", "s1100023", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500003_1034", "s1500003", "1034", "2016-12-06 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1500005_1034", "s1500005", "1034", "2016-12-06 00:00:00", 0);