# ICD10 spanish version?

**URL:** <https://community.open-emr.org/t/icd10-spanish-version/8317>\
**Category:** Management and Administration\
**Tags:** question\
**Created:** [March 30, 2017, 3:06pm UTC](https://community.open-emr.org/t/icd10-spanish-version/8317 "2017-03-30T15:06:34Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![luisuriarte](https://community.open-emr.org/user_avatar/community.open-emr.org/luisuriarte/32/15503_2.png) [@luisuriarte](https://community.open-emr.org/u/luisuriarte)\
**Post date:** [March 21, 2023, 12:56pm UTC](https://community.open-emr.org/t/icd10-spanish-version/8317/21 "2023-03-21T12:56:34Z")

</div>

@Fernando_Guerra , mejor cambia el nombre a las tablas originales para resguardo y luego ejecuta los script sql que te envié. Crearán tablas nuevas.  
Saludos.  
Luis  
(Sorry to the forum for writing in Spanish)

---

<div class="post-metadata">

**Author:** ![Fernando\_Guerra](https://community.open-emr.org/user_avatar/community.open-emr.org/fernando_guerra/32/10760_2.png) [@Fernando\_Guerra](https://community.open-emr.org/u/Fernando_Guerra)\
**Post date:** [March 21, 2023, 5:23pm UTC](https://community.open-emr.org/t/icd10-spanish-version/8317/22 "2023-03-21T17:23:58Z")

</div>

Thanks so much Luis, I’ve just installed OpenEMR v7 in a hosting space, I’m so happy ! First I’ll try it in my local VirtualBox Ubuntu 20 then I’ll let you know

Muchas gracias Luis un fuerte abrazo

---

<div class="post-metadata">

**Author:** ![Fernando\_Guerra](https://community.open-emr.org/user_avatar/community.open-emr.org/fernando_guerra/32/10760_2.png) [@Fernando\_Guerra](https://community.open-emr.org/u/Fernando_Guerra)\
**Post date:** [March 24, 2023, 3:52am UTC](https://community.open-emr.org/t/icd10-spanish-version/8317/23 "2023-03-24T03:52:42Z")

</div>

It works ok !  
Thanks !!!

---

<div class="post-metadata">

**Author:** ![Marco\_Meza](https://community.open-emr.org/user_avatar/community.open-emr.org/marco_meza/32/18988_2.png) [@Marco\_Meza](https://community.open-emr.org/u/Marco_Meza)\
**Post date:** [September 17, 2023, 5:08am UTC](https://community.open-emr.org/t/icd10-spanish-version/8317/24 "2023-09-17T05:08:50Z")

</div>

Thank you Luis,

This scripts will replace “english version” of ICD10. In my case, I am running MariaDB in my server, I can connect to it using DBeaver.

I had to drop table and create it again. I noticed that some codes exceeds 7 characters, so I modified the column size to 10.

I recommend to drop the table as first step

```auto
DROP TABLE IF EXISTS icd10_dx_order_code;

DROP TABLE IF EXISTS icd10_pcs_order_code;

```

Then create it again

```auto
CREATE TABLE icd10_dx_order_code (
  dx_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  dx_code varchar(10) DEFAULT NULL,
  formatted_dx_code varchar(10) DEFAULT NULL,
  valid_for_coding char(1) DEFAULT NULL,
  short_desc varchar(60) DEFAULT NULL,
  long_desc text DEFAULT NULL,
  active tinyint(4) DEFAULT 0,
  revision int(11) DEFAULT 0,
 UNIQUE KEY dx_id (dx_id),
 KEY formatted_dx_code (formatted_dx_code),
 KEY active (active)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE icd10_pcs_order_code (
  pcs_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  pcs_code varchar(10) DEFAULT NULL,
  valid_for_coding char(1) DEFAULT NULL,
  short_desc varchar(60) DEFAULT NULL,
  long_desc text DEFAULT NULL,
  active tinyint(4) DEFAULT 0,
  revision int(11) DEFAULT 0,
  UNIQUE KEY pcs_id (pcs_id),
  KEY pcs_code (pcs_code),
  KEY active (active)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

```

and then run the batch insert script.

[Previous page](https://community.open-emr.org/t/icd10-spanish-version/8317.md?page=1)