Select Git revision
example.sqlite
Jakob Junck authored
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;