1 | -- |
---|
2 | -- PostgreSQL database dump |
---|
3 | -- |
---|
4 | |
---|
5 | SET client_encoding = 'LATIN1'; |
---|
6 | SET standard_conforming_strings = off; |
---|
7 | SET check_function_bodies = false; |
---|
8 | SET client_min_messages = warning; |
---|
9 | SET escape_string_warning = off; |
---|
10 | |
---|
11 | SET search_path = public, pg_catalog; |
---|
12 | |
---|
13 | SET default_tablespace = ''; |
---|
14 | |
---|
15 | SET default_with_oids = true; |
---|
16 | |
---|
17 | -- |
---|
18 | -- Name: path_dest; Type: TABLE; Schema: public; Owner: transport; Tablespace: |
---|
19 | -- |
---|
20 | |
---|
21 | CREATE TABLE path_dest ( |
---|
22 | job integer, |
---|
23 | pu boolean, |
---|
24 | suburb character varying, |
---|
25 | city character varying, |
---|
26 | "time" timestamp without time zone, |
---|
27 | time_bound timestamp without time zone, |
---|
28 | dist real, |
---|
29 | priority double precision, |
---|
30 | seq integer NOT NULL, |
---|
31 | job_type character(1), |
---|
32 | load_pcnt real |
---|
33 | ); |
---|
34 | |
---|
35 | |
---|
36 | ALTER TABLE public.path_dest OWNER TO transport; |
---|
37 | |
---|
38 | -- |
---|
39 | -- Name: path_links; Type: TABLE; Schema: public; Owner: transport; Tablespace: |
---|
40 | -- |
---|
41 | |
---|
42 | CREATE TABLE path_links ( |
---|
43 | prev_dest integer NOT NULL, |
---|
44 | next_dest integer NOT NULL, |
---|
45 | dist real, |
---|
46 | time_int interval, |
---|
47 | active boolean, |
---|
48 | priority double precision |
---|
49 | ); |
---|
50 | |
---|
51 | |
---|
52 | ALTER TABLE public.path_links OWNER TO transport; |
---|
53 | |
---|
54 | -- |
---|
55 | -- Name: debug_table; Type: TABLE; Schema: public; Owner: transport; Tablespace: |
---|
56 | -- |
---|
57 | |
---|
58 | CREATE TABLE debug_table ( |
---|
59 | msg character varying, |
---|
60 | number bigint |
---|
61 | ); |
---|
62 | |
---|
63 | |
---|
64 | ALTER TABLE public.debug_table OWNER TO transport; |
---|
65 | |
---|
66 | -- |
---|
67 | -- Name: path_job; Type: TABLE; Schema: public; Owner: transport; Tablespace: |
---|
68 | -- |
---|
69 | |
---|
70 | CREATE TABLE path_job ( |
---|
71 | job integer NOT NULL, |
---|
72 | load_pcnt real, |
---|
73 | direct_dist real, |
---|
74 | priority double precision, |
---|
75 | time_int interval, |
---|
76 | job_type character varying(1) |
---|
77 | ); |
---|
78 | |
---|
79 | |
---|
80 | ALTER TABLE public.path_job OWNER TO transport; |
---|
81 | |
---|
82 | -- |
---|
83 | -- Data for Name: debug_table; Type: TABLE DATA; Schema: public; Owner: transport |
---|
84 | -- |
---|
85 | |
---|
86 | INSERT INTO debug_table (msg, number) VALUES ('^^^ Dist too long: number of option_costs = 14', 2); |
---|
87 | INSERT INTO debug_table (msg, number) VALUES ('--- In Move wout Gridlock, Chosen IS option prev=4,next=5,dest=3,priority=6.0,cost=5.0,non_dist inconsistencies=2, inconsistencies=2.57692,total_dist=150.0,inconsistent_priority=13.461538434', 4); |
---|
88 | INSERT INTO debug_table (msg, number) VALUES ('^^^ Dist too long: number of option_costs = 16', 5); |
---|
89 | INSERT INTO debug_table (msg, number) VALUES ('--- In Move wout Gridlock, Chosen IS option prev=3,next=5,dest=11,priority=6.0,cost=5.0,non_dist inconsistencies=3, inconsistencies=3.57308,total_dist=149.0,inconsistent_priority=16.4384614229', 7); |
---|
90 | INSERT INTO debug_table (msg, number) VALUES ('^^^ Dist too long: number of option_costs = 18', 8); |
---|
91 | INSERT INTO debug_table (msg, number) VALUES ('--- In Move wout Gridlock, Chosen IS option prev=2,next=4,dest=10,priority=6.0,cost=5.0,non_dist inconsistencies=3, inconsistencies=3.0,total_dist=125.0,inconsistent_priority=13.0', 10); |
---|
92 | INSERT INTO debug_table (msg, number) VALUES ('Vehicle overloaded, prev=5,next=6,dest=3,priority=5.0, detect = 4', 11); |
---|
93 | INSERT INTO debug_table (msg, number) VALUES (' *** Re-apply best gridlock escape found!!! : best dist = 131.0,time=03:40:00,inconcist=4.50385,consist=3,inconsist pr=19.0230770111,consist pr=9.0, best option = 3 ', 12); |
---|
94 | INSERT INTO debug_table (msg, number) VALUES ('Gridlock: update path_links set priority = 6.000000 where prev/dest in (4/11,3/6,5/3)', 13); |
---|
95 | INSERT INTO debug_table (msg, number) VALUES ('update path_links set priority = 5.000000 where ( prev_dest = 3 and next_dest = 11) or (prev_dest = 4 and next_dest = 3) or (prev_dest = 5 and next_dest = 6)', 14); |
---|
96 | INSERT INTO debug_table (msg, number) VALUES ('** Gridlock: Increased priority of seq=3 to 5.000000', 15); |
---|
97 | INSERT INTO debug_table (msg, number) VALUES ('^^^ Dist too long: number of option_costs = 18', 16); |
---|
98 | INSERT INTO debug_table (msg, number) VALUES ('--- In Move wout Gridlock, Chosen IS option prev=10,next=4,dest=3,priority=6.0,cost=5.0,non_dist inconsistencies=2, inconsistencies=2.0,total_dist=130.0,inconsistent_priority=9.0', 18); |
---|
99 | INSERT INTO debug_table (msg, number) VALUES ('Vehicle overloaded, prev=11,next=5,dest=4,priority=6.0, detect = 4', 19); |
---|
100 | INSERT INTO debug_table (msg, number) VALUES ('--- In Move wout Gridlock, Chosen IS option prev=11,next=5,dest=4,priority=6.0,cost=4.0,non_dist inconsistencies=0, inconsistencies=0.515385,total_dist=134.0,inconsistent_priority=3.09230768681', 20); |
---|
101 | INSERT INTO debug_table (msg, number) VALUES ('^^^ Dist too long: number of option_costs = 14', 21); |
---|
102 | INSERT INTO debug_table (msg, number) VALUES (' *** Re-apply best gridlock escape found!!! : best dist = 124.0,time=03:10:00,inconcist=0.0,consist=8,inconsist pr=0.0,consist pr=32.0, best option = 11 ', 23); |
---|
103 | INSERT INTO debug_table (msg, number) VALUES ('Gridlock: update path_links set priority = 7.000000 where prev/dest in (3/4,10/11,11/3)', 24); |
---|
104 | INSERT INTO debug_table (msg, number) VALUES ('update path_links set priority = 6.000000 where ( prev_dest = 3 and next_dest = 11) or (prev_dest = 10 and next_dest = 3) or (prev_dest = 11 and next_dest = 4)', 25); |
---|
105 | INSERT INTO debug_table (msg, number) VALUES ('** Gridlock: Increased priority of seq=11 to 6.000000', 26); |
---|
106 | INSERT INTO debug_table (msg, number) VALUES (' ### END of prog, cum exec times: mainloop=00:01:19.370798 apply_changes=00:00:17.319982 ,gridlock_time=00:00:16.520317,non_gridlock_time=00:00:00.000988', 27); |
---|
107 | |
---|
108 | |
---|
109 | -- |
---|
110 | -- Data for Name: path_dest; Type: TABLE DATA; Schema: public; Owner: transport |
---|
111 | -- |
---|
112 | |
---|
113 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (2, true, 'beenleigh', 'brisbane', '2009-02-01 08:30:00', '2009-02-01 08:30:00', 25, 3, 2, 'p', 0.40000001); |
---|
114 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (5, true, 'springwood', 'brisbane', '2009-02-01 08:45:00', '2009-02-01 08:00:00', 35, 3, 10, 'p', 1); |
---|
115 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (5, false, 'murarrie', 'brisbane', '2009-02-01 09:05:00', '2009-02-01 14:00:00', 55, 3, 11, 'p', 1); |
---|
116 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (2, false, 'murarrie', 'brisbane', '2009-02-01 09:15:00', '2009-02-01 10:00:00', 65, 5, 3, 'p', 0.40000001); |
---|
117 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (4, true, 'lytton', 'brisbane', '2009-02-01 09:25:00', '2009-02-01 09:00:00', 70, 6, 4, 'p', 0.69999999); |
---|
118 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (4, false, 'rocklea', 'brisbane', '2009-02-01 10:10:00', '2009-02-01 12:00:00', 89, 3, 5, 'p', 0.69999999); |
---|
119 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (0, NULL, 'redland bay', 'brisbane', '2009-02-01 18:00:00', '2009-02-01 18:00:00', 124, 7, 6, 'e', -5.9604599e-08); |
---|
120 | INSERT INTO path_dest (job, pu, suburb, city, "time", time_bound, dist, priority, seq, job_type, load_pcnt) VALUES (0, NULL, 'redland bay', 'brisbane', '2009-02-01 08:00:00', '2009-02-01 08:00:00', 0, 3, 1, 's', 0); |
---|
121 | |
---|
122 | |
---|
123 | -- |
---|
124 | -- Data for Name: path_job; Type: TABLE DATA; Schema: public; Owner: transport |
---|
125 | -- |
---|
126 | |
---|
127 | INSERT INTO path_job (job, load_pcnt, direct_dist, priority, time_int, job_type) VALUES (2, 0.40000001, 20, 1, '00:30:00', 'p'); |
---|
128 | INSERT INTO path_job (job, load_pcnt, direct_dist, priority, time_int, job_type) VALUES (4, 0.69999999, 25, 1, '00:45:00', 'p'); |
---|
129 | INSERT INTO path_job (job, load_pcnt, direct_dist, priority, time_int, job_type) VALUES (5, 0.60000002, 20, 1, '00:30:00', 'p'); |
---|
130 | |
---|
131 | |
---|
132 | -- |
---|
133 | -- Data for Name: path_links; Type: TABLE DATA; Schema: public; Owner: transport |
---|
134 | -- |
---|
135 | |
---|
136 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (11, 10, 20, '00:20:00', false, 2); |
---|
137 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (2, 6, 18, '00:25:00', false, 2); |
---|
138 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (10, 6, 15, '00:20:00', false, 2); |
---|
139 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (1, 5, 34, '00:41:00', false, 2); |
---|
140 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (4, 6, 39, '00:35:00', false, 2); |
---|
141 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (5, 4, 19, '00:24:00', false, 2); |
---|
142 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (1, 11, 40, '00:55:00', false, 3); |
---|
143 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (1, 3, 32, '00:40:00', false, 3); |
---|
144 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (3, 2, 18, '00:35:00', false, 2); |
---|
145 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (2, 11, 24, '00:27:00', false, 4); |
---|
146 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (4, 2, 23, '00:25:00', false, 4); |
---|
147 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (2, 5, 18, '00:22:00', false, 2); |
---|
148 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (11, 2, 20, '00:25:00', false, 2); |
---|
149 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (5, 10, 30, '00:50:00', false, 5); |
---|
150 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (10, 5, 30, '00:45:00', false, 2); |
---|
151 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (5, 2, 28, '00:30:00', false, 5); |
---|
152 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (11, 6, 35, '00:55:00', false, 4); |
---|
153 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (3, 11, 10, '00:19:00', false, 6); |
---|
154 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (3, 10, 15, '00:25:00', false, 5); |
---|
155 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (2, 3, 20, '00:40:00', false, 6); |
---|
156 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (3, 5, 21, '00:50:00', false, 6); |
---|
157 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (10, 2, 15, '00:20:00', false, 3); |
---|
158 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (1, 10, 30, '00:35:00', false, 6); |
---|
159 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (3, 6, 27, '00:45:00', false, 5); |
---|
160 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (5, 3, 19, '00:45:00', false, 6); |
---|
161 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (5, 11, 25, '00:40:00', false, 4); |
---|
162 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (5, 6, 35, '01:00:00', true, 4); |
---|
163 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (1, 4, 29, '00:55:00', false, 5); |
---|
164 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (1, 2, 25, '00:30:00', true, 4); |
---|
165 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (4, 10, 15, '00:15:00', false, 2); |
---|
166 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (2, 4, 24, '00:30:00', false, 4); |
---|
167 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (2, 10, 10, '00:15:00', true, 4); |
---|
168 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (4, 3, 5, '00:10:00', false, 4); |
---|
169 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (10, 4, 10, '00:25:00', false, 5); |
---|
170 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (11, 5, 30, '00:45:00', false, 6); |
---|
171 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (4, 11, 10, '00:15:00', false, 2); |
---|
172 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (4, 5, 19, '00:45:00', true, 3); |
---|
173 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (11, 4, 20, '00:15:00', false, 5); |
---|
174 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (3, 4, 5, '00:10:00', true, 3); |
---|
175 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (10, 11, 20, '00:20:00', true, 6); |
---|
176 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (11, 3, 10, '00:10:00', true, 6); |
---|
177 | INSERT INTO path_links (prev_dest, next_dest, dist, time_int, active, priority) VALUES (10, 3, 15, '00:20:00', false, 7); |
---|
178 | |
---|
179 | |
---|
180 | -- |
---|
181 | -- Name: path_job_pkey; Type: CONSTRAINT; Schema: public; Owner: transport; Tablespace: |
---|
182 | -- |
---|
183 | |
---|
184 | ALTER TABLE ONLY path_job |
---|
185 | ADD CONSTRAINT path_job_pkey PRIMARY KEY (job); |
---|
186 | |
---|
187 | |
---|
188 | -- |
---|
189 | -- Name: path_links_pkey; Type: CONSTRAINT; Schema: public; Owner: transport; Tablespace: |
---|
190 | -- |
---|
191 | |
---|
192 | ALTER TABLE ONLY path_links |
---|
193 | ADD CONSTRAINT path_links_pkey PRIMARY KEY (prev_dest, next_dest); |
---|
194 | |
---|
195 | |
---|
196 | -- |
---|
197 | -- Name: path_tab_pkey; Type: CONSTRAINT; Schema: public; Owner: transport; Tablespace: |
---|
198 | -- |
---|
199 | |
---|
200 | ALTER TABLE ONLY path_dest |
---|
201 | ADD CONSTRAINT path_tab_pkey PRIMARY KEY (seq); |
---|
202 | |
---|
203 | |
---|
204 | -- |
---|
205 | -- Name: path_jindx; Type: INDEX; Schema: public; Owner: transport; Tablespace: |
---|
206 | -- |
---|
207 | |
---|
208 | CREATE INDEX path_jindx ON path_dest USING btree (job); |
---|
209 | |
---|
210 | |
---|
211 | -- |
---|
212 | -- PostgreSQL database dump complete |
---|
213 | -- |
---|
214 | |
---|