# Customize Database

You can change any string value from file **string.xml**

here example for Database string attribute :

```markup
 <string name="db_name">database.sqlite</string>
 <string name="db_user_name">database_user.sqlite</string>
 
 <integer name="db_version">1</integer>
 
 <string name="table1_ind_en">table_ind_en</string>
 <string name="table2_en_ind">table_en_ind</string>
 <string name="column1_edited">edited</string>
 <string name="column2_favorites">favorites</string>
 <string name="column3_id">_id</string>
 <string name="column4_word">word</string>
 <string name="column5_result">result</string>
```

&#x20;Edit database with query sqlite browser : download here : [http://sqlitebrowser.org/](http://sqlitebrowser.org/)

## Prepare Database

If you want to clear current database value you just need to execute this query to clear all table value :

\#clear first table :&#x20;

```sql
DELETE FROM table_en_ind;  VACUUM;
```

&#x20;\#clear second table :&#x20;

```sql
DELETE FROM table_ind_en;  VACUUM;
```

## Insert Data

You just need to execute this query to add more record:&#x20;

\#This insert one row for first table :

```sql
INSERT INTO table_ind_en (edited, favorites, word, result)   
VALUES ( '-', '-',  'your word1', 'your word translate1' ); 
```

&#x20;\#This insert one row for second table :

```sql
INSERT INTO table_en_ind (edited, favorites, word, result)   
VALUES ( '-', '-',  'your word1', ' your word translate1' ); 
```

&#x20; If you done with this step save **database.sqlite** and copy it into asset project folder.&#x20;

