handling database in Packages

[root]

Hi,

does anybody knows what can be wrong with this xml in my sopm?

Code: Select all

<DatabaseUpgrade>
         <Insert Type="post" Table="ticket_state_type" Version="0.1">
            <Data Key="name" Type="Quote">pending job</Data>
            <Data Key="create_time">current_timestamp</Data>
            <Data Key="create_by">1</Data>
            <Data Key="change_time">current_timestamp</Data>
            <Data Key="change_by">1</Data>
         </Insert>
         <Insert Type="post" Table="ticket_state" Version="0.1">
            <Data Key="Name">closed</Data>
            <Data Key="type_id">3</Data>
            <Data Key="valid_id">1</Data>
            <Data Key="create_time">current_timestamp</Data>
            <Data Key="create_by">1</Data>
            <Data Key="change_time">current_timestamp</Data>
            <Data Key="change_by">1</Data>
         </Insert>
</DatabaseUpgrade>

otrs.PackageManager.pl show me this error:
duplicate attribute at line 25, column 54


My second question is how to get the type_id for new created TicketStateTypes.

tia