Drizzled Public API Documentation

create_table.inc
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;