SQLite format 3@ ,‰V,-â)'=‰űöńěçâÝŘÓÎÉÄżşľ°ŤŚĄœ—’ˆƒ~ytoje`[VQLGB=EATE TABLE "schema_version" ( "name" TEXT NOT NULL PRIMARY KEY, "version" INTEGER NOT *))‚tableschema_versionschema_versionCREATE TABLE "schema_version" ( "name" TEXT NOT NULL PRIMARY KEY, "version" INTEGER NOT NULL, "migration" INTEGER NOT NULL);O)indexsqlite_autoindex_schema_version_1schema_versionP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)(11ƒ)tableCPIImageToDownloadCPIImageToDownloadCREATE TABLxstrqoommljkgicgad_c]bYaW^U]R\MZIVFSAQ=M;J9I6H2G0D.C*B'?%="<:841/ , +*( ůů  üü    ÉXţçâÝŘÓÎÉÄżşľ°ŤŚĄœ—’ˆƒ~ytoje`[VQLGB=EATE TABLE "schema_version" *))‚tableschema_versionschema_versionCREATE TABLE "schema_version" ( "name" TEXT NOT NULL PRIMARY KEY, "version" INTEGER NOT NULL, "migration" INTEGER NOT NULL);O)indexsqlite_autoindex_schema_version_1schema_versionP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)(11ƒ)tableCPIImageToDownloadCPIImageToDownloadCREATE TABLE "CPIImageToDownload" ( "dbID" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ownerObjectwrntyID" BIGINT NULL DEFAULT 0, "imageType" INTEGER NOT NULL, "modificationDate" INT_DATETIME NULL) „„ś€XZŒçâÝŘÓÎÉÄżş*))‚tableschema_versionschema_versionCREATE TABLE "schema_version" ‚/*))‚tableschema_versionschema_versionCREATE TABLE "schema_version" ( "name" TEXT NOT NULL PRIMARY KEY, "version" INTEGER NOT NULL*))‚tableschema_versionschema_versionCREATE TABLE "schema_version" ( "name" TEXT NOT NULL P‚/)//„ tableCPIFileToDownloadCPIFileToDownloadCREATE TABLE "CPIFileToDownload" ( "dbID" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "wrntyID" BIGINT NULL DEFAULT 0, "ownerObjectwrntyID" BIGINT NULL DEFAULT 0, "url" TEXT NULL, "localFilePath" TEXT NULL, "modificationDate" INT_DATETIME NULL)‚G*##„UtableCPIEmployeeCPIEmployee CREATE TABLE "CPIEmployee" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "firstName" TEXT NULL, "lastName" TEXT NULL, "role" TEXT NULL, "cellular" TEXT NULL, "email" TEXT NULL, "externalID" TEXT NULL, "homePhone" TEXT NULL) ZZ$‚G##„UtableCPIEmployeeCPIEmployeeCREATE TABLE "CPIEmployee" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "firstName" TEXT NULL, "lastName" TEXT NULL, "role" TEXT NULL, "cellular" TEXT NULL, "email" TEXT NULL, "externalID" TEXT NULL, "homePhone" TEXT NULL)ŽAA‰!tableCPITypeSafeAttributeConfigCPITypeSafeAttributeConfig CREATE TABLE "CPITypeSafeAttributeConfig" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" J##„UtableCPIEmploy2//„ tableCPIFileToDownloadCPIFileToDownloadCREATE TABLE "CPIFileToDownload" ( "dbID" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "wrntyID" BIGINT NULL DEFAULT 0, "ownerObjectwrntyID" BIGINT NULL DEFAULT 0, "url" TEXT NULL, "localFilePath" TEXT NULL, "modificationDate" INT_DATETIME NULL)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)  rrn… +AA‰!tableCPITypeSafeAttributeConfigCPITypeSafeAttributeConfig CREATE TABLE "CPITypeSafeAttributeConfig" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "typeSafeAttrConfigDataType" INTEGER NOT NULL, "typeSafeAttrConfigData" BLOB NULL, "typeSafeAttrUIControlType" INTEGER NOT NULL, "ownerObjectTypeID" INTEGER NOT NULL, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED) ZZN##œMtableCPIActivityCPIActivity CREATE TABLE "CPIActivity" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "‡#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ˛˛ŽŽC,##œMtableCPIActivityCPIActivity CREATE TABLE "CPIActivity" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "} ZZZZ "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer"Ć''˘[tableCPIAssignmentCPIAssignment CREATE TABLE "CPIAssignment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INT~é--ƒotableCPIChangedObjectCPIChangedObjectCREATE TABLE "CPIChangedObject" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "objType" INTEGER NULL, "objDBID" INTEGER NOT NULL, "errorMsg" TEXT NULL, "syncStatus" INTEGER NULL)Č‚]tableCPIBrandCPIBrandCREATE TABLE "CPIBrand" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "imageURL" TEXT NULL, "name" TEXT NULL)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ::86rity" INTEGER NULL, "lastAssignerFullName" TEXT NULL, "creator" INTEGER NULL, "creatorWRNTYId" BIGINT NULL DEFAULT 0, "notes" TEXT NULL, "assignmentNotes" BLOB NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED‘N-''˘[tableCPIAssignmentCPIAssignmentCREATE TABLE "CPIAssignment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INT~‚.--ƒotableCPIChangedObjectCPIChangedObjectCREATE TABLE "CPIChangedObject" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "objType" INTEGER NULL, "objDBID" INTEGER NOT NULL, "errorMsg" TEXT NULL, "syncStatus" INTEGER NULL)E/‚]tableCPIBrandCPIBrandCREATE TABLE "CPIBrand" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "imageURL" TEXT NULL, "name" TEXT NULL) #86rity" INTEGER NULL, "lastAssignerFullName" TEXT NULL, "creator" INTEGER NULL, "creatorWRNTYId" BIGINT NULL DEFAULT 0, "notes" TEXT NULL, "assignmentNotes" BLOB NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED‘N ''˘[tableCPIAssignmentCPIAssignment CREATE TABLE "CPIAssignment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTé--ƒotableCPIChangedObjectCPIChangedObjectCREATE TABLE "CPIChangedObject" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "objType" INTEGER NULL, "objDBID" INTEGER NOT NULL, "errorMsg" TEXT NULL, "syncÝ''˘[tableCPIAssignmentCPIAssignment CREATE TABLE "CPIAssignment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INT #86‘N ''˘[tableCPIAssignmentCPIAssignmentCREATE TABLE "CPIAssignment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTé--ƒotableCPIChangedObjectCPIChangedObjectCREATE TABLE "CPIChangedObject" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "objType" INTEGER NULL, "objDBID" INTEGER NOT NULL, "errorMsg" TEXT NULL, "syncÝ''˘[tableCPIAssignmentCPIAssignmentCREATE TABLE "CPIAssignment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INT ZZZÝ##†!tableCPICampaignCPICampaignCREATE TABLE "CPICampaign" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "promotionalURL" TEXT NULL, "hasImage" BOOLEAN NULL, "ignoreEffectiveDates" BOOLEAN NULL, "type" INTEGER NULL, "data" TEXT NULL, "effectiveFromDate" DATE NULL, "effectiveToDate" DATE NULL)-!!„tableCPIPIColorCPIPIColorCREATE TABLE "CPIPIColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ##Óƒ-0##†!tableCPICampaignCPICampaignCREATE TABLE "CPICampaign" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "promotionalURL" TEXT NULL, "hasImage" BOOLEAN NULL, "ignoreEffectiveDates" BOOLEAN NULL, "type" INTEGER NULL, "data" TEXT NULL, "effectiveFromDate" DATE NULL, "effectiveToDate" DATE NULL)‚*1!!„tableCPIPIColorCPIPIColorCREATE TABLE "CPIPIColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL) #ÓÝ##†!tableCPICampaignCPICampaignCREATE TABLE "CPICampaign" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "promotionalURL" TEXT NULL, "hasImage" BOOLEAN NULL, "ignoreEffectiveDates" BOOLEAN NULL, "type" INTEGER NULL, "data" TEXT NULL, "effectiveFromDate" DATE NULL, "effectiveToDate" DATE NULL)-!!„tableCPIPIColorCPIPIColorCREATE TABLE "CPIPIColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL) ZZZ‚'„tableCPIPISizeCPIPISizeCREATE TABLE "CPIPISize" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL Pł„tableCPIPISizeCPIPISizeCREATE TABLE "CPIPISize" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL)‰!!…WtableCPIBoxItemCPIBoxItemCREATE TABLE "CPIBoxItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "unitQuantity" REAL NULL, "remark" TEXT NULL, "size" INTEGER NULL, "sizeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "size_fk" FOREIGN KEY ("size") REFERENCES "CPIPISize" ("dbID") DEFERRABLE INITIALLY DEFERRED)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) =Ƃ'2„tableCPIPISizeCPIPISizeCREATE TABLE "CPIPISize" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL)ƒ3!!…WtableCPIBoxItemCPIBoxItemCREATE TABLE "CPIBoxItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "unitQuantity" REAL NULL, "remark" TEXT NULL, "size" INTEGER NULL, "sizeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "size_fk" FOREIGN KEY ("size") REFERENCES "CPIPISize" ("dbID") DEFERRABLE INITIALLY DEFERRED)‚74„ItableCPIBoxCPIBoxCREATE TABLE "CPIBox" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "externalID" TEXT NULL, "dimension2ScaleID" INTEGER NULL, "itemCount" INTEGER NULL, "quantitiesTotal" INTEGER NULL) Ö=Ƃ'„tableCPIPISizeCPIPISizeCREATE TABLE "CPIPISize" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL)Ă!!…WtableCPIBoxItemCPIBoxItemCREATE TABLE "CPIBoxItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "unitQuantity" REAL NULL, "remark" TEXT NULL, "size" INTEGER NULL, "sizeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "size_fk" FOREIGN KEY ("size") REFERENCES "CPIPISize" ("dbID") DEFERRABLE INITIALLY DEFERRED):„ItableC*„tableCPIPISizeCPIPISizeCREATE TABLE "CPIPISize" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL) Ö=Ƃ'„tableCPIPISizeCPIPISizeCREATE TABLE "CPIPISize" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL)Ă!!…WtableCPIBoxItemCPIBoxItemCREATE TABLE "CPIBoxItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "unitQuantity" REAL NULL, "remark" TEXT NULL, "size" INTEGER NULL, "sizeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "size_fk" FOREIGN KEY ("size") REFERENCES "CPIPISize" ("dbID") DEFERRABLE INITIALLY DEFERRED):„ItableC*„tableCPIPISizeCPIPISizeCREATE TABLE "CPIPISize" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "code" TEXT NULL, "desc" TEXT NULL, "imageURL" TEXT NULL, "group" TEXT NULL, "groupID" INTEGER NULL, "sortIndex" INTEGER NULL) ZZZZU 55ctablebox_boxItem_relationbox_boxItem_re‚o++…tableCPIBox_boxItemsCPIBox_boxItemsCREATE TABLE "CPIBox_boxItems" ( "object_id" INTEGEˇr++…tableCPIBox_boxItemsCPIBox_boxItemsCREATE TABLE "CPIBox_boxItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIBox" ("Ă„ItableCPIBoxCPIBoxCREATE TABLE "CPIBox" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "externalID" TEXT NULL, "dimension2ScaleID" INTEGER NULL, "itemCount" INTEGER NULL, "quantitiesTotal" INTEGER NULL)‰C++indexCPIBox_boxItems_object_id_iCPIBox_boxItemsCREATE INDEX "CPIBox_boxItems_object_id_i" ON "CPIBox_boxItems" ("object_id")#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) YYËT÷U 755ctablebox_boxItem_relationbox_boxItem_re‚o5++…tableCPIBox_boxItemsCPIBox_boxItemsCREATE TABLE "CPIBox_boxItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIBox" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBoxItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)6C++indexCPIBox_boxItems_object_id_iCPIBox_boxItemsCREATE INDEX "CPIBox_boxItems_object_id_i" ON "CPIBox_boxItems" ("object_id") 755ctablebox_boxItem_relationbox_boxItem_relationCREATE TABLE "box_boxItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)‚855ƒ/tableCPIUnitOfMeasureItemCPIUnitOfMeasureItemCREATE TABLE "CPIUnitOfMeasureItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT NULL, "quantity" INTEGER NULL) =wT÷U 55ctablebox_boxItem_relationbox_boxItem_reTr++…tableCPIBox_boxItemsCPIBox_boxItemsCREATE TABLE "CPIBox_boxItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIBox" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBoxItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)C++indexCPIBox_boxItems_object_id_iCPIBox_boxItemsCREATE INDEX "CPIBox_boxItems_object_id_i" ON "CPIBox_‚7„ItableCPIBoxCPIBoxCREATE TABLE "CPIBox" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "externalID" TEXT NULL, "dimension2ScaleID" INTEGER NULL, "itemCount" INTEGER NULL, "quantitiesTotal" INTEGER NULL)‰C++indexCPIBox_boxItems_object_id_iCPIBox_boxItemsCREATE INDEX "CPIBox_boxItems_object_id_i" ON "CPIBox_boxItems" ("object_id") =wT÷U 55ctablebox_boxItem_relationbox_boxItem_reTr++…tableCPIBox_boxItemsCPIBox_boxItemsCREATE TABLE "CPIBox_boxItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIBox" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBoxItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)C++indexCPIBox_boxItems_object_id_iCPIBox_boxItemsCREATE INDEX "CPIBox_boxItems_object_id_i" ON "CPIBox_‚7„ItableCPIBoxCPIBoxCREATE TABLE "CPIBox" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "externalID" TEXT NULL, "dimension2ScaleID" INTEGER NULL, "itemCount" INTEGER NULL, "quantitiesTotal" INTEGER NULL)‰C++indexCPIBox_boxItems_object_id_iCPIBox_boxItemsCREATE INDEX "CPIBox_boxItems_object_id_i" ON "CPIBox_boxItems" ("object_id")  ZZƒc--†ytableCPIUnitOfMeasureCPIUnitOfMeasureCREATE TABLE "CPIUnitOfMeasure" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT NULL, "baseUnitOfMeasureItem" INTEGER NULL, "baseUnitOfMeasć--†ytableCPIUnitOfMeasureCPIUnitOfMeasureCREATE TABLE "CPIUnitOfMeasure" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT  55ƒ/tableCPIUnitOfMeasureItemCPIUnitOfMeasureItemCREATE TABLE "CPIUnitOfMeasureItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT NULL, "quantity" INTEGER NULL)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) XX>ƒc9--†ytableCPIUnitOfMeasureCPIUnitOfMeasureCREATE TABLE "CPIUnitOfMeasure" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT NULL, "baseUnitOfMeasureItem" INTEGER NULL, "baseUnitOfMeasureItemWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "baseUnitOfMeasureItem_fk" FOREIGN KEY ("baseUnitOfMeasureItem") REFERENCES "CPIUnitOfMeasureItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)ƒ?:SS…etableCPIUnitOfMeasure_unitOfMeasureItemsCPIUnitOfMeasure_unitOfMeasureItems CREATE TABLE "CPIUnitOfMeasure_unitOfMeasureItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIUnitOfMeasure" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIUnitOfMeasureItem" ("dbID") DEFERRABLE INITIALLY DEFERRED) >ƒc--†ytableCPIUnitOfMeasureCPIUnitOfMeasureCREATE TABLE "CPIUnitOfMeasure" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT NULL, "baseUnitOfMeasureItem" INTEGER NULL, "baseUnitOfMeasureItemWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "baseUnitOfMeasureItem_fk" FOREIGN KEY ("baseUnitOfMeasureItem") REFERENCES "CPIUnitOfMeasureItem" ("dbID"ć--†ytableCPIUnitOfMeasureCPIUnitOfMeasureCREATE TABLE "CPIUnitOfMeasure" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT NULL, "baseUnitOfMeasureItem" INTEGER NULL, "baseUnitOfMeasureItemWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "baseUnitOfMeasureItem_fk" FOREIGN KEY ("baseUnitOfMeasureItem") REFERENCES "CPIUnitOfMeasureItem" ("dbID") DEFERRABLE INITIALLY DEFERRED) ZZZƒc--†ytableCPIUnitOfMeasureCPIUnitOfMeasure CREATE TABLE "CPIUnitOfMeasure" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "externalID" TEXT NULL, "baseUnitOfMeasureItem" INTEGER NULL, "baseUnitOfMeasureItemWRNTYId" BIGINT NULL DEFAULÄkS{indexCPIUnitOfMeasure_unitOfMeasureItems_object_id_iCPIUnitOfMeasure_unitOfMeasureItems CREATE INDEX "CPIUnitOfMeasure_unitOfMeasureItems_object_id_i" ON "CPIUnitOfMeasure_unitOfMeasureItems" ("object_id")ëee‚tableunitOfMeasureItem_UnitOfMeasureItem_relationunitOfMeasureItem_UnitOfMeasureItem_relation"CREATE TABLE "unitOfMeasureItem_UnitOfMeasureItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) <<8V;kS{indexCPIUnitOfMeasure_unitOfMeasureItems_object_id_iCPIUnitOfMeasure_unitOfMeasureItems!CREATE INDEX "CPIUnitOfMeasure_unitOfMeasureItems_object_id_i" ON "CPIUnitOfMeasure_unitOfMeasureItems" ("object_id")h<ee‚tableunitOfMeasureItem_UnitOfMeasureItem_relationunitOfMeasureItem_UnitOfMeasureItem_relation#CREATE TABLE "unitOfMeasureItem_UnitOfMeasureItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) '8VkS{indexCPIUnitOfMeasure_unitOfMeasureItems_object_id_iCPIUnitOfMeasure_unitOfMeasureItems"CREATE INDEX "CPIUnitOfMeasure_unitOfMeasureItems_object_id_i" ON "CPIUnitOfMeasure_unitOfMeasureItems" ("object_id")ëee‚tableuniŮkS{indexCPIUnitOfMeasure_unitOfMeasureItems_object_id_iCPIUnitOfMeasure_unitOfMeasureItems"CREATE INDEX "CPIUnitOfMeasure_unitOfMeasureItems_object_id_i" ON "CPIUnitOfMeasure_unitOfMeasureItems" ("object_id") ZZULT 0, "unitOfMeasure" INTEGER NULL, "unitOfMeasureWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "brand_fk" FOREIGN KEY ("brand") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFER„--ŠtableCPIPortfolioItemCPIPortfolioItem#CREATE TABLE "CPIPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "remark" TEXT NULL, "distributorItemCode" TEXT NULL, "brandItemCode" TEXT NULL, "exID" TEXT NULL, "imageURL" TEXT NULL, "hasImage" BOOLEAN NULL, "inventory" REAL NULL, "price" REAL NULL, "portfolioDiscount" REAL NULL, "wholeSaleDiscount" REAL NULL, "type" TEXT NULL, "subType" TEXT NULL, "group" TEXT NULL, "family" TEXT NULL, "gender" TEXT NULL, "upc" TEXT NULL, "wholeSalePrice" REAL NULL, "priceListWholeSalePrice" REAL #'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ||x"priceListWholeSaleCurrencySymbol" TEXT NULL, "classForItem" TEXT NULL, "subClass" TEXT NULL, "collection" TEXT NULL, "setForItem" TEXT NULL, "instructionsURL" TEXT NULL, "longDescription" TEXT NULL, "tsAttributes" BLOB NULL, "creationDate" INT_DATETIME NULL, "futureInventoryDate" INT_DATETIME NULL, "futureInventoryQuantity" REAL NULL, "has”u=--ŠtableCPIPortfolioItemCPIPortfolioItem$CREATE TABLE "CPIPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "remark" TEXT NULL, "distributorItemCode" TEXT NULL, "brandItemCode" TEXT NULL, "exID" TEXT NULL, "imageURL" TEXT NULL, "hasImage" BOOLEAN NULL, "inventory" REAL NULL, "price" REAL NULL, "portfolioDiscount" REAL NULL, "wholeSaleDiscount" REAL NULL, "type" TEXT NULL, "subType" TEXT NULL, "group" TEXT NULL, "family" TEXT NULL, "gender" TEXT NULL, "upc" TEXT NULL, "wholeSalePrice" REAL NULL, "priceListWholeSalePrice" REAL  ZZZriceListWholeSaleCurrÝ??†#tableCPIPriceListPortfolioItemCPIPriceListPor??†#tableCPIPriceListPortfolioItemCPIPriceListPortfolioItem%CREATE TABLE "CPIPriceListPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "wholeSalePrice" REAL NULL, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)3%%„#tableCPIPriceListCPIPriceList'CREATE TABLE "CPIPriceList" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "desc" TEXT NULL, "currencySymbol" TEXT NULL, "externalID" TEXT NULL, "isConnectedToAgent" BOOLEAN NULL, "subType" INTEGER NULL)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ÍüT 0, "unitOfMeasureÝ??†#tableCPIPriceListPortfolioItemCPIPriceListPortfolioItem&CREATE TABLE "CPIPriceListPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "wholeSƒJ>??†#tableCPIPriceListPortfolioItemCPIPriceListPortfolioItem&CREATE TABLE "CPIPriceListPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "wholeSalePrice" REAL NULL, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)‚0?%%„#tableCPIPriceListCPIPriceList(CREATE TABLE "CPIPriceList" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "desc" TEXT NULL, "currencySymbol" TEXT NULL, "externalID" TEXT NULL, "isConnectedToAgent" BOOLEAN NULL, "subType" INTEGER NULL) #đ#T 0, "unitOfMeasureÝ??†#tableCPIPriceListPortfolioItemCPIPriceListPortfolioItem'CREATE TABLE "CPIPriceListPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "wholeSalePrice" REAL NULL, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)%%„#tableCPIPriceListCPIPriceList)CREATE TABLE "CPIPriceList" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "desc" TEXT NULL, "currencySymbol" TEXT NULL, "externalID" TEXT NULL, "isConnectedToAgent" BOOLEAN NULL, "subType" INTEGER NULL)ÝmUindexCPIPriceList_priceListPortfolioItems_object_id_iCPIPriceList_priceListPortfolioItems,CREATE INDEX "CPIPriceList_priceListPortfolioItems_object_id_i" ON "CPIPriceList_priceListPortfolioItems" ("object_id") ZZZwƒCUU…itableCPIPriceList_priceListPortfolioItemsCPIPriceLĆUU…itableCPIPriceList_priceListPortfolioItemsCPIPriceList_priceListPortfolioItems(CREATE TABLE "CPIPriceList_priceListPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIPriceList" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIPriceListPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)ÝmUindexCPIPriceList_priceListPortfolioItems_object_id_iCPIPriceList_priceListPortfolioItems*CREATE INDEX "CPIPriceList_priceListPortfolioItems_object_id_i" ON "CPIPriceList_priceListPortfolioItems" ("object_id")#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) {{AwÝ??†#tableCPIPriceListPortfolioItemCPIPriceListPortfolioItem)CREATE TABLE "CPIPƒC@UU…itableCPIPriceList_priceListPortfolioItemsCPIPriceList_priceListPortfolioItems)CREATE TABLE "CPIPriceList_priceListPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIPriceList" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIPriceListPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)ZAmUindexCPIPriceList_priceListPortfolioItems_object_id_iCPIPriceList_priceListPortfolioItems+CREATE INDEX "CPIPriceList_priceListPortfolioItems_object_id_i" ON "CPIPriceList_priceListPortfolioItems" ("object_id")_B__‚ tablepriceList_priceListPortFolioItem_relationpriceList_priceListPortFolioItem_relation,CREATE TABLE "priceList_priceListPortFolioItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) AAwÝ??†#tableCPIPriceListPortfolioItemCPIPriceListPortfolioItem*CREATE TABLE "CPIPĆUU…itableCPIPriceList_priceListPortfolioItemsCPIPriceList_priceListPortfolioItems*CREATE TABLE "CPIPriceList_priceListPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIPriceList" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIPriceListPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)ZmUindexCPIPriceList_priceListPortfolioItems_object_id_iCPIPriceList_priceListPortfolioItems,CREATE INDEX "CPIPriceList_priceListPortfolioItems_object_id_i" ON "CPIPriceList_priceListPortfolioItems" ("object_id")â__‚ tablepriceList_priceListPortFolioItem_relationpriceList_priceListPortFolioItem_relation-CREATE TABLE "priceList_priceListPortFolioItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)  ZZwĆUU…itableCPIPriceList_priceListPortfolioItemsCPIPriceList_priceListPortfol--‰KtableCPIContactPersonCPIContactPerson,CREATE TABLE "CPIContactPerson" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "externalID" TEXT NULL, "firstName" TEXT NULL, "middleName" TEXT NULL, "lastName" TEXT NULL, "birthDate" DATE NULL, "gender" TEXT NULL, "homePhone" TEXT NULL, "workPhone" TEXT NULL, "cellular" TEXT â__‚ tablepriceList_priceListPortFolioItem_relationpriceList_priceListPortFolioItem_relation+CREATE TABLE "priceList_priceListPortFolioItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) qqmwĆUU…itableCPIPriceList_priceListPortfolioItemsCPIPriceList_priceListPortfolioItems-CREATE TABLE "CPIPriceList_priceListPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY … C--‰KtableCPIContactPersonCPIContactPerson-CREATE TABLE "CPIContactPerson" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "externalID" TEXT NULL, "firstName" TEXT NULL, "middleName" TEXT NULL, "lastName" TEXT NULL, "birthDate" DATE NULL, "gender" TEXT NULL, "homePhone" TEXT NULL, "workPhone" TEXT NULL, "cellular" TEXT NULL, "fax" TEXT NULL, "email1" TEXT NULL, "email2" TEXT NULL, "email3" TEXT NULL, "role" TEXT NULL, "comments" TEXT NULL, "imageURL" TEXT NULL, "hasImage" BOOLEAN NULL, "parentWRNTYId" BIGINT NULL DEFAULT 0) ĽĄL, "oldestDebtDate" INT_DATETIME NULL, "latitude" REAL NULL, "longitude" REAL NULL, "orderDiscount" REAL NULL, "prop1" TEXT NULL, "prop2"[œstableCPIStoreCPIStore.CREATE TABLE "CPIStore" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "wrntyOrgRelID" BIGINT NULL DEFAULT 0, "phone" TEXT NULL, "mobile" TEXT NULL, "fax" TEXT NULL, "erpCode" TEXT NULL, "address" TEXT NULL, "name" TEXT NULL, "email" TEXT NULL, "city" TEXT NULL, "country" TEXT NULL, "countryISOAlpha2Code" TEXT NULL, "state" TEXT NULL, "stateISOAlpha2Code" TEXT NULL, "zipCode" TEXT NULL, "remark" TEXT NULL, "contactPersonFullName" TEXT NULL, "debt30" REAL NULL, "debt60" REAL NULL, "debt90" REAL NULL, "debtAbove90" REAL NULL, "debtTotal" REAL NULL, "maxDebt" REAL NULL, "currentDebt" REAL NULL, "maxDebtDays" INTEGER NOT NULL, "lastVisit" INT_DATETIME NULL, "creationDate" INT_DATE ĽĽĄŽPDœstableCPIStoreCPIStore/CREATE TABLE "CPIStore" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "wrntyOrgRelID" BIGINT NULL DEFAULT 0, "phone" TEXT NULL, "mobile" TEXT NULL, "fax" TEXT NULL, "erpCode" TEXT NULL, "address" TEXT NULL, "name" TEXT NULL, "email" TEXT NULL, "city" TEXT NULL, "country" TEXT NULL, "countryISOAlpha2Code" TEXT NULL, "state" TEXT NULL, "stateISOAlpha2Code" TEXT NULL, "zipCode" TEXT NULL, "remark" TEXT NULL, "contactPersonFullName" TEXT NULL, "debt30" REAL NULL, "debt60" REAL NULL, "debt90" REAL NULL, "debtAbove90" REAL NULL, "debtTotal" REAL NULL, "maxDebt" REAL NULL, "currentDebt" REAL NULL, "maxDebtDays" INTEGER NOT NULL, "lastVisit" INT_DATETIME NULL, "creationDate" INT_DATE{ ZZZZ "oldestDebtDate" INT_DATETIME NULL, "latitude" REAL NULL, "longitude" REAL Nœ’;;…5tableCPIStore_contactPersonsCPIStore_contactPersons0CREATE TABLE "CPIStore_contactPersons" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStore" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED)gS;KindexCPIStore_contactPersons_object_id_iCPIStore_contactPersons2CREATE INDEX "CPIStore_contactPersons_object_id_i" ON "CPIStore_contactPersons" ("object_id")žGGutablestore_contactPersons_relationstore_contactPersons_relation3CREATE TABLE "store_contactPersons_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ™B[œstableCPIStoreCPIStore0CREATE TABLE "CPIStore" ( "wrntyID" BIGINT NULL DEFAULT 0, ƒE;;…5tableCPIStore_contactPersonsCPIStore_contactPersons1CREATE TABLE "CPIStore_contactPersons" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStore" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED)&FS;KindexCPIStore_contactPersons_object_id_iCPIStore_contactPersons3CREATE INDEX "CPIStore_contactPersons_object_id_i" ON "CPIStore_contactPersons" ("object_id");GGGutablestore_contactPersons_relationstore_contactPersons_relation4CREATE TABLE "store_contactPersons_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)  NULL, "oldestDebtDate" INT_DATETIME NULL, "latitude" REAL NULL, "longitude" REAL NULL, "orderDiscount" REAL NULL, "prop1" TEXT NULL, "prop2" TEXT NULL, "prop3" TEXT NULL, "prop4" TEXT NULL, "prop5" TEXT NULL, "govIssuedID" TEXT NULL, "tsAttributes" BLOB NULL, "locationSet" BOOLEAN NULL, "dashboardCustomData" TEXT NULL, "workPhone" TEXT NULL, "parentStore" INTEGER NULL, "parentStoreWRNTYId" BIGINT NULL DEFAULT 0, "priceList" INTEGER NULL, "priceListWRNTYId" BIGINT NULL DEFAULT 0, "specialPriceList" INTEGER NULL, "specialPriceListWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "parentStore_fk" FOREIGN KEY ("parentStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "priceList_fk" FOREIGN KEY ("priceList") REFERENCES "CPIPriceList" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "specialPriceList_fk" FOREIGN KEY ("specialPriceList") REFERENCES "CPIPriceList" ("dbID") DEFERRABLE INITIALLY DEFERRED) W™B "oldestDebtDate" INT_DATETIME NULL, "latitude" REAL NULL, "longitude" REAL NULL, "orderDiscount" REAL NULL, "prop1" TEXT NULL, "prop2"[œstableCPIStoreCPIStore2CREATE TABLE "CPIStore" ( "wrntyID" BIGINT NULL DEFAULT 0, B’;;…5tableCPIStore_contactPersonsCPIStore_contactPersons3CREATE TABLE "CPIStore_contactPersons" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStore" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED)&#S;KindexCPIStore_contactPersons_object_id_iCPIStore_contactPersons5CREATE INDEX "CPIStore_contactPersons_object_id_i" ON "CPIStore_contactPersons" ("object_id")žGGutablestore_ŠS;KindexCPIStore_contactPersons_object_id_iCPIStore_contactPersons5CREATE INDEX "CPIStore_contactPersons_object_id_i" ON "CPIStore_contactPersons" ("object_id") ZZ[œstableCPIStĄ//‰ktableCPIStorePortfolioCPIStorePortfolio4CREATE TABLE "CPIStorePortfolio" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "discountPercentage" REAL NULL, "targetStock" REAL NULL, "targetRevenue" REAL NULL, "allowExtWrnty" BOOLEAN NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "brand" INTEGER NULL, "brandWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "brand_fk" FOREIGN KEY ("brand") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED)#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) __[BB’;;…5tableCPIStore_contactPersonsCPIStore_contactPersons5CREATE TABLE "CPIStore…H//‰ktableCPIStorePortfolioCPIStorePortfolio5CREATE TABLE "CPIStorePortfolio" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "discountPercentage" REAL NULL, "targetStock" REAL NULL, "targetRevenue" REAL NULL, "allowExtWrnty" BOOLEAN NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "brand" INTEGER NULL, "brandWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "brand_fk" FOREIGN KEY ("brand") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED) ZZórmula" TEXT NULL, "orderDiscountCalculationFormula" TEXT NULL, "distributorFax" TEXT NULL, "distributorID" BIGINT NULL DEFAULT 0, "distributorName" TEXT NULL, "distributorPhone" TEXT NULL, "distributorCity" TEXT NULL, "distributorCountryISOAlpha2Code" TEXT NULL, "distributorStateISOAlpha2Code" TEXT NULL, "distributorStreet" TEXT NULL, "distributorCurrencySymbol" TEXT NULL, "distributorZipCode" TEXT NULL, "accountStatus" INTEGER NULL, "accountType" INTEGERc•tableCPIAgentCPIAgent6CREATE TABLE "CPIAgent" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "email" TEXT NULL, "name" TEXT NULL, "password" TEXT NULL, "databaseVersion" REAL NULL, "lastSyncDateTime" BIGINT NULL DEFAULT 0, "uiControlCustomization" BLOB NULL, "orderPriceCalƒ#'77etableagent_brands_relationagent_brands_relation8CREATE TABLE "agent_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ĄĄ//‰ktableCPIStorePortfolioCPIStorePortfolio7CREATE TABLE "CPIStorePortfolio" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "discountPercentage" REAL NULL, "targetStock" REAL NULL, "targetRevenue" REAL NULL, "allowExtWrnty" BOOLEAN NULL, "store" IN_”{tableCPIAgentCPIAgent6CREATE TABLE "CPIAgent" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "email" TEXT NULL, "name" TEXT NULL, "password" TEXT NULL, "databaseVersion" REAL NULL, "lastSyncDateTime" INT_DATETIME NULL, "uiControlCustomization" BLOB NULL, "orderPriceCal7 ™ "storeSalesUseSalesPeriod" BOOLEAN NULL, "storeSalesPeriodQuantity" INTEGER NULL, "storeSalesPeriod" TEXT NULL, "storeSalesLocation" TEXcšetableCPIFilterCPIFilter8CREATE TABLE "CPIFilter" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "useAttributesFilter" BOOLEAN NULL, "attributeGender" BLOB NULL, "attributeGroup" BLOB NULL, "attributeType" BLOB NULL, "attributeSubtype" BLOB NULL, "attributeFamily" BLOB NULL, "attributeClass" BLOB NULL, "attributeSubclass" BLOB NULL, "attributeCollection" BLOB NULL, "attributeSet" BLOB NULL, "attriz•1tableCPIAŠXI•tableCPIAgentCPIAgent7CREATE TABLE "CPIAgent" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "email" TEXT NULL, "name" TEXT NULL, "password" TEXT NULL, "databaseVersion" REAL NULL, "lastSyncDateTime" BIGINT NULL DEFAULT 0, "uiControlCustomization" BLOB NULL, "orderPriceCalz s "storeSalesUseSalesPeriod" BOOLEAN NULL, "storeSalesPeriodQuantity" INTEGER NULL, "storeSalesPeriod" TEXT NULL, "storeSalesLocation" TEXcšetableCPIFilterCPIFilter9CREATE TABLE "CPIFilter" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "useAttributesFilter" BOOLEAN NULL, "attributeGender" BLOB NULL, "attributeGroup" BLOB NULL, "attributeType" BLOB NULL, "attributeSubtype" BLOB NULL, "attributeFamily" BLOB NULL, "attributeClass" BLOB NULL, "attributeSubclass" BLOB NULL, "attributeCollection" BLOB NULL, "attributeSet" BLOB NULL, "attributeBooleans" BIGINT NULL DEFAULT 0, "name" TEXT NULL, "desc" TEXT NULL, "sortBy" TEXT NULL, "sortByIsAsc" BOOLEAN NULL, "useStoreSalesFilter" BOOLEAN NULL, "storeSalesQuantityOperator" TEXT NULL, "storeSalesQuantity" INTEG„E-/indexCPIFilter_brands_object_id_iCPIFilter_brands=CREATE INDEX "CPIFilter_brands_object_id_i" ON "CPIFilter_brands" ("object_id") **&~rmula" TEXT NULL, "orderDiscountCalculationFormula" TEXT NULL, "distributorFax" TEXT NULL, "distributor‚s(--…tableCPIFilter_brandsCPIcšetableCPIFilterCPIFilter:CREATE TABLE "CPIFilter" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGERKJšetableCPIFilterCPIFilter:CREATE TABLE "CPIFilter" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "useAttributesFilter" BOOLEAN NULL, "attributeGender" BLOB NULL, "attributeGroup" BLOB NULL, "attributeType" BLOB NULL, "attributeSubtype" BLOB NULL, "attributeFamily" BLOB NULL, "attributeClass" BLOB NULL, "attributeSubclass" BLOB NULL, "attributeCollection" BLOB NULL, "attributeSet" BLOB NULL, "attributeBooleans" BIGINT NULL DEFAULT 0, "name" TEXT NULL, "desc" TEXT NULL, "sortBy" TEXT NULL, "sortByIsAsc" BOOLEAN NULL, "useStoreSalesFilter" BOOLEAN NULL, "storeSalesQuantityOperator" TEXT NULL, "storeSalesQuantity" INTEG‚ ss~ "storeSalesUseSalesPeriod" BOOLEAN NULL, "storeSalesPeriodQuantity" INTEGER NULL, "storeSalesPeriod" TEX‚s)--…tableCPIFilter_brandsCPIFilter_brands;CREATE TABLE "CPIFilter_brands" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIFilter" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED) *E-/inv--…tableCPIFilter_brandsCPIFilter_brands;CREATE TABLE "CPIFilter_brands" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIFilter" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED) *E-/indexCPIFilter_brands_object_id_iCPIFilter_brands=CREATE INDEX "CPIFilter_brands_object_id_i" ON "CPIFilter_brands" ("object_id") {{ń~ "storeSalesUseSalesPeriod" BOOLEAN NULL, "storeSalesPeriodQuantity" INTEGER NULL, "storeSalesPeriod" TEX‚sK--…tableCPIFilter_brandsCPIFilter_brandsCREATE INDEX "CPIFilter_brands_object_id_i" ON "CPIFilter_brands" ("object_id")‚M33…%tableCPIFilter_campaignsCPIFilter_campaigns?CREATE TABLE "CPIFilter_campaigns" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIFilter" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPICampaign" ("dbID") DEFERRABLE INITIALLY DEFERRED) ss~‚s(--…tableCPIFilter_brandsCPIFilter_brands=CREATE TABLE "CPIFilter_brands" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIFilter" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED) )E-/inv--…tableCPIFilter_brandsCPIFilter_brands=CREATE TABLE "CPIFilter_brands" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIFilter" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED) )E-/indexCPIFilter_brands_object_id_iCPIFilter_brands?CREATE INDEX "CPIFilter_brands_object_id_i" ON "CPIFilter_brands" ("object_id") gWh"oreSalesUseSales+K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns>CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")&,99gtablefilter_brands_relationfilter_brands_relation@CREATE TABLE "filter_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)˜??mtablefilter_campaigns_relationfilter_campaigns_relationACREATE TABLE "filter_campaigns_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)ć!!‡tableCPICatalogCPICatalogBCREATE TABLE "CPICatalog" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, +K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns>CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")Š99gtablef™K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns>CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id") gWh"oreSalesUseSales,K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns?CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")&-99gtablefilter_brands_relationfilter_brands_relationACREATE TABLE "filter_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)˜??mtablefilter_campaigns_relationfilter_campaigns_relationBCREATE TABLE "filter_campaigns_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)ć!!‡tableCPICatalogCPICatalogCCREATE TABLE "CPICatalog" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, ,K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns?CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")Š99gtablef™K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns?CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id") &&żh"NK3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns@CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")&O99gtablefilter_brands_relationfilter_brands_relationBCREATE TABLE "filter_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)/P??mtablefilter_campaigns_relationfilter_campaigns_relationCCREATE TABLE "filter_campaigns_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)ƒcQ!!‡tableCPICatalogCPICatalogDCREATE TABLE "CPICatalog" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "isActive" BOOLEAN NULL, "season" TEXT NULL, "department" TEXT NULL, "filter" INTEGER NULL, "connectedToAll" BOOLEAN NULL, "validityDate" DATE NULL, CONSTRAINT "filter_fk" FOREIGN KEY ("filter") REFERENCES "CPIFilter" ("dbID") DEFERRABLE INITIALLY DEFERRED) gWh"+K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaignsACREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")&,99gtablefilter_brands_relationfilter_brands_relationCCREATE TABLE "filter_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)˜??mtablefilter_campaigns_relationfilter_campaigns_relationDCREATE TABLE "filter_campaigns_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)ć!!‡tableCPICatalogCPICatalogECREATE TABLE "CPICatalog" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, +K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaignsACREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")Š99gtablef™K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaignsACREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id") ss~‚s'--…tableCPIFilter_brandsCPIFilter_brandsBCREATE TABLE "CPIFilter_brands" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIFilter" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED) (E-/inv--…tableCPIFilter_brandsCPIFilter_brandsBCREATE TABLE "CPIFilter_brands" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIFilter" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED) (E-/indexCPIFilter_brands_object_id_iCPIFilter_brandsDCREATE INDEX "CPIFilter_brands_object_id_i" ON "CPIFilter_brands" ("object_id") úrh"+K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaignsCCREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")&,99gtablefilter_brands_relationfilter_brands_relationECREATE TABLE "filter_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)‚/!!ƒQtableCPICountryCPICountryCCREATE TABLE "CPICountry" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "uiCulture" TEXT NULL, "vat" REAL NULL)Ž!!…atableCPIMessageCPIMessageECREATE TABLE "CPIMessage" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INT!!ƒQtableCPICountryCPICountryCCREATE TABLE "CPICountry" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "uiCulture" TEXT NULL, "vat" REAL NULL) úrh‚0!!ƒQtableCPICountryCPICountryDCREATE TABLE "CPICountry" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "uiCulture" TEXT NULL, "vat" REAL NULL)Ž!!…atableCPIMessageCPIMessageFCREATE TABLE "CPIMessage" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INT!!ƒQtableCPICountryCPICountryDCREATE TABLE "CPICountry" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "uiCulture" TEXT NULL, "vat" REAL NULL) llrh"+K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaignsECREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")&,99gtablefilter_brands_relationfilter_brands_relationGCREATE TABLE "filter_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)‚R!!ƒQtableCPICountryCPICountryECREATE TABLE "CPICountry" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "uiCulture" TEXT NULL, "vat" REAL NULL)ƒ S!!…atableCPIMessageCPIMessageGCREATE TABLE "CPIMessage" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "title" TEXT NULL, "content" TEXT NULL, "creationTime" INT_DATETIME NULL, "expirationTime" INT_DATETIME NULL, "sourceUser" INTEGER NULL, "sourceUserName" TEXT NULL, "wasRead" BOOLEAN NULL, "isWrntyMessage" BOOLEAN NULL) TýP"*K3;indexCPIFilter_campaigns_object_Ź†tableCPIStateCPIStateFCREATE TABLE "CPIState" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "vat" REAL NULL, "country" INTEGER NULL, "countryWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "country_fk" FOREIGN KEY ("country") REFERENCES "CPICountry" ("dbID") DEFERRABLE INITIALLY DEFERRED)%%ƒItableCPISubTargetCPISubTargetHCREATE TABLE "CPISubTarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL)ýƒCtableCPITargetCPITargetICREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL) TýPŹ†tableCPIStateCPIStateGCREATE TABLE "CPIState" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "vat" REAL NULL, "country" INTEGER NULL, "countryWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "country_fk" FOREIGN KEY ("country") REFERENCES "CPICountry" ("dbID") DEFERRABLE INITIALLY DEFERRED)%%ƒItableCPISubTargetCPISubTargetICREATE TABLE "CPISubTarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL)ýƒCtableCPITargetCPITargetJCREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL) TTýPƒ&T†tableCPIStateCPIStateHCREATE TABLE "CPIState" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "vat" REAL NULL, "country" INTEGER NULL, "countryWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "country_fk" FOREIGN KEY ("country") REFERENCES "CPICountry" ("dbID") DEFERRABLE INITIALLY DEFERRED)‚U%%ƒItableCPISubTargetCPISubTargetJCREATE TABLE "CPISubTarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL)zVƒCtableCPITargetCPITargetKCREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL) TýPŹ†tableCPIStateCPIStateICREATE TABLE "CPIState" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "vat" REAL NULL, "country" INTEGER NULL, "countryWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "country_fk" FOREIGN KEY ("country") REFERENCES "CPICountry" ("dbID") DEFERRABLE INITIALLY DEFERRED)%%ƒItableCPISubTargetCPISubTargetKCREATE TABLE "CPISubTarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL)ýƒCtableCPITargetCPITargetLCREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL) ŐooNz6E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsMCREATE N˘55…atableCPITarget_subTargetsCPITarget_subTargetsJCREATE TABLE "CPITarget_subTargets" ( "object_id" INTEGER NOT NULL, "index" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPITarget" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value"z3ƒCtableCPITargetCPITargetICREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL).M5?indexCPITarget_subTargets_object_id_iCPITarget_subTargetsLCREATE INDEX "CPITarget_subTargets_object_id_i" ON "CPITarget_subTargets" ("object_id")‘E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsMCREATE INDEX "CPITarget_subTargets_index_i" ON "CPITarget_subTargets" ("index") ŐooNz7E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsNCREATE N˘55…atableCPITarget_subTargetsCPITarget_subTargetsKCREATE TABLE "CPITarget_subTargets" ( "object_id" INTEGER NOT NULL, "index" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPITarget" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value"z4ƒCtableCPITargetCPITargetJCREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL).M5?indexCPITarget_subTargets_object_id_iCPITarget_subTargetsMCREATE INDEX "CPITarget_subTargets_object_id_i" ON "CPITarget_subTargets" ("object_id")‘E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsNCREATE INDEX "CPITarget_subTargets_index_i" ON "CPITarget_subTargets" ("index") ~~ ˝NzYE5/indexCPITarget_subTargets_index_iCPITarget_subTargetsOCREATE ƒW55…atableCPITarget_subTargetsCPITarget_subTargetsLCREATE TABLE "CPITarget_subTargets" ( "object_id" INTEGER NOT NULL, "index" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPITarget" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPISubTarget" ("dbID") DEFERRABLE INITIALLY DEFERRED)XM5?indexCPITarget_subTargets_object_id_iCPITarget_subTargetsNCREATE INDEX "CPITarget_subTargets_object_id_i" ON "CPITarget_subTargets" ("object_id")YE5/indexCPITarget_subTargets_index_iCPITarget_subTargetsOCREATE INDEX "CPITarget_subTargets_index_i" ON "CPITarget_subTargets" ("index")/Z??mtabletarget_subTarget_relationtarget_subTarget_relationPCREATE TABLE "target_subTarget_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ŐooNz6E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsPCREATE N˘55…atableCPITarget_subTargetsCPITarget_subTargetsMCREATE TABLE "CPITarget_subTargets" ( "object_id" INTEGER NOT NULL, "index" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPITarget" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value"z3ƒCtableCPITargetCPITargetLCREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL).M5?indexCPITarget_subTargets_object_id_iCPITarget_subTargetsOCREATE INDEX "CPITarget_subTargets_object_id_i" ON "CPITarget_subTargets" ("object_id")‘E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsPCREATE INDEX "CPITarget_subTargets_index_i" ON "CPITarget_subTargets" ("index") TýPŹ†tableCPIStateCPIStateNCREATE TABLE "CPIState" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "englishName" TEXT NULL, "isoAlpha2Code" TEXT NULL, "vat" REAL NULL, "country" INTEGER NULL, "countryWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "country_fk" FOREIGN KEY ("country") REFERENCES "CPICountry" ("dbID") DEFERRABLE INITIALLY DEFERRED)%%ƒItableCPISubTargetCPISubTargetPCREATE TABLE "CPISubTarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL)ýƒCtableCPITargetCPITargetQCREATE TABLE "CPITarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "incomeTarget" REAL NULL, "dateFrom" DATE NULL, "dateTo" DATE NULL) Í^Éz6E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsRCREATE N˘55…atableCPITarget_subTargetsCPIm877‚ytableCPIStorePropertyColorCPIStorePropertyColorOCREATE TABLE "CPIStorePropertyColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "color" INTEGER NULL, "value" TEXT NULL)h77ˆitableCPIPortfolioItemGroupCPIPortfolioItemG6E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsMCREATE INDEX "CPITarget_subTargets_index_i" ON "CPITarget_subTargets" ("index")/7??mtabletarget_subTarget_relationtarget_subTarget_relationNCREATE TABLE "target_subTarget_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)đ77‚ytableCPIStorePropertyColorCPIStorePropertyColorOCREATE TABLE "CPIStorePropertyColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "color" INTEGER NULL, "value" TEXT NULL) Í^Ɂm977‚ytableCPIStorePropertyColorCPIStorePropertyColorPCREATE TABLE "CPIStorePropertyColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "color" INTEGER NULL, "value" TEXT NULL)h77ˆitableCPIPortfolioItemGroupCPIPortfolioItemG7E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsNCREATE INDEX "CPITarget_subTargets_index_i" ON "CPITarget_subTargets" ("index")/8??mtabletarget_subTarget_relationtarget_subTarget_relationOCREATE TABLE "target_subTarget_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)đ77‚ytableCPIStorePropertyColorCPIStorePropertyColorPCREATE TABLE "CPIStorePropertyColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "color" INTEGER NULL, "value" TEXT NULL) ¨¨˜¤Éz6E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsTCREATE N˘55…atableCPITarget_subTargetsCPIm[77‚ytableCPIStorePropertyColorCPIStorePropertyColorQCREATE TABLE "CPIStorePropertyColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "color" INTEGER NULL, "value" TEXT NULL)„e\77ˆitableCPIPortfolioItemGroupCPIPortfolioItemGroupSCREATE TABLE "CPIPortfolioItemGroup" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "memberQuantity" INTEGER NULL, "group" INTEGER NULL, "groupWRNTYId" BIGINT NULL DEFAULT 0, "member" INTEGER NULL, "memberWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "group_fk" FOREIGN KEY ("group") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "member_fk" FOREIGN KEY ("member") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED) ~zÉz5E5/indexCPITarget_subTargets_index_iCPITarget_subTargetsUCREATE ‚CCtableCPIStockTakingPortfolioItemCPIStockTakingPortfolioItemRCREATE TABLE "CPIStockTakingPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "childrenUnitQuantity" REAL NULL, "allowSellout" BOOLEAN NULL, "remark" TEXT NULL, "unitQuantity" REAL NULL, "parentStockTakingPortfolioItem" INTEGER NULL, "parentStockTakingPortfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "parentWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "parentStockTakingPortfolioItem_fk" FOREIGN KEY ("parentStockTakingPortfolioItem") REFERENCES "CPIStockTakingPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED) ~z‚CCtableCPIStockTakingPortfolioItemCPIStockTakingPortfolioItemSCREATE TABLE "CPIStockTakingPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "childrenUnitQuantity" REAL NULL, "allowSellout" BOOLEAN NULL, "remark" TEXT NULL, "unitQuantity" REAL NULL, "parentStockTakingPortfolioItem" INTEGER NULL, "parentStockTakingPortfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "parentWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "parentStockTakingPortfolioItem_fk" FOREIGN KEY ("parentStockTakingPortfolioItem") REFERENCES "CPIStockTakingPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED) ~~ze" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATET†]CCtableCPIStockTakingPortfolioItemCPIStockTakingPortfolioItemTCREATE TABLE "CPIStockTakingPortfolioItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "childrenUnitQuantity" REAL NULL, "allowSellout" BOOLEAN NULL, "remark" TEXT NULL, "unitQuantity" REAL NULL, "parentStockTakingPortfolioItem" INTEGER NULL, "parentStockTakingPortfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "parentWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "parentStockTakingPortfolioItem_fk" FOREIGN KEY ("parentStockTakingPortfolioItem") REFERENCES "CPIStockTakingPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED) 1-e" INT_DATETIME NULL, "deliveryĎ))žCtableCPIStockTakingCPIStockTakingUCREATE TABLE "CPIStockTaking" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "a… 11-e" INT_DATETIME NULL, "deliveryD^))žCtableCPIStockTakingCPIStockTakingVCREATE TABLE "CPIStockTaking" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "a| %KNT_DATETIME NULL, "deliveryĎ))žCtableCPIStockTakÖ]]…ytableCPIStockTaking_stockTakingPortfolioItemsCPIStockTaking_stockTakingPortfolioItemsWCREATE TABLE "CPIStockTaking_stockTakingPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStockTaking" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIStockTakingPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)j>u]‚indexCPIStockTaking_stockTakingPortfolioItems_object_id_iCPIStockTaking_stockTakingPortfolioItemsYCREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id")íu]‚indexCPIStockTaking_stockTakingPortfolioItems_object_id_iCPIStockTaking_stockTakingPortfolioItemsYCREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id") OO%KĎ))žCtableCPIStockTakƒS_]]…ytableCPIStockTaking_stockTakingPortfolioItemsCPIStockTaking_stockTakingPortfolioItemsXCREATE TABLE "CPIStockTaking_stockTakingPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStockTaking" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIStockTakingPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)j`u]‚indexCPIStockTaking_stockTakingPortfolioItems_object_id_iCPIStockTaking_stockTakingPortfolioItemsZCREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id")kagg‚tablestockTaking_stockTakingPortfolioItem_relationstockTaking_stockTakingPortfolioItem_relation[CREATE TABLE "stockTaking_stockTakingPortfolioItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) %KNT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMeÖ]]…ytableCPIStockTaking_stockTakingPortfolioItemsCPIStockTaking_stockTakingPortfolioItemsYCREATE TABLE "CPIStockTaking_stockTakingPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStockTaking" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIStockTakingPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)j=u]‚indexCPIStockTaking_stockTakingPortfolioItems_object_id_iCPIStockTaking_stockTakingPortfolioItems[CREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id")íu]‚indexCPIStockTaking_stockTakingPortfolioItems_object_id_iCPIStockTaking_stockTakingPortfolioItems[CREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id") %KĎ))žCtableCPIStockTakÖ]]…ytableCPIStockTaking_stockTakingPortfolioItemsCPIStockTaking_stockTakingPortfolioItemsZCREATE TABLE "CPIStockTaking_stockTakingPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStockTaking" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIStockTakingPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)j=u]‚indexCPIStockTaking_stockTakingPortfolioItems_object_id_iCPIStockTaking_stockTakingPortfolioItems\CREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id")íu]‚indexCPIStockTaking_stockTakingPortfolioItems_object_id_iCPIStockTaking_stockTakingPortfolioItems\CREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id") …e" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "balanceTime" INT_DATETIME NULL, "isBalanced" BOOLEAN NULL, "itemCount" REAL NULL, "quantitiesTotal" REAL NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "{''‰/tableCPIStoreStockCPIStoreStock[CREATE TABLE "CPIStoreStock" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "inventory" INTEGER NULL, "date" INT_DATETIME NULL, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED) ……KNT_DATETIME NULL, "deliveryĎ))žCtableCPIStockTakÖ]]…ytableCPIStockTaking_stockTakingPortfolioItemsCPIStockTaking_stockTakingPortfolioItems\CREATE TABLE "CPIStockTaking_stockTakingPortfolioItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIStockTaking" ("dbID„xb''‰/tableCPIStoreStockCPIStoreStock\CREATE TABLE "CPIStoreStock" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "inventory" INTEGER NULL, "date" INT_DATETIME NULL, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED) îęĎ))žCtableCPIStockTakingCPIStockTaking\CREATE TABLE "CPIStockTaking" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPut==‹1tableCPIStoreCatalogPriceListCPIStoreCatalogPriceList]CREATE TABLE "CPIStoreCatalogPriceList" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "catalog" INTEGER NULL, "catalogWRNTYId" BIGINT NULL DEFAULT 0, "priceList" INTEGER NULL, "priceListWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "catalog_fk" FOREIGN KEY ("catalog") REFERENCES "CPICatalog" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "priceList_fk" FOREIGN KEY ("priceList") REFERENCES "CPIPriceList" ("dbID") DEFERRABLE INITIALLY DEFERRED) îîęKÖ]]…ytableCPIStockTaking_stockTakingPortfolioItemsCPIStockTaking_stockTakingPortfolioItems^CREATE TABLE "CPIStockTaking_stockTakingPortfolioItems" ( †c==‹1tableCPIStoreCatalogPriceListCPIStoreCatalogPriceList^CREATE TABLE "CPIStoreCatalogPriceList" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "catalog" INTEGER NULL, "catalogWRNTYId" BIGINT NULL DEFAULT 0, "priceList" INTEGER NULL, "priceListWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "catalog_fk" FOREIGN KEY ("catalog") REFERENCES "CPICatalog" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "priceList_fk" FOREIGN KEY ("priceList") REFERENCES "CPIPriceList" ("dbID") DEFERRABLE INITIALLY DEFERRED) ÇĂ" INTEGER NULL, "unitOfMeasureItemWRNTYId" BIGINT NULL DEFAULT 0, "packageOrderItem" INTEGER NULL, "packageOrderItemWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItem" INTEGER NUL9%%œtableCPIOrderItemCPIOrderItem_CREATE TABLE "CPIOrderItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "quantity" REAL NULL, "remark" TEXT NULL, "remark2" TEXT NULL, "remark3" TEXT NULL, "remark4" TEXT NULL, "unitPrice" REAL NULL, "unitPriceAfterDiscount" REAL NULL, "unitFinalPrice" REAL NULL, "discountPercentage" REAL NULL, "isFixedUnitPriceAfterDiscount" BOOLEAN NULL, "isFixedDiscount" BOOLEAN NULL, "isDuplicated" BOOLEAN NULL, "suppressedSpecialOffer" BOOLEAN NULL, "specialOfferLeadingOrderItem" INTEGER NULL, "specialOfferLeadingOrderItemWrntyID" BIGINT NULL DEFAULT 0, "localCreationDate" INT_DATETIME NULL, "portfolioItemExID" TEXT NULL, "deliveryDate" DATE NULL, "unitOfMea† ÇÇĂ" INTEGER NULL, "unitOfMeasureItemWRNTYId" BIGINT NULL DEFAULT 0, "packageOrderItem" INTEGER NULL, "packageOrderItemWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItem" INTEGER NULŽ.d%%œtableCPIOrderItemCPIOrderItem`CREATE TABLE "CPIOrderItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "quantity" REAL NULL, "remark" TEXT NULL, "remark2" TEXT NULL, "remark3" TEXT NULL, "remark4" TEXT NULL, "unitPrice" REAL NULL, "unitPriceAfterDiscount" REAL NULL, "unitFinalPrice" REAL NULL, "discountPercentage" REAL NULL, "isFixedUnitPriceAfterDiscount" BOOLEAN NULL, "isFixedDiscount" BOOLEAN NULL, "isDuplicated" BOOLEAN NULL, "suppressedSpecialOffer" BOOLEAN NULL, "specialOfferLeadingOrderItem" INTEGER NULL, "specialOfferLeadingOrderItemWrntyID" BIGINT NULL DEFAULT 0, "localCreationDate" INT_DATETIME NULL, "portfolioItemExID" TEXT NULL, "deliveryDate" DATE NULL, "unitOfMeay EFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "status" INTEGER NULL, "clientOrderID" TEXT NULL, "bank" TEXT NULL, "discount" REAL NULL, "clientExternalID" TEXT NULL, "insurance" TEXT NULL, "payment" TEXT NULL, "paymentTer ˘˘ĺgžL, "shipTo" TEXT NULL, "shipmentAddress" TEXT NULL, "shipmentCity" TEXT NULL, "shipmentCountry" TEXT NULL, "shipmentCountryISOAlpha2š0e´3tableCPIOrderCPIOrderbCREATE TABLE "CPIOrder" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NU‡‚f33…%tableCPIOrder_orderItemsCPIOrder_orderItemsdCREATE TABLE "CPIOrder_orderItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPIOrder" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPIOrderItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)gK3;indexCPIOrder_orderItems_object_id_iCPIOrder_orderItemseCREATE INDEX "CPIOrder_orderItems_object_id_i" ON "CPIOrder_orderItems" ("object_id") " TEXT NULL, "billingContactDetailsWorkPhone" TEXT NULL, "currencySymbol" TEXT NULL, "externalData" TEXT NULL, "catalog" INTEGER NULL, "catalogWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "catalog_fk" FOREIGN KEY ("catalog") REFERENCES "CPICatalog" ("dbID") DEFERRABLE INITIALLY DEFERRED) ˝ggžL, "shipTo" TEXT NULL, "shipmentAddress" TEXT NULL, "shipmentCity" TEXT NULL, "shipmentCountry" TEXT NULL, "shipmentCountryISOAlpha2š0C´3tableCPIOrderCPIOrderaCREATE TABLE "CPIOrder" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NUb33…%tableCPIOrder_orderItemsCPIOrder_orderItemsfCREATE TABLE "CPIOrder_orderItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENC´3tableCPIOrderCPIOrderaCREATE TABLE "CPIOrder" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NUb EFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "status" INTEGER NULL, "clientOrderID" TEXT NULL, "bank" TEXT NULL, "discount" REAL NULL, "clientExternalID" TEXT NULL, "insurance" TEXT NULL, "payment" TEXT NULL, "paymentTer éé˜PLULL, "billingContactDetailsWorkPhone" TEXT NULL, "curren„ei‰!tableCPISaleCPISalehCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY,,h==ktableorder_orderItem_relationorder_orderItem_relationfCREATE TABLE "order_orderItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)„ei‰!tableCPISaleCPISalehCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "date" INT_DATETIME NULL, "quantity" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED) ˝ggžULL, "billingContactDetailsWorkPhone" TEXT NULL, "currencySymbol" TEXT NULL, "externalData" TEXT NULL, "catalog" INTEGER NULL, "cataš0B´3tableCPIOrderCPIOrderdCREATE TABLE "CPIOrder" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NUe33…%tableCPIOrder_orderItemsCPIOrder_orderItemsiCREATE TABLE "CPIOrder_orderItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENC´3tableCPIOrderCPIOrderdCREATE TABLE "CPIOrder" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NUe ¸QPLL, "shipTo" TEXT NULL, "shipmentAddress" TEXT NULL, "s„eG‰!tableCPISaleCPISalejCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY,,F==ktableorder_orderItem_relationorder_orderItem_relationhCREATE TABLE "order_orderItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)h‰!tableCPISaleCPISalejCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "date" INT_DATETIME NULL, "quantity" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "portfolioIteEK3;indexCPIOrder_orderItems_object_id_iCPIOrder_orderItemsgCREATE INDEX "CPIOrder_orderItems_object_id_i" ON "CPIOrder_orderItems" ("object_id")Ż==ktableorder_orderItem_relationorder_orderItem_relationhCREATE TABLE "order_orderItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ŘŘÖÔLULL, "billingContactDetailsWorkPhone" TEXT NULL, "curren„eG‰!tableCPISaleCPISalekCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER ƒ{j!!‡AtableCPIPaymentCPIPaymentiCREATE TABLE "CPIPayment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "reference" TEXT NULL, "paidSum" REAL NULL, "debtSum" REAL NULL, "date" DATE NULL, "externalID" TEXT NULL, "currency" TEXT NULL, "comment" TEXT NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)‚'k++„tableCPIOnlineActionCPIOnlineActionkCREATE TABLE "CPIOnlineAction" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "onlineActionType" INTEGER NULL, "name" TEXT NULL, "description" TEXT NULL, "url" TEXT NULL, "icon" TEXT NULL) ¸QPLL, "shipTo" TEXT NULL, "shipmentAddress" TEXT NULL, "s„eF‰!tableCPISaleCPISalelCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY,,E==ktableorder_orderItem_relationorder_orderItem_relationjCREATE TABLE "order_orderItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)h‰!tableCPISaleCPISalelCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "date" INT_DATETIME NULL, "quantity" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "portfolioIteDK3;indexCPIOrder_orderItems_object_id_iCPIOrder_orderItemsiCREATE INDEX "CPIOrder_orderItems_object_id_i" ON "CPIOrder_orderItems" ("object_id")Ż==ktableorder_orderItem_relationorder_orderItem_relationjCREATE TABLE "order_orderItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) ŘÖÔLULL, "billingContactDetailsWorkPhone" TEXT NULL, "curren„eF‰!tableCPISaleCPISalemCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER (!!‡AtableCPIPaymentCPIPaymentkCREATE TABLE "CPIPayment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "reference" TEXT NULL, "paidSum" REAL NULL, "debtSum" REAL NULL, "date" DATE NULL, "externalID" TEXT NULL, "currency" TEXT NULL, "comment" TEXT NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)*++„tableCPIOnlineActionCPIOnlineActionmCREATE TABLE "CPIOnlineAction" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "onlineActionType" INTEGER NULL, "name" TEXT NULL, "description" TEXT NULL, "url" TEXT NULL, "icon" TEXT NULL) bb^ÔLULL, "billingContactDetailsWorkPhone" TEXT NULL, "curren„eF‰!tableCPISaleCPISalenCREATE TABLE "CPISale" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER (!!‡AtableCPIPaymentCPIPaymentlCREATE TABLE "CPIPayment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "reference" TEXT NULL, "paidSum" REAL NULL, "debtSum" REAL NULL, "date" DATE NULL, "externalID" TEXT NULL, "currency" TEXT NULL, "comment" TEXT NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0,ƒl??…EtableCPIActivityTypeDefinitionCPIActivityTypeDefinitionlCREATE TABLE "CPIActivityTypeDefinition" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "icon" TEXT NULL, "name" TEXT NULL, "desc" TEXT NULL, "exportToERP" BOOLEAN NULL, "activityType" INTEGER NULL, "share" BOOLEAN NULL, "approveType" INTEGER NULL, "applicationLogic" BLOB NULL) ŘÖԞš0A´3tableCPIOrderCPIOrderjCREATE TABLE "CPIO(!!‡AtableCPIPaymentCPIPaymentmCREATE TABLE "CPIPayment" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "reference" TEXT NULL, "paidSum" REAL NULL, "debtSum" REAL NULL, "date" DATE NULL, "externalID" TEXT NULL, "currency" TEXT NULL, "comment" TEXT NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)*++„tableCPIOnlineActionCPIOnlineActionoCREATE TABLE "CPIOnlineAction" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "onlineActionType" INTEGER NULL, "name" TEXT NULL, "description" TEXT NULL, "url" TEXT NULL, "icon" TEXT NULL) ™ÔL„eF‰!tableCPISaleCPISalepCREATE TABLE "CPISale" ( "wrntyID" BIGINTŽXm11œ[tableCPIGeneralActivityCPIGeneralActivitynCREATE TABLE "CPIGeneralActivity" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "… eProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED) üp4"ƒjn;;†ktableCPICustomizedTargetItemCPICustomizedTargetItempCREATE TABLE "CPICustomizedTargetItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "appObjectType" INTEGER NULL, "appObjectID" INTEGER NULL, "applicationData" TEXT NULL, "employee" INTEGER NULL, "employeeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "employee_fk" FOREIGN KEY ("employee") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED)„o33‡)tableCPICustomizedTargetCPICustomizedTargetrCREATE TABLE "CPICustomizedTarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "status" INTEGER NULL, "applicationData" TEXT NULL, "creatingEmployee" INTEGER NULL, "creatingEmployeeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "creatingEmployee_fk" FOREIGN KEY ("creatingEmployee") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED) üp4"ń;;†ktableCPICustomizedTargetItemCPICustomizedTargetItemqCREATE TABLE "CPICustomizedTargetItem" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "appObjectType" INTEGER NULL, "appObjectID" INTEGER NULL, "applicationData" TEXT NULL, "employee" INTEGER NULL, "employeeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "employee_fk" FOREIGN KEY ("employee") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED)33‡)tableCPICustomizedTargetCPICustomizedTargetsCREATE TABLE "CPICustomizedTarget" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NULL, "desc" TEXT NULL, "status" INTEGER NULL, "applicationData" TEXT NULL, "creatingEmployee" INTEGER NULL, "creatingEmployeeWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "creatingEmployee_fk" FOREIGN KEY ("creatingEmployee") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED) eProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED) őćń;;ƒWp__…}tableCPICustomizedTarget_customizedTargetItemsCPICustomizedTarget_customizedTargetItemssCREATE TABLE "CPICustomizedTarget_customizedTargetItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPICustomizedTarget" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPICustomizedTargetItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)nqw_‚indexCPICustomizedTarget_customizedTargetItems_object_id_iCPICustomizedTarget_customizedTargetItemsuCREATE INDEX "CPICustomizedTarget_customizedTargetItems_object_id_i" ON "CPICustomizedTarget_customizedTargetItems" ("object_id")‚r ‚1tablecustomizedtarget_customizedtarget_boxItem_relation_relationcustomizedtarget_customizedtarget_boxItem_relation_relationvCREATE TABLE "customizedtarget_customizedtarget_boxItem_relation_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0) őćń;;ćÚ__…}tableCPICustomizedTarget_customizedTargetItemsCPICustomizedTarget_customizedTargetItemstCREATE TABLE "CPICustomizedTarget_customizedTargetItems" ( "object_id" INTEGER NOT NULL, "value" INTEGER NULL, CONSTRAINT "object_id_fk" FOREIGN KEY ("object_id") REFERENCES "CPICustomizedTarget" ("dbID") ON DELETE CASCADE, CONSTRAINT "value_fk" FOREIGN KEY ("value") REFERENCES "CPICustomizedTargetItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)nqw_‚indexCPICustomizedTarget_customizedTargetItems_object_id_iCPICustomizedTarget_customizedTargetItemsvCREATE INDEX "CPICustomizedTarget_customizedTargetItems_object_id_i" ON "CPICustomizedTarget_customizedTargetItems" ("object_id")‚1tablecustomizedtarget_customińw_‚indexCPICustomizedTarget_customizedTargetItems_object_id_iCPICustomizedTarget_customizedTargetItemsvCREATE INDEX "CPICustomizedTarget_customizedTargetItems_object_id_i" ON "CPICustomizedTarget_customizedTargetItems" ("object_id") " TEXT NULL, "billingContactDetailsWorkPhone" TEXT NULL, "currencySymbol" TEXT NULL, "externalData" TEXT NULL, "catalog" INTEGER NULL, "catalogWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "catalog_fk" FOREIGN KEY ("catalog") REFERENCES "CPICatalog" ("dbID") DEFERRABLE INITIALLY DEFERRED) TEXT NULL, "shipTo" TEXT NULL, "shipmentAddress" TEXT NULL, "shipmentCity" TEXT NULL, "shipmentCountry" TEXT NULL, "shipmentCountryISOAlpha2Code" TEXT NULL, "shipmentState" TEXT NULL, "shipmentStateISOAlpha2Code" TEXT NULL, "shipmentZipcode" TEXT NULL, "govIssuedID" TEXT NULL, "shippingContactDetailsCellular" TEXT NULL, "shippingContactDetailsEmail" TEXT NULL, "shippingContactDetailsFax" TEXT NULL, "shippingContactDetailsHomePhone" TEXT NULL, "shippingContactDetailsWebSite" TEXT NULL, "shippingContactDetailsWorkPhone" TEXT NULL, "billTo" TEXT NULL, "billingAddress" TEXT NULL, "billingCity" TEXT NULL, "billingCountry" TEXT NULL, "billingCountryISOAlpha2Code" TEXT NULL, "billingState" TEXT NULL, "billingStateISOAlpha2Code" TEXT NULL, "billingZipcode" TEXT NULL, "billingContactDetailsCellular" TEXT NULL, "billingContactDetailsEmail" TEXT NULL, "billingContactDetailsFax" TEXT NULL, "billingContactDetailsHomePhone" TEXT NULL, "billingContactDetailsWeb ffbernalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "dsutableCPITaskCPITaskwCREATE TABLE "CPITask" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "syncPutStatus" INTEGER NULL, "store" INTEGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreO„sureItem" INTEGER NULL, "unitOfMeasureItemWRNTYId" BIGINT NULL DEFAULT 0, "packageOrderItem" INTEGER NULL, "packageOrderItemWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItem" INTEGER NULL, "portfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "portfolioItemTSAttributes" BLOB NULL, "tsAttributes" BLOB NULL, "readOnly" BOOLEAN NULL, "lineID" SMALLINT NULL, "parentWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "specialOfferLeadingOrderItem_fk" FOREIGN KEY ("specialOfferLeadingOrderItem") REFERENCES "CPIOrderItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "unitOfMeasureItem_fk" FOREIGN KEY ("unitOfMeasureItem") REFERENCES "CPIUnitOfMeasureItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "packageOrderItem_fk" FOREIGN KEY ("packageOrderItem") REFERENCES "CPIOrderItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "portfolioItem_fk" FOREIGN KEY ("portfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED)culationFormula" TEXT NULL, "orderDiscountCalculationFormula" TEXT NULL, "distributorFax" TEXT NULL, "distributorID" BIGINT NULL DEFAULT 0, "distributorName" TEXT NULL, "distributorPhone" TEXT NULL, "distributorCity" TEXT NULL, "distributorCountryISOAlpha2Code" TEXT NULL, "distributorStateISOAlpha2Code" TEXT NULL, "distributorStreet" TEXT NULL, "distributorCurrencySymbol" TEXT NULL, "distributorZipCode" TEXT NULL, "accountStatus" INTEGER NULL, "accountType" INTEGER NULL, "vatCalcFormulaID" INTEGER NULL, "imageCounter" INTEGER NULL, "allowEditOrderDiscount" BOOLEAN NULL, "isAdmin" BOOLEAN NULL, "phone" TEXT NULL, "domainRouting" TEXT NULL, "isPriceListUsed" BOOLEAN NULL, "useStoreDiscountPerItem" BOOLEAN NULL, "shareActivities" BOOLEAN NULL, "enforceCostPrice" BOOLEAN NULL, "orderCartSortingField" TEXT NULL, "propertyWithColors" INTEGER NULL, "tsAttributesDelimiter" CHARACTER(1) NULL, "accountDashboardFormatting" BLOB NULL, "targetsType" INTEGER NULL)TIME NULL, "oldestDebtDate" INT_DATETIME NULL, "latitude" REAL NULL, "longitude" REAL NULL, "orderDiscount" REAL NULL, "prop1" TEXT NULL, "prop2" TEXT NULL, "prop3" TEXT NULL, "prop4" TEXT NULL, "prop5" TEXT NULL, "govIssuedID" TEXT NULL, "tsAttributes" BLOB NULL, "locationSet" BOOLEAN NULL, "dashboardCustomData" TEXT NULL, "workPhone" TEXT NULL, "parentStore" INTEGER NULL, "parentStoreWRNTYId" BIGINT NULL DEFAULT 0, "priceList" INTEGER NULL, "priceListWRNTYId" BIGINT NULL DEFAULT 0, "specialPriceList" INTEGER NULL, "specialPriceListWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "parentStore_fk" FOREIGN KEY ("parentStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "priceList_fk" FOREIGN KEY ("priceList") REFERENCES "CPIPriceList" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "specialPriceList_fk" FOREIGN KEY ("specialPriceList") REFERENCES "CPIPriceList" ("dbID") DEFERRABLE INITIALLY DEFERRED)ctionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "balanceTime" INT_DATETIME NULL, "isBalanced" BOOLEAN NULL, "itemCount" REAL NULL, "quantitiesTotal" REAL NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)EGER NULL, "storeWRNTYId" BIGINT NULL DEFAULT 0, "contactPerson" INTEGER NULL, "contactPersonWRNTYId" BIGINT NULL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "reminder" DATE NULL, "useReminder" BOOLEAN NULL, "status" INTEGER NULL, "priority" INTEGER NULL, "lastAssignerFullName" TEXT NULL, "creator" INTEGER NULL, "creatorWRNTYId" BIGINT NULL DEFAULT 0, "notes" TEXT NULL, "assignmentNotes" BLOB NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "creator_fk" FOREIGN KEY ("creator") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED)ULL DEFAULT 0, "unitOfMeasure" INTEGER NULL, "unitOfMeasureWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "brand_fk" FOREIGN KEY ("brand") REFERENCES "CPIBrand" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "parentPortfolioItem_fk" FOREIGN KEY ("parentPortfolioItem") REFERENCES "CPIPortfolioItem" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "campaign_fk" FOREIGN KEY ("campaign") REFERENCES "CPICampaign" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "piColor_fk" FOREIGN KEY ("piColor") REFERENCES "CPIPIColor" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "piSize_fk" FOREIGN KEY ("piSize") REFERENCES "CPIPISize" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "defaultBox_fk" FOREIGN KEY ("defaultBox") REFERENCES "CPIBox" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "unitOfMeasure_fk" FOREIGN KEY ("unitOfMeasure") REFERENCES "CPIUnitOfMeasure" ("dbID") DEFERRABLE INITIALLY DEFERRED)€NULL, "priceListWholeSaleCurrencySymbol" TEXT NULL, "classForItem" TEXT NULL, "subClass" TEXT NULL, "collection" TEXT NULL, "setForItem" TEXT NULL, "instructionsURL" TEXT NULL, "longDescription" TEXT NULL, "tsAttributes" BLOB NULL, "creationDate" INT_DATETIME NULL, "futureInventoryDate" INT_DATETIME NULL, "futureInventoryQuantity" REAL NULL, "hasFutureInventory" BOOLEAN NULL, "costPrice" REAL NULL, "hasAdditionalInstructionsFiles" BOOLEAN NULL, "minQuantity" REAL NULL, "caseQuantity" REAL NULL, "boolFieldsBitMask" INTEGER NOT NULL, "entityType" INTEGER NULL, "brand" INTEGER NULL, "brandWRNTYId" BIGINT NULL DEFAULT 0, "parentPortfolioItem" INTEGER NULL, "parentPortfolioItemWRNTYId" BIGINT NULL DEFAULT 0, "campaign" INTEGER NULL, "campaignWRNTYId" BIGINT NULL DEFAULT 0, "piColor" INTEGER NULL, "piColorWRNTYId" BIGINT NULL DEFAULT 0, "piSize" INTEGER NULL, "piSizeWRNTYId" BIGINT NULL DEFAULT 0, "defaultBox" INTEGER NULL, "defaultBoxWRNTYId" BIGINT NER NULL, "storeSalesUseSalesPeriod" BOOLEAN NULL, "storeSalesPeriodQuantity" INTEGER NULL, "storeSalesPeriod" TEXT NULL, "storeSalesLocation" TEXT NULL, "useRetailPriceFilter" BOOLEAN NULL, "retailPriceUseRange" BOOLEAN NULL, "retailPriceOperator" TEXT NULL, "retailPriceOperand" REAL NULL, "retailPriceRangeFromValue" REAL NULL, "retailPriceRangeToValue" REAL NULL, "useDistributorInventoryFilter" BOOLEAN NULL, "distributorInventoryOperator" TEXT NULL, "distributorInventoryOperand" INTEGER NULL, "useStoreInventoryFilter" BOOLEAN NULL, "storeInventoryOperator" TEXT NULL, "storeInventoryOperand" INTEGER NULL, "orderOfAppearance" INTEGER NULL, "sortedPortfolioItems" BLOB NULL, "useChildrenProperties" BOOLEAN NULL, "isCatalogFilter" BOOLEAN NULL, "belongsToCatalog" INTEGER NULL, "belongsToCatalogWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "belongsToCatalog_fk" FOREIGN KEY ("belongsToCatalog") REFERENCES "CPICatalog" ("dbID") DEFERRABLE INITIALLY DEFERRED) lExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "isCompleted" BOOLEAN NULL, "repeatEndDate" DATE NULL, "repeatType" INTEGER NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)rgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "isCompleted" BOOLEAN NULL, "repeatEndDate" DATE NULL, "repeatType" INTEGER NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED)Site" TEXT NULL, "billingContactDetailsWorkPhone" TEXT NULL, "currencySymbol" TEXT NULL, "externalData" TEXT NULL, "catalog" INTEGER NULL, "catalogWRNTYId" BIGINT NULL DEFAULT 0, CONSTRAINT "store_fk" FOREIGN KEY ("store") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "contactPerson_fk" FOREIGN KEY ("contactPerson") REFERENCES "CPIContactPerson" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "performer_fk" FOREIGN KEY ("performer") REFERENCES "CPIEmployee" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "activityTypeDefinition_fk" FOREIGN KEY ("activityTypeDefinition") REFERENCES "CPIActivityTypeDefinition" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "additionalStore_fk" FOREIGN KEY ("additionalStore") REFERENCES "CPIStore" ("dbID") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "catalog_fk" FOREIGN KEY ("catalog") REFERENCES "CPICatalog" ("dbID") DEFERRABLE INITIALLY DEFERRED)ˆLL DEFAULT 0, "performer" INTEGER NULL, "performerWRNTYId" BIGINT NULL DEFAULT 0, "activityTypeDefinition" INTEGER NULL, "activityTypeDefinitionWRNTYId" BIGINT NULL DEFAULT 0, "additionalStore" INTEGER NULL, "additionalStoreWRNTYId" BIGINT NULL DEFAULT 0, "property1" TEXT NULL, "latitude" REAL NULL, "longitude" REAL NULL, "locationSet" BOOLEAN NULL, "tsAttributes" BLOB NULL, "storeTSAttributes" BLOB NULL, "storeProp1" TEXT NULL, "storeProp2" TEXT NULL, "storeProp3" TEXT NULL, "storeProp4" TEXT NULL, "storeProp5" TEXT NULL, "externalID" TEXT NULL, "distStoreOrgRelExternalID" TEXT NULL, "actionDate" INT_DATETIME NULL, "deliveryDate" DATE NULL, "deliveryMethod" TEXT NULL, "lastStatusChange" INT_DATETIME NULL, "calendarEventID" TEXT NULL, "creationDate" INT_DATETIME NULL, "status" INTEGER NULL, "clientOrderID" TEXT NULL, "bank" TEXT NULL, "discount" REAL NULL, "clientExternalID" TEXT NULL, "insurance" TEXT NULL, "payment" TEXT NULL, "paymentTer†ms" TEXT NULL, "shipTo" TEXT NULL, "shipmentAddress" TEXT NULL, "shipmentCity" TEXT NULL, "shipmentCountry" TEXT NULL, "shipmentCountryISOAlpha2Code" TEXT NULL, "shipmentState" TEXT NULL, "shipmentStateISOAlpha2Code" TEXT NULL, "shipmentZipcode" TEXT NULL, "govIssuedID" TEXT NULL, "shippingContactDetailsCellular" TEXT NULL, "shippingContactDetailsEmail" TEXT NULL, "shippingContactDetailsFax" TEXT NULL, "shippingContactDetailsHomePhone" TEXT NULL, "shippingContactDetailsWebSite" TEXT NULL, "shippingContactDetailsWorkPhone" TEXT NULL, "billTo" TEXT NULL, "billingAddress" TEXT NULL, "billingCity" TEXT NULL, "billingCountry" TEXT NULL, "billingCountryISOAlpha2Code" TEXT NULL, "billingState" TEXT NULL, "billingStateISOAlpha2Code" TEXT NULL, "billingZipcode" TEXT NULL, "billingContactDetailsCellular" TEXT NULL, "billingContactDetailsEmail" TEXT NULL, "billingContactDetailsFax" TEXT NULL, "billingContactDetailsHomePhone" TEXT NULL, "billingContactDetailsWeb ššƒƒxwvuusrqp„onmlkjihgfed……„cb‡a`_^]\[ZZXyWVUTSRQPOONLKJIHGFEDCBA@?>><|;:‚97654331z0/.-,++)('&{|%$#"! ‚~ ‚ct55„gtableCPICustomizationFileCPICustomizationFileƒCREATE TABLE "CPICustomizationFile" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "ownerObjectType" INTEGER NULL, "fileType" TEXT NULL, "requiredOperationType" TEXT NULL, "fileName" TEXT NULL, "customName" TEXT NULL, "desc" TEXT NULL)