小幺鸡 xiaoyaoji 修改项目owner

安宇雨
2019-12-03 10:13:16
自动测试
在线工具

user

4jZ1HwpSY
rain16881@163.com
2018-03-26 18:21:29
825b16f09a82da2da7938c505a1a3d64
USER
林进雨
201808/06/934d4fadc0d24e01b77e459932aa8329.jpg
PENDIN

fWz7niJv
378201132@qq.com
2018-04-13 14:35:13
031c66fc90c4cbee89161db460a2faf3
USER
王秀芝
null/assets/img/defaultlogo.jpg
PENDIN

项目owner修改


# 王秀芝
UPDATE `project` SET `userId` = '4jZ1HwpSY'  WHERE userId = 'fWz7niJv'
# 黄笑天
UPDATE `project` SET `userId` = '4jZ1HwpSY'  WHERE userId = 'CzUlBvR4r'

项目参与修改


# 王秀芝
UPDATE `project_user` SET userId = '4jZ1HwpSY' WHERE userId = 'fWz7niJv'

# 黄笑天
UPDATE `project_user` SET userId = '4jZ1HwpSY' WHERE userId = 'CzUlBvR4r'

SELECT project.name,user.nickname,project.id as project_id,user.id as user_id FROM `project` LEFT JOIN user on project.userId = user.id ORDER BY `userId` ASC

<?php
/**
 * Export to PHP Array plugin for PHPMyAdmin
 * @version 4.7.7
 */

/**
 * Database `tomcat_xiaoyaoji`
 */

/* `tomcat_xiaoyaoji`.`project` */
$project = array(
  array('name' => '测试接口','nickname' => '黄勇成','project_id' => 'NhFx3J7Ml','user_id' => '1sfmVYyXI'),
  array('name' => '得力-接口文档','nickname' => '罗贤涛','project_id' => '1aRRA8Rznu','user_id' => '1Wzi1D8J2D'),
  array('name' => '会议室-楼宇之窗','nickname' => '戴哥哥','project_id' => 'uaNKyDEor','user_id' => '1yM8j654Q'),
  array('name' => '派修改造项目','nickname' => '戴哥哥','project_id' => 'IczSXUPx0','user_id' => '1yM8j654Q'),
  array('name' => '统一订单','nickname' => '戴哥哥','project_id' => 'cOph7jpqm','user_id' => '1yM8j654Q'),
  array('name' => '楼宇之窗重构','nickname' => '戴哥哥','project_id' => '165NbeQNOP','user_id' => '1yM8j654Q'),
  array('name' => '统一订单管理系统','nickname' => '周荣斌','project_id' => '26tE6ZURz6','user_id' => '26seg0m4z5'),
  array('name' => 'boss系统','nickname' => '詹家豪','project_id' => 'WkbJEgq3v','user_id' => '4jYu1MoNC'),
  array('name' => '超级前台pc商城','nickname' => '詹家豪','project_id' => '4jbAfp812','user_id' => '4jYu1MoNC'),
  array('name' => 'GL公寓','nickname' => '林进雨','project_id' => '5O9V7B4PD','user_id' => '4jZ1HwpSY'),
  array('name' => '测试','nickname' => '林进雨','project_id' => 'NfjLwnJ9B','user_id' => '4jZ1HwpSY'),
  array('name' => '楼与之窗','nickname' => '林进雨','project_id' => 'lsoKqonQ','user_id' => '4jZ1HwpSY'),
  array('name' => '超级前台-商城-PC端','nickname' => '林进雨','project_id' => '4jZg3xJPQ','user_id' => '4jZ1HwpSY'),
  array('name' => '楼宇之窗-超级前台对接','nickname' => '林进雨','project_id' => '3x2rYzOpl','user_id' => '4jZ1HwpSY'),
  array('name' => '楼内闪送','nickname' => '林进雨','project_id' => '1uDGg9yGfw','user_id' => '4jZ1HwpSY'),
  array('name' => '易装','nickname' => 'hui','project_id' => '5wjNLUsvz','user_id' => '5wiRypiBM'),
  array('name' => '尚美项目','nickname' => '青章银','project_id' => '7pevLTPDr','user_id' => '7peGG43UN'),
  array('name' => '楼宇之窗订餐3.0','nickname' => '青章银','project_id' => '1GjRzcwjxg','user_id' => '7peGG43UN'),
  array('name' => '测试项目','nickname' => '青章银','project_id' => 'NkJ0qJ5if','user_id' => '7peGG43UN'),
  array('name' => '尚美项目','nickname' => '青章银','project_id' => 'OBqOjZTcE','user_id' => '7peGG43UN'),
  array('name' => '尚美会议室改造','nickname' => '青章银','project_id' => 'RjKG6PwYy','user_id' => '7peGG43UN'),
  array('name' => '问卷调查-投诉建议','nickname' => '青章银','project_id' => 'xHWvrt3Bn','user_id' => '7peGG43UN'),
  array('name' => '服务之窗-平安','nickname' => '龙美珍','project_id' => '26sLF0H95B','user_id' => '7pkVGvkGb'),
  array('name' => '服务之窗项目融合','nickname' => '龙美珍','project_id' => '21RPXJiov3','user_id' => '7pkVGvkGb'),
  array('name' => '楼宇之窗Demo项目','nickname' => '龙美珍','project_id' => 'WTWXAkvtz','user_id' => '7pkVGvkGb'),
  array('name' => '新架构','nickname' => 'huangxt','project_id' => '1G5cBpMBR1','user_id' => 'CzUlBvR4r'),
  array('name' => '楼宇之窗重构-用户体系','nickname' => 'huangxt','project_id' => '1CKU3pzafO','user_id' => 'CzUlBvR4r'),
  array('name' => '楼闪送项目','nickname' => 'Allen','project_id' => '1vodQ93E5M','user_id' => 'xMynXjNJG'),
  array('name' => '楼闪送项目','nickname' => 'Allen','project_id' => '1vobRE46n9','user_id' => 'xMynXjNJG')
);

未标明原创文章均为采集，版权归作者所有，转载无需和我联系，请注明原出处，南摩阿彌陀佛，知识，不只知道，要得到