iPhone: Create sqlite database with foreign key supported
<p>I am developing an iPhone application, where i need to store large data in an sqlite3 database.</p>

<p>I would like to create table with foreign key constraints for the below one example. How can i create the below tables using "sqlitemanager" firefox (or) through programmaitcally?</p>

<p>Please advise!</p>

<pre><code>"CREATE TABLE List (_id INTEGER PRIMARY KEY, ListId INTEGER UNIQUE, ListName TEXT, nameId INTEGER, FLAG BOOL)",
"CREATE TABLE User (_id INTEGER PRIMARY KEY, Name TEXT, ListId INTEGER, FOREIGN KEY(ListId) REFERENCES List(ListId))",
</code></pre>
