| Subject: | Keys are not translated right to SQLite |
Asuming the following MySQL-Table definiton:
CREATE TABLE image (
id int(11) NOT NULL auto_increment,
topic varchar(200) NOT NULL default '',
template_id varchar(200) NOT NULL default '',
href text NOT NULL,
PRIMARY KEY (id),
KEY topic (topic(200),template_id(50))
);
The SQLite producer produces:
CREATE TABLE image (
id INTEGER PRIMARY KEY NOT NULL,
topic varchar(200) NOT NULL DEFAULT '',
template_id varchar(200) NOT NULL DEFAULT '',
href text NOT NULL
);
CREATE INDEX topic_image on image (topic(200), template_id(50));
which is unfortunately not undestood by SQLite.
CREATE INDEX topic_image on image (topic, template_id);
instead is.
Nevertheless thanx for that great project!!!