structure.sql in landable-1.11.1

- old
+ new

@@ -372,10 +372,11 @@
     status_code smallint DEFAULT 200 NOT NULL,
     abstract text,
     hero_asset_id uuid,
     deleted_at timestamp without time zone,
     audit_flags character varying(255)[] DEFAULT '{}'::character varying[],
+    page_name character varying(255),
     CONSTRAINT only_valid_paths CHECK ((path ~ '^/[a-zA-Z0-9/_.~-]*$'::text))
 );
 
 
 --
@@ -1369,12 +1370,12 @@
     agg1."average response time (ms)"
    FROM ( SELECT p.path_id,
             p.path,
             round(avg(pv.response_time), 3) AS "average response time (ms)"
            FROM (page_views pv
-             JOIN paths p ON ((p.path_id = pv.path_id)))
-          GROUP BY p.path_id, p.path) agg1
+      JOIN paths p ON ((p.path_id = pv.path_id)))
+     GROUP BY p.path_id, p.path) agg1
   ORDER BY agg1."average response time (ms)" DESC;
 
 
 --
 -- Name: VIEW path_response_time__by_time; Type: COMMENT; Schema: dummy_landable_traffic; Owner: -
@@ -3952,6 +3953,8 @@
 INSERT INTO schema_migrations (version) VALUES ('20140515164543');
 
 INSERT INTO schema_migrations (version) VALUES ('20140522202332');
 
 INSERT INTO schema_migrations (version) VALUES ('20140602213937');
+
+INSERT INTO schema_migrations (version) VALUES ('20141211200012');
 