From 0481e12cb565a2b52e60f5910c76e12dd88ed0e1 Mon Sep 17 00:00:00 2001 From: Ahed Date: Thu, 4 Feb 2021 21:48:41 +0200 Subject: [PATCH] Add html tag to all files in xml/schema --- xml/schema/ACL/ACL.xml | 3 +++ xml/schema/ACL/Cache.xml | 3 +++ xml/schema/ACL/EntityRole.xml | 3 +++ xml/schema/Activity/Activity.xml | 3 +++ xml/schema/Activity/ActivityContact.xml | 3 +++ xml/schema/Batch/Batch.xml | 3 +++ xml/schema/Batch/EntityBatch.xml | 3 +++ xml/schema/Bridge/OG.xml | 3 +++ xml/schema/Bridge/Role.xml | 3 +++ xml/schema/Campaign/Campaign.xml | 3 +++ xml/schema/Campaign/CampaignGroup.xml | 3 +++ xml/schema/Campaign/Survey.xml | 3 +++ xml/schema/Case/Case.xml | 2 +- xml/schema/Case/CaseActivity.xml | 3 +++ xml/schema/Case/CaseContact.xml | 3 +++ xml/schema/Case/CaseType.xml | 3 +++ xml/schema/Contact/ACLContactCache.xml | 3 +++ xml/schema/Contact/Contact.xml | 3 +++ xml/schema/Contact/ContactType.xml | 3 +++ xml/schema/Contact/DashboardContact.xml | 3 +++ xml/schema/Contact/Group.xml | 3 +++ xml/schema/Contact/GroupContact.xml | 3 +++ xml/schema/Contact/GroupContactCache.xml | 3 +++ xml/schema/Contact/GroupNesting.xml | 3 +++ xml/schema/Contact/GroupOrganization.xml | 3 +++ xml/schema/Contact/Household.xml | 3 +++ xml/schema/Contact/Individual.xml | 3 +++ xml/schema/Contact/Organization.xml | 3 +++ xml/schema/Contact/Relationship.xml | 3 +++ xml/schema/Contact/RelationshipCache.xml | 3 +++ xml/schema/Contact/RelationshipType.xml | 3 +++ xml/schema/Contact/SavedSearch.xml | 3 +++ xml/schema/Contact/SubscriptionHistory.xml | 3 +++ xml/schema/Contribute/Contribution.xml | 2 +- xml/schema/Contribute/ContributionPage.xml | 3 +++ xml/schema/Contribute/ContributionProduct.xml | 3 +++ xml/schema/Contribute/ContributionRecur.xml | 3 +++ xml/schema/Contribute/ContributionSoft.xml | 3 +++ xml/schema/Contribute/Premium.xml | 3 +++ xml/schema/Contribute/PremiumsProduct.xml | 3 +++ xml/schema/Contribute/Product.xml | 3 +++ xml/schema/Contribute/Widget.xml | 3 +++ xml/schema/Core/ActionLog.xml | 3 +++ xml/schema/Core/ActionMapping.xml | 3 +++ xml/schema/Core/ActionSchedule.xml | 3 +++ xml/schema/Core/Address.xml | 3 +++ xml/schema/Core/AddressFormat.xml | 3 +++ xml/schema/Core/Cache.xml | 3 +++ xml/schema/Core/Component.xml | 3 +++ xml/schema/Core/Country.xml | 3 +++ xml/schema/Core/County.xml | 3 +++ xml/schema/Core/CustomField.xml | 3 +++ xml/schema/Core/CustomGroup.xml | 3 +++ xml/schema/Core/Dashboard.xml | 3 +++ xml/schema/Core/Discount.xml | 3 +++ xml/schema/Core/Domain.xml | 3 +++ xml/schema/Core/Email.xml | 3 +++ xml/schema/Core/EntityFile.xml | 3 +++ xml/schema/Core/EntityTag.xml | 3 +++ xml/schema/Core/Extension.xml | 3 +++ xml/schema/Core/File.xml | 3 +++ xml/schema/Core/IM.xml | 3 +++ xml/schema/Core/Job.xml | 3 +++ xml/schema/Core/JobLog.xml | 3 +++ xml/schema/Core/LocBlock.xml | 3 +++ xml/schema/Core/LocationType.xml | 3 +++ xml/schema/Core/Log.xml | 3 +++ xml/schema/Core/MailSettings.xml | 3 +++ xml/schema/Core/Managed.xml | 3 +++ xml/schema/Core/Mapping.xml | 3 +++ xml/schema/Core/MappingField.xml | 3 +++ xml/schema/Core/Menu.xml | 3 +++ xml/schema/Core/MessageTemplate.xml | 3 +++ xml/schema/Core/Navigation.xml | 3 +++ xml/schema/Core/Note.xml | 3 +++ xml/schema/Core/OpenID.xml | 3 +++ xml/schema/Core/OptionGroup.xml | 3 +++ xml/schema/Core/OptionValue.xml | 3 +++ xml/schema/Core/Persistent.xml | 3 +++ xml/schema/Core/Phone.xml | 3 +++ xml/schema/Core/Preferences.xml | 3 +++ xml/schema/Core/PreferencesDate.xml | 3 +++ xml/schema/Core/PrevNextCache.xml | 3 +++ xml/schema/Core/PrintLabel.xml | 3 +++ xml/schema/Core/RecurringEntity.xml | 3 +++ xml/schema/Core/Setting.xml | 3 +++ xml/schema/Core/StateProvince.xml | 3 +++ xml/schema/Core/StatusPreference.xml | 3 +++ xml/schema/Core/SystemLog.xml | 3 +++ xml/schema/Core/Tag.xml | 3 +++ xml/schema/Core/Timezone.xml | 3 +++ xml/schema/Core/UFField.xml | 3 +++ xml/schema/Core/UFGroup.xml | 3 +++ xml/schema/Core/UFJoin.xml | 3 +++ xml/schema/Core/UFMatch.xml | 3 +++ xml/schema/Core/Website.xml | 3 +++ xml/schema/Core/WordReplacement.xml | 3 +++ xml/schema/Core/Worldregion.xml | 3 +++ xml/schema/Cxn/Cxn.xml | 3 +++ xml/schema/Dedupe/Exception.xml | 3 +++ xml/schema/Dedupe/Rule.xml | 3 +++ xml/schema/Dedupe/RuleGroup.xml | 3 +++ xml/schema/Event/Cart/Cart.xml | 3 +++ xml/schema/Event/Cart/EventInCart.xml | 3 +++ xml/schema/Event/Event.xml | 3 +++ xml/schema/Event/Participant.xml | 3 +++ xml/schema/Event/ParticipantPayment.xml | 3 +++ xml/schema/Event/ParticipantStatusType.xml | 3 +++ xml/schema/Financial/Currency.xml | 3 +++ xml/schema/Financial/EntityFinancialAccount.xml | 3 +++ xml/schema/Financial/EntityFinancialTrxn.xml | 3 +++ xml/schema/Financial/FinancialAccount.xml | 3 +++ xml/schema/Financial/FinancialItem.xml | 3 +++ xml/schema/Financial/FinancialTrxn.xml | 3 +++ xml/schema/Financial/FinancialType.xml | 3 +++ xml/schema/Financial/PaymentProcessor.xml | 3 +++ xml/schema/Financial/PaymentProcessorType.xml | 3 +++ xml/schema/Financial/PaymentToken.xml | 3 +++ xml/schema/Friend/Friend.xml | 3 +++ xml/schema/Grant/Grant.xml | 3 +++ xml/schema/Mailing/BouncePattern.xml | 3 +++ xml/schema/Mailing/BounceType.xml | 3 +++ xml/schema/Mailing/Component.xml | 3 +++ xml/schema/Mailing/Event/Bounce.xml | 3 +++ xml/schema/Mailing/Event/Confirm.xml | 3 +++ xml/schema/Mailing/Event/Delivered.xml | 3 +++ xml/schema/Mailing/Event/Forward.xml | 3 +++ xml/schema/Mailing/Event/Opened.xml | 3 +++ xml/schema/Mailing/Event/Queue.xml | 3 +++ xml/schema/Mailing/Event/Reply.xml | 3 +++ xml/schema/Mailing/Event/Subscribe.xml | 3 +++ xml/schema/Mailing/Event/TrackableURLOpen.xml | 3 +++ xml/schema/Mailing/Event/Unsubscribe.xml | 3 +++ xml/schema/Mailing/Mailing.xml | 3 +++ xml/schema/Mailing/MailingAB.xml | 3 +++ xml/schema/Mailing/MailingGroup.xml | 3 +++ xml/schema/Mailing/MailingJob.xml | 3 +++ xml/schema/Mailing/Recipients.xml | 3 +++ xml/schema/Mailing/Spool.xml | 3 +++ xml/schema/Mailing/TrackableURL.xml | 3 +++ xml/schema/Member/Membership.xml | 3 +++ xml/schema/Member/MembershipBlock.xml | 3 +++ xml/schema/Member/MembershipLog.xml | 3 +++ xml/schema/Member/MembershipPayment.xml | 3 +++ xml/schema/Member/MembershipStatus.xml | 3 +++ xml/schema/Member/MembershipType.xml | 3 +++ xml/schema/PCP/PCP.xml | 3 +++ xml/schema/PCP/PCPBlock.xml | 3 +++ xml/schema/Pledge/Pledge.xml | 3 +++ xml/schema/Pledge/PledgeBlock.xml | 3 +++ xml/schema/Pledge/PledgePayment.xml | 3 +++ xml/schema/Price/LineItem.xml | 3 +++ xml/schema/Price/PriceField.xml | 3 +++ xml/schema/Price/PriceFieldValue.xml | 3 +++ xml/schema/Price/PriceSet.xml | 4 ++-- xml/schema/Price/PriceSetEntity.xml | 3 +++ xml/schema/Queue/QueueItem.xml | 3 +++ xml/schema/Report/ReportInstance.xml | 3 +++ xml/schema/SMS/History.xml | 3 +++ xml/schema/SMS/Provider.xml | 3 +++ 160 files changed, 475 insertions(+), 4 deletions(-) diff --git a/xml/schema/ACL/ACL.xml b/xml/schema/ACL/ACL.xml index 8353d97944..181de7b37e 100644 --- a/xml/schema/ACL/ACL.xml +++ b/xml/schema/ACL/ACL.xml @@ -12,6 +12,9 @@ int unsigned true Unique table ID + + Number + 1.6 diff --git a/xml/schema/ACL/Cache.xml b/xml/schema/ACL/Cache.xml index 8b54897737..93bb5b823f 100644 --- a/xml/schema/ACL/Cache.xml +++ b/xml/schema/ACL/Cache.xml @@ -12,6 +12,9 @@ int unsigned true Unique table ID + + Number + 1.6 diff --git a/xml/schema/ACL/EntityRole.xml b/xml/schema/ACL/EntityRole.xml index 5d7958b729..8679d27fc8 100644 --- a/xml/schema/ACL/EntityRole.xml +++ b/xml/schema/ACL/EntityRole.xml @@ -12,6 +12,9 @@ Entity Role true Unique table ID + + Number + 1.6 diff --git a/xml/schema/Activity/Activity.xml b/xml/schema/Activity/Activity.xml index 74f1624864..f80e5cfb52 100644 --- a/xml/schema/Activity/Activity.xml +++ b/xml/schema/Activity/Activity.xml @@ -22,6 +22,9 @@ int unsigned true Unique Other Activity ID + + Number + 1.1 diff --git a/xml/schema/Activity/ActivityContact.xml b/xml/schema/Activity/ActivityContact.xml index dc33ce3050..53fc948504 100644 --- a/xml/schema/Activity/ActivityContact.xml +++ b/xml/schema/Activity/ActivityContact.xml @@ -13,6 +13,9 @@ Activity Contact ID true Activity contact id + + Number + 4.4 diff --git a/xml/schema/Batch/Batch.xml b/xml/schema/Batch/Batch.xml index 811ecf4f21..dd091ea937 100644 --- a/xml/schema/Batch/Batch.xml +++ b/xml/schema/Batch/Batch.xml @@ -12,6 +12,9 @@ int unsigned true Unique Address ID + + Number + 3.3 diff --git a/xml/schema/Batch/EntityBatch.xml b/xml/schema/Batch/EntityBatch.xml index 004289557d..d36cc0eefc 100644 --- a/xml/schema/Batch/EntityBatch.xml +++ b/xml/schema/Batch/EntityBatch.xml @@ -12,6 +12,9 @@ int unsigned true primary key + + Number + 3.3 diff --git a/xml/schema/Bridge/OG.xml b/xml/schema/Bridge/OG.xml index 14256e1f49..7fb1447cc9 100644 --- a/xml/schema/Bridge/OG.xml +++ b/xml/schema/Bridge/OG.xml @@ -11,6 +11,9 @@ int unsigned true Unique table ID + + Number + 2.0 diff --git a/xml/schema/Bridge/Role.xml b/xml/schema/Bridge/Role.xml index 52f01cde2a..bb9c3a38da 100644 --- a/xml/schema/Bridge/Role.xml +++ b/xml/schema/Bridge/Role.xml @@ -11,6 +11,9 @@ int unsigned true Unique table ID + + Number + 2.0 diff --git a/xml/schema/Campaign/Campaign.xml b/xml/schema/Campaign/Campaign.xml index 3610464350..1c69731844 100644 --- a/xml/schema/Campaign/Campaign.xml +++ b/xml/schema/Campaign/Campaign.xml @@ -20,6 +20,9 @@ true Unique Campaign ID. true + + Number + 3.3 diff --git a/xml/schema/Campaign/CampaignGroup.xml b/xml/schema/Campaign/CampaignGroup.xml index 1c1b408082..0cc9db8b9d 100644 --- a/xml/schema/Campaign/CampaignGroup.xml +++ b/xml/schema/Campaign/CampaignGroup.xml @@ -12,6 +12,9 @@ int unsigned true Campaign Group id. + + Number + 3.3 diff --git a/xml/schema/Campaign/Survey.xml b/xml/schema/Campaign/Survey.xml index bfe0cf95c0..c1e529249c 100644 --- a/xml/schema/Campaign/Survey.xml +++ b/xml/schema/Campaign/Survey.xml @@ -14,6 +14,9 @@ int unsigned true Survey id. + + Number + 3.3 diff --git a/xml/schema/Case/Case.xml b/xml/schema/Case/Case.xml index 8ecbf21cd7..90c69086de 100644 --- a/xml/schema/Case/Case.xml +++ b/xml/schema/Case/Case.xml @@ -18,7 +18,7 @@ Case ID Unique Case ID - Text + Number 1.8 diff --git a/xml/schema/Case/CaseActivity.xml b/xml/schema/Case/CaseActivity.xml index 678e4eb89f..249a292149 100644 --- a/xml/schema/Case/CaseActivity.xml +++ b/xml/schema/Case/CaseActivity.xml @@ -13,6 +13,9 @@ int unsigned true Unique case-activity association id + + Number + 1.8 diff --git a/xml/schema/Case/CaseContact.xml b/xml/schema/Case/CaseContact.xml index 0ddfc379a0..e4c1382655 100644 --- a/xml/schema/Case/CaseContact.xml +++ b/xml/schema/Case/CaseContact.xml @@ -13,6 +13,9 @@ int unsigned true Unique case-contact association id + + Number + 2.1 diff --git a/xml/schema/Case/CaseType.xml b/xml/schema/Case/CaseType.xml index 99d40cd9ea..8640e62268 100644 --- a/xml/schema/Case/CaseType.xml +++ b/xml/schema/Case/CaseType.xml @@ -13,6 +13,9 @@ int unsigned true Autoincremented type id + + Number + 4.5 diff --git a/xml/schema/Contact/ACLContactCache.xml b/xml/schema/Contact/ACLContactCache.xml index 75603bdf57..470925a590 100644 --- a/xml/schema/Contact/ACLContactCache.xml +++ b/xml/schema/Contact/ACLContactCache.xml @@ -12,6 +12,9 @@ int unsigned true primary key + + Number + 3.1 diff --git a/xml/schema/Contact/Contact.xml b/xml/schema/Contact/Contact.xml index 33c33703c2..33a7f642a3 100644 --- a/xml/schema/Contact/Contact.xml +++ b/xml/schema/Contact/Contact.xml @@ -23,6 +23,9 @@ /internal|contact?|id$/i true Unique Contact ID + + Number + 1.1 diff --git a/xml/schema/Contact/ContactType.xml b/xml/schema/Contact/ContactType.xml index a09c6e1424..29f1524a44 100644 --- a/xml/schema/Contact/ContactType.xml +++ b/xml/schema/Contact/ContactType.xml @@ -12,6 +12,9 @@ int unsigned true Contact Type ID + + Number + 1.1 diff --git a/xml/schema/Contact/DashboardContact.xml b/xml/schema/Contact/DashboardContact.xml index 9ec01e202e..55a9085011 100644 --- a/xml/schema/Contact/DashboardContact.xml +++ b/xml/schema/Contact/DashboardContact.xml @@ -11,6 +11,9 @@ int unsigned Dashboard Contact ID true + + Number + 3.1 diff --git a/xml/schema/Contact/Group.xml b/xml/schema/Contact/Group.xml index 9dfd7fc857..4b7e03a115 100644 --- a/xml/schema/Contact/Group.xml +++ b/xml/schema/Contact/Group.xml @@ -18,6 +18,9 @@ Group ID true Group ID + + Number + 1.1 diff --git a/xml/schema/Contact/GroupContact.xml b/xml/schema/Contact/GroupContact.xml index 304be14a0a..94897930ad 100644 --- a/xml/schema/Contact/GroupContact.xml +++ b/xml/schema/Contact/GroupContact.xml @@ -13,6 +13,9 @@ Group Contact ID true primary key + + Number + 1.1 diff --git a/xml/schema/Contact/GroupContactCache.xml b/xml/schema/Contact/GroupContactCache.xml index 22e92fd4bd..5c1aa70565 100644 --- a/xml/schema/Contact/GroupContactCache.xml +++ b/xml/schema/Contact/GroupContactCache.xml @@ -12,6 +12,9 @@ int unsigned true primary key + + Number + 2.1 diff --git a/xml/schema/Contact/GroupNesting.xml b/xml/schema/Contact/GroupNesting.xml index cad890eb27..4a8a07b083 100644 --- a/xml/schema/Contact/GroupNesting.xml +++ b/xml/schema/Contact/GroupNesting.xml @@ -13,6 +13,9 @@ int unsigned true Relationship ID + + Number + 2.0 diff --git a/xml/schema/Contact/GroupOrganization.xml b/xml/schema/Contact/GroupOrganization.xml index 938717148f..b44dbea2ce 100644 --- a/xml/schema/Contact/GroupOrganization.xml +++ b/xml/schema/Contact/GroupOrganization.xml @@ -13,6 +13,9 @@ int unsigned true Relationship ID + + Number + 2.0 diff --git a/xml/schema/Contact/Household.xml b/xml/schema/Contact/Household.xml index 89f4216792..3c545045ff 100644 --- a/xml/schema/Contact/Household.xml +++ b/xml/schema/Contact/Household.xml @@ -12,6 +12,9 @@ int unsigned true Unique Household ID + + Number + 1.1 diff --git a/xml/schema/Contact/Individual.xml b/xml/schema/Contact/Individual.xml index 9956f17beb..4bfe467573 100644 --- a/xml/schema/Contact/Individual.xml +++ b/xml/schema/Contact/Individual.xml @@ -12,6 +12,9 @@ int unsigned true Unique Individual ID + + Number + 1.1 diff --git a/xml/schema/Contact/Organization.xml b/xml/schema/Contact/Organization.xml index bb5c88b827..b566730ca0 100644 --- a/xml/schema/Contact/Organization.xml +++ b/xml/schema/Contact/Organization.xml @@ -12,6 +12,9 @@ int unsigned true Unique Organization ID + + Number + 1.1 diff --git a/xml/schema/Contact/Relationship.xml b/xml/schema/Contact/Relationship.xml index f5c1aa04e7..1cc609aabd 100644 --- a/xml/schema/Contact/Relationship.xml +++ b/xml/schema/Contact/Relationship.xml @@ -14,6 +14,9 @@ Relationship ID true Relationship ID + + Number + 1.1 diff --git a/xml/schema/Contact/RelationshipCache.xml b/xml/schema/Contact/RelationshipCache.xml index 023e21e2b2..a77c2a322c 100644 --- a/xml/schema/Contact/RelationshipCache.xml +++ b/xml/schema/Contact/RelationshipCache.xml @@ -15,6 +15,9 @@ Relationship Cache ID true Relationship Cache ID + + Number + 5.29 diff --git a/xml/schema/Contact/RelationshipType.xml b/xml/schema/Contact/RelationshipType.xml index 183c3594c7..c55db740c4 100644 --- a/xml/schema/Contact/RelationshipType.xml +++ b/xml/schema/Contact/RelationshipType.xml @@ -13,6 +13,9 @@ Relationship Type ID true Primary key + + Number + 1.1 diff --git a/xml/schema/Contact/SavedSearch.xml b/xml/schema/Contact/SavedSearch.xml index 1edf5f9ac9..04faabed09 100644 --- a/xml/schema/Contact/SavedSearch.xml +++ b/xml/schema/Contact/SavedSearch.xml @@ -12,6 +12,9 @@ Saved Search ID true Saved Search ID + + Number + 1.1 diff --git a/xml/schema/Contact/SubscriptionHistory.xml b/xml/schema/Contact/SubscriptionHistory.xml index 4e93766e70..45a894604c 100644 --- a/xml/schema/Contact/SubscriptionHistory.xml +++ b/xml/schema/Contact/SubscriptionHistory.xml @@ -13,6 +13,9 @@ int unsigned true Internal Id + + Number + 1.1 diff --git a/xml/schema/Contribute/Contribution.xml b/xml/schema/Contribute/Contribution.xml index b09ee78061..b19782b179 100644 --- a/xml/schema/Contribute/Contribution.xml +++ b/xml/schema/Contribute/Contribution.xml @@ -23,7 +23,7 @@ Contribution ID Contribution ID - Text + Number 1.3 diff --git a/xml/schema/Contribute/ContributionPage.xml b/xml/schema/Contribute/ContributionPage.xml index 52f1df5eab..e5a48084d6 100644 --- a/xml/schema/Contribute/ContributionPage.xml +++ b/xml/schema/Contribute/ContributionPage.xml @@ -15,6 +15,9 @@ int unsigned true Contribution Id + + Number + 1.3 diff --git a/xml/schema/Contribute/ContributionProduct.xml b/xml/schema/Contribute/ContributionProduct.xml index 2f9d253e2a..2cd3917c76 100644 --- a/xml/schema/Contribute/ContributionProduct.xml +++ b/xml/schema/Contribute/ContributionProduct.xml @@ -12,6 +12,9 @@ Contribution Product ID int unsigned true + + Number + 1.4 diff --git a/xml/schema/Contribute/ContributionRecur.xml b/xml/schema/Contribute/ContributionRecur.xml index fd6b8a948c..a628d939ef 100644 --- a/xml/schema/Contribute/ContributionRecur.xml +++ b/xml/schema/Contribute/ContributionRecur.xml @@ -14,6 +14,9 @@ int unsigned true Contribution Recur ID + + Number + 1.6 diff --git a/xml/schema/Contribute/ContributionSoft.xml b/xml/schema/Contribute/ContributionSoft.xml index 62144ff625..2a21fc2c22 100644 --- a/xml/schema/Contribute/ContributionSoft.xml +++ b/xml/schema/Contribute/ContributionSoft.xml @@ -20,6 +20,9 @@ true Soft Credit ID Soft Credit ID + + Number + 2.2 diff --git a/xml/schema/Contribute/Premium.xml b/xml/schema/Contribute/Premium.xml index aaea0628d0..469b62450f 100644 --- a/xml/schema/Contribute/Premium.xml +++ b/xml/schema/Contribute/Premium.xml @@ -13,6 +13,9 @@ Premium ID int unsigned true + + Number + 1.4 diff --git a/xml/schema/Contribute/PremiumsProduct.xml b/xml/schema/Contribute/PremiumsProduct.xml index 8e88bd7574..4731ba25f8 100644 --- a/xml/schema/Contribute/PremiumsProduct.xml +++ b/xml/schema/Contribute/PremiumsProduct.xml @@ -16,6 +16,9 @@ int unsigned true Contribution ID + + Number + 1.4 diff --git a/xml/schema/Contribute/Product.xml b/xml/schema/Contribute/Product.xml index e75c938d86..e24dbe28ea 100644 --- a/xml/schema/Contribute/Product.xml +++ b/xml/schema/Contribute/Product.xml @@ -14,6 +14,9 @@ Product ID int unsigned true + + Number + 1.4 diff --git a/xml/schema/Contribute/Widget.xml b/xml/schema/Contribute/Widget.xml index d9ebeb77e1..67c27eb59f 100644 --- a/xml/schema/Contribute/Widget.xml +++ b/xml/schema/Contribute/Widget.xml @@ -14,6 +14,9 @@ int unsigned true Contribution Id + + Number + 2.0 diff --git a/xml/schema/Core/ActionLog.xml b/xml/schema/Core/ActionLog.xml index 7c3e7a439b..d340db88cf 100644 --- a/xml/schema/Core/ActionLog.xml +++ b/xml/schema/Core/ActionLog.xml @@ -11,6 +11,9 @@ Action Schedule ID int unsigned true + + Number + 3.4 diff --git a/xml/schema/Core/ActionMapping.xml b/xml/schema/Core/ActionMapping.xml index 5ce84e6611..c646932245 100644 --- a/xml/schema/Core/ActionMapping.xml +++ b/xml/schema/Core/ActionMapping.xml @@ -11,6 +11,9 @@ Action Mapping ID int unsigned true + + Number + 3.4 diff --git a/xml/schema/Core/ActionSchedule.xml b/xml/schema/Core/ActionSchedule.xml index 4bd9a20f1d..c582667bae 100644 --- a/xml/schema/Core/ActionSchedule.xml +++ b/xml/schema/Core/ActionSchedule.xml @@ -11,6 +11,9 @@ Action Schedule ID int unsigned true + + Number + 3.4 diff --git a/xml/schema/Core/Address.xml b/xml/schema/Core/Address.xml index d4dd2a49df..13894c1b5f 100644 --- a/xml/schema/Core/Address.xml +++ b/xml/schema/Core/Address.xml @@ -16,6 +16,9 @@ Address ID true Unique Address ID + + Number + 1.1 diff --git a/xml/schema/Core/AddressFormat.xml b/xml/schema/Core/AddressFormat.xml index ae678018b9..41008e9481 100644 --- a/xml/schema/Core/AddressFormat.xml +++ b/xml/schema/Core/AddressFormat.xml @@ -11,6 +11,9 @@ int unsigned true Address Format Id + + Number + 3.2 diff --git a/xml/schema/Core/Cache.xml b/xml/schema/Core/Cache.xml index 1e8d9a389f..1a6222f280 100644 --- a/xml/schema/Core/Cache.xml +++ b/xml/schema/Core/Cache.xml @@ -12,6 +12,9 @@ int unsigned true Unique table ID + + Number + 2.1 diff --git a/xml/schema/Core/Component.xml b/xml/schema/Core/Component.xml index 8ccce97d86..0bcf27277f 100644 --- a/xml/schema/Core/Component.xml +++ b/xml/schema/Core/Component.xml @@ -11,6 +11,9 @@ int unsigned true Component ID + + Number + 2.0 diff --git a/xml/schema/Core/Country.xml b/xml/schema/Core/Country.xml index 051ce788ce..2390356c8f 100644 --- a/xml/schema/Core/Country.xml +++ b/xml/schema/Core/Country.xml @@ -12,6 +12,9 @@ int unsigned true Country Id + + Number + 1.1 diff --git a/xml/schema/Core/County.xml b/xml/schema/Core/County.xml index db959aa660..d143acc99a 100644 --- a/xml/schema/Core/County.xml +++ b/xml/schema/Core/County.xml @@ -12,6 +12,9 @@ int unsigned true County ID + + Number + 1.1 diff --git a/xml/schema/Core/CustomField.xml b/xml/schema/Core/CustomField.xml index 4232753f6f..c1c8bf02c3 100644 --- a/xml/schema/Core/CustomField.xml +++ b/xml/schema/Core/CustomField.xml @@ -14,6 +14,9 @@ Custom Field ID true Unique Custom Field ID + + Number + 1.1 diff --git a/xml/schema/Core/CustomGroup.xml b/xml/schema/Core/CustomGroup.xml index 018e05bd22..9ffea44fd2 100644 --- a/xml/schema/Core/CustomGroup.xml +++ b/xml/schema/Core/CustomGroup.xml @@ -15,6 +15,9 @@ Custom Group ID true Unique Custom Group ID + + Number + 1.1 diff --git a/xml/schema/Core/Dashboard.xml b/xml/schema/Core/Dashboard.xml index 39373d714b..e749be7e7a 100644 --- a/xml/schema/Core/Dashboard.xml +++ b/xml/schema/Core/Dashboard.xml @@ -11,6 +11,9 @@ int unsigned DashletID true + + Number + 3.1 diff --git a/xml/schema/Core/Discount.xml b/xml/schema/Core/Discount.xml index 54535e4857..3fd601dc64 100644 --- a/xml/schema/Core/Discount.xml +++ b/xml/schema/Core/Discount.xml @@ -13,6 +13,9 @@ int unsigned true primary key + + Number + 2.1 diff --git a/xml/schema/Core/Domain.xml b/xml/schema/Core/Domain.xml index 8e4e119a7f..f647dcc81c 100644 --- a/xml/schema/Core/Domain.xml +++ b/xml/schema/Core/Domain.xml @@ -12,6 +12,9 @@ int unsigned true Domain ID + + Number + 1.1 diff --git a/xml/schema/Core/Email.xml b/xml/schema/Core/Email.xml index 4a2bbe2615..6537d19b02 100644 --- a/xml/schema/Core/Email.xml +++ b/xml/schema/Core/Email.xml @@ -15,6 +15,9 @@ int unsigned true Unique Email ID + + Number + 1.1 diff --git a/xml/schema/Core/EntityFile.xml b/xml/schema/Core/EntityFile.xml index cad60ba916..4ebbd38a10 100644 --- a/xml/schema/Core/EntityFile.xml +++ b/xml/schema/Core/EntityFile.xml @@ -13,6 +13,9 @@ int unsigned true primary key + + Number + 1.5 diff --git a/xml/schema/Core/EntityTag.xml b/xml/schema/Core/EntityTag.xml index 301706a42b..f4699b88b8 100644 --- a/xml/schema/Core/EntityTag.xml +++ b/xml/schema/Core/EntityTag.xml @@ -13,6 +13,9 @@ Entity Tag ID true primary key + + Number + 1.1 diff --git a/xml/schema/Core/Extension.xml b/xml/schema/Core/Extension.xml index 673b379291..17d1374195 100644 --- a/xml/schema/Core/Extension.xml +++ b/xml/schema/Core/Extension.xml @@ -12,6 +12,9 @@ Extension ID true Local Extension ID + + Number + 4.2 diff --git a/xml/schema/Core/File.xml b/xml/schema/Core/File.xml index 925e1f6489..687c390aa3 100644 --- a/xml/schema/Core/File.xml +++ b/xml/schema/Core/File.xml @@ -13,6 +13,9 @@ File ID true Unique ID + + Number + 1.5 diff --git a/xml/schema/Core/IM.xml b/xml/schema/Core/IM.xml index f521fb645a..cf9d18539d 100644 --- a/xml/schema/Core/IM.xml +++ b/xml/schema/Core/IM.xml @@ -17,6 +17,9 @@ int unsigned true Unique IM ID + + Number + 1.1 diff --git a/xml/schema/Core/Job.xml b/xml/schema/Core/Job.xml index a135360f05..acb6a90197 100644 --- a/xml/schema/Core/Job.xml +++ b/xml/schema/Core/Job.xml @@ -13,6 +13,9 @@ int unsigned true Job Id + + Number + 4.1 diff --git a/xml/schema/Core/JobLog.xml b/xml/schema/Core/JobLog.xml index b47a752bbf..2d09187b09 100644 --- a/xml/schema/Core/JobLog.xml +++ b/xml/schema/Core/JobLog.xml @@ -13,6 +13,9 @@ true Job Log ID Job log entry Id + + Number + 4.1 diff --git a/xml/schema/Core/LocBlock.xml b/xml/schema/Core/LocBlock.xml index 75a80185d5..675620460d 100644 --- a/xml/schema/Core/LocBlock.xml +++ b/xml/schema/Core/LocBlock.xml @@ -13,6 +13,9 @@ int unsigned true Unique ID + + Number + 2.0 diff --git a/xml/schema/Core/LocationType.xml b/xml/schema/Core/LocationType.xml index 83caa4802f..be66f7309d 100644 --- a/xml/schema/Core/LocationType.xml +++ b/xml/schema/Core/LocationType.xml @@ -12,6 +12,9 @@ int unsigned true Location Type ID + + Number + 1.1 diff --git a/xml/schema/Core/Log.xml b/xml/schema/Core/Log.xml index d7892395c7..3809abee96 100644 --- a/xml/schema/Core/Log.xml +++ b/xml/schema/Core/Log.xml @@ -12,6 +12,9 @@ int unsigned true Log ID + + Number + 1.5 diff --git a/xml/schema/Core/MailSettings.xml b/xml/schema/Core/MailSettings.xml index e55f0602c3..e41b2f190c 100644 --- a/xml/schema/Core/MailSettings.xml +++ b/xml/schema/Core/MailSettings.xml @@ -10,6 +10,9 @@ int unsigned true primary key + + Number + 2.2 diff --git a/xml/schema/Core/Managed.xml b/xml/schema/Core/Managed.xml index 9fdb1bc353..b00d1aa042 100644 --- a/xml/schema/Core/Managed.xml +++ b/xml/schema/Core/Managed.xml @@ -13,6 +13,9 @@ int unsigned true Surrogate Key + + Number + 4.2 diff --git a/xml/schema/Core/Mapping.xml b/xml/schema/Core/Mapping.xml index bd5420ea27..f629d6b0d5 100644 --- a/xml/schema/Core/Mapping.xml +++ b/xml/schema/Core/Mapping.xml @@ -12,6 +12,9 @@ Mapping ID true Mapping ID + + Number + 1.2 diff --git a/xml/schema/Core/MappingField.xml b/xml/schema/Core/MappingField.xml index 0c44414375..efa514ff3d 100644 --- a/xml/schema/Core/MappingField.xml +++ b/xml/schema/Core/MappingField.xml @@ -12,6 +12,9 @@ Mapping Field ID true Mapping Field ID + + Number + 1.2 diff --git a/xml/schema/Core/Menu.xml b/xml/schema/Core/Menu.xml index 303ae57f57..c627290a7b 100644 --- a/xml/schema/Core/Menu.xml +++ b/xml/schema/Core/Menu.xml @@ -11,6 +11,9 @@ Menu ID int unsigned true + + Number + 2.1 diff --git a/xml/schema/Core/MessageTemplate.xml b/xml/schema/Core/MessageTemplate.xml index ef3e0cf6f9..16ee1f7c7e 100644 --- a/xml/schema/Core/MessageTemplate.xml +++ b/xml/schema/Core/MessageTemplate.xml @@ -12,6 +12,9 @@ int unsigned true Message Template ID + + Number + 1.6 diff --git a/xml/schema/Core/Navigation.xml b/xml/schema/Core/Navigation.xml index bc9dc654e7..373c3199df 100644 --- a/xml/schema/Core/Navigation.xml +++ b/xml/schema/Core/Navigation.xml @@ -12,6 +12,9 @@ Navigation ID int unsigned true + + Number + 3.0 diff --git a/xml/schema/Core/Note.xml b/xml/schema/Core/Note.xml index a9466da05d..497b37dbd1 100644 --- a/xml/schema/Core/Note.xml +++ b/xml/schema/Core/Note.xml @@ -14,6 +14,9 @@ int unsigned true Note ID + + Number + 1.1 diff --git a/xml/schema/Core/OpenID.xml b/xml/schema/Core/OpenID.xml index 876aeca4b0..81a396a44d 100644 --- a/xml/schema/Core/OpenID.xml +++ b/xml/schema/Core/OpenID.xml @@ -11,6 +11,9 @@ int unsigned true Unique OpenID ID + + Number + 2.0 diff --git a/xml/schema/Core/OptionGroup.xml b/xml/schema/Core/OptionGroup.xml index 3df4c11d18..018922c6ae 100644 --- a/xml/schema/Core/OptionGroup.xml +++ b/xml/schema/Core/OptionGroup.xml @@ -12,6 +12,9 @@ int unsigned true Option Group ID + + Number + 1.5 diff --git a/xml/schema/Core/OptionValue.xml b/xml/schema/Core/OptionValue.xml index ce81cc6822..7109e02c74 100644 --- a/xml/schema/Core/OptionValue.xml +++ b/xml/schema/Core/OptionValue.xml @@ -12,6 +12,9 @@ int unsigned true Option ID + + Number + 1.5 diff --git a/xml/schema/Core/Persistent.xml b/xml/schema/Core/Persistent.xml index 6c48b577ab..348896277a 100644 --- a/xml/schema/Core/Persistent.xml +++ b/xml/schema/Core/Persistent.xml @@ -12,6 +12,9 @@ int unsigned true Persistent Record Id + + Number + 3.2 diff --git a/xml/schema/Core/Phone.xml b/xml/schema/Core/Phone.xml index 007ffa8486..e52e2b8344 100644 --- a/xml/schema/Core/Phone.xml +++ b/xml/schema/Core/Phone.xml @@ -15,6 +15,9 @@ int unsigned true Unique Phone ID + + Number + 1.1 diff --git a/xml/schema/Core/Preferences.xml b/xml/schema/Core/Preferences.xml index 985b71ab3c..49e1127e13 100644 --- a/xml/schema/Core/Preferences.xml +++ b/xml/schema/Core/Preferences.xml @@ -12,6 +12,9 @@ id int unsigned true + + Number + 1.8 diff --git a/xml/schema/Core/PreferencesDate.xml b/xml/schema/Core/PreferencesDate.xml index 90949567ec..625f0d3d17 100644 --- a/xml/schema/Core/PreferencesDate.xml +++ b/xml/schema/Core/PreferencesDate.xml @@ -12,6 +12,9 @@ Date Preference ID int unsigned true + + Number + 2.0 diff --git a/xml/schema/Core/PrevNextCache.xml b/xml/schema/Core/PrevNextCache.xml index 0af66d463b..9eea75ff34 100644 --- a/xml/schema/Core/PrevNextCache.xml +++ b/xml/schema/Core/PrevNextCache.xml @@ -11,6 +11,9 @@ Prev Next Cache ID int unsigned true + + Number + 3.4 diff --git a/xml/schema/Core/PrintLabel.xml b/xml/schema/Core/PrintLabel.xml index 546020cd1e..6f859c8503 100644 --- a/xml/schema/Core/PrintLabel.xml +++ b/xml/schema/Core/PrintLabel.xml @@ -11,6 +11,9 @@ Print Label ID int unsigned true + + Number + 4.4 diff --git a/xml/schema/Core/RecurringEntity.xml b/xml/schema/Core/RecurringEntity.xml index f90c5e4092..86f6f80808 100644 --- a/xml/schema/Core/RecurringEntity.xml +++ b/xml/schema/Core/RecurringEntity.xml @@ -12,6 +12,9 @@ int unsigned 10 true + + Number + 4.6 diff --git a/xml/schema/Core/Setting.xml b/xml/schema/Core/Setting.xml index 0a5263fab7..04230bc83f 100644 --- a/xml/schema/Core/Setting.xml +++ b/xml/schema/Core/Setting.xml @@ -11,6 +11,9 @@ Setting ID int unsigned true + + Number + 4.1 diff --git a/xml/schema/Core/StateProvince.xml b/xml/schema/Core/StateProvince.xml index f2352e0592..d72d6aa8cf 100644 --- a/xml/schema/Core/StateProvince.xml +++ b/xml/schema/Core/StateProvince.xml @@ -14,6 +14,9 @@ int unsigned true State/Province ID + + Number + 1.1 diff --git a/xml/schema/Core/StatusPreference.xml b/xml/schema/Core/StatusPreference.xml index 7ae28e74bd..7dcf5d1db9 100644 --- a/xml/schema/Core/StatusPreference.xml +++ b/xml/schema/Core/StatusPreference.xml @@ -12,6 +12,9 @@ Status Preference ID true Unique Status Preference ID + + Number + 4.7 diff --git a/xml/schema/Core/SystemLog.xml b/xml/schema/Core/SystemLog.xml index e50a7e4d54..d205739cf4 100644 --- a/xml/schema/Core/SystemLog.xml +++ b/xml/schema/Core/SystemLog.xml @@ -11,6 +11,9 @@ System Log ID true Primary key ID + + Number + 4.4 diff --git a/xml/schema/Core/Tag.xml b/xml/schema/Core/Tag.xml index 43229977b6..5f573db47d 100644 --- a/xml/schema/Core/Tag.xml +++ b/xml/schema/Core/Tag.xml @@ -15,6 +15,9 @@ int unsigned true Tag ID + + Number + 1.1 diff --git a/xml/schema/Core/Timezone.xml b/xml/schema/Core/Timezone.xml index a7930d8609..21738c06b7 100644 --- a/xml/schema/Core/Timezone.xml +++ b/xml/schema/Core/Timezone.xml @@ -11,6 +11,9 @@ int unsigned true Timezone Id + + Number + 1.8 diff --git a/xml/schema/Core/UFField.xml b/xml/schema/Core/UFField.xml index 9b012ab4c8..df10ddf86b 100644 --- a/xml/schema/Core/UFField.xml +++ b/xml/schema/Core/UFField.xml @@ -13,6 +13,9 @@ int unsigned true Unique table ID + + Number + 1.1 diff --git a/xml/schema/Core/UFGroup.xml b/xml/schema/Core/UFGroup.xml index 37d5d0a8aa..6af9ceaff0 100644 --- a/xml/schema/Core/UFGroup.xml +++ b/xml/schema/Core/UFGroup.xml @@ -13,6 +13,9 @@ int unsigned true Unique table ID + + Number + 1.1 diff --git a/xml/schema/Core/UFJoin.xml b/xml/schema/Core/UFJoin.xml index 368a3e0c0a..d007086ea3 100644 --- a/xml/schema/Core/UFJoin.xml +++ b/xml/schema/Core/UFJoin.xml @@ -13,6 +13,9 @@ int unsigned true Unique table ID + + Number + 1.3 diff --git a/xml/schema/Core/UFMatch.xml b/xml/schema/Core/UFMatch.xml index 9e573a5a79..1fe9e9a490 100644 --- a/xml/schema/Core/UFMatch.xml +++ b/xml/schema/Core/UFMatch.xml @@ -13,6 +13,9 @@ int unsigned true System generated ID. + + Number + 1.1 diff --git a/xml/schema/Core/Website.xml b/xml/schema/Core/Website.xml index f9e8e0ea7a..52b0da20ce 100644 --- a/xml/schema/Core/Website.xml +++ b/xml/schema/Core/Website.xml @@ -14,6 +14,9 @@ Website ID true Unique Website ID + + Number + 3.2 diff --git a/xml/schema/Core/WordReplacement.xml b/xml/schema/Core/WordReplacement.xml index e3a544ce29..84e6425a92 100644 --- a/xml/schema/Core/WordReplacement.xml +++ b/xml/schema/Core/WordReplacement.xml @@ -12,6 +12,9 @@ int unsigned true Word replacement ID + + Number + 4.4 diff --git a/xml/schema/Core/Worldregion.xml b/xml/schema/Core/Worldregion.xml index 5b0f06706b..ea4f20d701 100644 --- a/xml/schema/Core/Worldregion.xml +++ b/xml/schema/Core/Worldregion.xml @@ -11,6 +11,9 @@ int unsigned true Country Id + + Number + 1.8 diff --git a/xml/schema/Cxn/Cxn.xml b/xml/schema/Cxn/Cxn.xml index f8d7ee2c22..69280373f8 100644 --- a/xml/schema/Cxn/Cxn.xml +++ b/xml/schema/Cxn/Cxn.xml @@ -9,6 +9,9 @@ int unsigned true Connection ID + + Number + 4.6 diff --git a/xml/schema/Dedupe/Exception.xml b/xml/schema/Dedupe/Exception.xml index 77afb22248..a183ccaa53 100644 --- a/xml/schema/Dedupe/Exception.xml +++ b/xml/schema/Dedupe/Exception.xml @@ -11,6 +11,9 @@ int unsigned true Unique dedupe exception id + + Number + 3.3 diff --git a/xml/schema/Dedupe/Rule.xml b/xml/schema/Dedupe/Rule.xml index 858c0ff8c4..70b4864071 100644 --- a/xml/schema/Dedupe/Rule.xml +++ b/xml/schema/Dedupe/Rule.xml @@ -11,6 +11,9 @@ int unsigned true Unique dedupe rule id + + Number + 1.8 diff --git a/xml/schema/Dedupe/RuleGroup.xml b/xml/schema/Dedupe/RuleGroup.xml index 09a5873628..26fe7e63f8 100644 --- a/xml/schema/Dedupe/RuleGroup.xml +++ b/xml/schema/Dedupe/RuleGroup.xml @@ -11,6 +11,9 @@ int unsigned true Unique dedupe rule group id + + Number + 1.8 diff --git a/xml/schema/Event/Cart/Cart.xml b/xml/schema/Event/Cart/Cart.xml index 0c957af2a7..8830f37df8 100644 --- a/xml/schema/Event/Cart/Cart.xml +++ b/xml/schema/Event/Cart/Cart.xml @@ -13,6 +13,9 @@ int unsigned true Cart Id + + Number + 4.1 diff --git a/xml/schema/Event/Cart/EventInCart.xml b/xml/schema/Event/Cart/EventInCart.xml index 25eb7b0979..6ab1292097 100644 --- a/xml/schema/Event/Cart/EventInCart.xml +++ b/xml/schema/Event/Cart/EventInCart.xml @@ -13,6 +13,9 @@ int unsigned true Event In Cart Id + + Number + 4.1 diff --git a/xml/schema/Event/Event.xml b/xml/schema/Event/Event.xml index f0ff62f4ea..5d98615978 100644 --- a/xml/schema/Event/Event.xml +++ b/xml/schema/Event/Event.xml @@ -19,6 +19,9 @@ Event ID true Event + + Number + 1.7 diff --git a/xml/schema/Event/Participant.xml b/xml/schema/Event/Participant.xml index 44ecd7847e..4a35e6109a 100644 --- a/xml/schema/Event/Participant.xml +++ b/xml/schema/Event/Participant.xml @@ -17,6 +17,9 @@ Participant Id true /(^(participant(.)?)?id$)/i + + Number + 1.7 diff --git a/xml/schema/Event/ParticipantPayment.xml b/xml/schema/Event/ParticipantPayment.xml index 8872bdd25e..0e240e3805 100644 --- a/xml/schema/Event/ParticipantPayment.xml +++ b/xml/schema/Event/ParticipantPayment.xml @@ -13,6 +13,9 @@ int unsigned true Participant Payment Id + + Number + 1.7 diff --git a/xml/schema/Event/ParticipantStatusType.xml b/xml/schema/Event/ParticipantStatusType.xml index 083e9a2058..9df2ce9c1c 100644 --- a/xml/schema/Event/ParticipantStatusType.xml +++ b/xml/schema/Event/ParticipantStatusType.xml @@ -13,6 +13,9 @@ int unsigned true unique participant status type id + + Number + 3.0 diff --git a/xml/schema/Financial/Currency.xml b/xml/schema/Financial/Currency.xml index 31ccd6b38b..e1b25484fa 100644 --- a/xml/schema/Financial/Currency.xml +++ b/xml/schema/Financial/Currency.xml @@ -13,6 +13,9 @@ int unsigned true Currency Id + + Number + 1.7 diff --git a/xml/schema/Financial/EntityFinancialAccount.xml b/xml/schema/Financial/EntityFinancialAccount.xml index 86032a2567..43739da852 100644 --- a/xml/schema/Financial/EntityFinancialAccount.xml +++ b/xml/schema/Financial/EntityFinancialAccount.xml @@ -14,6 +14,9 @@ int unsigned true ID + + Number + 4.3 diff --git a/xml/schema/Financial/EntityFinancialTrxn.xml b/xml/schema/Financial/EntityFinancialTrxn.xml index ad7bee1e66..33d409024b 100644 --- a/xml/schema/Financial/EntityFinancialTrxn.xml +++ b/xml/schema/Financial/EntityFinancialTrxn.xml @@ -12,6 +12,9 @@ int unsigned true ID + + Number + 3.2 diff --git a/xml/schema/Financial/FinancialAccount.xml b/xml/schema/Financial/FinancialAccount.xml index 45e7ba751c..7b566a67ea 100644 --- a/xml/schema/Financial/FinancialAccount.xml +++ b/xml/schema/Financial/FinancialAccount.xml @@ -13,6 +13,9 @@ int unsigned true ID + + Number + 3.2 diff --git a/xml/schema/Financial/FinancialItem.xml b/xml/schema/Financial/FinancialItem.xml index 294a370782..5c3d822b07 100644 --- a/xml/schema/Financial/FinancialItem.xml +++ b/xml/schema/Financial/FinancialItem.xml @@ -15,6 +15,9 @@ 10 true + + Number + 4.3 diff --git a/xml/schema/Financial/FinancialTrxn.xml b/xml/schema/Financial/FinancialTrxn.xml index b6005f868c..4893a69b2b 100644 --- a/xml/schema/Financial/FinancialTrxn.xml +++ b/xml/schema/Financial/FinancialTrxn.xml @@ -12,6 +12,9 @@ Financial Transaction ID int unsigned true + + Number + 1.3 diff --git a/xml/schema/Financial/FinancialType.xml b/xml/schema/Financial/FinancialType.xml index 43b0ce68a9..c6850f15ce 100644 --- a/xml/schema/Financial/FinancialType.xml +++ b/xml/schema/Financial/FinancialType.xml @@ -16,6 +16,9 @@ 10 true ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp + + Number + 1.3 diff --git a/xml/schema/Financial/PaymentProcessor.xml b/xml/schema/Financial/PaymentProcessor.xml index f66d1cd093..330511ca43 100644 --- a/xml/schema/Financial/PaymentProcessor.xml +++ b/xml/schema/Financial/PaymentProcessor.xml @@ -12,6 +12,9 @@ int unsigned true Payment Processor ID + + Number + 1.8 diff --git a/xml/schema/Financial/PaymentProcessorType.xml b/xml/schema/Financial/PaymentProcessorType.xml index f282e33448..584c03f0ac 100644 --- a/xml/schema/Financial/PaymentProcessorType.xml +++ b/xml/schema/Financial/PaymentProcessorType.xml @@ -12,6 +12,9 @@ int unsigned true Payment Processor Type ID + + Number + 1.8 diff --git a/xml/schema/Financial/PaymentToken.xml b/xml/schema/Financial/PaymentToken.xml index 594ea0ec7f..3f396023b4 100644 --- a/xml/schema/Financial/PaymentToken.xml +++ b/xml/schema/Financial/PaymentToken.xml @@ -15,6 +15,9 @@ true Payment Token ID 4.6 + + Number + id diff --git a/xml/schema/Friend/Friend.xml b/xml/schema/Friend/Friend.xml index 1894e806a0..014aee536e 100644 --- a/xml/schema/Friend/Friend.xml +++ b/xml/schema/Friend/Friend.xml @@ -11,6 +11,9 @@ int unsigned true Friend ID + + Number + 2.0 diff --git a/xml/schema/Grant/Grant.xml b/xml/schema/Grant/Grant.xml index fb2732218a..e248dd2c99 100644 --- a/xml/schema/Grant/Grant.xml +++ b/xml/schema/Grant/Grant.xml @@ -22,6 +22,9 @@ true Unique Grant id true + + Number + 1.8 diff --git a/xml/schema/Mailing/BouncePattern.xml b/xml/schema/Mailing/BouncePattern.xml index 8c486d165e..f6b452fbbd 100644 --- a/xml/schema/Mailing/BouncePattern.xml +++ b/xml/schema/Mailing/BouncePattern.xml @@ -11,6 +11,9 @@ Bounce Pattern ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/BounceType.xml b/xml/schema/Mailing/BounceType.xml index a0807bf0e4..8e9051f828 100644 --- a/xml/schema/Mailing/BounceType.xml +++ b/xml/schema/Mailing/BounceType.xml @@ -11,6 +11,9 @@ Bounce Type ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Component.xml b/xml/schema/Mailing/Component.xml index 0c5f546e98..553ee81609 100644 --- a/xml/schema/Mailing/Component.xml +++ b/xml/schema/Mailing/Component.xml @@ -11,6 +11,9 @@ Mailing Component ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Bounce.xml b/xml/schema/Mailing/Event/Bounce.xml index 0fa36fbc66..3bd5b16558 100644 --- a/xml/schema/Mailing/Event/Bounce.xml +++ b/xml/schema/Mailing/Event/Bounce.xml @@ -14,6 +14,9 @@ Bounce ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Confirm.xml b/xml/schema/Mailing/Event/Confirm.xml index 5e2156e8fe..a436a1ee6e 100644 --- a/xml/schema/Mailing/Event/Confirm.xml +++ b/xml/schema/Mailing/Event/Confirm.xml @@ -14,6 +14,9 @@ Mailing Confirmation ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Delivered.xml b/xml/schema/Mailing/Event/Delivered.xml index af5aee8c3f..eb2eff5d5f 100644 --- a/xml/schema/Mailing/Event/Delivered.xml +++ b/xml/schema/Mailing/Event/Delivered.xml @@ -14,6 +14,9 @@ Delivered ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Forward.xml b/xml/schema/Mailing/Event/Forward.xml index 13c21b57d5..d5c9ce91d5 100644 --- a/xml/schema/Mailing/Event/Forward.xml +++ b/xml/schema/Mailing/Event/Forward.xml @@ -14,6 +14,9 @@ Forward ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Opened.xml b/xml/schema/Mailing/Event/Opened.xml index 95a87a1b20..6c4e6e2ebb 100644 --- a/xml/schema/Mailing/Event/Opened.xml +++ b/xml/schema/Mailing/Event/Opened.xml @@ -14,6 +14,9 @@ Mailing Opened ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Queue.xml b/xml/schema/Mailing/Event/Queue.xml index 7abc22afbb..97d15c2bad 100644 --- a/xml/schema/Mailing/Event/Queue.xml +++ b/xml/schema/Mailing/Event/Queue.xml @@ -14,6 +14,9 @@ int unsigned Mailing Event Queue ID true + + Number + id diff --git a/xml/schema/Mailing/Event/Reply.xml b/xml/schema/Mailing/Event/Reply.xml index db6ead5894..e8dfb1a239 100644 --- a/xml/schema/Mailing/Event/Reply.xml +++ b/xml/schema/Mailing/Event/Reply.xml @@ -12,6 +12,9 @@ Reply ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Subscribe.xml b/xml/schema/Mailing/Event/Subscribe.xml index 01be3097f5..6b8371704d 100644 --- a/xml/schema/Mailing/Event/Subscribe.xml +++ b/xml/schema/Mailing/Event/Subscribe.xml @@ -12,6 +12,9 @@ Mailing Subscribe ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/TrackableURLOpen.xml b/xml/schema/Mailing/Event/TrackableURLOpen.xml index 7500634bf9..c880b90f26 100644 --- a/xml/schema/Mailing/Event/TrackableURLOpen.xml +++ b/xml/schema/Mailing/Event/TrackableURLOpen.xml @@ -12,6 +12,9 @@ Trackable URL Open ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Event/Unsubscribe.xml b/xml/schema/Mailing/Event/Unsubscribe.xml index 347be796db..c46fee37ce 100644 --- a/xml/schema/Mailing/Event/Unsubscribe.xml +++ b/xml/schema/Mailing/Event/Unsubscribe.xml @@ -12,6 +12,9 @@ Unsubscribe ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Mailing.xml b/xml/schema/Mailing/Mailing.xml index 0b3422b8c3..d819e480d1 100644 --- a/xml/schema/Mailing/Mailing.xml +++ b/xml/schema/Mailing/Mailing.xml @@ -17,6 +17,9 @@ Mailing ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/MailingAB.xml b/xml/schema/Mailing/MailingAB.xml index 2ac6f0bf01..75c67b431d 100644 --- a/xml/schema/Mailing/MailingAB.xml +++ b/xml/schema/Mailing/MailingAB.xml @@ -12,6 +12,9 @@ int unsigned MailingAB ID true + + Number + id diff --git a/xml/schema/Mailing/MailingGroup.xml b/xml/schema/Mailing/MailingGroup.xml index 77cc087acc..32476ccde9 100644 --- a/xml/schema/Mailing/MailingGroup.xml +++ b/xml/schema/Mailing/MailingGroup.xml @@ -12,6 +12,9 @@ Mailing Group ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/MailingJob.xml b/xml/schema/Mailing/MailingJob.xml index 9f047ed0b7..8816d97b32 100644 --- a/xml/schema/Mailing/MailingJob.xml +++ b/xml/schema/Mailing/MailingJob.xml @@ -12,6 +12,9 @@ Mailing Job ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Recipients.xml b/xml/schema/Mailing/Recipients.xml index 955fcd5028..e909c87994 100644 --- a/xml/schema/Mailing/Recipients.xml +++ b/xml/schema/Mailing/Recipients.xml @@ -14,6 +14,9 @@ Mailing Recipients ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/Spool.xml b/xml/schema/Mailing/Spool.xml index 36cd5eb7b8..f192b62d25 100644 --- a/xml/schema/Mailing/Spool.xml +++ b/xml/schema/Mailing/Spool.xml @@ -11,6 +11,9 @@ Spool ID int unsigned true + + Number + id diff --git a/xml/schema/Mailing/TrackableURL.xml b/xml/schema/Mailing/TrackableURL.xml index 54a0e18088..ef5c4308d3 100644 --- a/xml/schema/Mailing/TrackableURL.xml +++ b/xml/schema/Mailing/TrackableURL.xml @@ -12,6 +12,9 @@ Trackable URL ID int unsigned true + + Number + id diff --git a/xml/schema/Member/Membership.xml b/xml/schema/Member/Membership.xml index 4a25c013c5..239d400772 100644 --- a/xml/schema/Member/Membership.xml +++ b/xml/schema/Member/Membership.xml @@ -25,6 +25,9 @@ /^(m(embership\s)?id)$/i Membership Id 1.5 + + Number + id diff --git a/xml/schema/Member/MembershipBlock.xml b/xml/schema/Member/MembershipBlock.xml index 12e81bb919..a4d14b672f 100644 --- a/xml/schema/Member/MembershipBlock.xml +++ b/xml/schema/Member/MembershipBlock.xml @@ -15,6 +15,9 @@ true Membership Id 1.5 + + Number + id diff --git a/xml/schema/Member/MembershipLog.xml b/xml/schema/Member/MembershipLog.xml index 29593bde96..910e017218 100644 --- a/xml/schema/Member/MembershipLog.xml +++ b/xml/schema/Member/MembershipLog.xml @@ -14,6 +14,9 @@ int unsigned true 1.5 + + Number + id diff --git a/xml/schema/Member/MembershipPayment.xml b/xml/schema/Member/MembershipPayment.xml index 1d12a14f4c..2bb3ca2e0d 100644 --- a/xml/schema/Member/MembershipPayment.xml +++ b/xml/schema/Member/MembershipPayment.xml @@ -14,6 +14,9 @@ int unsigned true 1.5 + + Number + id diff --git a/xml/schema/Member/MembershipStatus.xml b/xml/schema/Member/MembershipStatus.xml index 15201307d3..f10984995d 100644 --- a/xml/schema/Member/MembershipStatus.xml +++ b/xml/schema/Member/MembershipStatus.xml @@ -16,6 +16,9 @@ true Membership Id 1.5 + + Number + id diff --git a/xml/schema/Member/MembershipType.xml b/xml/schema/Member/MembershipType.xml index 8316e655b7..aaef24bbf9 100644 --- a/xml/schema/Member/MembershipType.xml +++ b/xml/schema/Member/MembershipType.xml @@ -16,6 +16,9 @@ true Membership Id 1.5 + + Number + id diff --git a/xml/schema/PCP/PCP.xml b/xml/schema/PCP/PCP.xml index 762e09c3d5..a98bd5ae5b 100644 --- a/xml/schema/PCP/PCP.xml +++ b/xml/schema/PCP/PCP.xml @@ -15,6 +15,9 @@ Personal Campaign Page ID Personal Campaign Page ID 2.2 + + Number + id diff --git a/xml/schema/PCP/PCPBlock.xml b/xml/schema/PCP/PCPBlock.xml index b7777e4bc9..4666b8bc0d 100644 --- a/xml/schema/PCP/PCPBlock.xml +++ b/xml/schema/PCP/PCPBlock.xml @@ -15,6 +15,9 @@ true PCP block Id 2.2 + + Number + id diff --git a/xml/schema/Pledge/Pledge.xml b/xml/schema/Pledge/Pledge.xml index 2f86cdef66..6f39a507ea 100644 --- a/xml/schema/Pledge/Pledge.xml +++ b/xml/schema/Pledge/Pledge.xml @@ -15,6 +15,9 @@ true Pledge ID true + + Number + 2.1 diff --git a/xml/schema/Pledge/PledgeBlock.xml b/xml/schema/Pledge/PledgeBlock.xml index f4790fad9e..30f47199f6 100644 --- a/xml/schema/Pledge/PledgeBlock.xml +++ b/xml/schema/Pledge/PledgeBlock.xml @@ -13,6 +13,9 @@ true Pledge ID 2.1 + + Number + id diff --git a/xml/schema/Pledge/PledgePayment.xml b/xml/schema/Pledge/PledgePayment.xml index b588d54839..3fa37ece59 100644 --- a/xml/schema/Pledge/PledgePayment.xml +++ b/xml/schema/Pledge/PledgePayment.xml @@ -15,6 +15,9 @@ int unsigned true true + + Number + 2.1 diff --git a/xml/schema/Price/LineItem.xml b/xml/schema/Price/LineItem.xml index 274d9389a0..4ecb7b918d 100644 --- a/xml/schema/Price/LineItem.xml +++ b/xml/schema/Price/LineItem.xml @@ -13,6 +13,9 @@ int unsigned true Line Item + + Number + 1.7 diff --git a/xml/schema/Price/PriceField.xml b/xml/schema/Price/PriceField.xml index d261c73110..07932daf40 100644 --- a/xml/schema/Price/PriceField.xml +++ b/xml/schema/Price/PriceField.xml @@ -13,6 +13,9 @@ int unsigned true Price Field + + Number + 1.8 diff --git a/xml/schema/Price/PriceFieldValue.xml b/xml/schema/Price/PriceFieldValue.xml index 3c4e39e70c..af9c783dd6 100644 --- a/xml/schema/Price/PriceFieldValue.xml +++ b/xml/schema/Price/PriceFieldValue.xml @@ -12,6 +12,9 @@ int unsigned true Price Field Value + + Number + 3.3 diff --git a/xml/schema/Price/PriceSet.xml b/xml/schema/Price/PriceSet.xml index 866ac927ac..1c0486d6f4 100644 --- a/xml/schema/Price/PriceSet.xml +++ b/xml/schema/Price/PriceSet.xml @@ -13,10 +13,10 @@ int unsigned true Price Set - 1.8 - Select + Number + 1.8 id diff --git a/xml/schema/Price/PriceSetEntity.xml b/xml/schema/Price/PriceSetEntity.xml index effc85ad2c..bb343cffdd 100644 --- a/xml/schema/Price/PriceSetEntity.xml +++ b/xml/schema/Price/PriceSetEntity.xml @@ -13,6 +13,9 @@ int unsigned true Price Set Entity + + Number + 1.8 diff --git a/xml/schema/Queue/QueueItem.xml b/xml/schema/Queue/QueueItem.xml index f5e68e3989..9feedb4f20 100644 --- a/xml/schema/Queue/QueueItem.xml +++ b/xml/schema/Queue/QueueItem.xml @@ -15,6 +15,9 @@ Queue ID int unsigned true + + Number + id diff --git a/xml/schema/Report/ReportInstance.xml b/xml/schema/Report/ReportInstance.xml index 0edd075cba..5d6e049940 100644 --- a/xml/schema/Report/ReportInstance.xml +++ b/xml/schema/Report/ReportInstance.xml @@ -15,6 +15,9 @@ int unsigned true Report Instance ID + + Number + 2.2 diff --git a/xml/schema/SMS/History.xml b/xml/schema/SMS/History.xml index 0cd60b2ae4..20f5cd3428 100644 --- a/xml/schema/SMS/History.xml +++ b/xml/schema/SMS/History.xml @@ -12,6 +12,9 @@ int unsigned true SMS History ID + + Number + 1.4 diff --git a/xml/schema/SMS/Provider.xml b/xml/schema/SMS/Provider.xml index e807701e6a..78c211694b 100644 --- a/xml/schema/SMS/Provider.xml +++ b/xml/schema/SMS/Provider.xml @@ -12,6 +12,9 @@ int unsigned true SMS Provider ID + + Number + 4.2 -- 2.25.1