drop table if exists  PlmnRestrictionList;
create table PlmnRestrictionList (
		restrictionListId INT NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		restrictionListCategory TINYINT,
		restrictionIsdn BINARY(55),
		restrictionListLabel CHAR(31),
		restrictionBitmap BINARY(8),
PRIMARY KEY USING HASH (restrictionListId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (restrictionListId);
 
drop table if exists  BasicServiceCode;
create table BasicServiceCode (
		basicServiceCodeId BINARY(2) NOT NULL,
		basicServiceGroupId BINARY NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		basicServiceImplicitSubs BIT(1),
		basicServiceGPRSApplicability BIT(1),
		basicServiceTCOCSubscription BIT(1),
PRIMARY KEY USING HASH (basicServiceCodeId,basicServiceGroupId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (basicServiceCodeId);
 
drop table if exists  BasicServiceGroup;
create table BasicServiceGroup (
		basicServiceGroupId BINARY NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
PRIMARY KEY USING HASH (basicServiceGroupId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (basicServiceGroupId);
 
drop table if exists  SSInThePLMN;
create table SSInThePLMN (
		ssInThePLMNId BINARY(2) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		implicitSubscriptAtCreation BIT(1),
		activationMapOpAllowed BIT(1),
		interrogationMapOpAllowed BIT(1),
		updateVLRforModification BIT(1),
		osssiSentOnNonFwdInSri BIT(1),
		osssiSentOnFwdInSri BIT(1),
		ossTransmission BIT(1),
		osssPrbt BIT(1),
		internalCodeValue BINARY,
		applicableBSG BINARY(10),
		serviceClassMark BINARY(6),
PRIMARY KEY USING HASH (ssInThePLMNId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (ssInThePLMNId);
 
drop table if exists  MNC;
create table MNC (
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		remoteAuCindic BIT(1),
		msgInfoTripletInAuC BIT(1),
		plmnIdType TINYINT,
		plmnLabel CHAR(31),
		plmnIndexTable TINYINT,
PRIMARY KEY USING HASH (mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (mobileNetworkCodeId);
 
drop table if exists  TranslatorBlockNumber;
create table TranslatorBlockNumber (
		analysisBlockId INT NOT NULL,
		serviceTranslatorId INT NOT NULL,
		translatorLabel CHAR(32),
		nextAnalysisBlockDgt0 INT,
		nextAnalysisBlockDgt1 INT,
		nextAnalysisBlockDgt2 INT,
		nextAnalysisBlockDgt3 INT,
		nextAnalysisBlockDgt4 INT,
		nextAnalysisBlockDgt5 INT,
		nextAnalysisBlockDgt6 INT,
		nextAnalysisBlockDgt7 INT,
		nextAnalysisBlockDgt8 INT,
		nextAnalysisBlockDgt9 INT,
		nextAnalysisBlockDgtA INT,
		nextAnalysisBlockDgtB INT,
		resultNumberDgt0 INT,
		resultNumberDgt1 INT,
		resultNumberDgt2 INT,
		resultNumberDgt3 INT,
		resultNumberDgt4 INT,
		resultNumberDgt5 INT,
		resultNumberDgt6 INT,
		resultNumberDgt7 INT,
		resultNumberDgt8 INT,
		resultNumberDgt9 INT,
		resultNumberDgtA INT,
		resultNumberDgtB INT,
PRIMARY KEY USING HASH (analysisBlockId,serviceTranslatorId) ) engine=ndb PARTITION BY KEY (analysisBlockId);
 
drop table if exists  TranslatorResult;
create table TranslatorResult (
		resultNumberId INT NOT NULL,
		serviceTranslatorId INT NOT NULL,
		flagAnaNumAsKeyForMapVers BIT(1),
		flagCooperatingPLMN BIT(1),
		flagServiceNodeNotification BIT(1),
		flagCamelTransfer BIT(1),
		flagLocationService BIT(1),
		flagCallForwardInhibition BIT(1),
		flagFwdNumRegistration BIT(1),
		flagFwdViolationAllowed BIT(1),
		flagFwdToVoiceMail BIT(1),
		resultType TINYINT,
		countResultUsers INT,
		resultLabel CHAR(32),
		callOrigin TINYINT,
		numberingPhase TINYINT,
		pNumberingType TINYINT,
		pNumberingPlan TINYINT,
		pRankDigitAdd TINYINT,
		pDigitToAdd BINARY(11),
		pRankDigitDel TINYINT,
		pNbDigitToDel TINYINT,
		pMinNumberLength TINYINT,
		pMaxNumberLength TINYINT,
		nNumberingType TINYINT,
		nNumberingPlan TINYINT,
		nRankDigitAdd TINYINT,
		nDigitToAdd BINARY(11),
		nRankDigitDel TINYINT,
		nNbDigitToDel TINYINT,
		nMinNumberLength TINYINT,
		nMaxNumberLength TINYINT,
		nCCNDC BINARY(5),
		nNDC BINARY(3),
		resultNumberLgth1 INT,
		resultNumberLgth2 INT,
		resultNumberLgth3 INT,
		resultNumberLgth4 INT,
		resultNumberLgth5 INT,
		resultNumberLgth6 INT,
		resultNumberLgth7 INT,
		resultNumberLgth8 INT,
		resultNumberLgth9 INT,
		resultNumberLgth10 INT,
		resultNumberLgth11 INT,
		resultNumberLgth12 INT,
		resultNumberLgth13 INT,
		resultNumberLgth14 INT,
		resultNumberLgth15 INT,
		resultNumberLgth16 INT,
		resultNumberLgth17 INT,
		resultNumberLgth18 INT,
		resultNumberLgth19 INT,
		resultNumberLgth20 INT,
		entityType TINYINT,
		eMobileCountryCode BINARY(3),
		MobileNetworkCode BINARY(3),
		eCCNDC BINARY(5),
		ccOptimalRouteing BINARY(3),
		ndcOptimalRouteing BINARY(3),
		eWorldNumberingZone BINARY(2),
		addressEntityForMapVers BINARY(9),
		aNumberingType TINYINT,
		aNumberingPlan TINYINT,
		aRankDigitAdd TINYINT,
		aDigitToAdd BINARY(11),
		aRankDigitDel TINYINT,
		aNbDigitToDel TINYINT,
		aMinNumberLength TINYINT,
		aMaxNumberLength TINYINT,
		targetTranslator TINYINT,
		rankNextAnalyse TINYINT,
		fNumberingType TINYINT,
		fNumberingPlan TINYINT,
		destinationProfileList BINARY(16),
		fRankDigitAdd TINYINT,
		fDigitToAdd BINARY(11),
		fRankDigitDel TINYINT,
		fNbDigitToDel TINYINT,
		fMinNumberLength TINYINT,
		fMaxNumberLength TINYINT,
		fMobileCountryCode BINARY(3),
		fWorldNumberingZone BINARY(2),
PRIMARY KEY USING HASH (resultNumberId,serviceTranslatorId) ) engine=ndb PARTITION BY KEY (resultNumberId);
 
drop table if exists  HomePlmnEntity;
create table HomePlmnEntity (
		homePlmnEntityId CHAR(23) NOT NULL,
		phaseAllowedForHLoccanOutAC TINYINT,
		phaseAllowedForHRnbenqOutAC TINYINT,
		phaseAllowedForHHlrrstOutAC TINYINT,
		phaseAllowedForHSubdtmOutAC TINYINT,
		phaseAllowedForHTrcingOutAC TINYINT,
		phaseAllowedForHNwusshOutAC TINYINT,
		phaseAllowedForHSmalrtOutAC TINYINT,
		phaseAllowedForHSinenqOutAC TINYINT,
		phaseAllowedForHSsnotiOutAC TINYINT,
		phaseAllowedForHReportOutAC TINYINT,
		phaseAllowedForHGpnotOutAC TINYINT,
PRIMARY KEY USING HASH (homePlmnEntityId) ) engine=ndb PARTITION BY KEY (homePlmnEntityId);
 
drop table if exists  CamelDestinationNumber;
create table CamelDestinationNumber (
		camelDestinationNumberId INT NOT NULL,
		destinationNumber BINARY(10),
PRIMARY KEY USING HASH (camelDestinationNumberId) ) engine=ndb PARTITION BY KEY (camelDestinationNumberId);
 
drop table if exists  CamelServiceControlPoint;
create table CamelServiceControlPoint (
		camelServiceControlPointId INT NOT NULL,
		scpAddress BINARY(10),
PRIMARY KEY USING HASH (camelServiceControlPointId) ) engine=ndb PARTITION BY KEY (camelServiceControlPointId);
 
drop table if exists  ConfPlmnData;
create table ConfPlmnData (
		confPlmnId INTEGER NOT NULL,
		confSccpSegmentation TINYINT,
		initPhaseForLoccanOutAC TINYINT,
		initPhaseForRnbenqOutAC TINYINT,
		initPhaseForHlrrstOutAC TINYINT,
		initPhaseForSubdtmOutAC TINYINT,
		initPhaseForTrcingOutAC TINYINT,
		initPhaseForNwusshOutAC TINYINT,
		initPhaseForSmalrtOutAC TINYINT,
		initPhaseForSinenqOutAC TINYINT,
		initPhaseForReportOutAC TINYINT,
		initPhaseForSsnotiOutAC TINYINT,
		initPhaseForGpnotOutAC TINYINT,
		maxPhaseForLocupdIncAC TINYINT,
		maxPhaseForImsirtIncAC TINYINT,
		maxPhaseForInfretIncAC TINYINT,
		maxPhaseForLocretIncAC TINYINT,
		maxPhaseForNwfsshIncAC TINYINT,
		maxPhaseForNwusshIncAC TINYINT,
		maxPhaseForSmgwayIncAC TINYINT,
		maxPhaseForSmwdtmIncAC TINYINT,
		maxPhaseForMspurgIncAC TINYINT,
		maxPhaseForAtienqIncAC TINYINT,
		maxPhaseForGplcupIncAC TINYINT,
		maxPhaseForReportIncAC TINYINT,
		maxPhaseForCcompIncAC TINYINT,
		maxPhaseForAufailIncAC TINYINT,
		maxPhaseForLcsgwIncAC TINYINT,
		maxPhaseForAthrqIncAC TINYINT,
		maxPhaseForGplocrIncAC TINYINT,
		maxPhaseForGpfailIncAC TINYINT,
PRIMARY KEY USING HASH (confPlmnId) ) engine=ndb PARTITION BY KEY (confPlmnId);
 
drop table if exists  WaitingGgsn;
create table WaitingGgsn (
		waitingGgsnId INT NOT NULL,
		mSubIdentificationNumberId BINARY(6) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		ggsnDate INT,
		ggsnIsdn BINARY(10),
		ggsnIp BINARY(18),
PRIMARY KEY USING HASH (waitingGgsnId,mSubIdentificationNumberId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (waitingGgsnId);
 
drop table if exists  PdPContext;
create table PdPContext (
		pdpContextId INT NOT NULL,
		suMSubscriberProfileId CHAR(12) NOT NULL,
		packetMsAddress BINARY(17),
		pdpProfileId BINARY(4),
PRIMARY KEY USING HASH (pdpContextId,suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (pdpContextId);
 
drop table if exists  PdPModel;
create table PdPModel (
		packetDataProtocolProfileId INT NOT NULL,
		pdpChargingCharacteristic BIT(4),
		vplmnAddressAllowedFlag BIT(1),
		pdpType SMALLINT,
		accessPointName CHAR(64),
		priorityOfUmtsBearer TINYINT,
		trafficClass TINYINT,
		deliveryOrder TINYINT,
		deliveryOfErroneousSdu TINYINT,
		maxSduSize TINYINT,
		uplinkMaxBR TINYINT,
		downlinkMaxBR TINYINT,
		residualBER TINYINT,
		ratioSduError TINYINT,
		transferDelay TINYINT,
		trafficHandlingPriority TINYINT,
		uplinkGuaranteedBR TINYINT,
		downlinkGuaranteedBR TINYINT,
		precedenceClass TINYINT,
		delayClass TINYINT,
		reliabilityClass TINYINT,
		peakThroughPutClass TINYINT,
		meanThroughPutClass TINYINT,
PRIMARY KEY USING HASH (packetDataProtocolProfileId) ) engine=ndb PARTITION BY KEY (packetDataProtocolProfileId);
 
drop table if exists  MobileUserSubscriptionProfile;
create table MobileUserSubscriptionProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		associatedMainMsisdn BINARY(12),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  GsmGprsUserSubscription;
create table GsmGprsUserSubscription (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		odbOutgoingCalls BIT(8),
		odbIncomingCalls BIT(4),
		odbRoaming BIT(2),
		odbSpecificHPLMN BIT(4),
		barringForLockingReason BIT(5),
		networkAccessMode TINYINT,
		bscWithoutSN BINARY(116),
		vlrSgsnServiceNodeNotification BINARY(4),
		plmnServiceNodeNotification BINARY(4),
		ccServiceNodeNotification BINARY(4),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  CamelSubscription;
create table CamelSubscription (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		camelLocationRequestFlag BIT(1),
		camelStatusRequestFlag BIT(1),
		camelMarkActivationRoamers BIT(1),
		camelMarkInhibitionRoamersCs BIT(1),
		camelUcsiLink BINARY(2),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  OriginatingCamelSubscription;
create table OriginatingCamelSubscription (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		ocsiCamelSubState BIT(1),
		ocsiCamelCapabilityHandling BIT(6),
		ocsiCamelGmscNotSuppDfltHdl BIT(1),
		tifcsiTransformationInformFlag BIT(1),
		matchType BIT(1),
		ocsiCollectedInfoTdpDfltCalH BIT(1),
		ocsiRouteSelectFailTdpDfltCalH BIT(1),
		ocsiCamelVlrNotSuppDfltHandl TINYINT,
		callTypeCriteria TINYINT,
		ocsiCollectedInfoTdpServKey INT,
		ocsiCollectedInfoTdpScpIsdn BINARY(4),
		destNbLengthCriteriaList BINARY(4),
		destinationNumberCritList BINARY(44),
		originBscCrit BINARY(49),
		originBsgCrit BINARY(39),
		ocsiRouteSelectFailTdpServKey INT,
		ocsiRouteSelectFailTdpScpIsdn BINARY(4),
		routeSelectFailTdpCauVCritList BINARY(6),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  TerminatingCamelSubscription;
create table TerminatingCamelSubscription (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		tcsiCamelSubState BIT(1),
		tcsiCamelCapabilityHandling BIT(6),
		tcsiCamelGmscNotSuppDfltHandl BIT(1),
		tcsiTBusyTdpDfltCalH BIT(1),
		tcsiTermAttemptTdpDfltCalH BIT(1),
		tcsiTNoAnswTdpDfltCalH BIT(1),
		tcsiTBusyTdpServKey INT,
		tcsiTBusyTdpScpIsdn BINARY(4),
		tbusyTdpCauseValueCritList BINARY(6),
		tcsiTermAttemptTdpServKey INT,
		tcsiTermAttemptTdpScpIsdn BINARY(4),
		terminBscCrit BINARY(49),
		terminBsgCrit BINARY(39),
		tcsiTNoAnswTdpServKey INT,
		tcsiTNoAnswTdpScpIsdn BINARY(4),
		tnoAnswTdpCauseValueCritList BINARY(6),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  CamelContractData;
create table CamelContractData (
		contractCamelId INTEGER NOT NULL,
		fCA001 BIT(1),
		fCA010 BIT(1),
		fCA012 BIT(1),
		fCA015 BIT(1),
		fCA016 BIT(1),
		fCA017 BIT(1),
		fCA019 BIT(1),
		fCA029 BIT(1),
		fCA030 BIT(1),
		fCA031 BIT(1),
		fCA032 BIT(1),
		fCA034 BIT(1),
		fCA042 BIT(1),
		fCA043 BIT(1),
		fCA044 BIT(1),
		fCA3001 BIT(1),
		fCA3002 BIT(1),
		fCA3003 BIT(1),
		fCA3004 BIT(1),
		fCA3005 BIT(1),
		fCA3021 BIT(1),
		fAlr001 BIT(1),
		ocsiCapabilityHandling BIT(6),
		tcsiCapabilityHandling BIT(6),
		smocsiCapabilityHandling BIT(6),
		ocsiSubState BIT(1),
		tcsiSubState BIT(1),
		sscsiSubState BIT(1),
		mcsiSubState BIT(1),
		smocsiSubState BIT(1),
		gprscsiSubState BIT(1),
		ocsiGmscNotSuppDfltHdl BIT(1),
		tcsiGmscNotSuppDfltHdl BIT(1),
		sscsiVlrNotSuppDfltHdl BIT(1),
		mcsiVlrNotSuppDfltHdl BIT(1),
		smocsiGmscNotSuppDfltHdl BIT(1),
		ocsiVlrNotSuppDfltHandl TINYINT,
PRIMARY KEY USING HASH (contractCamelId) ) engine=ndb PARTITION BY KEY (contractCamelId);
 
drop table if exists  ContractGprsData;
create table ContractGprsData (
		contractGprsId INTEGER NOT NULL,
		fGprs001 BIT(1),
		fGprs002 BIT(1),
		fGprs004 BIT(1),
		fGprs007 BIT(1),
		fGprs008 BIT(1),
		fGprs009 BIT(1),
		timeBetweenDeleteSubsGSN SMALLINT,
		maxNbDeleteSubsGSN TINYINT,
		maxNbInsertSubsGSN TINYINT,
		timeBetweenInsertSubsGSN SMALLINT,
		timeBetweenCancelLocationGSN SMALLINT,
		maxNbCancelLocationGSN TINYINT,
PRIMARY KEY USING HASH (contractGprsId) ) engine=ndb PARTITION BY KEY (contractGprsId);
 
drop table if exists  contractProtocolData;
create table contractProtocolData (
		contractProtocolId INTEGER NOT NULL,
		fDA019 BIT(1),
		fDA035 BIT(1),
		fDA036 BIT(1),
		fDA039 BIT(1),
		fDA040 BIT(1),
		fDA052 BIT(1),
		fDA060 BIT(1),
		fCLI007 BIT(1),
		fCLI008 BIT(1),
		fCLI014 BIT(1),
		fCLI015 BIT(1),
		fCS006 BIT(1),
		maxNbOfRepeatCancelLocVlr TINYINT,
		timeBetweenCancelLocVlr SMALLINT,
		maxNbOfRepeatIsdDsdVlr TINYINT,
		timeBetweenIsdDsdVlr SMALLINT,
		aceSGatewayVLRAddress BINARY(111),
PRIMARY KEY USING HASH (contractProtocolId) ) engine=ndb PARTITION BY KEY (contractProtocolId);
 
drop table if exists  IsdnbcTranslation;
create table IsdnbcTranslation (
		isdnbcTranslationId INT NOT NULL,
		finalResultIndicator BIT(1),
		informationTransferCapability TINYINT,
		userRate TINYINT,
		ibcBasicServiceCode BINARY(2),
		bearerCapabilityData BINARY(27),
PRIMARY KEY USING HASH (isdnbcTranslationId) ) engine=ndb PARTITION BY KEY (isdnbcTranslationId);
 
drop table if exists  IMSI;
create table IMSI (
		mSubIdentificationNumberId BINARY(6) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		roamingCapabilityFlags BIT(1),
		sgsnUpdateFlag BIT(1),
		gprsEnhancementIndicator BIT(1),
		sgsnGenUnsuppFeaturesFlags BIT(3),
		gprsCamelPhase BIT(3),
		gprsNegocCamelPhases BIT(6),
		sgsnRoamingRestriction BIT(5),
		gprsNotReachableFlag BIT(1),
		roamingRestrictionFlags BIT(11),
		vlrUpdateFlag BIT(1),
		roamingCharactsFlags BIT(2),
		flagCffPlmn BIT(1),
		locRegSponSent BIT(1),
		gsmCamelPhase BIT(3),
		gsmNegocCamelPhases BIT(12),
		odbUnsuppFeaturesFlags BIT(3),
		vlrBasServUnsuppFeaturesFlags BIT(4),
		vlrGenUnsuppFeaturesFlags BIT(6),
		autReqSponSent BIT(1),
		transferOfSmOption BIT(1),
		gsmNotReachableSMSFlag BIT(1),
		memoryCapacityExceededFlag BIT(1),
		sgsnIsdn BINARY(10),
		sgsnIp BINARY(18),
		gprsNotReachableReason TINYINT,
		localMobileStationIdentity INT,
		vlrIsdn BINARY(10),
		mscIsdn BINARY(10),
		supOfLocRegCount TINYINT,
		locRegSubsPeriod SMALLINT,
		inducedCbocBsg BINARY(7),
		inducedCboiBsg BINARY(7),
		inducedCboehBsg BINARY(7),
		supOfAutReqCount TINYINT,
		autReqSubsPeriod SMALLINT,
		smscIsdn BINARY(70),
		gsmNotReachableReason TINYINT,
		timeStampWaitingSms BINARY(28),
		mainMSISDN BINARY(12),
		alertMSISDN BINARY(12),
		associatedMSISDN BINARY(88),
		twinMasterMsisdn BINARY(12),
		twinnedState TINYINT,
		waitingGgsn BINARY(4),
		checkSSindicator TINYINT,
PRIMARY KEY USING HASH (mSubIdentificationNumberId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (mSubIdentificationNumberId);
 
drop table if exists  MSISDN;
create table MSISDN (
		subscriberNumberId BINARY(6) NOT NULL,
		nationalDestinationCodeId BINARY(3) NOT NULL,
		countryCodeId BINARY(3) NOT NULL,
		associatedSubscriptionProfile BINARY(12),
		associatedIMSI BINARY(12),
		associatedBasicServices BINARY(32),
PRIMARY KEY USING HASH (subscriberNumberId,nationalDestinationCodeId,countryCodeId) ) engine=ndb PARTITION BY KEY (subscriberNumberId);
 
drop table if exists  ServiceNode;
create table ServiceNode (
		serviceNodeAddressId INT NOT NULL,
		serverAddress BINARY(10),
PRIMARY KEY USING HASH (serviceNodeAddressId) ) engine=ndb PARTITION BY KEY (serviceNodeAddressId);
 
drop table if exists  VlrPhase1Data;
create table VlrPhase1Data (
		vlrPhase1Id INT NOT NULL,
		addressVlrPh1 BINARY(10),
PRIMARY KEY USING HASH (vlrPhase1Id) ) engine=ndb PARTITION BY KEY (vlrPhase1Id);
 
drop table if exists  ConfGlobalHlrData;
create table ConfGlobalHlrData (
		confGlobalHlrDataId INTEGER NOT NULL,
		sponMsgOnIntraPlmnFallback BIT(1),
		lengthPlmnLocalDPC TINYINT,
		lengthPlmnNationalDPC TINYINT,
		lengthPlmnInternationalDPC TINYINT,
		localHlrIsdnNumber BINARY(10),
		smsIwmscIsdnNumber BINARY(10),
		defaultTranslationPhase TINYINT,
		msRestrictionByDefault TINYINT,
		arrayOfServiceKeysTCSI BINARY(65),
		globalNullScpAddress BINARY(10),
PRIMARY KEY USING HASH (confGlobalHlrDataId) ) engine=ndb PARTITION BY KEY (confGlobalHlrDataId);
 
drop table if exists  ContractGlobalHlrData;
create table ContractGlobalHlrData (
		contractGlobalHlrDataId INTEGER NOT NULL,
		maxNumberHplmn TINYINT,
		homeCC BINARY(3),
		homeNDC BINARY(3),
PRIMARY KEY USING HASH (contractGlobalHlrDataId) ) engine=ndb PARTITION BY KEY (contractGlobalHlrDataId);
 
drop table if exists  ContractPlmnData;
create table ContractPlmnData (
		contractPlmnId INTEGER NOT NULL,
		fVh001 BIT(1),
		fVh002 BIT(1),
		fVh005 BIT(1),
		fSOR001 BIT(1),
		fSOR005 BIT(1),
PRIMARY KEY USING HASH (contractPlmnId) ) engine=ndb PARTITION BY KEY (contractPlmnId);
 
drop table if exists  ContractTranslatorData;
create table ContractTranslatorData (
		contractTranslatorId INTEGER NOT NULL,
		fTRN001 BIT(1),
		fTR012 BIT(1),
		fTR025 BIT(1),
		fCF012 BIT(1),
		defaultNumberingPlan TINYINT,
		maxLoops TINYINT,
		defaultWorldZoneNumber BINARY(2),
PRIMARY KEY USING HASH (contractTranslatorId) ) engine=ndb PARTITION BY KEY (contractTranslatorId);
 
drop table if exists  ContractSubscriptionData;
create table ContractSubscriptionData (
		contractSubscriptionId INTEGER NOT NULL,
		fCS001 BIT(1),
		fCS002 BIT(1),
		fHB001 BIT(1),
		fHB002 BIT(1),
		fHB003 BIT(1),
		fSA012 BIT(1),
		fSA015 BIT(1),
		fINTER001 BIT(1),
		fINTER003 BIT(1),
		fSMS001 BIT(1),
		fSMS004 BIT(1),
		fSMS005 BIT(1),
		fSMS006 BIT(1),
		fSMS010 BIT(1),
		fRS001 BIT(1),
		fRS002 BIT(1),
		fIC001 BIT(1),
		fIC002 BIT(1),
		contMaxMSISDN INT,
		contMaxSubscriptions INT,
		contMscatHotBilling BINARY,
		contMscatInterception BINARY,
		contMscatCAT0 BINARY,
		contMscatCAT1 BINARY,
		contMscatCAT2 BINARY,
		contMscatCAT3 BINARY,
		contMscatCAT4 BINARY,
		contMscatCAT5 BINARY,
		contMscatCAT6 BINARY,
		contMscatCAT7 BINARY,
		contMscatCAT8 BINARY,
		contMscatCAT9 BINARY,
		contMscatCAT10 BINARY,
		contMscatCAT11 BINARY,
		contMscatCAT12 BINARY,
		contMscatCAT13 BINARY,
		contMscatCAT14 BINARY,
		contMscatCAT15 BINARY,
		contMscatDefault BINARY,
		catFixedCellularSubs TINYINT,
		percentImsiChange TINYINT,
PRIMARY KEY USING HASH (contractSubscriptionId) ) engine=ndb PARTITION BY KEY (contractSubscriptionId);
 
drop table if exists  ContractSecurityData;
create table ContractSecurityData (
		contractSecurityId INTEGER NOT NULL,
		nbOfAuthVectorsSentWithoutGT TINYINT,
		nbOfAuthVectorsSentWithGT TINYINT,
PRIMARY KEY USING HASH (contractSecurityId) ) engine=ndb PARTITION BY KEY (contractSecurityId);
 
drop table if exists  ContractSupplementaryServiceData;
create table ContractSupplementaryServiceData (
		contractSupplementaryServiceId INTEGER NOT NULL,
		fCF001 BIT(1),
		fCF002 BIT(1),
		fCF003 BIT(1),
		fCF004 BIT(1),
		fCF010 BIT(1),
		fCF021 BIT(1),
		fCF022 BIT(1),
		fCF028 BIT(1),
		fCF029 BIT(1),
		fCF031 BIT(1),
		fCF032 BIT(1),
		fCF033 BIT(1),
		fCF034 BIT(1),
		fCFD001 BIT(1),
		fCFD002 BIT(1),
		cfApplicability BIT(4),
		cfuOptionForNotif BIT(1),
		cfuOptionToCallPartyFlag BIT(1),
		cfbusyOptionForNotif BIT(1),
		cfbusyOptionToCallPartyFlag BIT(1),
		cfnreplyOptionForNotif BIT(1),
		cfnreplyOptionToCallPartyFlag BIT(1),
		cfnreachOptionForNotif BIT(1),
		cfnreachOptionToCallPartyFlag BIT(1),
		fODB001 BIT(1),
		fODB003 BIT(1),
		fODB004 BIT(1),
		fODB006 BIT(1),
		fODB007 BIT(1),
		fODB008 BIT(1),
		fODB009 BIT(1),
		fCCBS001 BIT(1),
		fCCBS003 BIT(1),
		fCCBS005 BIT(1),
		fCCBS007 BIT(1),
		fCCBS010 BIT(1),
		fECT002 BIT(1),
		fCUG002 BIT(1),
		fAR001 BIT(1),
		fCFOP001 BIT(1),
		fRL001 BIT(1),
		fRP002 BIT(1),
		fUSSD001 BIT(1),
		fIN011 BIT(1),
		fUS002 BIT(1),
		hCAN001 BIT(1),
		fPDP001 BIT(1),
		cfOptionForNotification BINARY(8),
		noReplyConditionTimerDefault BINARY(6),
		noReplyGlobalConditionTimer TINYINT,
		confRestrictionType TINYINT,
		codeofOSSS BINARY(16),
		IndicatorsofOSSS BINARY(16),
		oSSStriggerValueMSISDN TINYINT,
		oSSStriggerValueBAOC TINYINT,
PRIMARY KEY USING HASH (contractSupplementaryServiceId) ) engine=ndb PARTITION BY KEY (contractSupplementaryServiceId);
 
drop table if exists  ContractLocationSecurityData;
create table ContractLocationSecurityData (
		contractLocationSecurityId INTEGER NOT NULL,
		fLR002 BIT(1),
		fLR003 BIT(1),
		fLR007 BIT(1),
		fLR008 BIT(1),
		fLR012 BIT(1),
		fLR014 BIT(1),
		fLR017 BIT(1),
		fLR021 BIT(1),
		fLR022 BIT(1),
		fLR034 BIT(1),
		fLR035 BIT(1),
		fSC013 BIT(1),
		fSC015 BIT(1),
		fSC016 BIT(1),
		fSC018 BIT(1),
		fFCS001 BIT(1),
PRIMARY KEY USING HASH (contractLocationSecurityId) ) engine=ndb PARTITION BY KEY (contractLocationSecurityId);
 
drop table if exists  ContractTcData;
create table ContractTcData (
		contractTCId INTEGER NOT NULL,
		fTC001 BIT(1),
		fTC003 BIT(1),
		fTC004 BIT(1),
		fTC005 BIT(1),
		fTC006 BIT(1),
		fTC008 BIT(1),
		fTC009 BIT(1),
		fTC010 BIT(1),
		fTC011 BIT(1),
		fTC013 BIT(1),
		fTC014 BIT(1),
		fTC017 BIT(1),
		fTC020 BIT(1),
		fTC022 BIT(1),
		fTC023 BIT(1),
		fTC024 BIT(1),
		fTC025 BIT(1),
		fTC031 BIT(1),
		fTC032 BIT(1),
		fTC036 BIT(1),
		fIN001 BIT(1),
PRIMARY KEY USING HASH (contractTCId) ) engine=ndb PARTITION BY KEY (contractTCId);
 
drop table if exists  ForeignPlmn;
create table ForeignPlmn (
		foreignPlmnId CHAR(16) NOT NULL,
		sccpSegmentation BIT(1),
		fPlmnLabel CHAR(31),
		phaseAllowedForFLoccanOutAC TINYINT,
		phaseAllowedForFRnbenqOutAC TINYINT,
		phaseAllowedForFHlrrstOutAC TINYINT,
		phaseAllowedForFSubdtmOutAC TINYINT,
		phaseAllowedForFTrcingOutAC TINYINT,
		phaseAllowedForFNwusshOutAC TINYINT,
		phaseAllowedForFSmalrtOutAC TINYINT,
		phaseAllowedForFSinenqOutAC TINYINT,
		phaseAllowedForFReportOutAC TINYINT,
		phaseAllowedForFSsnotiOutAC TINYINT,
		phaseAllowedForFLocupdIncAC TINYINT,
		phaseAllowedForFImsirtIncAC TINYINT,
		phaseAllowedForFInfretIncAC TINYINT,
		phaseAllowedForFLocretIncAC TINYINT,
		phaseAllowedForFNwfsshIncAC TINYINT,
		phaseAllowedForFNwusshIncAC TINYINT,
		phaseAllowedForFSmgwayIncAC TINYINT,
		phaseAllowedForFSmwdtmIncAC TINYINT,
		phaseAllowedForFMspurgIncAC TINYINT,
		phaseAllowedForFAtienqIncAC TINYINT,
		phaseAllowedForFGplcupIncAC TINYINT,
		phaseAllowedForFReportIncAC TINYINT,
		phaseAllowedForFCcompIncAC TINYINT,
		phaseAllowedForFAufailIncAC TINYINT,
		phaseAllowedForFLcsgwIncAC TINYINT,
		phaseAllowedForFAthrqIncAC TINYINT,
PRIMARY KEY USING HASH (foreignPlmnId) ) engine=ndb PARTITION BY KEY (foreignPlmnId);
 
drop table if exists  SystemData;
create table SystemData (
		sysGprsId INTEGER NOT NULL,
		maxPdpProfileId INT,
		maxPdpContextPerMs TINYINT,
		maxWaitingGgsnPerMs TINYINT,
		validityDurationOfGgsnNb INT,
PRIMARY KEY USING HASH (sysGprsId) ) engine=ndb PARTITION BY KEY (sysGprsId);
 
drop table if exists  SysProtocolData;
create table SysProtocolData (
		sysProtocolId INTEGER NOT NULL,
		fVH004 BIT(1),
		fDA053 BIT(1),
		fDA054 BIT(1),
		fTC012 BIT(1),
		maxNumberOfSmsScWaiting TINYINT,
		vlrUpdateReAttempt INT,
		timeToPreventRace INT,
		maxNbAlerAttempts INT,
		timerSecondComponent INT,
		delayAlertMsgResult INT,
		smsCenterAlertPeriod INT,
PRIMARY KEY USING HASH (sysProtocolId) ) engine=ndb PARTITION BY KEY (sysProtocolId);
 
drop table if exists  SysTranslatorData;
create table SysTranslatorData (
		sysTranslatorId INTEGER NOT NULL,
		maxLengthTranslatorLabel TINYINT,
		maxNumberingPhase TINYINT,
		maxTranslatorResult SMALLINT,
		maxAnalysisBlock INT,
		maxTranslatorNumber TINYINT,
		strMaxLengthDigits TINYINT,
PRIMARY KEY USING HASH (sysTranslatorId) ) engine=ndb PARTITION BY KEY (sysTranslatorId);
 
drop table if exists  SysSubscriptionData;
create table SysSubscriptionData (
		sysSubscriptionId INTEGER NOT NULL,
		fSA011 BIT(1),
		fHLRID001 BIT(1),
		fRP001 BIT(1),
		fSMS008 BIT(1),
		maxNumberOfMsisdnPerMS TINYINT,
		nationalCategories BINARY(33),
		mscatORDINSUB BINARY,
		maxMSISDN INT,
		triggeringType BINARY(33),
		decisionUnsupFeatureMapV1 BINARY(44),
		decisionUnsupFeatureMapV2 BINARY(44),
		decisionUnsupFeatureMapV3 BINARY(44),
		decisionUnsupFeatureGprsMapV3 BINARY(2),
PRIMARY KEY USING HASH (sysSubscriptionId) ) engine=ndb PARTITION BY KEY (sysSubscriptionId);
 
drop table if exists  SysCamelData;
create table SysCamelData (
		sysCamelId INTEGER NOT NULL,
		sysCamelNbDialNbCrit TINYINT,
		sysCamelNbLengthDestCrit TINYINT,
		sysCamelNbCauseValueCrit TINYINT,
		sysCamelNbBasicServCrit TINYINT,
PRIMARY KEY USING HASH (sysCamelId) ) engine=ndb PARTITION BY KEY (sysCamelId);
 
drop table if exists  SysLocationSecurityData;
create table SysLocationSecurityData (
		sysLocationSecurityId INTEGER NOT NULL,
		fLR023 BIT(1),
		fLR027 BIT(1),
		fLR033 BIT(1),
PRIMARY KEY USING HASH (sysLocationSecurityId) ) engine=ndb PARTITION BY KEY (sysLocationSecurityId);
 
drop table if exists  SysPlmnData;
create table SysPlmnData (
		sysPlmnId INTEGER NOT NULL,
		maxNumberFplmn SMALLINT,
		maxLengthPlmnLabel TINYINT,
		smLocAc TINYINT,
		maxPhaseForLoccanOutAC TINYINT,
		maxPhaseForRnbenqOutAC TINYINT,
		maxPhaseForHlrrstOutAC TINYINT,
		maxPhaseForSubdtmOutAC TINYINT,
		maxPhaseForTrcingOutAC TINYINT,
		maxPhaseForNwusshOutAC TINYINT,
		maxPhaseForSmalrtOutAC TINYINT,
		maxPhaseForSinenqOutAC TINYINT,
		maxPhaseForReportOutAC TINYINT,
		maxPhaseForSsnotiOutAC TINYINT,
		maxPhaseForGpnotOutAC TINYINT,
		lowPhaseForLoccanOutAC TINYINT,
		lowPhaseForRnbenqOutAC TINYINT,
		lowPhaseForHlrrstOutAC TINYINT,
		lowPhaseForSubdtmOutAC TINYINT,
		lowPhaseForTrcingOutAC TINYINT,
		lowPhaseForNwusshOutAC TINYINT,
		lowPhaseForSmalrtOutAC TINYINT,
		lowPhaseForSinenqOutAC TINYINT,
		lowPhaseForReportOutAC TINYINT,
		lowPhaseForSsnotiOutAC TINYINT,
		lowPhaseForGpnotOutAC TINYINT,
		lowPhaseForLocupdIncAC TINYINT,
		lowPhaseForImsirtIncAC TINYINT,
		lowPhaseForInfretIncAC TINYINT,
		lowPhaseForLocretIncAC TINYINT,
		lowPhaseForNwfsshIncAC TINYINT,
		lowPhaseForNwusshIncAC TINYINT,
		lowPhaseForSmgwayIncAC TINYINT,
		lowPhaseForSmwdtmIncAC TINYINT,
		lowPhaseForMspurgIncAC TINYINT,
		lowPhaseForAtienqIncAC TINYINT,
		lowPhaseForGplcupIncAC TINYINT,
		lowPhaseForReportIncAC TINYINT,
		lowPhaseForCcompIncAC TINYINT,
		lowPhaseForAufailIncAC TINYINT,
		lowPhaseForLcsgwIncAC TINYINT,
		lowPhaseForAthrqIncAC TINYINT,
		lowPhaseForGplocrIncAC TINYINT,
		lowPhaseForGpfailIncAC TINYINT,
PRIMARY KEY USING HASH (sysPlmnId) ) engine=ndb PARTITION BY KEY (sysPlmnId);
 
drop table if exists  CsServiceProfile;
create table CsServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		singleNumbering BIT(1),
		odbPremiumRateCalls BIT(2),
		odbSuplServiceMngt BIT(1),
		odbCfFTNRegistration BIT(8),
		odbECTInvocation BIT(4),
		odbECTDoublyChargeable BIT(1),
		odbMultipleECT BIT(1),
		csRoamingRestrictionType TINYINT,
		csRestrictionListId BINARY(16),
		csRegRestrictionListId BINARY(34),
		csAllocationRetentionPriority TINYINT,
		preferedCarrier BINARY(4),
		msCategory BINARY,
		mobileNetworkCodeId BINARY(3),
		mobileCountryCodeId BINARY(3),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  PSserviceProfile;
create table PSserviceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		chargingCharacteristics BIT(4),
		pdpContext BINARY(7),
		psRoamingRestrictionType TINYINT,
		psRestrictionListId BINARY(16),
		psRegRestrictionListId BINARY(34),
		odbSpecificToPs TINYINT,
		mobileNetworkCodeId BINARY(3),
		mobileCountryCodeId BINARY(3),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  ServiceCodeMnemonic;
create table ServiceCodeMnemonic (
		serviceCodeMnemonicId CHAR(8) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		restrictedApplicabillity BIT(1),
		basicServiceCategory BIT(1),
		enableMultiMediaTcCall BIT(1),
		belongToBscLink BINARY(9),
		gsmBearerCapabilityData BINARY(27),
		rowidGBC TINYINT,
PRIMARY KEY USING HASH (serviceCodeMnemonicId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (serviceCodeMnemonicId);
 
drop table if exists  GprscsiServiceProfile;
create table GprscsiServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		gprscsiPdpConChgPosTdpDfltCalH BIT(1),
		gprscsiChgPositionTdpDfltCalH BIT(1),
		gprscsiAttachProcTdpDfltCalH BIT(1),
		gprscsiCamelSubState BIT(1),
		gprscsiCamelCapabilityHandling BIT(6),
		gprscsiCamelSgsnNotSuppDfltHdl BIT(1),
		camelMarkInhibitionRoamersPs BIT(1),
		gprscsiPdpConEstAckTdpDfltCalH BIT(1),
		gprscsiPdpConEstabTdpDfltCalH BIT(1),
		gprscsiPdpConChgPosTdpServKey INT,
		gprscsiPdpConChgPosTdpScpIsdn BINARY(4),
		gprscsiChgPositionTdpServKey INT,
		gprscsiChgPositionTdpScpIsdn BINARY(4),
		gprscsiAttachProcTdpServKey INT,
		gprscsiAttachProcTdpScpIsdn BINARY(4),
		gprscsiPdpConEstAckTdpServKey INT,
		gprscsiPdpConEstAckTdpScpIsdn BINARY(4),
		gprscsiPdpConEstabTdpServKey INT,
		gprscsiPdpConEstabTdpScpIsdn BINARY(4),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  McsiServiceProfile;
create table McsiServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		mobilityTriggers BIT(5),
		mcsiCamelSubState BIT(1),
		mcsiCamelVlrNotSuppDfltHdl BIT(1),
		mcsiServKey INT,
		mcsiScpIsdn BINARY(4),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  SmocsiServiceProfile;
create table SmocsiServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		smocsiCollectedInfoTdpDfltCalH BIT(1),
		smocsiCamelSubState BIT(1),
		smocsiCamelCapabilityHandling BIT(6),
		smocsiCamelNotSuppDfltHdl BIT(1),
		smocsiCollectedInfoTdpServKey INT,
		smocsiCollectedInfoTdpScpIsdn BINARY(4),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  SscsiServiceProfile;
create table SscsiServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		sscsiCheckSSindicator BIT(2),
		sscsiCamelSubState BIT(1),
		sscsiCamelVlrNotSuppDfltHdl BIT(1),
		sscsiScpIsdn BINARY(4),
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  UcsiCamelService;
create table UcsiCamelService (
		ucsiCamelServiceId INT NOT NULL,
		suMSubscriberProfileId CHAR(12) NOT NULL,
		ucsiServiceCode BINARY(4),
		ucsiScpIsdn BINARY(4),
PRIMARY KEY USING HASH (ucsiCamelServiceId,suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (ucsiCamelServiceId);
 
drop table if exists  VlrWithoutSor;
create table VlrWithoutSor (
		vlrWithoutSorId INT NOT NULL,
		addressVlrWithoutSor BINARY(10),
PRIMARY KEY USING HASH (vlrWithoutSorId) ) engine=ndb PARTITION BY KEY (vlrWithoutSorId);
 
drop table if exists  GlobalUssdCamel;
create table GlobalUssdCamel (
		globalUssdCamelId INT NOT NULL,
		globalCodingAlphabet TINYINT,
		globalServiceCode BINARY(17),
		globalUcsiScpAddress BINARY(10),
PRIMARY KEY USING HASH (globalUssdCamelId) ) engine=ndb PARTITION BY KEY (globalUssdCamelId);
 
drop table if exists  ContractAucData;
create table ContractAucData (
		contractAucId INTEGER NOT NULL,
		fSS001 BIT(1),
		fSS002 BIT(1),
		fSS006 BIT(1),
		fSS007 BIT(1),
		fSS008 BIT(1),
		k2algo BIT(4),
		k4algo BIT(4),
		supportedAlgoritmGsm TINYINT,
		contAucMaxIMSI INT,
		supportedAlgoritmUMTS TINYINT,
		validityWindowOfTheSQNms BINARY(6),
PRIMARY KEY USING HASH (contractAucId) ) engine=ndb PARTITION BY KEY (contractAucId);
 
drop table if exists  SysAucData;
create table SysAucData (
		sysAUCId INTEGER NOT NULL,
		aucMaxIMSI INT,
		KTST BINARY(18),
PRIMARY KEY USING HASH (sysAUCId) ) engine=ndb PARTITION BY KEY (sysAUCId);
 
drop table if exists  SysSupplementaryService;
create table SysSupplementaryService (
		sysSupplementaryServiceId INTEGER NOT NULL,
		msCbAbilityByDefault BIT(1),
		maxNumberofForwarding TINYINT,
		maxWrongSuccessiveCbPwdAllowed TINYINT,
		cbPasswordDefaultValue BINARY(2),
PRIMARY KEY USING HASH (sysSupplementaryServiceId) ) engine=ndb PARTITION BY KEY (sysSupplementaryServiceId);
 
drop table if exists  Postponed;
create table Postponed (
		postponedId INTEGER NOT NULL,
		fCT001 BIT(1),
		fLCS001 BIT(1),
		fCF035 BIT(1),
		fSP001 BIT(1),
PRIMARY KEY USING HASH (postponedId) ) engine=ndb PARTITION BY KEY (postponedId);
 
drop table if exists  SSiBSG;
create table SSiBSG (
		sSiBSGId BINARY NOT NULL,
		ssInThePLMNId BINARY(2) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		tcOcApplicableBSC BINARY(24),
		ocApplicableBSC BINARY(24),
PRIMARY KEY USING HASH (sSiBSGId,ssInThePLMNId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (sSiBSGId);
 
drop table if exists  CamelServiceCode;
create table CamelServiceCode (
		camelServiceCodeId INT NOT NULL,
		codingAlphabet TINYINT,
		serviceCode BINARY(17),
PRIMARY KEY USING HASH (camelServiceCodeId) ) engine=ndb PARTITION BY KEY (camelServiceCodeId);
 
drop table if exists  ServiceTranslator;
create table ServiceTranslator (
		serviceTranslatorId INT NOT NULL,
		blockNumberMask1 BINARY(250),
		blockNumberMask2 BINARY(250),
		nbAnalysisBlock SMALLINT,
PRIMARY KEY USING HASH (serviceTranslatorId) ) engine=ndb PARTITION BY KEY (serviceTranslatorId);
 
drop table if exists  CallTraceServiceProfile;
create table CallTraceServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  CBServiceProfile;
create table CBServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		msCbAbility BIT(1),
		barOutCallProv BIT(1),
		barOutInterCallProv BIT(1),
		barOutIntCallExceptToHplmnProv BIT(1),
		barIncCallProvisioned BIT(1),
		barIncCallRoamFCountryProv BIT(1),
		callBarringPassword BINARY(2),
		cbPwdSuccErroneousAttempts TINYINT,
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  CallForwardingServiceProfile;
create table CallForwardingServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		msCfNoAbility BIT(1),
		ftnRegSponSent BIT(1),
		cfuProvisionedFlag BIT(1),
		cfuNotifToFwdPartyFlag BIT(1),
		cfuNotifToCallingPartyFlag BIT(1),
		cfbusyProvisionedFlag BIT(1),
		cfbusyNotifToFwdPartyFlag BIT(1),
		cfbusyNotifToCallingPartyFlag BIT(1),
		cfnreplyProvisionedFlag BIT(1),
		cfnreplyNotifToFwdPartyFlag BIT(1),
		cfnreplyNotifToCallingPartFlag BIT(1),
		cfnreachProvisionedFlag BIT(1),
		cfnreachNotifToFwdPartyFlag BIT(1),
		cfnreachNotifToCallingPartFlag BIT(1),
		cfdProvisionedFlag BIT(1),
		supOfFtnRegCount TINYINT,
		ftnRegSubsPeriod SMALLINT,
		destinationProfile TINYINT,
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  CFiBSG;
create table CFiBSG (
		cFiBSGId BINARY NOT NULL,
		callForwardingTypeId BINARY NOT NULL,
		suMSubscriberProfileId CHAR(12) NOT NULL,
		cfRegistrationFlag BIT(1),
		cfActivationFlag BIT(1),
		quiescentDueToCBOIx BIT(1),
		quiescentDueToCFU BIT(1),
		quiescentDueToCBRoaming BIT(1),
		quiescentDueToODB BIT(1),
		flagDefaultNumberInUsed BIT(1),
		forwardedToNumber BINARY(10),
		subAddressValue BINARY(22),
		noReplyConditionTimer TINYINT,
PRIMARY KEY USING HASH (cFiBSGId,callForwardingTypeId,suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (cFiBSGId);
 
drop table if exists  GeneralCallServiceProfile;
create table GeneralCallServiceProfile (
		suMSubscriberProfileId CHAR(12) NOT NULL,
		colpProvisionedFlag BIT(1),
		colpOverrideCategoryState BIT(1),
		clirProvisionedFlag BIT(1),
		callHoldProvisionedFlag BIT(1),
		mptyProvisionedFlag BIT(1),
		callTransferProvisionedFlag BIT(1),
		aoccProvisionedFlag BIT(1),
		aociProvisionedFlag BIT(1),
		maliciousCallProvisionedFlag BIT(1),
		colrProvisionedFlag BIT(1),
		clipProvisionedFlag BIT(1),
		clipOverrideCategoryState BIT(1),
		osss1ProvisionedFlag BIT(1),
		osss1ActivationFlag BIT(1),
		osss2ProvisionedFlag BIT(1),
		osss2ActivationFlag BIT(1),
		osss3ProvisionedFlag BIT(1),
		osss3ActivationFlag BIT(1),
		osss4ProvisionedFlag BIT(1),
		osss4ActivationFlag BIT(1),
		osss5ProvisionedFlag BIT(1),
		osss5ActivationFlag BIT(1),
		osss6ProvisionedFlag BIT(1),
		osss6ActivationFlag BIT(1),
		osss7ProvisionedFlag BIT(1),
		osss7ActivationFlag BIT(1),
		osss8ProvisionedFlag BIT(1),
		osss8ActivationFlag BIT(1),
		osss9ProvisionedFlag BIT(1),
		osss9ActivationFlag BIT(1),
		osss10ProvisionedFlag BIT(1),
		osss10ActivationFlag BIT(1),
		osss11ProvisionedFlag BIT(1),
		osss11ActivationFlag BIT(1),
		osss12ProvisionedFlag BIT(1),
		osss12ActivationFlag BIT(1),
		osss13ProvisionedFlag BIT(1),
		osss13ActivationFlag BIT(1),
		osss14ProvisionedFlag BIT(1),
		osss14ActivationFlag BIT(1),
		osss15ProvisionedFlag BIT(1),
		osss15ActivationFlag BIT(1),
		callWaitingProvisionedFlag BIT(1),
		cwTSSpeechActivationFlag BIT(1),
		cwTSFaxActivationFlag BIT(1),
		cwGBS20ActivationFlag BIT(1),
		cwGBS30ActivationFlag BIT(1),
		cwGBS40ActivationFlag BIT(1),
		presentationMode TINYINT,
PRIMARY KEY USING HASH (suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (suMSubscriberProfileId);
 
drop table if exists  ConfAucData;
create table ConfAucData (
		confAucDataId INTEGER NOT NULL,
		oldK2index BIT(4),
		currentK2index BIT(4),
		oldK2Key BINARY(16),
		currentK2Key BINARY(16),
		k4Key BINARY(16),
		AMF BINARY(2),
PRIMARY KEY USING HASH (confAucDataId) ) engine=ndb PARTITION BY KEY (confAucDataId);
 
drop table if exists  ossOperationType;
create table ossOperationType (
		ossOperationTypeId BINARY NOT NULL,
		ssInThePLMNId BINARY(2) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		stringIA5 BINARY(17),
		stringUssd BINARY(17),
		stringUcs2 BINARY(17),
PRIMARY KEY USING HASH (ossOperationTypeId,ssInThePLMNId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (ossOperationTypeId);
 
drop table if exists  osssResultType;
create table osssResultType (
		ossResultTypeId BINARY NOT NULL,
		ossOperationTypeId BINARY NOT NULL,
		ssInThePLMNId BINARY(2) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		resStringIA5 BINARY(17),
		resStringUssd BINARY(17),
		resStringUcs2 BINARY(17),
PRIMARY KEY USING HASH (ossResultTypeId,ossOperationTypeId,ssInThePLMNId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (ossResultTypeId);
 
drop table if exists  ConfigurationTrigger;
create table ConfigurationTrigger (
		configurationTriggerId INTEGER NOT NULL,
		hyr_hlg INT,
		hyr_hls INT,
		hyr_ugc INT,
		hyr_svl INT,
		hyr_vp1 INT,
		hyr_net INT,
		hyr_bss INT,
		hyr_lbs INT,
		hyr_ibc INT,
		hyr_gbc INT,
		hyr_lss INT,
		hyr_osi INT,
		hyr_osr INT,
		hyr_rst INT,
		hyr_scs INT,
PRIMARY KEY USING HASH (configurationTriggerId) ) engine=ndb PARTITION BY KEY (configurationTriggerId);
 
drop table if exists  Auc;
create table Auc (
		mSubIdentificationNumberId BINARY(6) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		authenticationSubscriberType BIT(4),
		thek2Index BIT(4),
		authenticationKeyNumber BINARY(16),
		algorithmPosition TINYINT,
		csSequenceNumber BINARY(6),
		psSequenceNumber BINARY(6),
PRIMARY KEY USING HASH (mSubIdentificationNumberId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (mSubIdentificationNumberId);
 
drop table if exists  CBBSG;
create table CBBSG (
		callBarringBSGId BINARY NOT NULL,
		callBarringTypeId BINARY NOT NULL,
		suMSubscriberProfileId CHAR(12) NOT NULL,
		cbRegistrationFlag BIT(1),
		cbActivationFlag BIT(1),
		quiescentDueToRoamingBaicRoam BIT(1),
		quiescentDueToCFUBaicRoam BIT(1),
PRIMARY KEY USING HASH (callBarringBSGId,callBarringTypeId,suMSubscriberProfileId) ) engine=ndb PARTITION BY KEY (callBarringBSGId);
 
drop table if exists  TranslatorTrigger;
create table TranslatorTrigger (
		translatorTriggerId INTEGER NOT NULL,
		hyr_trd INT,
		hyr_trr INT,
PRIMARY KEY USING HASH (translatorTriggerId) ) engine=ndb PARTITION BY KEY (translatorTriggerId);
 
drop table if exists  AucTrigger;
create table AucTrigger (
		aucTriggerId INTEGER NOT NULL,
		k2Change INT,
		k4Change INT,
		amfChange INT,
PRIMARY KEY USING HASH (aucTriggerId) ) engine=ndb PARTITION BY KEY (aucTriggerId);
 
drop table if exists  ContractOverloadAlarm;
create table ContractOverloadAlarm (
		contractOverloadAlarmId INTEGER NOT NULL,
		g1TrafficCapacity INT,
		x1ToSetUpOverloadG1 TINYINT,
		g2CpuThreshohdRealTime TINYINT,
		x1ReqCsTriplet TINYINT,
		x2ReqCsQuintuplet TINYINT,
		x3ReqPsTriplet TINYINT,
		x4ReqPsQuintuplet TINYINT,
		x5CsUpdateLocation TINYINT,
		x6SsAndUssd TINYINT,
		x7SmsEfficient TINYINT,
		x8SmsInefficient TINYINT,
		x9AlertAndReadySM TINYINT,
		x10IncomingWithoutMSRN TINYINT,
		x11IncomingWithMSRN TINYINT,
		x12CamelEfficient TINYINT,
		x13PsUpdateLocation TINYINT,
		x14ForATM TINYINT,
		x15ForPSI TINYINT,
		x16ReqLCSCallUnrelated TINYINT,
		x17ReqPdpCtx TINYINT,
		g1CsLocationUpdate TINYINT,
		g1PsLocationUpdate TINYINT,
		g1InfoRetrieval TINYINT,
		g1AlertFromMsc TINYINT,
		g1SgsnPurgeMs TINYINT,
		g1ShortMsgGateway TINYINT,
		g1MwdMngt TINYINT,
		g1LocationInfoRetrieval TINYINT,
		g1AnyTimeEnquiry TINYINT,
		g1VlrReport TINYINT,
		g1LocServiceGmlc TINYINT,
		g1SSFunctionFromVlr TINYINT,
		g1CallCompleteVlr TINYINT,
		g1UssdVlr TINYINT,
		g1ImsiRetrievalVlr TINYINT,
		g1GprsLocationRetrieval TINYINT,
		g1GprsFailureReport TINYINT,
		g1AuthentificationFailure TINYINT,
		g2CsLocationUpdate TINYINT,
		g2PsLocationUpdate TINYINT,
		g2InfoRetrieval TINYINT,
		g2AlertFromMsc TINYINT,
		g2SgsnPurgeMs TINYINT,
		g2ShortMsgGateway TINYINT,
		g2MwdMngt TINYINT,
		g2LocationInfoRetrieval TINYINT,
		g2AnyTimeEnquiry TINYINT,
		g2VlrReport TINYINT,
		g2LocServiceGmlc TINYINT,
		g2SSFunctionFromVlr TINYINT,
		g2CallCompleteVlr TINYINT,
		g2UssdVlr TINYINT,
		g2ImsiRetrievalVlr TINYINT,
		g2GprsLocationRetrieval TINYINT,
		g2GprsFailureReport TINYINT,
		g2AuthentificationFailure TINYINT,
PRIMARY KEY USING HASH (contractOverloadAlarmId) ) engine=ndb PARTITION BY KEY (contractOverloadAlarmId);
 
drop table if exists  ContractInitAudit;
create table ContractInitAudit (
		contractInitAuditId INTEGER NOT NULL,
		delayBeforeFirstResetVhTable TINYINT,
		dayTimeforResetVhTable TINYINT,
		delaybetweenResetVhTable TINYINT,
		nbRecordToResetVhAudit TINYINT,
PRIMARY KEY USING HASH (contractInitAuditId) ) engine=ndb PARTITION BY KEY (contractInitAuditId);
 
drop table if exists  SysInitAudit;
create table SysInitAudit (
		sysInitAuditId INTEGER NOT NULL,
		delayBeforeResetMessage INT,
		delayBetweenResetMessage INT,
		delayBeforeFirstGgsnAudit INT,
		delayBetweenGgsnAudit INT,
		timeBetweenGgsnAuditSession INT,
		nbRecToTreatGgsnAuditSession INT,
		delayValidityOfSmsCenter TINYINT,
		delayBetweenSmsAudit TINYINT,
		timeBetweenSmsAuditSession TINYINT,
		nbRecToTreatSmsAuditSession TINYINT,
PRIMARY KEY USING HASH (sysInitAuditId) ) engine=ndb PARTITION BY KEY (sysInitAuditId);
 
drop table if exists  SysOverloadAlarm;
create table SysOverloadAlarm (
		sysOverloadAlarmId INTEGER NOT NULL,
		regulationPrioCPU TINYINT,
		delayBetweenRegulation TINYINT,
		delayBeforeStartRegulation TINYINT,
		z1ToSetDownG1 TINYINT,
		z2ToSetDownG2 TINYINT,
		z4ToSetDownG4 TINYINT,
		x4ToSetUpAlarmG4 TINYINT,
PRIMARY KEY USING HASH (sysOverloadAlarmId) ) engine=ndb PARTITION BY KEY (sysOverloadAlarmId);
 
drop table if exists  PlmnRestrictionRegional;
create table PlmnRestrictionRegional (
		regionalRestrictionListId INT NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		plmnCode BINARY(4),
		zoneCode BINARY(21),
PRIMARY KEY USING HASH (regionalRestrictionListId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (regionalRestrictionListId);
 
drop table if exists  AutoImsiChange;
create table AutoImsiChange (
		mSubIdentificationNumberId BINARY(6) NOT NULL,
		mobileNetworkCodeId BINARY(3) NOT NULL,
		mobileCountryCodeId BINARY(3) NOT NULL,
		imsiStatus TINYINT,
		dateOfLinkCreation INT,
		linkToOtherIMSI BINARY(12),
PRIMARY KEY USING HASH (mSubIdentificationNumberId,mobileNetworkCodeId,mobileCountryCodeId) ) engine=ndb PARTITION BY KEY (mSubIdentificationNumberId);
 
drop table if exists  FraudPrevention;
create table FraudPrevention (
		dummyKey INTEGER NOT NULL,
		fraudPreventionMode BIT(3),
		authEventSupervisionType BIT(1),
		supOfFtnRegPeriod INT,
		supOfLocRegPeriod INT,
		supOfReqAutPeriod INT,
		supOfFtnRegThresh TINYINT,
		supOfLocReqThresh TINYINT,
		supOfReqAutThresh TINYINT,
		supOfAVSentThresh TINYINT,
		supOfFtnRegDeaCount SMALLINT,
		supOfLocReqDeaCount SMALLINT,
		supOfReqAutDeaCount SMALLINT,
		supOfFtnRegStartTime INT,
		supOfLocRegStartTime INT,
		supOfReqAutStartTime INT,
PRIMARY KEY USING HASH (dummyKey) ) engine=ndb PARTITION BY KEY (dummyKey);