percona_qa.zz

# Copyright (c) 2008, 2012 Oracle and/or its affiliates. All rights reserved.
# Use is subject to license terms.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
# General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
# USA
  #row_formats => ['DYNAMIC','COMPRESSED','DEFAULT']

# Certain parts (c) Percona Inc

$tables = {
  pk => [undef,'int','int auto_increment','varchar'],
  partitions => [ undef , 'KEY (pk) PARTITIONS 2' ],
  engines => ['InnoDB'],
  rows => [100,500],
  row_formats => ['DYNAMIC', 'Compressed', 'Default']
};

$fields = {
  types => ['varchar','char','int','blob','text','date'],
  indexes => [undef,'unique','key'],
  null => [undef,'not null'],
  default => [undef,'default null'],
  sign => [undef, 'unsigned'],
  charsets => ['utf8','latin1']
};

$data = {
  numbers => ['digit','null',undef],
  temporals => ['datetime','timestamp'],
  strings => ['varchar(1024)','varchar(1024)','english','letter'],
  blobs => ['letter','data','english'],
  temporals => ['date','year','null',undef]
}