← Back to branch summary

~clint-fewbar/drizzle/regex-policy-cache-limiter

« back to all changes in this revision

Viewing changes to tests/std_data/mysqlmigrate_enum_type.dat

  • Committer: Clint Byrum
  • Date: 2012-03-15 18:05:43 UTC
  • mfrom: (2224.1.302 workspace)
  • Revision ID: clint@ubuntu.com-20120315180543-9jxxm4q10k3np2ws
merging with latest trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/std_data/mysqlmigrate_enum_type.dat
 
1
CREATE TABLE enum_table(description TEXT,
 
2
col_2 enum('Roy','Moss','Jen'),
 
3
col_2_not_null enum('Roy','Moss','Jen') NOT NULL,
 
4
col_2_default_null enum('Roy','Moss','Jen') DEFAULT NULL,
 
5
col_2_default enum('Roy','Moss','Jen') DEFAULT 'Moss',
 
6
col_64 enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','0','1','2','3','4','5','6','7','8','9','10','11'),
 
7
col_64_default_null enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','0','1','2','3','4','5','6','7','8','9','10','11') DEFAULT NULL,
 
8
col_64_default enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','0','1','2','3','4','5','6','7','8','9','10','11') DEFAULT 'A' 
 
9
) ENGINE=MyISAM;
 
10
 
 
11
INSERT INTO enum_table VALUES('MIN','Roy','Roy',DEFAULT,DEFAULT,'a',DEFAULT,DEFAULT);
 
12
INSERT INTO enum_table VALUES('MAX','Moss','Jen',DEFAULT,DEFAULT,'Z',DEFAULT,DEFAULT);
 
13
INSERT INTO enum_table VALUES('NULL_ROW',NULL,'Moss',DEFAULT,DEFAULT,NULL,DEFAULT,DEFAULT);
 
14
 
 
15