Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE IF NOT EXISTS wsrep_cluster
4 (
5 cluster_uuid CHAR(36) PRIMARY KEY,
6 view_id BIGINT NOT NULL,
7 view_seqno BIGINT NOT NULL,
8 protocol_version INT NOT NULL,
9 capabilities INT NOT NULL
10 ) ENGINE=InnoDB;
11 CREATE TABLE IF NOT EXISTS wsrep_cluster_members
12 (
13 node_uuid CHAR(36) PRIMARY KEY,
14 cluster_uuid CHAR(36) NOT NULL,
15 node_name CHAR(32) NOT NULL,
16 node_incoming_address VARCHAR(256) NOT NULL
17 ) ENGINE=InnoDB;
18 CREATE TABLE IF NOT EXISTS wsrep_cluster_members_history
19 (
20 node_uuid CHAR(36) PRIMARY KEY,
21 cluster_uuid CHAR(36) NOT NULL,
22 last_view_id BIGINT NOT NULL,
23 last_view_seqno BIGINT NOT NULL,
24 node_name CHAR(32) NOT NULL,
25 node_incoming_address VARCHAR(256) NOT NULL
26 ) ENGINE=InnoDB;
27 CREATE TABLE IF NOT EXISTS wsrep_streaming_log
28 (
29 node_uuid CHAR(36),
30 trx_id BIGINT,
31 seqno BIGINT,
32 flags INT NOT NULL,
33 frag LONGBLOB NOT NULL,
34 PRIMARY KEY (node_uuid, trx_id, seqno)
35 ) ENGINE=InnoDB;
36 DELETE FROM wsrep_cluster;
37 DELETE FROM wsrep_cluster_members;
38 ALTER TABLE wsrep_cluster STATS_PERSISTENT=0;
39 ALTER TABLE wsrep_cluster_members STATS_PERSISTENT=0;
40 ALTER TABLE wsrep_cluster_members_history STATS_PERSISTENT=0;
41 ALTER TABLE wsrep_streaming_log STATS_PERSISTENT=0;
42 SHOW CREATE TABLE wsrep_cluster;
43 Table Create Table
44 wsrep_cluster CREATE TABLE `wsrep_cluster` (
45 `cluster_uuid` char(36) NOT NULL,
46 `view_id` bigint(20) NOT NULL,
47 `view_seqno` bigint(20) NOT NULL,
48 `protocol_version` int(11) NOT NULL,
49 `capabilities` int(11) NOT NULL,
50 PRIMARY KEY (`cluster_uuid`)
51 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci STATS_PERSISTENT=0
52 SHOW CREATE TABLE wsrep_cluster_members;
53 Table Create Table
54 wsrep_cluster_members CREATE TABLE `wsrep_cluster_members` (
55 `node_uuid` char(36) NOT NULL,
56 `cluster_uuid` char(36) NOT NULL,
57 `node_name` char(32) NOT NULL,
58 `node_incoming_address` varchar(256) NOT NULL,
59 PRIMARY KEY (`node_uuid`)
60 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci STATS_PERSISTENT=0
61 SHOW CREATE TABLE wsrep_cluster_members_history;
62 Table Create Table
63 wsrep_cluster_members_history CREATE TABLE `wsrep_cluster_members_history` (
64 `node_uuid` char(36) NOT NULL,
65 `cluster_uuid` char(36) NOT NULL,
66 `last_view_id` bigint(20) NOT NULL,
67 `last_view_seqno` bigint(20) NOT NULL,
68 `node_name` char(32) NOT NULL,
69 `node_incoming_address` varchar(256) NOT NULL,
70 PRIMARY KEY (`node_uuid`)
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci STATS_PERSISTENT=0
72 SHOW CREATE TABLE wsrep_streaming_log;
73 Table Create Table
74 wsrep_streaming_log CREATE TABLE `wsrep_streaming_log` (
75 `node_uuid` char(36) NOT NULL,
76 `trx_id` bigint(20) NOT NULL,
77 `seqno` bigint(20) NOT NULL,
78 `flags` int(11) NOT NULL,
79 `frag` longblob NOT NULL,
80 PRIMARY KEY (`node_uuid`,`trx_id`,`seqno`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci STATS_PERSISTENT=0
82 SHOW CREATE TABLE mysql.wsrep_cluster;
83 Table Create Table
84 wsrep_cluster CREATE TABLE `wsrep_cluster` (
85 `cluster_uuid` char(36) NOT NULL,
86 `view_id` bigint(20) NOT NULL,
87 `view_seqno` bigint(20) NOT NULL,
88 `protocol_version` int(11) NOT NULL,
89 `capabilities` int(11) NOT NULL,
90 PRIMARY KEY (`cluster_uuid`)
91 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci STATS_PERSISTENT=0
92 SHOW CREATE TABLE mysql.wsrep_cluster_members;
93 Table Create Table
94 wsrep_cluster_members CREATE TABLE `wsrep_cluster_members` (
95 `node_uuid` char(36) NOT NULL,
96 `cluster_uuid` char(36) NOT NULL,
97 `node_name` char(32) NOT NULL,
98 `node_incoming_address` varchar(256) NOT NULL,
99 PRIMARY KEY (`node_uuid`)
100 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci STATS_PERSISTENT=0
101 SHOW CREATE TABLE mysql.wsrep_streaming_log;
102 Table Create Table
103 wsrep_streaming_log CREATE TABLE `wsrep_streaming_log` (
104 `node_uuid` char(36) NOT NULL,
105 `trx_id` bigint(20) NOT NULL,
106 `seqno` bigint(20) NOT NULL,
107 `flags` int(11) NOT NULL,
108 `frag` longblob NOT NULL,
109 PRIMARY KEY (`node_uuid`,`trx_id`,`seqno`)
110 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci STATS_PERSISTENT=0
111 DROP TABLE wsrep_cluster;
112 DROP TABLE wsrep_cluster_members;
113 DROP TABLE wsrep_cluster_members_history;
114 DROP TABLE wsrep_streaming_log;