Incorrect synatx near '='

See more:

SQL

PHP

Hey, can you please correct this for me? please..
This is the code

CREATE TABLE IF NOT EXISTS server` (
  `id` int(10) unsigned NOT NULL,
  `region_id` int(10) unsigned NOT NULL,
  `players` int(10) unsigned NOT NULL DEFAULT '0',
  `realms` int(10) unsigned NOT NULL DEFAULT '0',
  `online` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `host` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

This is the error I keep getting:
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '='.
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near '`'.
Msg 102, Level 15, State 1, Line 48
Incorrect syntax near 'server'.

Anyone? Please!