spec/dummy/db/structure.sql in landable-1.9.1 vs spec/dummy/db/structure.sql in landable-1.9.2

- old
+ new

@@ -1,10 +1,11 @@ -- -- PostgreSQL database dump -- SET statement_timeout = 0; +SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; @@ -1361,11 +1362,20 @@ -- -- Name: path_response_time__by_time; Type: VIEW; Schema: dummy_landable_traffic; Owner: - -- CREATE VIEW path_response_time__by_time AS - SELECT agg1.path_id, agg1.path, 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 ORDER BY agg1."average response time (ms)" DESC; + SELECT agg1.path_id, + agg1.path, + 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 + ORDER BY agg1."average response time (ms)" DESC; -- -- Name: VIEW path_response_time__by_time; Type: COMMENT; Schema: dummy_landable_traffic; Owner: - -- @@ -3881,11 +3891,11 @@ -- -- PostgreSQL database dump complete -- -SET search_path TO "$user",public; +SET search_path TO "$user", public; INSERT INTO schema_migrations (version) VALUES ('20130510221424'); INSERT INTO schema_migrations (version) VALUES ('20130909182713'); @@ -3942,5 +3952,6 @@ INSERT INTO schema_migrations (version) VALUES ('20140515164543'); INSERT INTO schema_migrations (version) VALUES ('20140522202332'); INSERT INTO schema_migrations (version) VALUES ('20140602213937'); +