Index: TODO
==================================================================
--- TODO
+++ TODO
@@ -10,10 +10,11 @@
   * Testing the deferred movement
   * String data
   * A ,PopUp command to use a popup with arguments starting from a mark
   * "Goto message" instruction (?)
   * Returning a class from COLLIDE/COLLIDEBY to transform
+  * Coordinate input (may be suitable for some kind of games)
 * Editor
   * Mouse dragging
   * Level index editor
   * Bizarro world
   * Selection rectangles
@@ -39,5 +40,6 @@
   * Implement the GROUP column in the CLASSES table
   * Allow multiple SQL statements in one binding
 * Large fonts (width 8 or 16, height 8-32)
 * Branching replay recording
 * Slow movement displaying state between triggers
+* Warning if file changed when uncommited data exists in the cache database

Index: main.c
==================================================================
--- main.c
+++ main.c
@@ -35,10 +35,11 @@
   "PRAGMA APPLICATION_ID(1296388936);"
   "PRAGMA RECURSIVE_TRIGGERS(1);"
   "CREATE TABLE IF NOT EXISTS `USERCACHEINDEX`(`ID` INTEGER PRIMARY KEY, `NAME` TEXT, `TIME` INT);"
   "CREATE TABLE IF NOT EXISTS `USERCACHEDATA`(`ID` INTEGER PRIMARY KEY, `FILE` INT, `LEVEL` INT, `NAME` TEXT COLLATE NOCASE, `OFFSET` INT, `DATA` BLOB, `USERSTATE` BLOB);"
   "CREATE UNIQUE INDEX IF NOT EXISTS `USERCACHEDATA_I1` ON `USERCACHEDATA`(`FILE`, `LEVEL`);"
+  "CREATE TRIGGER IF NOT EXISTS `USERCACHEINDEX_DELETION` AFTER DELETE ON `USERCACHEINDEX` BEGIN DELETE FROM `USERCACHEDATA` WHERE `FILE` = OLD.`ID`; END;"
   "CREATE TEMPORARY TABLE `PICTURES`(`ID` INTEGER PRIMARY KEY, `NAME` TEXT COLLATE NOCASE, `OFFSET` INT, `DEPENDENT` INT);"
   "CREATE TEMPORARY TABLE `VARIABLES`(`ID` INTEGER PRIMARY KEY, `NAME` TEXT);"
   "COMMIT;"
 ;
 
@@ -72,17 +73,10 @@
 static sqlite3_int64 reset_usercache(FILE*fp,const char*nam,struct stat*stats,const char*suffix) {
   sqlite3_stmt*st;
   sqlite3_int64 t,id;
   char buf[128];
   int i,z;
-  if(z=sqlite3_prepare_v2(userdb,"DELETE FROM `USERCACHEDATA` WHERE `FILE` = (SELECT `ID` FROM `USERCACHEINDEX` WHERE `NAME` = ?1);",-1,&st,0)) {
-    fatal("SQL error (%d): %s\n",z,sqlite3_errmsg(userdb));
-  }
-  sqlite3_bind_text(st,1,nam,-1,0);
-  while((z=sqlite3_step(st))==SQLITE_ROW);
-  if(z!=SQLITE_DONE) fatal("SQL error (%d): %s\n",z,sqlite3_errmsg(userdb));
-  sqlite3_finalize(st);
   if(z=sqlite3_prepare_v2(userdb,"DELETE FROM `USERCACHEINDEX` WHERE `NAME` = ?1;",-1,&st,0)) fatal("SQL error (%d): %s\n",z,sqlite3_errmsg(userdb));
   sqlite3_bind_text(st,1,nam,-1,0);
   while((z=sqlite3_step(st))==SQLITE_ROW);
   if(z!=SQLITE_DONE) fatal("SQL error (%d): %s\n",z,sqlite3_errmsg(userdb));
   sqlite3_finalize(st);