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

-- データ追加のための準備
SET SCHEMA NAUTICA;

-- WF_USERテーブル
-- パスワード：saburo
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID100001','三郎','アルゴ','XuiMliL/isTlanQq1QDudZO6r3Q=','saburo@abc.co.jp');
-- パスワード：jiro
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID110001','次郎','アルゴ','rZB1SyRYzXh6kHDqPfaxKeQGZJA=','jiro@abc.co.jp');
-- パスワード：taro
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID110101','太郎','アルゴ','1jkttgN/ON8VpHjFFt6k0h7a9Kw=','taro@abc.co.jp');
-- パスワード：tuguo
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID120001','次男','アルゴ','6hPs66kYOlOaswQPDbL50j/QOJY=','tuguo@abc.co.jp');
-- パスワード：kazuo
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID120101','一男','アルゴ','nnRkqROmjtDFSyi9dGYmzIDkrz0=','kazuo@abc.co.jp');
-- パスワード：yonko
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID200001','四子','アルゴ','ka58FAr+2YY59mI335cKCzyFVxM=','yonko@abc.co.jp');
-- パスワード：sanko
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID210001','三子','アルゴ','Qq4MPFoZ+bB4AFLZwfFaU+xDSzc=','sanko@abc.co.jp');
-- パスワード：kazuko
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID210101','一子','アルゴ','GqV0WwYf2RfD9uvaaZwyaLjgsCg=','kazuko@abc.co.jp');
-- パスワード：niko
insert into WF_USER (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, MAIL_ADDRESS) values ('UID210102','二子','アルゴ','AT2xSb3YNBdH022PWbkrtXK2KUg=','niko@abc.co.jp');


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


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


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

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

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