#25 Jtrac and mysql-datatype
I'm a new user for jtrac and i've got some trouble about database tables view. I am using mysql(mysql workbench 6.0) database make necessarily properties for that. When i login to JTRAC first time it creates an empty database tables. When i add some spaces and items i can see added values on database but the values look as integer values. For example in history table "status" column seen as "1" for open and "99" for closed(default values). I want to see the actual writen values for columns not as integer. I try to change the datatype of "status" column from database table as enum('open','closed'), but this time when i login to the system, system can not open previously created record view and in log file represented java.sql.SQLException:invalid value for getInt()-Open.
Is there any way to fix this? and how can i change default values for a column?