how set "default" inthe name of column ?

[amir taghvayi]

hi
i try to run this code :

eparedStatement ps = connection.prepareStatement("
              int r= ps.executeUpdate("CREATE TABLE `imagemanager` (
             `id` int(10) unsigned NOT NULL auto_increment,
             `image` varchar(255) NOT NULL default '',
             `date` varchar(45) NOT NULL default '',
             `defualt` tinyint(1) NOT NULL default '0',
             PRIMARY KEY  (`id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;" );
    int r= ps.executeUpdate(string);
    System.out.println(r);

i get sql error near "`defualt` tinyint(1) NOT NULL default '0'," .

please help me !!!

[Scott Selikoff]

Since it's a numeric type, have tried "default 0" without the quotes around '0'.