apollo@ubuntu:/tmp/db-structure$ ls -lart
total 76
drwxrwxr-x  4 apollo apollo 4096 Nov 25 09:27 warehouse-shard
drwxrwxr-x  2 apollo apollo 4096 Nov 25 09:27 utils
drwxrwxr-x  4 apollo apollo 4096 Nov 25 09:27 smb-services
-rw-rw-r--  1 apollo apollo   95 Nov 25 09:27 README.txt
drwxrwxr-x  4 apollo apollo 4096 Nov 25 09:27 global-sesystem
-rw-rw-r--  1 apollo apollo    4 Nov 25 09:27 .gitignore
-rwxrwxr-x  1 apollo apollo 3957 Nov 25 09:27 generate_db_structure.sh
-rwxrwxrwx  1 apollo apollo 1931 Nov 25 09:27 create-all-wrapper.sh
-rwxrwxr-x  1 apollo apollo 4432 Nov 25 09:27 create_all.sh
drwxrwxr-x  4 apollo apollo 4096 Nov 25 09:27 account-shard
drwxrwxr-x  3 apollo apollo 4096 Nov 25 09:27 tsa-services
drwxrwxr-x  4 apollo apollo 4096 Nov 25 09:27 pdi-staging
-rwxrwxr-x  1 apollo apollo  369 Nov 25 09:27 makestructure
drwxrwxr-x  4 apollo apollo 4096 Nov 25 09:27 global-tsacommon-master
-rwxrwxr-x  1 apollo apollo  245 Nov 25 10:04 create-all-aml.sh
drwxrwxr-x 10 apollo apollo 4096 Nov 25 10:07 .
drwxrwxrwt 27 root   root   4096 Nov 25 10:07 ..
-rw-rw-r--  1 apollo apollo    5 Nov 25 10:07 NUL
apollo@ubuntu:/tmp/db-structure$ ./create-all-aml.sh

This script will create a new set of database schemas in a target MySQL
instance.  If this is not your intention, hit ctrl-c to exit. Otherwise,
fill in the appropriate connection info below.

Setting up databases:  clients logging staging tsacommon

Creating database users and applying grants.

Creating database clients ...
create database IF NOT EXISTS `clients` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/accountMigrations.sql
tables/externalCampaignJobItem.sql
tables/externalCampaignJob.sql
tables/externalCampaignJobType.sql
tables/externalCampaignParentDeployStatus.sql
tables/externalCampaignParent.sql
tables/externalCampaign.sql
data/externalCampaignJobType.sql

Creating database logging ...
create database IF NOT EXISTS `logging` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/accountChanges.sql
tables/searchEngineAccountChanges.sql
tables/searchEngineUserChanges.sql
tables/siteChanges.sql
tables/userAccountMapChanges.sql
tables/userChanges.sql

Creating database staging ...
create database IF NOT EXISTS `staging` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/askDailyCheck.sql
tables/askReports.sql
tables/bingAdMax.sql
tables/bingClicks.sql
tables/bingDailyCheck.sql
tables/bingPerformanceReports.sql
tables/discrepancies.sql
tables/googleClicks.sql
tables/googleDailyCheck.sql
tables/googleMccAdMax.sql
tables/googleMcc.sql
tables/googleSummaryCheck.sql
tables/msnDailyCheck.sql
tables/msnDailyCheckV5.sql
tables/msnReports.sql
tables/msnReportsV5.sql
tables/msnSummaryCheck.sql
tables/overtureDailyCheck.sql
tables/overtureSummaryCheck.sql
tables/yahooDailyCheck.sql
tables/yahooGroupReports.sql
tables/yahooJAdMax.sql
tables/yahooJDailyCheck.sql
tables/yahooJPerformanceReports.sql
tables/yahooReports.sql
tables/yahooSummaryCheck.sql

