2024-10-16 16:44:22,949 INFO [edoc-001] [DefaultDatabaseWriter] [edoc-001-dataloader-10312] About to create table using the following definition:
2024-10-16 16:44:22,955 INFO [edoc-001] [SqliteDatabasePlatform] [edoc-001-dataloader-10312] Running alter sql:
DROP TABLE IF EXISTS "people_";
CREATE TABLE "people_"(
"id" INTEGER NOT NULL,
"surname" VARCHAR,
"first_name" VARCHAR,
"second_name" VARCHAR,
"traits" VARCHAR,
"message" VARCHAR,
"photofile" VARCHAR,
"regime_id" INTEGER,
"spec_regime_id" INTEGER,
"has_bag" INTEGER DEFAULT (0) NOT NULL,
"has_bicycle" INTEGER DEFAULT (0) NOT NULL,
"has_car_id" VARCHAR,
"passport_series" VARCHAR,
"passport_number" VARCHAR,
"passport_scancopy" VARCHAR,
"birthdate" TIMESTAMP,
"1st_cat_pass" INTEGER DEFAULT (0) NOT NULL,
"instrument" VARCHAR,
"has_folder" INTEGER DEFAULT (0) NOT NULL,
"personal_data_consent" INTEGER DEFAULT (0) NOT NULL,
"knows_behavior_rules" INTEGER DEFAULT (0) NOT NULL
);
INSERT INTO "people_" ("id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules") SELECT "id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules" FROM "people";
DROP TABLE IF EXISTS "people";
CREATE TABLE "people"(
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"surname" VARCHAR,
"first_name" VARCHAR,
"second_name" VARCHAR,
"traits" VARCHAR,
"message" VARCHAR,
"photofile" VARCHAR,
"regime_id" INTEGER,
"spec_regime_id" INTEGER,
"has_bag" INTEGER DEFAULT (0) NOT NULL,
"has_bicycle" INTEGER DEFAULT (0) NOT NULL,
"has_car_id" VARCHAR,
"passport_series" VARCHAR,
"passport_number" VARCHAR,
"passport_scancopy" VARCHAR,
"birthdate" TIMESTAMP,
"1st_cat_pass" INTEGER DEFAULT (0) NOT NULL,
"instrument" VARCHAR,
"has_folder" INTEGER DEFAULT (0) NOT NULL,
"personal_data_consent" INTEGER DEFAULT (0) NOT NULL,
"knows_behavior_rules" INTEGER DEFAULT (0) NOT NULL
);
CREATE INDEX "IX_people_passport" ON "people" ("passport_series", "passport_number");
INSERT INTO "people" ("id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules") SELECT "id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules" FROM "people_";
DROP TABLE IF EXISTS "people_";
2024-10-16 16:44:23,314 INFO [edoc-001] [DefaultDatabaseWriter] [edoc-001-dataloader-10312] About to create table using the following definition:
2024-10-16 16:44:23,315 INFO [edoc-001] [SqliteDatabasePlatform] [edoc-001-dataloader-10312] Running alter sql:
DROP TABLE IF EXISTS "people_";
CREATE TABLE "people_"(
"id" INTEGER NOT NULL,
"surname" VARCHAR,
"first_name" VARCHAR,
"second_name" VARCHAR,
"traits" VARCHAR,
"message" VARCHAR,
"photofile" VARCHAR,
"regime_id" INTEGER,
"spec_regime_id" INTEGER,
"has_bag" INTEGER DEFAULT (0) NOT NULL,
"has_bicycle" INTEGER DEFAULT (0) NOT NULL,
"has_car_id" VARCHAR,
"passport_series" VARCHAR,
"passport_number" VARCHAR,
"passport_scancopy" VARCHAR,
"birthdate" TIMESTAMP,
"1st_cat_pass" INTEGER DEFAULT (0) NOT NULL,
"instrument" VARCHAR,
"has_folder" INTEGER DEFAULT (0) NOT NULL,
"personal_data_consent" INTEGER DEFAULT (0) NOT NULL,
"knows_behavior_rules" INTEGER DEFAULT (0) NOT NULL
);
INSERT INTO "people_" ("id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules") SELECT "id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules" FROM "people";
DROP TABLE IF EXISTS "people";
CREATE TABLE "people"(
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"surname" VARCHAR,
"first_name" VARCHAR,
"second_name" VARCHAR,
"traits" VARCHAR,
"message" VARCHAR,
"photofile" VARCHAR,
"regime_id" INTEGER,
"spec_regime_id" INTEGER,
"has_bag" INTEGER DEFAULT (0) NOT NULL,
"has_bicycle" INTEGER DEFAULT (0) NOT NULL,
"has_car_id" VARCHAR,
"passport_series" VARCHAR,
"passport_number" VARCHAR,
"passport_scancopy" VARCHAR,
"birthdate" TIMESTAMP,
"1st_cat_pass" INTEGER DEFAULT (0) NOT NULL,
"instrument" VARCHAR,
"has_folder" INTEGER DEFAULT (0) NOT NULL,
"personal_data_consent" INTEGER DEFAULT (0) NOT NULL,
"knows_behavior_rules" INTEGER DEFAULT (0) NOT NULL
);
CREATE INDEX "IX_people_passport" ON "people" ("passport_series", "passport_number");
INSERT INTO "people" ("id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules") SELECT "id","surname","first_name","second_name","traits","message","photofile","regime_id","spec_regime_id","has_bag","has_bicycle","has_car_id","passport_series","passport_number","passport_scancopy","birthdate","1st_cat_pass","instrument","has_folder","personal_data_consent","knows_behavior_rules" FROM "people_";
DROP TABLE IF EXISTS "people_";