Mysql error on enabling the module

the create table script is wrong, mysql does not allow default values on text fields.
changed it manually and executed in mysql administrator
the script is

CREATE TABLE custom_pager ( pid int unsigned NOT NULL auto_increment,
 title varchar(255) NOT NULL default '',
  list_php text NOT NULL,
   view varchar(255) NOT NULL default '',
   args varchar(255) NOT NULL default '', position varchar(16) NOT NULL default 'bottom', visibility_php text NOT NULL,
   node_type varchar(255) default '', reverse_list tinyint NOT NULL default 1, cache_list tinyint NOT NULL default 1,
   PRIMARY KEY (pid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */