I am new to android sqlite.

**Problem:**

Create a table with three columns(namely column1,column2 and column3) all of type TEXT .Column1 and Column2 should together form a composite primary key.Also,this table will be used by CursorAdapter. So creating an `_id` field becomes necessary.

**Till Now:**

* Able to create a table without \_id with column1 and column2 as PK using below query:

`CREATE TABLE Test ( column1 TEXT, column2 TEXT, column3 TEXT, PRIMARY KEY(column1,column2 ));`
* Able to create a table with \_id as AUTOINCREMENT

`CREATE TABLE Test ( _id INTEGER PRIMARY KEY AUTOINCREMENT, column1 TEXT, column2 TEXT, column3 TEXT);`

But I am unable to create the combination of both.

I have tried the below queries and both give errors:

1> `CREATE TABLE Test ( _id INTEGER AUTOINCREMENT, column1 TEXT, column2 TEXT, column3 TEXT, PRIMARY KEY(_id ,column1,column2 ));`

2>`CREATE TABLE Test ( _id INTEGER , column1 TEXT, column2 TEXT, column3 TEXT, PRIMARY KEY(_id AUTOINCREMENT,column1,column2 ));`

So please help me out in creating the table with the below mentioned feature i.e.

* Should have an `_id` autoincrement field
* should have a composite primary key over column1 as well as column2