insert_user_etc.euc.sql - dukejr @Wiki

insert_user_etc.euc.sql

---

DELETE FROM DOLPHIN_FACILITY;
DELETE FROM DOLPHIN_USERS;
DELETE FROM DOLPHIN_ROLES;

INSERT INTO DOLPHIN_FACILITY (
FACILITYID, NAME, ZIPCODE, ADDRESS, TELEPHONE
) VALUES (
'TEST_001', 'テスト医院', '5300001', '大阪府', '0612345678'
);

INSERT INTO DOLPHIN_USERS (
USERID, PASSWORD, SIRNAME, GIVENNAME, COMMONNAME,
LICENSE, LICENSEDESC, LICENSECODESYS,
DEPARTMENT, DEPARTMENTDESC, DEPARTMENTCODESYS,
FACILITY
) VALUES (
'TEST_001:root', 'X03MO1qnZdYdgyfeuILPmQ==', '管理', '太郎', '管理太郎',
'doctor', '医師', 'MML0026',
'01', '内科', 'MML0028',
'TEST_001'
);

• • 'password' -> 'X03MO1qnZdYdgyfeuILPmQ=='

INSERT INTO DOLPHIN_ROLES (
ID, ROLE, USER
) VALUES (
'1', 'admin', 'TEST_001:root'
);

SELECT * FROM DOLPHIN_FACILITY;
SELECT * FROM DOLPHIN_USERS;
SELECT * FROM DOLPHIN_ROLES;