Debian Codegraph @

mysql-test/suite/galera/r/fk.result

raw
1 connection node_2;
2 connection node_1;
3 USE test;
4
5 # On node_1
6 connection node_1;
7 CREATE TABLE networks (
8 `tenant_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
9 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
10 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
11 `status` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
12 `admin_state_up` tinyint(1) DEFAULT NULL,
13 `shared` tinyint(1) DEFAULT NULL,
14 PRIMARY KEY (`id`)
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
16 CREATE TABLE ports (
17 `tenant_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
18 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
19 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
20 `network_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
21 `mac_address` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
22 `admin_state_up` tinyint(1) NOT NULL,
23 `status` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
24 `device_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
25 `device_owner` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
26 PRIMARY KEY (`id`),
27 KEY `network_id` (`network_id`),
28 CONSTRAINT `ports_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES networks (`id`)
29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
30 CREATE TABLE subnets (
31 `tenant_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
32 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
33 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
34 `network_id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
35 `ip_version` int(11) NOT NULL,
36 `cidr` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
37 `gateway_ip` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
38 `enable_dhcp` tinyint(1) DEFAULT NULL,
39 `shared` tinyint(1) DEFAULT NULL,
40 `ipv6_ra_mode` enum('slaac','dhcpv6-stateful','dhcpv6-stateless') COLLATE utf8_unicode_ci DEFAULT NULL,
41 `ipv6_address_mode` enum('slaac','dhcpv6-stateful','dhcpv6-stateless') COLLATE utf8_unicode_ci DEFAULT NULL,
42 PRIMARY KEY (`id`),
43 KEY `network_id` (`network_id`),
44 CONSTRAINT `subnets_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES networks (`id`)
45 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
46 CREATE TABLE `ipallocations` (
47 `port_id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
48 `ip_address` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
49 `subnet_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
50 `network_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
51 PRIMARY KEY (`ip_address`,`subnet_id`,`network_id`),
52 KEY `port_id` (`port_id`),
53 KEY `subnet_id` (`subnet_id`),
54 KEY `network_id` (`network_id`),
55 CONSTRAINT `ipallocations_ibfk_1` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE,
56 CONSTRAINT `ipallocations_ibfk_2` FOREIGN KEY (`subnet_id`) REFERENCES `subnets` (`id`) ON DELETE CASCADE,
57 CONSTRAINT `ipallocations_ibfk_3` FOREIGN KEY (`network_id`) REFERENCES `networks` (`id`) ON DELETE CASCADE
58 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
59 INSERT INTO networks VALUES ('f37aa3fe-ab99-4d0f-a566-6cd3169d7516','f37aa3fe-ab99-4d0f-a566-6cd3169d7516','MyNet','ACTIVE',0,0);
60 INSERT INTO ports VALUES ('','f37aa3fe-ab99-4d0f-a566-6cd3169d7516','','f37aa3fe-ab99-4d0f-a566-6cd3169d7516','fa:16:3e:e3:cc:bb',1,'DOWN','f37aa3fe-ab99-4d0f-a566-6cd3169d7516','network:router_gateway');
61 INSERT INTO subnets VALUES ('f37aa3fe-ab99-4d0f-a566-6cd3169d7516','f37aa3fe-ab99-4d0f-a566-6cd3169d7516','ext-subnet','f37aa3fe-ab99-4d0f-a566-6cd3169d7516',4,'10.25.0.0/24','10.25.0.4',0,1,NULL,NULL);
62 INSERT INTO ipallocations VALUES ('f37aa3fe-ab99-4d0f-a566-6cd3169d7516','10.25.0.17','f37aa3fe-ab99-4d0f-a566-6cd3169d7516','f37aa3fe-ab99-4d0f-a566-6cd3169d7516');
63 select * from ports where ports.id = 'f37aa3fe-ab99-4d0f-a566-6cd3169d7516';
64 tenant_id id name network_id mac_address admin_state_up status device_id device_owner
65 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 fa:16:3e:e3:cc:bb 1 DOWN f37aa3fe-ab99-4d0f-a566-6cd3169d7516 network:router_gateway
66 connection node_2;
67 select * from ports where ports.id = 'f37aa3fe-ab99-4d0f-a566-6cd3169d7516';
68 tenant_id id name network_id mac_address admin_state_up status device_id device_owner
69 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 fa:16:3e:e3:cc:bb 1 DOWN f37aa3fe-ab99-4d0f-a566-6cd3169d7516 network:router_gateway
70 connection node_1;
71 DELETE FROM ports WHERE ports.id = 'f37aa3fe-ab99-4d0f-a566-6cd3169d7516';
72 select * from networks;
73 tenant_id id name status admin_state_up shared
74 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 MyNet ACTIVE 0 0
75 select * from ports;
76 tenant_id id name network_id mac_address admin_state_up status device_id device_owner
77 select * from subnets;
78 tenant_id id name network_id ip_version cidr gateway_ip enable_dhcp shared ipv6_ra_mode ipv6_address_mode
79 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 ext-subnet f37aa3fe-ab99-4d0f-a566-6cd3169d7516 4 10.25.0.0/24 10.25.0.4 0 1 NULL NULL
80 select * from ipallocations;
81 port_id ip_address subnet_id network_id
82 select * from ports;
83 tenant_id id name network_id mac_address admin_state_up status device_id device_owner
84
85 # On node_2
86 connection node_2;
87 select * from networks;
88 tenant_id id name status admin_state_up shared
89 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 MyNet ACTIVE 0 0
90 select * from ports;
91 tenant_id id name network_id mac_address admin_state_up status device_id device_owner
92 select * from subnets;
93 tenant_id id name network_id ip_version cidr gateway_ip enable_dhcp shared ipv6_ra_mode ipv6_address_mode
94 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 f37aa3fe-ab99-4d0f-a566-6cd3169d7516 ext-subnet f37aa3fe-ab99-4d0f-a566-6cd3169d7516 4 10.25.0.0/24 10.25.0.4 0 1 NULL NULL
95 select * from ipallocations;
96 port_id ip_address subnet_id network_id
97 select * from ports;
98 tenant_id id name network_id mac_address admin_state_up status device_id device_owner
99 connection node_1;
100 drop table ipallocations;
101 drop table subnets;
102 drop table ports;
103 drop table networks;
104 disconnect node_2;
105 disconnect node_1;