1.Langファイルの以下の項目に、エリアリストを追加 すでにあるエリアなのでなし 2.DB追加 -- 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 ("1313", "1313", "2015-07-01 00:00:00", "2015-07-01 00:00:00", "1", "1", "秋葉原", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "東京都", NULL), ("1314", "1314", "2015-07-01 00:00:00", "2015-07-01 00:00:00", "1", "1", "赤羽", NULL, NULL, "school", NULL, 0, NULL, NULL, NULL, NULL, "東京都", NULL), ("1315", "1315", "2015-07-01 00:00:00", "2015-07-01 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 ("1313", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ("1314", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ("1315", 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_1313", "1", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1314", "1", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("1_1315", "1", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310002_1313", "s1310002", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310003_1313", "s1310003", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310004_1313", "s1310004", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310005_1313", "s1310005", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310006_1313", "s1310006", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310007_1313", "s1310007", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310008_1313", "s1310008", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310009_1313", "s1310009", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310010_1313", "s1310010", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310011_1313", "s1310011", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1313", "s1320002", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1313", "s1320003", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1313", "s1320004", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1313", "s1320005", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1313", "s1320006", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1313", "s1320007", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1313", "s1320008", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1313", "s1320009", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1313", "s1320010", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1313", "s1320011", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1313", "s1320012", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1313", "s1320013", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1313", "s1320014", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1313", "s1320015", "1313", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310002_1314", "s1310002", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310003_1314", "s1310003", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310004_1314", "s1310004", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310005_1314", "s1310005", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310006_1314", "s1310006", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310007_1314", "s1310007", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310008_1314", "s1310008", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310009_1314", "s1310009", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310010_1314", "s1310010", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310011_1314", "s1310011", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1314", "s1320002", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1314", "s1320003", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1314", "s1320004", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1314", "s1320005", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1314", "s1320006", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1314", "s1320007", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1314", "s1320008", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1314", "s1320009", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1314", "s1320010", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1314", "s1320011", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1314", "s1320012", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1314", "s1320013", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1314", "s1320014", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1314", "s1320015", "1314", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310002_1315", "s1310002", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310003_1315", "s1310003", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310004_1315", "s1310004", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310005_1315", "s1310005", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310006_1315", "s1310006", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310007_1315", "s1310007", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310008_1315", "s1310008", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310009_1315", "s1310009", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310010_1315", "s1310010", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1310011_1315", "s1310011", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320002_1315", "s1320002", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320003_1315", "s1320003", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320004_1315", "s1320004", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320005_1315", "s1320005", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320006_1315", "s1320006", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320007_1315", "s1320007", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320008_1315", "s1320008", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320009_1315", "s1320009", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320010_1315", "s1320010", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320011_1315", "s1320011", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320012_1315", "s1320012", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320013_1315", "s1320013", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320014_1315", "s1320014", "1315", "2015-07-01 00:00:00", 0); INSERT INTO users_schools (id, user_id, school_id, date_modified, deleted) VALUES("s1320015_1315", "s1320015", "1315", "2015-07-01 00:00:00", 0);