2024-01-15 11:31:03 +00:00
|
|
|
code: vn-database
|
|
|
|
|
versionSchema: util
|
|
|
|
|
replace: true
|
|
|
|
|
sumViews: false
|
2024-09-06 06:25:21 +00:00
|
|
|
defaultDefiner: vn@localhost
|
2024-01-15 11:31:03 +00:00
|
|
|
mockDate: '2001-01-01 12:00:00'
|
2024-01-25 23:09:24 +00:00
|
|
|
subdir: db
|
2024-01-15 11:31:03 +00:00
|
|
|
schemas:
|
|
|
|
|
- account
|
|
|
|
|
- bi
|
|
|
|
|
- bs
|
|
|
|
|
- cache
|
|
|
|
|
- dipole
|
|
|
|
|
- edi
|
2024-04-08 11:07:04 +00:00
|
|
|
- floranet
|
2024-01-15 11:31:03 +00:00
|
|
|
- hedera
|
|
|
|
|
- pbx
|
|
|
|
|
- psico
|
|
|
|
|
- sage
|
|
|
|
|
- salix
|
|
|
|
|
- srt
|
|
|
|
|
- stock
|
|
|
|
|
- tmp
|
|
|
|
|
- util
|
|
|
|
|
- vn
|
|
|
|
|
- vn2008
|
|
|
|
|
privileges:
|
|
|
|
|
where: >-
|
|
|
|
|
`Host` = ''
|
|
|
|
|
AND `User` NOT LIKE '$%'
|
|
|
|
|
AND `User` <> 'any'
|
|
|
|
|
fixtures:
|
|
|
|
|
util:
|
|
|
|
|
- version
|
|
|
|
|
- versionLog
|
|
|
|
|
account:
|
|
|
|
|
- role
|
|
|
|
|
- roleInherit
|
|
|
|
|
- userPassword
|
|
|
|
|
- accountConfig
|
|
|
|
|
- mailConfig
|
|
|
|
|
salix:
|
|
|
|
|
- ACL
|
|
|
|
|
- fieldAcl
|
|
|
|
|
- module
|
2024-07-10 05:46:18 +00:00
|
|
|
- defaultViewMultiConfig
|
2024-01-15 11:31:03 +00:00
|
|
|
vn:
|
|
|
|
|
- alertLevel
|
|
|
|
|
- bookingPlanner
|
|
|
|
|
- businessType
|
|
|
|
|
- companyI18n
|
|
|
|
|
- cplusRectificationType
|
|
|
|
|
- cplusSubjectOp
|
|
|
|
|
- cplusTaxBreak
|
|
|
|
|
- claimResponsible
|
|
|
|
|
- claimReason
|
|
|
|
|
- claimRedelivery
|
|
|
|
|
- claimResult
|
|
|
|
|
- component
|
|
|
|
|
- componentType
|
|
|
|
|
- continent
|
|
|
|
|
- department
|
|
|
|
|
- docuware
|
|
|
|
|
- itemPackingType
|
|
|
|
|
- pgc
|
|
|
|
|
- sample
|
|
|
|
|
- siiTrascendencyInvoiceIn
|
|
|
|
|
- siiTypeInvoiceIn
|
|
|
|
|
- siiTypeInvoiceOut
|
|
|
|
|
- state
|
|
|
|
|
- ticketUpdateAction
|
2024-10-03 07:49:16 +00:00
|
|
|
- ticketCanAdvanceConfig
|
2024-01-15 11:31:03 +00:00
|
|
|
- volumeConfig
|
|
|
|
|
- workCenter
|
2024-01-25 16:33:54 +00:00
|
|
|
- workerTimeControlError
|
2024-01-15 11:31:03 +00:00
|
|
|
cache:
|
|
|
|
|
- cache
|
|
|
|
|
hedera:
|
|
|
|
|
- browser
|
|
|
|
|
- imageCollection
|
|
|
|
|
- imageCollectionSize
|
|
|
|
|
- language
|
|
|
|
|
- link
|
|
|
|
|
- location
|
|
|
|
|
- menu
|
|
|
|
|
- message
|
|
|
|
|
- metatag
|
|
|
|
|
- newsTag
|
|
|
|
|
- restPriv
|
|
|
|
|
- social
|
|
|
|
|
- tpvError
|
|
|
|
|
- tpvResponse
|
|
|
|
|
sage:
|
|
|
|
|
- TiposIva
|
|
|
|
|
- TiposTransacciones
|
|
|
|
|
- TiposRetencion
|
|
|
|
|
- taxType
|
|
|
|
|
localFixtures:
|
|
|
|
|
account:
|
|
|
|
|
- account
|
|
|
|
|
- mailAlias
|
|
|
|
|
- mailAliasAccount
|
|
|
|
|
- mailForward
|
|
|
|
|
- roleConfig
|
|
|
|
|
- user
|
|
|
|
|
- userConfig
|
|
|
|
|
bs:
|
|
|
|
|
- clientAnnualConsumption
|
|
|
|
|
- clientNewBorn
|
|
|
|
|
- defaulter
|
|
|
|
|
- sale
|
|
|
|
|
- waste
|
|
|
|
|
cache:
|
|
|
|
|
- cache_calc
|
|
|
|
|
hedera:
|
|
|
|
|
- config
|
|
|
|
|
- image
|
|
|
|
|
- imageConfig
|
|
|
|
|
- news
|
|
|
|
|
- order
|
|
|
|
|
- orderConfig
|
|
|
|
|
- orderRow
|
|
|
|
|
- orderRowComponent
|
|
|
|
|
- tpvConfig
|
|
|
|
|
- tpvMerchant
|
|
|
|
|
- tpvMerchantEnable
|
|
|
|
|
- tpvTransaction
|
|
|
|
|
- userSession
|
|
|
|
|
- visit
|
|
|
|
|
- visitAccess
|
|
|
|
|
- visitAgent
|
|
|
|
|
- visitUser
|
|
|
|
|
pbx:
|
|
|
|
|
- sip
|
|
|
|
|
salix:
|
|
|
|
|
- AccessToken
|
|
|
|
|
- accessTokenConfig
|
|
|
|
|
- printConfig
|
|
|
|
|
- url
|
|
|
|
|
util:
|
|
|
|
|
- config
|
|
|
|
|
- notification
|
|
|
|
|
- notificationAcl
|
|
|
|
|
- notificationConfig
|
|
|
|
|
- notificationQueue
|
|
|
|
|
- notificationSubscription
|
|
|
|
|
vn:
|
|
|
|
|
- absenceType
|
|
|
|
|
- accounting
|
|
|
|
|
- accountingConfig
|
|
|
|
|
- accountingType
|
|
|
|
|
- address
|
|
|
|
|
- addressObservation
|
|
|
|
|
- agency
|
|
|
|
|
- agencyMode
|
|
|
|
|
- autonomy
|
|
|
|
|
- awb
|
|
|
|
|
- bankEntity
|
|
|
|
|
- beach
|
|
|
|
|
- bionicConfig
|
|
|
|
|
- business
|
|
|
|
|
- businessReasonEnd
|
|
|
|
|
- buy
|
|
|
|
|
- buyConfig
|
|
|
|
|
- calendar
|
|
|
|
|
- calendarHolidays
|
|
|
|
|
- calendarHolidaysName
|
|
|
|
|
- calendarHolidaysType
|
|
|
|
|
- calendarType
|
|
|
|
|
- campaign
|
|
|
|
|
- chat
|
|
|
|
|
- chatConfig
|
|
|
|
|
- claim
|
|
|
|
|
- claimBeginning
|
|
|
|
|
- claimConfig
|
|
|
|
|
- claimDestination
|
|
|
|
|
- claimDevelopment
|
|
|
|
|
- claimDms
|
|
|
|
|
- claimEnd
|
|
|
|
|
- claimLog
|
|
|
|
|
- claimObservation
|
|
|
|
|
- claimRatio
|
|
|
|
|
- claimState
|
|
|
|
|
- client
|
|
|
|
|
- clientConfig
|
|
|
|
|
- clientContact
|
|
|
|
|
- clientCredit
|
|
|
|
|
- roleCreditLimit
|
|
|
|
|
- clientDms
|
|
|
|
|
- clientManaCache
|
|
|
|
|
- clientObservation
|
|
|
|
|
- clientRisk
|
|
|
|
|
- clientSample
|
|
|
|
|
- clientType
|
|
|
|
|
- cmr
|
|
|
|
|
- cmrConfig
|
|
|
|
|
- collection
|
|
|
|
|
- collectionColors
|
|
|
|
|
- company
|
|
|
|
|
- companyGroup
|
|
|
|
|
- config
|
|
|
|
|
- contactChannel
|
|
|
|
|
- country
|
|
|
|
|
- cplusTerIdNif
|
|
|
|
|
- creditClassification
|
|
|
|
|
- creditInsurance
|
|
|
|
|
- currency
|
|
|
|
|
- customsAgent
|
|
|
|
|
- deliveryMethod
|
|
|
|
|
- deliveryPoint
|
|
|
|
|
- device
|
|
|
|
|
- deviceProduction
|
|
|
|
|
- deviceProductionModels
|
|
|
|
|
- deviceProductionState
|
|
|
|
|
- deviceProductionUser
|
|
|
|
|
- disabilityGrade
|
|
|
|
|
- dms
|
|
|
|
|
- dmsType
|
|
|
|
|
- docuwareConfig
|
|
|
|
|
- dua
|
|
|
|
|
- duaInvoiceIn
|
|
|
|
|
- educationLevel
|
|
|
|
|
- entry
|
|
|
|
|
- entryConfig
|
|
|
|
|
- expedition
|
|
|
|
|
- expeditionBoxVol
|
|
|
|
|
- expeditionPallet
|
|
|
|
|
- expeditionScan
|
|
|
|
|
- expeditionState
|
|
|
|
|
- expeditionStateType
|
2024-05-16 08:20:08 +00:00
|
|
|
- roadmapStop
|
2024-01-15 11:31:03 +00:00
|
|
|
- expense
|
|
|
|
|
- genus
|
|
|
|
|
- greuge
|
|
|
|
|
- greugeConfig
|
|
|
|
|
- greugeType
|
|
|
|
|
- host
|
|
|
|
|
- incoterms
|
|
|
|
|
- ink
|
|
|
|
|
- intrastat
|
|
|
|
|
- invoiceIn
|
|
|
|
|
- invoiceInConfig
|
|
|
|
|
- invoiceInDueDay
|
|
|
|
|
- invoiceInIntrastat
|
|
|
|
|
- invoiceInSerial
|
|
|
|
|
- invoiceInTax
|
|
|
|
|
- invoiceOut
|
|
|
|
|
- invoiceOutConfig
|
|
|
|
|
- invoiceOutExpense
|
|
|
|
|
- invoiceOutSerial
|
|
|
|
|
- invoiceOutTax
|
|
|
|
|
- item
|
|
|
|
|
- itemBarcode
|
|
|
|
|
- itemBotanical
|
|
|
|
|
- itemCategory
|
|
|
|
|
- itemConfig
|
|
|
|
|
- itemCost
|
|
|
|
|
- itemFamily
|
|
|
|
|
- itemLog
|
|
|
|
|
- itemShelving
|
|
|
|
|
- itemShelvingLog
|
|
|
|
|
- itemShelvingSale
|
|
|
|
|
- itemTag
|
|
|
|
|
- itemTaxCountry
|
|
|
|
|
- itemType
|
|
|
|
|
- itemTypeTag
|
|
|
|
|
- machine
|
|
|
|
|
- machineWorker
|
|
|
|
|
- mail
|
|
|
|
|
- mandate
|
|
|
|
|
- mandateType
|
|
|
|
|
- mdbApp
|
|
|
|
|
- mdbBranch
|
|
|
|
|
- mdbVersion
|
|
|
|
|
- medicalCenter
|
|
|
|
|
- mobileAppVersionControl
|
|
|
|
|
- observationType
|
|
|
|
|
- occupationCode
|
|
|
|
|
- operator
|
|
|
|
|
- orderTicket
|
|
|
|
|
- origin
|
|
|
|
|
- osTicketConfig
|
|
|
|
|
- packaging
|
|
|
|
|
- packagingConfig
|
|
|
|
|
- packingSite
|
|
|
|
|
- packingSiteConfig
|
|
|
|
|
- parking
|
|
|
|
|
- payDem
|
|
|
|
|
- payDemDetail
|
|
|
|
|
- payMethod
|
|
|
|
|
- payrollCategories
|
2024-04-24 07:53:31 +00:00
|
|
|
- payrollWorker
|
2024-01-15 11:31:03 +00:00
|
|
|
- postCode
|
|
|
|
|
- priceFixed
|
|
|
|
|
- printer
|
|
|
|
|
- producer
|
|
|
|
|
- productionConfig
|
|
|
|
|
- professionalCategory
|
|
|
|
|
- profileType
|
|
|
|
|
- province
|
|
|
|
|
- queuePriority
|
|
|
|
|
- rate
|
|
|
|
|
- rateConfig
|
|
|
|
|
- receipt
|
|
|
|
|
- recovery
|
|
|
|
|
- report
|
|
|
|
|
- roadmap
|
|
|
|
|
- route
|
|
|
|
|
- routeConfig
|
|
|
|
|
- routeRecalc
|
|
|
|
|
- routesMonitor
|
|
|
|
|
- sale
|
|
|
|
|
- saleCloned
|
|
|
|
|
- saleComponent
|
|
|
|
|
- saleGroup
|
|
|
|
|
- saleGroupDetail
|
|
|
|
|
- saleTracking
|
|
|
|
|
- sector
|
|
|
|
|
- sectorCollection
|
|
|
|
|
- sectorCollectionSaleGroup
|
|
|
|
|
- sharingCart
|
|
|
|
|
- sharingCartDaily
|
|
|
|
|
- sharingClient
|
|
|
|
|
- shelving
|
|
|
|
|
- smsConfig
|
|
|
|
|
- specie
|
2024-04-24 07:53:31 +00:00
|
|
|
- split
|
2024-01-15 11:31:03 +00:00
|
|
|
- supplier
|
|
|
|
|
- supplierAccount
|
|
|
|
|
- supplierActivity
|
|
|
|
|
- supplierAddress
|
|
|
|
|
- supplierAgencyTerm
|
|
|
|
|
- supplierContact
|
|
|
|
|
- tablet
|
|
|
|
|
- tabletDepartment
|
|
|
|
|
- tag
|
|
|
|
|
- taxArea
|
|
|
|
|
- taxClass
|
|
|
|
|
- taxClassCode
|
|
|
|
|
- taxCode
|
|
|
|
|
- taxType
|
|
|
|
|
- temperature
|
|
|
|
|
- thermograph
|
|
|
|
|
- ticket
|
|
|
|
|
- ticketCollection
|
|
|
|
|
- ticketConfig
|
|
|
|
|
- ticketDms
|
|
|
|
|
- ticketLastState
|
|
|
|
|
- ticketLog
|
|
|
|
|
- ticketObservation
|
|
|
|
|
- ticketPackaging
|
|
|
|
|
- ticketRecalc
|
|
|
|
|
- ticketRefund
|
|
|
|
|
- ticketRequest
|
|
|
|
|
- ticketService
|
|
|
|
|
- ticketServiceType
|
|
|
|
|
- ticketTracking
|
|
|
|
|
- ticketWeekly
|
|
|
|
|
- town
|
|
|
|
|
- train
|
|
|
|
|
- trainingCenter
|
|
|
|
|
- trainingCourseType
|
|
|
|
|
- travel
|
|
|
|
|
- travelConfig
|
|
|
|
|
- travelRecalc
|
|
|
|
|
- travelThermograph
|
2024-07-10 05:46:18 +00:00
|
|
|
- userMultiConfig
|
2024-01-15 11:31:03 +00:00
|
|
|
- vehicle
|
|
|
|
|
- wagonConfig
|
|
|
|
|
- wagonType
|
|
|
|
|
- wagonTypeColor
|
|
|
|
|
- wagonTypeTray
|
|
|
|
|
- warehouse
|
|
|
|
|
- warehouseAlias
|
|
|
|
|
- workCenterHoliday
|
|
|
|
|
- worker
|
|
|
|
|
- workerBosses
|
|
|
|
|
- workerBusinessType
|
|
|
|
|
- workerConfig
|
2024-09-11 12:38:58 +00:00
|
|
|
- workerDms
|
2024-01-15 11:31:03 +00:00
|
|
|
- workerLog
|
|
|
|
|
- workerMana
|
|
|
|
|
- workerManaExcluded
|
|
|
|
|
- workerTeam
|
|
|
|
|
- workerTimeControl
|
|
|
|
|
- workerTimeControlConfig
|
|
|
|
|
- workerTimeControlMail
|
|
|
|
|
- zone
|
|
|
|
|
- zoneAgencyMode
|
|
|
|
|
- zoneClosure
|
|
|
|
|
- zoneConfig
|
|
|
|
|
- zoneEvent
|
|
|
|
|
- zoneExclusion
|
|
|
|
|
- zoneExclusionGeo
|
|
|
|
|
- zoneGeo
|
|
|
|
|
- zoneIncluded
|
2024-09-09 07:58:20 +00:00
|
|
|
- zoneWarehouse
|
