1--source include/have_rocksdb.inc 2 3# 4# NULL column attribute 5# 6 7let $extra_col_opts = NULL; 8 9 10--echo ######################## 11--echo # BINARY columns 12--echo ######################## 13 14--source type_binary.inc 15--let $col_type = BINARY 16--let $col_default = 0 17--source col_null.inc 18 19--echo ######################## 20--echo # VARBINARY columns 21--echo ######################## 22 23--source type_varbinary.inc 24--let $col_type = VARBINARY(64) 25--let $col_default = 'test' 26--source col_null.inc 27 28--echo ######################## 29--echo # BIT columns 30--echo ######################## 31 32--source type_bit.inc 33--let $col_type = BIT 34--let $col_default = 1 35--source col_null.inc 36 37--echo ######################## 38--echo # BLOB columns 39--echo ######################## 40 41--source type_blob.inc 42 43--let $col_default = '' 44 45--let $col_type = BLOB 46--source col_null.inc 47 48--let $col_type = TINYBLOB 49--source col_null.inc 50 51--let $col_type = MEDIUMBLOB 52--source col_null.inc 53 54--let $col_type = LONGBLOB 55--source col_null.inc 56 57--echo ######################## 58--echo # BOOL columns 59--echo ######################## 60 61--source type_bool.inc 62--let $col_type = BOOL 63--let $col_default = '0' 64--source col_null.inc 65 66 67--echo ######################## 68--echo # CHAR columns 69--echo ######################## 70 71--source type_char.inc 72--let $col_type = CHAR 73--let $col_default = '_' 74--source col_null.inc 75 76--echo ######################## 77--echo # VARCHAR columns 78--echo ######################## 79 80 81--source type_varchar.inc 82--let $col_type = VARCHAR(64) 83--let $col_default = 'test default' 84--source col_null.inc 85 86 87--echo ######################## 88--echo # date and time columns 89--echo ######################## 90 91set @col_opt_nullsave_time_zone=@@time_zone; 92set time_zone='UTC'; 93 94--source type_date_time.inc 95 96--let $col_type = DATE 97--let $col_default = '2012-12-21' 98--source col_null.inc 99 100--let $col_type = DATETIME 101--let $col_default = '2012-12-21 12:21:12' 102--source col_null.inc 103 104--let $col_type = TIMESTAMP 105--let $col_default = '2012-12-21 12:21:12' 106--source col_null.inc 107 108--let $col_type = TIME 109--let $col_default = '12:21:12' 110--source col_null.inc 111 112--let $col_type = YEAR 113--let $col_default = '2012' 114--source col_null.inc 115 116--let $col_type = YEAR(2) 117--let $col_default = '12' 118--source col_null.inc 119 120set time_zone=@col_opt_nullsave_time_zone; 121 122--echo ######################## 123--echo # ENUM columns 124--echo ######################## 125 126--source type_enum.inc 127--let $col_type = ENUM('test1','test2','test3') 128--let $col_default = 'test2' 129--source col_null.inc 130 131--echo ######################## 132--echo # Fixed point columns (NUMERIC, DECIMAL) 133--echo ######################## 134 135--source type_fixed.inc 136 137--let $col_type = DECIMAL 138--let $col_default = 1.1 139--source col_null.inc 140 141--let $col_type = NUMERIC 142--let $col_default = 0 143--source col_null.inc 144 145--echo ######################## 146--echo # Floating point columns (FLOAT, DOUBLE) 147--echo ######################## 148 149--source type_float.inc 150 151--let $col_type = FLOAT 152--let $col_default = 1.1 153--source col_null.inc 154 155--let $col_type = DOUBLE 156--let $col_default = 0 157--source col_null.inc 158 159--echo ######################## 160--echo # INT columns 161--echo ######################## 162 163--source type_int.inc 164 165--let $col_type = INT 166--let $col_default = 2147483647 167--source col_null.inc 168 169--let $col_type = TINYINT 170--let $col_default = 127 171--source col_null.inc 172 173--let $col_type = SMALLINT 174--let $col_default = 0 175--source col_null.inc 176 177--let $col_type = MEDIUMINT 178--let $col_default = 1 179--source col_null.inc 180 181--let $col_type = BIGINT 182--let $col_default = 9223372036854775807 183--source col_null.inc 184 185--echo ######################## 186--echo # SET columns 187--echo ######################## 188 189--source type_set.inc 190--let $col_type = SET('test1','test2','test3') 191--let $col_default = 'test2,test3' 192--source col_null.inc 193 194 195--echo ######################## 196--echo # TEXT columns 197--echo ######################## 198 199--source type_text.inc 200 201--let $col_default = '' 202 203--let $col_type = TEXT 204--source col_null.inc 205 206--let $col_type = TINYTEXT 207--source col_null.inc 208 209--let $col_type = MEDIUMTEXT 210--source col_null.inc 211 212--let $col_type = LONGTEXT 213--source col_null.inc 214 215 216--let $col_type = 217--let $col_default = 218--let $extra_col_opts = 219 220 221