Patrick Ritchie pritchie
pritchie
/ gist:1727138
Created
February 3, 2012 01:49
— forked from francois/gist:1712533
SQL to create the events table for the SQL Workshop on February 2nd
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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') |