la tabla se me resiste!!

[compiler5]

mecachis!!! xDDDD

me pongo a acgregar la tabla con el nuevo valor k me diste, osea este...

Código:

CREATE TABLE `accounts_extend` (
  `accounts_id` varchar(45) NOT NULL,
  `email` varchar(320) NULL DEFAULT 'youname@domain',
  `joindate` decimal(20,0) DEFAULT NULL,
  `referrals` varchar(45) DEFAULT NULL,
  `points_tmp` varchar(5) NOT NULL DEFAULT ''',
  PRIMARY KEY  (`accounts_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

y me sale este error:

Código:

[Err] 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 '''',
  PRIMARY KEY  (`accounts_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 6
[Err] CREATE TABLE `accounts_extend` (
  `accounts_id` varchar(45) NOT NULL,
  `email` varchar(320) NULL DEFAULT 'youname@domain',
  `joindate` decimal(20,0) DEFAULT NULL,
  `referrals` varchar(45) DEFAULT NULL,
  `points_tmp` varchar(5) NOT NULL DEFAULT ''',
  PRIMARY KEY  (`accounts_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------