
Hello, I'm a complete newbie to OTRS, so I have a questions. I'm running OTRS on windows XP and did customize the webinterface (add a field), I did map the field also to the config.pm file and now I have to alter the table customer_user (add a new column) The syntax is 'ALTER TABLE customer_user ADD afdeling VARCHAR (200); ' - the problem is which tool or program do I use to add the column and where or how do I start it?? Thanks for the help!! Greetings, Rene ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.

try phpadmin. may be it is installed on your system, in a linux enviroment it would be.... if not, may be a search engine is your friend.... Li otrs-bounces@otrs.org schrieb am 01.02.2006 11:59:21:
Hello,
I'm a complete newbie to OTRS, so I have a questions. I'm running OTRS on windows XP and did customize the webinterface (add a field), I did map the field also to the config.pm file and now I have to alter the table customer_user (add a new column)
The syntax is 'ALTER TABLE customer_user ADD afdeling VARCHAR (200); ' - the problem is which tool or program do I use to add the column and where or how do I start it??
Thanks for the help!!
Greetings, Rene ###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

On 01/02/06, Koning, Rene
The syntax is 'ALTER TABLE customer_user ADD afdeling VARCHAR (200); ' - the problem is which tool or program do I use to add the column and where or how do I start it??
You need a MySQL client such as http://www.mysqlfront.de/ or a web-based client such as http://www.phpmyadmin.net/ which the previous poster mentioned.

Thomas Wills:
On 01/02/06, Koning, Rene
wrote: The syntax is 'ALTER TABLE customer_user ADD afdeling VARCHAR (200); ' - the problem is which tool or program do I use to add the column and where or how do I start it??
You need a MySQL client such as http://www.mysqlfront.de/ or a web-based client such as http://www.phpmyadmin.net/ which the previous poster mentioned.
What is wrong with the standard mysql commandline interface? No need to install anything. Or isn't that available on Windows (I believe the original poster was talking about an installation on Windows)? Nils.

On 01/02/06, Nils Breunese (Lemonbit Internet)
Thomas Wills:
On 01/02/06, Koning, Rene
wrote: The syntax is 'ALTER TABLE customer_user ADD afdeling VARCHAR (200); ' - the problem is which tool or program do I use to add the column and where or how do I start it??
You need a MySQL client such as http://www.mysqlfront.de/ or a web-based client such as http://www.phpmyadmin.net/ which the previous poster mentioned.
What is wrong with the standard mysql commandline interface? No need to install anything.
Good point, I forgot he was running it on his own machine. mysql -u username -p (you will be prompted for the password)

В сообщении от Среда 01 Февраль 2006 14:59 Koning, Rene написал(a):
The syntax is 'ALTER TABLE customer_user ADD afdeling VARCHAR (200); ' - the problem is which tool or program do I use to add the column and where or how do I start it??
goole for "mysql frontend" like MysqlFront (as seems to me...) by the way, the better is just to install linux distro %) -- Mike Lykov ISP Samtelecom, Administrator
participants (5)
-
Koning, Rene
-
Mike Lykov
-
Nils Breunese (Lemonbit Internet)
-
Thomas Wills
-
Volker.Lipper@de.mecglobal.com