MERGE (courier:DeliveryType {name: "Courier"})
MERGE (pickup:DeliveryType {name: "Pickup"})

MERGE (hkAvia:DeliveryService {name: "HK Avia"})
MERGE (hkBarge:DeliveryService {name: "HK Barge"})
MERGE (ups:DeliveryService {name: "UPS"})
MERGE (internalDelivery:DeliveryService {name: "Our Internal Delivery Service"})
MERGE (ups)-[:BELONGS_TO]->(courier)

MERGE (markersCategory:GoodCategory {title: "Markers", url: "/markers/"})
MERGE (elerktronikaCategory:GoodCategory {title: "Elektronika", url: "/markers/elektronika/"})
MERGE (otherCategory:GoodCategory {title: "Other", url: "/others/"})
MERGE (elerktronikaCategory)-[:INCLUDED_IN]->(markersCategory)

MERGE (russia:Location {name: "Russian Federation"})
MERGE (hk:Location {name: "Hong Kong"})
MERGE (lithuania:Location {name: "Lithuania"})

MERGE (moscow:Location {name: "Moscow"})
MERGE (moscow)-[:INSIDE]->(russia)

MERGE (moscowPark:Location {name: "Moscow Park"})
MERGE (moscowPark)-[:INSIDE]->(moscow)

MERGE (systemLithuaniaWarehouse:Location {name: "System's Lithuania Warehouse"})
MERGE (systemLithuaniaWarehouse)-[:INSIDE]->(lithuania)

MERGE (systemMoscowWarehouse:Location {name: "System's Moscow Warehouse"})
MERGE (systemMoscowWarehouse)-[:INSIDE]->(moscow)
MERGE (systemMoscowWarehouse)-[:BELONGS_TO]->(pickup)

MERGE (sellerWarehouse:Location {name: "Seller's Warehouse"})
MERGE (sellerWarehouse)-[:INSIDE]->(hk)

MERGE (buyerHome:Location {name: "Buyer's Home"})
MERGE (buyerHome)-[:INSIDE]->(moscow)

MERGE (leg1:LogisticLeg {name: "HK-LITHUANIA WAREHOUSE", priceFormula: "i.amount * 10%"})
MERGE (hk)-[:GO]->(leg1)
MERGE (leg1)-[:GO]->(systemLithuaniaWarehouse)
MERGE (leg1)-[:SERVES]->(markersCategory)
MERGE (leg1)-[:SERVES]->(otherCategory)
MERGE (leg1)-[:VIA]->(hkBarge)

MERGE (leg2:LogisticLeg {name: "LITHUANIA WAREHOUSE-MOSCOW WAREHOUSE", priceFormula: "i.amount * 15%"})
MERGE (systemLithuaniaWarehouse)-[:GO]->(leg2)
MERGE (leg2)-[:GO]->(systemMoscowWarehouse)
MERGE (leg2)-[:SERVES]->(markersCategory)
MERGE (leg2)-[:SERVES]->(otherCategory)
MERGE (leg2)-[:VIA]->(internalDelivery)

MERGE (leg3:LogisticLeg {name: "MOSCOW WAREHOUSE-MOSCOW", priceFormula: "500"})
MERGE (systemMoscowWarehouse)-[:GO]->(leg3)
MERGE (leg3)-[:GO]->(moscow)
MERGE (leg3)-[:SERVES]->(markersCategory)
MERGE (leg3)-[:SERVES]->(otherCategory)
MERGE (leg3)-[:VIA]->(ups)

MERGE (leg4:LogisticLeg {name: "HK-MOSCOW WAREHOUSE", priceFormula: "i.weight * 100"})
MERGE (hk)-[:GO]->(leg4)
MERGE (leg4)-[:GO]->(systemMoscowWarehouse)
MERGE (leg4)-[:SERVES]->(otherCategory)
MERGE (leg4)-[:VIA]->(hkAvia)

