------------------------------------------------------------------------
--

DROP TABLE dhg.reddit_frontpage_scores CASCADE;
CREATE TABLE dhg.reddit_frontpage_scores (
       score   INTEGER NOT NULL
);

-- Snapshot taken around 2007-05-11 20:30 GMT
--
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (175);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (456);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (140);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (191);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (230);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (186);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (134);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (215);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (171);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (83);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (102);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (171);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (182);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (322);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (193);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (310);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (338);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (345);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (174);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (134);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (92);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (109);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (241);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (256);
INSERT INTO dhg.reddit_frontpage_scores (score) VALUES (132);

DELETE FROM dhg.source;
INSERT INTO dhg.source SELECT * FROM dhg.reddit_frontpage_scores;


------------------------------------------------------------------------
--

DROP TABLE dhg.digg_scores;
CREATE TABLE dhg.digg_scores (score INTEGER NOT NULL);

-- snapshot taken 2007-05-15 16:40 GMT
INSERT INTO dhg.digg_scores (score) VALUES (66);
INSERT INTO dhg.digg_scores (score) VALUES (95);
INSERT INTO dhg.digg_scores (score) VALUES (97);
INSERT INTO dhg.digg_scores (score) VALUES (559);
INSERT INTO dhg.digg_scores (score) VALUES (415);
INSERT INTO dhg.digg_scores (score) VALUES (281);
INSERT INTO dhg.digg_scores (score) VALUES (208);
INSERT INTO dhg.digg_scores (score) VALUES (172);
INSERT INTO dhg.digg_scores (score) VALUES (588);
INSERT INTO dhg.digg_scores (score) VALUES (1112);
INSERT INTO dhg.digg_scores (score) VALUES (264);
INSERT INTO dhg.digg_scores (score) VALUES (440);
INSERT INTO dhg.digg_scores (score) VALUES (492);
INSERT INTO dhg.digg_scores (score) VALUES (372);
INSERT INTO dhg.digg_scores (score) VALUES (445);

DELETE FROM dhg.source;
INSERT INTO dhg.source SELECT * FROM dhg.digg_scores;

------------------------------------------------------------------------
-- front page comment count, taken 2007-05-15 20:45 GMT
--

DROP TABLE dhg.slashdot_comments;
CREATE TABLE dhg.slashdot_comments (comments INTEGER NOT NULL);

INSERT INTO dhg.slashdot_comments (comments) VALUES (4);
INSERT INTO dhg.slashdot_comments (comments) VALUES (24);
INSERT INTO dhg.slashdot_comments (comments) VALUES (103);
INSERT INTO dhg.slashdot_comments (comments) VALUES (304);
INSERT INTO dhg.slashdot_comments (comments) VALUES (423);
INSERT INTO dhg.slashdot_comments (comments) VALUES (102);
INSERT INTO dhg.slashdot_comments (comments) VALUES (109);
INSERT INTO dhg.slashdot_comments (comments) VALUES (93);
INSERT INTO dhg.slashdot_comments (comments) VALUES (143);
INSERT INTO dhg.slashdot_comments (comments) VALUES (496);
INSERT INTO dhg.slashdot_comments (comments) VALUES (66);
INSERT INTO dhg.slashdot_comments (comments) VALUES (95);
INSERT INTO dhg.slashdot_comments (comments) VALUES (553);
INSERT INTO dhg.slashdot_comments (comments) VALUES (106);
INSERT INTO dhg.slashdot_comments (comments) VALUES (372);
INSERT INTO dhg.slashdot_comments (comments) VALUES (307);
INSERT INTO dhg.slashdot_comments (comments) VALUES (131);
INSERT INTO dhg.slashdot_comments (comments) VALUES (111);

DELETE FROM dhg.source;
INSERT INTO dhg.source SELECT * FROM dhg.slashdot_comments;