use novomoodle;
update mdl_user, users set mdl_user.username=users.uid where mdl_user.email=users.mail and mdl_user.auth='oidc';
UPDATE
Sales_Import SI,
RetrieveAccountNumber RAN
SET
SI.AccountNumber = RAN.AccountNumber
WHERE
SI.LeadID = RAN.LeadID;
verificar collation e charset aqui
modificar o default collation da base de dados:
SELECT DISTINCT concat('ALTER DATABASE ', TABLE_SCHEMA, ' CHARACTER SET utf8 COLLATE utf8_general_ci;') from information_schema.tables where TABLE_SCHEMA like 'database_name';
http://stackoverflow.com/questions/5906585/how-to-change-the-default-collation-of-a-database
modificar o default charset e collation de todas as tabelas na base de dados:
atualizar o sistema
# apt-get update && apt-get upgrade
instalar nginx
apt-get install nginx
iniciar o serviço
service nginx start
editar o ficheiro /etc/nginx/nginx.conf e substituir
worker_processes 8; deve ser igual ao número de cores do processador
access_log off; para melhorar a performance de e/s
client_max_body_size 64m;
instalar o php-fpm
# apt-get install php5-fpm php5-mysqlnd