Table creation template
If the data source user has table creation permissions, then the table is created using this template the first time hcimsgarchive connects. If the data source user does not have table creation permissions, then the table must be created independently. This must be created by someone who has permission, for example, a database administrator.
This is a portion of the template for the table creation SQL that is used to
insert data. <TABLENAME>
is replaced with the table
name. The items that are surrounded by <
and >
characters are replaced with the equivalent bind parameters.
CREATE TABLE <TABLENAME> (
MID VARCHAR(16) NOT NULL,
SOURCEMID VARCHAR(16) NULL,
TYPE VARCHAR(16) NULL,
PRIORITY VARCHAR(16) NULL,
HOSTID VARCHAR(128) NOT NULL,
VERSION VARCHAR(16) NOT NULL,
SITE VARCHAR(64) NOT NULL,
. . . . .
This template is stored as create_template.sql in the archiving folder.