openant电商-用户

-- 数据库大全：openant电商-用户
-- 来源：YesApi.cn
CREATE TABLE `yesapi_openant_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL COMMENT '',
    `user_group_id` int(11) NOT NULL COMMENT '',
    `user_class_id` int(11) NOT NULL COMMENT '',
    `sale_class_id` int(11) NOT NULL COMMENT '',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `firstname` varchar(32) NOT NULL COMMENT '',
    `lastname` varchar(32) NOT NULL COMMENT '',
    `nickname` varchar(28) NOT NULL COMMENT '',
    `gender` varchar(28) NOT NULL COMMENT '',
    `email` varchar(96) NOT NULL COMMENT '',
    `telephone` varchar(32) NOT NULL COMMENT '',
    `yesapi_openant_user_password` varchar(40) NOT NULL COMMENT '',
    `image` varchar(255) NOT NULL COMMENT '',
    `description` varchar(255) NOT NULL COMMENT '',
    `newsletter` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `address_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `user_field` text NOT NULL COMMENT '',
    `ip` varchar(40) NOT NULL COMMENT '',
    `yesapi_openant_user_status` tinyint(1) NOT NULL COMMENT '',
    `safe` tinyint(1) NOT NULL COMMENT '',
    `token` text NOT NULL COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-用户';

复制后，到数据库执行，即可创建此数据库表。