How to alter 'not null' value of field after creation
You need to ud db_change_field function to change structure of table field.

function MYOTHERMODULE_update_70xx() {
  db_change_field('tablename', 'payments', 'payments', array(
    'not null' =&gt; TRUE,
  ));
}