PolyNOM/test_dump.sql at main · polypheny/PolyNOM · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
/*
@format_version: 1
@app_uuid: a8817239-9bae-4961-a619-1e9ef5575eff
@snapshot: {"version": "20250902T130116", "schemas": [{"entity_name": "change_log", "namespace_name": "polynom_internal", "data_model": "RELATIONAL", "fields": [{"name": "_entry_id", "db_name": "_entry_id", "type": "VarChar", "previous_name": null, "nullable": false, "unique": true, "default": null, "is_primary_key": true, "is_foreign_key": false}, {"name": "app_uuid", "db_name": "app_uuid", "type": "Text", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "modified_entry_id", "db_name": "modified_entry_id", "type": "Text", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "modified_entity_namespace", "db_name": "modified_entity_namespace", "type": "Text", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "modified_entity_name", "db_name": "modified_entity_name", "type": "Text", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "modified_by", "db_name": "modified_by", "type": "Text", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "date_of_change", "db_name": "date_of_change", "type": "Timestamp", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "changes", "db_name": "changes", "type": "Json", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}]}, {"entity_name": "User", "namespace_name": "polynom_entities", "data_model": "RELATIONAL", "fields": [{"name": "_entry_id", "db_name": "_entry_id", "type": "VarChar", "previous_name": null, "nullable": false, "unique": true, "default": null, "is_primary_key": true, "is_foreign_key": false}, {"name": "username", "db_name": "username", "type": "VarChar", "previous_name": "username2", "nullable": false, "unique": true, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "email", "db_name": "email", "type": "VarChar", "previous_name": null, "nullable": false, "unique": true, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "first_name", "db_name": "first_name", "type": "VarChar", "previous_name": null, "nullable": true, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "last_name", "db_name": "last_name", "type": "VarChar", "previous_name": null, "nullable": true, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "active", "db_name": "active", "type": "Boolean", "previous_name": null, "nullable": true, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "is_admin", "db_name": "is_admin", "type": "Boolean", "previous_name": null, "nullable": true, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}]}, {"entity_name": "snapshot", "namespace_name": "polynom_internal", "data_model": "RELATIONAL", "fields": [{"name": "_entry_id", "db_name": "_entry_id", "type": "VarChar", "previous_name": null, "nullable": false, "unique": true, "default": null, "is_primary_key": true, "is_foreign_key": false}, {"name": "snapshot", "db_name": "snapshot", "type": "Json", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}]}, {"entity_name": "Bike", "namespace_name": "polynom_entities", "data_model": "RELATIONAL", "fields": [{"name": "_entry_id", "db_name": "_entry_id", "type": "VarChar", "previous_name": null, "nullable": false, "unique": true, "default": null, "is_primary_key": true, "is_foreign_key": false}, {"name": "brand", "db_name": "brand", "type": "VarChar", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "model", "db_name": "model", "type": "VarChar", "previous_name": null, "nullable": false, "unique": false, "default": null, "is_primary_key": false, "is_foreign_key": false}, {"name": "owner_id", "db_name": "owner_id", "type": "VarChar", "previous_name": null, "nullable": false, "unique": null, "default": false, "is_primary_key": false, "is_foreign_key": true, "references_namespace": "polynom_entities", "references_entity": "User", "references_field": "_entry_id"}]}]}
*/
/*sql@None*/ CREATE RELATIONAL NAMESPACE IF NOT EXISTS "polynom_internal"
/*sql@polynom_internal*/ CREATE TABLE IF NOT EXISTS "polynom_internal"."change_log" ("_entry_id" VARCHAR(36) NOT NULL, "app_uuid" TEXT NOT NULL, "modified_entry_id" TEXT NOT NULL, "modified_entity_namespace" TEXT NOT NULL, "modified_entity_name" TEXT NOT NULL, "modified_by" TEXT NOT NULL, "date_of_change" TIMESTAMP(0) NOT NULL, "changes" TEXT NOT NULL, PRIMARY KEY (_entry_id), UNIQUE ("_entry_id"));
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('be4e5d02-556a-4d75-b593-ec12a9e30020', 'a8817239-9bae-4961-a619-1e9ef5575eff', '85e510a8-456c-4cda-85b3-e28e289e8e3e', 'polynom_entities', 'User', 'test', 2025-09-02 11:01:14+00:00, '{"username": [null, "testuser"], "email": [null, "u1@demo.ch"], "first_name": [null, "max"], "last_name": [null, "muster"], "active": [null, true], "is_admin": [null, false]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('b01c705b-4355-486f-a050-a40dd0a0b5a7', 'a8817239-9bae-4961-a619-1e9ef5575eff', '0ded1d18-021c-4950-8d66-705adc7ab81c', 'polynom_entities', 'User', 'test', 2025-09-02 11:01:15+00:00, '{"username": [null, "testuser2"], "email": [null, "u2@demo.ch"], "first_name": [null, "mira"], "last_name": [null, "muster"], "active": [null, false], "is_admin": [null, true]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('4134cc5e-ad41-4c22-9d5d-4aa7c019affe', 'a8817239-9bae-4961-a619-1e9ef5575eff', '39c3b556-4563-49dd-b02e-d67770dec2cc', 'polynom_entities', 'User', 'test', 2025-09-02 11:01:15+00:00, '{"username": [null, "testuser3"], "email": [null, "u3@demo.ch"], "first_name": [null, "miraculix"], "last_name": [null, "musterin"], "active": [null, false], "is_admin": [null, true]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('187562d8-a802-4053-a113-5b6a80a59c6e', 'a8817239-9bae-4961-a619-1e9ef5575eff', '51aca4be-c98b-4f30-a46f-a9f4e26dead0', 'polynom_entities', 'User', 'test', 2025-09-02 11:01:15+00:00, '{"username": [null, "testuser4"], "email": [null, "u4@demo.ch"], "first_name": [null, "maxine"], "last_name": [null, "meier"], "active": [null, true], "is_admin": [null, false]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('cdb54a8c-bed6-4e3a-a9f9-a23bd7997969', 'a8817239-9bae-4961-a619-1e9ef5575eff', '7fab1a2a-5101-4554-ad36-ada7c7dac8e8', 'polynom_entities', 'User', 'test', 2025-09-02 11:01:15+00:00, '{"username": [null, "testuser5"], "email": [null, "u5@demo.ch"], "first_name": [null, "mia"], "last_name": [null, "m\u00fcller"], "active": [null, false], "is_admin": [null, false]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('4ac3d749-ecc8-468c-87e1-528fbc2b99f8', 'a8817239-9bae-4961-a619-1e9ef5575eff', 'e2bb1175-bafb-4edf-8ff6-9d33a63bdab3', 'polynom_entities', 'Bike', 'test', 2025-09-02 11:01:15+00:00, '{"brand": [null, "Trek"], "model": [null, "Marlin 7"], "owner_id": [null, "85e510a8-456c-4cda-85b3-e28e289e8e3e"]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('0696e254-513e-4f8c-8102-1b2b24522040', 'a8817239-9bae-4961-a619-1e9ef5575eff', 'f6eacf31-f44e-4c0d-8dd4-fff9d9f5079c', 'polynom_entities', 'Bike', 'test', 2025-09-02 11:01:15+00:00, '{"brand": [null, "Specialized"], "model": [null, "Rockhopper"], "owner_id": [null, "85e510a8-456c-4cda-85b3-e28e289e8e3e"]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('56ef62c8-a167-4a07-8afe-78d4bf175d91', 'a8817239-9bae-4961-a619-1e9ef5575eff', 'be9b5f23-c20d-4693-8f53-df1f357ca23a', 'polynom_entities', 'Bike', 'test', 2025-09-02 11:01:15+00:00, '{"brand": [null, "Cannondale"], "model": [null, "Trail 8"], "owner_id": [null, "39c3b556-4563-49dd-b02e-d67770dec2cc"]}')
/*sql@polynom_internal*/ INSERT INTO "polynom_internal"."change_log" (_entry_id, app_uuid, modified_entry_id, modified_entity_namespace, modified_entity_name, modified_by, date_of_change, changes) VALUES ('b0d38c33-e472-43bd-88dc-5859e83ccec6', 'a8817239-9bae-4961-a619-1e9ef5575eff', 'df141b62-beef-4e58-8590-235f0649edc0', 'polynom_entities', 'Bike', 'test', 2025-09-02 11:01:15+00:00, '{"brand": [null, "Giant"], "model": [null, "Talon 3"], "owner_id": [null, "51aca4be-c98b-4f30-a46f-a9f4e26dead0"]}')
/*sql@None*/ CREATE RELATIONAL NAMESPACE IF NOT EXISTS "polynom_entities"
/*sql@polynom_entities*/ CREATE TABLE IF NOT EXISTS "polynom_entities"."User" ("_entry_id" VARCHAR(36) NOT NULL, "username" VARCHAR(80) NOT NULL, "email" VARCHAR(80) NOT NULL, "first_name" VARCHAR(30), "last_name" VARCHAR(30), "active" BOOLEAN, "is_admin" BOOLEAN, PRIMARY KEY (_entry_id), UNIQUE ("_entry_id"), UNIQUE ("username"), UNIQUE ("email"));
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."User" (_entry_id, username, email, first_name, last_name, active, is_admin) VALUES ('85e510a8-456c-4cda-85b3-e28e289e8e3e', 'testuser', 'u1@demo.ch', 'max', 'muster', TRUE, FALSE)
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."User" (_entry_id, username, email, first_name, last_name, active, is_admin) VALUES ('0ded1d18-021c-4950-8d66-705adc7ab81c', 'testuser2', 'u2@demo.ch', 'mira', 'muster', FALSE, TRUE)
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."User" (_entry_id, username, email, first_name, last_name, active, is_admin) VALUES ('39c3b556-4563-49dd-b02e-d67770dec2cc', 'testuser3', 'u3@demo.ch', 'miraculix', 'musterin', FALSE, TRUE)
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."User" (_entry_id, username, email, first_name, last_name, active, is_admin) VALUES ('51aca4be-c98b-4f30-a46f-a9f4e26dead0', 'testuser4', 'u4@demo.ch', 'maxine', 'meier', TRUE, FALSE)
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."User" (_entry_id, username, email, first_name, last_name, active, is_admin) VALUES ('7fab1a2a-5101-4554-ad36-ada7c7dac8e8', 'testuser5', 'u5@demo.ch', 'mia', 'müller', FALSE, FALSE)
/*sql@polynom_entities*/ CREATE TABLE IF NOT EXISTS "polynom_entities"."Bike" ("_entry_id" VARCHAR(36) NOT NULL, "brand" VARCHAR(50) NOT NULL, "model" VARCHAR(50) NOT NULL, "owner_id" VARCHAR(36) NOT NULL DEFAULT 'False', FOREIGN KEY ("owner_id") REFERENCES "polynom_entities"."User"("_entry_id"), PRIMARY KEY (_entry_id), UNIQUE ("_entry_id"));
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."Bike" (_entry_id, brand, model, owner_id) VALUES ('e2bb1175-bafb-4edf-8ff6-9d33a63bdab3', 'Trek', 'Marlin 7', '85e510a8-456c-4cda-85b3-e28e289e8e3e')
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."Bike" (_entry_id, brand, model, owner_id) VALUES ('f6eacf31-f44e-4c0d-8dd4-fff9d9f5079c', 'Specialized', 'Rockhopper', '85e510a8-456c-4cda-85b3-e28e289e8e3e')
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."Bike" (_entry_id, brand, model, owner_id) VALUES ('be9b5f23-c20d-4693-8f53-df1f357ca23a', 'Cannondale', 'Trail 8', '39c3b556-4563-49dd-b02e-d67770dec2cc')
/*sql@polynom_entities*/ INSERT INTO "polynom_entities"."Bike" (_entry_id, brand, model, owner_id) VALUES ('df141b62-beef-4e58-8590-235f0649edc0', 'Giant', 'Talon 3', '51aca4be-c98b-4f30-a46f-a9f4e26dead0')