...
Code Block | ||
---|---|---|
| ||
# dump database before! mysqldump composer update php artisan migrate php artisan module:migrate php artisan nms:auth php artisan route:cache # check daily conversions php artisan nms:contract daily php artisan provvoip:phonenumber # check active states in DB mysql -u root -p <psw> db_lara # show all contracts that have network_access=0 or contract-/modem-network-access/phonenumber-active differs [db_lara]> select c.id, c.firstname, c.lastname, c.network_access as Cnw_access, m.network_access as Mnw_access, p.username, p.active from contract c, modem m, mta mta, phonenumber p where c.id=m.contract_id and p.mta_id=mta.id and mta.modem_id=m.id and c.deleted_at is null and m.deleted_at is null and mta.deleted_at is null and p.deleted_at is null and (c.network_access!=m.network_access or c.network_access!=p.active or m.network_access!=p.active or c.network_access=0); |
Import
...
language | bash |
---|---|
title | Test SQL Commands |
...
see Km3 Import Page