Return to sw_collector_tables.sql CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / strongswan / src / sw-collector

Annotation of embedaddon/strongswan/src/sw-collector/sw_collector_tables.sql, revision 1.1

1.1     ! misho       1: /* SQLit database for an Endpoint Collector */
        !             2: 
        !             3: DROP TABLE IF EXISTS "events";
        !             4: CREATE TABLE "events" (
        !             5:   "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
        !             6:   "epoch" INTEGER NOT NULL,
        !             7:   "timestamp" CHAR(20) NOT NULL
        !             8: );
        !             9: 
        !            10: DROP TABLE IF EXISTS "sw_identifiers";
        !            11: CREATE TABLE "sw_identifiers" (
        !            12:   "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
        !            13:   "name" VARCHAR(255) NOT NULL,
        !            14:   "package" VARCHAR(255) NOT NULL,
        !            15:   "version" VARCHAR(255) NOT NULL,
        !            16:   "source" INTEGER DEFAULT 0,
        !            17:   "installed" INTEGER DEFAULT 1,
        !            18:   "tag" TEXT
        !            19:   );
        !            20: DROP INDEX IF EXISTS "sw_identifiers_name";
        !            21: CREATE INDEX "sw_identifiers_name" ON "sw_identifiers" (
        !            22:   "name"
        !            23: );
        !            24: 
        !            25: DROP TABLE IF EXISTS "sw_events";
        !            26: CREATE TABLE "sw_events" (
        !            27:   "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
        !            28:   "eid" INTEGER REFERENCES "events" ("id"),
        !            29:   "sw_id" INTEGER NOT NULL REFERENCES "sw_identifiers" ("id"),
        !            30:   "action" INTEGER NOT NULL
        !            31: );