Creating database tsacommon ...
create database IF NOT EXISTS `tsacommon` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/accountManagers.sql
tables/accounts.sql
tables/bidManagerServiceColumns.sql
tables/bidTypes.sql
tables/callFeedExecution.sql
tables/channels.sql
tables/creativeServiceColumns.sql
tables/databaseInstances.sql
tables/distribution.sql
tables/globalSettingDefaults.sql
tables/globalSettings.sql
tables/MSNErrorCodes.sql
tables/replicationStatus.sql
tables/replicationUpdates.sql
tables/reportColumnFormats.sql
tables/reportColumns.sql
tables/reportColumnVarTypeMap.sql
tables/reportTemplates.sql
tables/searchEngineAccounts.sql
tables/searchEngineUsers.sql
tables/sites.sql
tables/targetCodes.sql
tables/targetTypes.sql
tables/userAccountMap.sql
tables/userContacts.sql
tables/userSites.sql
tables/users.sql
views/vActiveSearchEngineAccounts.sql
data/accounts.sql
data/bidManagerServiceColumns.sql
data/bidTypes.sql
data/channels.sql
data/creativeServiceColumns.sql
data/databaseInstances.sql
data/distribution.sql
data/globalSettingDefaults.sql
data/MSNErrorCodes.sql
data/replicationStatus.sql
data/reportColumnFormats.sql
data/reportColumns.sql
data/reportColumnVarTypeMap.sql
data/reportTemplates.sql
data/targetTypes.sql
data/userAccountMap.sql
data/users.sql
triggers/accountManagerTriggers.sql
triggers/accountTriggers.sql
triggers/bidTypeTriggers.sql
triggers/callFeedExecutionTriggers.sql
triggers/channelTriggers.sql
triggers/databaseInstanceTriggers.sql
triggers/distributionTriggers.sql
triggers/globalSettingDefaultTriggers.sql
triggers/globalSettingTriggers.sql
triggers/MSNErrorCodeTriggers.sql
triggers/replicationUpdates.sql
triggers/reportColumnFormatTriggers.sql
triggers/reportColumnTriggers.sql
triggers/reportTemplateTriggers.sql
triggers/searchEngineAccountTriggers.sql
triggers/searchEngineUserTriggers.sql
triggers/siteTriggers.sql
triggers/targetCodeTriggers.sql
triggers/targetTypeTriggers.sql
triggers/userAccountMapTriggers.sql
triggers/userContactTriggers.sql
triggers/userSiteTriggers.sql
triggers/userTriggers.sql

Creating database users and applying grants.
global-tsacommon-master/permissions/post/perfreptUser.sql
global-tsacommon-master/permissions/post/perfsumUser.sql
global-tsacommon-master/permissions/post/spike.sql

Success: Database creation completed.

This script will create a new set of database schemas in a target MySQL
instance.  If this is not your intention, hit ctrl-c to exit. Otherwise,
fill in the appropriate connection info below.

Setting up databases:  sesystem

Creating database users and applying grants.

Creating database sesystem ...
create database IF NOT EXISTS `sesystem` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/googleAuthToken.sql
tables/msnLogins.sql
tables/quotaUsage.sql
tables/searchEngineConnections.sql
tables/searchEngineResources.sql
tables/searchEngineResourceUsage.sql
tables/yahooMasterAccounts.sql
tables/yahooServiceURLs.sql
data/searchEngineResources.sql

Creating database users and applying grants.
global-sesystem/permissions/post/sesystemUser.sql

Success: Database creation completed.

This script will create a new set of database schemas in a target MySQL
instance.  If this is not your intention, hit ctrl-c to exit. Otherwise,
fill in the appropriate connection info below.

Setting up databases:  pdi_staging

Creating database users and applying grants.

Creating database pdi_staging ...
create database IF NOT EXISTS `pdi_staging` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/datafeedOutputs.sql
tables/datafeedRequirements.sql
tables/datafeeds.sql
tables/dates.sql
data/dates.sql

