1
# Copyright (C) 2009-2010 Sun Microsystems, Inc. All rights reserved.
2
# Use is subject to license terms.
4
# This program is free software; you can redistribute it and/or modify
5
# it under the terms of the GNU General Public License as published by
6
# the Free Software Foundation; version 2 of the License.
8
# This program is distributed in the hope that it will be useful, but
9
# WITHOUT ANY WARRANTY; without even the implied warranty of
10
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
11
# General Public License for more details.
13
# You should have received a copy of the GNU General Public License
14
# along with this program; if not, write to the Free Software
15
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
18
# Attention: If you modify something under $tables than the amount and the names of
19
# the tables will change and this requires adjustments in
20
# conf/replication/replication-dml_sql.yy *_table
22
$schemas = [ 'test' ];
25
# Example: table<rows>
28
# partitions => [ undef , 'KEY (pk) PARTITIONS 2' ] ,
29
# Currently not tested
31
# Example: table<rows> , table<rows>_<engine>
32
engines => [ 'MyISAM' , 'InnoDB' ] ,
34
# Example: table<rows>_<engine>_<pk column data type> like table0_myisam_int_autoinc
35
# The preferred PK variation is within the next line.
36
# pk => [ 'int auto_increment' , 'int' , undef ]
39
# - "undef" when the RPL team says it is time to do this
40
# - "auto_increment" when
41
# Bug#50619 assert in handler::update_auto_increment
42
# Bug#46902 Assertion failed: next_insert_id >= auto_inc_interval_for_cur_row.minimum()
44
# and modify conf/replication/replication-ddl_sql.yy so that tables with names like
45
# table<number> and table<number>_<engine> are used.
47
pk => [ 'int auto_increment' ]
52
# a) CHAR(25) - constant length sqlmode PAD WITH SPACES...
53
# b) VARCHAR(25) - less than 255 characters
54
# c) VARCHAR(257) - more than 255 characters
55
# d) BIT ... - less than 1 Byte
56
# e) BIGINT - it's so simple and useful for keys
57
# f) DECIMAL - non easy structure but maybe not important
58
# g) FLOAT - non easy structure but maybe not important
59
# h) BLOB - special treatment if BINLOG_ROW_IMAGE = noblob
62
'bit(4)' , 'bit(64)' ,
63
'tinyint' , 'bigint' ,
66
# decimal(M,N) is not supported by RQG. I would have taken decimal(65,30),decimal(10,0).
67
# Enable the next line in case
68
# Bug#49533 Overflow in DECIMAL, SBR out of sync
69
# Bug#53643 assert in Field_new_decimal::store_value on slave server
73
# Manual: Specifying the CHARACTER SET binary attribute for a character data type causes
74
# the column to be created as the corresponding binary data type:
75
# CHAR becomes BINARY, VARCHAR becomes VARBINARY, and TEXT becomes BLOB.
76
# We do not mention *BINARY and BLOB here + but have 'binary' between the charsets.
81
indexes => [ undef ] ,
82
null => [ 'default null' , 'not null' ] ,
83
# default => [ undef , 'default null' ] ,
85
charsets => [ undef , 'binary' ]
89
numbers => [ 'digit' , 'null' , undef ],
90
strings => [ 'letter' , 'english' , 'null' ],
91
blobs => [ 'english', 'data' ],
92
temporals => [ undef , 'null' , 'time' , 'date' , 'datetime' , 'year(2)' , 'year(4)' , 'timestamp' ]