eddb user schema

gistfile1.sql

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `account_activation_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `change_email_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_login_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `user_profile` (
  `id` int(11) NOT NULL,
  `accept_emails` int(11) DEFAULT '0',
  `route_credits_filter_enabled` tinyint(1) DEFAULT NULL,
  `route_range_filter_enabled` tinyint(1) DEFAULT NULL,
  `route_landing_pad_filter_enabled` tinyint(1) DEFAULT NULL,
  `route_range_min` int(11) DEFAULT NULL,
  `route_range_max` int(11) DEFAULT NULL,
  `ship_cargo_max` int(11) DEFAULT NULL,
  `ship_credits_per_ly` double DEFAULT NULL,
  `ship_landing_pad_size` int(11) DEFAULT NULL,
  `cmdr_credits` int(11) DEFAULT NULL,
  `cmdr_last_station_id` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
);