Skip to content

Instantly share code, notes, and snippets.

@pritchie
Forked from francois/gist:1712533
Created February 3, 2012 01:49
Show Gist options
  • Save pritchie/1727138 to your computer and use it in GitHub Desktop.
Save pritchie/1727138 to your computer and use it in GitHub Desktop.
SQL to create the events table for the SQL Workshop on February 2nd
CREATE TEMPORARY TABLE events(
step text primary key
, start_at timestamp without time zone not null
);
INSERT INTO events VALUES
('Startup', '2011-10-01 02:00:00')
, ('Find Unique Personas', '2011-10-01 02:01:13')
, ('Calculate Loyalty', '2011-10-01 02:01:41')
, ('Calculate Social Impressions', '2011-10-01 02:02:38')
, ('Calculate Feedback', '2011-10-01 02:03:09')
, ('ANALYZE', '2011-10-01 02:09:27');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment