35 lines
1.4 KiB
Plaintext
35 lines
1.4 KiB
Plaintext
$tables = {
|
|
# names => ['A', 'B', 'C', 'D', 'E', 'AA', 'BB', 'CC', 'DD'],
|
|
# rows => [0, 1, 20, 100, 1, 0, 1, 20, 100],
|
|
names => ['A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'],
|
|
rows => [0, 1, 5, 10, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 50, 100],
|
|
pk => [ 'integer auto_increment' ],
|
|
engines => ['InnoDB']
|
|
};
|
|
|
|
$fields = {
|
|
types => [ 'int',
|
|
'datetime',
|
|
# 'date', 'time', 'datetime',
|
|
'char(16)', 'varchar(10)', 'varchar(256)' ],
|
|
indexes => [undef, 'key', 'unique'],
|
|
null => [undef],
|
|
# sign => [undef, 'unsigned'],
|
|
|
|
#########################################################################
|
|
# We don't specify charsets here as this will affect column naming
|
|
# and requires a grammar rewrite when we change to another charset
|
|
# and/or collation.
|
|
#########################################################################
|
|
# charsets => ['utf8'], collations => ['utf8_bin']
|
|
# charsets => ['latin1'], collations => ['latin1_bin']
|
|
};
|
|
|
|
$data = {
|
|
# numbers => [ 0..20, 0..99, 'null' ],
|
|
numbers => [ 0..10, 0..20, 0..50, 'null' ],
|
|
strings => [ 'varchar(32)', 'english' ],
|
|
# temporals => ['date', 'year', 'datetime', 'null']
|
|
temporals => ['datetime', 'null']
|
|
}
|