Creating database users and applying grants.
pdi-staging/permissions/post/smb_services.sql

Success: Database creation completed.

This script will create a new set of database schemas in a target MySQL
instance.  If this is not your intention, hit ctrl-c to exit. Otherwise,
fill in the appropriate connection info below.

Setting up databases:  audit biz_function_location budget_estimate content_model content_repository ip_pool jboss_5_1_0_smb_messaging_cluster mms_common site_customization site_generation support_dashboard

Creating database users and applying grants.

Creating database audit ...
create database IF NOT EXISTS `audit` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/action.sql
tables/context.sql
tables/event.sql
tables/source.sql
tables/user.sql

Creating database biz_function_location ...
create database IF NOT EXISTS `biz_function_location` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/bfsaGrouping.sql
tables/keywordLists.sql
tables/keywords.sql

Creating database budget_estimate ...
create database IF NOT EXISTS `budget_estimate` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/bingBudgetEstimateMap.sql
tables/bingBudgetEstimates.sql
tables/googleBudgetEstimateMap.sql
tables/googleBudgetEstimates.sql
tables/yahooJBudgetEstimateMap.sql
tables/yahooJBudgetEstimates.sql

Creating database content_model ...
create database IF NOT EXISTS `content_model` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/contentField.sql
tables/customerField.sql
tables/customizableEntity.sql

Creating database content_repository ...
create database IF NOT EXISTS `content_repository` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/contentAssignmentElements.sql
tables/contentAssignments.sql
tables/contentElementTokens.sql
tables/contentElementVariations.sql
tables/contentEntityMap.sql
tables/contentGroups.sql
tables/contentImportLabelTokenMap.sql
tables/contentTypes.sql
tables/generated_ad_assignments.sql
tables/generated_ad_content.sql
tables/geocodedAddresses.sql
tables/imageAssignments.sql
tables/imageFileData.sql
tables/images.sql
tables/md_siteTemplateFileData.sql
tables/merchantAttributes.sql
tables/merchantAttributesTemp.sql
tables/siteTemplateAssignments.sql
tables/siteTemplateFileData.sql
tables/siteTemplates.sql
tables/siteTemplateTagMap.sql
tables/siteTemplateUsage.sql
tables/tags.sql
views/vTemplateTags.sql
data/contentElementTokens.sql
data/contentImportLabelTokenMap.sql
data/contentTypes.sql
data/tags.sql

Creating database ip_pool ...
create database IF NOT EXISTS `ip_pool` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/ipPool.sql

Creating database jboss_5_1_0_smb_messaging_cluster ...
jboss_5_1_0_smb_messaging_cluster.sql

Creating database mms_common ...
create database IF NOT EXISTS `mms_common` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/accounts.sql
tables/bingLocationTargets.sql
tables/blacklist.sql
tables/businessAreaLoader.sql
tables/businessAreas.sql
tables/businessCategories.sql
tables/businessCategoryAreaMap.sql
tables/businessCategoryLoader.sql
tables/businessFunctions.sql
tables/businessLocationMap.sql
tables/businessLocationPointRadiusLoader.sql
tables/businessLocations.sql
tables/businessLocationTargetMap.sql
tables/businessLocationTargets.sql
tables/businessLocationTypes.sql
tables/businessTypeFunctionMap.sql
tables/businessTypes.sql
tables/callbackEvent.sql
tables/campaigns.sql
tables/campUpdateResp.sql
tables/coverageLocationMap.sql
tables/customerCampaignIdMap.sql
tables/exemptionRequests.sql
tables/googleLocationTargets.sql
tables/languages.sql
tables/locationAliasesLoader.sql
tables/locationAliases.sql
tables/pointRadiusModifiers.sql
tables/pointRadius.sql
tables/postcodeLocationMap.sql
tables/requests.sql
tables/yahooJLocationTargets.sql
data/bingLocationTargets.sql
data/contentImportLabelTokenMap.sql
data/exemptionRequests.sql
data/googleLocationTargets.sql
data/languages.sql
data/pointRadiusModifiers.sql
data/yahooJLocationTargets.sql

