Create a gist now

Instantly share code, notes, and snippets.

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
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment