-- 校舎追加
-- 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
	("2710", "2710", "2016-02-02 00:00:00", "2016-02-02 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
	("2710", 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_2710", "1", "2710", "2016-02-02 00:00:00", 0);

-- users_schools 権限追加　管理者 アドミンユーザ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_2710", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_2710", "s0100001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_2710", "s0400001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_2710", "s1100001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_2710", "s1200001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_2710", "s1310001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_2710", "s1320001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_2710", "s1400001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_2710", "s2200001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_2710", "s2300001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_2710", "s2700001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_2710", "s2800001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_2710", "s4000001", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_2710", "s4700001", "2710", "2016-02-02 00:00:00", 0);


-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700002_2710", "s2700002", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700003_2710", "s2700003", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700004_2710", "s2700004", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700005_2710", "s2700005", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700006_2710", "s2700006", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700007_2710", "s2700007", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700008_2710", "s2700008", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700009_2710", "s2700009", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700010_2710", "s2700010", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700011_2710", "s2700011", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700012_2710", "s2700012", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700013_2710", "s2700013", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700014_2710", "s2700014", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700015_2710", "s2700015", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700016_2710", "s2700016", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700017_2710", "s2700017", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700018_2710", "s2700018", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700019_2710", "s2700019", "2710", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700020_2710", "s2700020", "2710", "2016-02-02 00:00:00", 0);

-- 校舎追加
-- 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
	("2711", "2711", "2016-02-02 00:00:00", "2016-02-02 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
	("2711", 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_2711", "1", "2711", "2016-02-02 00:00:00", 0);

-- users_schools 権限追加　管理者 アドミンユーザ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s8880001_2711", "7803b4c1-3c24-b1ea-12b9-556c29fa3063", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0100001_2711", "s0100001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s0400001_2711", "s0400001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1100001_2711", "s1100001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1200001_2711", "s1200001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310001_2711", "s1310001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320001_2711", "s1320001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1400001_2711", "s1400001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2200001_2711", "s2200001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_2711", "s2300001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700001_2711", "s2700001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2800001_2711", "s2800001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4000001_2711", "s4000001", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s4700001_2711", "s4700001", "2711", "2016-02-02 00:00:00", 0);


-- users_schools 権限追加　スタッフ
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700002_2711", "s2700002", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700003_2711", "s2700003", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700004_2711", "s2700004", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700005_2711", "s2700005", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700006_2711", "s2700006", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700007_2711", "s2700007", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700008_2711", "s2700008", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700009_2711", "s2700009", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700010_2711", "s2700010", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700011_2711", "s2700011", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700012_2711", "s2700012", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700013_2711", "s2700013", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700014_2711", "s2700014", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700015_2711", "s2700015", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700016_2711", "s2700016", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700017_2711", "s2700017", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700018_2711", "s2700018", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700019_2711", "s2700019", "2711", "2016-02-02 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2700020_2711", "s2700020", "2711", "2016-02-02 00:00:00", 0);