error creating table

[xgd]

`Hello people, i am trying to get an example from this book i got working, but i get an error while creating the table WROX_SHOP_INVENTORY

 

this is the code for the 2 tables:

 

DROP TABLE IF EXISTS WROX_SHOP_INVENTORY;

DROP TABLE IF EXISTS WROX_SHOP_CATEGORY;

 

CREATE TABLE WROX_SHOP_CATEGORY (

    CATEGORY_ID  INTEGER UNSIGNED  NOT NULL  AUTO_INCREMENT,

    CATEGORY_NAME VARCHAR(100)      NOT NULL,

 

    PRIMARY KEY (CATEGORY_ID)

)

ENGINE=InnoDB DEFAULT CHARACTER SET latin1

    COLLATE latin1_general_cs;

 

CREATE TABLE WROX_SHOP_INVENTORY (

    ITEM_ID          INTEGER UNSIGNED  NOT NULL  AUTO_INCREMENT,

    ITEM_NAME        VARCHAR(100)      NOT NULL,

    ITEM_DESCRIPTION TEXT              DEFAULT '',

    PRICE            DOUBLE(5,2)      NOT NULL,

    ITEM_IMAGE      VARCHAR(255)      DEFAULT 'img/none.gif',

    CATEGORY_ID      INTEGER UNSIGNED  NOT NULL,

 

    PRIMARY KEY (ITEM_ID),

 

    FOREIGN KEY (CATEGORY_ID)

        REFERENCES WROX_SHOP_CATEGORY(CATEGORY_ID)

        ON DELETE CASCADE

)

ENGINE=InnoDB DEFAULT CHARACTER SET latin1

    COLLATE latin1_general_cs AUTO_INCREMENT=0;

 

the error i get is:

 

#1101 - BLOB/TEXT column 'ITEM_DESCRIPTION' can't have a default value

 

Does anyone know what the problem is, because i am guessing it should be working since it is for mysql 5 and i have an up to date mysql.

 

Thanks

 

[Aeglos]

Seriously... did you even read or try to comprehend the error?

 

It clearly states BLOB/TEXT types can't have default values...

 

change:

ITEM_DESCRIPTION TEXT              DEFAULT '',

to:

ITEM_DESCRIPTION TEXT,