← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/mysql_protocol.result

  • Committer: Brian Aker
  • Date: 2010-08-17 01:34:55 UTC
  • mto: (1711.1.23 build)
  • mto: This revision was merged to the branch mainline in revision 1714.
  • Revision ID: brian@tangent.org-20100817013455-zx3nm7qilxvpwrgb
Style on structure cleanup

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/mysql_protocol.result
1
1
DROP TABLE IF EXISTS t1;
2
2
CREATE TABLE t1(a int, key (a));
3
3
INSERT INTO t1 VALUES (1), (2);
4
 
 
5
4
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
6
5
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
7
6
DROP TABLE IF EXISTS `t1`;
8
7
CREATE TABLE `t1` (
9
 
  `a` INT DEFAULT NULL,
 
8
  `a` int DEFAULT NULL,
10
9
  KEY `a` (`a`)
11
 
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
 
10
) ENGINE=InnoDB;
12
11
 
13
12
ALTER TABLE `t1` DISABLE KEYS;
14
13
INSERT INTO `t1` VALUES (1),(2);
15
14
ALTER TABLE `t1` ENABLE KEYS;
16
 
 
17
15
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
18
16
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
19
17
DROP TABLE t1;