1
# Copyright (C) 2009 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] ,
27
# partitions => [ undef , 'KEY (pk) PARTITIONS 2' ] ,
28
# Example: table<rows> , table<rows>_<engine>
29
# engines => [ undef , 'MyISAM' , 'InnoDB' ] ,
30
engines => [ undef , 'MyISAM' ] ,
31
# Example: table<rows>_<engine>_<pk> like table0_myisam_int_autoinc
32
# Enable the next line when the RPL team says it is time to do this.
33
# pk => [ 'int auto_increment' , 'int' , undef ]
34
pk => [ 'int auto_increment' , 'int' ]
40
'bit' , 'bit(4)' , 'bit(64)' ,
41
'tinyint' , 'smallint' , 'mediumint' , 'int' ,
44
# decimal(M,N) is not supported by RQG. I would have taken decimal(65,30),decimal(10,0).
45
# decimal had to be disabled because of
46
# Bug#49533: Overflow in DECIMAL, SBR out of sync
47
# 'decimal' , 'decimal(35)' ,
49
# Manual: Specifying the CHARACTER SET binary attribute for a character data type causes
50
# the column to be created as the corresponding binary data type:
51
# CHAR becomes BINARY, VARCHAR becomes VARBINARY, and TEXT becomes BLOB.
52
# We do not mention *BINARY and BLOB here + but have 'binary' between the charsets.
55
'varchar' , 'varchar(10)' , 'varchar(257)' ,
56
# Not all storage engines support text
57
'tinytext' , 'text' , 'mediumtext' , 'longtext' ,
61
'datetime' , 'date' , 'timestamp' , 'time' ,'year'
63
indexes => [ undef ] ,
64
# null => [ undef , 'not null' ] ,
65
# default => [ undef , 'default null' ] ,
66
sign => [ undef , 'unsigned' ] ,
67
charsets => [ 'utf8' , 'latin1' , 'binary' ]
71
numbers => [ 'digit' , 'null' , undef ],
72
strings => [ 'letter' , 'english' , 'null' ],
73
blobs => [ 'english', 'english', 'english', 'english', 'english', 'english', 'english', 'english', 'english', 'data' ],
74
temporals => [ undef , 'null' , 'time' , 'date' , 'datetime' , 'year(2)' , 'year(4)' , 'timestamp' ]