Instantly share code, notes, and snippets.

Embed
What would you like to do?
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