Creating database site_customization ...
create database IF NOT EXISTS `site_customization` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/fieldType.sql
tables/keywordMap.sql
tables/keyword.sql
tables/pageAdCopyField.sql
tables/pageAdCopy.sql
tables/pageField.sql
tables/pageHistory.sql
tables/page.sql
tables/paragraphField.sql
tables/paragraph.sql
tables/siteField.sql
tables/siteHistory.sql
tables/site.sql
tables/users.sql
data/fieldType.sql

Creating database site_generation ...
create database IF NOT EXISTS `site_generation` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/customerBAreaBLocationPairs.sql
tables/hostingAssignments.sql

Creating database support_dashboard ...
create database IF NOT EXISTS `support_dashboard` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/queueMessageCounts.sql

Creating database users and applying grants.
smb-services/permissions/post/dashboard_user.sql
smb-services/permissions/post/smb_audit.sql
smb-services/permissions/post/smb_services.sql

Success: Database creation completed.

This script will create a new set of database schemas in a target MySQL
instance.  If this is not your intention, hit ctrl-c to exit. Otherwise,
fill in the appropriate connection info below.

Setting up databases:  report_service

Creating database users and applying grants.

Creating database report_service ...
create database IF NOT EXISTS `report_service` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/accountReportMap.sql
tables/accountReportScheduleMap.sql
tables/reportDataAvailability.sql
tables/reportInfo.sql
tables/reportSchedule.sql
tables/userContactMap.sql

Creating database users and applying grants.

Success: Database creation completed.

This script will create a new set of database schemas in a target MySQL
instance.  If this is not your intention, hit ctrl-c to exit. Otherwise,
fill in the appropriate connection info below.

Setting up databases:  bing content_editor_google spike_v2 st-tracker sync_google targeting
Verifying presence of tsacommon database ...

Creating database users and applying grants.
account-shard/permissions/pre/spike.sql
ERROR 1049 (42000): Unknown database 'targeting'
Error running pre permissions script - account-shard/permissions/pre/spike.sql

Creating database bing ...
create database IF NOT EXISTS `bing` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/campaigns.sql
tables/errors.sql

Creating database content_editor_google ...
create database IF NOT EXISTS `content_editor_google` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/gce_adGroupError.sql
tables/gce_adGroupPendingChange.sql
tables/gce_adGroupPendingUpdate.sql
tables/gce_adGroup.sql
tables/gce_adLocation.sql
tables/gce_campaign.sql
tables/gce_currentAdGroup.sql
tables/gce_currentAds.sql
tables/gce_currentCampaigns.sql
tables/gce_currentCriterion.sql
tables/gce_feed.sql
tables/gce_googleAccountError.sql
tables/gce_googleAccountPendingChange.sql
tables/gce_googleAccountPendingUpdate.sql
tables/gce_googleAccount.sql
tables/gce_keywordError.sql
tables/gce_keywordPendingChange.sql
tables/gce_keywordPendingUpdate.sql
tables/gce_keyword.sql
tables/gce_placementError.sql
tables/gce_placementPendingChange.sql
tables/gce_placementPendingUpdate.sql
tables/gce_placement.sql
tables/gce_target.sql
tables/gce_textAdError.sql
tables/gce_textAdPendingChange.sql
tables/gce_textAdPendingUpdate.sql
tables/gce_textAd.sql
views/vAdGroupCreated.sql
views/vAdGroupDeleted.sql
views/vAdGroupUpdated.sql
views/vKeywordCreated.sql
views/vKeywordDeleted.sql
views/vKeywordUpdated.sql
views/vPlacementCreated.sql
views/vPlacementDeleted.sql
views/vPlacementUpdated.sql
views/vTextAdCreated.sql
views/vTextAdDeleted.sql
views/vTextAdUpdated.sql
data/gce_target.sql