MERGE (admin:User {email: "admin@p8nt.ru", passwordHash: "$2a$10$.QmNWQTupmFA8BIKFBKoWuVC80lFxqy5AlHYQpTuzgAFMH6IvcU1G", role: "ADMIN"})
MERGE (buyer:User {email: "buyer@p8nt.ru", passwordHash: "$2a$10$.QmNWQTupmFA8BIKFBKoWuVC80lFxqy5AlHYQpTuzgAFMH6IvcU1G", role: "USER"})
MERGE (seller:User {email: "seller@p8nt.ru", passwordHash: "$2a$10$.QmNWQTupmFA8BIKFBKoWuVC80lFxqy5AlHYQpTuzgAFMH6IvcU1G", role: "USER"})
MERGE (photographer:User {email: "photographer@p8nt.ru", passwordHash: "$2a$10$.QmNWQTupmFA8BIKFBKoWuVC80lFxqy5AlHYQpTuzgAFMH6IvcU1G", role: "USER"})

MERGE (adminBonus:BonusAccount {name: "adminBonus"})
MERGE (admin)-[:OWNS {main: true}]->(adminBonus)

MERGE (buyerBonus:BonusAccount {name: "buyerBonus"})
MERGE (buyer)-[:OWNS {main: true}]->(buyerBonus)

MERGE (sellerBonus:BonusAccount {name: "sellerBonus"})
MERGE (seller)-[:OWNS {main: true}]->(sellerBonus)

MERGE (photographerBonus:BonusAccount {name: "photographerBonus"})
MERGE (photographer)-[:OWNS {main: true}]->(photographerBonus)

MERGE (retail:UserSegment {name: "Retail"})
MERGE (admin)-[:BELONGS_TO]->(retail)
MERGE (seller)-[:BELONGS_TO]->(retail)
MERGE (photographer)-[:BELONGS_TO]->(retail)

MERGE (wholesale:UserSegment {name: "Wholesale"})
MERGE (buyer)-[:BELONGS_TO]->(wholesale)

MERGE (system:System {name: "SYSTEM"})
MERGE (admin)-[:ADMIN]->(system)

MERGE (systemBonus:BonusAccount {name: "systemBonus"})
MERGE (system)-[:OWNS {main: true}]->(systemBonus)

MERGE (systemTransfer:BonusAccount {name: "systemTransfer"})
MERGE (system)-[:OWNS]->(systemTransfer)

MERGE (systemContragent:Contragent {name: "systemContragent"})
MERGE (system)-[:OWNS {main: true}]->(systemContragent)

MERGE (systemBank:BankAccount {name: "systemBank", bank: "SBERBANK", number: "189239081293801283"})
MERGE (systemContragent)-[:OWNS]->(systemBank)

MERGE (buyerContragent:Contragent {name: "buyerContragent"})
MERGE (buyer)-[:OWNS]->(buyerContragent)

MERGE (buyerBank:BankAccount {name: "buyerBank", bank: "ALFA-BANK", number: "192030918723817237"})
MERGE (buyerContragent)-[:OWNS]->(buyerBank)

MERGE (sellerContragent:Contragent {name: "sellerContragent"})
MERGE (seller)-[:OWNS]->(sellerContragent)

MERGE (sellerBank:BankAccount {name: "sellerBank", bank: "ALFA-BANK", number: "1231231231235235234"})
MERGE (sellerContragent)-[:OWNS]->(sellerBank)

MERGE (photographerContragent:Contragent {name: "photographerContragent"})
MERGE (photographer)-[:OWNS]->(photographerContragent)

MERGE (photographerBank:BankAccount {name: "photographerBank", bank: "ALFA-BANK", number: "12893719207398712"})
MERGE (photographerContragent)-[:OWNS]->(photographerBank)

MERGE (team:Team {name: "team"})
MERGE (buyer)-[:LEADER]->(team)
MERGE (admin)-[:MEMBER]->(team)

MERGE (imageFile330x220:File {url: "http://lorempixel.com/330/220/"})
MERGE (imageFile800x600:File {url: "http://lorempixel.com/800/600/"})
MERGE (imageFile100x100:File {url: "http://lorempixel.com/100/100/"})

MERGE (image:Image {description: "Lorem Image"})
MERGE (photographer)-[:AUTHOR]->(image)
MERGE (image)-[:SIZE {width: 100, height: 100}]->(imageFile100x100)
MERGE (image)-[:SIZE {width: 330, height: 220}]->(imageFile330x220)
MERGE (image)-[:SIZE {width: 800, height: 600}]->(imageFile800x600)

MERGE (tag1:Tag {name: "Marker"})
MERGE (tag2:Tag {name: "FOO"})
MERGE (tag3:Tag {name: "BAR"})
MERGE (tag4:Tag {name: "BAZ"})

