eddb user schema
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`), | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment