--------------------------------------------------------
--  ÆÄÀÏÀÌ »ý¼ºµÊ - ¿ù¿äÀÏ-12¿ù-14-2020   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table MPL_INFORMATION
--------------------------------------------------------

  CREATE TABLE "KITCHENCABINET"."MPL_INFORMATION" 
   (	"SEQ" NUMBER(10,0), 
	"LANGUAGE" VARCHAR2(2 BYTE) DEFAULT NULL, 
	"MID" NUMBER(10,0) DEFAULT 1, 
	"TAG" VARCHAR2(200 BYTE) DEFAULT NULL, 
	"TITLE" VARCHAR2(500 BYTE) DEFAULT NULL, 
	"CONTENT" VARCHAR2(1000 BYTE) DEFAULT NULL, 
	"ATTACH_PHOTO" VARCHAR2(500 BYTE) DEFAULT NULL, 
	"RELATION_ARTICLE" VARCHAR2(500 BYTE) DEFAULT NULL, 
	"REGIST_DATE" DATE DEFAULT NULL
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
REM INSERTING into KITCHENCABINET.MPL_INFORMATION
SET DEFINE OFF;
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (1,'kr',1,'abc','Á¦¸ñÀÔ´Ï´Ù.','³»¿ëÀÔ´Ï´Ù.','photo',null,to_date('20/12/11','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (2,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù2.','³»¿ëÀÔ´Ï´Ù2.','photo2',null,to_date('20/12/11','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (4,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù4.','³»¿ëÀÔ´Ï´Ù4.','photo4',null,to_date('20/12/11','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (5,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (6,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (7,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (8,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (9,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (10,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (11,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
Insert into KITCHENCABINET.MPL_INFORMATION (SEQ,LANGUAGE,MID,TAG,TITLE,CONTENT,ATTACH_PHOTO,RELATION_ARTICLE,REGIST_DATE) values (12,'kr',1,'abc2','Á¦¸ñÀÔ´Ï´Ù5.','³»¿ëÀÔ´Ï´Ù5.','photo5',null,to_date('20/12/12','RR/MM/DD'));
--------------------------------------------------------
--  DDL for Index SYS_C007004
--------------------------------------------------------

  CREATE UNIQUE INDEX "KITCHENCABINET"."SYS_C007004" ON "KITCHENCABINET"."MPL_INFORMATION" ("SEQ") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
--------------------------------------------------------
--  Constraints for Table MPL_INFORMATION
--------------------------------------------------------

  ALTER TABLE "KITCHENCABINET"."MPL_INFORMATION" ADD PRIMARY KEY ("SEQ")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM"  ENABLE;