← Back to branch summary

~percona-toolkit-dev/percona-toolkit/fix-password-comma-bug-886077

« back to all changes in this revision

Viewing changes to t/pt-table-checksum/samples/3tbl-resume.sql

  • Committer: Daniel Nichter
  • Date: 2012-02-07 20:10:11 UTC
  • mfrom: (174 2.0)
  • mto: This revision was merged to the branch mainline in revision 189.
  • Revision ID: daniel@percona.com-20120207201011-sok2c1f2ay9qr3gm
Merge trunk r174.

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/pt-table-checksum/samples/3tbl-resume.sql
 
1
DROP DATABASE IF EXISTS test;
 
2
CREATE DATABASE test;
 
3
USE test;
 
4
 
 
5
CREATE TABLE `t1` (
 
6
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
7
  `c` varchar(26) NOT NULL,
 
8
  PRIMARY KEY (`id`)
 
9
) ENGINE=MyISAM;
 
10
 
 
11
INSERT INTO `t1` VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'f'),(7,'g'),(8,'h'),(9,'i'),(10,'j'),(11,'k'),(12,'l'),(13,'m'),(14,'n'),(15,'o'),(16,'p'),(17,'q'),(18,'r'),(19,'s'),(20,'t'),(21,'u'),(22,'v'),(23,'w'),(24,'x'),(25,'y'),(26,'z');
 
12
 
 
13
CREATE TABLE `t2` (
 
14
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
15
  `c` varchar(26) NOT NULL,
 
16
  PRIMARY KEY (`id`)
 
17
) ENGINE=MyISAM;
 
18
 
 
19
INSERT INTO `t2` VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'f'),(7,'g'),(8,'h'),(9,'i'),(10,'j'),(11,'k'),(12,'l'),(13,'m'),(14,'n'),(15,'o'),(16,'p'),(17,'q'),(18,'r'),(19,'s'),(20,'t'),(21,'u'),(22,'v'),(23,'w'),(24,'x'),(25,'y'),(26,'z');
 
20
 
 
21
CREATE TABLE `t3` (
 
22
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
23
  `c` varchar(26) NOT NULL,
 
24
  PRIMARY KEY (`id`)
 
25
) ENGINE=MyISAM;
 
26
 
 
27
INSERT INTO `t3` VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'f'),(7,'g'),(8,'h'),(9,'i'),(10,'j'),(11,'k'),(12,'l'),(13,'m'),(14,'n'),(15,'o'),(16,'p'),(17,'q'),(18,'r'),(19,'s'),(20,'t'),(21,'u'),(22,'v'),(23,'w'),(24,'x'),(25,'y'),(26,'z');