During installation and creating table uc_discounts_conditions. Error occured, it says

user warning: BLOB/TEXT column 'amount' can't have a default value query: CREATE TABLE uc_discounts_conditions ( `id` INT NOT NULL auto_increment, `discount_id` INT NOT NULL, `condition_group` SMALLINT NOT NULL DEFAULT 1, `property` VARCHAR(255) NOT NULL, `op` CHAR(2) NOT NULL, `item_id` VARCHAR(255) DEFAULT NULL, `value` TEXT NOT NULL, `weight` INT NOT NULL, `amount` TEXT NOT NULL DEFAULT '', PRIMARY KEY (id), INDEX discount_id (discount_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\WebServerDevelopment\omart\includes\database.inc on line 515.

So I fixed this by manually creating table on my DB with scripts below

CREATE TABLE uc_discounts_conditions ( `id` INT NOT NULL auto_increment, `discount_id` INT NOT NULL, `condition_group` SMALLINT NOT NULL DEFAULT 1, `property` VARCHAR(255) NOT NULL, `op` CHAR(2) NOT NULL, `item_id` VARCHAR(255) DEFAULT NULL, `value` TEXT NOT NULL, `weight` INT NOT NULL, `amount` TEXT, PRIMARY KEY (id), INDEX discount_id (discount_id) )

Can you guys confirm this and fix the installation module?

Regards