1##### suite/funcs_1/include/tb3.inc
2#
3# This auxiliary script is used in several Trigger tests.
4#
5# If the table need data than the file std_data/funcs_1/memory_tb3.txt
6# could be used.
7#
8
9--disable_warnings
10drop table if exists tb3;
11--enable_warnings
12--replace_result $engine_type <engine_to_be_used>
13eval create table tb3 (
14f118 char not null DEFAULT 'a',
15f119 char binary not null DEFAULT b'101',
16f120 char ascii not null DEFAULT b'101',
17f121 char(50),
18f122 char(50),
19f129 binary not null DEFAULT b'101',
20f130 tinyint not null DEFAULT 99,
21f131 tinyint unsigned not null DEFAULT 99,
22f132 tinyint zerofill not null DEFAULT 99,
23f133 tinyint unsigned zerofill not null DEFAULT 99,
24f134 smallint not null DEFAULT 999,
25f135 smallint unsigned not null DEFAULT 999,
26f136 smallint zerofill not null DEFAULT 999,
27f137 smallint unsigned zerofill not null DEFAULT 999,
28f138 mediumint not null DEFAULT 9999,
29f139 mediumint unsigned not null DEFAULT 9999,
30f140 mediumint zerofill not null DEFAULT 9999,
31f141 mediumint unsigned zerofill not null DEFAULT 9999,
32f142 int not null DEFAULT 99999,
33f143 int unsigned not null DEFAULT 99999,
34f144 int zerofill not null DEFAULT 99999,
35f145 int unsigned zerofill not null DEFAULT 99999,
36f146 bigint not null DEFAULT 999999,
37f147 bigint unsigned not null DEFAULT 999999,
38f148 bigint zerofill not null DEFAULT 999999,
39f149 bigint unsigned zerofill not null DEFAULT 999999,
40f150 decimal not null DEFAULT 999.999,
41f151 decimal unsigned not null DEFAULT 999.17,
42f152 decimal zerofill not null DEFAULT 999.999,
43f153 decimal unsigned zerofill,
44f154 decimal (0),
45f155 decimal (64),
46f156 decimal (0) unsigned,
47f157 decimal (64) unsigned,
48f158 decimal (0) zerofill,
49f159 decimal (64) zerofill,
50f160 decimal (0) unsigned zerofill,
51f161 decimal (64) unsigned zerofill,
52f162 decimal (0,0),
53f163 decimal (63,30),
54f164 decimal (0,0) unsigned,
55f165 decimal (63,30) unsigned,
56f166 decimal (0,0) zerofill,
57f167 decimal (63,30) zerofill,
58f168 decimal (0,0) unsigned zerofill,
59f169 decimal (63,30) unsigned zerofill,
60f170 numeric,
61f171 numeric unsigned,
62f172 numeric zerofill,
63f173 numeric unsigned zerofill,
64f174 numeric (0),
65f175 numeric (64)
66) engine = $engine_type;
67