CREATE TABLE `user` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(64) NOT NULL default '',
  `device_name` varchar(64) default NULL,
  `sec_answer` varchar(128) default NULL,
  `sec_question` varchar(128) default NULL,
  `age_range` varchar(8) default NULL,
  `gender` varchar(6) default NULL,
  `home_page_item` varchar(128) default NULL,
  `email_address` varchar(128) default NULL,
  `user_account` varchar(64) NOT NULL default '',
  `password` varchar(24) default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;

CREATE TABLE `user_setting` (
  `us_id` int(10) unsigned NOT NULL auto_increment,
  `location` varchar(128) default NULL,
  `user_id` int(10) unsigned default NULL,
  `user_config_time` varchar(30) default NULL,
  `ieautolaunch` varchar(5) default NULL,
  `oeautolaunch` varchar(5) default NULL,
  `olautolaunch` varchar(5) default NULL,
  `lastCountry` varchar(128) default NULL,
  PRIMARY KEY  (`us_id`),
  KEY `user_id` (`user_id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

CREATE TABLE `user_country_setting` (
  `ucs_id` int(10) unsigned NOT NULL auto_increment,
  `country` varchar(128) default NULL,
  `navigationURL` varchar(128) default NULL,
  `currentFolder` int(10) default NULL,
  `lastClassification` int(10) unsigned default NULL,
  `us_id` int(10) unsigned default NULL,
  `rssTopic` varchar(128) default NULL,
  PRIMARY KEY  (`ucs_id`),
  KEY `us_id` (`us_id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

CREATE TABLE `user_country_link_setting` (
  `ucls_id` int(10) unsigned NOT NULL auto_increment,
  `ucs_id` int(10) unsigned default NULL,
  `link_id` int(10) unsigned default NULL,
  `state` varchar(8) default NULL,
  PRIMARY KEY  (`ucls_id`),
  KEY `ucs_id` (`ucs_id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

CREATE TABLE `initial_links` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `link_id` int(11) unsigned default NULL,
  `criteria` varchar(64) default NULL,
  `match_value` varchar(64) default NULL,
  `show_link` int(11) default NULL,
  `location` varchar(25) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;