createTable.sql

CREATE TABLE PAGES
(
	EID VARCHAR(4000) PRIMARY KEY,
	DATE DATE,
	CATEGORY VARCHAR(4000),
	ENTRYRANK NUMERIC(5),
	COUNT NUMERIC(5),
	TITLE VARCHAR(4000),
	URL VARCHAR(4000)
);
CREATE TABLE BLOG_SUBSCRIBER_ID
(
	URL VARCHAR(4000),
	BLOG_ID VARCHAR(4000),
	SUBSCRIBER_ID VARCHAR(4000)
);
CREATE TABLE "HATENA_ID" (
	`ID`	VARCHAR(4000),
	`BLOG_URL`	VARCHAR(4000),
	`LAST_POST`	DATE,
	`BLOG_TITLE`	VARCHAR(4000),
	`BLOG_SUBSCRIBER`	NUMERIC,
	`FEEDLY_COUNT`	NUMERIC,
	`HATENA_COUNT`	NUMERIC,
	`BLOG_COUNT`	NUMERIC,
	`LAST_UPDATE`	DATE
);