← Back to branch summary

~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

« back to all changes in this revision

Viewing changes to tests/std_data/mysqlmigrate_year_type.dat

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2011-03-15 10:41:18 UTC
  • mfrom: (1.2.10 upstream)
  • Revision ID: james.westby@ubuntu.com-20110315104118-eaf0hvlytjdl4zrf
Tags: 2011.03.13-0ubuntu1
* New upstream release.
* Added slave plugin.
* Removed archive, blackhole and blitzdb plugins.
* Moved location of libdrizzle headers.
* Removed drizzleadmin manpage patch.
* Add drizzle_safe_write_string to symbols.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/std_data/mysqlmigrate_year_type.dat
 
1
CREATE TABLE year_table(description TEXT,
 
2
col_year year,
 
3
col_year_not_null year NOT NULL,
 
4
col_year_default_null year DEFAULT NULL,
 
5
col_year_default_min year DEFAULT '0000',
 
6
col_year_default_max year DEFAULT '2155',
 
7
col_year2 year(2),
 
8
col_year2_not_null year(2) NOT NULL, 
 
9
col_year2_default_null year(2) DEFAULT NULL, 
 
10
col_year2_default_min year(2) DEFAULT '00',
 
11
col_year2_default_max year(2) DEFAULT 99) ENGINE=MyISAM;
 
12
 
 
13
INSERT INTO year_table VALUES('MIN',0000,'0000',DEFAULT,DEFAULT,DEFAULT,00,00,DEFAULT,DEFAULT,DEFAULT);
 
14
INSERT INTO year_table VALUES('MAX',2155,'2155',DEFAULT,DEFAULT,DEFAULT,99,99,DEFAULT,DEFAULT,DEFAULT);
 
15
INSERT INTO year_table VALUES('NULL_ROW',NULL,2099,DEFAULT,DEFAULT,DEFAULT,NULL,'22',DEFAULT,DEFAULT,DEFAULT);
 
16
INSERT INTO year_table VALUES('ZERO',00,00,00,00,00,00,00,00,00,00);
 
17
 
 
18