Merge lp:~allenap/maas/initial-test-data-2017-03-23 into lp:~maas-committers/maas/trunk

Proposed by Gavin Panella
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
Reviewer Review Type Date Requested Status
Gavin Panella (community) Approve
Review via email: mp+320871@code.launchpad.net

Commit message

Update initial test data.

To post a comment you must log in.
Revision history for this message
Gavin Panella (allenap) wrote :

Selfie.

review: Approve
Revision history for this message
MAAS Lander (maas-lander) wrote :
Download full text (1.8 MiB)

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://prodstack-zone-2.clouds.archive.ubuntu.com/ubuntu xenial InRelease
Get:2 http://prodstack-zone-2.clouds.archive.ubuntu.com/ubuntu xenial-updates InRelease [102 kB]
Get:3 http://prodstack-zone-2.clouds.archive.ubuntu.com/ubuntu xenial-backports InRelease [102 kB]
Get:4 http://security.ubuntu.com/ubuntu xenial-security InRelease [102 kB]
Fetched 306 kB in 0s (638 kB/s)
Reading package lists...
sudo DEBIAN_FRONTEND=noninteractive apt-get -y \
    --no-install-recommends install apache2 archdetect-deb authbind avahi-utils bash bind9 bind9utils build-essential bzr bzr-builddeb chromium-browser chromium-chromedriver curl daemontools debhelper dh-apport dh-systemd distro-info dnsutils firefox freeipmi-tools git gjs ipython isc-dhcp-common isc-dhcp-server libjs-angularjs libjs-jquery libjs-jquery-hotkeys libjs-yui3-full libjs-yui3-min libnss-wrapper libpq-dev make nodejs-legacy npm postgresql psmisc pxelinux python3-all python3-apt python3-attr python3-bson python3-convoy python3-crochet python3-cssselect python3-curtin python3-dev python3-distro-info python3-django python3-django-nose python3-django-piston3 python3-dnspython python3-docutils python3-formencode python3-hivex python3-httplib2 python3-jinja2 python3-jsonschema python3-lxml python3-netaddr python3-netifaces python3-novaclient python3-oauth python3-oauthlib python3-openssl python3-paramiko python3-petname python3-pexpect python3-psycopg2 python3-pyinotify python3-pyparsing python3-pyvmomi python3-requests python3-seamicroclient python3-setuptools python3-simplestreams python3-sphinx python3-tempita python3-twisted python3-txtftp python3-tz python3-yaml python3-zope.interface python-bson python-crochet python-django python-django-piston python-djorm-ext-pgarray python-formencode python-lxml python-netaddr python-netifaces python-pocket-lint python-psycopg2 python-simplejson python-tempita python-twisted python-yaml socat syslinux-common tgt ubuntu-cloudimage-keyring wget xvfb
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~rc+dfsg-1ubuntu2).
build-essential is already the newest version (12.1ubuntu2).
debhelper is already the newest version (9.20160115ubuntu3).
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+dfsg-11ubuntu1).
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...

Revision history for this message
Gavin Panella (allenap) wrote :

The spurious test failure has been filed as bug 1675823.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
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 --