SQLite format 3@ _N-% _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, "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) AA!tableCPITypeSafeAttributeConfigCPITypeSafeAttributeConfigCREATE 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)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)/// 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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)11)tableCPIImageToDownloadCPIImageToDownloadCREATE TABLE "CPIImageToDownload" ( "dbID" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ownerObjectwrntyID" BIGINT NULL DEFAULT 0, "imageType" INTEGER NOT NULL, "modificationDate" INT_DATETIME NULL)*))tableschema_versionschema_versionCREATE TABLE "schema_version" ( "name" TEXT NOT NULL PRIMARY KEY, "version" INTEGER NOT NULL, "migration" INTEGER NOT NULL)XOQIMCJ@D>=9/1+&##            rr\^,C*))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_version11)tableCPIImageToDownloadCPIImageToDownloadCREATE TABLE "CPIImageToDownload" ( "dbID" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ownerObjectwrntyID" BIGINT NULL DEFAULT 0, "imageType" INTEGER NOT NULL, "modificationDate" INT_DATETIME NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/// 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##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!tableCPITypeSafeAttributeConfigCPITypeSafeAttributeConfigCREATE 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)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, "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) ii : [ #?;'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)N ''[tableCPIAssignmentCPIAssignment CREATE TABLE "CPIAssignment" ( "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, "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) --otableCPIChangedObjectCPIChangedObject CREATE 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)- ##!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)       *_ z<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 DEFA'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)7ItableCPIBoxCPIBoxCREATE 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)o++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_boxItems" ("object_id") 55ctablebox_boxItem_relationbox_boxItem_relationCREATE TABLE "box_boxItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)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)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") DEFERRABLE INITIALLY DEFERRED)?SSetableCPIUnitOfMeasure_unitOfMeasureItemsCPIUnitOfMeasure_unitOfMeasureItemsCREATE 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)VkS{indexCPIUnitOfMeasure_unitOfMeasureItems_object_id_iCPIUnitOfMeasure_unitOfMeasureItemsCREATE INDEX "CPIUnitOfMeasure_unitOfMeasureItems_object_id_i" ON "CPIUnitOfMeasure_unitOfMeasureItems" ("object_id")heetableunitOfMeasureItem_UnitOfMeasureItem_relationunitOfMeasureItem_UnitOfMeasureItem_relationCREATE TABLE "unitOfMeasureItem_UnitOfMeasureItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)            : :u--tableCPIPortfolioItemCPIPortfolioItemCREATE 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 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 NULL 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)J??#tableCPIPriceListPortfolioItemCPIPriceListPortfolioItemCREATE 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)CUUitableCPIPriceList_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)     ffC% Bb&"S;KindexCPIStore_contactPersons_object_id_iCPIStore_contactPersons(CREATE INDEX "CPIStore_contactPersons_object_id_i" ON "CPIStore_contactPersons" ("object_id")!;;5tableCPIStore_contactPersonsCPIStore_contactPersons'CREATE TABLE "CPIStore_contacZmUindexCPIPriceList_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) --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)P 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_DATETIME 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)!;;5tableCPIStore_contactPersonsCPIStore_contactPersons'CREATE 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_contactPersons(CREATE INDEX "CPIStore_contactPersons_object_id_i" ON "CPIStore_contactPersons" ("object_id");#GGutablestore_contactPersons_relationstore_contactPersons_relation)CREATE TABLE "store_contactPersons_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)        66 22 $//ktableCPIStorePortfolioCPIStorePortfolio*CREATE 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)X%tableCPIAgentCPIAgent,CREATE 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, "orderPriceCalculationFormula" 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)K&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" INTEGER 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)    ^^a|% Qa355atableCPITarget_subTargetsCPITarget_subTargets;CREATE 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)z2CtableCPITargetCPITarget:CREATE 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)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-/indexCPIFilter_brands_object_id_iCPIFilter_brands0CREATE INDEX "CPIFilter_brands_object_id_i" ON "CPIFilter_brands" ("object_id"))33%tableCPIFilter_campaignsCPIFilter_campaigns1CREATE 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)*K3;indexCPIFilter_campaigns_object_id_iCPIFilter_campaigns2CREATE INDEX "CPIFilter_campaigns_object_id_i" ON "CPIFilter_campaigns" ("object_id")&+99gtablefilter_brands_relationfilter_brands_relation3CREATE TABLE "filter_brands_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)/,??mtablefilter_campaigns_relationfilter_campaigns_relation4CREATE TABLE "filter_campaigns_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)c-!!tableCPICatalogCPICatalog5CREATE 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).!!QtableCPICountryCPICountry6CREATE 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) /!!atableCPIMessageCPIMessage7CREATE 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)&0tableCPIStateCPIState8CREATE 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)1%%ItableCPISubTargetCPISubTarget9CREATE 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)              Ft &  ~Tjf9CCtableCPIStockTakingPortfolioItemCPIStockTakingPortfolioItemBCREATE 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)e877itableCPIPortfolioItemGroupCPIPortfolioItemGroupACREATE TABLE "CPIPortfolioItemGroup" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMz2CtableCPITargetCPITarget:CREATE 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)355atableCPITarget_subTargetsCPITarget_subTargets;CREATE 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)4M5?indexCPITarget_subTargets_object_id_iCPITarget_subTargetsCREATE INDEX "CPITarget_subTargets_index_i" ON "CPITarget_subTargets" ("index")/6??mtabletarget_subTarget_relationtarget_subTarget_relation?CREATE TABLE "target_subTarget_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)m777ytableCPIStorePropertyColorCPIStorePropertyColor@CREATE TABLE "CPIStorePropertyColor" ( "wrntyID" BIGINT NULL DEFAULT 0, "hidden" BOOLEAN NULL, "dbID" INTEGER NOT NULL PRIMARY KEY, "color" INTEGER NULL, "value" TEXT NULL)e877itableCPIPortfolioItemGroupCPIPortfolioItemGroupACREATE 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)9CCtableCPIStockTakingPortfolioItemCPIStockTakingPortfolioItemBCREATE 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)          D:))CtableCPIStockTakingCPIStockTakingCCREATE 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, "actionDate" 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)S;]]ytableCPIStockTaking_stockTakingPortfolioItemsCPIStockTaking_stockTakingPortfolioItemsECREATE 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_stockTakingPortfolioItemsFCREATE INDEX "CPIStockTaking_stockTakingPortfolioItems_object_id_i" ON "CPIStockTaking_stockTakingPortfolioItems" ("object_id")k=ggtablestockTaking_stockTakingPortfolioItem_relationstockTaking_stockTakingPortfolioItem_relationGCREATE TABLE "stockTaking_stockTakingPortfolioItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)x>''/tableCPIStoreStockCPIStoreStockHCREATE 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)       s gc.@%%tableCPIOrderItemCPIOrderItemKCREATE 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, "unitOfMeasureItem" 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, "tsA?==1tableCPIStoreCatalogPriceListCPIStoreCatalogPriceListICREATE 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).@%%tableCPIOrderItemCPIOrderItemKCREATE 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, "unitOfMeasureItem" 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)    g0A3tableCPIOrderCPIOrderLCREATE 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 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, "status" INTEGER NULL, "clientOrderID" TEXT NULL, "bank" TEXT NULL, "discount" REAL NULL, "clientExternalID" TEXT NULL, "insurance" TEXT NULL, "payment" TEXT NULL, "paymentTerms" 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, "billingContactDetailsWebSite" 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)B33%tableCPIOrder_orderItemsCPIOrder_orderItemsNCREATE 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)CK3;indexCPIOrder_orderItems_object_id_iCPIOrder_orderItemsOCREATE INDEX "CPIOrder_orderItems_object_id_i" ON "CPIOrder_orderItems" ("object_id")    w,D==ktableorder_orderItem_relationorder_orderItem_relationPCREATE TABLE "order_orderItem_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)eE!tableCPISaleCPISaleRCREATE 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){F!!AtableCPIPaymentCPIPaymentSCREATE 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)'G++tableCPIOnlineActionCPIOnlineActionTCREATE 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)H??EtableCPIActivityTypeDefinitionCPIActivityTypeDefinitionUCREATE 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)XI11[tableCPIGeneralActivityCPIGeneralActivityVCREATE 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, "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)       cTnjJ;;ktableCPICustomizedTargetItemCPICustomizedTargetItemWCREATE 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)K33)tableCPICustomizedTargetCPICustomizedTargetYCREATE 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)WL__}tableCPICustomizedTarget_customizedTargetItemsCPICustomizedTarget_customizedTargetItemsZCREATE 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)nMw_indexCPICustomizedTarget_customizedTargetItems_object_id_iCPICustomizedTarget_customizedTargetItems[CREATE INDEX "CPICustomizedTarget_customizedTargetItems_object_id_i" ON "CPICustomizedTarget_customizedTargetItems" ("object_id")N 1tablecustomizedtarget_customizedtarget_boxItem_relation_relationcustomizedtarget_customizedtarget_boxItem_relation_relation\CREATE TABLE "customizedtarget_customizedtarget_boxItem_relation_relation" ( "parentID" BIGINT NULL DEFAULT 0, "itemID" BIGINT NULL DEFAULT 0)OutableCPITaskCPITask]CREATE 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, "distStoreOrgRelExternalID" 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)       bP55gtableCPICustomizationFileCPICustomizationFile^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)