default NULL problem with CREATE TABLE

[peter michaux]

Hi,

I'm trying to create a table with the field 'customer_group_id' having default null. What I tried is attached below. I also tried with customer_group_id line without the first NULL. Either way doesn't seem to be working. Any suggestions greatly appreciated!

Thanks,
Peter



mysql> CREATE TABLE price (
product_variation_id int(10) unsigned NOT NULL,
customer_group_id int(10) unsigned NULL default NULL,
quantity int(10) unsigned NOT NULL default '1',
price decimal(10,2) NOT NULL,
PRIMARY KEY (product_variation_id, customer_group_id, quantity)
) ENGINE=INNODB;

mysql> describe price;
+----------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+-------+
| product_variation_id | int(10) unsigned | | PRI | 0 | |
| customer_group_id | int(10) unsigned | | PRI | 0 | |
| quantity | int(10) unsigned | | PRI | 1 | |
| price | decimal(10,2) | | | 0.00 | |
+----------------------+------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)