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');
+