Sxya7TxD

1DROP DATABASE IF EXISTS testdatabase;
2CREATE DATABASE testdatabase CHARACTER SET UTF8 COLLATE utf8_bin;
3USE testdatabase;
4
5CREATE TABLE table1(
6    ID INT NOT NULL AUTO_INCREMENT,
7    col1 TEXT,
8    col2 TEXT,
9    col3 TEXT,
10    col4 TEXT,
11    col5 TEXT,
12    col6 TEXT,
13    col7 TEXT,
14    col8 TEXT,
15    PRIMARY KEY (ID)
16    );
17
18CREATE TABLE table2(
19    ID INT NOT NULL AUTO_INCREMENT,
20    col1 TEXT,
21    col2 TEXT,
22    col3 TEXT,
23    col4 TEXT,
24    PRIMARY KEY (ID)
25    );
26
27CREATE TABLE table3(
28    ID INT NOT NULL AUTO_INCREMENT,
29    col1 TEXT,
30    col2 TEXT,
31    col3 TEXT,
32    col4 TEXT,
33    col5 TEXT,
34    col6 TEXT,
35    col7 TEXT,
36    col8 TEXT,
37    col9 TEXT,
38    col10 TEXT,
39    PRIMARY KEY (ID)
40    );
41
42INSERT INTO table3 VALUES (null, 'one','two','three','four','five','six','seven','eight','nine','ten');
43INSERT INTO table3 VALUES (null, 'eleven','twelve','thirteen','fourteen','fifteen','sixteen','seventeen','eighteen','nineteen','twenty');