These SQL commands should allow to delete a Customer in not valid state
Someone can 'confirm?

-- 1)
delete from service_customer_user where customer_user_login in (select login from customer_user where valid_id=2)
-- 2)
delete from customer_preferences where user_id in (select login from customer_user where valid_id=2)
-- 3)
delete from group_customer_user where user_id in (select login from customer_user where valid_id=2)
-- 4)
delete from customer_user where valid_id=2

By
Rocco



Il 21/02/2013 12.12, Rafa Quiñonero Figuerola ha scritto:
All that things must be done from the database, you can delete tickets, users, partners, services... from database. But pay attention to don´t delete something you need!! 

2013/2/21 Jignesh Kakka (jkakka) <jkakka@cisco.com>
Hi Team,

As of now we only have an option to make customer invalid by setting Valid=0.

Do we have any option to permanently delete the customer?
If yes, then is are similar way for Services also?

Thanks,
Jignesh
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev



--
Rafa Quiñonero Figuerola
Tlf: 0151-61436385
rafakorp@gmail.com 

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

-- 
Rocco Tocci
Application Architect
Strada Prov. 1 BariModugno n. 4
70123 Bari  Italy
Tel. +39 0803855483

TBS IT – Telematic & Biomedical Services Srl a socio unico
Sede Legale : Via Giacinto Gallina, 4 – 34122 Trieste
Tel. 040 - 92291
Sede Operativa : Via Francesco Bettini, 13 – 06034 Foligno
Tel. 0742- 32661
C.F., P.IVA e Registro Imprese (TS) : 01165260322
Cap.Soc. € 8.000.000,00 i.v.
una società di TBS Group SpA
 
Ai sensi del D.Lgs. 196/2003 e della normativa internazionale, vi informiamo che questo messaggio è riservato esclusivamente al destinatario. Se esso vi fosse pervenuto per errore, vi invitiamo a eliminarlo immediatamente e a darcene comunicazione. Grazie.
According to the Italian and international laws in force, we inform you that this message is reserved only for the addressee. If you are not the addressee, please delete it immediately and notify us. Thank you.
 P Per favore, pensa all'ambiente prima di stampare questo messaggio. Please, consider the environment before printing this e-mail.