Add example data

Tragically, I'm on an airplane so the examples are all my talks since I can
remember what those are called (and mdk's, since he's sat next to me ...).

diff --git a/share/sql/example-data-1.0.sql b/share/sql/example-data-1.0.sql
new file mode 100644 (file)
index 0000000..909d18d
--- /dev/null
+++ b/share/sql/example-data-1.0.sql
@@ -0,0 +1,39 @@
+INSERT INTO buckets (slug, name) VALUES (
+  'lpw2009', 'London Perl Workshop 2009'
+);
+INSERT INTO buckets (slug, name) VALUES (
+  'opw2010', 'Perl Oasis 2010'
+);
+
+INSERT INTO announcements (id, made_at, bucket_slug) VALUES (
+  1, '2009-12-25 09:00:00', 'lpw2009'
+);
+INSERT INTO announcements (id, made_at, bucket_slug) VALUES (
+  2, '2010-01-01 14:00:00', 'lpw2009',
+);
+INSERT INTO announcements (id, made_at, bucket_slug) VALUES (
+  3, '2010-01-21 01:00:00', 'opw2010'
+);
+
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'BEGIN', 'lpw2009', 'BEGINning Perl', 'Matt S Trout (mst)', 1
+);
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'dream', 'lpw2009', 'Dreamcasting', 'Matt S Trout (mst)', 2
+);
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'troll-god-mountain', 'opw2010', 'The Troll, the God and the Mountain',
+   'Matt S Trout (mst)', 3
+);
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'keynote', 'opw2010', 'The Most Disgusting Word You''ll Hear'
+  'Mark Keating (mdk)', 4
+);