Creating database spike_v2 ...
spike_v2.sql
stored_procedures/hash.sql
stored_procedures/logPlaybackStatus.sql
stored_procedures/makeLastPaidHits.sql
stored_procedures/routines.sql
stored_procedures/timeOK.sql
tables/aAlter.sql
tables/playbackLog.sql
tables/userAgent.sql
tables/waypointConversionLog.sql
tables/waypointFilter.sql
tables/waypointLogLastPaidHit.sql
tables/waypointLog.sql
views/vFilePlaybackRates.sql
views/vOutOfOrderErrors.sql
views/vPlaybackRates.sql
data/waypointFilter.sql

Creating database st-tracker ...
create database IF NOT EXISTS `st-tracker` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
stored_procedures/routines.sql
tables/accountChannelMap.sql
tables/admaxAccountAnniversary.sql
tables/admaxActualDailyBudgets.sql
tables/admaxBidErrors.sql
tables/admaxBids.sql
tables/admaxBoosts.sql
tables/admaxBudgetCapMultipliers.sql
tables/admaxBudgetMultipliers.sql
tables/admaxCampaignBudgetAccrualStatus.sql
tables/admaxCampaignMigrations.sql
tables/admaxCampaignRefunds.sql
tables/admaxCampaigns.sql
tables/admaxCarryoverAdjustments.sql
tables/admaxCarryovers.sql
tables/admaxEWMAHistory.sql
tables/admaxEWMA.sql
tables/admaxExcludeDates.sql
tables/admaxMCPCHistory.sql
tables/admaxMCPC.sql
tables/admaxNominalDailyBudgets.sql
tables/admaxNominalMonthlyBudgets.sql
tables/admaxSearchEngineAccountActualDailyBudgets.sql
tables/admaxSearchEngineAccountBalanceFactors.sql
tables/admaxSearchEngineAccountMap.sql
tables/admaxSloshFactors.sql
tables/admaxSloshLimits.sql
tables/admaxWACPHistory.sql
tables/admaxWACP.sql
tables/altKeyMap.sql
tables/bidChangeRequests.sql
tables/bidHistory.sql
tables/bidTargetBonusHistory.sql
tables/bidTargetBonus.sql
tables/bidTargetCPM.sql
tables/bidTargetEstimates.sql
tables/bidTargets.sql
tables/bidTimePeriods.sql
tables/bulkUploadRequests.sql
tables/callFeedData.sql
tables/callFeedProductSourceMap.sql
tables/campaigns.sql
tables/clientConversionSummary.sql
tables/clientProductSummary.sql
tables/contactInfo.sql
tables/dataAvailabilityHistory.sql
tables/dataAvailability.sql
tables/dataFeeds.sql
tables/dataSources.sql
tables/elementModels.sql
tables/elementPortfolioMap.sql
tables/elementTimePeriodMap.sql
tables/linearRegression.sql
tables/MSNErrorCodes.sql
tables/portfolios.sql
tables/products.sql
tables/rulesets.sql
tables/sbbRuleTemplates.sql
tables/sbbRuleTemplateTerms.sql
tables/sbbStrategies.sql
tables/searchEngineConversionTypeProductMap.sql
tables/searchEngineConversionTypes.sql
tables/searchEngineGroups.sql
tables/searchEngineImagesMap.sql
tables/searchEngineImages.sql
tables/searchEngineListingKeywordMap.sql
tables/searchEngineListings.sql
tables/searchEngineReferers.sql
tables/settingDefaults.sql
tables/settings.sql
tables/sourceBidType.sql
tables/sources.sql
tables/waypoints.sql
views/1_vActiveBidTargets.sql
views/2_vActiveBidTargetsDetailed.sql
views/vActiveBidTargetsCPA.sql
views/vActiveBidTargetsDetailedCPA.sql
views/vActiveBidTargetsDetailedROI.sql
views/vActiveBidTargetsROI.sql
views/vActiveTimeBasedBidTargets.sql
views/vElementTimePeriodCount.sql
views/vSearchEngineTargets.sql
data/admaxBudgetCapMultipliers.sql
data/admaxSloshFactors.sql
data/admaxSloshLimits.sql
data/campaigns.sql
data/searchEngineImagesMap.sql
data/searchEngineReferers.sql
data/settingDefaults.sql
triggers/bidTargetBonusTriggers.sql
triggers/bidTargetsTriggers.sql
triggers/productsTriggers.sql
triggers/searchEngineListingTriggers.sql