MERGE (marker:Good {title: "Marker", weight: 2000})
MERGE (marker)-[:BELONGS_TO]->(elerktronikaCategory)
MERGE (marker)-[:SHOWN_ON]->(image)
MERGE (marker)-[:TAGGED_WITH]->(tag1)
MERGE (marker)-[:TAGGED_WITH]->(tag2)
MERGE (marker)-[:TAGGED_WITH]->(tag3)
MERGE (marker)-[:TAGGED_WITH]->(tag4)

MERGE (offer:Offer {name: "Offer1"})
MERGE (seller)-[:AUTHOR]->(offer)

MERGE (is1:ItemStatus {name: "is1", amount: 100, price: 100, currency: "USD", status: "Available", quality: "Best"})
MERGE (offer)-[:REASON]->(is1)
MERGE (is1)-[:LOCATED]->(sellerWarehouse)
MERGE (is1)-[:OF]->(marker)

MERGE (buyerCart:Cart {name: "buyerCart"})
MERGE (buyer)-[:OWNS]->(buyerCart)

MERGE (cartPosition1:CartPosition {name: "cartPosition1", amount: 10})
MERGE (image)-[:LEAD]->(cartPosition1)
MERGE (buyerCart)-[:INCLUDES]->(cartPosition1)
MERGE (cartPosition1)-[:OF]->(is1)

MERGE (order:Order {name: "Order1"})
MERGE (order)-[:TO]->(buyerHome)
MERGE (buyer)-[:AUTHOR]->(order)
MERGE (order)-[:OF]->(buyerCart)

MERGE (rubBonusRateOld:CurrencyRate {name: "RUB/BONUS", value: 56.6685, createdAt: 1436706000})
MERGE (rubBonusRate:CurrencyRate {name: "RUB/BONUS", value: 56.6079, createdAt: 1436792989})
MERGE (usdBonusRate:CurrencyRate {name: "USD/BONUS", value: 1, createdAt: 1436706000})
MERGE (rubBonusRate)-[:OVERRIDES]->(rubBonusRateOld)

MERGE (ls1:LogisticSchema {name: "LogisticSchema1"})
MERGE (ls1)-[:INCLUDES {position: 0, price: 1000, currency: "BONUS"}]->(leg1)
MERGE (ls1)-[:INCLUDES {position: 1, price: 1500, currency: "BONUS"}]->(leg2)
MERGE (ls1)-[:INCLUDES {position: 2, price: 500, currency: "BONUS"}]->(leg3)

MERGE (is2:ItemStatus {name: "is2", amount: 50, price: 200, currency: "BONUS", status: "Reserved", quality: "Best"})
MERGE (is3:ItemStatus {name: "is3", amount: 50, price: 100, currency: "USD", status: "Available", quality: "Best"})
MERGE (is2)-[:USING]->(ls1)
MERGE (is2)-[:CONVERTED_BY]->(usdBonusRate)
MERGE (buyerHome)-[:DESTINATION]->(is2)
MERGE (is2)-[:OVERRIDES]->(is1)
MERGE (is3)-[:OVERRIDES]->(is1)
MERGE (order)-[:REASON]->(is2)
MERGE (is2)-[:REASON]->(is3)

MERGE (cashInRequest:CashInRequest {name: "CashInRequest1"})
MERGE (order)-[:REASON]->(cashInRequest)

MERGE (payment1:Payment {name: "Payment1", baseAmount: 13000, baseCurrency: "BONUS", amount: 6500, currency: "USD"})
MERGE (payment1)-[:CONVERTED_BY]->(usdBonusRate)
MERGE (cashInRequest)-[:REASON]->(payment1)
MERGE (payment1)-[:FROM]->(buyerBank)
MERGE (payment1)-[:TO]->(systemBank)

MERGE (emit1:BonusEmit {name: "BonusEmit1", amount: 13000})
MERGE (payment1)-[:REASON]->(emit1)
MERGE (emit1)-[:TO]->(systemTransfer)

MERGE (bt1:BonusTransfer {name: "Покупка бонусов", amount: 13000})
MERGE (emit1)-[:REASON]->(bt1)
MERGE (bt1)-[:FROM]->(systemTransfer)
MERGE (bt1)-[:TO]->(buyerBonus)

MERGE (balancing1:AccountBalancing {name: "balancing1"})
MERGE (bt1)-[:REASON]->(balancing1)

