Cordova / Sqlite外键

这是我的javascript代码`

var dbname = "PresentationDB";
var dbVersion = "1.0";
var bdSize = 100000;
var displayName = "TTPresentationDB";
var db = null;

var app = {


initialize: function() {
    this.bindEvents();
},bindEvents: function() {
    document.addEventListener('deviceready',this.onDeviceReady,falsE);
},onDeviceReady: function() {
    app.receivedEvent('deviceready');
    db = createdb();
    alert(db);
    db.transaction(populatedb,errorCallBACk,successCallBACk);

 },// update DOM on a Received Event
receivedEvent: function(id) {

    console.log('Received Event: ' + id);
}



};

app.initialize();


function createdb()
{

 if (!window.openDatabasE)
 {
   alert("Your browser does not support openDatabase");
 }
 alert("creaTing db..");
 return window.openDatabase(dbName,dbVersion,displayName,bdSizE);

 }


function populatedb(tX)
{
tx.executesql('create table IF NOT EXISTS PAGE (id_page INTEGER PRIMARY KEY 
   AUTOINCREMENT,title varchar(255),description TEXT,num_visits DATE,last_visited date)');
tx.executesql('create table IF NOT EXISTS CONTENT (id_content INTEGER PRIMARY
   KEY AUTOINCREMENT,FOREIGN KEY(id_pagE) REFERENCES PAGE (id_pagE))');
tx.executesql('create table IF NOT EXISTS ARTICLE (id_article INTEGER PRIMARY 
   KEY AUTOINCREMENT,@R_482_3801@,FOREIGN 
   KEY (id_pagE) REFERENCES PAGE (id_pagE))');
tx.executesql('INSERT INTO PAGE (title,description,num_visits,last_visited) VALUES ("First Page","Test Page",CURRENT_TIME,CURRENT_TIME)');
tx.executesql('INSERT INTO CONTENT (id_pagE) VALUES (1)');
tx.executesql('INSERT INTO ARTICLE (title,text,id_pagE) VALUES 
   ("Article 1 Page 1","Test Article",1)');
tx.executesql('INSERT INTO ARTICLE (title,id_pagE) VALUES 
   ("Article 2 Page 1",1)');


}

function successCallBACk()
{
    alert("Sucess");
    //alert("Returned rows = " + results.rows.length);
}


 function errorCallBACk(tx,err)
 {
  alert("Error : " + err );
 }

function queryDB(tX)  
{
   tx.executesql('SELECT * FROM DEMO',[],querysuccess,errorCB);

}

`

添加外键时的行导致错误,有没有办法为sqlITE和Cordova创建关系数据库？

解决方法

create table IF NOT EXISTS CONTENT (id_content INTEGER PRIMARY
   KEY AUTOINCREMENT,id_page INTEGER,FOREIGN KEY(id_pagE) REFERENCES PAGE (id_pagE))'