✏️ 正在编辑: 161.sql
路径:
/srv/systems_dir/yuppiecred/data/database/161.sql
提示:
您可以编辑任何文件(包括二进制文件),但请注意不当修改可能导致文件损坏。
ALTER TABLE `tb_usuarios` ADD `receber_email_copia` TINYINT( 2 ) NULL DEFAULT '0' AFTER `dias` ; DROP VIEW `vw_usuarios`; CREATE VIEW `vw_usuarios` AS select `u`.`id` AS `id`,`u`.`grupo_id` AS `grupo_id`,`u`.`empresa_id` AS `empresa_id`,`u`.`corretor_id` AS `corretor_id`,`u`.`nome` AS `nome`,`u`.`email` AS `email`,`u`.`login` AS `login`,`u`.`senha` AS `senha`,`u`.`ramal_login` AS `ramal_login`,`u`.`ramal_senha` AS `ramal_senha`,`u`.`excluido` AS `excluido`,`u`.`hora_inicio` AS `hora_inicio`,`u`.`hora_fim` AS `hora_fim`,`u`.`dias` AS `dias`, `receber_email_copia` AS `receber_email_copia`, `gu`.`nome` AS `grupo` from (`tb_usuarios` `u` join `tb_grupos_usuarios` `gu` on((`gu`.`id` = `u`.`grupo_id`))) where ((`gu`.`excluido` <> 1) and (`u`.`excluido` <> 1));
💾 保存文件
← 返回文件管理器