text: --# Logback: the reliable, generic, fast and flexible logging framework.
  --# Copyright (C) 1999-2012, QOS.ch. All rights reserved.
  --#
  --# See http://logback.qos.ch/license.html for the applicable licensing
  --# conditions.
  --#
  --# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender.
  --#
  --# It is intended for SQLite3 databases. It has been tested on SQLite 3.7.4
  --# on Android ICS (4.0.3).
  
  
  BEGIN;
  DROP TABLE IF EXISTS logging_event_property;
  DROP TABLE IF EXISTS logging_event_exception;
  DROP TABLE IF EXISTS logging_event;
  COMMIT;
  
  
  BEGIN;
  CREATE TABLE logging_event
    (
      timestmp         BIGINT NOT NULL,
      formatted_message  TEXT NOT NULL,
      logger_name       VARCHAR(254) NOT NULL,
      level_string      VARCHAR(254) NOT NULL,
      thread_name       VARCHAR(254),
      reference_flag    SMALLINT,
      arg0              VARCHAR(254),
      arg1              VARCHAR(254),
      arg2              VARCHAR(254),
      arg3              VARCHAR(254),
      caller_filename   VARCHAR(254) NOT NULL,
      caller_class      VARCHAR(254) NOT NULL,
      caller_method     VARCHAR(254) NOT NULL,
      caller_line       CHAR(4) NOT NULL,
      event_id          INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
    );
  COMMIT;
  
  BEGIN;
  CREATE TABLE logging_event_property
    (
      event_id	      BIGINT NOT NULL,
      mapped_key        VARCHAR(254) NOT NULL,
      mapped_value      TEXT,
      PRIMARY KEY(event_id, mapped_key),
      FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
    );
  COMMIT;
  
  BEGIN;
  CREATE TABLE logging_event_exception
    (
      event_id         BIGINT NOT NULL,
      i                SMALLINT NOT NULL,
      trace_line       VARCHAR(254) NOT NULL,
      PRIMARY KEY(event_id, i),
      FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
    );
  COMMIT;