blob: 413a026265e2937d8071ade62e86a9f4e024253b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
--echo # Create table & Index
eval CREATE TABLE tab5(col_1 TINYBLOB, col_2 TINYTEXT,col_3 BLOB,
col_4 TEXT,col_5 MEDIUMBLOB,col_6 MEDIUMTEXT,
col_7 LONGBLOB,col_8 LONGTEXT,col_9 VARCHAR(255))
ENGINE=INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=$block_size;
let $i = 9;
while ($i) {
eval CREATE INDEX idx$i ON tab5(col_$i(10));
dec $i;
}
|