Index: main.c
==================================================================
--- main.c
+++ main.c
@@ -38,10 +38,11 @@
   "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);"
+  "CREATE TEMPORARY TABLE `DIVISIONS`(`HEADING` BLOB NOT NULL, `FIRST` INT NOT NULL);"
   "COMMIT;"
 ;
 
 sqlite3*userdb;
 xrm_db*resourcedb;
@@ -197,10 +198,12 @@
       sqlite3_bind_int(st,2,strtol(buf,0,10));
     } else if(i==9 && suffix[1]=='L' && !sqlite3_stricmp(buf,"CLASS.DEF")) {
       sqlite3_bind_int(st,2,LUMP_CLASS_DEF);
     } else if(i==9 && suffix[1]=='L' && !sqlite3_stricmp(buf,"LEVEL.IDX")) {
       sqlite3_bind_int(st,2,LUMP_LEVEL_IDX);
+    } else if(i==12 && suffix[1]=='L' && !sqlite3_stricmp(buf,"DIVISION.IDX")) {
+      sqlite3_bind_int(st,2,LUMP_DIVISION_IDX);
     } else {
       nomatch: sqlite3_bind_null(st,2);
     }
     while((z=sqlite3_step(st))==SQLITE_ROW);
     if(z!=SQLITE_DONE) fatal("SQL error (%d): %s\n",z,sqlite3_errmsg(userdb));
@@ -277,18 +280,40 @@
   sqlite3_finalize(st);
 }
 
 static void load_level_index(void) {
   long sz;
+  sqlite3_stmt*st;
   int i;
   unsigned char*data=read_lump(FIL_LEVEL,LUMP_LEVEL_IDX,&sz);
+  unsigned char*p;
   if(!data) return;
   if(sz>65536) fatal("Too many levels\n");
   level_index=malloc((level_nindex=sz>>1)*sizeof(Uint16));
   if(!level_index) fatal("Allocation failed\n");
   for(i=0;i<level_nindex;i++) level_index[i]=data[i+i]|(data[i+i+1]<<8);
   free(data);
+  // Load divisions
+  data=read_lump(FIL_LEVEL,LUMP_DIVISION_IDX,&sz);
+  if(!data || sz<3) {
+    free(data);
+    return;
+  }
+  if(i=sqlite3_prepare_v2(userdb,"INSERT INTO `DIVISIONS`(`HEADING`,`FIRST`) VALUES(?1,?2);",-1,&st,0))
+   fatal("SQL error (%d): %s\n",i,sqlite3_errmsg(userdb));
+  p=data;
+  while(p<data+sz-3) {
+    sqlite3_reset(st);
+    sqlite3_bind_int(st,2,p[0]|(p[1]<<8));
+    p+=2;
+    sqlite3_bind_blob(st,1,p,i=strnlen(p,data+sz-p),0);
+    p+=i;
+    if(p<data+sz) p++;
+    while(sqlite3_step(st)==SQLITE_ROW);
+  }
+  sqlite3_finalize(st);
+  free(data);
 }
 
 const char*load_level(int lvl) {
   // Load level by ID. Returns null pointer if successful, or an error message if it failed.
   long sz=0;

Index: sql.doc
==================================================================
--- sql.doc
+++ sql.doc
@@ -175,10 +175,19 @@
   A list of classes in the current puzzle set; mostly read-only. Only
   QUIZ, TRACEIN, and TRACEOUT are writable. If TRACEIN is true then it
   will trace messages received by this class (if tracing is enabled). If
   TRACEOUT is true then it will trace messages sent by this class (if
   tracing is enabled).
+
+CREATE TEMPORARY TABLE "DIVISIONS"("HEADING" BLOB NOT NULL, "FIRST" INT
+NOT NULL);
+  The list of level divisions. The HEADING is the (unformatted) heading
+  text, and the FIRST is the order number (not ID number) of the first
+  level to which this heading applies. (Note: Writing to this table by
+  use of SQL statements will not automatically update the puzzle set.
+  However, if you use SQL and then use the level index editor, then that
+  will make the changes permanent.)
 
 CREATE TABLE "INVENTORY"("ID" INTEGER PRIMARY KEY, "CLASS" INT, "IMAGE"
 INT, "VALUE" INT); *
   This table contains the current inventory, and is read-only. It is not
   meaningful in the editor.