Sql_SysUser_gen.go 1.3 KB

1234567891011
  1. package models
  2. var Insert_sys_user = "insert into sys_user(`id`,`login_id`,`password`,`name`,`full_name`,`mobile`,`email`,`org_id`,`type`,`status`,`domain`,`create_by`,`create_time`,`last_update_by`,`last_update_date`,`del_flag`) values (?id,?login_id,?password,?name,?full_name,?mobile,?email,?org_id,?type,?status,?domain,?create_by,?create_time,?last_update_by,?last_update_date,?del_flag)"
  3. var Update_sys_user = "update sys_user set `login_id` = ?login_id,`password` = ?password,`name` = ?name,`full_name` = ?full_name,`mobile` = ?mobile,`email` = ?email,`org_id` = ?org_id,`type` = ?type,`status` = ?status,`domain` = ?domain,`create_by` = ?create_by,`create_time` = ?create_time,`last_update_by` = ?last_update_by,`last_update_date` = ?last_update_date,`del_flag` = ?del_flag where id = ?id"
  4. var Deleteone_sys_user = "delete from sys_userwhere id =?id"
  5. var Selectone_sys_user = "select `id`,`login_id`,`password`,`name`,`full_name`,`mobile`,`email`,`org_id`,`type`,`status`,`domain`,`create_by`,`create_time`,`last_update_by`,`last_update_date`,`del_flag` from sys_user where id = ?id"
  6. var Selectall_sys_user = "select `id`,`login_id`,`password`,`name`,`full_name`,`mobile`,`email`,`org_id`,`type`,`status`,`domain`,`create_by`,`create_time`,`last_update_by`,`last_update_date`,`del_flag` from sys_user"