Rinjae
91 lines
7.6 KiB
SQL
91 lines
7.6 KiB
SQL
insert into PT_CODE (CODE_ID, CODE_ID_NAME, CODE_ID_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM013' ,'회원상태', '회원 가입 신청/승인/삭제를 위한 상태 구분','Y', '2022-11-24 00:35:10','SYSTEM', '2022-11-24 00:35:10','SYSTEM');
|
|
|
|
insert into PT_CODE (CODE_ID, CODE_ID_NAME, CODE_ID_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','비밀번호 힌트','비밀번호 힌트 구분코드','Y','2022-11-24 00:35:12','SYSTEM','2022-11-24 00:35:12','SYSTEM');
|
|
|
|
insert into PT_CODE (CODE_ID, CODE_ID_NAME, CODE_ID_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM101','게시판유형','게시판 유형 구분코드','Y','2022-11-24 00:35:23','SYSTEM','2022-11-24 00:35:23','SYSTEM');
|
|
|
|
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM013','ACTIVE','활성화','활성화 상태','Y','2022-11-24 00:35:42','SYSTEM','2022-11-24 00:35:42','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM013','DELETED','삭제','삭제 상태','Y','2022-11-24 00:35:41','SYSTEM','2022-11-24 00:35:41','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM013','INACTIVE','비활성화','비활성화 상태','Y','2022-11-24 00:35:41','SYSTEM','2022-11-24 00:35:41','SYSTEM');
|
|
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM013','LOCKED','잠김','잠김 상태','Y','2022-11-24 00:35:41','SYSTEM','2022-11-24 00:35:41','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM013','WAITING','가입승인 대기','가입승인 대기 상태','Y','2022-11-24 00:35:41','SYSTEM','2022-11-24 00:35:41','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P01','가장 기억에 남는 장소는?','가장 기억에 남는 장소는?','Y','2022-11-24 00:35:46','SYSTEM','2022-11-24 00:35:46','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P02','나의 좌우명은?','나의 좌우명은?','Y','2022-11-24 00:35:46','SYSTEM','2022-11-24 00:35:46','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (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','2022-11-24 00:35:46','SYSTEM','2022-11-24 00:35:46','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P04','가장 기억에 남는 선생님 성함은?','가장 기억에 남는 선생님 성함은?','Y','2022-11-24 00:35:47','SYSTEM','2022-11-24 00:35:47','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P05','다른 사람은 모르는 나만의 신체비밀은?','다른 사람은 모르는 나만의 신체비밀은?','Y','2022-11-24 00:35:47','SYSTEM','2022-11-24 00:35:47','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P06','오래도록 기억하고 싶은 날짜는?','오래도록 기억하고 싶은 날짜는?','Y','2022-11-24 00:35:47','SYSTEM','2022-11-24 00:35:47','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P07','받았던 선물 중 기억에 남는 독특한 선물은?','받았던 선물 중 기억에 남는 독특한 선물은?','Y','2022-11-24 00:35:47','SYSTEM','2022-11-24 00:35:47','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P08','가장 생각나는 친구 이름은?','가장 생각나는 친구 이름은?','Y','2022-11-24 00:35:47','SYSTEM','2022-11-24 00:35:47','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P09','인상 깊게 읽은 책 이름은?','인상 깊게 읽은 책 이름은?','Y','2022-11-24 00:35:48','SYSTEM','2022-11-24 00:35:48','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P10','내가 존경하는 인물은?','내가 존경하는 인물은?','Y','2022-11-24 00:35:48','SYSTEM','2022-11-24 00:35:48','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P11','나의 노래방 애창곡은?','나의 노래방 애창곡은?','Y','2022-11-24 00:35:48','SYSTEM','2022-11-24 00:35:48','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P12','가장 감명깊게 본 영화는?','가장 감명깊게 본 영화는?','Y','2022-11-24 00:35:48','SYSTEM','2022-11-24 00:35:48','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM022','P13','좋아하는 스포츠팀 이름은?','좋아하는 스포츠팀 이름은?','Y','2022-11-24 00:35:48','SYSTEM','2022-11-24 00:35:48','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM101','BBST01','통합게시판','통합게시판','Y','2022-11-24 00:36:42','SYSTEM','2022-11-24 00:36:42','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM101','BBST02','블로그형게시판','블로그형게시판','Y','2022-11-24 00:36:42','SYSTEM','2022-11-24 00:36:42','SYSTEM');
|
|
|
|
insert into PT_DETAIL_CODE (CODE_ID, CODE, CODE_VALUE, CODE_DC, USE_AT, REGISTERED_ON, REGISTERED_BY, LAST_MODIFIED_ON, LAST_MODIFIED_BY)
|
|
values ('COM101','BBST03','방명록','방명록','Y','2022-11-24 00:36:42','SYSTEM','2022-11-24 00:36:42','SYSTEM');
|
|
|
|
|
|
insert into PT_BOARD_MASTER (BOARD_ID, BOARD_NAME, BOARD_DESC, BOARD_TYPE, REPLY_POSBL_AT, FILE_ATCH_POSBL_AT,
|
|
ATCH_POSBL_FILE_NUMBER, ATCH_POSBL_FILE_SIZE, USE_AT, REGISTERED_BY,
|
|
REGISTERED_ON)
|
|
values ('BBSMSTR_000000000000', '공지사항', '공지사항', 'BBST01', 'N', 'Y', 3, 2048576, 'Y', 'SYSTEM', now());
|
|
|
|
insert into PT_ID (TABLE_NAME, NEXT_ID) values ('BBS_ID', 10);
|
|
insert into PT_ID (TABLE_NAME, NEXT_ID) values ('FILE_ID', 1);
|
|
insert into PT_ID (TABLE_NAME, NEXT_ID) values ('BOARD_AUTH_ID', 1);
|
|
insert into PT_ID (TABLE_NAME, NEXT_ID) values ('NTT_ID', 1);
|
|
insert into PT_ID (TABLE_NAME, NEXT_ID) values ('FAQ_ID', 1);
|
|
insert into PT_ID (TABLE_NAME, NEXT_ID) values ('APPROVAL_ID', 1);
|
|
|
|
|
|
|