Re: [sqlite] Preserve optimzation after a table change

Raphaël KINDT <[EMAIL PROTECTED]> wrote: > How can I change the schema of this table to keep the optimzation and > allow to have two same 'time'? > > CREATE TABLE events( >time REAL NOT NULL PRIMARY KEY, >detections BLOB); > > CREATE INDEX idxTime ON events (time ASC); Just

[sqlite] Preserve optimzation after a table change

Hello, How can I change the schema of this table to keep the optimzation and allow to have two same 'time'? CREATE TABLE events( time REAL NOT NULL PRIMARY KEY, detections BLOB); CREATE INDEX idxTime ON events (time ASC); Thanks in advance. KINDT Raphaël