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' , 'test1' ];
25
# Example: table<rows>
26
rows => [ 0 , 1 , 10] ,
28
# partitions => [ undef , 'KEY (pk) PARTITIONS 2' ] ,
29
# Currently not tested
31
# Example: table<rows> , table<rows>_<engine>
32
engines => [ undef , 'MyISAM' , 'InnoDB' ] ,
34
# Example: table<rows>_<engine>_<pk column data type> like table0_myisam_int_autoinc
35
# Enable the next line when the RPL team says it is time to do this
36
# + modify conf/replication/replication-ddl_sql.yy so that tables with names like
37
# table<number> and table<number>_<engine> are used
38
# pk => [ 'int auto_increment' , 'int' , undef ]
39
pk => [ 'int auto_increment' , 'int' ]
42
# In the moment we can suffer from
43
# Bug #49481 RBR: MyISAM and bit fields may cause slave to stop on delete: cant find record
44
# Bug #49482 RBR: Replication may break on deletes when MyISAM tables + char field are used
49
# 'bit' , 'bit(4)' , 'bit(64)' ,
51
# 'smallint' , 'mediumint' , 'int' ,
53
# Enable the next line in case
54
# Bug#50511 Sometimes wrong handling of user variables containing NULL
56
# 'float' , 'double' ,
58
# decimal(M,N) is not supported by RQG. I would have taken decimal(65,30),decimal(10,0).
59
# Enable the next line in case
60
# Bug#49533: Overflow in DECIMAL, SBR out of sync
62
# 'decimal' , 'decimal(35)' ,
64
# Manual: Specifying the CHARACTER SET binary attribute for a character data type causes
65
# the column to be created as the corresponding binary data type:
66
# CHAR becomes BINARY, VARCHAR becomes VARBINARY, and TEXT becomes BLOB.
67
# We do not mention *BINARY and BLOB here + but have 'binary' between the charsets.
70
# 'varchar' , 'varchar(10)' ,
72
# Not all storage engines support text
73
# 'tinytext' , 'text' , 'mediumtext' , 'longtext' ,
75
# 'char' , 'char(10)' ,
77
# 'datetime' , 'date' ,
81
indexes => [ undef ] ,
82
# null => [ undef , 'not null' ] ,
83
# default => [ undef , 'default null' ] ,
84
sign => [ undef , 'unsigned' ] ,
85
charsets => [ 'utf8' , 'latin1' , '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' ]