Versions Compared

Old Version 1

changes.mady.by.user Dennis Scheidner

Saved on

compared with

New Version 2

changes.mady.by.user Dennis Scheidner

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Kontakte aus antony exportieren (über Navicat)

Code Block
languagesql
SELECT
contact.id,contact.main_contact_id,contacttitle.`name` as title,contact.company,contact.firstname,contact.lastname,contact.street,contact.zipcode,contact.city,contactstate.`name` as state,contactcountry.`name` as country,contact.phone,contact.phone2,contact.fax,contact.email,contact.mobile,contact.homepage,contact.`comment`,contact.street_private,contact.zipcode_private,contact.city_private,privatestate.`name` as state_private,privatecountry.`name` as country_private,contact.phone_private,contact.phone2_private,contact.fax_private,contact.department,contact.birthday
FROM
contact
LEFT JOIN type_state as contactstate ON contactstate.id = contact.state
LEFT JOIN type_state as privatestate ON privatestate.id = contact.state_private
LEFT JOIN type_title as contacttitle ON contacttitle.id = contact.title_id
LEFT JOIN type_country as contactcountry ON contactcountry.id = contact.country_id
LEFT JOIN type_country as privatecountry ON privatecountry.id = contact.country_id_private
WHERE
contact.deleted = 0
ORDER by main_contact_id ASC

Alle Emails aus antony und dem Dateisystem löschen (über Navicat und Powershell)

  1. Pfade im Dateisystem aus Datenbank holen und das Ergebniss in einem administrativen Powershell-Fenster ausführen

    Code Block
    languagesql
    select CONCAT("Remove-item \'", SUBSTRING(guid, 1, 2), "/", SUBSTRING(guid, 3, 2) , "/", REPLACE( SUBSTRING(guid, 5), "-", "/"), "/\' -Recurse -Force")
FROM instance_properties_attachments
WHERE addin_id=3

  2. Daten aus Datenbank löschen

    Code Block
    languagesql
    DELETE FROM email_messages;
DELETE FROM email_addresses;
DELETE FROM `email_message-email_account`;
DELETE FROM instance_properties WHERE instance_id=3;
DELETE FROM tlstatus WHERE instance_id=3;
DELETE FROM instance_properties_attachments where addin_id=3