MERGE (bt2:BonusTransfer {name: "Оплата заказа", appliedFormula: "order.amount * 80%", amount: 8000})
MERGE (balancing1)-[:REASON]->(bt2)
MERGE (bt2)-[:FROM]->(buyerBonus)
MERGE (bt2)-[:TO]->(sellerBonus)

MERGE (bt3:BonusTransfer {name: "Оплата доставки заказа", appliedFormula: "logisticSchema.amount", amount: 3000})
MERGE (balancing1)-[:REASON]->(bt3)
MERGE (bt3)-[:FROM]->(buyerBonus)
MERGE (bt3)-[:TO]->(systemBonus)

MERGE (bt4:BonusTransfer {name: "Комиссия за сервис", appliedFormula: "order.amount * 10%", amount: 1000})
MERGE (balancing1)-[:REASON]->(bt4)
MERGE (bt4)-[:FROM]->(buyerBonus)
MERGE (bt4)-[:TO]->(systemBonus)

MERGE (bt5:BonusTransfer {name: "Вознаграждение фотографам", appliedFormula: "order.amount * 5% / count(photographers)", amount: 500})
MERGE (balancing1)-[:REASON]->(bt5)
MERGE (bt5)-[:FROM]->(buyerBonus)
MERGE (bt5)-[:TO]->(photographerBonus)

MERGE (bt6:BonusTransfer {name: "Cash Back", appliedFormula: "order.amount * 5%", amount: 500})
MERGE (balancing1)-[:REASON]->(bt6)
MERGE (bt6)-[:FROM]->(buyerBonus)
MERGE (bt6)-[:TO]->(buyerBonus)

MERGE (is4:ItemStatus {name: "is4", amount: 50, price: 200, currency: "BONUS", status: "ToBePacked", quality: "Best"})
MERGE (is4)-[:OVERRIDES]->(is2)
MERGE (balancing1)-[:REASON]->(is4)

MERGE (cargo1:Cargo {name: "Cargo1"})
MERGE (balancing1)-[:REASON]->(cargo1)
MERGE (cargo1)-[:FROM]->(sellerWarehouse)
MERGE (cargo1)-[:TO]->(systemLithuaniaWarehouse)
MERGE (cargo1)-[:VIA]->(hkBarge)

MERGE (is5:ItemStatus {name: "is5", amount: 50, price: 200, currency: "BONUS", status: "Dispatched", quality: "Best"})
MERGE (is5)-[:OVERRIDES]->(is4)
MERGE (cargo1)-[:REASON]->(is5)

MERGE (deliveryReport1:DeliveryReport {name: "DeliveryReport1"})
MERGE (cargo1)-[:REASON]->(deliveryReport1)

MERGE (is6:ItemStatus {name: "is6", amount: 50, price: 200, currency: "BONUS", status: "ToBePacked", quality: "Best"})
MERGE (is6)-[:LOCATED]->(systemLithuaniaWarehouse)
MERGE (is6)-[:OVERRIDES]->(is5)
MERGE (deliveryReport1)-[:REASON]->(is6)

MERGE (cargo2:Cargo {name: "Cargo2"})
MERGE (deliveryReport1)-[:REASON]->(cargo2)
MERGE (cargo2)-[:FROM]->(systemLithuaniaWarehouse)
MERGE (cargo2)-[:TO]->(systemMoscowWarehouse)
MERGE (cargo2)-[:VIA]->(internalDelivery)

MERGE (is7:ItemStatus {name: "is7", amount: 50, price: 200, currency: "BONUS", status: "Dispatched", quality: "Best"})
MERGE (is7)-[:OVERRIDES]->(is6)
MERGE (cargo2)-[:REASON]->(is7)

MERGE (deliveryReport2:DeliveryReport {name: "DeliveryReport2"})
MERGE (cargo2)-[:REASON]->(deliveryReport2)

MERGE (is8:ItemStatus {name: "is8", amount: 50, price: 200, currency: "BONUS", status: "ToBePacked", quality: "Best"})
MERGE (is8)-[:LOCATED]->(systemMoscowWarehouse)
MERGE (is8)-[:OVERRIDES]->(is7)
MERGE (deliveryReport2)-[:REASON]->(is8)

