SQL Inserts to SPANISH
"Aquiles Cohen" <[email protected]>
| Newsgroups | gmane.comp.otrs.internationalization |
|---|---|
| Message-ID | <[email protected]> |
1. Is There any way to make spanish packages from .opm packages?
2. IF 1 = True
then Is this help?
<DatabaseInstall Type="post">
<TableCreate Type="post" Name="configitem">
<Column AutoIncrement="true" Name="id" PrimaryKey="true"
Required="true" Type="BIGINT"></Column>
<Column Name="configitem_number" Required="true" Size="100"
Type="VARCHAR"></Column>
<Column Name="class_id" Required="true" Type="INTEGER"></Column>
<Column Name="last_version_id" Required="false"
Type="BIGINT"></Column>
<Column Name="cur_depl_state_id" Required="false"
Type="INTEGER"></Column>
<Column Name="cur_inci_state_id" Required="false"
Type="INTEGER"></Column>
<Column Name="create_time" Required="true" Type="DATE"></Column>
<Column Name="create_by" Required="true"
Type="INTEGER"></Column>
<Column Name="change_time" Required="true" Type="DATE"></Column>
<Column Name="change_by" Required="true"
Type="INTEGER"></Column>
<Unique>
<UniqueColumn
Name="configitem_number"></UniqueColumn>
</Unique>
<Index Name="configitem_class_id">
<IndexColumn Name="class_id">
</IndexColumn>
</Index>
<Index Name="configitem_last_version_id">
<IndexColumn Name="last_version_id">
</IndexColumn>
</Index>
<Index Name="configitem_cur_depl_state_id">
<IndexColumn Name="cur_depl_state_id">
</IndexColumn>
</Index>
<Index Name="configitem_cur_inci_state_id">
<IndexColumn Name="cur_inci_state_id">
</IndexColumn>
</Index>
<ForeignKey ForeignTable="general_catalog">
<Reference Foreign="id" Local="class_id">
</Reference>
<Reference Foreign="id" Local="cur_depl_state_id">
</Reference>
<Reference Foreign="id" Local="cur_inci_state_id">
</Reference>
</ForeignKey>
<ForeignKey ForeignTable="users">
<Reference Foreign="id" Local="create_by">
</Reference>
<Reference Foreign="id" Local="change_by">
</Reference>
</ForeignKey>
</TableCreate>
<TableCreate Type="post" Name="configitem_definition">
<Column AutoIncrement="true" Name="id" PrimaryKey="true"
Required="true" Type="INTEGER"></Column>
<Column Name="class_id" Required="true" Type="INTEGER"></Column>
<Column Name="configitem_definition" Required="true"
Type="LONGBLOB"></Column>
<Column Name="version" Required="true" Type="INTEGER"></Column>
<Column Name="create_time" Required="true" Type="DATE"></Column>
<Column Name="create_by" Required="true"
Type="INTEGER"></Column>
<ForeignKey ForeignTable="general_catalog">
<Reference Foreign="id" Local="class_id">
</Reference>
</ForeignKey>
<ForeignKey ForeignTable="users">
<Reference Foreign="id" Local="create_by">
</Reference>
</ForeignKey>
</TableCreate>
<TableCreate Type="post" Name="configitem_version">
<Column AutoIncrement="true" Name="id" PrimaryKey="true"
Required="true" Type="BIGINT"></Column>
<Column Name="configitem_id" Required="true"
Type="BIGINT"></Column>
<Column Name="name" Required="true" Size="250"
Type="VARCHAR"></Column>
<Column Name="definition_id" Required="true"
Type="INTEGER"></Column>
<Column Name="depl_state_id" Required="true"
Type="INTEGER"></Column>
<Column Name="inci_state_id" Required="false"
Type="INTEGER"></Column>
<Column Name="create_time" Required="true" Type="DATE"></Column>
<Column Name="create_by" Required="true"
Type="INTEGER"></Column>
<Index Name="configitem_version_configitem_id">
<IndexColumn Name="configitem_id">
</IndexColumn>
</Index>
<Index Name="configitem_version_depl_state_id">
<IndexColumn Name="depl_state_id">
</IndexColumn>
</Index>
<Index Name="configitem_version_inci_state_id">
<IndexColumn Name="inci_state_id">
</IndexColumn>
</Index>
<ForeignKey ForeignTable="configitem">
<Reference Foreign="id" Local="configitem_id">
</Reference>
</ForeignKey>
<ForeignKey ForeignTable="configitem_definition">
<Reference Foreign="id" Local="definition_id">
</Reference>
</ForeignKey>
<ForeignKey ForeignTable="general_catalog">
<Reference Foreign="id" Local="depl_state_id">
</Reference>
<Reference Foreign="id" Local="inci_state_id">
</Reference>
</ForeignKey>
<ForeignKey ForeignTable="users">
<Reference Foreign="id" Local="create_by">
</Reference>
</ForeignKey>
</TableCreate>
<TableCreate Type="post" Name="configitem_counter">
<Column Name="class_id" PrimaryKey="true" Required="true"
Type="INTEGER"></Column>
<Column Name="counter_type" Required="true" Size="50"
Type="VARCHAR"></Column>
<Column Name="counter" Required="true" Size="50"
Type="VARCHAR"></Column>
<ForeignKey ForeignTable="general_catalog">
<Reference Foreign="id" Local="class_id">
</Reference>
</ForeignKey>
</TableCreate>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Class</Data>
<Data Key="name" Type="Quote">Computador</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Class</Data>
<Data Key="name" Type="Quote">Hardware</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Class</Data>
<Data Key="name" Type="Quote">Ubicación</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Class</Data>
<Data Key="name" Type="Quote">Red</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Class</Data>
<Data Key="name" Type="Quote">Software</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Vencido</Data>
<Data Key="functionality" Type="Quote">productive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Inactivo</Data>
<Data Key="functionality" Type="Quote">postproductive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Mantenimiento</Data>
<Data Key="functionality" Type="Quote">productive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Piloto</Data>
<Data Key="functionality" Type="Quote">productive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Planificado</Data>
<Data Key="functionality" Type="Quote">preproductive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Producción</Data>
<Data Key="functionality" Type="Quote">productive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Reparación</Data>
<Data Key="functionality" Type="Quote">productive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Retirado</Data>
<Data Key="functionality" Type="Quote">postproductive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Revisado</Data>
<Data Key="functionality" Type="Quote">productive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
<Data Key="name" Type="Quote">Pruebas</Data>
<Data Key="functionality" Type="Quote">preproductive</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::YesNo</Data>
<Data Key="name" Type="Quote">Si</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::YesNo</Data>
<Data Key="name" Type="Quote">No</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
<Data Key="name" Type="Quote">Portatil</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
<Data Key="name" Type="Quote">Desktop</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
<Data Key="name" Type="Quote">Teléfono</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
<Data Key="name" Type="Quote">Agenda Personal</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
<Data Key="name" Type="Quote">Servidor</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
<Data Key="name" Type="Quote">Otro</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Monitor</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Impresora</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Switch</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Enrutador</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">WLAN Access Point</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Dispositivo de Seguridad</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Dispositivo de Copias</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Mouse</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Teclado</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Cámara</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Video Beam</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Modem</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Tarjeta PCMCIA</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Dispositivo USB</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Docking Station</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Escaner</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
<Data Key="name" Type="Quote">Otro</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Edificio</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Oficina</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Piso</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Salón</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Rack</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Lugar de Trabajo</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Exterior</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Cuarto de Cableado</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Location::Type</Data>
<Data Key="name" Type="Quote">Otro</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Network::Type</Data>
<Data Key="name" Type="Quote">LAN</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Network::Type</Data>
<Data Key="name" Type="Quote">WLAN</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Network::Type</Data>
<Data Key="name" Type="Quote">Telco</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Network::Type</Data>
<Data Key="name" Type="Quote">GSM</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Network::Type</Data>
<Data Key="name" Type="Quote">Otro</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">Aplicación Cliente</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">Middleware</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">Aplicación Servidor</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">SO Cliente</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">SO Servidor</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">Herramienta de
Administrador</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">Herramienta de Usuario</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">Embebido</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::Type</Data>
<Data Key="name" Type="Quote">Otro</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Single Licence</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Por Usuario</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Usuarios Concurrentes</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Por Procesador</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Por Servidor</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Por Nodo</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Licencia por Volumen</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Licencia Corporativa</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Licencia de Desarrollador</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Demostración</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">de Tiempo Restringida</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Freeware</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Open Source</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>
<Insert Type="post" Table="general_catalog">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
<Data Key="name" Type="Quote">Ilimitada</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>
</DatabaseInstall>
<DatabaseUpgrade>
<Insert Type="post" Table="general_catalog" Version="1.1.90">
<Data Key="general_catalog_class"
Type="Quote">ITSM::ConfigItem::Class</Data>
<Data Key="name" Type="Quote">Ubicación</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>
<DatabaseUninstall Type="pre">
<TableDrop Type="pre" Name="configitem_counter">
</TableDrop>
<TableDrop Type="pre" Name="configitem_version">
</TableDrop>
<TableDrop Type="pre" Name="configitem_definition">
</TableDrop>
<TableDrop Type="pre" Name="configitem">
</TableDrop>
</DatabaseUninstall>
Aquiles Cohen.-
Homepage : http://aqcohen.blogspot.com
_______________________________________________
OTRS mailing list: i18n
Archiv: http://lists.otrs.org/cgi-bin/listinfo/i18n