Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
55 lines (43 sloc) 957 Bytes
create table hackers (
name varchar primary key,
followers integer,
repos integer,
location varchar,
updated timestamp
);
create table updates (
update_id varchar primary key,
author varchar,
date timestamp,
title varchar,
content text,
media varchar
);
create index updates_date_idx on updates (date);
create table blog_posts (
blog varchar,
feed_url varchar,
href varchar unique,
title varchar,
author varchar,
date timestamp,
summary text
);
create index blog_posts_date_idx on updates (date);
create table tweets (
id bigint primary key,
created_at timestamp,
user_screen_name varchar,
user_profile_image_url varchar,
user_description varchar,
user_location varchar,
user_followers_count integer,
text varchar,
retweet_count integer default 0
);
create index tweets_created_at_idx on tweets (created_at);
create table blogs (
title varchar,
html_url varchar,
feed_url varchar
);