|
TestData
Sample data for testing the application.
/* 1199750400 == Tue Jan 08 00:00:00 GMT 2008 */ INSERT INTO lists (scheduled_dt, value) VALUES (FROM_UNIXTIME(1199750400), 'You know there''s a writers strike when ...'); CREATE TABLE submissions_1 LIKE submissions_template; CREATE TABLE votes_1 LIKE votes_template; INSERT INTO submissions_1 (list_id, create_dt, facebook_uin, value) VALUES (1, '2008-01-07 13:14:15', 4, 'Jay Leno''s jokes are even less funny than usual'); INSERT INTO submissions_1 (list_id, create_dt, facebook_uin, value) VALUES (1, '2008-01-07 12:13:14', 504598293, 'Starbucks has even more grungy people hanging out on laptops'); INSERT INTO submissions_1 (list_id, create_dt, facebook_uin, value) VALUES (1, '2008-01-07 04:05:06', 5409797, 'Action films don''t have snappy one liners we know and love'); INSERT INTO submissions_1 (list_id, create_dt, facebook_uin, value) VALUES (1, '2008-01-07 04:05:06', 527224093, 'Rambo IV comes out'); INSERT INTO submissions_1 (list_id, create_dt, facebook_uin, value) VALUES (1, '2008-01-07 04:05:06', 501869468, 'Hollywood agents starting pestering you to have lunch with them'); /* 1199836800 == Wed Jan 09 00:00:00 GMT 2008 */ INSERT INTO lists (scheduled_dt, value) VALUES (FROM_UNIXTIME(1199836800), 'You know Hilary Clinton is going to win the election when ...'); CREATE TABLE submissions_2 LIKE submissions_template; CREATE TABLE votes_2 LIKE votes_template; INSERT INTO submissions_2 (list_id, create_dt, facebook_uin, value) VALUES (2, '2008-01-08 16:15:14', 501869468, 'Nancy Pelosi, and Hilary start having pajama parties for fundraising'); INSERT INTO submissions_2 (list_id, create_dt, facebook_uin, value) VALUES (2, '2008-01-08 19:18:17', 527224093, 'Chelsea Clinton undergoes Extreme-Makeover reality show'); INSERT INTO submissions_2 (list_id, create_dt, facebook_uin, value) VALUES (2, '2008-01-08 20:21:22', 34805778, 'Soccer moms start burning their bras'); |
Sign in to add a comment