~~~[sql] CREATE TABLE `xi_distributor` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户名', `password` char(32) NOT NULL DEFAULT '' COMMENT '密码', `auth_key` varchar(32) DEFAULT NULL COMMENT '认证密钥', `mobile` varchar(16) NOT NULL COMMENT '手机号码', `realname` varchar(16) NOT NULL COMMENT '真实姓名', `longitude` varchar(16) NOT NULL COMMENT '经度', `latitude` varchar(16) NOT NULL COMMENT '纬度', `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型，1=>平台配送员，2=>商家配送员', `work` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '工作状态，0=>休息，1=>开工', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0=>禁用，1=>启用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '创建时间', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `mobile` (`mobile`), UNIQUE KEY `auth_key` (`auth_key`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='配送员'; ~~~ ~~~[sql] CREATE TABLE `xi_distributor_wallet` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `distributor_id` int(11) unsigned NOT NULL COMMENT '配送员ID', `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0=>禁用，1=>启用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '创建时间', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `distributor_id` (`distributor_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='配送员钱包'; ~~~ ~~~[sql] CREATE TABLE `xi_distributor_work_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `distributor_id` int(11) unsigned NOT NULL, `work` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '工作状态，0=>休息中，1=>接单中', `longitude` varchar(16) NOT NULL COMMENT '经度', `latitude` varchar(16) NOT NULL COMMENT '纬度', `ip` varchar(16) NOT NULL DEFAULT '' COMMENT 'IP地址', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0=>禁用，1=>启用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '创建时间', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配送员工作日志'; ~~~ ~~~[sql] CREATE TABLE `xi_distributor_work_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `distributor_id` int(11) unsigned NOT NULL, `work` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '工作状态，0=>休息中，1=>接单中', `longitude` varchar(16) NOT NULL COMMENT '经度', `latitude` varchar(16) NOT NULL COMMENT '纬度', `ip` varchar(16) NOT NULL DEFAULT '' COMMENT 'IP地址', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0=>禁用，1=>启用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '创建时间', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配送员工作日志'; ~~~