# エンジンのDBに登録するデータ（サンプルアプリ結合試験用）

# USERテーブル
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID100001','三郎','アルゴ','saburo','saburo@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID110001','次郎','アルゴ','jiro','jiro@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID110101','太郎','アルゴ','taro','taro@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID120001','次男','アルゴ','tuguo','tuguo@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID120101','一男','アルゴ','kazuo','kazuo@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID200001','四子','アルゴ','yonko','yonko@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID210001','三子','アルゴ','sanko','sanko@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID210101','一子','アルゴ','kazuko','kazuko@abc.co.jp');
insert into USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID210102','二子','アルゴ','niko','niko@abc.co.jp');


# ROLEテーブル
insert into ROLE (ROLE_ID, DESCRIPTION) values ('KIKAKU_ROLE','企画営業部ロール');
insert into ROLE (ROLE_ID, DESCRIPTION) values ('JINJI_ROLE','人事部ロール');
insert into ROLE (ROLE_ID, DESCRIPTION) values ('JINJI_BUCHO_ROLE','人事部長ロール');
insert into ROLE (ROLE_ID, DESCRIPTION) values ('JINJI_KACHO_ROLE','人事課長ロール');
insert into ROLE (ROLE_ID, DESCRIPTION) values ('BUCHO_ROLE','部長ロール');
insert into ROLE (ROLE_ID, DESCRIPTION) values ('KACHO_ROLE','課長ロール');
insert into ROLE (ROLE_ID, DESCRIPTION) values ('EMPLOYEE_ROLE','一般社員ロール');


# ORGANIZATIONテーブル
insert into ORGANIZATION (ORG_ID, ORG_NAME, HIGHER_ORG_ID) values ('Z000','全社組織',NULL);
insert into ORGANIZATION (ORG_ID, ORG_NAME, HIGHER_ORG_ID) values ('E100','企画営業部','Z000');
insert into ORGANIZATION (ORG_ID, ORG_NAME, HIGHER_ORG_ID) values ('E110','企画営業部一課','E100');
insert into ORGANIZATION (ORG_ID, ORG_NAME, HIGHER_ORG_ID) values ('E120','企画営業部二課','E100');
insert into ORGANIZATION (ORG_ID, ORG_NAME, HIGHER_ORG_ID) values ('J100','人事部','Z000');
insert into ORGANIZATION (ORG_ID, ORG_NAME, HIGHER_ORG_ID) values ('J110','人事部人事課','J100');


# USERROLEMAPテーブル
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KACHO_ROLE','UID110001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KACHO_ROLE','UID210001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KACHO_ROLE','UID120001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('BUCHO_ROLE','UID100001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('BUCHO_ROLE','UID200001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KIKAKU_ROLE','UID100001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KIKAKU_ROLE','UID110001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KIKAKU_ROLE','UID110101');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KIKAKU_ROLE','UID120001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('KIKAKU_ROLE','UID120101');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('JINJI_ROLE','UID200001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('JINJI_ROLE','UID210001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('JINJI_ROLE','UID210101');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('JINJI_ROLE','UID210102');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('JINJI_BUCHO_ROLE','UID200001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('JINJI_KACHO_ROLE','UID210001');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('EMPLOYEE_ROLE','UID110101');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('EMPLOYEE_ROLE','UID120101');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('EMPLOYEE_ROLE','UID210101');
insert into USERROLEMAP (ROLE_ID, USER_ID) values ('EMPLOYEE_ROLE','UID210102');

# ORGUSERMAPテーブル
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('E100','UID100001');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('E110','UID110001');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('E110','UID110101');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('E120','UID120001');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('E120','UID120101');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('J100','UID200001');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('J110','UID210001');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('J110','UID210101');
insert into ORGUSERMAP (ORG_ID, USER_ID) values ('J110','UID210102');

# ORGROLEMAPテーブル
insert into ORGROLEMAP (ROLE_ID, ORG_ID) values ('KIKAKU_ROLE','E100');
insert into ORGROLEMAP (ROLE_ID, ORG_ID) values ('JINJI_ROLE','J100');
