Skip to content
Snippets Groups Projects
Select Git revision
  • ddea8c871cbeb50653bfb6e9a712caa385a5835b
  • main default protected
  • simon
3 results

example.sqlite

  • example.sqlite 1.22 KiB
    PRAGMA foreign_keys=OFF;
    BEGIN TRANSACTION;
    CREATE TABLE IF NOT EXISTS "event" (
    "ocel_id" TEXT,
      "ocel_type" TEXT
    );
    INSERT INTO event VALUES('e1','Create Order');
    CREATE TABLE IF NOT EXISTS "event_object" (
    "ocel_event_id" TEXT,
      "ocel_object_id" TEXT,
      "ocel_qualifier" TEXT
    );
    INSERT INTO event_object VALUES('e1','o1','order');
    CREATE TABLE IF NOT EXISTS "object" (
    "ocel_id" TEXT,
      "ocel_type" TEXT
    );
    INSERT INTO object VALUES('o1','Order');
    CREATE TABLE IF NOT EXISTS "object_object" (
    "ocel_source_id" TEXT,
      "ocel_target_id" TEXT,
      "ocel_qualifier" TEXT
    );
    CREATE TABLE IF NOT EXISTS "event_CreateOrder" (
    "ocel_id" TEXT,
      "ocel_time" TEXT
    , "total items" INTEGER);
    INSERT INTO event_CreateOrder VALUES('e1','1970-01-01 00:00:00',1);
    CREATE TABLE IF NOT EXISTS "event_map_type" (
    "ocel_type" TEXT,
      "ocel_type_map" TEXT
    );
    INSERT INTO event_map_type VALUES('Create Order','CreateOrder');
    CREATE TABLE IF NOT EXISTS "object_map_type" (
    "ocel_type" TEXT,
      "ocel_type_map" TEXT
    );
    INSERT INTO object_map_type VALUES('Order','Order');
    CREATE TABLE IF NOT EXISTS "object_Order" (
     "ocel_id" TEXT,
     "ocel_time" TEXT,
     "ocel_changed_field" TEXT,
     "item" INTEGER
    );
    INSERT INTO object_Order VALUES('o1','1970-01-01 00:00:00',NULL,1);
    COMMIT;