CREATE TABLE `user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  `microsite_id` int(11) NOT NULL,
  `real_name` varchar(100) NOT NULL,
  `avatar` varchar(255) NOT NULL,
  `password` varchar(64) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `admin_login_hash` varchar(100) NOT NULL,
  `forgot_password` varchar(64) NOT NULL,
  `sign_up_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_status` int(11) NOT NULL DEFAULT '0',
  `last_visited` datetime NOT NULL,
  `hidemyobject` tinyint(1) NOT NULL DEFAULT '0',
  `detail` text NOT NULL,
  `featured_product_config` text NOT NULL,
  `sign_up_activation_code` varchar(100) NOT NULL,
  `user_group_id` int(11) NOT NULL DEFAULT '2',
  `terms` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_login_key` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8