Merge lp:~allenap/maas/initial-test-data-2017-03-23 into lp:~maas-committers/maas/trunk
- initial-test-data-2017-03-23
- Merge into trunk
Status: | Merged |
---|---|
Approved by: | Gavin Panella |
Approved revision: | no longer in the source branch. |
Merged at revision: | 5855 |
Proposed branch: | lp:~allenap/maas/initial-test-data-2017-03-23 |
Merge into: | lp:~maas-committers/maas/trunk |
Diff against target: |
4068 lines (+1622/-1458) 1 file modified
src/maasserver/testing/initial.maas_test.sql (+1622/-1458) |
To merge this branch: | bzr merge lp:~allenap/maas/initial-test-data-2017-03-23 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Gavin Panella (community) | Approve | ||
Review via email: mp+320871@code.launchpad.net |
Commit message
Update initial test data.
Description of the change
MAAS Lander (maas-lander) wrote : | # |
The attempt to merge lp:~allenap/maas/initial-test-data-2017-03-23 into lp:maas failed. Below is the output from the failed tests.
Hit:1 http://
Get:2 http://
Get:3 http://
Get:4 http://
Fetched 306 kB in 0s (638 kB/s)
Reading package lists...
sudo DEBIAN_
--no-
Reading package lists...
Building dependency tree...
Reading state information...
authbind is already the newest version (2.1.1+nmu1).
avahi-utils is already the newest version (0.6.32~
build-essential is already the newest version (12.1ubuntu2).
debhelper is already the newest version (9.20160115ubun
distro-info is already the newest version (0.14build1).
git is already the newest version (1:2.7.4-0ubuntu1).
libjs-angularjs is already the newest version (1.2.28-1ubuntu2).
libjs-jquery is already the newest version (1.11.3+dfsg-4).
libjs-yui3-full is already the newest version (3.5.1-1ubuntu3).
libjs-yui3-min is already the newest version (3.5.1-1ubuntu3).
make is already the newest version (4.1-6).
postgresql is already the newest version (9.5+173).
psmisc is already the newest version (22.21-2.1build1).
pxelinux is already the newest version (3:6.03+
python-formencode is already the newest version (1.3.0-0ubuntu5).
python-lxml is already the newest version (3.5.0-1build1).
python-netaddr is already the newest version (0.7.18-1).
pytho...
Gavin Panella (allenap) wrote : | # |
The spurious test failure has been filed as bug 1675823.
Preview Diff
1 | === modified file 'src/maasserver/testing/initial.maas_test.sql' |
2 | --- src/maasserver/testing/initial.maas_test.sql 2017-01-10 18:31:26 +0000 |
3 | +++ src/maasserver/testing/initial.maas_test.sql 2017-03-23 20:59:52 +0000 |
4 | @@ -2,8 +2,8 @@ |
5 | -- PostgreSQL database dump |
6 | -- |
7 | |
8 | --- Dumped from database version 9.5.5 |
9 | --- Dumped by pg_dump version 9.5.5 |
10 | +-- Dumped from database version 9.5.6 |
11 | +-- Dumped by pg_dump version 9.5.6 |
12 | |
13 | SET statement_timeout = 0; |
14 | SET lock_timeout = 0; |
15 | @@ -1950,6 +1950,79 @@ |
16 | |
17 | |
18 | -- |
19 | +-- Name: node_pod_delete_notify(); Type: FUNCTION; Schema: public; Owner: - |
20 | +-- |
21 | + |
22 | +CREATE FUNCTION node_pod_delete_notify() RETURNS trigger |
23 | + LANGUAGE plpgsql |
24 | + AS $$ |
25 | +DECLARE |
26 | + bmc RECORD; |
27 | +BEGIN |
28 | + IF OLD.bmc_id IS NOT NULL THEN |
29 | + SELECT * INTO bmc FROM maasserver_bmc WHERE id = OLD.bmc_id; |
30 | + IF bmc.bmc_type = 1 THEN |
31 | + PERFORM pg_notify('pod_update',CAST(OLD.bmc_id AS text)); |
32 | + END IF; |
33 | + END IF; |
34 | + RETURN OLD; |
35 | +END; |
36 | +$$; |
37 | + |
38 | + |
39 | +-- |
40 | +-- Name: node_pod_insert_notify(); Type: FUNCTION; Schema: public; Owner: - |
41 | +-- |
42 | + |
43 | +CREATE FUNCTION node_pod_insert_notify() RETURNS trigger |
44 | + LANGUAGE plpgsql |
45 | + AS $$ |
46 | +DECLARE |
47 | + bmc RECORD; |
48 | +BEGIN |
49 | + IF NEW.bmc_id IS NOT NULL THEN |
50 | + SELECT * INTO bmc FROM maasserver_bmc WHERE id = NEW.bmc_id; |
51 | + IF bmc.bmc_type = 1 THEN |
52 | + PERFORM pg_notify('pod_update',CAST(NEW.bmc_id AS text)); |
53 | + END IF; |
54 | + END IF; |
55 | + RETURN NEW; |
56 | +END; |
57 | +$$; |
58 | + |
59 | + |
60 | +-- |
61 | +-- Name: node_pod_update_notify(); Type: FUNCTION; Schema: public; Owner: - |
62 | +-- |
63 | + |
64 | +CREATE FUNCTION node_pod_update_notify() RETURNS trigger |
65 | + LANGUAGE plpgsql |
66 | + AS $$ |
67 | +DECLARE |
68 | + bmc RECORD; |
69 | +BEGIN |
70 | + IF ((OLD.bmc_id IS NULL and NEW.bmc_id IS NOT NULL) OR |
71 | + (OLD.bmc_id IS NOT NULL and NEW.bmc_id IS NULL) OR |
72 | + OLD.bmc_id != NEW.bmc_id) THEN |
73 | + IF OLD.bmc_id IS NOT NULL THEN |
74 | + SELECT * INTO bmc FROM maasserver_bmc WHERE id = OLD.bmc_id; |
75 | + IF bmc.bmc_type = 1 THEN |
76 | + PERFORM pg_notify('pod_update',CAST(OLD.bmc_id AS text)); |
77 | + END IF; |
78 | + END IF; |
79 | + END IF; |
80 | + IF NEW.bmc_id IS NOT NULL THEN |
81 | + SELECT * INTO bmc FROM maasserver_bmc WHERE id = NEW.bmc_id; |
82 | + IF bmc.bmc_type = 1 THEN |
83 | + PERFORM pg_notify('pod_update',CAST(NEW.bmc_id AS text)); |
84 | + END IF; |
85 | + END IF; |
86 | + RETURN NEW; |
87 | +END; |
88 | +$$; |
89 | + |
90 | + |
91 | +-- |
92 | -- Name: node_type_change_notify(); Type: FUNCTION; Schema: public; Owner: - |
93 | -- |
94 | |
95 | @@ -1983,8 +2056,6 @@ |
96 | WHEN 4 THEN |
97 | PERFORM pg_notify('controller_delete',CAST( |
98 | OLD.system_id AS TEXT)); |
99 | - WHEN 5 THEN |
100 | - -- Do nothing. |
101 | END CASE; |
102 | CASE NEW.node_type |
103 | WHEN 0 THEN |
104 | @@ -2002,8 +2073,6 @@ |
105 | WHEN 4 THEN |
106 | PERFORM pg_notify('controller_create',CAST( |
107 | NEW.system_id AS TEXT)); |
108 | - WHEN 5 THEN |
109 | - -- Do nothing. |
110 | END CASE; |
111 | END IF; |
112 | RETURN NEW; |
113 | @@ -2012,6 +2081,68 @@ |
114 | |
115 | |
116 | -- |
117 | +-- Name: notification_create_notify(); Type: FUNCTION; Schema: public; Owner: - |
118 | +-- |
119 | + |
120 | +CREATE FUNCTION notification_create_notify() RETURNS trigger |
121 | + LANGUAGE plpgsql |
122 | + AS $$ |
123 | +DECLARE |
124 | +BEGIN |
125 | + PERFORM pg_notify('notification_create',CAST(NEW.id AS text)); |
126 | + RETURN NEW; |
127 | +END; |
128 | +$$; |
129 | + |
130 | + |
131 | +-- |
132 | +-- Name: notification_delete_notify(); Type: FUNCTION; Schema: public; Owner: - |
133 | +-- |
134 | + |
135 | +CREATE FUNCTION notification_delete_notify() RETURNS trigger |
136 | + LANGUAGE plpgsql |
137 | + AS $$ |
138 | +DECLARE |
139 | +BEGIN |
140 | + PERFORM pg_notify('notification_delete',CAST(OLD.id AS text)); |
141 | + RETURN NEW; |
142 | +END; |
143 | +$$; |
144 | + |
145 | + |
146 | +-- |
147 | +-- Name: notification_update_notify(); Type: FUNCTION; Schema: public; Owner: - |
148 | +-- |
149 | + |
150 | +CREATE FUNCTION notification_update_notify() RETURNS trigger |
151 | + LANGUAGE plpgsql |
152 | + AS $$ |
153 | +DECLARE |
154 | +BEGIN |
155 | + PERFORM pg_notify('notification_update',CAST(NEW.id AS text)); |
156 | + RETURN NEW; |
157 | +END; |
158 | +$$; |
159 | + |
160 | + |
161 | +-- |
162 | +-- Name: notificationdismissal_create_notify(); Type: FUNCTION; Schema: public; Owner: - |
163 | +-- |
164 | + |
165 | +CREATE FUNCTION notificationdismissal_create_notify() RETURNS trigger |
166 | + LANGUAGE plpgsql |
167 | + AS $$ |
168 | +DECLARE |
169 | +BEGIN |
170 | + PERFORM pg_notify( |
171 | + 'notificationdismissal_create', CAST(NEW.notification_id AS text) || ':' || |
172 | + CAST(NEW.user_id AS text)); |
173 | + RETURN NEW; |
174 | +END; |
175 | +$$; |
176 | + |
177 | + |
178 | +-- |
179 | -- Name: packagerepository_create_notify(); Type: FUNCTION; Schema: public; Owner: - |
180 | -- |
181 | |
182 | @@ -2057,6 +2188,60 @@ |
183 | |
184 | |
185 | -- |
186 | +-- Name: pod_delete_notify(); Type: FUNCTION; Schema: public; Owner: - |
187 | +-- |
188 | + |
189 | +CREATE FUNCTION pod_delete_notify() RETURNS trigger |
190 | + LANGUAGE plpgsql |
191 | + AS $$ |
192 | +BEGIN |
193 | + IF OLD.bmc_type = 1 THEN |
194 | + PERFORM pg_notify('pod_delete',CAST(OLD.id AS text)); |
195 | + END IF; |
196 | + RETURN OLD; |
197 | +END; |
198 | +$$; |
199 | + |
200 | + |
201 | +-- |
202 | +-- Name: pod_insert_notify(); Type: FUNCTION; Schema: public; Owner: - |
203 | +-- |
204 | + |
205 | +CREATE FUNCTION pod_insert_notify() RETURNS trigger |
206 | + LANGUAGE plpgsql |
207 | + AS $$ |
208 | +BEGIN |
209 | + IF NEW.bmc_type = 1 THEN |
210 | + PERFORM pg_notify('pod_create',CAST(NEW.id AS text)); |
211 | + END IF; |
212 | + RETURN NEW; |
213 | +END; |
214 | +$$; |
215 | + |
216 | + |
217 | +-- |
218 | +-- Name: pod_update_notify(); Type: FUNCTION; Schema: public; Owner: - |
219 | +-- |
220 | + |
221 | +CREATE FUNCTION pod_update_notify() RETURNS trigger |
222 | + LANGUAGE plpgsql |
223 | + AS $$ |
224 | +BEGIN |
225 | + IF OLD.bmc_type = NEW.bmc_type THEN |
226 | + IF OLD.bmc_type = 1 THEN |
227 | + PERFORM pg_notify('pod_update',CAST(OLD.id AS text)); |
228 | + END IF; |
229 | + ELSIF OLD.bmc_type = 0 AND NEW.bmc_type = 1 THEN |
230 | + PERFORM pg_notify('pod_create',CAST(NEW.id AS text)); |
231 | + ELSIF OLD.bmc_type = 1 AND NEW.bmc_type = 0 THEN |
232 | + PERFORM pg_notify('pod_delete',CAST(OLD.id AS text)); |
233 | + END IF; |
234 | + RETURN NEW; |
235 | +END; |
236 | +$$; |
237 | + |
238 | + |
239 | +-- |
240 | -- Name: rack_controller_create_notify(); Type: FUNCTION; Schema: public; Owner: - |
241 | -- |
242 | |
243 | @@ -2639,10 +2824,10 @@ |
244 | previous_status integer NOT NULL, |
245 | default_user character varying(32) NOT NULL, |
246 | cpu_speed integer NOT NULL, |
247 | - dynamic boolean NOT NULL, |
248 | current_commissioning_script_set_id integer, |
249 | current_installation_script_set_id integer, |
250 | current_testing_script_set_id integer, |
251 | + creation_type integer NOT NULL, |
252 | CONSTRAINT maasserver_node_address_ttl_check CHECK ((address_ttl >= 0)) |
253 | ); |
254 | |
255 | @@ -4725,7 +4910,7 @@ |
256 | created timestamp with time zone NOT NULL, |
257 | updated timestamp with time zone NOT NULL, |
258 | url character varying(200) NOT NULL, |
259 | - keyring_filename character varying(100) NOT NULL, |
260 | + keyring_filename character varying(4096) NOT NULL, |
261 | keyring_data bytea NOT NULL |
262 | ); |
263 | |
264 | @@ -4837,40 +5022,25 @@ |
265 | |
266 | |
267 | -- |
268 | --- Name: maasserver_licensekey; Type: TABLE; Schema: public; Owner: - |
269 | --- |
270 | - |
271 | -CREATE TABLE maasserver_licensekey ( |
272 | - id integer NOT NULL, |
273 | - created timestamp with time zone NOT NULL, |
274 | - updated timestamp with time zone NOT NULL, |
275 | - osystem character varying(255) NOT NULL, |
276 | - distro_series character varying(255) NOT NULL, |
277 | - license_key character varying(255) NOT NULL |
278 | -); |
279 | - |
280 | - |
281 | --- |
282 | --- Name: maas_support__license_keys_present__excluding_key_material; Type: VIEW; Schema: public; Owner: - |
283 | --- |
284 | - |
285 | -CREATE VIEW maas_support__license_keys_present__excluding_key_material AS |
286 | - SELECT maasserver_licensekey.osystem, |
287 | - maasserver_licensekey.distro_series |
288 | - FROM maasserver_licensekey; |
289 | - |
290 | - |
291 | --- |
292 | --- Name: maasserver_fabric; Type: TABLE; Schema: public; Owner: - |
293 | --- |
294 | - |
295 | -CREATE TABLE maasserver_fabric ( |
296 | - id integer NOT NULL, |
297 | - created timestamp with time zone NOT NULL, |
298 | - updated timestamp with time zone NOT NULL, |
299 | - name character varying(256), |
300 | - class_type character varying(256), |
301 | - description text NOT NULL |
302 | +-- Name: maasserver_bmc; Type: TABLE; Schema: public; Owner: - |
303 | +-- |
304 | + |
305 | +CREATE TABLE maasserver_bmc ( |
306 | + id integer NOT NULL, |
307 | + created timestamp with time zone NOT NULL, |
308 | + updated timestamp with time zone NOT NULL, |
309 | + power_type character varying(10) NOT NULL, |
310 | + power_parameters text NOT NULL, |
311 | + ip_address_id integer, |
312 | + architectures text[], |
313 | + bmc_type integer NOT NULL, |
314 | + capabilities text[], |
315 | + cores integer NOT NULL, |
316 | + cpu_speed integer NOT NULL, |
317 | + local_disks integer NOT NULL, |
318 | + local_storage bigint NOT NULL, |
319 | + memory integer NOT NULL, |
320 | + name character varying(255) NOT NULL |
321 | ); |
322 | |
323 | |
324 | @@ -4947,6 +5117,74 @@ |
325 | |
326 | |
327 | -- |
328 | +-- Name: maas_support__ip_allocation; Type: VIEW; Schema: public; Owner: - |
329 | +-- |
330 | + |
331 | +CREATE VIEW maas_support__ip_allocation AS |
332 | + SELECT sip.ip, |
333 | + CASE |
334 | + WHEN (sip.alloc_type = 0) THEN 'AUTO'::bpchar |
335 | + WHEN (sip.alloc_type = 1) THEN 'STICKY'::bpchar |
336 | + WHEN (sip.alloc_type = 4) THEN 'USER_RESERVED'::bpchar |
337 | + WHEN (sip.alloc_type = 5) THEN 'DHCP'::bpchar |
338 | + WHEN (sip.alloc_type = 6) THEN 'DISCOVERED'::bpchar |
339 | + ELSE (sip.alloc_type)::character(1) |
340 | + END AS alloc_type, |
341 | + subnet.cidr, |
342 | + node.hostname, |
343 | + iface.id AS ifid, |
344 | + iface.name AS ifname, |
345 | + iface.type AS iftype, |
346 | + iface.mac_address, |
347 | + bmc.power_type |
348 | + FROM (((((maasserver_staticipaddress sip |
349 | + LEFT JOIN maasserver_subnet subnet ON ((subnet.id = sip.subnet_id))) |
350 | + LEFT JOIN maasserver_interface_ip_addresses ifip ON ((sip.id = ifip.staticipaddress_id))) |
351 | + LEFT JOIN maasserver_interface iface ON ((iface.id = ifip.interface_id))) |
352 | + LEFT JOIN maasserver_node node ON ((iface.node_id = node.id))) |
353 | + LEFT JOIN maasserver_bmc bmc ON ((bmc.ip_address_id = sip.id))) |
354 | + ORDER BY sip.ip; |
355 | + |
356 | + |
357 | +-- |
358 | +-- Name: maasserver_licensekey; Type: TABLE; Schema: public; Owner: - |
359 | +-- |
360 | + |
361 | +CREATE TABLE maasserver_licensekey ( |
362 | + id integer NOT NULL, |
363 | + created timestamp with time zone NOT NULL, |
364 | + updated timestamp with time zone NOT NULL, |
365 | + osystem character varying(255) NOT NULL, |
366 | + distro_series character varying(255) NOT NULL, |
367 | + license_key character varying(255) NOT NULL |
368 | +); |
369 | + |
370 | + |
371 | +-- |
372 | +-- Name: maas_support__license_keys_present__excluding_key_material; Type: VIEW; Schema: public; Owner: - |
373 | +-- |
374 | + |
375 | +CREATE VIEW maas_support__license_keys_present__excluding_key_material AS |
376 | + SELECT maasserver_licensekey.osystem, |
377 | + maasserver_licensekey.distro_series |
378 | + FROM maasserver_licensekey; |
379 | + |
380 | + |
381 | +-- |
382 | +-- Name: maasserver_fabric; Type: TABLE; Schema: public; Owner: - |
383 | +-- |
384 | + |
385 | +CREATE TABLE maasserver_fabric ( |
386 | + id integer NOT NULL, |
387 | + created timestamp with time zone NOT NULL, |
388 | + updated timestamp with time zone NOT NULL, |
389 | + name character varying(256), |
390 | + class_type character varying(256), |
391 | + description text NOT NULL |
392 | +); |
393 | + |
394 | + |
395 | +-- |
396 | -- Name: maas_support__node_networking; Type: VIEW; Schema: public; Owner: - |
397 | -- |
398 | |
399 | @@ -5027,7 +5265,7 @@ |
400 | created timestamp with time zone NOT NULL, |
401 | updated timestamp with time zone NOT NULL, |
402 | name character varying(255) NOT NULL, |
403 | - id_path character varying(100), |
404 | + id_path character varying(4096), |
405 | size bigint NOT NULL, |
406 | block_size integer NOT NULL, |
407 | tags text[], |
408 | @@ -5055,20 +5293,6 @@ |
409 | |
410 | |
411 | -- |
412 | --- Name: maasserver_bmc; Type: TABLE; Schema: public; Owner: - |
413 | --- |
414 | - |
415 | -CREATE TABLE maasserver_bmc ( |
416 | - id integer NOT NULL, |
417 | - created timestamp with time zone NOT NULL, |
418 | - updated timestamp with time zone NOT NULL, |
419 | - power_type character varying(10) NOT NULL, |
420 | - power_parameters text NOT NULL, |
421 | - ip_address_id integer |
422 | -); |
423 | - |
424 | - |
425 | --- |
426 | -- Name: maasserver_bmc_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
427 | -- |
428 | |
429 | @@ -5313,70 +5537,6 @@ |
430 | |
431 | |
432 | -- |
433 | --- Name: maasserver_chassishints; Type: TABLE; Schema: public; Owner: - |
434 | --- |
435 | - |
436 | -CREATE TABLE maasserver_chassishints ( |
437 | - id integer NOT NULL, |
438 | - cores integer NOT NULL, |
439 | - memory integer NOT NULL, |
440 | - local_storage integer NOT NULL, |
441 | - chassis_id integer NOT NULL |
442 | -); |
443 | - |
444 | - |
445 | --- |
446 | --- Name: maasserver_chassishints_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
447 | --- |
448 | - |
449 | -CREATE SEQUENCE maasserver_chassishints_id_seq |
450 | - START WITH 1 |
451 | - INCREMENT BY 1 |
452 | - NO MINVALUE |
453 | - NO MAXVALUE |
454 | - CACHE 1; |
455 | - |
456 | - |
457 | --- |
458 | --- Name: maasserver_chassishints_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
459 | --- |
460 | - |
461 | -ALTER SEQUENCE maasserver_chassishints_id_seq OWNED BY maasserver_chassishints.id; |
462 | - |
463 | - |
464 | --- |
465 | --- Name: maasserver_componenterror; Type: TABLE; Schema: public; Owner: - |
466 | --- |
467 | - |
468 | -CREATE TABLE maasserver_componenterror ( |
469 | - id integer NOT NULL, |
470 | - created timestamp with time zone NOT NULL, |
471 | - updated timestamp with time zone NOT NULL, |
472 | - component character varying(40) NOT NULL, |
473 | - error character varying(1000) NOT NULL |
474 | -); |
475 | - |
476 | - |
477 | --- |
478 | --- Name: maasserver_componenterror_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
479 | --- |
480 | - |
481 | -CREATE SEQUENCE maasserver_componenterror_id_seq |
482 | - START WITH 1 |
483 | - INCREMENT BY 1 |
484 | - NO MINVALUE |
485 | - NO MAXVALUE |
486 | - CACHE 1; |
487 | - |
488 | - |
489 | --- |
490 | --- Name: maasserver_componenterror_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
491 | --- |
492 | - |
493 | -ALTER SEQUENCE maasserver_componenterror_id_seq OWNED BY maasserver_componenterror.id; |
494 | - |
495 | - |
496 | --- |
497 | -- Name: maasserver_config_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
498 | -- |
499 | |
500 | @@ -6222,7 +6382,8 @@ |
501 | admins boolean NOT NULL, |
502 | message text NOT NULL, |
503 | context text NOT NULL, |
504 | - user_id integer |
505 | + user_id integer, |
506 | + category character varying(10) NOT NULL |
507 | ); |
508 | |
509 | |
510 | @@ -6322,7 +6483,8 @@ |
511 | "default" boolean NOT NULL, |
512 | enabled boolean NOT NULL, |
513 | disabled_pockets text[], |
514 | - distributions text[] |
515 | + distributions text[], |
516 | + disabled_components text[] |
517 | ); |
518 | |
519 | |
520 | @@ -6423,6 +6585,39 @@ |
521 | |
522 | |
523 | -- |
524 | +-- Name: maasserver_podhints; Type: TABLE; Schema: public; Owner: - |
525 | +-- |
526 | + |
527 | +CREATE TABLE maasserver_podhints ( |
528 | + id integer NOT NULL, |
529 | + cores integer NOT NULL, |
530 | + memory integer NOT NULL, |
531 | + local_storage bigint NOT NULL, |
532 | + local_disks integer NOT NULL, |
533 | + pod_id integer NOT NULL |
534 | +); |
535 | + |
536 | + |
537 | +-- |
538 | +-- Name: maasserver_podhints_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
539 | +-- |
540 | + |
541 | +CREATE SEQUENCE maasserver_podhints_id_seq |
542 | + START WITH 1 |
543 | + INCREMENT BY 1 |
544 | + NO MINVALUE |
545 | + NO MAXVALUE |
546 | + CACHE 1; |
547 | + |
548 | + |
549 | +-- |
550 | +-- Name: maasserver_podhints_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
551 | +-- |
552 | + |
553 | +ALTER SEQUENCE maasserver_podhints_id_seq OWNED BY maasserver_podhints.id; |
554 | + |
555 | + |
556 | +-- |
557 | -- Name: maasserver_rdns_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
558 | -- |
559 | |
560 | @@ -6957,36 +7152,6 @@ |
561 | |
562 | |
563 | -- |
564 | --- Name: metadataserver_commissioningscript; Type: TABLE; Schema: public; Owner: - |
565 | --- |
566 | - |
567 | -CREATE TABLE metadataserver_commissioningscript ( |
568 | - id integer NOT NULL, |
569 | - name character varying(255) NOT NULL, |
570 | - content text NOT NULL |
571 | -); |
572 | - |
573 | - |
574 | --- |
575 | --- Name: metadataserver_commissioningscript_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
576 | --- |
577 | - |
578 | -CREATE SEQUENCE metadataserver_commissioningscript_id_seq |
579 | - START WITH 1 |
580 | - INCREMENT BY 1 |
581 | - NO MINVALUE |
582 | - NO MAXVALUE |
583 | - CACHE 1; |
584 | - |
585 | - |
586 | --- |
587 | --- Name: metadataserver_commissioningscript_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
588 | --- |
589 | - |
590 | -ALTER SEQUENCE metadataserver_commissioningscript_id_seq OWNED BY metadataserver_commissioningscript.id; |
591 | - |
592 | - |
593 | --- |
594 | -- Name: metadataserver_nodekey; Type: TABLE; Schema: public; Owner: - |
595 | -- |
596 | |
597 | @@ -7062,7 +7227,8 @@ |
598 | timeout interval NOT NULL, |
599 | destructive boolean NOT NULL, |
600 | "default" boolean NOT NULL, |
601 | - script_id integer NOT NULL |
602 | + script_id integer NOT NULL, |
603 | + title character varying(255) NOT NULL |
604 | ); |
605 | |
606 | |
607 | @@ -7101,7 +7267,10 @@ |
608 | result text NOT NULL, |
609 | script_id integer, |
610 | script_set_id integer NOT NULL, |
611 | - script_version_id integer |
612 | + script_version_id integer, |
613 | + output text NOT NULL, |
614 | + ended timestamp with time zone, |
615 | + started timestamp with time zone |
616 | ); |
617 | |
618 | |
619 | @@ -7132,7 +7301,8 @@ |
620 | id integer NOT NULL, |
621 | last_ping timestamp with time zone, |
622 | result_type integer NOT NULL, |
623 | - node_id integer NOT NULL |
624 | + node_id integer NOT NULL, |
625 | + power_state_before_transition character varying(10) NOT NULL |
626 | ); |
627 | |
628 | |
629 | @@ -7395,20 +7565,6 @@ |
630 | -- Name: id; Type: DEFAULT; Schema: public; Owner: - |
631 | -- |
632 | |
633 | -ALTER TABLE ONLY maasserver_chassishints ALTER COLUMN id SET DEFAULT nextval('maasserver_chassishints_id_seq'::regclass); |
634 | - |
635 | - |
636 | --- |
637 | --- Name: id; Type: DEFAULT; Schema: public; Owner: - |
638 | --- |
639 | - |
640 | -ALTER TABLE ONLY maasserver_componenterror ALTER COLUMN id SET DEFAULT nextval('maasserver_componenterror_id_seq'::regclass); |
641 | - |
642 | - |
643 | --- |
644 | --- Name: id; Type: DEFAULT; Schema: public; Owner: - |
645 | --- |
646 | - |
647 | ALTER TABLE ONLY maasserver_config ALTER COLUMN id SET DEFAULT nextval('maasserver_config_id_seq'::regclass); |
648 | |
649 | |
650 | @@ -7633,6 +7789,13 @@ |
651 | -- Name: id; Type: DEFAULT; Schema: public; Owner: - |
652 | -- |
653 | |
654 | +ALTER TABLE ONLY maasserver_podhints ALTER COLUMN id SET DEFAULT nextval('maasserver_podhints_id_seq'::regclass); |
655 | + |
656 | + |
657 | +-- |
658 | +-- Name: id; Type: DEFAULT; Schema: public; Owner: - |
659 | +-- |
660 | + |
661 | ALTER TABLE ONLY maasserver_rdns ALTER COLUMN id SET DEFAULT nextval('maasserver_rdns_id_seq'::regclass); |
662 | |
663 | |
664 | @@ -7752,13 +7915,6 @@ |
665 | -- Name: id; Type: DEFAULT; Schema: public; Owner: - |
666 | -- |
667 | |
668 | -ALTER TABLE ONLY metadataserver_commissioningscript ALTER COLUMN id SET DEFAULT nextval('metadataserver_commissioningscript_id_seq'::regclass); |
669 | - |
670 | - |
671 | --- |
672 | --- Name: id; Type: DEFAULT; Schema: public; Owner: - |
673 | --- |
674 | - |
675 | ALTER TABLE ONLY metadataserver_nodekey ALTER COLUMN id SET DEFAULT nextval('metadataserver_nodekey_id_seq'::regclass); |
676 | |
677 | |
678 | @@ -7885,243 +8041,234 @@ |
679 | 37 Can add Static IP Address 13 add_staticipaddress |
680 | 38 Can change Static IP Address 13 change_staticipaddress |
681 | 39 Can delete Static IP Address 13 delete_staticipaddress |
682 | -40 Can add bmc 14 add_bmc |
683 | -41 Can change bmc 14 change_bmc |
684 | -42 Can delete bmc 14 delete_bmc |
685 | -43 Can add bmc routable rack controller relationship 15 add_bmcroutablerackcontrollerrelationship |
686 | -44 Can change bmc routable rack controller relationship 15 change_bmcroutablerackcontrollerrelationship |
687 | -45 Can delete bmc routable rack controller relationship 15 delete_bmcroutablerackcontrollerrelationship |
688 | -46 Can add boot source 16 add_bootsource |
689 | -47 Can change boot source 16 change_bootsource |
690 | -48 Can delete boot source 16 delete_bootsource |
691 | -49 Can add boot source cache 17 add_bootsourcecache |
692 | -50 Can change boot source cache 17 change_bootsourcecache |
693 | -51 Can delete boot source cache 17 delete_bootsourcecache |
694 | -52 Can add boot resource 18 add_bootresource |
695 | -53 Can change boot resource 18 change_bootresource |
696 | -54 Can delete boot resource 18 delete_bootresource |
697 | -55 Can add boot resource set 19 add_bootresourceset |
698 | -56 Can change boot resource set 19 change_bootresourceset |
699 | -57 Can delete boot resource set 19 delete_bootresourceset |
700 | -58 Can add large file 20 add_largefile |
701 | -59 Can change large file 20 change_largefile |
702 | -60 Can delete large file 20 delete_largefile |
703 | -61 Can add boot resource file 21 add_bootresourcefile |
704 | -62 Can change boot resource file 21 change_bootresourcefile |
705 | -63 Can delete boot resource file 21 delete_bootresourcefile |
706 | -64 Can add boot source selection 22 add_bootsourceselection |
707 | -65 Can change boot source selection 22 change_bootsourceselection |
708 | -66 Can delete boot source selection 22 delete_bootsourceselection |
709 | -67 Can add cache set 23 add_cacheset |
710 | -68 Can change cache set 23 change_cacheset |
711 | -69 Can delete cache set 23 delete_cacheset |
712 | -70 Can add Interface 24 add_interface |
713 | -71 Can change Interface 24 change_interface |
714 | -72 Can delete Interface 24 delete_interface |
715 | -73 Can add interface relationship 25 add_interfacerelationship |
716 | -74 Can change interface relationship 25 change_interfacerelationship |
717 | -75 Can delete interface relationship 25 delete_interfacerelationship |
718 | -76 Can add Physical interface 24 add_physicalinterface |
719 | -77 Can change Physical interface 24 change_physicalinterface |
720 | -78 Can delete Physical interface 24 delete_physicalinterface |
721 | -79 Can add child interface 24 add_childinterface |
722 | -80 Can change child interface 24 change_childinterface |
723 | -81 Can delete child interface 24 delete_childinterface |
724 | -82 Can add Bridge 24 add_bridgeinterface |
725 | -83 Can change Bridge 24 change_bridgeinterface |
726 | -84 Can delete Bridge 24 delete_bridgeinterface |
727 | -85 Can add Bond 24 add_bondinterface |
728 | -86 Can change Bond 24 change_bondinterface |
729 | -87 Can delete Bond 24 delete_bondinterface |
730 | -88 Can add VLAN interface 24 add_vlaninterface |
731 | -89 Can change VLAN interface 24 change_vlaninterface |
732 | -90 Can delete VLAN interface 24 delete_vlaninterface |
733 | -91 Can add Unknown interface 24 add_unknowninterface |
734 | -92 Can change Unknown interface 24 change_unknowninterface |
735 | -93 Can delete Unknown interface 24 delete_unknowninterface |
736 | -94 Can add Fabric 26 add_fabric |
737 | -95 Can change Fabric 26 change_fabric |
738 | -96 Can delete Fabric 26 delete_fabric |
739 | -97 Can add filesystem group 27 add_filesystemgroup |
740 | -98 Can change filesystem group 27 change_filesystemgroup |
741 | -99 Can delete filesystem group 27 delete_filesystemgroup |
742 | -100 Can add volume group 27 add_volumegroup |
743 | -101 Can change volume group 27 change_volumegroup |
744 | -102 Can delete volume group 27 delete_volumegroup |
745 | -103 Can add raid 27 add_raid |
746 | -104 Can change raid 27 change_raid |
747 | -105 Can delete raid 27 delete_raid |
748 | -106 Can add bcache 27 add_bcache |
749 | -107 Can change bcache 27 change_bcache |
750 | -108 Can delete bcache 27 delete_bcache |
751 | -109 Can add partition 28 add_partition |
752 | -110 Can change partition 28 change_partition |
753 | -111 Can delete partition 28 delete_partition |
754 | -112 Can add filesystem 29 add_filesystem |
755 | -113 Can change filesystem 29 change_filesystem |
756 | -114 Can delete filesystem 29 delete_filesystem |
757 | -115 Can add license key 30 add_licensekey |
758 | -116 Can change license key 30 change_licensekey |
759 | -117 Can delete license key 30 delete_licensekey |
760 | -118 Can add owner data 31 add_ownerdata |
761 | -119 Can change owner data 31 change_ownerdata |
762 | -120 Can delete owner data 31 delete_ownerdata |
763 | -121 Can add partition table 32 add_partitiontable |
764 | -122 Can change partition table 32 change_partitiontable |
765 | -123 Can delete partition table 32 delete_partitiontable |
766 | -124 Can add physical block device 33 add_physicalblockdevice |
767 | -125 Can change physical block device 33 change_physicalblockdevice |
768 | -126 Can delete physical block device 33 delete_physicalblockdevice |
769 | -127 Can add service 34 add_service |
770 | -128 Can change service 34 change_service |
771 | -129 Can delete service 34 delete_service |
772 | -130 Can add tag 35 add_tag |
773 | -131 Can change tag 35 change_tag |
774 | -132 Can delete tag 35 delete_tag |
775 | -133 Can add VLAN 36 add_vlan |
776 | -134 Can change VLAN 36 change_vlan |
777 | -135 Can delete VLAN 36 delete_vlan |
778 | -136 Can add Physical zone 37 add_zone |
779 | -137 Can change Physical zone 37 change_zone |
780 | -138 Can delete Physical zone 37 delete_zone |
781 | -139 Can add node 38 add_node |
782 | -140 Can change node 38 change_node |
783 | -141 Can delete node 38 delete_node |
784 | -142 Can add machine 38 add_machine |
785 | -143 Can change machine 38 change_machine |
786 | -144 Can delete machine 38 delete_machine |
787 | -145 Can add controller 38 add_controller |
788 | -146 Can change controller 38 change_controller |
789 | -147 Can delete controller 38 delete_controller |
790 | -148 Can add rack controller 38 add_rackcontroller |
791 | -149 Can change rack controller 38 change_rackcontroller |
792 | -150 Can delete rack controller 38 delete_rackcontroller |
793 | -151 Can add region controller 38 add_regioncontroller |
794 | -152 Can change region controller 38 change_regioncontroller |
795 | -153 Can delete region controller 38 delete_regioncontroller |
796 | -154 Can add device 38 add_device |
797 | -155 Can change device 38 change_device |
798 | -156 Can delete device 38 delete_device |
799 | -157 Can add chassis 38 add_chassis |
800 | -158 Can change chassis 38 change_chassis |
801 | -159 Can delete chassis 38 delete_chassis |
802 | -160 Can add storage 38 add_storage |
803 | -161 Can change storage 38 change_storage |
804 | -162 Can delete storage 38 delete_storage |
805 | -163 Can add node group to rack controller 39 add_nodegrouptorackcontroller |
806 | -164 Can change node group to rack controller 39 change_nodegrouptorackcontroller |
807 | -165 Can delete node group to rack controller 39 delete_nodegrouptorackcontroller |
808 | -166 Can add chassis hints 40 add_chassishints |
809 | -167 Can change chassis hints 40 change_chassishints |
810 | -168 Can delete chassis hints 40 delete_chassishints |
811 | -169 Can add component error 41 add_componenterror |
812 | -170 Can change component error 41 change_componenterror |
813 | -171 Can delete component error 41 delete_componenterror |
814 | -172 Can add dhcp snippet 42 add_dhcpsnippet |
815 | -173 Can change dhcp snippet 42 change_dhcpsnippet |
816 | -174 Can delete dhcp snippet 42 delete_dhcpsnippet |
817 | -175 Can add Discovery 43 add_discovery |
818 | -176 Can change Discovery 43 change_discovery |
819 | -177 Can delete Discovery 43 delete_discovery |
820 | -178 Can add DNSResource 44 add_dnsresource |
821 | -179 Can change DNSResource 44 change_dnsresource |
822 | -180 Can delete DNSResource 44 delete_dnsresource |
823 | -181 Can add DNSData 45 add_dnsdata |
824 | -182 Can change DNSData 45 change_dnsdata |
825 | -183 Can delete DNSData 45 delete_dnsdata |
826 | -184 Can add dns publication 46 add_dnspublication |
827 | -185 Can change dns publication 46 change_dnspublication |
828 | -186 Can delete dns publication 46 delete_dnspublication |
829 | -187 Can add Event type 47 add_eventtype |
830 | -188 Can change Event type 47 change_eventtype |
831 | -189 Can delete Event type 47 delete_eventtype |
832 | -190 Can add Event record 48 add_event |
833 | -191 Can change Event record 48 change_event |
834 | -192 Can delete Event record 48 delete_event |
835 | -193 Can add Fan Network 49 add_fannetwork |
836 | -194 Can change Fan Network 49 change_fannetwork |
837 | -195 Can delete Fan Network 49 delete_fannetwork |
838 | -196 Can add file storage 50 add_filestorage |
839 | -197 Can change file storage 50 change_filestorage |
840 | -198 Can delete file storage 50 delete_filestorage |
841 | -199 Can add ip range 51 add_iprange |
842 | -200 Can change ip range 51 change_iprange |
843 | -201 Can delete ip range 51 delete_iprange |
844 | -202 Can add Key Source 52 add_keysource |
845 | -203 Can change Key Source 52 change_keysource |
846 | -204 Can delete Key Source 52 delete_keysource |
847 | -205 Can add mDNS binding 53 add_mdns |
848 | -206 Can change mDNS binding 53 change_mdns |
849 | -207 Can delete mDNS binding 53 delete_mdns |
850 | -208 Can add Neighbour 54 add_neighbour |
851 | -209 Can change Neighbour 54 change_neighbour |
852 | -210 Can delete Neighbour 54 delete_neighbour |
853 | -211 Can add notification 55 add_notification |
854 | -212 Can change notification 55 change_notification |
855 | -213 Can delete notification 55 delete_notification |
856 | -214 Can add notification dismissal 56 add_notificationdismissal |
857 | -215 Can change notification dismissal 56 change_notificationdismissal |
858 | -216 Can delete notification dismissal 56 delete_notificationdismissal |
859 | -217 Can add package repository 57 add_packagerepository |
860 | -218 Can change package repository 57 change_packagerepository |
861 | -219 Can delete package repository 57 delete_packagerepository |
862 | -220 Can add Reverse-DNS entry 58 add_rdns |
863 | -221 Can change Reverse-DNS entry 58 change_rdns |
864 | -222 Can delete Reverse-DNS entry 58 delete_rdns |
865 | -223 Can add region controller process 59 add_regioncontrollerprocess |
866 | -224 Can change region controller process 59 change_regioncontrollerprocess |
867 | -225 Can delete region controller process 59 delete_regioncontrollerprocess |
868 | -226 Can add region controller process endpoint 60 add_regioncontrollerprocessendpoint |
869 | -227 Can change region controller process endpoint 60 change_regioncontrollerprocessendpoint |
870 | -228 Can delete region controller process endpoint 60 delete_regioncontrollerprocessendpoint |
871 | -229 Can add region rack rpc connection 61 add_regionrackrpcconnection |
872 | -230 Can change region rack rpc connection 61 change_regionrackrpcconnection |
873 | -231 Can delete region rack rpc connection 61 delete_regionrackrpcconnection |
874 | -232 Can add Space 62 add_space |
875 | -233 Can change Space 62 change_space |
876 | -234 Can delete Space 62 delete_space |
877 | -235 Can add SSH key 63 add_sshkey |
878 | -236 Can change SSH key 63 change_sshkey |
879 | -237 Can delete SSH key 63 delete_sshkey |
880 | -238 Can add SSL key 64 add_sslkey |
881 | -239 Can change SSL key 64 change_sslkey |
882 | -240 Can delete SSL key 64 delete_sslkey |
883 | -241 Can add Template 65 add_template |
884 | -242 Can change Template 65 change_template |
885 | -243 Can delete Template 65 delete_template |
886 | -244 Can add user profile 66 add_userprofile |
887 | -245 Can change user profile 66 change_userprofile |
888 | -246 Can delete user profile 66 delete_userprofile |
889 | -247 Can add virtual block device 67 add_virtualblockdevice |
890 | -248 Can change virtual block device 67 change_virtualblockdevice |
891 | -249 Can delete virtual block device 67 delete_virtualblockdevice |
892 | -250 Can add commissioning script 84 add_commissioningscript |
893 | -251 Can change commissioning script 84 change_commissioningscript |
894 | -252 Can delete commissioning script 84 delete_commissioningscript |
895 | -253 Can add node key 85 add_nodekey |
896 | -254 Can change node key 85 change_nodekey |
897 | -255 Can delete node key 85 delete_nodekey |
898 | -256 Can add node user data 86 add_nodeuserdata |
899 | -257 Can change node user data 86 change_nodeuserdata |
900 | -258 Can delete node user data 86 delete_nodeuserdata |
901 | -259 Can add script 87 add_script |
902 | -260 Can change script 87 change_script |
903 | -261 Can delete script 87 delete_script |
904 | -262 Can add script set 88 add_scriptset |
905 | -263 Can change script set 88 change_scriptset |
906 | -264 Can delete script set 88 delete_scriptset |
907 | -265 Can add script result 89 add_scriptresult |
908 | -266 Can change script result 89 change_scriptresult |
909 | -267 Can delete script result 89 delete_scriptresult |
910 | -268 Can add nonce 90 add_nonce |
911 | -269 Can change nonce 90 change_nonce |
912 | -270 Can delete nonce 90 delete_nonce |
913 | -271 Can add consumer 91 add_consumer |
914 | -272 Can change consumer 91 change_consumer |
915 | -273 Can delete consumer 91 delete_consumer |
916 | -274 Can add token 92 add_token |
917 | -275 Can change token 92 change_token |
918 | -276 Can delete token 92 delete_token |
919 | +40 Can add Interface 14 add_interface |
920 | +41 Can change Interface 14 change_interface |
921 | +42 Can delete Interface 14 delete_interface |
922 | +43 Can add interface relationship 15 add_interfacerelationship |
923 | +44 Can change interface relationship 15 change_interfacerelationship |
924 | +45 Can delete interface relationship 15 delete_interfacerelationship |
925 | +46 Can add Physical interface 14 add_physicalinterface |
926 | +47 Can change Physical interface 14 change_physicalinterface |
927 | +48 Can delete Physical interface 14 delete_physicalinterface |
928 | +49 Can add child interface 14 add_childinterface |
929 | +50 Can change child interface 14 change_childinterface |
930 | +51 Can delete child interface 14 delete_childinterface |
931 | +52 Can add Bridge 14 add_bridgeinterface |
932 | +53 Can change Bridge 14 change_bridgeinterface |
933 | +54 Can delete Bridge 14 delete_bridgeinterface |
934 | +55 Can add Bond 14 add_bondinterface |
935 | +56 Can change Bond 14 change_bondinterface |
936 | +57 Can delete Bond 14 delete_bondinterface |
937 | +58 Can add VLAN interface 14 add_vlaninterface |
938 | +59 Can change VLAN interface 14 change_vlaninterface |
939 | +60 Can delete VLAN interface 14 delete_vlaninterface |
940 | +61 Can add Unknown interface 14 add_unknowninterface |
941 | +62 Can change Unknown interface 14 change_unknowninterface |
942 | +63 Can delete Unknown interface 14 delete_unknowninterface |
943 | +64 Can add Fabric 16 add_fabric |
944 | +65 Can change Fabric 16 change_fabric |
945 | +66 Can delete Fabric 16 delete_fabric |
946 | +67 Can add boot source 17 add_bootsource |
947 | +68 Can change boot source 17 change_bootsource |
948 | +69 Can delete boot source 17 delete_bootsource |
949 | +70 Can add boot source cache 18 add_bootsourcecache |
950 | +71 Can change boot source cache 18 change_bootsourcecache |
951 | +72 Can delete boot source cache 18 delete_bootsourcecache |
952 | +73 Can add boot resource 19 add_bootresource |
953 | +74 Can change boot resource 19 change_bootresource |
954 | +75 Can delete boot resource 19 delete_bootresource |
955 | +76 Can add cache set 20 add_cacheset |
956 | +77 Can change cache set 20 change_cacheset |
957 | +78 Can delete cache set 20 delete_cacheset |
958 | +79 Can add filesystem group 21 add_filesystemgroup |
959 | +80 Can change filesystem group 21 change_filesystemgroup |
960 | +81 Can delete filesystem group 21 delete_filesystemgroup |
961 | +82 Can add volume group 21 add_volumegroup |
962 | +83 Can change volume group 21 change_volumegroup |
963 | +84 Can delete volume group 21 delete_volumegroup |
964 | +85 Can add raid 21 add_raid |
965 | +86 Can change raid 21 change_raid |
966 | +87 Can delete raid 21 delete_raid |
967 | +88 Can add bcache 21 add_bcache |
968 | +89 Can change bcache 21 change_bcache |
969 | +90 Can delete bcache 21 delete_bcache |
970 | +91 Can add partition 22 add_partition |
971 | +92 Can change partition 22 change_partition |
972 | +93 Can delete partition 22 delete_partition |
973 | +94 Can add filesystem 23 add_filesystem |
974 | +95 Can change filesystem 23 change_filesystem |
975 | +96 Can delete filesystem 23 delete_filesystem |
976 | +97 Can add license key 24 add_licensekey |
977 | +98 Can change license key 24 change_licensekey |
978 | +99 Can delete license key 24 delete_licensekey |
979 | +100 Can add owner data 25 add_ownerdata |
980 | +101 Can change owner data 25 change_ownerdata |
981 | +102 Can delete owner data 25 delete_ownerdata |
982 | +103 Can add partition table 26 add_partitiontable |
983 | +104 Can change partition table 26 change_partitiontable |
984 | +105 Can delete partition table 26 delete_partitiontable |
985 | +106 Can add physical block device 27 add_physicalblockdevice |
986 | +107 Can change physical block device 27 change_physicalblockdevice |
987 | +108 Can delete physical block device 27 delete_physicalblockdevice |
988 | +109 Can add service 28 add_service |
989 | +110 Can change service 28 change_service |
990 | +111 Can delete service 28 delete_service |
991 | +112 Can add tag 29 add_tag |
992 | +113 Can change tag 29 change_tag |
993 | +114 Can delete tag 29 delete_tag |
994 | +115 Can add VLAN 30 add_vlan |
995 | +116 Can change VLAN 30 change_vlan |
996 | +117 Can delete VLAN 30 delete_vlan |
997 | +118 Can add Physical zone 31 add_zone |
998 | +119 Can change Physical zone 31 change_zone |
999 | +120 Can delete Physical zone 31 delete_zone |
1000 | +121 Can add node 32 add_node |
1001 | +122 Can change node 32 change_node |
1002 | +123 Can delete node 32 delete_node |
1003 | +124 Can add machine 32 add_machine |
1004 | +125 Can change machine 32 change_machine |
1005 | +126 Can delete machine 32 delete_machine |
1006 | +127 Can add controller 32 add_controller |
1007 | +128 Can change controller 32 change_controller |
1008 | +129 Can delete controller 32 delete_controller |
1009 | +130 Can add rack controller 32 add_rackcontroller |
1010 | +131 Can change rack controller 32 change_rackcontroller |
1011 | +132 Can delete rack controller 32 delete_rackcontroller |
1012 | +133 Can add region controller 32 add_regioncontroller |
1013 | +134 Can change region controller 32 change_regioncontroller |
1014 | +135 Can delete region controller 32 delete_regioncontroller |
1015 | +136 Can add device 32 add_device |
1016 | +137 Can change device 32 change_device |
1017 | +138 Can delete device 32 delete_device |
1018 | +139 Can add node group to rack controller 33 add_nodegrouptorackcontroller |
1019 | +140 Can change node group to rack controller 33 change_nodegrouptorackcontroller |
1020 | +141 Can delete node group to rack controller 33 delete_nodegrouptorackcontroller |
1021 | +142 Can add pod hints 34 add_podhints |
1022 | +143 Can change pod hints 34 change_podhints |
1023 | +144 Can delete pod hints 34 delete_podhints |
1024 | +145 Can add bmc 35 add_bmc |
1025 | +146 Can change bmc 35 change_bmc |
1026 | +147 Can delete bmc 35 delete_bmc |
1027 | +148 Can add pod 35 add_pod |
1028 | +149 Can change pod 35 change_pod |
1029 | +150 Can delete pod 35 delete_pod |
1030 | +151 Can add bmc routable rack controller relationship 36 add_bmcroutablerackcontrollerrelationship |
1031 | +152 Can change bmc routable rack controller relationship 36 change_bmcroutablerackcontrollerrelationship |
1032 | +153 Can delete bmc routable rack controller relationship 36 delete_bmcroutablerackcontrollerrelationship |
1033 | +154 Can add boot resource set 37 add_bootresourceset |
1034 | +155 Can change boot resource set 37 change_bootresourceset |
1035 | +156 Can delete boot resource set 37 delete_bootresourceset |
1036 | +157 Can add large file 38 add_largefile |
1037 | +158 Can change large file 38 change_largefile |
1038 | +159 Can delete large file 38 delete_largefile |
1039 | +160 Can add boot resource file 39 add_bootresourcefile |
1040 | +161 Can change boot resource file 39 change_bootresourcefile |
1041 | +162 Can delete boot resource file 39 delete_bootresourcefile |
1042 | +163 Can add boot source selection 40 add_bootsourceselection |
1043 | +164 Can change boot source selection 40 change_bootsourceselection |
1044 | +165 Can delete boot source selection 40 delete_bootsourceselection |
1045 | +166 Can add dhcp snippet 41 add_dhcpsnippet |
1046 | +167 Can change dhcp snippet 41 change_dhcpsnippet |
1047 | +168 Can delete dhcp snippet 41 delete_dhcpsnippet |
1048 | +169 Can add Discovery 42 add_discovery |
1049 | +170 Can change Discovery 42 change_discovery |
1050 | +171 Can delete Discovery 42 delete_discovery |
1051 | +172 Can add DNSResource 43 add_dnsresource |
1052 | +173 Can change DNSResource 43 change_dnsresource |
1053 | +174 Can delete DNSResource 43 delete_dnsresource |
1054 | +175 Can add DNSData 44 add_dnsdata |
1055 | +176 Can change DNSData 44 change_dnsdata |
1056 | +177 Can delete DNSData 44 delete_dnsdata |
1057 | +178 Can add dns publication 45 add_dnspublication |
1058 | +179 Can change dns publication 45 change_dnspublication |
1059 | +180 Can delete dns publication 45 delete_dnspublication |
1060 | +181 Can add Event type 46 add_eventtype |
1061 | +182 Can change Event type 46 change_eventtype |
1062 | +183 Can delete Event type 46 delete_eventtype |
1063 | +184 Can add Event record 47 add_event |
1064 | +185 Can change Event record 47 change_event |
1065 | +186 Can delete Event record 47 delete_event |
1066 | +187 Can add Fan Network 48 add_fannetwork |
1067 | +188 Can change Fan Network 48 change_fannetwork |
1068 | +189 Can delete Fan Network 48 delete_fannetwork |
1069 | +190 Can add file storage 49 add_filestorage |
1070 | +191 Can change file storage 49 change_filestorage |
1071 | +192 Can delete file storage 49 delete_filestorage |
1072 | +193 Can add ip range 50 add_iprange |
1073 | +194 Can change ip range 50 change_iprange |
1074 | +195 Can delete ip range 50 delete_iprange |
1075 | +196 Can add Key Source 51 add_keysource |
1076 | +197 Can change Key Source 51 change_keysource |
1077 | +198 Can delete Key Source 51 delete_keysource |
1078 | +199 Can add mDNS binding 52 add_mdns |
1079 | +200 Can change mDNS binding 52 change_mdns |
1080 | +201 Can delete mDNS binding 52 delete_mdns |
1081 | +202 Can add Neighbour 53 add_neighbour |
1082 | +203 Can change Neighbour 53 change_neighbour |
1083 | +204 Can delete Neighbour 53 delete_neighbour |
1084 | +205 Can add notification 54 add_notification |
1085 | +206 Can change notification 54 change_notification |
1086 | +207 Can delete notification 54 delete_notification |
1087 | +208 Can add notification dismissal 55 add_notificationdismissal |
1088 | +209 Can change notification dismissal 55 change_notificationdismissal |
1089 | +210 Can delete notification dismissal 55 delete_notificationdismissal |
1090 | +211 Can add package repository 56 add_packagerepository |
1091 | +212 Can change package repository 56 change_packagerepository |
1092 | +213 Can delete package repository 56 delete_packagerepository |
1093 | +214 Can add Reverse-DNS entry 57 add_rdns |
1094 | +215 Can change Reverse-DNS entry 57 change_rdns |
1095 | +216 Can delete Reverse-DNS entry 57 delete_rdns |
1096 | +217 Can add region controller process 58 add_regioncontrollerprocess |
1097 | +218 Can change region controller process 58 change_regioncontrollerprocess |
1098 | +219 Can delete region controller process 58 delete_regioncontrollerprocess |
1099 | +220 Can add region controller process endpoint 59 add_regioncontrollerprocessendpoint |
1100 | +221 Can change region controller process endpoint 59 change_regioncontrollerprocessendpoint |
1101 | +222 Can delete region controller process endpoint 59 delete_regioncontrollerprocessendpoint |
1102 | +223 Can add region rack rpc connection 60 add_regionrackrpcconnection |
1103 | +224 Can change region rack rpc connection 60 change_regionrackrpcconnection |
1104 | +225 Can delete region rack rpc connection 60 delete_regionrackrpcconnection |
1105 | +226 Can add Space 61 add_space |
1106 | +227 Can change Space 61 change_space |
1107 | +228 Can delete Space 61 delete_space |
1108 | +229 Can add SSH key 62 add_sshkey |
1109 | +230 Can change SSH key 62 change_sshkey |
1110 | +231 Can delete SSH key 62 delete_sshkey |
1111 | +232 Can add SSL key 63 add_sslkey |
1112 | +233 Can change SSL key 63 change_sslkey |
1113 | +234 Can delete SSL key 63 delete_sslkey |
1114 | +235 Can add Template 64 add_template |
1115 | +236 Can change Template 64 change_template |
1116 | +237 Can delete Template 64 delete_template |
1117 | +238 Can add user profile 65 add_userprofile |
1118 | +239 Can change user profile 65 change_userprofile |
1119 | +240 Can delete user profile 65 delete_userprofile |
1120 | +241 Can add virtual block device 66 add_virtualblockdevice |
1121 | +242 Can change virtual block device 66 change_virtualblockdevice |
1122 | +243 Can delete virtual block device 66 delete_virtualblockdevice |
1123 | +244 Can add node key 82 add_nodekey |
1124 | +245 Can change node key 82 change_nodekey |
1125 | +246 Can delete node key 82 delete_nodekey |
1126 | +247 Can add node user data 83 add_nodeuserdata |
1127 | +248 Can change node user data 83 change_nodeuserdata |
1128 | +249 Can delete node user data 83 delete_nodeuserdata |
1129 | +250 Can add script 84 add_script |
1130 | +251 Can change script 84 change_script |
1131 | +252 Can delete script 84 delete_script |
1132 | +253 Can add script set 85 add_scriptset |
1133 | +254 Can change script set 85 change_scriptset |
1134 | +255 Can delete script set 85 delete_scriptset |
1135 | +256 Can add script result 86 add_scriptresult |
1136 | +257 Can change script result 86 change_scriptresult |
1137 | +258 Can delete script result 86 delete_scriptresult |
1138 | +259 Can add nonce 87 add_nonce |
1139 | +260 Can change nonce 87 change_nonce |
1140 | +261 Can delete nonce 87 delete_nonce |
1141 | +262 Can add consumer 88 add_consumer |
1142 | +263 Can change consumer 88 change_consumer |
1143 | +264 Can delete consumer 88 delete_consumer |
1144 | +265 Can add token 89 add_token |
1145 | +266 Can change token 89 change_token |
1146 | +267 Can delete token 89 delete_token |
1147 | \. |
1148 | |
1149 | |
1150 | @@ -8129,7 +8276,7 @@ |
1151 | -- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
1152 | -- |
1153 | |
1154 | -SELECT pg_catalog.setval('auth_permission_id_seq', 276, true); |
1155 | +SELECT pg_catalog.setval('auth_permission_id_seq', 267, true); |
1156 | |
1157 | |
1158 | -- |
1159 | @@ -8195,85 +8342,82 @@ |
1160 | 11 maasserver staticroute |
1161 | 12 maasserver subnet |
1162 | 13 maasserver staticipaddress |
1163 | -14 maasserver bmc |
1164 | -15 maasserver bmcroutablerackcontrollerrelationship |
1165 | -16 maasserver bootsource |
1166 | -17 maasserver bootsourcecache |
1167 | -18 maasserver bootresource |
1168 | -19 maasserver bootresourceset |
1169 | -20 maasserver largefile |
1170 | -21 maasserver bootresourcefile |
1171 | -22 maasserver bootsourceselection |
1172 | -23 maasserver cacheset |
1173 | -24 maasserver interface |
1174 | -25 maasserver interfacerelationship |
1175 | -26 maasserver fabric |
1176 | -27 maasserver filesystemgroup |
1177 | -28 maasserver partition |
1178 | -29 maasserver filesystem |
1179 | -30 maasserver licensekey |
1180 | -31 maasserver ownerdata |
1181 | -32 maasserver partitiontable |
1182 | -33 maasserver physicalblockdevice |
1183 | -34 maasserver service |
1184 | -35 maasserver tag |
1185 | -36 maasserver vlan |
1186 | -37 maasserver zone |
1187 | -38 maasserver node |
1188 | -39 maasserver nodegrouptorackcontroller |
1189 | -40 maasserver chassishints |
1190 | -41 maasserver componenterror |
1191 | -42 maasserver dhcpsnippet |
1192 | -43 maasserver discovery |
1193 | -44 maasserver dnsresource |
1194 | -45 maasserver dnsdata |
1195 | -46 maasserver dnspublication |
1196 | -47 maasserver eventtype |
1197 | -48 maasserver event |
1198 | -49 maasserver fannetwork |
1199 | -50 maasserver filestorage |
1200 | -51 maasserver iprange |
1201 | -52 maasserver keysource |
1202 | -53 maasserver mdns |
1203 | -54 maasserver neighbour |
1204 | -55 maasserver notification |
1205 | -56 maasserver notificationdismissal |
1206 | -57 maasserver packagerepository |
1207 | -58 maasserver rdns |
1208 | -59 maasserver regioncontrollerprocess |
1209 | -60 maasserver regioncontrollerprocessendpoint |
1210 | -61 maasserver regionrackrpcconnection |
1211 | -62 maasserver space |
1212 | -63 maasserver sshkey |
1213 | -64 maasserver sslkey |
1214 | -65 maasserver template |
1215 | -66 maasserver userprofile |
1216 | -67 maasserver virtualblockdevice |
1217 | -68 maasserver device |
1218 | -69 maasserver bridgeinterface |
1219 | -70 maasserver storage |
1220 | +14 maasserver interface |
1221 | +15 maasserver interfacerelationship |
1222 | +16 maasserver fabric |
1223 | +17 maasserver bootsource |
1224 | +18 maasserver bootsourcecache |
1225 | +19 maasserver bootresource |
1226 | +20 maasserver cacheset |
1227 | +21 maasserver filesystemgroup |
1228 | +22 maasserver partition |
1229 | +23 maasserver filesystem |
1230 | +24 maasserver licensekey |
1231 | +25 maasserver ownerdata |
1232 | +26 maasserver partitiontable |
1233 | +27 maasserver physicalblockdevice |
1234 | +28 maasserver service |
1235 | +29 maasserver tag |
1236 | +30 maasserver vlan |
1237 | +31 maasserver zone |
1238 | +32 maasserver node |
1239 | +33 maasserver nodegrouptorackcontroller |
1240 | +34 maasserver podhints |
1241 | +35 maasserver bmc |
1242 | +36 maasserver bmcroutablerackcontrollerrelationship |
1243 | +37 maasserver bootresourceset |
1244 | +38 maasserver largefile |
1245 | +39 maasserver bootresourcefile |
1246 | +40 maasserver bootsourceselection |
1247 | +41 maasserver dhcpsnippet |
1248 | +42 maasserver discovery |
1249 | +43 maasserver dnsresource |
1250 | +44 maasserver dnsdata |
1251 | +45 maasserver dnspublication |
1252 | +46 maasserver eventtype |
1253 | +47 maasserver event |
1254 | +48 maasserver fannetwork |
1255 | +49 maasserver filestorage |
1256 | +50 maasserver iprange |
1257 | +51 maasserver keysource |
1258 | +52 maasserver mdns |
1259 | +53 maasserver neighbour |
1260 | +54 maasserver notification |
1261 | +55 maasserver notificationdismissal |
1262 | +56 maasserver packagerepository |
1263 | +57 maasserver rdns |
1264 | +58 maasserver regioncontrollerprocess |
1265 | +59 maasserver regioncontrollerprocessendpoint |
1266 | +60 maasserver regionrackrpcconnection |
1267 | +61 maasserver space |
1268 | +62 maasserver sshkey |
1269 | +63 maasserver sslkey |
1270 | +64 maasserver template |
1271 | +65 maasserver userprofile |
1272 | +66 maasserver virtualblockdevice |
1273 | +67 maasserver bridgeinterface |
1274 | +68 maasserver machine |
1275 | +69 maasserver pod |
1276 | +70 maasserver rackcontroller |
1277 | 71 maasserver physicalinterface |
1278 | -72 maasserver chassis |
1279 | -73 maasserver rackcontroller |
1280 | -74 maasserver bcache |
1281 | -75 maasserver controller |
1282 | -76 maasserver regioncontroller |
1283 | -77 maasserver childinterface |
1284 | -78 maasserver machine |
1285 | -79 maasserver bondinterface |
1286 | -80 maasserver volumegroup |
1287 | -81 maasserver vlaninterface |
1288 | -82 maasserver raid |
1289 | -83 maasserver unknowninterface |
1290 | -84 metadataserver commissioningscript |
1291 | -85 metadataserver nodekey |
1292 | -86 metadataserver nodeuserdata |
1293 | -87 metadataserver script |
1294 | -88 metadataserver scriptset |
1295 | -89 metadataserver scriptresult |
1296 | -90 piston3 nonce |
1297 | -91 piston3 consumer |
1298 | -92 piston3 token |
1299 | +72 maasserver controller |
1300 | +73 maasserver bcache |
1301 | +74 maasserver vlaninterface |
1302 | +75 maasserver childinterface |
1303 | +76 maasserver unknowninterface |
1304 | +77 maasserver device |
1305 | +78 maasserver bondinterface |
1306 | +79 maasserver raid |
1307 | +80 maasserver regioncontroller |
1308 | +81 maasserver volumegroup |
1309 | +82 metadataserver nodekey |
1310 | +83 metadataserver nodeuserdata |
1311 | +84 metadataserver script |
1312 | +85 metadataserver scriptset |
1313 | +86 metadataserver scriptresult |
1314 | +87 piston3 nonce |
1315 | +88 piston3 consumer |
1316 | +89 piston3 token |
1317 | \. |
1318 | |
1319 | |
1320 | @@ -8281,7 +8425,7 @@ |
1321 | -- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
1322 | -- |
1323 | |
1324 | -SELECT pg_catalog.setval('django_content_type_id_seq', 92, true); |
1325 | +SELECT pg_catalog.setval('django_content_type_id_seq', 89, true); |
1326 | |
1327 | |
1328 | -- |
1329 | @@ -8289,125 +8433,143 @@ |
1330 | -- |
1331 | |
1332 | COPY django_migrations (id, app, name, applied) FROM stdin; |
1333 | -1 contenttypes 0001_initial 2017-01-10 10:30:23.537654-08 |
1334 | -2 auth 0001_initial 2017-01-10 10:30:23.562737-08 |
1335 | -3 auth 0002_auto_20151119_1629 2017-01-10 10:30:23.615092-08 |
1336 | -4 contenttypes 0002_remove_content_type_name 2017-01-10 10:30:23.631977-08 |
1337 | -5 piston3 0001_initial 2017-01-10 10:30:23.653188-08 |
1338 | -6 maasserver 0001_initial 2017-01-10 10:30:25.50039-08 |
1339 | -7 metadataserver 0001_initial 2017-01-10 10:30:25.70416-08 |
1340 | -8 maasserver 0002_remove_candidate_name_model 2017-01-10 10:30:25.710138-08 |
1341 | -9 maasserver 0003_add_node_type_to_node 2017-01-10 10:30:25.764718-08 |
1342 | -10 maasserver 0004_migrate_installable_to_node_type 2017-01-10 10:30:25.771058-08 |
1343 | -11 maasserver 0005_delete_installable_from_node 2017-01-10 10:30:25.820839-08 |
1344 | -12 maasserver 0006_add_lease_time_to_staticipaddress 2017-01-10 10:30:25.871927-08 |
1345 | -13 maasserver 0007_create_node_proxy_models 2017-01-10 10:30:25.881122-08 |
1346 | -14 maasserver 0008_use_new_arrayfield 2017-01-10 10:30:26.099884-08 |
1347 | -15 maasserver 0009_remove_routers_field_from_node 2017-01-10 10:30:26.162327-08 |
1348 | -16 maasserver 0010_add_dns_models 2017-01-10 10:30:26.292332-08 |
1349 | -17 maasserver 0011_domain_data 2017-01-10 10:30:26.305077-08 |
1350 | -18 maasserver 0012_drop_dns_fields 2017-01-10 10:30:26.503353-08 |
1351 | -19 maasserver 0013_remove_boot_type_from_node 2017-01-10 10:30:26.558726-08 |
1352 | -20 maasserver 0014_add_region_models 2017-01-10 10:30:27.355588-08 |
1353 | -21 maasserver 0015_add_bmc_model 2017-01-10 10:30:27.588553-08 |
1354 | -22 maasserver 0016_migrate_power_data_node_to_bmc 2017-01-10 10:30:27.596511-08 |
1355 | -23 maasserver 0017_remove_node_power_type 2017-01-10 10:30:27.6555-08 |
1356 | -24 maasserver 0018_add_dnsdata 2017-01-10 10:30:27.835944-08 |
1357 | -25 maasserver 0019_add_iprange 2017-01-10 10:30:27.897757-08 |
1358 | -26 maasserver 0020_nodegroup_to_rackcontroller 2017-01-10 10:30:27.962821-08 |
1359 | -27 maasserver 0021_nodegroupinterface_to_iprange 2017-01-10 10:30:27.96809-08 |
1360 | -28 maasserver 0022_extract_ip_for_bmcs 2017-01-10 10:30:27.974279-08 |
1361 | -29 maasserver 0023_add_ttl_field 2017-01-10 10:30:28.435315-08 |
1362 | -30 maasserver 0024_remove_nodegroupinterface 2017-01-10 10:30:29.797233-08 |
1363 | -31 maasserver 0025_create_node_system_id_sequence 2017-01-10 10:30:29.803626-08 |
1364 | -32 maasserver 0026_create_zone_serial_sequence 2017-01-10 10:30:29.80906-08 |
1365 | -33 maasserver 0027_replace_static_range_with_admin_reserved_ranges 2017-01-10 10:30:29.815557-08 |
1366 | -34 maasserver 0028_update_default_vlan_on_interface_and_subnet 2017-01-10 10:30:29.955173-08 |
1367 | -35 maasserver 0029_add_rdns_mode 2017-01-10 10:30:30.015257-08 |
1368 | -36 maasserver 0030_drop_all_old_funcs 2017-01-10 10:30:30.02152-08 |
1369 | -37 maasserver 0031_add_region_rack_rpc_conn_model 2017-01-10 10:30:30.207086-08 |
1370 | -38 maasserver 0032_loosen_vlan 2017-01-10 10:30:30.352458-08 |
1371 | -39 maasserver 0033_iprange_minor_changes 2017-01-10 10:30:30.596761-08 |
1372 | -40 maasserver 0034_rename_mount_params_as_mount_options 2017-01-10 10:30:30.654084-08 |
1373 | -41 maasserver 0035_convert_ether_wake_to_manual_power_type 2017-01-10 10:30:30.659702-08 |
1374 | -42 maasserver 0036_add_service_model 2017-01-10 10:30:30.775738-08 |
1375 | -43 maasserver 0037_node_last_image_sync 2017-01-10 10:30:30.83666-08 |
1376 | -44 maasserver 0038_filesystem_ramfs_tmpfs_support 2017-01-10 10:30:30.955453-08 |
1377 | -45 maasserver 0039_create_template_and_versionedtextfile_models 2017-01-10 10:30:30.985598-08 |
1378 | -46 maasserver 0040_fix_id_seq 2017-01-10 10:30:30.990976-08 |
1379 | -47 maasserver 0041_change_bmc_on_delete_to_set_null 2017-01-10 10:30:31.066277-08 |
1380 | -48 maasserver 0042_add_routable_rack_controllers_to_bmc 2017-01-10 10:30:31.652817-08 |
1381 | -49 maasserver 0043_dhcpsnippet 2017-01-10 10:30:31.728354-08 |
1382 | -50 maasserver 0044_remove_di_bootresourcefiles 2017-01-10 10:30:31.745222-08 |
1383 | -51 maasserver 0045_add_node_to_filesystem 2017-01-10 10:30:31.834514-08 |
1384 | -52 maasserver 0046_add_bridge_interface_type 2017-01-10 10:30:31.910249-08 |
1385 | -53 maasserver 0047_fix_spelling_of_degraded 2017-01-10 10:30:31.980086-08 |
1386 | -54 maasserver 0048_add_subnet_allow_proxy 2017-01-10 10:30:32.052395-08 |
1387 | -55 maasserver 0049_add_external_dhcp_present_to_vlan 2017-01-10 10:30:32.282374-08 |
1388 | -56 maasserver 0050_modify_external_dhcp_on_vlan 2017-01-10 10:30:32.582954-08 |
1389 | -57 maasserver 0051_space_fabric_unique 2017-01-10 10:30:32.718323-08 |
1390 | -58 maasserver 0052_add_codename_title_eol_to_bootresourcecache 2017-01-10 10:30:32.747222-08 |
1391 | -59 maasserver 0053_add_ownerdata_model 2017-01-10 10:30:32.880817-08 |
1392 | -60 maasserver 0054_controller 2017-01-10 10:30:32.887252-08 |
1393 | -61 maasserver 0055_dns_publications 2017-01-10 10:30:32.900553-08 |
1394 | -62 maasserver 0056_zone_serial_ownership 2017-01-10 10:30:32.911855-08 |
1395 | -63 maasserver 0057_initial_dns_publication 2017-01-10 10:30:32.91866-08 |
1396 | -64 maasserver 0058_bigger_integer_for_dns_publication_serial 2017-01-10 10:30:32.927772-08 |
1397 | -65 maasserver 0056_add_description_to_fabric_and_space 2017-01-10 10:30:33.365379-08 |
1398 | -66 maasserver 0057_merge 2017-01-10 10:30:33.367004-08 |
1399 | -67 maasserver 0059_merge 2017-01-10 10:30:33.368585-08 |
1400 | -68 maasserver 0060_amt_remove_mac_address 2017-01-10 10:30:33.375209-08 |
1401 | -69 maasserver 0061_maas_nodegroup_worker_to_maas 2017-01-10 10:30:33.381213-08 |
1402 | -70 maasserver 0062_fix_bootsource_daily_label 2017-01-10 10:30:33.387879-08 |
1403 | -71 maasserver 0063_remove_orphaned_bmcs_and_ips 2017-01-10 10:30:33.394413-08 |
1404 | -72 maasserver 0064_remove_unneeded_event_triggers 2017-01-10 10:30:33.399577-08 |
1405 | -73 maasserver 0065_larger_osystem_and_distro_series 2017-01-10 10:30:34.005338-08 |
1406 | -74 maasserver 0066_allow_squashfs 2017-01-10 10:30:34.016663-08 |
1407 | -75 maasserver 0067_add_size_to_largefile 2017-01-10 10:30:34.034048-08 |
1408 | -76 maasserver 0068_drop_node_system_id_sequence 2017-01-10 10:30:34.041162-08 |
1409 | -77 maasserver 0069_add_previous_node_status_to_node 2017-01-10 10:30:34.12564-08 |
1410 | -78 maasserver 0070_allow_null_vlan_on_interface 2017-01-10 10:30:34.209352-08 |
1411 | -79 maasserver 0071_ntp_server_to_ntp_servers 2017-01-10 10:30:34.215226-08 |
1412 | -80 maasserver 0072_packagerepository 2017-01-10 10:30:34.224822-08 |
1413 | -81 maasserver 0073_migrate_package_repositories 2017-01-10 10:30:34.234933-08 |
1414 | -82 maasserver 0072_update_status_and_previous_status 2017-01-10 10:30:34.377397-08 |
1415 | -83 maasserver 0074_merge 2017-01-10 10:30:34.379094-08 |
1416 | -84 maasserver 0075_modify_packagerepository 2017-01-10 10:30:34.41792-08 |
1417 | -85 maasserver 0076_interface_discovery_rescue_mode 2017-01-10 10:30:35.154928-08 |
1418 | -86 maasserver 0077_static_routes 2017-01-10 10:30:35.308806-08 |
1419 | -87 maasserver 0078_remove_packagerepository_description 2017-01-10 10:30:35.318893-08 |
1420 | -88 maasserver 0079_add_keysource_model 2017-01-10 10:30:35.488796-08 |
1421 | -89 maasserver 0080_change_packagerepository_url_type 2017-01-10 10:30:35.497451-08 |
1422 | -90 maasserver 0081_allow_larger_bootsourcecache_fields 2017-01-10 10:30:35.543837-08 |
1423 | -91 maasserver 0082_add_kflavor 2017-01-10 10:30:35.574404-08 |
1424 | -92 maasserver 0083_device_discovery 2017-01-10 10:30:35.652092-08 |
1425 | -93 maasserver 0084_add_default_user_to_node_model 2017-01-10 10:30:35.737259-08 |
1426 | -94 maasserver 0085_no_intro_on_upgrade 2017-01-10 10:30:35.744001-08 |
1427 | -95 maasserver 0086_remove_powerpc_from_ports_arches 2017-01-10 10:30:35.767658-08 |
1428 | -96 maasserver 0087_add_completed_intro_to_userprofile 2017-01-10 10:30:35.845717-08 |
1429 | -97 maasserver 0088_remove_node_disable_ipv4 2017-01-10 10:30:35.927107-08 |
1430 | -98 maasserver 0089_active_discovery 2017-01-10 10:30:36.625708-08 |
1431 | -99 maasserver 0090_bootloaders 2017-01-10 10:30:36.684355-08 |
1432 | -100 maasserver 0091_v2_to_v3 2017-01-10 10:30:36.691175-08 |
1433 | -101 maasserver 0092_rolling 2017-01-10 10:30:36.705914-08 |
1434 | -102 maasserver 0093_add_rdns_model 2017-01-10 10:30:36.8635-08 |
1435 | -103 maasserver 0094_add_unmanaged_subnets 2017-01-10 10:30:36.943813-08 |
1436 | -104 maasserver 0095_vlan_relay_vlan 2017-01-10 10:30:37.02381-08 |
1437 | -105 maasserver 0096_set_default_vlan_field 2017-01-10 10:30:37.12043-08 |
1438 | -106 maasserver 0097_node_chassis_storage_hints 2017-01-10 10:30:37.609599-08 |
1439 | -107 maasserver 0098_add_space_to_vlan 2017-01-10 10:30:37.69251-08 |
1440 | -108 maasserver 0099_set_default_vlan_field 2017-01-10 10:30:37.800469-08 |
1441 | -109 maasserver 0100_migrate_spaces_from_subnet_to_vlan 2017-01-10 10:30:37.807652-08 |
1442 | -110 maasserver 0101_filesystem_btrfs_support 2017-01-10 10:30:37.887587-08 |
1443 | -111 maasserver 0102_remove_space_from_subnet 2017-01-10 10:30:38.083219-08 |
1444 | -112 maasserver 0103_notifications 2017-01-10 10:30:38.17212-08 |
1445 | -113 maasserver 0104_notifications_dismissals 2017-01-10 10:30:38.257711-08 |
1446 | -114 metadataserver 0002_script_models 2017-01-10 10:30:39.29069-08 |
1447 | -115 maasserver 0105_add_script_sets_to_node_model 2017-01-10 10:30:39.570306-08 |
1448 | -116 metadataserver 0003_remove_noderesult 2017-01-10 10:30:39.782484-08 |
1449 | -117 piston3 0002_auto_20151209_1652 2017-01-10 10:30:39.867922-08 |
1450 | -118 sessions 0001_initial 2017-01-10 10:30:39.87768-08 |
1451 | -119 sites 0001_initial 2017-01-10 10:30:39.887649-08 |
1452 | +1 contenttypes 0001_initial 2017-03-23 21:47:39.42153+01 |
1453 | +2 auth 0001_initial 2017-03-23 21:47:39.451128+01 |
1454 | +3 auth 0002_auto_20151119_1629 2017-03-23 21:47:39.54123+01 |
1455 | +4 contenttypes 0002_remove_content_type_name 2017-03-23 21:47:39.56309+01 |
1456 | +5 piston3 0001_initial 2017-03-23 21:47:39.585614+01 |
1457 | +6 maasserver 0001_initial 2017-03-23 21:47:41.446737+01 |
1458 | +7 metadataserver 0001_initial 2017-03-23 21:47:42.21798+01 |
1459 | +8 maasserver 0002_remove_candidate_name_model 2017-03-23 21:47:42.223961+01 |
1460 | +9 maasserver 0003_add_node_type_to_node 2017-03-23 21:47:42.287373+01 |
1461 | +10 maasserver 0004_migrate_installable_to_node_type 2017-03-23 21:47:42.295951+01 |
1462 | +11 maasserver 0005_delete_installable_from_node 2017-03-23 21:47:42.366214+01 |
1463 | +12 maasserver 0006_add_lease_time_to_staticipaddress 2017-03-23 21:47:42.427458+01 |
1464 | +13 maasserver 0007_create_node_proxy_models 2017-03-23 21:47:42.446966+01 |
1465 | +14 maasserver 0008_use_new_arrayfield 2017-03-23 21:47:42.706929+01 |
1466 | +15 maasserver 0009_remove_routers_field_from_node 2017-03-23 21:47:42.771781+01 |
1467 | +16 maasserver 0010_add_dns_models 2017-03-23 21:47:42.981927+01 |
1468 | +17 maasserver 0011_domain_data 2017-03-23 21:47:43.0052+01 |
1469 | +18 maasserver 0012_drop_dns_fields 2017-03-23 21:47:43.276452+01 |
1470 | +19 maasserver 0013_remove_boot_type_from_node 2017-03-23 21:47:43.378309+01 |
1471 | +20 maasserver 0014_add_region_models 2017-03-23 21:47:43.974324+01 |
1472 | +21 maasserver 0015_add_bmc_model 2017-03-23 21:47:44.33414+01 |
1473 | +22 maasserver 0016_migrate_power_data_node_to_bmc 2017-03-23 21:47:44.344298+01 |
1474 | +23 maasserver 0017_remove_node_power_type 2017-03-23 21:47:44.444322+01 |
1475 | +24 maasserver 0018_add_dnsdata 2017-03-23 21:47:44.72588+01 |
1476 | +25 maasserver 0019_add_iprange 2017-03-23 21:47:45.428698+01 |
1477 | +26 maasserver 0020_nodegroup_to_rackcontroller 2017-03-23 21:47:45.555183+01 |
1478 | +27 maasserver 0021_nodegroupinterface_to_iprange 2017-03-23 21:47:45.563627+01 |
1479 | +28 maasserver 0022_extract_ip_for_bmcs 2017-03-23 21:47:45.572118+01 |
1480 | +29 maasserver 0023_add_ttl_field 2017-03-23 21:47:46.279646+01 |
1481 | +30 maasserver 0024_remove_nodegroupinterface 2017-03-23 21:47:47.67792+01 |
1482 | +31 maasserver 0025_create_node_system_id_sequence 2017-03-23 21:47:47.683876+01 |
1483 | +32 maasserver 0026_create_zone_serial_sequence 2017-03-23 21:47:47.688791+01 |
1484 | +33 maasserver 0027_replace_static_range_with_admin_reserved_ranges 2017-03-23 21:47:47.693864+01 |
1485 | +34 maasserver 0028_update_default_vlan_on_interface_and_subnet 2017-03-23 21:47:47.936142+01 |
1486 | +35 maasserver 0029_add_rdns_mode 2017-03-23 21:47:48.048344+01 |
1487 | +36 maasserver 0030_drop_all_old_funcs 2017-03-23 21:47:48.058546+01 |
1488 | +37 maasserver 0031_add_region_rack_rpc_conn_model 2017-03-23 21:47:48.342189+01 |
1489 | +38 maasserver 0032_loosen_vlan 2017-03-23 21:47:48.551556+01 |
1490 | +39 maasserver 0033_iprange_minor_changes 2017-03-23 21:47:49.475623+01 |
1491 | +40 maasserver 0034_rename_mount_params_as_mount_options 2017-03-23 21:47:49.549499+01 |
1492 | +41 maasserver 0035_convert_ether_wake_to_manual_power_type 2017-03-23 21:47:49.555523+01 |
1493 | +42 maasserver 0036_add_service_model 2017-03-23 21:47:49.702593+01 |
1494 | +43 maasserver 0037_node_last_image_sync 2017-03-23 21:47:49.800423+01 |
1495 | +44 maasserver 0038_filesystem_ramfs_tmpfs_support 2017-03-23 21:47:49.975268+01 |
1496 | +45 maasserver 0039_create_template_and_versionedtextfile_models 2017-03-23 21:47:50.031716+01 |
1497 | +46 maasserver 0040_fix_id_seq 2017-03-23 21:47:50.04092+01 |
1498 | +47 maasserver 0041_change_bmc_on_delete_to_set_null 2017-03-23 21:47:50.198313+01 |
1499 | +48 maasserver 0042_add_routable_rack_controllers_to_bmc 2017-03-23 21:47:50.456813+01 |
1500 | +49 maasserver 0043_dhcpsnippet 2017-03-23 21:47:50.567007+01 |
1501 | +50 maasserver 0044_remove_di_bootresourcefiles 2017-03-23 21:47:50.585023+01 |
1502 | +51 maasserver 0045_add_node_to_filesystem 2017-03-23 21:47:50.71502+01 |
1503 | +52 maasserver 0046_add_bridge_interface_type 2017-03-23 21:47:50.819817+01 |
1504 | +53 maasserver 0047_fix_spelling_of_degraded 2017-03-23 21:47:50.89851+01 |
1505 | +54 maasserver 0048_add_subnet_allow_proxy 2017-03-23 21:47:50.99169+01 |
1506 | +55 maasserver 0049_add_external_dhcp_present_to_vlan 2017-03-23 21:47:51.30448+01 |
1507 | +56 maasserver 0050_modify_external_dhcp_on_vlan 2017-03-23 21:47:51.71174+01 |
1508 | +57 maasserver 0051_space_fabric_unique 2017-03-23 21:47:51.883285+01 |
1509 | +58 maasserver 0052_add_codename_title_eol_to_bootresourcecache 2017-03-23 21:47:51.924221+01 |
1510 | +59 maasserver 0053_add_ownerdata_model 2017-03-23 21:47:52.135112+01 |
1511 | +60 maasserver 0054_controller 2017-03-23 21:47:52.142167+01 |
1512 | +61 maasserver 0055_dns_publications 2017-03-23 21:47:52.154548+01 |
1513 | +62 maasserver 0056_zone_serial_ownership 2017-03-23 21:47:52.17348+01 |
1514 | +63 maasserver 0057_initial_dns_publication 2017-03-23 21:47:52.18432+01 |
1515 | +64 maasserver 0058_bigger_integer_for_dns_publication_serial 2017-03-23 21:47:52.198625+01 |
1516 | +65 maasserver 0056_add_description_to_fabric_and_space 2017-03-23 21:47:53.369843+01 |
1517 | +66 maasserver 0057_merge 2017-03-23 21:47:53.370939+01 |
1518 | +67 maasserver 0059_merge 2017-03-23 21:47:53.371916+01 |
1519 | +68 maasserver 0060_amt_remove_mac_address 2017-03-23 21:47:53.379357+01 |
1520 | +69 maasserver 0061_maas_nodegroup_worker_to_maas 2017-03-23 21:47:53.387952+01 |
1521 | +70 maasserver 0062_fix_bootsource_daily_label 2017-03-23 21:47:53.396703+01 |
1522 | +71 maasserver 0063_remove_orphaned_bmcs_and_ips 2017-03-23 21:47:53.402804+01 |
1523 | +72 maasserver 0064_remove_unneeded_event_triggers 2017-03-23 21:47:53.407839+01 |
1524 | +73 maasserver 0065_larger_osystem_and_distro_series 2017-03-23 21:47:53.575645+01 |
1525 | +74 maasserver 0066_allow_squashfs 2017-03-23 21:47:53.586882+01 |
1526 | +75 maasserver 0067_add_size_to_largefile 2017-03-23 21:47:53.605251+01 |
1527 | +76 maasserver 0068_drop_node_system_id_sequence 2017-03-23 21:47:53.610913+01 |
1528 | +77 maasserver 0069_add_previous_node_status_to_node 2017-03-23 21:47:53.696235+01 |
1529 | +78 maasserver 0070_allow_null_vlan_on_interface 2017-03-23 21:47:53.796905+01 |
1530 | +79 maasserver 0071_ntp_server_to_ntp_servers 2017-03-23 21:47:53.807749+01 |
1531 | +80 maasserver 0072_packagerepository 2017-03-23 21:47:53.820425+01 |
1532 | +81 maasserver 0073_migrate_package_repositories 2017-03-23 21:47:53.833181+01 |
1533 | +82 maasserver 0072_update_status_and_previous_status 2017-03-23 21:47:54.044142+01 |
1534 | +83 maasserver 0074_merge 2017-03-23 21:47:54.045794+01 |
1535 | +84 maasserver 0075_modify_packagerepository 2017-03-23 21:47:54.094715+01 |
1536 | +85 maasserver 0076_interface_discovery_rescue_mode 2017-03-23 21:47:55.068863+01 |
1537 | +86 maasserver 0077_static_routes 2017-03-23 21:47:55.326937+01 |
1538 | +87 maasserver 0078_remove_packagerepository_description 2017-03-23 21:47:55.341738+01 |
1539 | +88 maasserver 0079_add_keysource_model 2017-03-23 21:47:55.62063+01 |
1540 | +89 maasserver 0080_change_packagerepository_url_type 2017-03-23 21:47:55.630299+01 |
1541 | +90 maasserver 0081_allow_larger_bootsourcecache_fields 2017-03-23 21:47:55.700652+01 |
1542 | +91 maasserver 0082_add_kflavor 2017-03-23 21:47:55.746847+01 |
1543 | +92 maasserver 0083_device_discovery 2017-03-23 21:47:55.853805+01 |
1544 | +93 maasserver 0084_add_default_user_to_node_model 2017-03-23 21:47:55.977969+01 |
1545 | +94 maasserver 0085_no_intro_on_upgrade 2017-03-23 21:47:55.984074+01 |
1546 | +95 maasserver 0086_remove_powerpc_from_ports_arches 2017-03-23 21:47:56.016251+01 |
1547 | +96 maasserver 0087_add_completed_intro_to_userprofile 2017-03-23 21:47:56.117235+01 |
1548 | +97 maasserver 0088_remove_node_disable_ipv4 2017-03-23 21:47:56.231732+01 |
1549 | +98 maasserver 0089_active_discovery 2017-03-23 21:47:57.163801+01 |
1550 | +99 maasserver 0090_bootloaders 2017-03-23 21:47:57.249133+01 |
1551 | +100 maasserver 0091_v2_to_v3 2017-03-23 21:47:57.255775+01 |
1552 | +101 maasserver 0092_rolling 2017-03-23 21:47:57.269915+01 |
1553 | +102 maasserver 0093_add_rdns_model 2017-03-23 21:47:57.536731+01 |
1554 | +103 maasserver 0094_add_unmanaged_subnets 2017-03-23 21:47:57.665406+01 |
1555 | +104 maasserver 0095_vlan_relay_vlan 2017-03-23 21:47:57.79349+01 |
1556 | +105 maasserver 0096_set_default_vlan_field 2017-03-23 21:47:57.904848+01 |
1557 | +106 maasserver 0097_node_chassis_storage_hints 2017-03-23 21:47:58.581036+01 |
1558 | +107 maasserver 0098_add_space_to_vlan 2017-03-23 21:47:58.695068+01 |
1559 | +108 maasserver 0099_set_default_vlan_field 2017-03-23 21:47:58.852739+01 |
1560 | +109 maasserver 0100_migrate_spaces_from_subnet_to_vlan 2017-03-23 21:47:58.862478+01 |
1561 | +110 maasserver 0101_filesystem_btrfs_support 2017-03-23 21:47:58.986929+01 |
1562 | +111 maasserver 0102_remove_space_from_subnet 2017-03-23 21:47:59.229661+01 |
1563 | +112 maasserver 0103_notifications 2017-03-23 21:47:59.35471+01 |
1564 | +113 maasserver 0104_notifications_dismissals 2017-03-23 21:47:59.470353+01 |
1565 | +114 metadataserver 0002_script_models 2017-03-23 21:48:00.165201+01 |
1566 | +115 maasserver 0105_add_script_sets_to_node_model 2017-03-23 21:48:01.247387+01 |
1567 | +116 maasserver 0106_testing_status 2017-03-23 21:48:01.483861+01 |
1568 | +117 maasserver 0107_chassis_to_pods 2017-03-23 21:48:03.033357+01 |
1569 | +118 maasserver 0108_generate_bmc_names 2017-03-23 21:48:03.047284+01 |
1570 | +119 maasserver 0109_bmc_names_unique 2017-03-23 21:48:03.181962+01 |
1571 | +120 maasserver 0110_notification_category 2017-03-23 21:48:03.338978+01 |
1572 | +121 maasserver 0111_remove_component_error 2017-03-23 21:48:03.353678+01 |
1573 | +122 maasserver 0112_update_notification 2017-03-23 21:48:03.933219+01 |
1574 | +123 maasserver 0113_set_filepath_limit_to_linux_max 2017-03-23 21:48:04.067262+01 |
1575 | +124 maasserver 0114_node_dynamic_to_creation_type 2017-03-23 21:48:04.912184+01 |
1576 | +125 maasserver 0115_additional_boot_resource_filetypes 2017-03-23 21:48:04.925405+01 |
1577 | +126 maasserver 0116_add_disabled_components_for_mirrors 2017-03-23 21:48:04.938516+01 |
1578 | +127 metadataserver 0003_remove_noderesult 2017-03-23 21:48:04.945473+01 |
1579 | +128 metadataserver 0004_aborted_script_status 2017-03-23 21:48:05.087102+01 |
1580 | +129 metadataserver 0005_store_powerstate_on_scriptset_creation 2017-03-23 21:48:05.188796+01 |
1581 | +130 metadataserver 0006_scriptresult_combined_output 2017-03-23 21:48:05.311946+01 |
1582 | +131 metadataserver 0007_migrate-commissioningscripts 2017-03-23 21:48:05.318655+01 |
1583 | +132 metadataserver 0008_remove-commissioningscripts 2017-03-23 21:48:05.32641+01 |
1584 | +133 metadataserver 0009_remove_noderesult_schema 2017-03-23 21:48:05.334301+01 |
1585 | +134 metadataserver 0010_scriptresult_time_and_script_title 2017-03-23 21:48:05.687889+01 |
1586 | +135 piston3 0002_auto_20151209_1652 2017-03-23 21:48:05.816619+01 |
1587 | +136 sessions 0001_initial 2017-03-23 21:48:05.826854+01 |
1588 | +137 sites 0001_initial 2017-03-23 21:48:05.835587+01 |
1589 | \. |
1590 | |
1591 | |
1592 | @@ -8415,7 +8577,7 @@ |
1593 | -- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
1594 | -- |
1595 | |
1596 | -SELECT pg_catalog.setval('django_migrations_id_seq', 119, true); |
1597 | +SELECT pg_catalog.setval('django_migrations_id_seq', 137, true); |
1598 | |
1599 | |
1600 | -- |
1601 | @@ -8461,7 +8623,7 @@ |
1602 | -- Data for Name: maasserver_bmc; Type: TABLE DATA; Schema: public; Owner: - |
1603 | -- |
1604 | |
1605 | -COPY maasserver_bmc (id, created, updated, power_type, power_parameters, ip_address_id) FROM stdin; |
1606 | +COPY maasserver_bmc (id, created, updated, power_type, power_parameters, ip_address_id, architectures, bmc_type, capabilities, cores, cpu_speed, local_disks, local_storage, memory, name) FROM stdin; |
1607 | \. |
1608 | |
1609 | |
1610 | @@ -8593,36 +8755,6 @@ |
1611 | |
1612 | |
1613 | -- |
1614 | --- Data for Name: maasserver_chassishints; Type: TABLE DATA; Schema: public; Owner: - |
1615 | --- |
1616 | - |
1617 | -COPY maasserver_chassishints (id, cores, memory, local_storage, chassis_id) FROM stdin; |
1618 | -\. |
1619 | - |
1620 | - |
1621 | --- |
1622 | --- Name: maasserver_chassishints_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
1623 | --- |
1624 | - |
1625 | -SELECT pg_catalog.setval('maasserver_chassishints_id_seq', 1, false); |
1626 | - |
1627 | - |
1628 | --- |
1629 | --- Data for Name: maasserver_componenterror; Type: TABLE DATA; Schema: public; Owner: - |
1630 | --- |
1631 | - |
1632 | -COPY maasserver_componenterror (id, created, updated, component, error) FROM stdin; |
1633 | -\. |
1634 | - |
1635 | - |
1636 | --- |
1637 | --- Name: maasserver_componenterror_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
1638 | --- |
1639 | - |
1640 | -SELECT pg_catalog.setval('maasserver_componenterror_id_seq', 1, false); |
1641 | - |
1642 | - |
1643 | --- |
1644 | -- Data for Name: maasserver_config; Type: TABLE DATA; Schema: public; Owner: - |
1645 | -- |
1646 | |
1647 | @@ -8672,7 +8804,7 @@ |
1648 | -- |
1649 | |
1650 | COPY maasserver_dnspublication (id, serial, created, source) FROM stdin; |
1651 | -1 1 2017-01-10 10:30:32.917359-08 Initial publication |
1652 | +1 1 2017-03-23 21:47:52.182266+01 Initial publication |
1653 | \. |
1654 | |
1655 | |
1656 | @@ -8718,7 +8850,7 @@ |
1657 | -- |
1658 | |
1659 | COPY maasserver_domain (id, created, updated, name, authoritative, ttl) FROM stdin; |
1660 | -0 2017-01-10 10:30:26.296446-08 2017-01-10 10:30:26.296446-08 maas t \N |
1661 | +0 2017-03-23 21:47:42.988411+01 2017-03-23 21:47:42.988411+01 maas t \N |
1662 | \. |
1663 | |
1664 | |
1665 | @@ -8764,7 +8896,7 @@ |
1666 | -- |
1667 | |
1668 | COPY maasserver_fabric (id, created, updated, name, class_type, description) FROM stdin; |
1669 | -0 2017-01-10 10:30:37.79185-08 2017-01-10 10:30:37.774584-08 fabric-0 \N |
1670 | +0 2017-03-23 21:47:58.844986+01 2017-03-23 21:47:58.826294+01 fabric-0 \N |
1671 | \. |
1672 | |
1673 | |
1674 | @@ -8974,7 +9106,7 @@ |
1675 | -- Data for Name: maasserver_node; Type: TABLE DATA; Schema: public; Owner: - |
1676 | -- |
1677 | |
1678 | -COPY maasserver_node (id, created, updated, system_id, hostname, status, bios_boot_method, osystem, distro_series, architecture, min_hwe_kernel, hwe_kernel, agent_name, error_description, cpu_count, memory, swap_size, instance_power_parameters, power_state, power_state_updated, error, netboot, license_key, boot_cluster_ip, enable_ssh, skip_networking, skip_storage, boot_interface_id, gateway_link_ipv4_id, gateway_link_ipv6_id, owner_id, parent_id, token_id, zone_id, boot_disk_id, node_type, domain_id, dns_process_id, bmc_id, address_ttl, status_expires, power_state_queried, url, managing_process_id, last_image_sync, previous_status, default_user, cpu_speed, dynamic, current_commissioning_script_set_id, current_installation_script_set_id, current_testing_script_set_id) FROM stdin; |
1679 | +COPY maasserver_node (id, created, updated, system_id, hostname, status, bios_boot_method, osystem, distro_series, architecture, min_hwe_kernel, hwe_kernel, agent_name, error_description, cpu_count, memory, swap_size, instance_power_parameters, power_state, power_state_updated, error, netboot, license_key, boot_cluster_ip, enable_ssh, skip_networking, skip_storage, boot_interface_id, gateway_link_ipv4_id, gateway_link_ipv6_id, owner_id, parent_id, token_id, zone_id, boot_disk_id, node_type, domain_id, dns_process_id, bmc_id, address_ttl, status_expires, power_state_queried, url, managing_process_id, last_image_sync, previous_status, default_user, cpu_speed, current_commissioning_script_set_id, current_installation_script_set_id, current_testing_script_set_id, creation_type) FROM stdin; |
1680 | \. |
1681 | |
1682 | |
1683 | @@ -9019,7 +9151,7 @@ |
1684 | -- Data for Name: maasserver_notification; Type: TABLE DATA; Schema: public; Owner: - |
1685 | -- |
1686 | |
1687 | -COPY maasserver_notification (id, created, updated, ident, users, admins, message, context, user_id) FROM stdin; |
1688 | +COPY maasserver_notification (id, created, updated, ident, users, admins, message, context, user_id, category) FROM stdin; |
1689 | \. |
1690 | |
1691 | |
1692 | @@ -9064,9 +9196,9 @@ |
1693 | -- Data for Name: maasserver_packagerepository; Type: TABLE DATA; Schema: public; Owner: - |
1694 | -- |
1695 | |
1696 | -COPY maasserver_packagerepository (id, created, updated, name, url, components, arches, key, "default", enabled, disabled_pockets, distributions) FROM stdin; |
1697 | -1 2017-01-10 10:30:34.229459-08 2017-01-10 10:30:34.229459-08 main_archive http://archive.ubuntu.com/ubuntu {} {amd64,i386} t t {} {} |
1698 | -2 2017-01-10 10:30:34.229459-08 2017-01-10 10:30:34.229459-08 ports_archive http://ports.ubuntu.com/ubuntu-ports {} {armhf,arm64,ppc64el} t t {} {} |
1699 | +COPY maasserver_packagerepository (id, created, updated, name, url, components, arches, key, "default", enabled, disabled_pockets, distributions, disabled_components) FROM stdin; |
1700 | +1 2017-03-23 21:47:53.824969+01 2017-03-23 21:47:53.824969+01 main_archive http://archive.ubuntu.com/ubuntu {} {amd64,i386} t t {} {} {} |
1701 | +2 2017-03-23 21:47:53.824969+01 2017-03-23 21:47:53.824969+01 ports_archive http://ports.ubuntu.com/ubuntu-ports {} {armhf,arm64,ppc64el} t t {} {} {} |
1702 | \. |
1703 | |
1704 | |
1705 | @@ -9116,6 +9248,21 @@ |
1706 | |
1707 | |
1708 | -- |
1709 | +-- Data for Name: maasserver_podhints; Type: TABLE DATA; Schema: public; Owner: - |
1710 | +-- |
1711 | + |
1712 | +COPY maasserver_podhints (id, cores, memory, local_storage, local_disks, pod_id) FROM stdin; |
1713 | +\. |
1714 | + |
1715 | + |
1716 | +-- |
1717 | +-- Name: maasserver_podhints_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
1718 | +-- |
1719 | + |
1720 | +SELECT pg_catalog.setval('maasserver_podhints_id_seq', 1, false); |
1721 | + |
1722 | + |
1723 | +-- |
1724 | -- Data for Name: maasserver_rdns; Type: TABLE DATA; Schema: public; Owner: - |
1725 | -- |
1726 | |
1727 | @@ -9353,7 +9500,7 @@ |
1728 | -- |
1729 | |
1730 | COPY maasserver_vlan (id, created, updated, name, vid, mtu, fabric_id, dhcp_on, primary_rack_id, secondary_rack_id, external_dhcp, description, relay_vlan_id, space_id) FROM stdin; |
1731 | -5001 2017-01-10 10:30:37.774584-08 2017-01-10 10:30:37.774584-08 Default VLAN 0 1500 0 f \N \N \N \N \N |
1732 | +5001 2017-03-23 21:47:58.826294+01 2017-03-23 21:47:58.826294+01 Default VLAN 0 1500 0 f \N \N \N \N \N |
1733 | \. |
1734 | |
1735 | |
1736 | @@ -9369,7 +9516,7 @@ |
1737 | -- |
1738 | |
1739 | COPY maasserver_zone (id, created, updated, name, description) FROM stdin; |
1740 | -1 2017-01-10 10:30:24.186679-08 2017-01-10 10:30:24.186679-08 default |
1741 | +1 2017-03-23 21:47:40.322875+01 2017-03-23 21:47:40.322875+01 default |
1742 | \. |
1743 | |
1744 | |
1745 | @@ -9388,21 +9535,6 @@ |
1746 | |
1747 | |
1748 | -- |
1749 | --- Data for Name: metadataserver_commissioningscript; Type: TABLE DATA; Schema: public; Owner: - |
1750 | --- |
1751 | - |
1752 | -COPY metadataserver_commissioningscript (id, name, content) FROM stdin; |
1753 | -\. |
1754 | - |
1755 | - |
1756 | --- |
1757 | --- Name: metadataserver_commissioningscript_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
1758 | --- |
1759 | - |
1760 | -SELECT pg_catalog.setval('metadataserver_commissioningscript_id_seq', 1, false); |
1761 | - |
1762 | - |
1763 | --- |
1764 | -- Data for Name: metadataserver_nodekey; Type: TABLE DATA; Schema: public; Owner: - |
1765 | -- |
1766 | |
1767 | @@ -9436,7 +9568,7 @@ |
1768 | -- Data for Name: metadataserver_script; Type: TABLE DATA; Schema: public; Owner: - |
1769 | -- |
1770 | |
1771 | -COPY metadataserver_script (id, created, updated, name, description, tags, script_type, timeout, destructive, "default", script_id) FROM stdin; |
1772 | +COPY metadataserver_script (id, created, updated, name, description, tags, script_type, timeout, destructive, "default", script_id, title) FROM stdin; |
1773 | \. |
1774 | |
1775 | |
1776 | @@ -9451,7 +9583,7 @@ |
1777 | -- Data for Name: metadataserver_scriptresult; Type: TABLE DATA; Schema: public; Owner: - |
1778 | -- |
1779 | |
1780 | -COPY metadataserver_scriptresult (id, created, updated, status, exit_status, script_name, stdout, stderr, result, script_id, script_set_id, script_version_id) FROM stdin; |
1781 | +COPY metadataserver_scriptresult (id, created, updated, status, exit_status, script_name, stdout, stderr, result, script_id, script_set_id, script_version_id, output, ended, started) FROM stdin; |
1782 | \. |
1783 | |
1784 | |
1785 | @@ -9466,7 +9598,7 @@ |
1786 | -- Data for Name: metadataserver_scriptset; Type: TABLE DATA; Schema: public; Owner: - |
1787 | -- |
1788 | |
1789 | -COPY metadataserver_scriptset (id, last_ping, result_type, node_id) FROM stdin; |
1790 | +COPY metadataserver_scriptset (id, last_ping, result_type, node_id, power_state_before_transition) FROM stdin; |
1791 | \. |
1792 | |
1793 | |
1794 | @@ -9571,11 +9703,11 @@ |
1795 | |
1796 | |
1797 | -- |
1798 | --- Name: auth_user_email_5a5ed9e47947023_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1799 | +-- Name: auth_user_email_615bd60a40eb49c7_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1800 | -- |
1801 | |
1802 | ALTER TABLE ONLY auth_user |
1803 | - ADD CONSTRAINT auth_user_email_5a5ed9e47947023_uniq UNIQUE (email); |
1804 | + ADD CONSTRAINT auth_user_email_615bd60a40eb49c7_uniq UNIQUE (email); |
1805 | |
1806 | |
1807 | -- |
1808 | @@ -9627,11 +9759,11 @@ |
1809 | |
1810 | |
1811 | -- |
1812 | --- Name: django_content_type_app_label_2fea355b3ac2cf72_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1813 | +-- Name: django_content_type_app_label_65a5d9d6988a7fa8_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1814 | -- |
1815 | |
1816 | ALTER TABLE ONLY django_content_type |
1817 | - ADD CONSTRAINT django_content_type_app_label_2fea355b3ac2cf72_uniq UNIQUE (app_label, model); |
1818 | + ADD CONSTRAINT django_content_type_app_label_65a5d9d6988a7fa8_uniq UNIQUE (app_label, model); |
1819 | |
1820 | |
1821 | -- |
1822 | @@ -9667,11 +9799,11 @@ |
1823 | |
1824 | |
1825 | -- |
1826 | --- Name: maasserver_blockdevice_node_id_5938ac0a0c0c8629_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1827 | +-- Name: maasserver_blockdevice_node_id_61ed667b4723808c_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1828 | -- |
1829 | |
1830 | ALTER TABLE ONLY maasserver_blockdevice |
1831 | - ADD CONSTRAINT maasserver_blockdevice_node_id_5938ac0a0c0c8629_uniq UNIQUE (node_id, name); |
1832 | + ADD CONSTRAINT maasserver_blockdevice_node_id_61ed667b4723808c_uniq UNIQUE (node_id, name); |
1833 | |
1834 | |
1835 | -- |
1836 | @@ -9683,6 +9815,14 @@ |
1837 | |
1838 | |
1839 | -- |
1840 | +-- Name: maasserver_bmc_name_2403eaed8ac705_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1841 | +-- |
1842 | + |
1843 | +ALTER TABLE ONLY maasserver_bmc |
1844 | + ADD CONSTRAINT maasserver_bmc_name_2403eaed8ac705_uniq UNIQUE (name); |
1845 | + |
1846 | + |
1847 | +-- |
1848 | -- Name: maasserver_bmc_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
1849 | -- |
1850 | |
1851 | @@ -9691,11 +9831,11 @@ |
1852 | |
1853 | |
1854 | -- |
1855 | --- Name: maasserver_bmc_power_type_3556c1fd84b045c9_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1856 | +-- Name: maasserver_bmc_power_type_6d18b56557a45ba9_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1857 | -- |
1858 | |
1859 | ALTER TABLE ONLY maasserver_bmc |
1860 | - ADD CONSTRAINT maasserver_bmc_power_type_3556c1fd84b045c9_uniq UNIQUE (power_type, power_parameters, ip_address_id); |
1861 | + ADD CONSTRAINT maasserver_bmc_power_type_6d18b56557a45ba9_uniq UNIQUE (power_type, power_parameters, ip_address_id); |
1862 | |
1863 | |
1864 | -- |
1865 | @@ -9707,11 +9847,11 @@ |
1866 | |
1867 | |
1868 | -- |
1869 | --- Name: maasserver_bootresource_name_7a867957ec5edb5d_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1870 | +-- Name: maasserver_bootresource_name_1156cb7b42cf0633_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1871 | -- |
1872 | |
1873 | ALTER TABLE ONLY maasserver_bootresource |
1874 | - ADD CONSTRAINT maasserver_bootresource_name_7a867957ec5edb5d_uniq UNIQUE (name, architecture); |
1875 | + ADD CONSTRAINT maasserver_bootresource_name_1156cb7b42cf0633_uniq UNIQUE (name, architecture); |
1876 | |
1877 | |
1878 | -- |
1879 | @@ -9723,11 +9863,11 @@ |
1880 | |
1881 | |
1882 | -- |
1883 | --- Name: maasserver_bootresourcefi_resource_set_id_3cff8f4a9b17e697_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1884 | +-- Name: maasserver_bootresourcefi_resource_set_id_4819be9cc2291e17_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1885 | -- |
1886 | |
1887 | ALTER TABLE ONLY maasserver_bootresourcefile |
1888 | - ADD CONSTRAINT maasserver_bootresourcefi_resource_set_id_3cff8f4a9b17e697_uniq UNIQUE (resource_set_id, filename); |
1889 | + ADD CONSTRAINT maasserver_bootresourcefi_resource_set_id_4819be9cc2291e17_uniq UNIQUE (resource_set_id, filename); |
1890 | |
1891 | |
1892 | -- |
1893 | @@ -9747,11 +9887,11 @@ |
1894 | |
1895 | |
1896 | -- |
1897 | --- Name: maasserver_bootresourceset_resource_id_4a2769351e59d06b_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1898 | +-- Name: maasserver_bootresourceset_resource_id_63fdd5256f516802_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1899 | -- |
1900 | |
1901 | ALTER TABLE ONLY maasserver_bootresourceset |
1902 | - ADD CONSTRAINT maasserver_bootresourceset_resource_id_4a2769351e59d06b_uniq UNIQUE (resource_id, version); |
1903 | + ADD CONSTRAINT maasserver_bootresourceset_resource_id_63fdd5256f516802_uniq UNIQUE (resource_id, version); |
1904 | |
1905 | |
1906 | -- |
1907 | @@ -9779,11 +9919,11 @@ |
1908 | |
1909 | |
1910 | -- |
1911 | --- Name: maasserver_bootsourceselec_boot_source_id_246d27b1334bd901_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1912 | +-- Name: maasserver_bootsourceselec_boot_source_id_63663e9f2a8d890e_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1913 | -- |
1914 | |
1915 | ALTER TABLE ONLY maasserver_bootsourceselection |
1916 | - ADD CONSTRAINT maasserver_bootsourceselec_boot_source_id_246d27b1334bd901_uniq UNIQUE (boot_source_id, os, release); |
1917 | + ADD CONSTRAINT maasserver_bootsourceselec_boot_source_id_63663e9f2a8d890e_uniq UNIQUE (boot_source_id, os, release); |
1918 | |
1919 | |
1920 | -- |
1921 | @@ -9803,38 +9943,6 @@ |
1922 | |
1923 | |
1924 | -- |
1925 | --- Name: maasserver_chassishints_chassis_id_key; Type: CONSTRAINT; Schema: public; Owner: - |
1926 | --- |
1927 | - |
1928 | -ALTER TABLE ONLY maasserver_chassishints |
1929 | - ADD CONSTRAINT maasserver_chassishints_chassis_id_key UNIQUE (chassis_id); |
1930 | - |
1931 | - |
1932 | --- |
1933 | --- Name: maasserver_chassishints_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
1934 | --- |
1935 | - |
1936 | -ALTER TABLE ONLY maasserver_chassishints |
1937 | - ADD CONSTRAINT maasserver_chassishints_pkey PRIMARY KEY (id); |
1938 | - |
1939 | - |
1940 | --- |
1941 | --- Name: maasserver_componenterror_component_key; Type: CONSTRAINT; Schema: public; Owner: - |
1942 | --- |
1943 | - |
1944 | -ALTER TABLE ONLY maasserver_componenterror |
1945 | - ADD CONSTRAINT maasserver_componenterror_component_key UNIQUE (component); |
1946 | - |
1947 | - |
1948 | --- |
1949 | --- Name: maasserver_componenterror_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
1950 | --- |
1951 | - |
1952 | -ALTER TABLE ONLY maasserver_componenterror |
1953 | - ADD CONSTRAINT maasserver_componenterror_pkey PRIMARY KEY (id); |
1954 | - |
1955 | - |
1956 | --- |
1957 | -- Name: maasserver_config_name_key; Type: CONSTRAINT; Schema: public; Owner: - |
1958 | -- |
1959 | |
1960 | @@ -9939,11 +10047,11 @@ |
1961 | |
1962 | |
1963 | -- |
1964 | --- Name: maasserver_fabric_name_2f92526e4f01fcd0_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1965 | +-- Name: maasserver_fabric_name_5f7a46a7fc709d58_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1966 | -- |
1967 | |
1968 | ALTER TABLE ONLY maasserver_fabric |
1969 | - ADD CONSTRAINT maasserver_fabric_name_2f92526e4f01fcd0_uniq UNIQUE (name); |
1970 | + ADD CONSTRAINT maasserver_fabric_name_5f7a46a7fc709d58_uniq UNIQUE (name); |
1971 | |
1972 | |
1973 | -- |
1974 | @@ -9987,11 +10095,11 @@ |
1975 | |
1976 | |
1977 | -- |
1978 | --- Name: maasserver_filestorage_filename_3d496b77294343ad_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1979 | +-- Name: maasserver_filestorage_filename_67e1c1567ef6d9a1_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1980 | -- |
1981 | |
1982 | ALTER TABLE ONLY maasserver_filestorage |
1983 | - ADD CONSTRAINT maasserver_filestorage_filename_3d496b77294343ad_uniq UNIQUE (filename, owner_id); |
1984 | + ADD CONSTRAINT maasserver_filestorage_filename_67e1c1567ef6d9a1_uniq UNIQUE (filename, owner_id); |
1985 | |
1986 | |
1987 | -- |
1988 | @@ -10011,19 +10119,19 @@ |
1989 | |
1990 | |
1991 | -- |
1992 | --- Name: maasserver_filesystem_block_device_id_10d1a2204fd12199_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
1993 | --- |
1994 | - |
1995 | -ALTER TABLE ONLY maasserver_filesystem |
1996 | - ADD CONSTRAINT maasserver_filesystem_block_device_id_10d1a2204fd12199_uniq UNIQUE (block_device_id, acquired); |
1997 | - |
1998 | - |
1999 | --- |
2000 | --- Name: maasserver_filesystem_partition_id_5ff4060f75ec1c4b_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2001 | --- |
2002 | - |
2003 | -ALTER TABLE ONLY maasserver_filesystem |
2004 | - ADD CONSTRAINT maasserver_filesystem_partition_id_5ff4060f75ec1c4b_uniq UNIQUE (partition_id, acquired); |
2005 | +-- Name: maasserver_filesystem_block_device_id_34689361d585d768_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2006 | +-- |
2007 | + |
2008 | +ALTER TABLE ONLY maasserver_filesystem |
2009 | + ADD CONSTRAINT maasserver_filesystem_block_device_id_34689361d585d768_uniq UNIQUE (block_device_id, acquired); |
2010 | + |
2011 | + |
2012 | +-- |
2013 | +-- Name: maasserver_filesystem_partition_id_3f716444b2111ae_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2014 | +-- |
2015 | + |
2016 | +ALTER TABLE ONLY maasserver_filesystem |
2017 | + ADD CONSTRAINT maasserver_filesystem_partition_id_3f716444b2111ae_uniq UNIQUE (partition_id, acquired); |
2018 | |
2019 | |
2020 | -- |
2021 | @@ -10115,11 +10223,11 @@ |
2022 | |
2023 | |
2024 | -- |
2025 | --- Name: maasserver_licensekey_osystem_558b8a6d5ab65571_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2026 | +-- Name: maasserver_licensekey_osystem_7900a93e0c9711cb_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2027 | -- |
2028 | |
2029 | ALTER TABLE ONLY maasserver_licensekey |
2030 | - ADD CONSTRAINT maasserver_licensekey_osystem_558b8a6d5ab65571_uniq UNIQUE (osystem, distro_series); |
2031 | + ADD CONSTRAINT maasserver_licensekey_osystem_7900a93e0c9711cb_uniq UNIQUE (osystem, distro_series); |
2032 | |
2033 | |
2034 | -- |
2035 | @@ -10139,11 +10247,11 @@ |
2036 | |
2037 | |
2038 | -- |
2039 | --- Name: maasserver_neighbour_interface_id_5960e4363cc8129_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2040 | +-- Name: maasserver_neighbour_interface_id_7c4f2cdca0e8361f_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2041 | -- |
2042 | |
2043 | ALTER TABLE ONLY maasserver_neighbour |
2044 | - ADD CONSTRAINT maasserver_neighbour_interface_id_5960e4363cc8129_uniq UNIQUE (interface_id, vid, mac_address, ip); |
2045 | + ADD CONSTRAINT maasserver_neighbour_interface_id_7c4f2cdca0e8361f_uniq UNIQUE (interface_id, vid, mac_address, ip); |
2046 | |
2047 | |
2048 | -- |
2049 | @@ -10227,11 +10335,11 @@ |
2050 | |
2051 | |
2052 | -- |
2053 | --- Name: maasserver_ownerdata_node_id_100f161c7ca5c764_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2054 | +-- Name: maasserver_ownerdata_node_id_55d9e4dc29e2fad1_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2055 | -- |
2056 | |
2057 | ALTER TABLE ONLY maasserver_ownerdata |
2058 | - ADD CONSTRAINT maasserver_ownerdata_node_id_100f161c7ca5c764_uniq UNIQUE (node_id, key); |
2059 | + ADD CONSTRAINT maasserver_ownerdata_node_id_55d9e4dc29e2fad1_uniq UNIQUE (node_id, key); |
2060 | |
2061 | |
2062 | -- |
2063 | @@ -10291,11 +10399,27 @@ |
2064 | |
2065 | |
2066 | -- |
2067 | --- Name: maasserver_rdns_ip_1add3bdfe37d0f08_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2068 | +-- Name: maasserver_podhints_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
2069 | +-- |
2070 | + |
2071 | +ALTER TABLE ONLY maasserver_podhints |
2072 | + ADD CONSTRAINT maasserver_podhints_pkey PRIMARY KEY (id); |
2073 | + |
2074 | + |
2075 | +-- |
2076 | +-- Name: maasserver_podhints_pod_id_key; Type: CONSTRAINT; Schema: public; Owner: - |
2077 | +-- |
2078 | + |
2079 | +ALTER TABLE ONLY maasserver_podhints |
2080 | + ADD CONSTRAINT maasserver_podhints_pod_id_key UNIQUE (pod_id); |
2081 | + |
2082 | + |
2083 | +-- |
2084 | +-- Name: maasserver_rdns_ip_5a5493691e5bec70_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2085 | -- |
2086 | |
2087 | ALTER TABLE ONLY maasserver_rdns |
2088 | - ADD CONSTRAINT maasserver_rdns_ip_1add3bdfe37d0f08_uniq UNIQUE (ip, observer_id); |
2089 | + ADD CONSTRAINT maasserver_rdns_ip_5a5493691e5bec70_uniq UNIQUE (ip, observer_id); |
2090 | |
2091 | |
2092 | -- |
2093 | @@ -10307,19 +10431,19 @@ |
2094 | |
2095 | |
2096 | -- |
2097 | --- Name: maasserver_regioncontrollerpro_process_id_4e2a0d37417eea52_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2098 | +-- Name: maasserver_regioncontrollerpro_process_id_4af5d2c2d5cc34b2_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2099 | -- |
2100 | |
2101 | ALTER TABLE ONLY maasserver_regioncontrollerprocessendpoint |
2102 | - ADD CONSTRAINT maasserver_regioncontrollerpro_process_id_4e2a0d37417eea52_uniq UNIQUE (process_id, address, port); |
2103 | + ADD CONSTRAINT maasserver_regioncontrollerpro_process_id_4af5d2c2d5cc34b2_uniq UNIQUE (process_id, address, port); |
2104 | |
2105 | |
2106 | -- |
2107 | --- Name: maasserver_regioncontrollerproc_region_id_1934c97d30512489_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2108 | +-- Name: maasserver_regioncontrollerproc_region_id_717ffbd0a322b219_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2109 | -- |
2110 | |
2111 | ALTER TABLE ONLY maasserver_regioncontrollerprocess |
2112 | - ADD CONSTRAINT maasserver_regioncontrollerproc_region_id_1934c97d30512489_uniq UNIQUE (region_id, pid); |
2113 | + ADD CONSTRAINT maasserver_regioncontrollerproc_region_id_717ffbd0a322b219_uniq UNIQUE (region_id, pid); |
2114 | |
2115 | |
2116 | -- |
2117 | @@ -10339,11 +10463,11 @@ |
2118 | |
2119 | |
2120 | -- |
2121 | --- Name: maasserver_regionrackrpcconne_endpoint_id_705a162aecb0f936_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2122 | +-- Name: maasserver_regionrackrpcconne_endpoint_id_30c32aba1fef06d0_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2123 | -- |
2124 | |
2125 | ALTER TABLE ONLY maasserver_regionrackrpcconnection |
2126 | - ADD CONSTRAINT maasserver_regionrackrpcconne_endpoint_id_705a162aecb0f936_uniq UNIQUE (endpoint_id, rack_controller_id); |
2127 | + ADD CONSTRAINT maasserver_regionrackrpcconne_endpoint_id_30c32aba1fef06d0_uniq UNIQUE (endpoint_id, rack_controller_id); |
2128 | |
2129 | |
2130 | -- |
2131 | @@ -10355,11 +10479,11 @@ |
2132 | |
2133 | |
2134 | -- |
2135 | --- Name: maasserver_service_node_id_6c1146a7d4cfef26_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2136 | +-- Name: maasserver_service_node_id_1d8bde96619170fb_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2137 | -- |
2138 | |
2139 | ALTER TABLE ONLY maasserver_service |
2140 | - ADD CONSTRAINT maasserver_service_node_id_6c1146a7d4cfef26_uniq UNIQUE (node_id, name); |
2141 | + ADD CONSTRAINT maasserver_service_node_id_1d8bde96619170fb_uniq UNIQUE (node_id, name); |
2142 | |
2143 | |
2144 | -- |
2145 | @@ -10371,11 +10495,11 @@ |
2146 | |
2147 | |
2148 | -- |
2149 | --- Name: maasserver_space_name_d3c3741573ae10f_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2150 | +-- Name: maasserver_space_name_1a1bbcaafee2cf61_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2151 | -- |
2152 | |
2153 | ALTER TABLE ONLY maasserver_space |
2154 | - ADD CONSTRAINT maasserver_space_name_d3c3741573ae10f_uniq UNIQUE (name); |
2155 | + ADD CONSTRAINT maasserver_space_name_1a1bbcaafee2cf61_uniq UNIQUE (name); |
2156 | |
2157 | |
2158 | -- |
2159 | @@ -10395,11 +10519,11 @@ |
2160 | |
2161 | |
2162 | -- |
2163 | --- Name: maasserver_sshkey_user_id_6d71fd0d8d6f1adf_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2164 | +-- Name: maasserver_sshkey_user_id_3d713e65678d342e_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2165 | -- |
2166 | |
2167 | ALTER TABLE ONLY maasserver_sshkey |
2168 | - ADD CONSTRAINT maasserver_sshkey_user_id_6d71fd0d8d6f1adf_uniq UNIQUE (user_id, key, keysource_id); |
2169 | + ADD CONSTRAINT maasserver_sshkey_user_id_3d713e65678d342e_uniq UNIQUE (user_id, key, keysource_id); |
2170 | |
2171 | |
2172 | -- |
2173 | @@ -10411,11 +10535,11 @@ |
2174 | |
2175 | |
2176 | -- |
2177 | --- Name: maasserver_sslkey_user_id_42deba26692680a4_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2178 | +-- Name: maasserver_sslkey_user_id_7bd39f7198681dbf_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2179 | -- |
2180 | |
2181 | ALTER TABLE ONLY maasserver_sslkey |
2182 | - ADD CONSTRAINT maasserver_sslkey_user_id_42deba26692680a4_uniq UNIQUE (user_id, key); |
2183 | + ADD CONSTRAINT maasserver_sslkey_user_id_7bd39f7198681dbf_uniq UNIQUE (user_id, key); |
2184 | |
2185 | |
2186 | -- |
2187 | @@ -10443,11 +10567,11 @@ |
2188 | |
2189 | |
2190 | -- |
2191 | --- Name: maasserver_staticroute_source_id_75e86ec7a8727697_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2192 | +-- Name: maasserver_staticroute_source_id_1636df29e6d17f32_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2193 | -- |
2194 | |
2195 | ALTER TABLE ONLY maasserver_staticroute |
2196 | - ADD CONSTRAINT maasserver_staticroute_source_id_75e86ec7a8727697_uniq UNIQUE (source_id, destination_id, gateway_ip); |
2197 | + ADD CONSTRAINT maasserver_staticroute_source_id_1636df29e6d17f32_uniq UNIQUE (source_id, destination_id, gateway_ip); |
2198 | |
2199 | |
2200 | -- |
2201 | @@ -10547,11 +10671,11 @@ |
2202 | |
2203 | |
2204 | -- |
2205 | --- Name: maasserver_vlan_vid_c786a95248c70fe_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2206 | +-- Name: maasserver_vlan_vid_5e0af43ba1c72b24_uniq; Type: CONSTRAINT; Schema: public; Owner: - |
2207 | -- |
2208 | |
2209 | ALTER TABLE ONLY maasserver_vlan |
2210 | - ADD CONSTRAINT maasserver_vlan_vid_c786a95248c70fe_uniq UNIQUE (vid, fabric_id); |
2211 | + ADD CONSTRAINT maasserver_vlan_vid_5e0af43ba1c72b24_uniq UNIQUE (vid, fabric_id); |
2212 | |
2213 | |
2214 | -- |
2215 | @@ -10571,22 +10695,6 @@ |
2216 | |
2217 | |
2218 | -- |
2219 | --- Name: metadataserver_commissioningscript_name_key; Type: CONSTRAINT; Schema: public; Owner: - |
2220 | --- |
2221 | - |
2222 | -ALTER TABLE ONLY metadataserver_commissioningscript |
2223 | - ADD CONSTRAINT metadataserver_commissioningscript_name_key UNIQUE (name); |
2224 | - |
2225 | - |
2226 | --- |
2227 | --- Name: metadataserver_commissioningscript_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
2228 | --- |
2229 | - |
2230 | -ALTER TABLE ONLY metadataserver_commissioningscript |
2231 | - ADD CONSTRAINT metadataserver_commissioningscript_pkey PRIMARY KEY (id); |
2232 | - |
2233 | - |
2234 | --- |
2235 | -- Name: metadataserver_nodekey_key_key; Type: CONSTRAINT; Schema: public; Owner: - |
2236 | -- |
2237 | |
2238 | @@ -10699,10 +10807,10 @@ |
2239 | |
2240 | |
2241 | -- |
2242 | --- Name: auth_group_name_38a30f011f611ad4_like; Type: INDEX; Schema: public; Owner: - |
2243 | +-- Name: auth_group_name_4a85116491e2e245_like; Type: INDEX; Schema: public; Owner: - |
2244 | -- |
2245 | |
2246 | -CREATE INDEX auth_group_name_38a30f011f611ad4_like ON auth_group USING btree (name varchar_pattern_ops); |
2247 | +CREATE INDEX auth_group_name_4a85116491e2e245_like ON auth_group USING btree (name varchar_pattern_ops); |
2248 | |
2249 | |
2250 | -- |
2251 | @@ -10755,10 +10863,10 @@ |
2252 | |
2253 | |
2254 | -- |
2255 | --- Name: auth_user_username_2dad4f030f3bc17e_like; Type: INDEX; Schema: public; Owner: - |
2256 | +-- Name: auth_user_username_1d81623265744713_like; Type: INDEX; Schema: public; Owner: - |
2257 | -- |
2258 | |
2259 | -CREATE INDEX auth_user_username_2dad4f030f3bc17e_like ON auth_user USING btree (username varchar_pattern_ops); |
2260 | +CREATE INDEX auth_user_username_1d81623265744713_like ON auth_user USING btree (username varchar_pattern_ops); |
2261 | |
2262 | |
2263 | -- |
2264 | @@ -10769,10 +10877,10 @@ |
2265 | |
2266 | |
2267 | -- |
2268 | --- Name: django_session_session_key_1fe2fa8803092e73_like; Type: INDEX; Schema: public; Owner: - |
2269 | +-- Name: django_session_session_key_2e22e38c7909b1a_like; Type: INDEX; Schema: public; Owner: - |
2270 | -- |
2271 | |
2272 | -CREATE INDEX django_session_session_key_1fe2fa8803092e73_like ON django_session USING btree (session_key varchar_pattern_ops); |
2273 | +CREATE INDEX django_session_session_key_2e22e38c7909b1a_like ON django_session USING btree (session_key varchar_pattern_ops); |
2274 | |
2275 | |
2276 | -- |
2277 | @@ -10825,10 +10933,10 @@ |
2278 | |
2279 | |
2280 | -- |
2281 | --- Name: maasserver_bootsource_url_39cd33782b00b124_like; Type: INDEX; Schema: public; Owner: - |
2282 | +-- Name: maasserver_bootsource_url_3c19af436b14de47_like; Type: INDEX; Schema: public; Owner: - |
2283 | -- |
2284 | |
2285 | -CREATE INDEX maasserver_bootsource_url_39cd33782b00b124_like ON maasserver_bootsource USING btree (url varchar_pattern_ops); |
2286 | +CREATE INDEX maasserver_bootsource_url_3c19af436b14de47_like ON maasserver_bootsource USING btree (url varchar_pattern_ops); |
2287 | |
2288 | |
2289 | -- |
2290 | @@ -10846,17 +10954,10 @@ |
2291 | |
2292 | |
2293 | -- |
2294 | --- Name: maasserver_componenterror_component_5e210db3f0e741fb_like; Type: INDEX; Schema: public; Owner: - |
2295 | --- |
2296 | - |
2297 | -CREATE INDEX maasserver_componenterror_component_5e210db3f0e741fb_like ON maasserver_componenterror USING btree (component varchar_pattern_ops); |
2298 | - |
2299 | - |
2300 | --- |
2301 | --- Name: maasserver_config_name_7c1d163efce4b8fe_like; Type: INDEX; Schema: public; Owner: - |
2302 | --- |
2303 | - |
2304 | -CREATE INDEX maasserver_config_name_7c1d163efce4b8fe_like ON maasserver_config USING btree (name varchar_pattern_ops); |
2305 | +-- Name: maasserver_config_name_126cf8badee6303f_like; Type: INDEX; Schema: public; Owner: - |
2306 | +-- |
2307 | + |
2308 | +CREATE INDEX maasserver_config_name_126cf8badee6303f_like ON maasserver_config USING btree (name varchar_pattern_ops); |
2309 | |
2310 | |
2311 | -- |
2312 | @@ -10916,10 +11017,10 @@ |
2313 | |
2314 | |
2315 | -- |
2316 | --- Name: maasserver_domain_name_6794b96199f4fa1a_like; Type: INDEX; Schema: public; Owner: - |
2317 | +-- Name: maasserver_domain_name_e8a0d5e94d96ed_like; Type: INDEX; Schema: public; Owner: - |
2318 | -- |
2319 | |
2320 | -CREATE INDEX maasserver_domain_name_6794b96199f4fa1a_like ON maasserver_domain USING btree (name varchar_pattern_ops); |
2321 | +CREATE INDEX maasserver_domain_name_e8a0d5e94d96ed_like ON maasserver_domain USING btree (name varchar_pattern_ops); |
2322 | |
2323 | |
2324 | -- |
2325 | @@ -10937,10 +11038,10 @@ |
2326 | |
2327 | |
2328 | -- |
2329 | --- Name: maasserver_event_node_id_2553aa26ab376d5e_idx; Type: INDEX; Schema: public; Owner: - |
2330 | +-- Name: maasserver_event_node_id_6a80e8a054ded994_idx; Type: INDEX; Schema: public; Owner: - |
2331 | -- |
2332 | |
2333 | -CREATE INDEX maasserver_event_node_id_2553aa26ab376d5e_idx ON maasserver_event USING btree (node_id, id); |
2334 | +CREATE INDEX maasserver_event_node_id_6a80e8a054ded994_idx ON maasserver_event USING btree (node_id, id); |
2335 | |
2336 | |
2337 | -- |
2338 | @@ -10951,17 +11052,17 @@ |
2339 | |
2340 | |
2341 | -- |
2342 | --- Name: maasserver_eventtype_name_4960ba61f283c74b_like; Type: INDEX; Schema: public; Owner: - |
2343 | --- |
2344 | - |
2345 | -CREATE INDEX maasserver_eventtype_name_4960ba61f283c74b_like ON maasserver_eventtype USING btree (name varchar_pattern_ops); |
2346 | - |
2347 | - |
2348 | --- |
2349 | --- Name: maasserver_fannetwork_name_4a3d49465daa9e38_like; Type: INDEX; Schema: public; Owner: - |
2350 | --- |
2351 | - |
2352 | -CREATE INDEX maasserver_fannetwork_name_4a3d49465daa9e38_like ON maasserver_fannetwork USING btree (name varchar_pattern_ops); |
2353 | +-- Name: maasserver_eventtype_name_467950bf75296c86_like; Type: INDEX; Schema: public; Owner: - |
2354 | +-- |
2355 | + |
2356 | +CREATE INDEX maasserver_eventtype_name_467950bf75296c86_like ON maasserver_eventtype USING btree (name varchar_pattern_ops); |
2357 | + |
2358 | + |
2359 | +-- |
2360 | +-- Name: maasserver_fannetwork_name_37af7416b0c3595a_like; Type: INDEX; Schema: public; Owner: - |
2361 | +-- |
2362 | + |
2363 | +CREATE INDEX maasserver_fannetwork_name_37af7416b0c3595a_like ON maasserver_fannetwork USING btree (name varchar_pattern_ops); |
2364 | |
2365 | |
2366 | -- |
2367 | @@ -10972,10 +11073,10 @@ |
2368 | |
2369 | |
2370 | -- |
2371 | --- Name: maasserver_filestorage_key_269f6b20453eb763_like; Type: INDEX; Schema: public; Owner: - |
2372 | +-- Name: maasserver_filestorage_key_208c1b70647df11c_like; Type: INDEX; Schema: public; Owner: - |
2373 | -- |
2374 | |
2375 | -CREATE INDEX maasserver_filestorage_key_269f6b20453eb763_like ON maasserver_filestorage USING btree (key varchar_pattern_ops); |
2376 | +CREATE INDEX maasserver_filestorage_key_208c1b70647df11c_like ON maasserver_filestorage USING btree (key varchar_pattern_ops); |
2377 | |
2378 | |
2379 | -- |
2380 | @@ -11021,10 +11122,10 @@ |
2381 | |
2382 | |
2383 | -- |
2384 | --- Name: maasserver_filesystemgroup_uuid_b24b3f5e011a86_like; Type: INDEX; Schema: public; Owner: - |
2385 | +-- Name: maasserver_filesystemgroup_uuid_78029343fdfb02bf_like; Type: INDEX; Schema: public; Owner: - |
2386 | -- |
2387 | |
2388 | -CREATE INDEX maasserver_filesystemgroup_uuid_b24b3f5e011a86_like ON maasserver_filesystemgroup USING btree (uuid varchar_pattern_ops); |
2389 | +CREATE INDEX maasserver_filesystemgroup_uuid_78029343fdfb02bf_like ON maasserver_filesystemgroup USING btree (uuid varchar_pattern_ops); |
2390 | |
2391 | |
2392 | -- |
2393 | @@ -11084,10 +11185,10 @@ |
2394 | |
2395 | |
2396 | -- |
2397 | --- Name: maasserver_largefile_sha256_32229a9556e542ca_like; Type: INDEX; Schema: public; Owner: - |
2398 | +-- Name: maasserver_largefile_sha256_424761b962d7977b_like; Type: INDEX; Schema: public; Owner: - |
2399 | -- |
2400 | |
2401 | -CREATE INDEX maasserver_largefile_sha256_32229a9556e542ca_like ON maasserver_largefile USING btree (sha256 varchar_pattern_ops); |
2402 | +CREATE INDEX maasserver_largefile_sha256_424761b962d7977b_like ON maasserver_largefile USING btree (sha256 varchar_pattern_ops); |
2403 | |
2404 | |
2405 | -- |
2406 | @@ -11203,17 +11304,17 @@ |
2407 | |
2408 | |
2409 | -- |
2410 | --- Name: maasserver_node_hostname_27627fb596fc4c1a_like; Type: INDEX; Schema: public; Owner: - |
2411 | --- |
2412 | - |
2413 | -CREATE INDEX maasserver_node_hostname_27627fb596fc4c1a_like ON maasserver_node USING btree (hostname varchar_pattern_ops); |
2414 | - |
2415 | - |
2416 | --- |
2417 | --- Name: maasserver_node_system_id_2f29f9e2a76f415c_like; Type: INDEX; Schema: public; Owner: - |
2418 | --- |
2419 | - |
2420 | -CREATE INDEX maasserver_node_system_id_2f29f9e2a76f415c_like ON maasserver_node USING btree (system_id varchar_pattern_ops); |
2421 | +-- Name: maasserver_node_hostname_69b5e99c5cc9856d_like; Type: INDEX; Schema: public; Owner: - |
2422 | +-- |
2423 | + |
2424 | +CREATE INDEX maasserver_node_hostname_69b5e99c5cc9856d_like ON maasserver_node USING btree (hostname varchar_pattern_ops); |
2425 | + |
2426 | + |
2427 | +-- |
2428 | +-- Name: maasserver_node_system_id_756fe2bb78d1bab1_like; Type: INDEX; Schema: public; Owner: - |
2429 | +-- |
2430 | + |
2431 | +CREATE INDEX maasserver_node_system_id_756fe2bb78d1bab1_like ON maasserver_node USING btree (system_id varchar_pattern_ops); |
2432 | |
2433 | |
2434 | -- |
2435 | @@ -11273,10 +11374,10 @@ |
2436 | |
2437 | |
2438 | -- |
2439 | --- Name: maasserver_packagerepository_name_52d9145560987d1f_like; Type: INDEX; Schema: public; Owner: - |
2440 | +-- Name: maasserver_packagerepository_name_566705bd7af62b9a_like; Type: INDEX; Schema: public; Owner: - |
2441 | -- |
2442 | |
2443 | -CREATE INDEX maasserver_packagerepository_name_52d9145560987d1f_like ON maasserver_packagerepository USING btree (name varchar_pattern_ops); |
2444 | +CREATE INDEX maasserver_packagerepository_name_566705bd7af62b9a_like ON maasserver_packagerepository USING btree (name varchar_pattern_ops); |
2445 | |
2446 | |
2447 | -- |
2448 | @@ -11287,10 +11388,10 @@ |
2449 | |
2450 | |
2451 | -- |
2452 | --- Name: maasserver_partition_uuid_7f5b37f99f99617d_like; Type: INDEX; Schema: public; Owner: - |
2453 | +-- Name: maasserver_partition_uuid_2af63caf42b4083b_like; Type: INDEX; Schema: public; Owner: - |
2454 | -- |
2455 | |
2456 | -CREATE INDEX maasserver_partition_uuid_7f5b37f99f99617d_like ON maasserver_partition USING btree (uuid varchar_pattern_ops); |
2457 | +CREATE INDEX maasserver_partition_uuid_2af63caf42b4083b_like ON maasserver_partition USING btree (uuid varchar_pattern_ops); |
2458 | |
2459 | |
2460 | -- |
2461 | @@ -11399,10 +11500,10 @@ |
2462 | |
2463 | |
2464 | -- |
2465 | --- Name: maasserver_tag_name_1d9c8923e459f4bc_like; Type: INDEX; Schema: public; Owner: - |
2466 | +-- Name: maasserver_tag_name_bc4471be2d702b6_like; Type: INDEX; Schema: public; Owner: - |
2467 | -- |
2468 | |
2469 | -CREATE INDEX maasserver_tag_name_1d9c8923e459f4bc_like ON maasserver_tag USING btree (name varchar_pattern_ops); |
2470 | +CREATE INDEX maasserver_tag_name_bc4471be2d702b6_like ON maasserver_tag USING btree (name varchar_pattern_ops); |
2471 | |
2472 | |
2473 | -- |
2474 | @@ -11420,10 +11521,10 @@ |
2475 | |
2476 | |
2477 | -- |
2478 | --- Name: maasserver_template_filename_372f9a931f4ec2f9_like; Type: INDEX; Schema: public; Owner: - |
2479 | +-- Name: maasserver_template_filename_6ac38a772a3a93f0_like; Type: INDEX; Schema: public; Owner: - |
2480 | -- |
2481 | |
2482 | -CREATE INDEX maasserver_template_filename_372f9a931f4ec2f9_like ON maasserver_template USING btree (filename varchar_pattern_ops); |
2483 | +CREATE INDEX maasserver_template_filename_6ac38a772a3a93f0_like ON maasserver_template USING btree (filename varchar_pattern_ops); |
2484 | |
2485 | |
2486 | -- |
2487 | @@ -11441,10 +11542,10 @@ |
2488 | |
2489 | |
2490 | -- |
2491 | --- Name: maasserver_virtualblockdevice_uuid_49a3743cb26e8940_like; Type: INDEX; Schema: public; Owner: - |
2492 | +-- Name: maasserver_virtualblockdevice_uuid_74a225e176fedef1_like; Type: INDEX; Schema: public; Owner: - |
2493 | -- |
2494 | |
2495 | -CREATE INDEX maasserver_virtualblockdevice_uuid_49a3743cb26e8940_like ON maasserver_virtualblockdevice USING btree (uuid varchar_pattern_ops); |
2496 | +CREATE INDEX maasserver_virtualblockdevice_uuid_74a225e176fedef1_like ON maasserver_virtualblockdevice USING btree (uuid varchar_pattern_ops); |
2497 | |
2498 | |
2499 | -- |
2500 | @@ -11483,31 +11584,24 @@ |
2501 | |
2502 | |
2503 | -- |
2504 | --- Name: maasserver_zone_name_4a249361d3d2b6fb_like; Type: INDEX; Schema: public; Owner: - |
2505 | --- |
2506 | - |
2507 | -CREATE INDEX maasserver_zone_name_4a249361d3d2b6fb_like ON maasserver_zone USING btree (name varchar_pattern_ops); |
2508 | - |
2509 | - |
2510 | --- |
2511 | --- Name: metadataserver_commissioningscript_name_49404964796e9cdb_like; Type: INDEX; Schema: public; Owner: - |
2512 | --- |
2513 | - |
2514 | -CREATE INDEX metadataserver_commissioningscript_name_49404964796e9cdb_like ON metadataserver_commissioningscript USING btree (name varchar_pattern_ops); |
2515 | - |
2516 | - |
2517 | --- |
2518 | --- Name: metadataserver_nodekey_key_1bc4c3c7d491275f_like; Type: INDEX; Schema: public; Owner: - |
2519 | --- |
2520 | - |
2521 | -CREATE INDEX metadataserver_nodekey_key_1bc4c3c7d491275f_like ON metadataserver_nodekey USING btree (key varchar_pattern_ops); |
2522 | - |
2523 | - |
2524 | --- |
2525 | --- Name: metadataserver_script_name_39aa535750a9d325_like; Type: INDEX; Schema: public; Owner: - |
2526 | --- |
2527 | - |
2528 | -CREATE INDEX metadataserver_script_name_39aa535750a9d325_like ON metadataserver_script USING btree (name varchar_pattern_ops); |
2529 | +-- Name: maasserver_zone_name_63dc6f524ce7c18c_like; Type: INDEX; Schema: public; Owner: - |
2530 | +-- |
2531 | + |
2532 | +CREATE INDEX maasserver_zone_name_63dc6f524ce7c18c_like ON maasserver_zone USING btree (name varchar_pattern_ops); |
2533 | + |
2534 | + |
2535 | +-- |
2536 | +-- Name: metadataserver_nodekey_key_7fb2843a75c25b8b_like; Type: INDEX; Schema: public; Owner: - |
2537 | +-- |
2538 | + |
2539 | +CREATE INDEX metadataserver_nodekey_key_7fb2843a75c25b8b_like ON metadataserver_nodekey USING btree (key varchar_pattern_ops); |
2540 | + |
2541 | + |
2542 | +-- |
2543 | +-- Name: metadataserver_script_name_3ce57c4f136749f4_like; Type: INDEX; Schema: public; Owner: - |
2544 | +-- |
2545 | + |
2546 | +CREATE INDEX metadataserver_script_name_3ce57c4f136749f4_like ON metadataserver_script USING btree (name varchar_pattern_ops); |
2547 | |
2548 | |
2549 | -- |
2550 | @@ -11602,6 +11696,27 @@ |
2551 | |
2552 | |
2553 | -- |
2554 | +-- Name: bmc_pod_delete_notify; Type: TRIGGER; Schema: public; Owner: - |
2555 | +-- |
2556 | + |
2557 | +CREATE TRIGGER bmc_pod_delete_notify AFTER DELETE ON maasserver_bmc FOR EACH ROW EXECUTE PROCEDURE pod_delete_notify(); |
2558 | + |
2559 | + |
2560 | +-- |
2561 | +-- Name: bmc_pod_insert_notify; Type: TRIGGER; Schema: public; Owner: - |
2562 | +-- |
2563 | + |
2564 | +CREATE TRIGGER bmc_pod_insert_notify AFTER INSERT ON maasserver_bmc FOR EACH ROW EXECUTE PROCEDURE pod_insert_notify(); |
2565 | + |
2566 | + |
2567 | +-- |
2568 | +-- Name: bmc_pod_update_notify; Type: TRIGGER; Schema: public; Owner: - |
2569 | +-- |
2570 | + |
2571 | +CREATE TRIGGER bmc_pod_update_notify AFTER UPDATE ON maasserver_bmc FOR EACH ROW EXECUTE PROCEDURE pod_update_notify(); |
2572 | + |
2573 | + |
2574 | +-- |
2575 | -- Name: cacheset_nd_cacheset_link_notify; Type: TRIGGER; Schema: public; Owner: - |
2576 | -- |
2577 | |
2578 | @@ -12211,6 +12326,27 @@ |
2579 | |
2580 | |
2581 | -- |
2582 | +-- Name: node_node_pod_delete_notify; Type: TRIGGER; Schema: public; Owner: - |
2583 | +-- |
2584 | + |
2585 | +CREATE TRIGGER node_node_pod_delete_notify AFTER DELETE ON maasserver_node FOR EACH ROW EXECUTE PROCEDURE node_pod_delete_notify(); |
2586 | + |
2587 | + |
2588 | +-- |
2589 | +-- Name: node_node_pod_insert_notify; Type: TRIGGER; Schema: public; Owner: - |
2590 | +-- |
2591 | + |
2592 | +CREATE TRIGGER node_node_pod_insert_notify AFTER INSERT ON maasserver_node FOR EACH ROW EXECUTE PROCEDURE node_pod_insert_notify(); |
2593 | + |
2594 | + |
2595 | +-- |
2596 | +-- Name: node_node_pod_update_notify; Type: TRIGGER; Schema: public; Owner: - |
2597 | +-- |
2598 | + |
2599 | +CREATE TRIGGER node_node_pod_update_notify AFTER UPDATE ON maasserver_node FOR EACH ROW EXECUTE PROCEDURE node_pod_update_notify(); |
2600 | + |
2601 | + |
2602 | +-- |
2603 | -- Name: node_node_type_change_notify; Type: TRIGGER; Schema: public; Owner: - |
2604 | -- |
2605 | |
2606 | @@ -12316,6 +12452,34 @@ |
2607 | |
2608 | |
2609 | -- |
2610 | +-- Name: notification_notification_create_notify; Type: TRIGGER; Schema: public; Owner: - |
2611 | +-- |
2612 | + |
2613 | +CREATE TRIGGER notification_notification_create_notify AFTER INSERT ON maasserver_notification FOR EACH ROW EXECUTE PROCEDURE notification_create_notify(); |
2614 | + |
2615 | + |
2616 | +-- |
2617 | +-- Name: notification_notification_delete_notify; Type: TRIGGER; Schema: public; Owner: - |
2618 | +-- |
2619 | + |
2620 | +CREATE TRIGGER notification_notification_delete_notify AFTER DELETE ON maasserver_notification FOR EACH ROW EXECUTE PROCEDURE notification_delete_notify(); |
2621 | + |
2622 | + |
2623 | +-- |
2624 | +-- Name: notification_notification_update_notify; Type: TRIGGER; Schema: public; Owner: - |
2625 | +-- |
2626 | + |
2627 | +CREATE TRIGGER notification_notification_update_notify AFTER UPDATE ON maasserver_notification FOR EACH ROW EXECUTE PROCEDURE notification_update_notify(); |
2628 | + |
2629 | + |
2630 | +-- |
2631 | +-- Name: notificationdismissal_notificationdismissal_create_notify; Type: TRIGGER; Schema: public; Owner: - |
2632 | +-- |
2633 | + |
2634 | +CREATE TRIGGER notificationdismissal_notificationdismissal_create_notify AFTER INSERT ON maasserver_notificationdismissal FOR EACH ROW EXECUTE PROCEDURE notificationdismissal_create_notify(); |
2635 | + |
2636 | + |
2637 | +-- |
2638 | -- Name: packagerepository_packagerepository_create_notify; Type: TRIGGER; Schema: public; Owner: - |
2639 | -- |
2640 | |
2641 | @@ -12757,835 +12921,835 @@ |
2642 | |
2643 | |
2644 | -- |
2645 | --- Name: D07b44ef84d027bec1fb6e68629dcb2f; Type: FK CONSTRAINT; Schema: public; Owner: - |
2646 | --- |
2647 | - |
2648 | -ALTER TABLE ONLY maasserver_node |
2649 | - ADD CONSTRAINT "D07b44ef84d027bec1fb6e68629dcb2f" FOREIGN KEY (current_testing_script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
2650 | - |
2651 | - |
2652 | --- |
2653 | --- Name: D0f22e99ba0ac2c74a70420a319eb05b; Type: FK CONSTRAINT; Schema: public; Owner: - |
2654 | --- |
2655 | - |
2656 | -ALTER TABLE ONLY maasserver_regioncontrollerprocessendpoint |
2657 | - ADD CONSTRAINT "D0f22e99ba0ac2c74a70420a319eb05b" FOREIGN KEY (process_id) REFERENCES maasserver_regioncontrollerprocess(id) DEFERRABLE INITIALLY DEFERRED; |
2658 | - |
2659 | - |
2660 | --- |
2661 | --- Name: D1070196201dec7c9634d69f7e2a0c91; Type: FK CONSTRAINT; Schema: public; Owner: - |
2662 | +-- Name: D01c4bc8ec3a44341e022ef0dc975639; Type: FK CONSTRAINT; Schema: public; Owner: - |
2663 | -- |
2664 | |
2665 | ALTER TABLE ONLY maasserver_virtualblockdevice |
2666 | - ADD CONSTRAINT "D1070196201dec7c9634d69f7e2a0c91" FOREIGN KEY (filesystem_group_id) REFERENCES maasserver_filesystemgroup(id) DEFERRABLE INITIALLY DEFERRED; |
2667 | - |
2668 | - |
2669 | --- |
2670 | --- Name: D108f1ee160483b949bce80d28dfd4f8; Type: FK CONSTRAINT; Schema: public; Owner: - |
2671 | + ADD CONSTRAINT "D01c4bc8ec3a44341e022ef0dc975639" FOREIGN KEY (filesystem_group_id) REFERENCES maasserver_filesystemgroup(id) DEFERRABLE INITIALLY DEFERRED; |
2672 | + |
2673 | + |
2674 | +-- |
2675 | +-- Name: D209f307551da9b8097278e280756387; Type: FK CONSTRAINT; Schema: public; Owner: - |
2676 | +-- |
2677 | + |
2678 | +ALTER TABLE ONLY maasserver_filesystem |
2679 | + ADD CONSTRAINT "D209f307551da9b8097278e280756387" FOREIGN KEY (filesystem_group_id) REFERENCES maasserver_filesystemgroup(id) DEFERRABLE INITIALLY DEFERRED; |
2680 | + |
2681 | + |
2682 | +-- |
2683 | +-- Name: D260dd282c2c1ba291618a19cb64f6d5; Type: FK CONSTRAINT; Schema: public; Owner: - |
2684 | +-- |
2685 | + |
2686 | +ALTER TABLE ONLY maasserver_physicalblockdevice |
2687 | + ADD CONSTRAINT "D260dd282c2c1ba291618a19cb64f6d5" FOREIGN KEY (blockdevice_ptr_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
2688 | + |
2689 | + |
2690 | +-- |
2691 | +-- Name: D2f57b14ffcb978bc25cdd17aff56c3e; Type: FK CONSTRAINT; Schema: public; Owner: - |
2692 | +-- |
2693 | + |
2694 | +ALTER TABLE ONLY maasserver_node |
2695 | + ADD CONSTRAINT "D2f57b14ffcb978bc25cdd17aff56c3e" FOREIGN KEY (dns_process_id) REFERENCES maasserver_regioncontrollerprocess(id) DEFERRABLE INITIALLY DEFERRED; |
2696 | + |
2697 | + |
2698 | +-- |
2699 | +-- Name: D3b3c320e20fd14e52338602f45357b0; Type: FK CONSTRAINT; Schema: public; Owner: - |
2700 | +-- |
2701 | + |
2702 | +ALTER TABLE ONLY maasserver_node |
2703 | + ADD CONSTRAINT "D3b3c320e20fd14e52338602f45357b0" FOREIGN KEY (boot_disk_id) REFERENCES maasserver_physicalblockdevice(blockdevice_ptr_id) DEFERRABLE INITIALLY DEFERRED; |
2704 | + |
2705 | + |
2706 | +-- |
2707 | +-- Name: D481e1717d4bef0fe16b7fb55731b78e; Type: FK CONSTRAINT; Schema: public; Owner: - |
2708 | -- |
2709 | |
2710 | ALTER TABLE ONLY metadataserver_scriptresult |
2711 | - ADD CONSTRAINT "D108f1ee160483b949bce80d28dfd4f8" FOREIGN KEY (script_version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
2712 | - |
2713 | - |
2714 | --- |
2715 | --- Name: D13db59455e3333d0b0ab4168dc7c430; Type: FK CONSTRAINT; Schema: public; Owner: - |
2716 | + ADD CONSTRAINT "D481e1717d4bef0fe16b7fb55731b78e" FOREIGN KEY (script_version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
2717 | + |
2718 | + |
2719 | +-- |
2720 | +-- Name: D4b27d3883ac32913aaaeb97c340b81c; Type: FK CONSTRAINT; Schema: public; Owner: - |
2721 | +-- |
2722 | + |
2723 | +ALTER TABLE ONLY maasserver_dnsresource_ip_addresses |
2724 | + ADD CONSTRAINT "D4b27d3883ac32913aaaeb97c340b81c" FOREIGN KEY (staticipaddress_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2725 | + |
2726 | + |
2727 | +-- |
2728 | +-- Name: D52e45b9b6c9c98eebd9bf7864ca5e27; Type: FK CONSTRAINT; Schema: public; Owner: - |
2729 | -- |
2730 | |
2731 | ALTER TABLE ONLY maasserver_node |
2732 | - ADD CONSTRAINT "D13db59455e3333d0b0ab4168dc7c430" FOREIGN KEY (gateway_link_ipv6_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2733 | - |
2734 | - |
2735 | --- |
2736 | --- Name: D384ca3ec95969691a51174ccccbd502; Type: FK CONSTRAINT; Schema: public; Owner: - |
2737 | + ADD CONSTRAINT "D52e45b9b6c9c98eebd9bf7864ca5e27" FOREIGN KEY (gateway_link_ipv4_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2738 | + |
2739 | + |
2740 | +-- |
2741 | +-- Name: D67f45d812751af0c5fff6e9e0b0f1cc; Type: FK CONSTRAINT; Schema: public; Owner: - |
2742 | +-- |
2743 | + |
2744 | +ALTER TABLE ONLY maasserver_interface_ip_addresses |
2745 | + ADD CONSTRAINT "D67f45d812751af0c5fff6e9e0b0f1cc" FOREIGN KEY (staticipaddress_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2746 | + |
2747 | + |
2748 | +-- |
2749 | +-- Name: D759d79ffe2ab9b60f94050c4fe23b29; Type: FK CONSTRAINT; Schema: public; Owner: - |
2750 | -- |
2751 | |
2752 | ALTER TABLE ONLY maasserver_partition |
2753 | - ADD CONSTRAINT "D384ca3ec95969691a51174ccccbd502" FOREIGN KEY (partition_table_id) REFERENCES maasserver_partitiontable(id) DEFERRABLE INITIALLY DEFERRED; |
2754 | - |
2755 | - |
2756 | --- |
2757 | --- Name: D3b526bce0f9c49e7da25fe377d06b8b; Type: FK CONSTRAINT; Schema: public; Owner: - |
2758 | --- |
2759 | - |
2760 | -ALTER TABLE ONLY maasserver_node |
2761 | - ADD CONSTRAINT "D3b526bce0f9c49e7da25fe377d06b8b" FOREIGN KEY (current_installation_script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
2762 | - |
2763 | - |
2764 | --- |
2765 | --- Name: D47c87a3742e39c598f2a871784fcb05; Type: FK CONSTRAINT; Schema: public; Owner: - |
2766 | --- |
2767 | - |
2768 | -ALTER TABLE ONLY maasserver_node |
2769 | - ADD CONSTRAINT "D47c87a3742e39c598f2a871784fcb05" FOREIGN KEY (current_commissioning_script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
2770 | - |
2771 | - |
2772 | --- |
2773 | --- Name: D502de9ebd918eb525ed54ef43502e57; Type: FK CONSTRAINT; Schema: public; Owner: - |
2774 | --- |
2775 | - |
2776 | -ALTER TABLE ONLY maasserver_filesystem |
2777 | - ADD CONSTRAINT "D502de9ebd918eb525ed54ef43502e57" FOREIGN KEY (filesystem_group_id) REFERENCES maasserver_filesystemgroup(id) DEFERRABLE INITIALLY DEFERRED; |
2778 | - |
2779 | - |
2780 | --- |
2781 | --- Name: D5f84692cf8c31d9471ca2f675399448; Type: FK CONSTRAINT; Schema: public; Owner: - |
2782 | --- |
2783 | - |
2784 | -ALTER TABLE ONLY maasserver_physicalblockdevice |
2785 | - ADD CONSTRAINT "D5f84692cf8c31d9471ca2f675399448" FOREIGN KEY (blockdevice_ptr_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
2786 | - |
2787 | - |
2788 | --- |
2789 | --- Name: D65ae837d5ae92d54a8a6b9143ebbad6; Type: FK CONSTRAINT; Schema: public; Owner: - |
2790 | --- |
2791 | - |
2792 | -ALTER TABLE ONLY maasserver_dnsresource_ip_addresses |
2793 | - ADD CONSTRAINT "D65ae837d5ae92d54a8a6b9143ebbad6" FOREIGN KEY (staticipaddress_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2794 | - |
2795 | - |
2796 | --- |
2797 | --- Name: D7bfb76524c265a3acff0471a8e41a90; Type: FK CONSTRAINT; Schema: public; Owner: - |
2798 | --- |
2799 | - |
2800 | -ALTER TABLE ONLY maasserver_node |
2801 | - ADD CONSTRAINT "D7bfb76524c265a3acff0471a8e41a90" FOREIGN KEY (dns_process_id) REFERENCES maasserver_regioncontrollerprocess(id) DEFERRABLE INITIALLY DEFERRED; |
2802 | - |
2803 | - |
2804 | --- |
2805 | --- Name: D88dd95acce2969749166bd64ef4f766; Type: FK CONSTRAINT; Schema: public; Owner: - |
2806 | --- |
2807 | - |
2808 | -ALTER TABLE ONLY maasserver_virtualblockdevice |
2809 | - ADD CONSTRAINT "D88dd95acce2969749166bd64ef4f766" FOREIGN KEY (blockdevice_ptr_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
2810 | - |
2811 | - |
2812 | --- |
2813 | --- Name: D9c4c30025bf087dcf627c8ffc17adf5; Type: FK CONSTRAINT; Schema: public; Owner: - |
2814 | --- |
2815 | - |
2816 | -ALTER TABLE ONLY maasserver_interface_ip_addresses |
2817 | - ADD CONSTRAINT "D9c4c30025bf087dcf627c8ffc17adf5" FOREIGN KEY (staticipaddress_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2818 | - |
2819 | - |
2820 | --- |
2821 | --- Name: af2239da0d3eb4ad21112109e21f97d1; Type: FK CONSTRAINT; Schema: public; Owner: - |
2822 | --- |
2823 | - |
2824 | -ALTER TABLE ONLY maasserver_node |
2825 | - ADD CONSTRAINT af2239da0d3eb4ad21112109e21f97d1 FOREIGN KEY (gateway_link_ipv4_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2826 | - |
2827 | - |
2828 | --- |
2829 | --- Name: auth__content_type_id_2b98b1ee3208ece_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2830 | + ADD CONSTRAINT "D759d79ffe2ab9b60f94050c4fe23b29" FOREIGN KEY (partition_table_id) REFERENCES maasserver_partitiontable(id) DEFERRABLE INITIALLY DEFERRED; |
2831 | + |
2832 | + |
2833 | +-- |
2834 | +-- Name: D8915f1c6195b646ed9b16907a53c482; Type: FK CONSTRAINT; Schema: public; Owner: - |
2835 | +-- |
2836 | + |
2837 | +ALTER TABLE ONLY maasserver_node |
2838 | + ADD CONSTRAINT "D8915f1c6195b646ed9b16907a53c482" FOREIGN KEY (managing_process_id) REFERENCES maasserver_regioncontrollerprocess(id) DEFERRABLE INITIALLY DEFERRED; |
2839 | + |
2840 | + |
2841 | +-- |
2842 | +-- Name: D8c1b57a2ada87209e1b52bccea6d1d2; Type: FK CONSTRAINT; Schema: public; Owner: - |
2843 | +-- |
2844 | + |
2845 | +ALTER TABLE ONLY maasserver_bootresourcefile |
2846 | + ADD CONSTRAINT "D8c1b57a2ada87209e1b52bccea6d1d2" FOREIGN KEY (resource_set_id) REFERENCES maasserver_bootresourceset(id) DEFERRABLE INITIALLY DEFERRED; |
2847 | + |
2848 | + |
2849 | +-- |
2850 | +-- Name: a0ea99bc1b6733861178b09cf5575650; Type: FK CONSTRAINT; Schema: public; Owner: - |
2851 | +-- |
2852 | + |
2853 | +ALTER TABLE ONLY maasserver_template |
2854 | + ADD CONSTRAINT a0ea99bc1b6733861178b09cf5575650 FOREIGN KEY (default_version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
2855 | + |
2856 | + |
2857 | +-- |
2858 | +-- Name: auth_content_type_id_4800f59986276c05_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2859 | -- |
2860 | |
2861 | ALTER TABLE ONLY auth_permission |
2862 | - ADD CONSTRAINT auth__content_type_id_2b98b1ee3208ece_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED; |
2863 | - |
2864 | - |
2865 | --- |
2866 | --- Name: auth_group_permissio_group_id_33ec2120f4f73ce8_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2867 | --- |
2868 | - |
2869 | -ALTER TABLE ONLY auth_group_permissions |
2870 | - ADD CONSTRAINT auth_group_permissio_group_id_33ec2120f4f73ce8_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED; |
2871 | - |
2872 | - |
2873 | --- |
2874 | --- Name: auth_group_permission_id_782de1cb78f41dfb_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2875 | --- |
2876 | - |
2877 | -ALTER TABLE ONLY auth_group_permissions |
2878 | - ADD CONSTRAINT auth_group_permission_id_782de1cb78f41dfb_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED; |
2879 | - |
2880 | - |
2881 | --- |
2882 | --- Name: auth_user__permission_id_42f723d88c708260_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2883 | --- |
2884 | - |
2885 | -ALTER TABLE ONLY auth_user_user_permissions |
2886 | - ADD CONSTRAINT auth_user__permission_id_42f723d88c708260_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED; |
2887 | - |
2888 | - |
2889 | --- |
2890 | --- Name: auth_user_groups_group_id_346b3577a7241832_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2891 | --- |
2892 | - |
2893 | -ALTER TABLE ONLY auth_user_groups |
2894 | - ADD CONSTRAINT auth_user_groups_group_id_346b3577a7241832_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED; |
2895 | - |
2896 | - |
2897 | --- |
2898 | --- Name: auth_user_groups_user_id_1f0d16061eb70d47_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2899 | --- |
2900 | - |
2901 | -ALTER TABLE ONLY auth_user_groups |
2902 | - ADD CONSTRAINT auth_user_groups_user_id_1f0d16061eb70d47_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
2903 | - |
2904 | - |
2905 | --- |
2906 | --- Name: auth_user_user_permiss_user_id_17ae90e2e1fb93ec_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2907 | --- |
2908 | - |
2909 | -ALTER TABLE ONLY auth_user_user_permissions |
2910 | - ADD CONSTRAINT auth_user_user_permiss_user_id_17ae90e2e1fb93ec_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
2911 | - |
2912 | - |
2913 | --- |
2914 | --- Name: b5bc41476207559569c56550444e5a4e; Type: FK CONSTRAINT; Schema: public; Owner: - |
2915 | + ADD CONSTRAINT auth_content_type_id_4800f59986276c05_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED; |
2916 | + |
2917 | + |
2918 | +-- |
2919 | +-- Name: auth_group_permissio_group_id_3856a1531c70cab7_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2920 | +-- |
2921 | + |
2922 | +ALTER TABLE ONLY auth_group_permissions |
2923 | + ADD CONSTRAINT auth_group_permissio_group_id_3856a1531c70cab7_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED; |
2924 | + |
2925 | + |
2926 | +-- |
2927 | +-- Name: auth_group_permission_id_5b4d1d0e2d48ebac_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2928 | +-- |
2929 | + |
2930 | +ALTER TABLE ONLY auth_group_permissions |
2931 | + ADD CONSTRAINT auth_group_permission_id_5b4d1d0e2d48ebac_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED; |
2932 | + |
2933 | + |
2934 | +-- |
2935 | +-- Name: auth_user__permission_id_597d12668c0eb7f1_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2936 | +-- |
2937 | + |
2938 | +ALTER TABLE ONLY auth_user_user_permissions |
2939 | + ADD CONSTRAINT auth_user__permission_id_597d12668c0eb7f1_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED; |
2940 | + |
2941 | + |
2942 | +-- |
2943 | +-- Name: auth_user_groups_group_id_6a708cfabb357f54_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2944 | +-- |
2945 | + |
2946 | +ALTER TABLE ONLY auth_user_groups |
2947 | + ADD CONSTRAINT auth_user_groups_group_id_6a708cfabb357f54_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED; |
2948 | + |
2949 | + |
2950 | +-- |
2951 | +-- Name: auth_user_groups_user_id_7fd5fa3cf3749be5_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2952 | +-- |
2953 | + |
2954 | +ALTER TABLE ONLY auth_user_groups |
2955 | + ADD CONSTRAINT auth_user_groups_user_id_7fd5fa3cf3749be5_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
2956 | + |
2957 | + |
2958 | +-- |
2959 | +-- Name: auth_user_user_permiss_user_id_50c4fdcbcfd0531b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
2960 | +-- |
2961 | + |
2962 | +ALTER TABLE ONLY auth_user_user_permissions |
2963 | + ADD CONSTRAINT auth_user_user_permiss_user_id_50c4fdcbcfd0531b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
2964 | + |
2965 | + |
2966 | +-- |
2967 | +-- Name: b12b9075d153b004bc9c42f76d3b0ddf; Type: FK CONSTRAINT; Schema: public; Owner: - |
2968 | +-- |
2969 | + |
2970 | +ALTER TABLE ONLY maasserver_bmc |
2971 | + ADD CONSTRAINT b12b9075d153b004bc9c42f76d3b0ddf FOREIGN KEY (ip_address_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
2972 | + |
2973 | + |
2974 | +-- |
2975 | +-- Name: bdafd767b8ee8a3c0e8a40f8c6961fe8; Type: FK CONSTRAINT; Schema: public; Owner: - |
2976 | +-- |
2977 | + |
2978 | +ALTER TABLE ONLY maasserver_virtualblockdevice |
2979 | + ADD CONSTRAINT bdafd767b8ee8a3c0e8a40f8c6961fe8 FOREIGN KEY (blockdevice_ptr_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
2980 | + |
2981 | + |
2982 | +-- |
2983 | +-- Name: c28aee345c400414838c2b48c51d51bb; Type: FK CONSTRAINT; Schema: public; Owner: - |
2984 | +-- |
2985 | + |
2986 | +ALTER TABLE ONLY maasserver_node |
2987 | + ADD CONSTRAINT c28aee345c400414838c2b48c51d51bb FOREIGN KEY (current_testing_script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
2988 | + |
2989 | + |
2990 | +-- |
2991 | +-- Name: d76bea6ad92ce5a6e2e5ebe69d0c43a5; Type: FK CONSTRAINT; Schema: public; Owner: - |
2992 | +-- |
2993 | + |
2994 | +ALTER TABLE ONLY maasserver_node |
2995 | + ADD CONSTRAINT d76bea6ad92ce5a6e2e5ebe69d0c43a5 FOREIGN KEY (current_installation_script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
2996 | + |
2997 | + |
2998 | +-- |
2999 | +-- Name: e12b499bd7a646c65276644372e80c81; Type: FK CONSTRAINT; Schema: public; Owner: - |
3000 | +-- |
3001 | + |
3002 | +ALTER TABLE ONLY maasserver_regionrackrpcconnection |
3003 | + ADD CONSTRAINT e12b499bd7a646c65276644372e80c81 FOREIGN KEY (endpoint_id) REFERENCES maasserver_regioncontrollerprocessendpoint(id) DEFERRABLE INITIALLY DEFERRED; |
3004 | + |
3005 | + |
3006 | +-- |
3007 | +-- Name: f0c28e6109e6d07caf1c2f696edc2de4; Type: FK CONSTRAINT; Schema: public; Owner: - |
3008 | +-- |
3009 | + |
3010 | +ALTER TABLE ONLY maasserver_regioncontrollerprocessendpoint |
3011 | + ADD CONSTRAINT f0c28e6109e6d07caf1c2f696edc2de4 FOREIGN KEY (process_id) REFERENCES maasserver_regioncontrollerprocess(id) DEFERRABLE INITIALLY DEFERRED; |
3012 | + |
3013 | + |
3014 | +-- |
3015 | +-- Name: f3feec239b591ed0b25790f79bedff14; Type: FK CONSTRAINT; Schema: public; Owner: - |
3016 | -- |
3017 | |
3018 | ALTER TABLE ONLY maasserver_versionedtextfile |
3019 | - ADD CONSTRAINT b5bc41476207559569c56550444e5a4e FOREIGN KEY (previous_version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
3020 | - |
3021 | - |
3022 | --- |
3023 | --- Name: d31994ed8dbb4b75be89db9f3cb69d24; Type: FK CONSTRAINT; Schema: public; Owner: - |
3024 | --- |
3025 | - |
3026 | -ALTER TABLE ONLY maasserver_bmc |
3027 | - ADD CONSTRAINT d31994ed8dbb4b75be89db9f3cb69d24 FOREIGN KEY (ip_address_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
3028 | - |
3029 | - |
3030 | --- |
3031 | --- Name: d7de91f950ab2fa3ce2ce1aad9ed716f; Type: FK CONSTRAINT; Schema: public; Owner: - |
3032 | --- |
3033 | - |
3034 | -ALTER TABLE ONLY maasserver_bootresourcefile |
3035 | - ADD CONSTRAINT d7de91f950ab2fa3ce2ce1aad9ed716f FOREIGN KEY (resource_set_id) REFERENCES maasserver_bootresourceset(id) DEFERRABLE INITIALLY DEFERRED; |
3036 | - |
3037 | - |
3038 | --- |
3039 | --- Name: df6ece8242a8ca40fd2b23f7406de5c1; Type: FK CONSTRAINT; Schema: public; Owner: - |
3040 | --- |
3041 | - |
3042 | -ALTER TABLE ONLY maasserver_template |
3043 | - ADD CONSTRAINT df6ece8242a8ca40fd2b23f7406de5c1 FOREIGN KEY (default_version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
3044 | - |
3045 | - |
3046 | --- |
3047 | --- Name: e00b435d791c481337da17843027a455; Type: FK CONSTRAINT; Schema: public; Owner: - |
3048 | --- |
3049 | - |
3050 | -ALTER TABLE ONLY maasserver_regionrackrpcconnection |
3051 | - ADD CONSTRAINT e00b435d791c481337da17843027a455 FOREIGN KEY (endpoint_id) REFERENCES maasserver_regioncontrollerprocessendpoint(id) DEFERRABLE INITIALLY DEFERRED; |
3052 | - |
3053 | - |
3054 | --- |
3055 | --- Name: e5d76f2b46ec16296dfeafdf01eb7640; Type: FK CONSTRAINT; Schema: public; Owner: - |
3056 | --- |
3057 | - |
3058 | -ALTER TABLE ONLY maasserver_node |
3059 | - ADD CONSTRAINT e5d76f2b46ec16296dfeafdf01eb7640 FOREIGN KEY (managing_process_id) REFERENCES maasserver_regioncontrollerprocess(id) DEFERRABLE INITIALLY DEFERRED; |
3060 | - |
3061 | - |
3062 | --- |
3063 | --- Name: f5750ee1af72499282c6b3e037bde7e2; Type: FK CONSTRAINT; Schema: public; Owner: - |
3064 | --- |
3065 | - |
3066 | -ALTER TABLE ONLY maasserver_node |
3067 | - ADD CONSTRAINT f5750ee1af72499282c6b3e037bde7e2 FOREIGN KEY (boot_disk_id) REFERENCES maasserver_physicalblockdevice(blockdevice_ptr_id) DEFERRABLE INITIALLY DEFERRED; |
3068 | - |
3069 | - |
3070 | --- |
3071 | --- Name: m_block_device_id_20fef2565d2ff4eb_fk_maasserver_blockdevice_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3072 | + ADD CONSTRAINT f3feec239b591ed0b25790f79bedff14 FOREIGN KEY (previous_version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
3073 | + |
3074 | + |
3075 | +-- |
3076 | +-- Name: f6813247f17f3bd397b7051f3047a6fa; Type: FK CONSTRAINT; Schema: public; Owner: - |
3077 | +-- |
3078 | + |
3079 | +ALTER TABLE ONLY maasserver_node |
3080 | + ADD CONSTRAINT f6813247f17f3bd397b7051f3047a6fa FOREIGN KEY (current_commissioning_script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
3081 | + |
3082 | + |
3083 | +-- |
3084 | +-- Name: ff110a973658bf38f441f6da134073e7; Type: FK CONSTRAINT; Schema: public; Owner: - |
3085 | +-- |
3086 | + |
3087 | +ALTER TABLE ONLY maasserver_node |
3088 | + ADD CONSTRAINT ff110a973658bf38f441f6da134073e7 FOREIGN KEY (gateway_link_ipv6_id) REFERENCES maasserver_staticipaddress(id) DEFERRABLE INITIALLY DEFERRED; |
3089 | + |
3090 | + |
3091 | +-- |
3092 | +-- Name: m_block_device_id_3f63bc3876339222_fk_maasserver_blockdevice_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3093 | -- |
3094 | |
3095 | ALTER TABLE ONLY maasserver_filesystem |
3096 | - ADD CONSTRAINT m_block_device_id_20fef2565d2ff4eb_fk_maasserver_blockdevice_id FOREIGN KEY (block_device_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
3097 | + ADD CONSTRAINT m_block_device_id_3f63bc3876339222_fk_maasserver_blockdevice_id FOREIGN KEY (block_device_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
3098 | |
3099 | |
3100 | -- |
3101 | --- Name: m_block_device_id_2aa8fe22212511d3_fk_maasserver_blockdevice_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3102 | +-- Name: m_block_device_id_7ae09b4e922a3b1d_fk_maasserver_blockdevice_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3103 | -- |
3104 | |
3105 | ALTER TABLE ONLY maasserver_partitiontable |
3106 | - ADD CONSTRAINT m_block_device_id_2aa8fe22212511d3_fk_maasserver_blockdevice_id FOREIGN KEY (block_device_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
3107 | - |
3108 | - |
3109 | --- |
3110 | --- Name: m_boot_interface_id_6628bc5b036d8595_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3111 | --- |
3112 | - |
3113 | -ALTER TABLE ONLY maasserver_node |
3114 | - ADD CONSTRAINT m_boot_interface_id_6628bc5b036d8595_fk_maasserver_interface_id FOREIGN KEY (boot_interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3115 | - |
3116 | - |
3117 | --- |
3118 | --- Name: m_script_id_6f8bed269172f9b5_fk_maasserver_versionedtextfile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3119 | + ADD CONSTRAINT m_block_device_id_7ae09b4e922a3b1d_fk_maasserver_blockdevice_id FOREIGN KEY (block_device_id) REFERENCES maasserver_blockdevice(id) DEFERRABLE INITIALLY DEFERRED; |
3120 | + |
3121 | + |
3122 | +-- |
3123 | +-- Name: m_script_id_5674743fc05c6830_fk_maasserver_versionedtextfile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3124 | -- |
3125 | |
3126 | ALTER TABLE ONLY metadataserver_script |
3127 | - ADD CONSTRAINT m_script_id_6f8bed269172f9b5_fk_maasserver_versionedtextfile_id FOREIGN KEY (script_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
3128 | + ADD CONSTRAINT m_script_id_5674743fc05c6830_fk_maasserver_versionedtextfile_id FOREIGN KEY (script_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
3129 | |
3130 | |
3131 | -- |
3132 | --- Name: m_script_set_id_361a0c10db8e8f7c_fk_metadataserver_scriptset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3133 | +-- Name: m_script_set_id_60c42afabd64274e_fk_metadataserver_scriptset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3134 | -- |
3135 | |
3136 | ALTER TABLE ONLY metadataserver_scriptresult |
3137 | - ADD CONSTRAINT m_script_set_id_361a0c10db8e8f7c_fk_metadataserver_scriptset_id FOREIGN KEY (script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
3138 | - |
3139 | - |
3140 | --- |
3141 | --- Name: ma_dnsresource_id_3087fe1275d02b82_fk_maasserver_dnsresource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3142 | --- |
3143 | - |
3144 | -ALTER TABLE ONLY maasserver_dnsresource_ip_addresses |
3145 | - ADD CONSTRAINT ma_dnsresource_id_3087fe1275d02b82_fk_maasserver_dnsresource_id FOREIGN KEY (dnsresource_id) REFERENCES maasserver_dnsresource(id) DEFERRABLE INITIALLY DEFERRED; |
3146 | - |
3147 | - |
3148 | --- |
3149 | --- Name: ma_dnsresource_id_5036977095b42f66_fk_maasserver_dnsresource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3150 | + ADD CONSTRAINT m_script_set_id_60c42afabd64274e_fk_metadataserver_scriptset_id FOREIGN KEY (script_set_id) REFERENCES metadataserver_scriptset(id) DEFERRABLE INITIALLY DEFERRED; |
3151 | + |
3152 | + |
3153 | +-- |
3154 | +-- Name: ma_boot_interface_id_6f6f3d441a5e53a_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3155 | +-- |
3156 | + |
3157 | +ALTER TABLE ONLY maasserver_node |
3158 | + ADD CONSTRAINT ma_boot_interface_id_6f6f3d441a5e53a_fk_maasserver_interface_id FOREIGN KEY (boot_interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3159 | + |
3160 | + |
3161 | +-- |
3162 | +-- Name: ma_dnsresource_id_46caeaed7f0f0e4d_fk_maasserver_dnsresource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3163 | -- |
3164 | |
3165 | ALTER TABLE ONLY maasserver_dnsdata |
3166 | - ADD CONSTRAINT ma_dnsresource_id_5036977095b42f66_fk_maasserver_dnsresource_id FOREIGN KEY (dnsresource_id) REFERENCES maasserver_dnsresource(id) DEFERRABLE INITIALLY DEFERRED; |
3167 | - |
3168 | - |
3169 | --- |
3170 | --- Name: maa_boot_source_id_559a26dfdc4bdb77_fk_maasserver_bootsource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3171 | + ADD CONSTRAINT ma_dnsresource_id_46caeaed7f0f0e4d_fk_maasserver_dnsresource_id FOREIGN KEY (dnsresource_id) REFERENCES maasserver_dnsresource(id) DEFERRABLE INITIALLY DEFERRED; |
3172 | + |
3173 | + |
3174 | +-- |
3175 | +-- Name: ma_value_id_3129a05a16aa1db6_fk_maasserver_versionedtextfile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3176 | +-- |
3177 | + |
3178 | +ALTER TABLE ONLY maasserver_dhcpsnippet |
3179 | + ADD CONSTRAINT ma_value_id_3129a05a16aa1db6_fk_maasserver_versionedtextfile_id FOREIGN KEY (value_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
3180 | + |
3181 | + |
3182 | +-- |
3183 | +-- Name: maa_boot_source_id_228d82f16742d13b_fk_maasserver_bootsource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3184 | -- |
3185 | |
3186 | ALTER TABLE ONLY maasserver_bootsourceselection |
3187 | - ADD CONSTRAINT maa_boot_source_id_559a26dfdc4bdb77_fk_maasserver_bootsource_id FOREIGN KEY (boot_source_id) REFERENCES maasserver_bootsource(id) DEFERRABLE INITIALLY DEFERRED; |
3188 | - |
3189 | - |
3190 | --- |
3191 | --- Name: maa_value_id_bc6b564f7bd9f69_fk_maasserver_versionedtextfile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3192 | --- |
3193 | - |
3194 | -ALTER TABLE ONLY maasserver_dhcpsnippet |
3195 | - ADD CONSTRAINT maa_value_id_bc6b564f7bd9f69_fk_maasserver_versionedtextfile_id FOREIGN KEY (value_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
3196 | - |
3197 | - |
3198 | --- |
3199 | --- Name: maas_boot_source_id_f6b46b0be2fcfa2_fk_maasserver_bootsource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3200 | + ADD CONSTRAINT maa_boot_source_id_228d82f16742d13b_fk_maasserver_bootsource_id FOREIGN KEY (boot_source_id) REFERENCES maasserver_bootsource(id) DEFERRABLE INITIALLY DEFERRED; |
3201 | + |
3202 | + |
3203 | +-- |
3204 | +-- Name: maa_dnsresource_id_b2791744e4474af_fk_maasserver_dnsresource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3205 | +-- |
3206 | + |
3207 | +ALTER TABLE ONLY maasserver_dnsresource_ip_addresses |
3208 | + ADD CONSTRAINT maa_dnsresource_id_b2791744e4474af_fk_maasserver_dnsresource_id FOREIGN KEY (dnsresource_id) REFERENCES maasserver_dnsresource(id) DEFERRABLE INITIALLY DEFERRED; |
3209 | + |
3210 | + |
3211 | +-- |
3212 | +-- Name: maas_boot_source_id_5dc82c36de78f83_fk_maasserver_bootsource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3213 | -- |
3214 | |
3215 | ALTER TABLE ONLY maasserver_bootsourcecache |
3216 | - ADD CONSTRAINT maas_boot_source_id_f6b46b0be2fcfa2_fk_maasserver_bootsource_id FOREIGN KEY (boot_source_id) REFERENCES maasserver_bootsource(id) DEFERRABLE INITIALLY DEFERRED; |
3217 | + ADD CONSTRAINT maas_boot_source_id_5dc82c36de78f83_fk_maasserver_bootsource_id FOREIGN KEY (boot_source_id) REFERENCES maasserver_bootsource(id) DEFERRABLE INITIALLY DEFERRED; |
3218 | |
3219 | |
3220 | -- |
3221 | --- Name: maas_resource_id_48b397ebe088845e_fk_maasserver_bootresource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3222 | +-- Name: maas_resource_id_1fec0c247f26f2da_fk_maasserver_bootresource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3223 | -- |
3224 | |
3225 | ALTER TABLE ONLY maasserver_bootresourceset |
3226 | - ADD CONSTRAINT maas_resource_id_48b397ebe088845e_fk_maasserver_bootresource_id FOREIGN KEY (resource_id) REFERENCES maasserver_bootresource(id) DEFERRABLE INITIALLY DEFERRED; |
3227 | - |
3228 | - |
3229 | --- |
3230 | --- Name: maass_rack_controller_id_166246f43e6d544a_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3231 | --- |
3232 | - |
3233 | -ALTER TABLE ONLY maasserver_bmcroutablerackcontrollerrelationship |
3234 | - ADD CONSTRAINT maass_rack_controller_id_166246f43e6d544a_fk_maasserver_node_id FOREIGN KEY (rack_controller_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3235 | - |
3236 | - |
3237 | --- |
3238 | --- Name: maasse_interface_id_3b7a5c9d314a19d4_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3239 | + ADD CONSTRAINT maas_resource_id_1fec0c247f26f2da_fk_maasserver_bootresource_id FOREIGN KEY (resource_id) REFERENCES maasserver_bootresource(id) DEFERRABLE INITIALLY DEFERRED; |
3240 | + |
3241 | + |
3242 | +-- |
3243 | +-- Name: maass_rack_controller_id_6806247650c96a8d_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3244 | +-- |
3245 | + |
3246 | +ALTER TABLE ONLY maasserver_regionrackrpcconnection |
3247 | + ADD CONSTRAINT maass_rack_controller_id_6806247650c96a8d_fk_maasserver_node_id FOREIGN KEY (rack_controller_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3248 | + |
3249 | + |
3250 | +-- |
3251 | +-- Name: maasse_interface_id_4f42f6bcf56549fd_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3252 | +-- |
3253 | + |
3254 | +ALTER TABLE ONLY maasserver_neighbour |
3255 | + ADD CONSTRAINT maasse_interface_id_4f42f6bcf56549fd_fk_maasserver_interface_id FOREIGN KEY (interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3256 | + |
3257 | + |
3258 | +-- |
3259 | +-- Name: maasse_interface_id_613cc7444db7158e_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3260 | -- |
3261 | |
3262 | ALTER TABLE ONLY maasserver_mdns |
3263 | - ADD CONSTRAINT maasse_interface_id_3b7a5c9d314a19d4_fk_maasserver_interface_id FOREIGN KEY (interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3264 | - |
3265 | - |
3266 | --- |
3267 | --- Name: maasse_interface_id_4feeab3a3717b74e_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3268 | --- |
3269 | - |
3270 | -ALTER TABLE ONLY maasserver_interface_ip_addresses |
3271 | - ADD CONSTRAINT maasse_interface_id_4feeab3a3717b74e_fk_maasserver_interface_id FOREIGN KEY (interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3272 | - |
3273 | - |
3274 | --- |
3275 | --- Name: maasse_interface_id_50d58a81efe34826_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3276 | --- |
3277 | - |
3278 | -ALTER TABLE ONLY maasserver_neighbour |
3279 | - ADD CONSTRAINT maasse_interface_id_50d58a81efe34826_fk_maasserver_interface_id FOREIGN KEY (interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3280 | - |
3281 | - |
3282 | --- |
3283 | --- Name: maasse_keysource_id_10322633a1d30928_fk_maasserver_keysource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3284 | + ADD CONSTRAINT maasse_interface_id_613cc7444db7158e_fk_maasserver_interface_id FOREIGN KEY (interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3285 | + |
3286 | + |
3287 | +-- |
3288 | +-- Name: maasse_keysource_id_7824932a3f08281f_fk_maasserver_keysource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3289 | -- |
3290 | |
3291 | ALTER TABLE ONLY maasserver_sshkey |
3292 | - ADD CONSTRAINT maasse_keysource_id_10322633a1d30928_fk_maasserver_keysource_id FOREIGN KEY (keysource_id) REFERENCES maasserver_keysource(id) DEFERRABLE INITIALLY DEFERRED; |
3293 | + ADD CONSTRAINT maasse_keysource_id_7824932a3f08281f_fk_maasserver_keysource_id FOREIGN KEY (keysource_id) REFERENCES maasserver_keysource(id) DEFERRABLE INITIALLY DEFERRED; |
3294 | |
3295 | |
3296 | -- |
3297 | --- Name: maasse_largefile_id_3003880f9a9f5a98_fk_maasserver_largefile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3298 | +-- Name: maasse_largefile_id_5b2b478d04a6b781_fk_maasserver_largefile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3299 | -- |
3300 | |
3301 | ALTER TABLE ONLY maasserver_bootresourcefile |
3302 | - ADD CONSTRAINT maasse_largefile_id_3003880f9a9f5a98_fk_maasserver_largefile_id FOREIGN KEY (largefile_id) REFERENCES maasserver_largefile(id) DEFERRABLE INITIALLY DEFERRED; |
3303 | + ADD CONSTRAINT maasse_largefile_id_5b2b478d04a6b781_fk_maasserver_largefile_id FOREIGN KEY (largefile_id) REFERENCES maasserver_largefile(id) DEFERRABLE INITIALLY DEFERRED; |
3304 | |
3305 | |
3306 | -- |
3307 | --- Name: maasse_partition_id_41d7a8350f9ec429_fk_maasserver_partition_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3308 | +-- Name: maasse_partition_id_6fb95a93fd9e438d_fk_maasserver_partition_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3309 | -- |
3310 | |
3311 | ALTER TABLE ONLY maasserver_filesystem |
3312 | - ADD CONSTRAINT maasse_partition_id_41d7a8350f9ec429_fk_maasserver_partition_id FOREIGN KEY (partition_id) REFERENCES maasserver_partition(id) DEFERRABLE INITIALLY DEFERRED; |
3313 | - |
3314 | - |
3315 | --- |
3316 | --- Name: maasse_rack_controller_id_d93480e56c7dc8d_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3317 | --- |
3318 | - |
3319 | -ALTER TABLE ONLY maasserver_regionrackrpcconnection |
3320 | - ADD CONSTRAINT maasse_rack_controller_id_d93480e56c7dc8d_fk_maasserver_node_id FOREIGN KEY (rack_controller_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3321 | - |
3322 | - |
3323 | --- |
3324 | --- Name: maasse_secondary_rack_id_43ef9b836136687b_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3325 | + ADD CONSTRAINT maasse_partition_id_6fb95a93fd9e438d_fk_maasserver_partition_id FOREIGN KEY (partition_id) REFERENCES maasserver_partition(id) DEFERRABLE INITIALLY DEFERRED; |
3326 | + |
3327 | + |
3328 | +-- |
3329 | +-- Name: maasse_rack_controller_id_599bf619aa689e6_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3330 | +-- |
3331 | + |
3332 | +ALTER TABLE ONLY maasserver_bmcroutablerackcontrollerrelationship |
3333 | + ADD CONSTRAINT maasse_rack_controller_id_599bf619aa689e6_fk_maasserver_node_id FOREIGN KEY (rack_controller_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3334 | + |
3335 | + |
3336 | +-- |
3337 | +-- Name: maasse_secondary_rack_id_3536547a00c66e0d_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3338 | -- |
3339 | |
3340 | ALTER TABLE ONLY maasserver_vlan |
3341 | - ADD CONSTRAINT maasse_secondary_rack_id_43ef9b836136687b_fk_maasserver_node_id FOREIGN KEY (secondary_rack_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3342 | - |
3343 | - |
3344 | --- |
3345 | --- Name: maasser_cache_set_id_33c70a2a6e15b810_fk_maasserver_cacheset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3346 | --- |
3347 | - |
3348 | -ALTER TABLE ONLY maasserver_filesystem |
3349 | - ADD CONSTRAINT maasser_cache_set_id_33c70a2a6e15b810_fk_maasserver_cacheset_id FOREIGN KEY (cache_set_id) REFERENCES maasserver_cacheset(id) DEFERRABLE INITIALLY DEFERRED; |
3350 | - |
3351 | - |
3352 | --- |
3353 | --- Name: maasser_cache_set_id_48d2b739ea3d6f16_fk_maasserver_cacheset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3354 | + ADD CONSTRAINT maasse_secondary_rack_id_3536547a00c66e0d_fk_maasserver_node_id FOREIGN KEY (secondary_rack_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3355 | + |
3356 | + |
3357 | +-- |
3358 | +-- Name: maasser_cache_set_id_13ad6144e8e22d79_fk_maasserver_cacheset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3359 | -- |
3360 | |
3361 | ALTER TABLE ONLY maasserver_filesystemgroup |
3362 | - ADD CONSTRAINT maasser_cache_set_id_48d2b739ea3d6f16_fk_maasserver_cacheset_id FOREIGN KEY (cache_set_id) REFERENCES maasserver_cacheset(id) DEFERRABLE INITIALLY DEFERRED; |
3363 | - |
3364 | - |
3365 | --- |
3366 | --- Name: maasser_destination_id_1b91088af3c57958_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3367 | + ADD CONSTRAINT maasser_cache_set_id_13ad6144e8e22d79_fk_maasserver_cacheset_id FOREIGN KEY (cache_set_id) REFERENCES maasserver_cacheset(id) DEFERRABLE INITIALLY DEFERRED; |
3368 | + |
3369 | + |
3370 | +-- |
3371 | +-- Name: maasser_cache_set_id_6b8cb1e371efe7b3_fk_maasserver_cacheset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3372 | +-- |
3373 | + |
3374 | +ALTER TABLE ONLY maasserver_filesystem |
3375 | + ADD CONSTRAINT maasser_cache_set_id_6b8cb1e371efe7b3_fk_maasserver_cacheset_id FOREIGN KEY (cache_set_id) REFERENCES maasserver_cacheset(id) DEFERRABLE INITIALLY DEFERRED; |
3376 | + |
3377 | + |
3378 | +-- |
3379 | +-- Name: maasser_destination_id_6d03e40b48fbcfae_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3380 | -- |
3381 | |
3382 | ALTER TABLE ONLY maasserver_staticroute |
3383 | - ADD CONSTRAINT maasser_destination_id_1b91088af3c57958_fk_maasserver_subnet_id FOREIGN KEY (destination_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3384 | - |
3385 | - |
3386 | --- |
3387 | --- Name: maasserve_parent_id_16d676b48075c7fc_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3388 | + ADD CONSTRAINT maasser_destination_id_6d03e40b48fbcfae_fk_maasserver_subnet_id FOREIGN KEY (destination_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3389 | + |
3390 | + |
3391 | +-- |
3392 | +-- Name: maasser_interface_id_e9c3e645b3c4bd3_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3393 | +-- |
3394 | + |
3395 | +ALTER TABLE ONLY maasserver_interface_ip_addresses |
3396 | + ADD CONSTRAINT maasser_interface_id_e9c3e645b3c4bd3_fk_maasserver_interface_id FOREIGN KEY (interface_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3397 | + |
3398 | + |
3399 | +-- |
3400 | +-- Name: maasserv_primary_rack_id_26957d9d4829e690_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3401 | +-- |
3402 | + |
3403 | +ALTER TABLE ONLY maasserver_vlan |
3404 | + ADD CONSTRAINT maasserv_primary_rack_id_26957d9d4829e690_fk_maasserver_node_id FOREIGN KEY (primary_rack_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3405 | + |
3406 | + |
3407 | +-- |
3408 | +-- Name: maasserve_parent_id_441a8c651d07a0a3_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3409 | -- |
3410 | |
3411 | ALTER TABLE ONLY maasserver_interfacerelationship |
3412 | - ADD CONSTRAINT maasserve_parent_id_16d676b48075c7fc_fk_maasserver_interface_id FOREIGN KEY (parent_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3413 | - |
3414 | - |
3415 | --- |
3416 | --- Name: maasserve_primary_rack_id_d3b721cfcfa052e_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3417 | --- |
3418 | - |
3419 | -ALTER TABLE ONLY maasserver_vlan |
3420 | - ADD CONSTRAINT maasserve_primary_rack_id_d3b721cfcfa052e_fk_maasserver_node_id FOREIGN KEY (primary_rack_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3421 | - |
3422 | - |
3423 | --- |
3424 | --- Name: maasserver__type_id_64a83c5c9406ee62_fk_maasserver_eventtype_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3425 | --- |
3426 | - |
3427 | -ALTER TABLE ONLY maasserver_event |
3428 | - ADD CONSTRAINT maasserver__type_id_64a83c5c9406ee62_fk_maasserver_eventtype_id FOREIGN KEY (type_id) REFERENCES maasserver_eventtype(id) DEFERRABLE INITIALLY DEFERRED; |
3429 | - |
3430 | - |
3431 | --- |
3432 | --- Name: maasserver_block_node_id_4d07a9332927b01c_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3433 | + ADD CONSTRAINT maasserve_parent_id_441a8c651d07a0a3_fk_maasserver_interface_id FOREIGN KEY (parent_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3434 | + |
3435 | + |
3436 | +-- |
3437 | +-- Name: maasserver_block_node_id_4150665edf91b5a7_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3438 | -- |
3439 | |
3440 | ALTER TABLE ONLY maasserver_blockdevice |
3441 | - ADD CONSTRAINT maasserver_block_node_id_4d07a9332927b01c_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3442 | + ADD CONSTRAINT maasserver_block_node_id_4150665edf91b5a7_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3443 | |
3444 | |
3445 | -- |
3446 | --- Name: maasserver_bmcrouta_bmc_id_8caa0d861f9dc30_fk_maasserver_bmc_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3447 | +-- Name: maasserver_bmcrout_bmc_id_127ff68d449cc09c_fk_maasserver_bmc_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3448 | -- |
3449 | |
3450 | ALTER TABLE ONLY maasserver_bmcroutablerackcontrollerrelationship |
3451 | - ADD CONSTRAINT maasserver_bmcrouta_bmc_id_8caa0d861f9dc30_fk_maasserver_bmc_id FOREIGN KEY (bmc_id) REFERENCES maasserver_bmc(id) DEFERRABLE INITIALLY DEFERRED; |
3452 | - |
3453 | - |
3454 | --- |
3455 | --- Name: maasserver_ch_chassis_id_544fa6121ab3f909_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3456 | --- |
3457 | - |
3458 | -ALTER TABLE ONLY maasserver_chassishints |
3459 | - ADD CONSTRAINT maasserver_ch_chassis_id_544fa6121ab3f909_fk_maasserver_node_id FOREIGN KEY (chassis_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3460 | - |
3461 | - |
3462 | --- |
3463 | --- Name: maasserver_child_id_27e0edd64faac0d6_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3464 | + ADD CONSTRAINT maasserver_bmcrout_bmc_id_127ff68d449cc09c_fk_maasserver_bmc_id FOREIGN KEY (bmc_id) REFERENCES maasserver_bmc(id) DEFERRABLE INITIALLY DEFERRED; |
3465 | + |
3466 | + |
3467 | +-- |
3468 | +-- Name: maasserver_child_id_4e8dfc5d2f4d19d7_fk_maasserver_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3469 | -- |
3470 | |
3471 | ALTER TABLE ONLY maasserver_interfacerelationship |
3472 | - ADD CONSTRAINT maasserver_child_id_27e0edd64faac0d6_fk_maasserver_interface_id FOREIGN KEY (child_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3473 | + ADD CONSTRAINT maasserver_child_id_4e8dfc5d2f4d19d7_fk_maasserver_interface_id FOREIGN KEY (child_id) REFERENCES maasserver_interface(id) DEFERRABLE INITIALLY DEFERRED; |
3474 | |
3475 | |
3476 | -- |
3477 | --- Name: maasserver_d_domain_id_6e0ef210df603575_fk_maasserver_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3478 | +-- Name: maasserver_d_domain_id_55bf6442c94efe97_fk_maasserver_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3479 | -- |
3480 | |
3481 | ALTER TABLE ONLY maasserver_dnsresource |
3482 | - ADD CONSTRAINT maasserver_d_domain_id_6e0ef210df603575_fk_maasserver_domain_id FOREIGN KEY (domain_id) REFERENCES maasserver_domain(id) DEFERRABLE INITIALLY DEFERRED; |
3483 | - |
3484 | - |
3485 | --- |
3486 | --- Name: maasserver_d_subnet_id_272d35ced0450c6e_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3487 | --- |
3488 | - |
3489 | -ALTER TABLE ONLY maasserver_dhcpsnippet |
3490 | - ADD CONSTRAINT maasserver_d_subnet_id_272d35ced0450c6e_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3491 | - |
3492 | - |
3493 | --- |
3494 | --- Name: maasserver_dhcps_node_id_33e70277c1b8c11e_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3495 | --- |
3496 | - |
3497 | -ALTER TABLE ONLY maasserver_dhcpsnippet |
3498 | - ADD CONSTRAINT maasserver_dhcps_node_id_33e70277c1b8c11e_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3499 | - |
3500 | - |
3501 | --- |
3502 | --- Name: maasserver_event_node_id_3a43280367bbacb2_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3503 | --- |
3504 | - |
3505 | -ALTER TABLE ONLY maasserver_event |
3506 | - ADD CONSTRAINT maasserver_event_node_id_3a43280367bbacb2_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3507 | - |
3508 | - |
3509 | --- |
3510 | --- Name: maasserver_files_node_id_279557a726406a27_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3511 | + ADD CONSTRAINT maasserver_d_domain_id_55bf6442c94efe97_fk_maasserver_domain_id FOREIGN KEY (domain_id) REFERENCES maasserver_domain(id) DEFERRABLE INITIALLY DEFERRED; |
3512 | + |
3513 | + |
3514 | +-- |
3515 | +-- Name: maasserver_dh_subnet_id_62c0918cb5993da_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3516 | +-- |
3517 | + |
3518 | +ALTER TABLE ONLY maasserver_dhcpsnippet |
3519 | + ADD CONSTRAINT maasserver_dh_subnet_id_62c0918cb5993da_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3520 | + |
3521 | + |
3522 | +-- |
3523 | +-- Name: maasserver_dhcps_node_id_68d14f832e74c81a_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3524 | +-- |
3525 | + |
3526 | +ALTER TABLE ONLY maasserver_dhcpsnippet |
3527 | + ADD CONSTRAINT maasserver_dhcps_node_id_68d14f832e74c81a_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3528 | + |
3529 | + |
3530 | +-- |
3531 | +-- Name: maasserver_e_type_id_79f1669d059b1c0_fk_maasserver_eventtype_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3532 | +-- |
3533 | + |
3534 | +ALTER TABLE ONLY maasserver_event |
3535 | + ADD CONSTRAINT maasserver_e_type_id_79f1669d059b1c0_fk_maasserver_eventtype_id FOREIGN KEY (type_id) REFERENCES maasserver_eventtype(id) DEFERRABLE INITIALLY DEFERRED; |
3536 | + |
3537 | + |
3538 | +-- |
3539 | +-- Name: maasserver_event_node_id_12a74e61c2e717e_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3540 | +-- |
3541 | + |
3542 | +ALTER TABLE ONLY maasserver_event |
3543 | + ADD CONSTRAINT maasserver_event_node_id_12a74e61c2e717e_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3544 | + |
3545 | + |
3546 | +-- |
3547 | +-- Name: maasserver_files_node_id_4f1751c748c09b77_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3548 | -- |
3549 | |
3550 | ALTER TABLE ONLY maasserver_filesystem |
3551 | - ADD CONSTRAINT maasserver_files_node_id_279557a726406a27_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3552 | + ADD CONSTRAINT maasserver_files_node_id_4f1751c748c09b77_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3553 | |
3554 | |
3555 | -- |
3556 | --- Name: maasserver_filestorag_owner_id_4b93561b2472977a_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3557 | +-- Name: maasserver_filestorag_owner_id_365a64ac12d8cdca_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3558 | -- |
3559 | |
3560 | ALTER TABLE ONLY maasserver_filestorage |
3561 | - ADD CONSTRAINT maasserver_filestorag_owner_id_4b93561b2472977a_fk_auth_user_id FOREIGN KEY (owner_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3562 | - |
3563 | - |
3564 | --- |
3565 | --- Name: maasserver_i_subnet_id_394517ace84223b9_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3566 | --- |
3567 | - |
3568 | -ALTER TABLE ONLY maasserver_iprange |
3569 | - ADD CONSTRAINT maasserver_i_subnet_id_394517ace84223b9_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3570 | - |
3571 | - |
3572 | --- |
3573 | --- Name: maasserver_inter_vlan_id_489e0bd634df81d1_fk_maasserver_vlan_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3574 | --- |
3575 | - |
3576 | -ALTER TABLE ONLY maasserver_interface |
3577 | - ADD CONSTRAINT maasserver_inter_vlan_id_489e0bd634df81d1_fk_maasserver_vlan_id FOREIGN KEY (vlan_id) REFERENCES maasserver_vlan(id) DEFERRABLE INITIALLY DEFERRED; |
3578 | - |
3579 | - |
3580 | --- |
3581 | --- Name: maasserver_interf_node_id_64aa1a4431bb9fb_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3582 | --- |
3583 | - |
3584 | -ALTER TABLE ONLY maasserver_interface |
3585 | - ADD CONSTRAINT maasserver_interf_node_id_64aa1a4431bb9fb_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3586 | - |
3587 | - |
3588 | --- |
3589 | --- Name: maasserver_iprange_user_id_a7a93a0779c78a_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3590 | --- |
3591 | - |
3592 | -ALTER TABLE ONLY maasserver_iprange |
3593 | - ADD CONSTRAINT maasserver_iprange_user_id_a7a93a0779c78a_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3594 | - |
3595 | - |
3596 | --- |
3597 | --- Name: maasserver_n_domain_id_2eb62cb821b7c4cc_fk_maasserver_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3598 | + ADD CONSTRAINT maasserver_filestorag_owner_id_365a64ac12d8cdca_fk_auth_user_id FOREIGN KEY (owner_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3599 | + |
3600 | + |
3601 | +-- |
3602 | +-- Name: maasserver_i_subnet_id_431aa3189f54cf3a_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3603 | +-- |
3604 | + |
3605 | +ALTER TABLE ONLY maasserver_iprange |
3606 | + ADD CONSTRAINT maasserver_i_subnet_id_431aa3189f54cf3a_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3607 | + |
3608 | + |
3609 | +-- |
3610 | +-- Name: maasserver_inter_node_id_309152590d8c0375_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3611 | +-- |
3612 | + |
3613 | +ALTER TABLE ONLY maasserver_interface |
3614 | + ADD CONSTRAINT maasserver_inter_node_id_309152590d8c0375_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3615 | + |
3616 | + |
3617 | +-- |
3618 | +-- Name: maasserver_inter_vlan_id_4ad576e3d206866a_fk_maasserver_vlan_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3619 | +-- |
3620 | + |
3621 | +ALTER TABLE ONLY maasserver_interface |
3622 | + ADD CONSTRAINT maasserver_inter_vlan_id_4ad576e3d206866a_fk_maasserver_vlan_id FOREIGN KEY (vlan_id) REFERENCES maasserver_vlan(id) DEFERRABLE INITIALLY DEFERRED; |
3623 | + |
3624 | + |
3625 | +-- |
3626 | +-- Name: maasserver_iprange_user_id_2ca55fb2b580f69b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3627 | +-- |
3628 | + |
3629 | +ALTER TABLE ONLY maasserver_iprange |
3630 | + ADD CONSTRAINT maasserver_iprange_user_id_2ca55fb2b580f69b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3631 | + |
3632 | + |
3633 | +-- |
3634 | +-- Name: maasserver_n_domain_id_149ab04252b90b4e_fk_maasserver_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3635 | -- |
3636 | |
3637 | ALTER TABLE ONLY maasserver_node |
3638 | - ADD CONSTRAINT maasserver_n_domain_id_2eb62cb821b7c4cc_fk_maasserver_domain_id FOREIGN KEY (domain_id) REFERENCES maasserver_domain(id) DEFERRABLE INITIALLY DEFERRED; |
3639 | + ADD CONSTRAINT maasserver_n_domain_id_149ab04252b90b4e_fk_maasserver_domain_id FOREIGN KEY (domain_id) REFERENCES maasserver_domain(id) DEFERRABLE INITIALLY DEFERRED; |
3640 | |
3641 | |
3642 | -- |
3643 | --- Name: maasserver_n_subnet_id_48aaa0934baa1a70_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3644 | +-- Name: maasserver_n_subnet_id_64006182098718b9_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3645 | -- |
3646 | |
3647 | ALTER TABLE ONLY maasserver_nodegrouptorackcontroller |
3648 | - ADD CONSTRAINT maasserver_n_subnet_id_48aaa0934baa1a70_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3649 | - |
3650 | - |
3651 | --- |
3652 | --- Name: maasserver_nod_parent_id_53989c4af13ad213_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3653 | --- |
3654 | - |
3655 | -ALTER TABLE ONLY maasserver_node |
3656 | - ADD CONSTRAINT maasserver_nod_parent_id_53989c4af13ad213_fk_maasserver_node_id FOREIGN KEY (parent_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3657 | - |
3658 | - |
3659 | --- |
3660 | --- Name: maasserver_node__node_id_65df15c7b449e442_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3661 | --- |
3662 | - |
3663 | -ALTER TABLE ONLY maasserver_node_tags |
3664 | - ADD CONSTRAINT maasserver_node__node_id_65df15c7b449e442_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3665 | - |
3666 | - |
3667 | --- |
3668 | --- Name: maasserver_node_bmc_id_7cbecf30cbf5cb05_fk_maasserver_bmc_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3669 | --- |
3670 | - |
3671 | -ALTER TABLE ONLY maasserver_node |
3672 | - ADD CONSTRAINT maasserver_node_bmc_id_7cbecf30cbf5cb05_fk_maasserver_bmc_id FOREIGN KEY (bmc_id) REFERENCES maasserver_bmc(id) DEFERRABLE INITIALLY DEFERRED; |
3673 | - |
3674 | - |
3675 | --- |
3676 | --- Name: maasserver_node_owner_id_546ded0868b73ab6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3677 | --- |
3678 | - |
3679 | -ALTER TABLE ONLY maasserver_node |
3680 | - ADD CONSTRAINT maasserver_node_owner_id_546ded0868b73ab6_fk_auth_user_id FOREIGN KEY (owner_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3681 | - |
3682 | - |
3683 | --- |
3684 | --- Name: maasserver_node_ta_tag_id_2350e6c027e941ae_fk_maasserver_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3685 | --- |
3686 | - |
3687 | -ALTER TABLE ONLY maasserver_node_tags |
3688 | - ADD CONSTRAINT maasserver_node_ta_tag_id_2350e6c027e941ae_fk_maasserver_tag_id FOREIGN KEY (tag_id) REFERENCES maasserver_tag(id) DEFERRABLE INITIALLY DEFERRED; |
3689 | - |
3690 | - |
3691 | --- |
3692 | --- Name: maasserver_node_token_id_668d4c938eedde33_fk_piston3_token_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3693 | --- |
3694 | - |
3695 | -ALTER TABLE ONLY maasserver_node |
3696 | - ADD CONSTRAINT maasserver_node_token_id_668d4c938eedde33_fk_piston3_token_id FOREIGN KEY (token_id) REFERENCES piston3_token(id) DEFERRABLE INITIALLY DEFERRED; |
3697 | - |
3698 | - |
3699 | --- |
3700 | --- Name: maasserver_node_zone_id_21e97ed118223782_fk_maasserver_zone_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3701 | --- |
3702 | - |
3703 | -ALTER TABLE ONLY maasserver_node |
3704 | - ADD CONSTRAINT maasserver_node_zone_id_21e97ed118223782_fk_maasserver_zone_id FOREIGN KEY (zone_id) REFERENCES maasserver_zone(id) DEFERRABLE INITIALLY DEFERRED; |
3705 | - |
3706 | - |
3707 | --- |
3708 | --- Name: maasserver_notificatio_user_id_50fdc47bf9297613_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3709 | + ADD CONSTRAINT maasserver_n_subnet_id_64006182098718b9_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3710 | + |
3711 | + |
3712 | +-- |
3713 | +-- Name: maasserver_node__node_id_21732d24c097e4f8_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3714 | +-- |
3715 | + |
3716 | +ALTER TABLE ONLY maasserver_node_tags |
3717 | + ADD CONSTRAINT maasserver_node__node_id_21732d24c097e4f8_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3718 | + |
3719 | + |
3720 | +-- |
3721 | +-- Name: maasserver_node_bmc_id_3f29bfc0bad1e51d_fk_maasserver_bmc_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3722 | +-- |
3723 | + |
3724 | +ALTER TABLE ONLY maasserver_node |
3725 | + ADD CONSTRAINT maasserver_node_bmc_id_3f29bfc0bad1e51d_fk_maasserver_bmc_id FOREIGN KEY (bmc_id) REFERENCES maasserver_bmc(id) DEFERRABLE INITIALLY DEFERRED; |
3726 | + |
3727 | + |
3728 | +-- |
3729 | +-- Name: maasserver_node_owner_id_6a28d5651309e375_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3730 | +-- |
3731 | + |
3732 | +ALTER TABLE ONLY maasserver_node |
3733 | + ADD CONSTRAINT maasserver_node_owner_id_6a28d5651309e375_fk_auth_user_id FOREIGN KEY (owner_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3734 | + |
3735 | + |
3736 | +-- |
3737 | +-- Name: maasserver_node_parent_id_e01e2df39fefebc_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3738 | +-- |
3739 | + |
3740 | +ALTER TABLE ONLY maasserver_node |
3741 | + ADD CONSTRAINT maasserver_node_parent_id_e01e2df39fefebc_fk_maasserver_node_id FOREIGN KEY (parent_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3742 | + |
3743 | + |
3744 | +-- |
3745 | +-- Name: maasserver_node_tag_tag_id_ed44dfceaec21a5_fk_maasserver_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3746 | +-- |
3747 | + |
3748 | +ALTER TABLE ONLY maasserver_node_tags |
3749 | + ADD CONSTRAINT maasserver_node_tag_tag_id_ed44dfceaec21a5_fk_maasserver_tag_id FOREIGN KEY (tag_id) REFERENCES maasserver_tag(id) DEFERRABLE INITIALLY DEFERRED; |
3750 | + |
3751 | + |
3752 | +-- |
3753 | +-- Name: maasserver_node_token_id_49ef5f5b36066daa_fk_piston3_token_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3754 | +-- |
3755 | + |
3756 | +ALTER TABLE ONLY maasserver_node |
3757 | + ADD CONSTRAINT maasserver_node_token_id_49ef5f5b36066daa_fk_piston3_token_id FOREIGN KEY (token_id) REFERENCES piston3_token(id) DEFERRABLE INITIALLY DEFERRED; |
3758 | + |
3759 | + |
3760 | +-- |
3761 | +-- Name: maasserver_node_zone_id_3b4718dbc234b5e1_fk_maasserver_zone_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3762 | +-- |
3763 | + |
3764 | +ALTER TABLE ONLY maasserver_node |
3765 | + ADD CONSTRAINT maasserver_node_zone_id_3b4718dbc234b5e1_fk_maasserver_zone_id FOREIGN KEY (zone_id) REFERENCES maasserver_zone(id) DEFERRABLE INITIALLY DEFERRED; |
3766 | + |
3767 | + |
3768 | +-- |
3769 | +-- Name: maasserver_notificatio_user_id_34e48bb5ddb1b967_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3770 | -- |
3771 | |
3772 | ALTER TABLE ONLY maasserver_notification |
3773 | - ADD CONSTRAINT maasserver_notificatio_user_id_50fdc47bf9297613_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3774 | + ADD CONSTRAINT maasserver_notificatio_user_id_34e48bb5ddb1b967_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3775 | |
3776 | |
3777 | -- |
3778 | --- Name: maasserver_notificatio_user_id_73eaf37bfada1823_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3779 | +-- Name: maasserver_notificatio_user_id_7f4f6347758a84ce_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3780 | -- |
3781 | |
3782 | ALTER TABLE ONLY maasserver_notificationdismissal |
3783 | - ADD CONSTRAINT maasserver_notificatio_user_id_73eaf37bfada1823_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3784 | + ADD CONSTRAINT maasserver_notificatio_user_id_7f4f6347758a84ce_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3785 | |
3786 | |
3787 | -- |
3788 | --- Name: maasserver_owner_node_id_4719098c1c0cebff_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3789 | +-- Name: maasserver_owner_node_id_29f2c15d28dfdd8a_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3790 | -- |
3791 | |
3792 | ALTER TABLE ONLY maasserver_ownerdata |
3793 | - ADD CONSTRAINT maasserver_owner_node_id_4719098c1c0cebff_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3794 | - |
3795 | - |
3796 | --- |
3797 | --- Name: maasserver_r_observer_id_2ec9259fe318470c_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3798 | + ADD CONSTRAINT maasserver_owner_node_id_29f2c15d28dfdd8a_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3799 | + |
3800 | + |
3801 | +-- |
3802 | +-- Name: maasserver_podhint_pod_id_4ebb0860eb06ad5b_fk_maasserver_bmc_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3803 | +-- |
3804 | + |
3805 | +ALTER TABLE ONLY maasserver_podhints |
3806 | + ADD CONSTRAINT maasserver_podhint_pod_id_4ebb0860eb06ad5b_fk_maasserver_bmc_id FOREIGN KEY (pod_id) REFERENCES maasserver_bmc(id) DEFERRABLE INITIALLY DEFERRED; |
3807 | + |
3808 | + |
3809 | +-- |
3810 | +-- Name: maasserver_rd_observer_id_ca0e775ccf74f9e_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3811 | -- |
3812 | |
3813 | ALTER TABLE ONLY maasserver_rdns |
3814 | - ADD CONSTRAINT maasserver_r_observer_id_2ec9259fe318470c_fk_maasserver_node_id FOREIGN KEY (observer_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3815 | + ADD CONSTRAINT maasserver_rd_observer_id_ca0e775ccf74f9e_fk_maasserver_node_id FOREIGN KEY (observer_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3816 | |
3817 | |
3818 | -- |
3819 | --- Name: maasserver_reg_region_id_4784f373bd2649c9_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3820 | +-- Name: maasserver_reg_region_id_723ee65e9b09d8f9_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3821 | -- |
3822 | |
3823 | ALTER TABLE ONLY maasserver_regioncontrollerprocess |
3824 | - ADD CONSTRAINT maasserver_reg_region_id_4784f373bd2649c9_fk_maasserver_node_id FOREIGN KEY (region_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3825 | + ADD CONSTRAINT maasserver_reg_region_id_723ee65e9b09d8f9_fk_maasserver_node_id FOREIGN KEY (region_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3826 | |
3827 | |
3828 | -- |
3829 | --- Name: maasserver_relay_vlan_id_1872bbd03cd39efc_fk_maasserver_vlan_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3830 | +-- Name: maasserver_relay_vlan_id_745cb7d6f9595c3e_fk_maasserver_vlan_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3831 | -- |
3832 | |
3833 | ALTER TABLE ONLY maasserver_vlan |
3834 | - ADD CONSTRAINT maasserver_relay_vlan_id_1872bbd03cd39efc_fk_maasserver_vlan_id FOREIGN KEY (relay_vlan_id) REFERENCES maasserver_vlan(id) DEFERRABLE INITIALLY DEFERRED; |
3835 | + ADD CONSTRAINT maasserver_relay_vlan_id_745cb7d6f9595c3e_fk_maasserver_vlan_id FOREIGN KEY (relay_vlan_id) REFERENCES maasserver_vlan(id) DEFERRABLE INITIALLY DEFERRED; |
3836 | |
3837 | |
3838 | -- |
3839 | --- Name: maasserver_s_source_id_2d22befe6f13e28c_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3840 | +-- Name: maasserver_s_source_id_7b50256911141d10_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3841 | -- |
3842 | |
3843 | ALTER TABLE ONLY maasserver_staticroute |
3844 | - ADD CONSTRAINT maasserver_s_source_id_2d22befe6f13e28c_fk_maasserver_subnet_id FOREIGN KEY (source_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3845 | + ADD CONSTRAINT maasserver_s_source_id_7b50256911141d10_fk_maasserver_subnet_id FOREIGN KEY (source_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3846 | |
3847 | |
3848 | -- |
3849 | --- Name: maasserver_s_subnet_id_723038a631f126ae_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3850 | +-- Name: maasserver_s_subnet_id_5e7903874e286284_fk_maasserver_subnet_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3851 | -- |
3852 | |
3853 | ALTER TABLE ONLY maasserver_staticipaddress |
3854 | - ADD CONSTRAINT maasserver_s_subnet_id_723038a631f126ae_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3855 | + ADD CONSTRAINT maasserver_s_subnet_id_5e7903874e286284_fk_maasserver_subnet_id FOREIGN KEY (subnet_id) REFERENCES maasserver_subnet(id) DEFERRABLE INITIALLY DEFERRED; |
3856 | |
3857 | |
3858 | -- |
3859 | --- Name: maasserver_servi_node_id_249351472754bde5_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3860 | +-- Name: maasserver_servi_node_id_65a80971d0867f2e_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3861 | -- |
3862 | |
3863 | ALTER TABLE ONLY maasserver_service |
3864 | - ADD CONSTRAINT maasserver_servi_node_id_249351472754bde5_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3865 | + ADD CONSTRAINT maasserver_servi_node_id_65a80971d0867f2e_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3866 | |
3867 | |
3868 | -- |
3869 | --- Name: maasserver_sshkey_user_id_3b3c78c83e787920_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3870 | +-- Name: maasserver_sshkey_user_id_6e9941b65bce83bb_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3871 | -- |
3872 | |
3873 | ALTER TABLE ONLY maasserver_sshkey |
3874 | - ADD CONSTRAINT maasserver_sshkey_user_id_3b3c78c83e787920_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3875 | + ADD CONSTRAINT maasserver_sshkey_user_id_6e9941b65bce83bb_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3876 | |
3877 | |
3878 | -- |
3879 | --- Name: maasserver_sslkey_user_id_41a4dd14c9b4e341_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3880 | +-- Name: maasserver_sslkey_user_id_5584747c49154c22_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3881 | -- |
3882 | |
3883 | ALTER TABLE ONLY maasserver_sslkey |
3884 | - ADD CONSTRAINT maasserver_sslkey_user_id_41a4dd14c9b4e341_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3885 | + ADD CONSTRAINT maasserver_sslkey_user_id_5584747c49154c22_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3886 | |
3887 | |
3888 | -- |
3889 | --- Name: maasserver_staticipadd_user_id_7f83c117f9c43acf_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3890 | +-- Name: maasserver_staticipadd_user_id_61aa0e46edc6c259_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3891 | -- |
3892 | |
3893 | ALTER TABLE ONLY maasserver_staticipaddress |
3894 | - ADD CONSTRAINT maasserver_staticipadd_user_id_7f83c117f9c43acf_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3895 | + ADD CONSTRAINT maasserver_staticipadd_user_id_61aa0e46edc6c259_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3896 | |
3897 | |
3898 | -- |
3899 | --- Name: maasserver_subne_vlan_id_782ee6de53706cbe_fk_maasserver_vlan_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3900 | +-- Name: maasserver_subne_vlan_id_6a6ac3962742ae4a_fk_maasserver_vlan_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3901 | -- |
3902 | |
3903 | ALTER TABLE ONLY maasserver_subnet |
3904 | - ADD CONSTRAINT maasserver_subne_vlan_id_782ee6de53706cbe_fk_maasserver_vlan_id FOREIGN KEY (vlan_id) REFERENCES maasserver_vlan(id) DEFERRABLE INITIALLY DEFERRED; |
3905 | + ADD CONSTRAINT maasserver_subne_vlan_id_6a6ac3962742ae4a_fk_maasserver_vlan_id FOREIGN KEY (vlan_id) REFERENCES maasserver_vlan(id) DEFERRABLE INITIALLY DEFERRED; |
3906 | |
3907 | |
3908 | -- |
3909 | --- Name: maasserver_userprofile_user_id_627c1879a19812dc_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3910 | +-- Name: maasserver_userprofile_user_id_2ded56a7e7d3e0b3_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3911 | -- |
3912 | |
3913 | ALTER TABLE ONLY maasserver_userprofile |
3914 | - ADD CONSTRAINT maasserver_userprofile_user_id_627c1879a19812dc_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3915 | - |
3916 | - |
3917 | --- |
3918 | --- Name: maasserver_v_fabric_id_3993a8cd82cb944d_fk_maasserver_fabric_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3919 | --- |
3920 | - |
3921 | -ALTER TABLE ONLY maasserver_vlan |
3922 | - ADD CONSTRAINT maasserver_v_fabric_id_3993a8cd82cb944d_fk_maasserver_fabric_id FOREIGN KEY (fabric_id) REFERENCES maasserver_fabric(id) DEFERRABLE INITIALLY DEFERRED; |
3923 | - |
3924 | - |
3925 | --- |
3926 | --- Name: maasserver_vla_space_id_7755368be4b71620_fk_maasserver_space_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3927 | --- |
3928 | - |
3929 | -ALTER TABLE ONLY maasserver_vlan |
3930 | - ADD CONSTRAINT maasserver_vla_space_id_7755368be4b71620_fk_maasserver_space_id FOREIGN KEY (space_id) REFERENCES maasserver_space(id) DEFERRABLE INITIALLY DEFERRED; |
3931 | - |
3932 | - |
3933 | --- |
3934 | --- Name: metadata_script_id_470338caca32549f_fk_metadataserver_script_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3935 | + ADD CONSTRAINT maasserver_userprofile_user_id_2ded56a7e7d3e0b3_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
3936 | + |
3937 | + |
3938 | +-- |
3939 | +-- Name: maasserver_v_fabric_id_2af367b0b6169923_fk_maasserver_fabric_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3940 | +-- |
3941 | + |
3942 | +ALTER TABLE ONLY maasserver_vlan |
3943 | + ADD CONSTRAINT maasserver_v_fabric_id_2af367b0b6169923_fk_maasserver_fabric_id FOREIGN KEY (fabric_id) REFERENCES maasserver_fabric(id) DEFERRABLE INITIALLY DEFERRED; |
3944 | + |
3945 | + |
3946 | +-- |
3947 | +-- Name: maasserver_vla_space_id_32407e808ec0d03c_fk_maasserver_space_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3948 | +-- |
3949 | + |
3950 | +ALTER TABLE ONLY maasserver_vlan |
3951 | + ADD CONSTRAINT maasserver_vla_space_id_32407e808ec0d03c_fk_maasserver_space_id FOREIGN KEY (space_id) REFERENCES maasserver_space(id) DEFERRABLE INITIALLY DEFERRED; |
3952 | + |
3953 | + |
3954 | +-- |
3955 | +-- Name: metadatas_script_id_eff2c5a744f9b61_fk_metadataserver_script_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3956 | -- |
3957 | |
3958 | ALTER TABLE ONLY metadataserver_scriptresult |
3959 | - ADD CONSTRAINT metadata_script_id_470338caca32549f_fk_metadataserver_script_id FOREIGN KEY (script_id) REFERENCES metadataserver_script(id) DEFERRABLE INITIALLY DEFERRED; |
3960 | + ADD CONSTRAINT metadatas_script_id_eff2c5a744f9b61_fk_metadataserver_script_id FOREIGN KEY (script_id) REFERENCES metadataserver_script(id) DEFERRABLE INITIALLY DEFERRED; |
3961 | |
3962 | |
3963 | -- |
3964 | --- Name: metadataserver_n_node_id_56685b2e68e0b99c_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3965 | +-- Name: metadataserver_n_node_id_4f1618970edd883d_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3966 | -- |
3967 | |
3968 | ALTER TABLE ONLY metadataserver_nodekey |
3969 | - ADD CONSTRAINT metadataserver_n_node_id_56685b2e68e0b99c_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3970 | + ADD CONSTRAINT metadataserver_n_node_id_4f1618970edd883d_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3971 | |
3972 | |
3973 | -- |
3974 | --- Name: metadataserver_n_node_id_56f03be1d74e291f_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3975 | +-- Name: metadataserver_no_node_id_61ed827e2d95e55_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3976 | -- |
3977 | |
3978 | ALTER TABLE ONLY metadataserver_nodeuserdata |
3979 | - ADD CONSTRAINT metadataserver_n_node_id_56f03be1d74e291f_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3980 | + ADD CONSTRAINT metadataserver_no_node_id_61ed827e2d95e55_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
3981 | |
3982 | |
3983 | -- |
3984 | --- Name: metadataserver_no_token_id_70210e962874d481_fk_piston3_token_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3985 | +-- Name: metadataserver_no_token_id_288e0b07cea1ae04_fk_piston3_token_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3986 | -- |
3987 | |
3988 | ALTER TABLE ONLY metadataserver_nodekey |
3989 | - ADD CONSTRAINT metadataserver_no_token_id_70210e962874d481_fk_piston3_token_id FOREIGN KEY (token_id) REFERENCES piston3_token(id) DEFERRABLE INITIALLY DEFERRED; |
3990 | + ADD CONSTRAINT metadataserver_no_token_id_288e0b07cea1ae04_fk_piston3_token_id FOREIGN KEY (token_id) REFERENCES piston3_token(id) DEFERRABLE INITIALLY DEFERRED; |
3991 | |
3992 | |
3993 | -- |
3994 | --- Name: metadataserver_s_node_id_2ee92379b6b0e63f_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3995 | +-- Name: metadataserver_s_node_id_79140ef84c98ceeb_fk_maasserver_node_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3996 | -- |
3997 | |
3998 | ALTER TABLE ONLY metadataserver_scriptset |
3999 | - ADD CONSTRAINT metadataserver_s_node_id_2ee92379b6b0e63f_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
4000 | + ADD CONSTRAINT metadataserver_s_node_id_79140ef84c98ceeb_fk_maasserver_node_id FOREIGN KEY (node_id) REFERENCES maasserver_node(id) DEFERRABLE INITIALLY DEFERRED; |
4001 | |
4002 | |
4003 | -- |
4004 | --- Name: notification_id_23226db2108b3ab6_fk_maasserver_notification_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4005 | +-- Name: notification_id_43a6259c276f65e1_fk_maasserver_notification_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4006 | -- |
4007 | |
4008 | ALTER TABLE ONLY maasserver_notificationdismissal |
4009 | - ADD CONSTRAINT notification_id_23226db2108b3ab6_fk_maasserver_notification_id FOREIGN KEY (notification_id) REFERENCES maasserver_notification(id) DEFERRABLE INITIALLY DEFERRED; |
4010 | + ADD CONSTRAINT notification_id_43a6259c276f65e1_fk_maasserver_notification_id FOREIGN KEY (notification_id) REFERENCES maasserver_notification(id) DEFERRABLE INITIALLY DEFERRED; |
4011 | |
4012 | |
4013 | -- |
4014 | --- Name: piston3_consumer_user_id_224c303158c9d9e_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4015 | +-- Name: piston3_consumer_user_id_2c68b5d7b79383ed_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4016 | -- |
4017 | |
4018 | ALTER TABLE ONLY piston3_consumer |
4019 | - ADD CONSTRAINT piston3_consumer_user_id_224c303158c9d9e_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
4020 | - |
4021 | - |
4022 | --- |
4023 | --- Name: piston3_tok_consumer_id_2a37a82bc97a7522_fk_piston3_consumer_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4024 | --- |
4025 | - |
4026 | -ALTER TABLE ONLY piston3_token |
4027 | - ADD CONSTRAINT piston3_tok_consumer_id_2a37a82bc97a7522_fk_piston3_consumer_id FOREIGN KEY (consumer_id) REFERENCES piston3_consumer(id) DEFERRABLE INITIALLY DEFERRED; |
4028 | - |
4029 | - |
4030 | --- |
4031 | --- Name: piston3_token_user_id_20ff125368a570_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4032 | --- |
4033 | - |
4034 | -ALTER TABLE ONLY piston3_token |
4035 | - ADD CONSTRAINT piston3_token_user_id_20ff125368a570_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
4036 | - |
4037 | - |
4038 | --- |
4039 | --- Name: version_id_7b356ba457b1caff_fk_maasserver_versionedtextfile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4040 | + ADD CONSTRAINT piston3_consumer_user_id_2c68b5d7b79383ed_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
4041 | + |
4042 | + |
4043 | +-- |
4044 | +-- Name: piston3_tok_consumer_id_281253f477a4b311_fk_piston3_consumer_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4045 | +-- |
4046 | + |
4047 | +ALTER TABLE ONLY piston3_token |
4048 | + ADD CONSTRAINT piston3_tok_consumer_id_281253f477a4b311_fk_piston3_consumer_id FOREIGN KEY (consumer_id) REFERENCES piston3_consumer(id) DEFERRABLE INITIALLY DEFERRED; |
4049 | + |
4050 | + |
4051 | +-- |
4052 | +-- Name: piston3_token_user_id_6f718e5694c253f3_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4053 | +-- |
4054 | + |
4055 | +ALTER TABLE ONLY piston3_token |
4056 | + ADD CONSTRAINT piston3_token_user_id_6f718e5694c253f3_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; |
4057 | + |
4058 | + |
4059 | +-- |
4060 | +-- Name: version_id_3ad53cfd8863df46_fk_maasserver_versionedtextfile_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
4061 | -- |
4062 | |
4063 | ALTER TABLE ONLY maasserver_template |
4064 | - ADD CONSTRAINT version_id_7b356ba457b1caff_fk_maasserver_versionedtextfile_id FOREIGN KEY (version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
4065 | + ADD CONSTRAINT version_id_3ad53cfd8863df46_fk_maasserver_versionedtextfile_id FOREIGN KEY (version_id) REFERENCES maasserver_versionedtextfile(id) DEFERRABLE INITIALLY DEFERRED; |
4066 | |
4067 | |
4068 | -- |
Selfie.