67
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
68
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
67
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
68
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
70
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET utf8 */;
70
CREATE DATABASE IF NOT EXISTS `test`;
73
73
DROP TABLE IF EXISTS `t1`;
79
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
79
ALTER TABLE `t1` DISABLE KEYS;
80
80
INSERT IGNORE INTO `t1` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
81
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
81
ALTER TABLE `t1` ENABLE KEYS;
82
82
DROP TABLE IF EXISTS `t2`;
83
83
CREATE TABLE `t2` (
88
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
88
ALTER TABLE `t2` DISABLE KEYS;
89
89
INSERT DELAYED IGNORE INTO `t2` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
90
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
90
ALTER TABLE `t2` ENABLE KEYS;
91
91
DROP TABLE IF EXISTS `t3`;
92
92
CREATE TABLE `t3` (
97
/*!40000 ALTER TABLE `t3` DISABLE KEYS */;
97
ALTER TABLE `t3` DISABLE KEYS;
98
98
INSERT DELAYED IGNORE INTO `t3` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
99
/*!40000 ALTER TABLE `t3` ENABLE KEYS */;
99
ALTER TABLE `t3` ENABLE KEYS;
100
100
DROP TABLE IF EXISTS `t4`;
101
101
CREATE TABLE `t4` (
103
103
`name` varchar(32)
106
/*!40000 ALTER TABLE `t4` DISABLE KEYS */;
106
ALTER TABLE `t4` DISABLE KEYS;
107
107
INSERT DELAYED IGNORE INTO `t4` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
108
/*!40000 ALTER TABLE `t4` ENABLE KEYS */;
108
ALTER TABLE `t4` ENABLE KEYS;
109
109
DROP TABLE IF EXISTS `t6`;
110
110
CREATE TABLE `t6` (
112
112
`name` varchar(32)
115
/*!40000 ALTER TABLE `t6` DISABLE KEYS */;
115
ALTER TABLE `t6` DISABLE KEYS;
116
116
INSERT IGNORE INTO `t6` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
117
/*!40000 ALTER TABLE `t6` ENABLE KEYS */;
118
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
119
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
120
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
121
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
117
ALTER TABLE `t6` ENABLE KEYS;
118
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
119
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
120
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
121
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
123
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET utf8 */;
123
CREATE DATABASE IF NOT EXISTS `test`;
126
126
DROP TABLE IF EXISTS `t1`;
129
129
`name` varchar(32)
132
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
132
ALTER TABLE `t1` DISABLE KEYS;
133
133
INSERT INTO `t1` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
134
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
134
ALTER TABLE `t1` ENABLE KEYS;
135
135
DROP TABLE IF EXISTS `t2`;
136
136
CREATE TABLE `t2` (
138
138
`name` varchar(32)
141
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
141
ALTER TABLE `t2` DISABLE KEYS;
142
142
INSERT DELAYED INTO `t2` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
143
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
143
ALTER TABLE `t2` ENABLE KEYS;
144
144
DROP TABLE IF EXISTS `t3`;
145
145
CREATE TABLE `t3` (
147
147
`name` varchar(32)
150
/*!40000 ALTER TABLE `t3` DISABLE KEYS */;
150
ALTER TABLE `t3` DISABLE KEYS;
151
151
INSERT DELAYED INTO `t3` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
152
/*!40000 ALTER TABLE `t3` ENABLE KEYS */;
152
ALTER TABLE `t3` ENABLE KEYS;
153
153
DROP TABLE IF EXISTS `t4`;
154
154
CREATE TABLE `t4` (
156
156
`name` varchar(32)
159
/*!40000 ALTER TABLE `t4` DISABLE KEYS */;
159
ALTER TABLE `t4` DISABLE KEYS;
160
160
INSERT DELAYED INTO `t4` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
161
/*!40000 ALTER TABLE `t4` ENABLE KEYS */;
161
ALTER TABLE `t4` ENABLE KEYS;
162
162
DROP TABLE IF EXISTS `t6`;
163
163
CREATE TABLE `t6` (
165
165
`name` varchar(32)
168
/*!40000 ALTER TABLE `t6` DISABLE KEYS */;
168
ALTER TABLE `t6` DISABLE KEYS;
169
169
INSERT INTO `t6` VALUES ('1','first value'),('2','first value'),('3','first value'),('4','first value'),('5','first value');
170
/*!40000 ALTER TABLE `t6` ENABLE KEYS */;
171
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
172
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
170
ALTER TABLE `t6` ENABLE KEYS;
171
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
172
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;