user warning: BLOB/TEXT column 'announce_url' can't have a default value query: CREATE TABLE drp6_bt_torrents ( `fid` INT unsigned NOT NULL DEFAULT 0, `info_hash` CHAR(40) NOT NULL, `announce_url` LONGTEXT NOT NULL DEFAULT '', `total_size` BIGINT unsigned NOT NULL DEFAULT 0, `snatches` BIGINT unsigned NOT NULL DEFAULT 0, `seeders` BIGINT unsigned NOT NULL DEFAULT 0, `leechers` BIGINT unsigned NOT NULL DEFAULT 0, `downloaded` BIGINT unsigned NOT NULL DEFAULT 0, `last_seed` BIGINT unsigned DEFAULT 0, `custom_data` LONGTEXT NOT NULL DEFAULT '', PRIMARY KEY (fid), UNIQUE KEY info_hash_index (info_hash) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\HostingSpaces\axacter\axacter.com\wwwroot\includes\database.inc on line 550.
user warning: BLOB/TEXT column 'path' can't have a default value query: CREATE TABLE drp6_bt_torrents_files ( `fid` INT unsigned NOT NULL, `length` INT unsigned NOT NULL, `path` TEXT NOT NULL DEFAULT '', `name` VARCHAR(255) NOT NULL, INDEX fid_index (fid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\HostingSpaces\axacter\axacter.com\wwwroot\includes\database.inc on line 550.

BLOB/TEXT column 'custom_data' can't have a default value

this is a working query manualy created
CREATE TABLE drp6_bt_torrents ( `fid` INT unsigned NOT NULL DEFAULT 0, `info_hash` CHAR(40) NOT NULL, `announce_url` LONGTEXT NOT NULL, `total_size` BIGINT unsigned NOT NULL DEFAULT 0, `snatches` BIGINT unsigned NOT NULL DEFAULT 0, `seeders` BIGINT unsigned NOT NULL DEFAULT 0, `leechers` BIGINT unsigned NOT NULL DEFAULT 0, `downloaded` BIGINT unsigned NOT NULL DEFAULT 0, `last_seed` BIGINT unsigned DEFAULT 0, `custom_data` LONGTEXT NOT NULL, PRIMARY KEY (fid), UNIQUE KEY info_hash_index (info_hash) ) /*!40100 DEFAULT CHARACTER SET utf8 */
CREATE TABLE drp6_bt_torrents_files ( `fid` INT unsigned NOT NULL, `length` INT unsigned NOT NULL, `path` TEXT NOT NULL, `name` VARCHAR(255) NOT NULL, INDEX fid_index (fid) ) /*!40100 DEFAULT CHARACTER SET utf8 */