CREATE TABLE RCH20.TB_ARTICLE_SEARCH_RSSTEST_1 ( SEQ NUMBER, ARTICLE_ID NUMBER NOT NULL, SITE_ID_OLD NUMBER, WRITER_ID VARCHAR2 (100) NOT NULL, CRAWL_DATE CHAR (14) NOT NULL, TITLE VARCHAR2 (2000), BODY LONG NOT NULL, RT CHAR (1) DEFAULT ‘F’, REPLY_ID VARCHAR2 (100), REPLY_WRITER_ID VARCHAR2 (100), RE CHAR (1) DEFAULT ‘F’, ADDRESS VARCHAR2 (100), LAT VARCHAR2 (50), LNG VARCHAR2 (50), CREATE_DATE CHAR (14) NOT NULL, SITE_TYPE CHAR (1), VIA_URL VARCHAR2 (200), ADDRESS_STATUS CHAR (1), MENTION CHAR (1), ARTICLE_ID_OLD NUMBER, URL VARCHAR2 (1000), REPUTATION_TYPE CHAR (1), SITE_SUB_TYPE CHAR (50), CONTENT_ID VARCHAR2 (50) NOT NULL, ADDRESS2 VARCHAR2 (100), SITE_ID VARCHAR2 (100), SITE_CODE NUMBER, WRITER_NAME VARCHAR2 (100), COLLECTED_BY CHAR (1), RT_COUNT NUMBER, FOLLOWER_COUNT NUMBER, SITE_NAME VARCHAR2 (4000), PICTURE VARCHAR2 (500), SCREEN_NAME VARCHAR2 (100), SITE_CATEGORY VARCHAR2 (100) ) COMPRESS FOR ALL OPERATIONS NOLOGGING;

CREATE INDEX RCH20.IDX_RSS_CDATE_TEST_1201 ON RCH20.TB_ARTICLE_SEARCH_RSSTEST_1201(CREATE_DATE ASC) NOLOGGING COMPRESS NOPARALLEL ;

CREATE INDEX RCH20.IDX_RSS_CID_TEST_1201 ON RCH20.TB_ARTICLE_SEARCH_RSSTEST_1201( CONTENT_ID ASC)NOLOGGING COMPRESS NOPARALLEL ;

CREATE INDEX RCH20.IDX_RSS_CRAWL_DATE_TEST_1201 ON RCH20.TB_ARTICLE_SEARCH_RSSTEST_1201 ( CRAWL_DATE ASC ) NOLOGGING COMPRESS NOPARALLEL ;

ALTER TABLE RCH20.TB_ARTICLE_SEARCH_RSSTEST_1201 ADD( UNIQUE (SEQ));

ALTER TABLE RCH20.TB_ARTICLE_SEARCH_RSSTEST_1201 ADD( PRIMARY KEY (ARTICLE_ID));

CREATE INDEX RCH20.IDX_RSS_CURL_TEST_1201 ON RCH20.TB_ARTICLE_SEARCH_RSSTEST_1201 ( URL ASC )