I created a module with an html field in module builder but when I deploy or publish it the SQL statement creating the table generates an error and doesn't execute. Apparently the field type is blank for the html field. I'm trying to change it manually but I can't seem to find a field type that sugar will accept.

Here is what Repair Database comes up with:

/* Table : inv_purchaseorders */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - add_items - ROW [name] => 'add_items' [type] => 'varchar' [len] => '255' */
/* VARDEF - add_items - ROW[required] => '' [name] => 'add_items' [vname] => 'LBL_ADD_ITEMS' [type] => 'html' [massupdate] => '0' [comments] => '' [help] => '' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '0' [reportable] => '0' [len] => '255' [default_value] => '<a href="window.open('../inventory/index.php','additems','width=350,height=400')">ADD ITEMS</a>' [studio] => 'visible' [dbType] => 'html' */
/* INDEXES */
ALTER TABLE inv_purchaseorders modify column add_items NULL ;

And when executed:

Executing repair query: Query Failed:ALTER TABLE inv_purchaseorders modify column add_items NULL::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1