Creating database sync_google ...
create database IF NOT EXISTS `sync_google` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/googleAdGroups.sql
tables/googleAds.sql
tables/googleKeywords.sql

Creating database targeting ...
create database IF NOT EXISTS `targeting` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/googleProximity.sql
tables/isExclude.sql
tables/levelTargetMap.sql

Creating database users and applying grants.
account-shard/permissions/post/perfreptUser.sql
account-shard/permissions/post/perfsumUser.sql
account-shard/permissions/post/spike.sql

Success: Database creation completed.

This script will create a new set of database schemas in a target MySQL
instance.  If this is not your intention, hit ctrl-c to exit. Otherwise,
fill in the appropriate connection info below.

Setting up databases:  warehouse
Verifying presence of tsacommon database ...

Creating database users and applying grants.

Creating database warehouse ...
Creating database with name:  warehouse_1
tables/accountChannelMap.sql
tables/campaigns.sql
tables/products.sql
tables/searchEngineConversionTypeProductMap.sql
tables/searchEngineGroups.sql
tables/searchEngineListingIDHashMap.sql
tables/searchEngineListings.sql
tables/whDailyGroupAttr.sql
tables/whDailyGroupConv.sql
tables/whDailyGroupPerf.sql
tables/whDailySourceAttr.sql
tables/whDailySourceClicks.sql
tables/whDailySourceConv.sql
tables/whDailySourcePerf.sql
tables/whDescriptions.sql
tables/whDimensionSyncStatus.sql
tables/whHourlyGroupAttr.sql
tables/whHourlyGroupConv.sql
tables/whHourlyGroupPerf.sql
tables/whHourlySourceAttr.sql
tables/whHourlySourceConv.sql
tables/whHourlySourcePerf.sql
tables/whIdentifiers.sql
tables/whKeys.sql
tables/whMonthlyGroupAttr.sql
tables/whMonthlyGroupConv.sql
tables/whMonthlyGroupPerf.sql
tables/whMonthlySourceAttr.sql
tables/whMonthlySourceConv.sql
tables/whMonthlySourcePerf.sql
tables/whWeeklyGroupAttr.sql
tables/whWeeklyGroupConv.sql
tables/whWeeklyGroupPerf.sql
tables/whWeeklySourceAttr.sql
tables/whWeeklySourceConv.sql
tables/whWeeklySourcePerf.sql
constraints/whDailyGroupConvConst.sql
constraints/whDailySourceClicksConst.sql
constraints/whDailySourceConvConst.sql
constraints/whHourlyGroupConvConst.sql
constraints/whHourlySourceConvConst.sql
constraints/whMonthlyGroupConvConst.sql
constraints/whMonthlySourceConvConst.sql
constraints/whWeeklyGroupConvConst.sql
constraints/whWeeklySourceConvConst.sql

Creating database users and applying grants.
warehouse-shard/permissions/post/perfreptUser.sql
warehouse-shard/permissions/post/perfsumUser.sql
warehouse-shard/permissions/post/spike.sql

Success: Database creation completed.
apollo@ubuntu:/tmp/db-structure$