-- エリア名変更
UPDATE `resource` SET `area_id` = '三重県' WHERE `id` = '2317';

-- 校舎追加
-- 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
	("2312", "2312", "2015-07-23 00:00:00", "2015-07-23 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
	("2312", 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_2312", "1", "2312", "2015-07-23 00:00:00", 0);

INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300001_2312", "s2300001", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300002_2312", "s2300002", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300003_2312", "s2300003", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300004_2312", "s2300004", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300005_2312", "s2300005", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300006_2312", "s2300006", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300007_2312", "s2300007", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300008_2312", "s2300008", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300009_2312", "s2300009", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300010_2312", "s2300010", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300011_2312", "s2300011", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300012_2312", "s2300012", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300013_2312", "s2300013", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300014_2312", "s2300014", "2312", "2015-07-23 00:00:00", 0);
INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s2300015_2312", "s2300015", "2312", "2015-07-23 00:00:00", 0);