MERGE (cargo3:Cargo {name: "Cargo3"})
MERGE (deliveryReport2)-[:REASON]->(cargo3)
MERGE (cargo3)-[:FROM]->(systemMoscowWarehouse)
MERGE (cargo3)-[:TO]->(buyerHome)
MERGE (cargo3)-[:VIA]->(ups)

MERGE (is9:ItemStatus {name: "is9", amount: 50, price: 200, currency: "BONUS", status: "Dispatched", quality: "Best"})
MERGE (is9)-[:OVERRIDES]->(is8)
MERGE (cargo3)-[:REASON]->(is9)

MERGE (deliveryReport3:DeliveryReport {name: "DeliveryReport3"})
MERGE (cargo3)-[:REASON]->(deliveryReport3)

MERGE (is10:ItemStatus {name: "is10", amount: 50, price: 200, currency: "BONUS", status: "Delivered", quality: "Best"})
MERGE (is10)-[:LOCATED]->(buyerHome)
MERGE (is10)-[:OVERRIDES]->(is9)
MERGE (deliveryReport3)-[:REASON]->(is10)

MERGE (offerEdit:DeliveryReport {name: "OfferEdit1"})
MERGE (offer)-[:REASON]->(offerEdit)

MERGE (is11:ItemStatus {name: "is11", amount: 40, price: 110, currency: "USD", status: "Available", quality: "Best"})
MERGE (is11)-[:OVERRIDES]->(is3)
MERGE (offerEdit)-[:REASON]->(is11)

MERGE (cashOutRequest:CashOutRequest {name: "CashOutRequest1"})

MERGE (bt7:BonusTransfer {name: "Вывод бонусов", amount: 500})
MERGE (cashOutRequest)-[:REASON]->(bt7)
MERGE (bt7)-[:FROM]->(photographerBonus)
MERGE (bt7)-[:TO]->(systemTransfer)

MERGE (payment2:Payment {name: "Payment2", baseAmount: 500, baseCurrency: "BONUS", amount: 250, currency: "USD"})
MERGE (payment2)-[:CONVERTED_BY]->(usdBonusRate)
MERGE (bt7)-[:REASON]->(payment2)
MERGE (payment2)-[:FROM]->(systemBank)
MERGE (payment2)-[:TO]->(photographerBank)

MERGE (emit2:BonusEmit {name: "BonusEmit2", amount: -500})
MERGE (payment2)-[:REASON]->(emit2)
MERGE (emit2)-[:TO]->(systemTransfer)

MERGE (esd1:EventSeriesDevision {name: "EventSeriesDevision1"})
MERGE (team)-[:INCLUDED_IN]->(esd1)

MERGE (devision1:Devision {name: "devision1"})
MERGE (devision1)-[:UNKNOWN]->(esd1)

MERGE (es1:EventSeries {name: "EventSeries1"})
MERGE (esd1)-[:PARTICIPANT]->(es1)

MERGE (et1:EventTournament {name: "EventTournament1"})
MERGE (es1)-[:INCLUDES]->(et1)

MERGE (et2:EventTournament {name: "EventTournament2"})
MERGE (es1)-[:INCLUDES]->(et2)

MERGE (mission:Mission {name: "Battle for New-York"})
MERGE (admin)-[:AUTHOR]->(mission)

MERGE (usa:MissionUnit {name: "USA"})
MERGE (usa)-[:FRACTION]->(mission)

MERGE (ussr:MissionUnit {name: "USSR"})
MERGE (ussr)-[:FRACTION]->(mission)

MERGE (em1:EventMission {name: "Game: Battle for New-York"})
MERGE (mission)-[:SCENARIO]->(em1)
MERGE (moscowPark)-[:SPOT]->(em1)

MERGE (emu1:EventMissionUnit {name: "USA in Battle for New-York"})
MERGE (usa)-[:PROTOTYPE]->(emu1)
MERGE (emu1)-[:PARTICIPANT]->(em1)

MERGE (emu2:EventMissionUnit {name: "USSR in Battle for New-York"})
MERGE (ussr)-[:PROTOTYPE]->(emu2)
MERGE (emu2)-[:PARTICIPANT]->(em1)

MERGE (esc1:EventScenario {name: "USSR vs USA 21century"})
MERGE (esc1)-[:INCLUDES]->(em1)

MERGE (camp1:Campaign {name: "CAMPAIGN????"})
MERGE (camp1)-[:INCLUDES]->(esc1)