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.