Rinjae
47 lines
9.6 KiB
SQL
47 lines
9.6 KiB
SQL
INSERT INTO DVPOWN.COMTECOPSEQ (TABLE_NAME, NEXT_ID) VALUES ('FILE_ID', 1);
|
|
INSERT INTO DVPOWN.COMTECOPSEQ (TABLE_NAME, NEXT_ID) VALUES ('MSG_ID', 1);
|
|
INSERT INTO DVPOWN.COMTECOPSEQ (TABLE_NAME, NEXT_ID) VALUES ('APPROVAL_ID', 1);
|
|
INSERT INTO DVPOWN.COMTECOPSEQ (TABLE_NAME, NEXT_ID) VALUES ('FAQ_ID', 1);
|
|
INSERT INTO DVPOWN.COMTECOPSEQ (TABLE_NAME, NEXT_ID) VALUES ('NTT_ID', 1);
|
|
INSERT INTO DVPOWN.COMTECOPSEQ (TABLE_NAME, NEXT_ID) VALUES ('BBS_ID', 1);
|
|
INSERT INTO DVPOWN.COMTECOPSEQ (TABLE_NAME, NEXT_ID) VALUES ('BOARD_AUTH_ID', 1);
|
|
|
|
|
|
INSERT INTO DVPOWN.COMTCCMMNCODE (CODE_ID, CODE_ID_NAME, CODE_ID_DC, USE_AT, CL_CODE, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM013', '회원상태', '회원 가입 신청/승인/삭제를 위한 상태 구분', 'Y', 'EFC', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNCODE (CODE_ID, CODE_ID_NAME, CODE_ID_DC, USE_AT, CL_CODE, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', '비밀번호 힌트', '비밀번호 힌트 구분코드', 'Y', 'EFC', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM013', 'WAITING', '가입승인 대기', '가입승인 대기', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM013', 'ACTIVE', '활성화', '활성화', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM013', 'RESET_PASSWORD', '비밀번호 초기화', '비밀번호 초기화', 'Y',SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM013', 'INACTIVE', '비활성화', '비활성화', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM013', 'LOCKED', '잠김', '잠김', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM013', 'DELETED', '삭제', '삭제', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P01', '가장 기억에 남는 장소는?', '가장 기억에 남는 장소는?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P02', '나의 좌우명은?', '나의 좌우명은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P03', '나의 보물 제1호는?', '나의 보물 제1호는?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P04', '가장 기억에 남는 선생님 성함은?', '가장 기억에 남는 선생님 성함은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P05', '다른 사람은 모르는 나만의 신체비밀은?', '다른 사람은 모르는 나만의 신체비밀은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P06', '오래도록 기억하고 싶은 날짜는?', '오래도록 기억하고 싶은 날짜는?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P07', '받았던 선물 중 기억에 남는 독특한 선물은?', '받았던 선물 중 기억에 남는 독특한 선물은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P08', '가장 생각나는 친구 이름은?', '가장 생각나는 친구 이름은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P09', '인상 깊게 읽은 책 이름은?', '인상 깊게 읽은 책 이름은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P10', '내가 존경하는 인물은?', '내가 존경하는 인물은?', 'Y', SYSDATE, 'SYSTEM',SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P11', '나의 노래방 애창곡은?', '나의 노래방 애창곡은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P12', '가장 감명깊게 본 영화는?', '가장 감명깊게 본 영화는?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
INSERT INTO DVPOWN.COMTCCMMNDETAILCODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('COM022', 'P13', '좋아하는 스포츠팀 이름은?', '좋아하는 스포츠팀 이름은?', 'Y', SYSDATE, 'SYSTEM', SYSDATE, 'SYSTEM');
|
|
|
|
|
|
INSERT INTO DVPOWN.PT_USER (ESNTL_ID, USER_ID, ORGNZT_ID, USER_NAME, PASSWORD, EMPL_NO, IHIDNUM, SEXDSTN_CODE, BRTHDY, FXNUM, HOUSE_ADRES, PASSWORD_HINT, PASSWORD_CNSR, HOUSE_END_TELNO, AREA_NO, DETAIL_ADRES, ZIP, OFFM_TELNO, MBTLNUM, EMAIL_ADRES, OFCPS_NAME, HOUSE_MIDDLE_TELNO, GROUP_ID, PSTINST_CODE, EMPLYR_STTUS_CODE, CRTFC_DN_VALUE, SBSCRB_DE, LOCK_AT, LOCK_CNT, LAST_LOCK_DATE, LAST_CHANGE_PASSWORD_DATE, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY) VALUES ('SYSADMIN', 'admin@knbank.co.kr', null, '포탈관리자', 'n4PYnz95OwhnEVoX71BLhxhjup0Y+BSwfsnqXUNEts4=', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ACTIVE', null, null, 'N', 0, null, null, SYSDATE, 'SYSADMIN', SYSDATE, 'SYSADMIN');
|
|
|
|
INSERT INTO DVPOWN.COMTNEMPLYRSCRTYESTBS (SCRTY_DTRMN_TRGET_ID, MBER_TY_CODE, AUTHOR_CODE) VALUES ('SYSADMIN', 'USR ', 'ROLE_ADMIN');
|
|
|
|
INSERT INTO DVPOWN.COMTNBBSMASTER (BBS_ID, BBS_NAME, BBS_INTRCN, BBS_TY_CODE, REPLY_POSBL_AT, FILE_ATCH_POSBL_AT, ATCH_POSBL_FILE_NUMBER, ATCH_POSBL_FILE_SIZE, USE_AT, TMPLAT_ID, CMMNTY_ID, REGISTERED_BY, REGISTERED_ON, LAST_MODIFIED_BY, LAST_MODIFIED_ON, BLOG_ID, BLOG_AT) VALUES ('BBSMSTR_000000000000', '공지사항', '공지사항 게시판', 'BBST01', 'Y', 'Y', 1, null, 'Y', null, null, 'SYSADMIN', SYSDATE, 'SYSADMIN', SYSDATE, null, null);
|
|
|
|
insert into DVPOWN.PT_BOARD_AUTHORITY (AUTHORITY_ID, BBS_ID, AUTHORITY_CODE, ESNTL_ID, READ_YN, WRITE_YN, MODIFY_YN,DELETE_YN, ADMIN_YN, REGISTERED_BY, REGISTERED_ON, LAST_MODIFIED_BY,LAST_MODIFIED_ON) values ('1','BBSMSTR_000000000000','ROLE_ADMIN','_','Y','N','N','N','Y','SYSADMIN',sysdate,'SYSADMIN',SYSDATE);
|
|
insert into DVPOWN.PT_BOARD_AUTHORITY (AUTHORITY_ID, BBS_ID, AUTHORITY_CODE, ESNTL_ID, READ_YN, WRITE_YN, MODIFY_YN,DELETE_YN, ADMIN_YN, REGISTERED_BY, REGISTERED_ON, LAST_MODIFIED_BY,LAST_MODIFIED_ON) values ('2','BBSMSTR_000000000000','ROLE_USER','_','Y','N','N','N','N','SYSADMIN',sysdate,'SYSADMIN',SYSDATE);
|
|
insert into DVPOWN.PT_BOARD_AUTHORITY (AUTHORITY_ID, BBS_ID, AUTHORITY_CODE, ESNTL_ID, READ_YN, WRITE_YN, MODIFY_YN,DELETE_YN, ADMIN_YN, REGISTERED_BY, REGISTERED_ON, LAST_MODIFIED_BY,LAST_MODIFIED_ON) values ('3','BBSMSTR_000000000000','ROLE_ANONYMOUS','_','Y','N','N','N','N','SYSADMIN',sysdate,'SYSADMIN',SYSDATE);
|
|
|
|
INSERT INTO DVPOWN.PT_MESSAGE_TEMPLATE (MESSAGE_KEY, MESSAGE_TYPE, SUBJECT, CONTENTS, USE_YN, REGISTERED_BY, REGISTERED_ON, LAST_MODIFIED_BY, LAST_MODIFIED_ON) VALUES ('request_password_reset', 'email', '초기화 요청', '<p>초기화 요청</p>', 'N', null, null, 'SYSADMIN', SYSDATE);
|
|
INSERT INTO DVPOWN.PT_MESSAGE_TEMPLATE (MESSAGE_KEY, MESSAGE_TYPE, SUBJECT, CONTENTS, USE_YN, REGISTERED_BY, REGISTERED_ON, LAST_MODIFIED_BY, LAST_MODIFIED_ON) VALUES ('request_auth_number', 'sms', '인증번호 발송', '인증번호[%authNumber%]를 입력해주세요.', 'Y', 'SYSADMIN', SYSDATE, 'SYSADMIN', SYSDATE);
|
|
INSERT INTO DVPOWN.PT_MESSAGE_TEMPLATE (MESSAGE_KEY, MESSAGE_TYPE, SUBJECT, CONTENTS, USE_YN, REGISTERED_BY, REGISTERED_ON, LAST_MODIFIED_BY, LAST_MODIFIED_ON) VALUES ('request_auth_number', 'email', '포탈 인증번호', '<p>인증번호[%authNumber%]를 입력해주세요.</p><p><br></p>', 'Y', null, null, 'SYSADMIN', SYSDATE);
|