13
message StorageEngine {
15
message EngineOption {
16
enum EngineOptionType {
22
required string option_name = 1;
23
required string option_value = 2;
24
required EngineOptionType option_type = 3;
27
required string name = 1;
28
repeated EngineOption option = 2;
31
18
message TableOptions {
32
optional uint64 auto_increment = 1;
19
optional bool has_user_set_auto_increment_value = 1;
33
20
optional string collation = 2;
34
21
optional uint32 collation_id = 3;
35
22
optional string data_file_name = 5;
38
25
optional uint64 min_rows = 8;
39
26
optional uint64 auto_increment_value = 9;
40
27
optional uint32 avg_row_length = 11;
41
optional uint32 key_block_size = 12;
42
28
optional uint32 block_size = 13;
43
29
optional string comment = 14;
44
optional bool pack_keys = 15;
45
30
optional bool pack_record = 16;
46
31
optional bool checksum = 17;
47
32
optional bool page_checksum = 18;
48
33
optional bool delay_key_write = 19;
54
ROW_TYPE_COMPRESSED = 3;
55
ROW_TYPE_REDUNDANT = 4;
60
optional RowType row_type = 20;
64
optional uint32 avg_row_length = 1;
65
optional uint64 max_rows = 2;
66
optional uint32 min_rows = 3;
69
36
message ForeignKeyConstraint {
70
required string name = 1;
71
required Field dependent = 2;
72
required Field parent = 3;
73
/** @TODO Finish this off... */
37
optional string name = 1;
38
repeated string column_names = 2;
39
required string references_table_name = 3;
40
repeated string references_columns = 4;
42
enum ForeignKeyMatchOption {
48
required ForeignKeyMatchOption match = 5;
50
enum ForeignKeyOption {
59
required ForeignKeyOption update_option = 6 [ default = OPTION_UNDEF ];
60
required ForeignKeyOption delete_option = 7 [ default = OPTION_UNDEF ];
91
enum FieldFormatType {
97
78
message FieldOptions {
98
79
optional string default_value = 1;
99
80
optional string update_value = 2;
100
81
optional bool default_null = 3 [default = false];
101
82
optional bytes default_bin_value = 4;
104
message TimestampFieldOptions {
105
optional bool auto_updates = 1 [default = false];
83
optional string default_expression = 5;
84
optional string update_expression = 6;
108
87
message FieldConstraints {
133
112
required string name = 1;
134
113
required FieldType type = 2;
135
optional FieldFormatType format = 3;
136
114
optional FieldOptions options = 4;
137
115
optional FieldConstraints constraints = 5;
138
116
optional NumericFieldOptions numeric_options = 6;
158
135
required uint32 fieldnr = 1;
159
136
optional uint32 compare_length = 2;
160
137
optional bool in_reverse_order = 3 [default = false];
162
optional uint32 key_type = 101; /* THIS MUST DIE. Along with pack_flag*/
165
message IndexOptions {
166
141
optional bool pack_key = 1;
167
142
optional bool binary_pack_key = 2;
168
143
optional bool var_length_key = 3;
178
153
required IndexType type = 4 [default = UNKNOWN_INDEX];
179
154
required uint32 key_length = 5;
180
155
repeated IndexPart index_part = 6;
181
optional IndexOptions options= 7;
156
optional Options options= 7;
182
157
optional string comment = 8;
185
160
required string name = 1;
186
161
required string schema = 6;
187
162
required TableType type = 5;
188
required StorageEngine engine = 2;
163
required Engine engine = 2;
189
164
repeated Field field = 3;
190
165
repeated Index indexes = 4;
192
167
repeated ForeignKeyConstraint fk_constraint = 8;
193
168
optional TableOptions options = 9;
194
optional TableStats stats = 10;
195
169
required uint64 creation_timestamp= 11 [default = 0];
196
170
required uint64 update_timestamp= 12 [default = 0];
197
171
optional string catalog = 13;