wiki:database:h2

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- wiki:database:h2 [2022/11/17 20:15]
dhan
+++ wiki:database:h2 [2023/06/28 13:48] (현재)
dhan
@@ 줄 76: / 줄 76: @@
 	TEXT VARCHAR(255) DEFAULT NULL,
 	CREATED_AT VARCHAR(64) DEFAULT NULL,
-	"SOURCE" VARCHAR(64) DEFAULT NULL,
+	"SOURCE" VARCHAR(256) DEFAULT NULL,
 	USERID VARCHAR(64) DEFAULT NULL,
 	USERSCREENNAME VARCHAR(64) DEFAULT NULL,
@@ 줄 84: / 줄 84: @@
 	USERPROFILEIMAGEURL VARCHAR(255) DEFAULT NULL,
 	USERSTATUSESCOUNT VARCHAR(11) DEFAULT NULL
+);
+</code>
+Instagram
+<code sql>
+CREATE TABLE PUBLIC.TB_INSTAGRAM (
+	ID VARCHAR(64) NOT NULL,
+	PERMALINK VARCHAR(1024) DEFAULT NULL,
+	CAPTION TEXT,
+	CREATED_TIME VARCHAR(64) DEFAULT NULL,
+	MEDIA_TYPE VARCHAR(64) DEFAULT NULL,
+	MEDIA_URL VARCHAR(1024) DEFAULT NULL,
+	THUMBNAIL_URL VARCHAR(1024) DEFAULT NULL,
+	USERNAME VARCHAR(64) DEFAULT NULL
 );
 </code>
@@ 줄 89: / 줄 103: @@
 ===== Case Study =====
-컬럼 크기 변경
+컬럼 크기 변경(TOTAL_SIZE, USED_SIZE, NAME)
 <code sql>
 ALTER TABLE T_LOG_SYSTEM ALTER COLUMN TOTAL_SIZE VARCHAR(32) NOT NULL;
@@ 줄 104: / 줄 118: @@
 UPDATE T_ADDON_TOPKEYWORD_EXCEPT SET INFLOW='inflow' WHERE INFLOW IS NULL;
 </code>
-===== Backup =====
+인덱스(INDEX) 추가, 조회
+<code sql>
+CREATE INDEX {인덱스명} ON {테이블명} ({컬럼명})
+-- 예시(온나라) --
+CREATE INDEX TB_BMS_DCT_ENF_2021_IDX ON PUBLIC.TB_BMS_DCT_ENF_2021 (DOCID,ENFDOCID);
+CREATE INDEX TB_BMS_DCT_ENF_2021_DOCID_IDX ON PUBLIC.TB_BMS_DCT_ENF_2021 (DOCID);
+CREATE INDEX TB_BMS_DCT_ENF_2021_ENFDOCID_IDX ON PUBLIC.TB_BMS_DCT_ENF_2021 (ENFDOCID)
+-- 인덱스 조회
+SELECT * FROM information_schema.CONSTRAINTS c WHERE TABLE_SCHEMA = 'PUBLIC' AND TABLE_NAME='{테이블명}'
+or
+SELECT * FROM INFORMATION_SCHEMA.INDEXES WHERE TABLE_NAME ='{테이블명}';
+</code>
+===== Backup =====
 ===== Tip =====
 <do 2020-02-10 김토피아>H2 실행 및 설정방법</do>
 ===== Troubleshooting =====

/volume1/web/dokuwiki/data/attic/wiki/database/h2.1668683757.txt.gz · 마지막으로 수정됨: 2022/11/17 20:15 저자 dhan