-- 校舎追加
-- 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
	("1403", "1403", "2016-07-22 00:00:00", "2016-07-22 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
	("1404", "1404", "2016-07-22 00:00:00", "2016-07-22 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
	("1405", "1405", "2016-07-22 00:00:00", "2016-07-22 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
	("1403", 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
	("1404", 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
	("1405", 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_1403", "1", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1404", "1", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1405", "1", "1405", "2016-07-22 00:00:00", 0);

-- users_schools 権限追加　管理者 アドミンユーザ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1403", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1403", "s0100001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1403", "s0400001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1403", "s1100001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1403", "s1200001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1403", "s1310001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1403", "s1320001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1403", "s1400001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1403", "s2200001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1403", "s2300001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1403", "s2700001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1403", "s2800001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1403", "s4000001", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1403", "s4700001", "1403", "2016-07-22 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1404", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1404", "s0100001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1404", "s0400001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1404", "s1100001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1404", "s1200001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1404", "s1310001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1404", "s1320001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1404", "s1400001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1404", "s2200001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1404", "s2300001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1404", "s2700001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1404", "s2800001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1404", "s4000001", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1404", "s4700001", "1404", "2016-07-22 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_1405", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_1405", "s0100001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_1405", "s0400001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_1405", "s1100001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_1405", "s1200001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_1405", "s1310001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_1405", "s1320001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_1405", "s1400001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_1405", "s2200001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_1405", "s2300001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_1405", "s2700001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_1405", "s2800001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_1405", "s4000001", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_1405", "s4700001", "1405", "2016-07-22 00:00:00", 0);


-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400002_1403", "s1400002", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400002_1404", "s1400002", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400002_1405", "s1400002", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400003_1403", "s1400003", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400003_1404", "s1400003", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400003_1405", "s1400003", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400004_1403", "s1400004", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400004_1404", "s1400004", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400004_1405", "s1400004", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400005_1403", "s1400005", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400005_1404", "s1400005", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400005_1405", "s1400005", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400006_1403", "s1400006", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400006_1404", "s1400006", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400006_1405", "s1400006", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400007_1403", "s1400007", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400007_1404", "s1400007", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400007_1405", "s1400007", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400008_1403", "s1400008", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400008_1404", "s1400008", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400008_1405", "s1400008", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400009_1403", "s1400009", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400009_1404", "s1400009", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400009_1405", "s1400009", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400010_1403", "s1400010", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400010_1404", "s1400010", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400010_1405", "s1400010", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400012_1403", "s1400012", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400012_1404", "s1400012", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400012_1405", "s1400012", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400013_1403", "s1400013", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400013_1404", "s1400013", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400013_1405", "s1400013", "1405", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400014_1403", "s1400014", "1403", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400014_1404", "s1400014", "1404", "2016-07-22 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400014_1405", "s1400014", "1405", "2016-07-22 00:00:00", 0);