Fossil

    db_begin_transaction();
    db_multi_exec(
      "ALTER TABLE repository.mlink ADD COLUMN pmid INTEGER DEFAULT 0;"
      "ALTER TABLE repository.mlink ADD COLUMN isaux BOOLEAN DEFAULT 0;"
    );
    db_end_transaction(0);
  }

  /* Verify that the REMARK table exists.  It was added on 2017-01-10.
  */
  if( !db_table_exists("repository","remark") ){
    db_multi_exec(
      "CREATE TABLE repository.remark(\n"
      "  rid INTEGER PRIMARY KEY,\n" /* The Remark artifact in BLOB table */
      "  ctime TIMESTAMP,\n"         /* Creation date.  Julian day. */
      "  target TEXT,\n"             /* UUID for check-in or name of branch */
      "  uid TEXT\n"                 /* Name of user who entered remark */
      ");\n"
      "CREATE INDEX repository.remarkidx1 ON remark(target,ctime);"
    );
  }
}

/*
** Flags for the db_find_and_open_repository() function.
*/
#if INTERFACE
#define OPEN_OK_NOT_FOUND    0x001      /* Do not error out if not found */

    db_multi_exec(
      "REPLACE INTO event(type,mtime,objid,user,comment)"
      "VALUES('g',%.17g,%d,%Q,%Q)",
      p->rDate, rid, p->zUser, blob_str(&comment)+1
    );
    blob_reset(&comment);
  }
  if( p->type==CFTYPE_REMARK ){
    db_multi_exec(
      "INSERT OR IGNORE INTO remark(rid,target,ctime,uid)"
      "VALUES(%d,%Q,%.17g,%Q)", p->rid, p->zRemTarget, p->rDate, p->zUser);
  }
  db_end_transaction(0);
  if( permitHooks ){
    rc = xfer_run_common_script();
    if( rc==TH_OK ){
      rc = xfer_run_script(zScript, zUuid, 0);
    }
  }

** changes.  The aux tables have an arbitrary version number (typically
** a date) which can change frequently.  When the content schema changes,
** we have to execute special procedures to update the schema.  When
** the aux schema changes, all we need to do is rebuild the database.
*/
#define CONTENT_SCHEMA  "2"
#define AUX_SCHEMA_MIN  "2011-04-25 19:50"
#define AUX_SCHEMA_MAX  "2017-01-10"
/* NB:  Some features require the latest schema.  Warning or error messages
** will appear if an older schema is used.  However, the older schemas are
** adequate for many common functions. */

#endif /* INTERFACE */

@   -- Add as many fields as required below this line
@   login TEXT,
@   username TEXT,
@   mimetype TEXT,
@   icomment TEXT
@ );
@ CREATE INDEX ticketchng_idx1 ON ticketchng(tkt_id, tkt_mtime);
@
@ -- Each remark artifact makes a single entry in the Remark table.
@ CREATE TABLE remark(
@   rid INTEGER PRIMARY KEY, -- The Remark artifact in the BLOB table
@   ctime TIMESTAMP,         -- Creation date.  Julian day.
@   target TEXT,             -- UUID for check-in or name of branch
@   uid TEXT                 -- Name of user who entered this remark
@ );
@ CREATE INDEX remarkidx1 ON remark(target,ctime);
;


/*
** Predefined tagid values
*/
#if INTERFACE
# define TAG_BGCOLOR    1     /* Set the background color for display */
# define TAG_COMMENT    2     /* The check-in comment */