genericpreload.sql

CREATE TABLE t1 (c1 INT PRIMARY KEY) ENGINE=InnoDB;
CREATE TABLE t2 (c1 INT PRIMARY KEY) ENGINE=MyISAM;
CREATE TABLE t3 (c1 INT PRIMARY KEY) ENGINE=Aria;
CREATE TABLE t4 (c1 TEXT, PRIMARY KEY (c1(100))) ENGINE=InnoDB;
CREATE TABLE t5 (c1 BLOB, PRIMARY KEY (c1(100))) ENGINE=MyISAM;
CREATE TABLE t (c BLOB, PRIMARY KEY (c(100))) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(-2),(3);
INSERT INTO t2 VALUES (1),(2),(-3);
INSERT INTO t3 VALUES (-1.0),(2),(3);
INSERT INTO t4 VALUES ('1'),('2'),('3');
INSERT INTO t5 VALUES ('1'),('2'),('3');
INSERT INTO t VALUES ('1'),('2'),('3');
CREATE TABLE t10 (c1 INT PRIMARY KEY, c2 FLOAT UNIQUE) ENGINE=InnoDB;
CREATE TABLE t11 (c1 INT PRIMARY KEY, c2 BIGINT UNIQUE) ENGINE=MyISAM;
CREATE TABLE t12 (c1 INT PRIMARY KEY, c2 BLOB, c3 BIGINT) ENGINE=Aria;
CREATE TABLE t13 (c1 TEXT, c2 TEXT, c3 INT UNIQUE, PRIMARY KEY (c1(100))) ENGINE=InnoDB;
CREATE TABLE t14 (c1 BLOB, c2 INT, c3 FLOAT, c4 INT, PRIMARY KEY (c1(100))) ENGINE=MyISAM;
INSERT INTO t10 VALUES (1,.2),(2,.3),(3,-.4);
INSERT INTO t11 VALUES (1,2),(2,-3),(3,4);
INSERT INTO t12 VALUES (1,'2',3),(2,'3',-4),(3,'4',5);
INSERT INTO t13 VALUES ('1','2',3),('2','3',4.0),('3','4',-5);
INSERT INTO t14 VALUES ('1',2,-.3,4),('2',2,-0.3,4),('3',3,+3.1,-3);