New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

auto sync user info on profile page if user not exists #82

Closed
fengmk2 opened this Issue Dec 12, 2013 · 2 comments

Comments

Projects
None yet
1 participant

@fengmk2 fengmk2 added this to the v0.3 koa milestone Feb 20, 2014

@fengmk2 fengmk2 self-assigned this Mar 15, 2014

@fengmk2

This comment has been minimized.

Member

fengmk2 commented Mar 15, 2014

working on this

@fengmk2

This comment has been minimized.

Member

fengmk2 commented Mar 15, 2014

CREATE TABLE `user` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
 `gmt_create` datetime NOT NULL COMMENT 'create time',
 `gmt_modified` datetime NOT NULL COMMENT 'modified time',
 `name` varchar(100) NOT NULL COMMENT 'user name',
 `salt` varchar(100) NOT NULL,
 `password_sha` varchar(100) NOT NULL COMMENT 'user password hash',
 `ip` varchar(64) NOT NULL COMMENT 'user last request ip',
 `roles` varchar(200) NOT NULL DEFAULT '[]',
 `rev` varchar(40) NOT NULL,
 `email` varchar(400) NOT NULL,
 `json` longtext CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'json details',
 `npm_user` tinyint(1) DEFAULT '0' COMMENT 'user sync from npm or not, 1: true, other: false',
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`),
 KEY `gmt_modified` (`gmt_modified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='user base info';
-- ALTER TABLE `user` ADD `json` longtext CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'json details'
-- ALTER TABLE `user` ADD `npm_user` tinyint(1) DEFAULT '0' COMMENT 'user sync from npm or not, 1: true, other: false'

@fengmk2 fengmk2 closed this in 1c743f3 Mar 16, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment