mysite.install : mysite_content table is not being created because of error in mysql query

// $Id: mysite.install,v 1.1.2.2 2006/11/21 20:21:35 agentken Exp $

mysql version 4.1.21

[ line 38/94 (40%), col 1/46 (2%), char 1262/3500 (36%) ]
to
[ line 49/94 (52%), col 13/13 (100%), char 1690/3500 (48%) ]

Search:

      $sql = "CREATE TABLE {mysite_content} (
        myid int(11) NOT NULL default '0',
        'type' varchar(40) NOT NULL default '',
        type_key varchar(80) default NULL,
        title varchar(255) NOT NULL default '',        
        content blob,
        PRIMARY KEY  (myid),
        KEY 'type' ('type'),
        KEY type_key (type_key)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;";
      db_query($sql);
      break;

Replace:

      $sql = "CREATE TABLE {mysite_content} (
        myid int(11) NOT NULL default '0',
        `type` varchar(40) NOT NULL default '',
        type_key varchar(80) default NULL,
        title varchar(255) NOT NULL default '',
        content blob,
        PRIMARY KEY  (myid),
        KEY type (type),
        KEY type_key (type_key)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;";
      db_query($sql);
      break;

Errormessage:

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 ''type' ('type'), KEY type_key (type_key) ) /*!40100 DEFAULT CHARAC' at line 8 query: CREATE TABLE mysite_content ( myid int(11) NOT NULL default '0', `type` varchar(40) NOT NULL default '', type_key varchar(80) default NULL, title varchar(255) NOT NULL default '', content blob, PRIMARY KEY (myid), KEY 'type' ('type'), KEY type_key (type_key) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /var/www/domain.tld/htdocs/includes/database.mysql.inc on line 121.