00001 # 00002 # Tests tons of different CREATE TABLE 00003 # variations and the replication stream 00004 # 00005 00006 --disable_warnings 00007 DROP TABLE IF EXISTS t1; 00008 --enable_warnings 00009 00010 # Test the field generation 00011 00012 CREATE TABLE t1 ( 00013 autoinc_int_field INT NOT NULL AUTO_INCREMENT 00014 , null_int_field INT NULL 00015 , not_null_bigint_field BIGINT NOT NULL 00016 , null_bigint_field BIGINT NULL 00017 , not_null_int_field INT NOT NULL 00018 , null_varchar_field VARCHAR(100) NULL 00019 , not_null_varchar_field VARCHAR(100) NOT NULL 00020 , null_enum_field ENUM ('val1', 'val2') NULL 00021 , not_null_enum_field ENUM ('val1', 'val2') NOT NULL 00022 , null_date_field DATE NULL 00023 , not_null_date_field DATE NOT NULL 00024 , null_datetime_field DATETIME NULL 00025 , not_null_datetime_field DATETIME NOT NULL 00026 , null_blob_field BLOB NULL 00027 , not_null_blob_field BLOB NOT NULL 00028 , null_text_field TEXT NULL 00029 , not_null_text_field TEXT NOT NULL 00030 , null_timestamp_field TIMESTAMP NULL 00031 , not_null_timestamp_field TIMESTAMP NOT NULL 00032 , null_double_field DOUBLE NULL 00033 , not_null_double_field DOUBLE NOT NULL 00034 , null_decimal_field DECIMAL(10,2) NULL 00035 , not_null_decimal_field DECIMAL(10,2) NOT NULL 00036 , PRIMARY KEY (autoinc_int_field) 00037 ); 00038 00039 DROP TABLE t1; 00040 00041 # Test the index generation 00042 00043 CREATE TABLE t1 ( 00044 id INT NOT NULL AUTO_INCREMENT PRIMARY KEY 00045 , key1 VARCHAR(10) NOT NULL 00046 , key2 DOUBLE NOT NULL 00047 , key3 BLOB NOT NULL 00048 , UNIQUE KEY (key1) 00049 , KEY named_key (key2) 00050 , KEY partial_key (key3(30)) 00051 ); 00052 00053 DROP TABLE t1;