~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/std_data/mysqlmigrate_databases.dat

  • Committer: Lee Bieber
  • Date: 2011-03-12 15:53:38 UTC
  • mfrom: (2048.2.2 mysql-migrate-tests)
  • mto: This revision was merged to the branch mainline in revision 2232.
  • Revision ID: kalebral@gmail.com-20110312155338-qbifjqp24vsyiluo
Merge Patrick - add suite to test drizzledump

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
CREATE TABLE t1 (a int, b char(10)) ENGINE=MyISAM;
 
2
CREATE TABLE t2 (a int, b char(10)) ENGINE=MyISAM;
 
3
INSERT INTO t1 VALUES (1,'Jen'),(2,'Roy'),(3,'Moss');
 
4
INSERT INTO t2 VALUES (1,'Vince'),(2,'Howard'),(3,'Naboo'),(4,'Bollo'),(5,'Bob Fossil');
 
5
CREATE TABLE drizzledump_migrate_test2.t1 (a int, b char(10)) ENGINE=MyISAM;
 
6
CREATE TABLE drizzledump_migrate_test2.t2 (a int, b char(10)) ENGINE=MyISAM;
 
7
INSERT INTO drizzledump_migrate_test2.t1 VALUES (1,'Jen'),(2,'Moss');
 
8
INSERT INTO drizzledump_migrate_test2.t2 VALUES (1,'Naboo'),(2,'Bollo');
 
9
CREATE TABLE drizzledump_migrate_test3.not_on_drizzle(a char(50)) ENGINE=MyISAM; 
 
10
INSERT INTO drizzledump_migrate_test3.not_on_drizzle VALUES ('You shouldnt see this on Drizzle');