API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
297
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 52.04 KB | None | 0 0
raw download clone embed print report
  1. > php bin/console doctrine:migrations:migrate -n --allow-no-migration --env=test --em=default --configuration=config/packages/common/doctrine_migrations.yaml
  2. Loading configuration from command option: config/packages/common/doctrine_migrations.yaml
  3.  
  4. Application_Migrations_Default
  5.  
  6.  
  7. Migrating up to 20190108040510 from 0
  8.  
  9. ++ migrating 20181221162946
  10.  
  11. -> CREATE TABLE example (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(50) NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  12.  
  13. ++ migrated (0.19s)
  14.  
  15. ++ migrating 20190108040510
  16.  
  17. -> CREATE TABLE IF NOT EXISTS example_i18n (id INT UNSIGNED AUTO_INCREMENT NOT NULL, `datetime_at` datetime NOT NULL, `datetime_nullable_at` datetime DEFAULT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  18.  
  19. ++ migrated (0.08s)
  20.  
  21. ------------------------
  22.  
  23. ++ finished in 0.27s
  24. ++ 2 migrations executed
  25. ++ 2 sql queries
  26. > php bin/console doctrine:migrations:migrate -n --allow-no-migration --env=test --em=platform --configuration=config/packages/common/platform_migrations.yaml
  27. Loading configuration from command option: config/packages/common/platform_migrations.yaml
  28.  
  29. Platform_Migrations_Default
  30.  
  31.  
  32. Migrating up to 20190213132715 from 0
  33.  
  34. ++ migrating 20181226173116
  35.  
  36. -> CREATE TABLE coupon_code (id_coupon_code CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_coupon CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', code VARCHAR(100) NOT NULL, cashed TINYINT(1) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_372BEC9A42888AEF (id_coupon), PRIMARY KEY(id_coupon_code)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  37. -> CREATE TABLE coupon (id_coupon CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', coupon_type VARCHAR(50) NOT NULL, description LONGTEXT NOT NULL, amount_available INT NOT NULL, value NUMERIC(10, 0) NOT NULL, free_shipping TINYINT(1) DEFAULT NULL, effect_datetime DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', expiration_datetime DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', minimum_spend_amount NUMERIC(13, 4) NOT NULL, minimum_spend_currency VARCHAR(3) NOT NULL, PRIMARY KEY(id_coupon)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  38. -> CREATE TABLE `order` (id_order CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_account_buyer CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_payment CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_coupon_code CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_account_address_delivery CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', order_number VARCHAR(50) NOT NULL, external_order_number VARCHAR(50) DEFAULT NULL, status VARCHAR(100) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_F5299398C3757A7 (id_account_buyer), INDEX IDX_F5299398B3B52D7D (id_payment), INDEX IDX_F52993982F39216D (id_coupon_code), INDEX IDX_F5299398C4ED9466 (id_account_address_delivery), PRIMARY KEY(id_order)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  39. -> CREATE TABLE payment_method (id_payment_method CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(100) NOT NULL, PRIMARY KEY(id_payment_method)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  40. -> CREATE TABLE payment (id_payment CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_payment_method CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_account_buyer CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', status VARCHAR(100) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', total_price_amount NUMERIC(13, 4) NOT NULL, total_price_currency VARCHAR(3) NOT NULL, INDEX IDX_6D28840D46071CF0 (id_payment_method), INDEX IDX_6D28840DC3757A7 (id_account_buyer), PRIMARY KEY(id_payment)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  41. -> CREATE TABLE delivery (id_delivery CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_shipment_provider CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', tracking_number VARCHAR(100) NOT NULL, tracking_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', status VARCHAR(100) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_3781EC10C5A4E4EA (id_shipment_provider), PRIMARY KEY(id_delivery)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  42. -> CREATE TABLE cart (id_cart CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_account_buyer CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_offer CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', country VARCHAR(2) NOT NULL, quantity NUMERIC(10, 0) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_BA388B7C3757A7 (id_account_buyer), INDEX IDX_BA388B7C753C60E (id_offer), UNIQUE INDEX unique_id_account_buyer_id_offer_country (id_account_buyer, id_offer, country), PRIMARY KEY(id_cart)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  43. -> CREATE TABLE order_unit_status (id_order_unit_status CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', status VARCHAR(100) NOT NULL, is_positive TINYINT(1) NOT NULL, PRIMARY KEY(id_order_unit_status)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  44. -> CREATE TABLE order_unit (id_order_unit CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_order CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_account_seller CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_organization_seller CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_offer CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_shipment_option CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_order_unit_status CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', estimated_delivery_date DATE DEFAULT NULL COMMENT '(DC2Type:date_immutable)', factual_delivery_date DATE DEFAULT NULL COMMENT '(DC2Type:date_immutable)', created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', price_amount NUMERIC(13, 4) NOT NULL, price_currency VARCHAR(3) NOT NULL, delivery_cost_amount NUMERIC(13, 4) NOT NULL, delivery_cost_currency VARCHAR(3) NOT NULL, INDEX IDX_914A36441BACD2A8 (id_order), INDEX IDX_914A3644E148A089 (id_account_seller), INDEX IDX_914A3644B87E9FC2 (id_organization_seller), INDEX IDX_914A3644C753C60E (id_offer), INDEX IDX_914A364415E859FD (id_shipment_option), INDEX IDX_914A36446DC997B (id_order_unit_status), PRIMARY KEY(id_order_unit)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  45. -> CREATE TABLE order_unit_delivery (id_order_unit CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_delivery CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_EFDC4E5034C0B693 (id_order_unit), INDEX IDX_EFDC4E50675A0085 (id_delivery), PRIMARY KEY(id_order_unit, id_delivery)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  46. -> CREATE TABLE offer (id_offer CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_item CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_account_seller CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_organization CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', offer_number BIGINT NOT NULL, amount_available NUMERIC(10, 0) NOT NULL, effect_datetime DATETIME NOT NULL COMMENT '(DC2Type:datetime_immutable)', expiration_datetime DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', warehouse_processing_time INT DEFAULT NULL, is_active TINYINT(1) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', price_amount NUMERIC(13, 4) NOT NULL, price_currency VARCHAR(3) NOT NULL, marketplace_fee_amount NUMERIC(13, 4) NOT NULL, marketplace_fee_currency VARCHAR(3) NOT NULL, INDEX IDX_29D6873E943B391C (id_item), INDEX IDX_29D6873EE148A089 (id_account_seller), INDEX IDX_29D6873EE22F160E (id_organization), PRIMARY KEY(id_offer)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  47. -> CREATE TABLE offer_shipment_option (id_offer CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_shipment_option CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_ED201FA4C753C60E (id_offer), INDEX IDX_ED201FA415E859FD (id_shipment_option), PRIMARY KEY(id_offer, id_shipment_option)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  48. -> CREATE TABLE shipment_provider (id_shipment_provider CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(100) NOT NULL, PRIMARY KEY(id_shipment_provider)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  49. -> CREATE TABLE shipment_option (id_shipment_option CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_shipment_provider CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', country VARCHAR(2) NOT NULL, min_shipping_time INT NOT NULL, max_shipping_time INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', shipping_fee_amount NUMERIC(13, 4) NOT NULL, shipping_fee_currency VARCHAR(3) NOT NULL, INDEX IDX_FCB69A75C5A4E4EA (id_shipment_provider), PRIMARY KEY(id_shipment_option)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  50. -> CREATE TABLE category (id_category CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_parent CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(255) NOT NULL, languages JSON DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_64C19C11BB9D5A2 (id_parent), PRIMARY KEY(id_category)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  51. -> CREATE TABLE item (id_item CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_parent CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_item_type CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_account_owner CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', gtin VARCHAR(25) NOT NULL, mpn VARCHAR(100) DEFAULT NULL, mid VARCHAR(50) DEFAULT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(255) NOT NULL, description_long LONGTEXT DEFAULT NULL, languages JSON DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_1F1B251E1BB9D5A2 (id_parent), INDEX IDX_1F1B251EC4DBAFF5 (id_item_type), INDEX IDX_1F1B251E47C7EE68 (id_account_owner), PRIMARY KEY(id_item)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  52. -> CREATE TABLE option_value (id_option_value CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_option CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', value VARCHAR(255) NOT NULL, languages JSON DEFAULT NULL, INDEX IDX_249CE55C7CB1B55D (id_option), PRIMARY KEY(id_option_value)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  53. -> CREATE TABLE option_measure_unit (id_option_measure_unit CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', abbreviation VARCHAR(10) NOT NULL, measure VARCHAR(100) DEFAULT NULL, languages JSON DEFAULT NULL, PRIMARY KEY(id_option_measure_unit)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  54. -> CREATE TABLE option_set (id_option_set CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_option CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_option_value CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', list_index INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_506AF59B7CB1B55D (id_option), INDEX IDX_506AF59B75D902E (id_option_value), UNIQUE INDEX unique_id_option_id_option_value (id_option, id_option_value), PRIMARY KEY(id_option_set)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  55. -> CREATE TABLE `option` (id_option CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_option_measure_unit CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_option_data_type CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(100) NOT NULL, is_list TINYINT(1) DEFAULT NULL, languages JSON DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_5A8600B011A295E0 (id_option_measure_unit), INDEX IDX_5A8600B0580D99A (id_option_data_type), PRIMARY KEY(id_option)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  56. -> CREATE TABLE item_type (id_item_type CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(100) NOT NULL, languages JSON DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', PRIMARY KEY(id_item_type)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  57. -> CREATE TABLE item_type_option_set (id_item_type CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_option_set CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_F7A8F81CC4DBAFF5 (id_item_type), INDEX IDX_F7A8F81CF5E0754C (id_option_set), PRIMARY KEY(id_item_type, id_option_set)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  58. -> CREATE TABLE item_option_value (id_item_option_value CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_item CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_option CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_option_value CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', absolute_value VARCHAR(255) DEFAULT NULL, INDEX IDX_EBC6189D943B391C (id_item), INDEX IDX_EBC6189D7CB1B55D (id_option), INDEX IDX_EBC6189D75D902E (id_option_value), UNIQUE INDEX unique_id_item_id_option_id_option_value (id_item, id_option, id_option_value), PRIMARY KEY(id_item_option_value)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  59. -> CREATE TABLE item_type_category (id_item_type_category CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_item_type CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_category CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', priority INT DEFAULT NULL, is_default TINYINT(1) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_271F96E6C4DBAFF5 (id_item_type), INDEX IDX_271F96E65697F554 (id_category), UNIQUE INDEX unique_id_item_type_id_category (id_item_type, id_category), PRIMARY KEY(id_item_type_category)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  60. -> CREATE TABLE option_data_type (id_option_data_type CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(100) NOT NULL, PRIMARY KEY(id_option_data_type)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  61. -> CREATE TABLE seller_assortment (id_seller_assortment CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_item CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_organization CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', sku VARCHAR(100) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_E5059CE1943B391C (id_item), INDEX IDX_E5059CE1E22F160E (id_organization), PRIMARY KEY(id_seller_assortment)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  62. -> CREATE TABLE account_credentials (id_account_credentials CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', email VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, salt VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_2B42D40DE7927C74 (email), PRIMARY KEY(id_account_credentials)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  63. -> CREATE TABLE organization (id_organization CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, PRIMARY KEY(id_organization)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  64. -> CREATE TABLE address (id_address CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_country VARCHAR(2) NOT NULL, postal_code VARCHAR(15) NOT NULL, city VARCHAR(100) NOT NULL, address VARCHAR(255) NOT NULL, street_name VARCHAR(50) NOT NULL, street_name_2 VARCHAR(50) NOT NULL, house_number VARCHAR(10) NOT NULL, addition VARCHAR(25) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', PRIMARY KEY(id_address)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  65. -> CREATE TABLE organization_address (id_organization_address CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_organization CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_address CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', address_type VARCHAR(15) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_C09CE7C2E22F160E (id_organization), INDEX IDX_C09CE7C2D3D3C6F1 (id_address), UNIQUE INDEX unique_id_organization_id_address_adress_type (id_organization, id_address, address_type), PRIMARY KEY(id_organization_address)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  66. -> CREATE TABLE account (id_account CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_account_credentials CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', email VARCHAR(255) NOT NULL, account_number VARCHAR(50) NOT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, status VARCHAR(50) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_7D3656A46DA848C6 (id_account_credentials), UNIQUE INDEX unique_email (email), UNIQUE INDEX unique_account_number (account_number), PRIMARY KEY(id_account)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  67. -> CREATE TABLE account_organization (id_account CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_organization CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_5836753AA3ABFFD4 (id_account), INDEX IDX_5836753AE22F160E (id_organization), PRIMARY KEY(id_account, id_organization)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  68. -> CREATE TABLE account_role (id_account CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_role CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_DBFA0DC0A3ABFFD4 (id_account), INDEX IDX_DBFA0DC0DC499668 (id_role), PRIMARY KEY(id_account, id_role)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  69. -> CREATE TABLE role (id_role CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', name VARCHAR(50) NOT NULL, type VARCHAR(50) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, PRIMARY KEY(id_role)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  70. -> CREATE TABLE account_address (id_account_address CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_account CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_address CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', address_type VARCHAR(15) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_C4657BC9A3ABFFD4 (id_account), INDEX IDX_C4657BC9D3D3C6F1 (id_address), UNIQUE INDEX unique_id_account_id_address_adress_type (id_account, id_address, address_type), PRIMARY KEY(id_account_address)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  71. -> CREATE TABLE country (id_country VARCHAR(2) NOT NULL, country VARCHAR(50) NOT NULL, PRIMARY KEY(id_country)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  72. -> CREATE TABLE language (id_language VARCHAR(2) NOT NULL, language VARCHAR(50) NOT NULL, PRIMARY KEY(id_language)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  73. -> ALTER TABLE coupon_code ADD CONSTRAINT FK_372BEC9A42888AEF FOREIGN KEY (id_coupon) REFERENCES coupon (id_coupon)
  74. -> ALTER TABLE `order` ADD CONSTRAINT FK_F5299398C3757A7 FOREIGN KEY (id_account_buyer) REFERENCES account (id_account)
  75. -> ALTER TABLE `order` ADD CONSTRAINT FK_F5299398B3B52D7D FOREIGN KEY (id_payment) REFERENCES payment (id_payment)
  76. -> ALTER TABLE `order` ADD CONSTRAINT FK_F52993982F39216D FOREIGN KEY (id_coupon_code) REFERENCES coupon_code (id_coupon_code)
  77. -> ALTER TABLE `order` ADD CONSTRAINT FK_F5299398C4ED9466 FOREIGN KEY (id_account_address_delivery) REFERENCES account_address (id_account_address)
  78. -> ALTER TABLE payment ADD CONSTRAINT FK_6D28840D46071CF0 FOREIGN KEY (id_payment_method) REFERENCES payment_method (id_payment_method)
  79. -> ALTER TABLE payment ADD CONSTRAINT FK_6D28840DC3757A7 FOREIGN KEY (id_account_buyer) REFERENCES account (id_account)
  80. -> ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10C5A4E4EA FOREIGN KEY (id_shipment_provider) REFERENCES shipment_provider (id_shipment_provider)
  81. -> ALTER TABLE cart ADD CONSTRAINT FK_BA388B7C3757A7 FOREIGN KEY (id_account_buyer) REFERENCES account (id_account)
  82. -> ALTER TABLE cart ADD CONSTRAINT FK_BA388B7C753C60E FOREIGN KEY (id_offer) REFERENCES offer (id_offer)
  83. -> ALTER TABLE order_unit ADD CONSTRAINT FK_914A36441BACD2A8 FOREIGN KEY (id_order) REFERENCES `order` (id_order)
  84. -> ALTER TABLE order_unit ADD CONSTRAINT FK_914A3644E148A089 FOREIGN KEY (id_account_seller) REFERENCES account (id_account)
  85. -> ALTER TABLE order_unit ADD CONSTRAINT FK_914A3644B87E9FC2 FOREIGN KEY (id_organization_seller) REFERENCES organization (id_organization)
  86. -> ALTER TABLE order_unit ADD CONSTRAINT FK_914A3644C753C60E FOREIGN KEY (id_offer) REFERENCES offer (id_offer)
  87. -> ALTER TABLE order_unit ADD CONSTRAINT FK_914A364415E859FD FOREIGN KEY (id_shipment_option) REFERENCES shipment_option (id_shipment_option)
  88. -> ALTER TABLE order_unit ADD CONSTRAINT FK_914A36446DC997B FOREIGN KEY (id_order_unit_status) REFERENCES order_unit_status (id_order_unit_status)
  89. -> ALTER TABLE order_unit_delivery ADD CONSTRAINT FK_EFDC4E5034C0B693 FOREIGN KEY (id_order_unit) REFERENCES order_unit (id_order_unit)
  90. -> ALTER TABLE order_unit_delivery ADD CONSTRAINT FK_EFDC4E50675A0085 FOREIGN KEY (id_delivery) REFERENCES delivery (id_delivery)
  91. -> ALTER TABLE offer ADD CONSTRAINT FK_29D6873E943B391C FOREIGN KEY (id_item) REFERENCES item (id_item)
  92. -> ALTER TABLE offer ADD CONSTRAINT FK_29D6873EE148A089 FOREIGN KEY (id_account_seller) REFERENCES account (id_account)
  93. -> ALTER TABLE offer ADD CONSTRAINT FK_29D6873EE22F160E FOREIGN KEY (id_organization) REFERENCES organization (id_organization)
  94. -> ALTER TABLE offer_shipment_option ADD CONSTRAINT FK_ED201FA4C753C60E FOREIGN KEY (id_offer) REFERENCES offer (id_offer)
  95. -> ALTER TABLE offer_shipment_option ADD CONSTRAINT FK_ED201FA415E859FD FOREIGN KEY (id_shipment_option) REFERENCES shipment_option (id_shipment_option)
  96. -> ALTER TABLE shipment_option ADD CONSTRAINT FK_FCB69A75C5A4E4EA FOREIGN KEY (id_shipment_provider) REFERENCES shipment_provider (id_shipment_provider)
  97. -> ALTER TABLE category ADD CONSTRAINT FK_64C19C11BB9D5A2 FOREIGN KEY (id_parent) REFERENCES category (id_category)
  98. -> ALTER TABLE item ADD CONSTRAINT FK_1F1B251E1BB9D5A2 FOREIGN KEY (id_parent) REFERENCES item (id_item)
  99. -> ALTER TABLE item ADD CONSTRAINT FK_1F1B251EC4DBAFF5 FOREIGN KEY (id_item_type) REFERENCES item_type (id_item_type)
  100. -> ALTER TABLE item ADD CONSTRAINT FK_1F1B251E47C7EE68 FOREIGN KEY (id_account_owner) REFERENCES account (id_account)
  101. -> ALTER TABLE option_value ADD CONSTRAINT FK_249CE55C7CB1B55D FOREIGN KEY (id_option) REFERENCES `option` (id_option)
  102. -> ALTER TABLE option_set ADD CONSTRAINT FK_506AF59B7CB1B55D FOREIGN KEY (id_option) REFERENCES `option` (id_option)
  103. -> ALTER TABLE option_set ADD CONSTRAINT FK_506AF59B75D902E FOREIGN KEY (id_option_value) REFERENCES option_value (id_option_value)
  104. -> ALTER TABLE `option` ADD CONSTRAINT FK_5A8600B011A295E0 FOREIGN KEY (id_option_measure_unit) REFERENCES option_measure_unit (id_option_measure_unit)
  105. -> ALTER TABLE `option` ADD CONSTRAINT FK_5A8600B0580D99A FOREIGN KEY (id_option_data_type) REFERENCES option_data_type (id_option_data_type)
  106. -> ALTER TABLE item_type_option_set ADD CONSTRAINT FK_F7A8F81CC4DBAFF5 FOREIGN KEY (id_item_type) REFERENCES item_type (id_item_type)
  107. -> ALTER TABLE item_type_option_set ADD CONSTRAINT FK_F7A8F81CF5E0754C FOREIGN KEY (id_option_set) REFERENCES option_set (id_option_set)
  108. -> ALTER TABLE item_option_value ADD CONSTRAINT FK_EBC6189D943B391C FOREIGN KEY (id_item) REFERENCES item (id_item)
  109. -> ALTER TABLE item_option_value ADD CONSTRAINT FK_EBC6189D7CB1B55D FOREIGN KEY (id_option) REFERENCES `option` (id_option)
  110. -> ALTER TABLE item_option_value ADD CONSTRAINT FK_EBC6189D75D902E FOREIGN KEY (id_option_value) REFERENCES option_value (id_option_value)
  111. -> ALTER TABLE item_type_category ADD CONSTRAINT FK_271F96E6C4DBAFF5 FOREIGN KEY (id_item_type) REFERENCES item_type (id_item_type)
  112. -> ALTER TABLE item_type_category ADD CONSTRAINT FK_271F96E65697F554 FOREIGN KEY (id_category) REFERENCES category (id_category)
  113. -> ALTER TABLE seller_assortment ADD CONSTRAINT FK_E5059CE1943B391C FOREIGN KEY (id_item) REFERENCES item (id_item)
  114. -> ALTER TABLE seller_assortment ADD CONSTRAINT FK_E5059CE1E22F160E FOREIGN KEY (id_organization) REFERENCES organization (id_organization)
  115. -> ALTER TABLE organization_address ADD CONSTRAINT FK_C09CE7C2E22F160E FOREIGN KEY (id_organization) REFERENCES organization (id_organization)
  116. -> ALTER TABLE organization_address ADD CONSTRAINT FK_C09CE7C2D3D3C6F1 FOREIGN KEY (id_address) REFERENCES address (id_address)
  117. -> ALTER TABLE account ADD CONSTRAINT FK_7D3656A46DA848C6 FOREIGN KEY (id_account_credentials) REFERENCES account_credentials (id_account_credentials)
  118. -> ALTER TABLE account_organization ADD CONSTRAINT FK_5836753AA3ABFFD4 FOREIGN KEY (id_account) REFERENCES account (id_account)
  119. -> ALTER TABLE account_organization ADD CONSTRAINT FK_5836753AE22F160E FOREIGN KEY (id_organization) REFERENCES organization (id_organization)
  120. -> ALTER TABLE account_role ADD CONSTRAINT FK_DBFA0DC0A3ABFFD4 FOREIGN KEY (id_account) REFERENCES account (id_account)
  121. -> ALTER TABLE account_role ADD CONSTRAINT FK_DBFA0DC0DC499668 FOREIGN KEY (id_role) REFERENCES role (id_role)
  122. -> ALTER TABLE account_address ADD CONSTRAINT FK_C4657BC9A3ABFFD4 FOREIGN KEY (id_account) REFERENCES account (id_account)
  123. -> ALTER TABLE account_address ADD CONSTRAINT FK_C4657BC9D3D3C6F1 FOREIGN KEY (id_address) REFERENCES address (id_address)
  124.  
  125. ++ migrated (11.73s)
  126.  
  127. ++ migrating 20181226173209
  128.  
  129. -> INSERT INTO payment_method (id_payment_method, name) VALUES ('1b05b4e4-1444-4812-9ca2-14d9052b8980', 'Cash-in-advance')
  130. -> INSERT INTO shipment_provider (id_shipment_provider, name) VALUES ('fd0333f5-c73e-4531-9ce6-a3f06d9ea2f3', 'DHL')
  131. -> INSERT INTO order_unit_status (id_order_unit_status, status, is_positive) VALUES ('241b15ee-b21c-405c-9ccb-bf3346a053d8', 'In delivery', 1), ('44de2e02-4ccb-47ec-b2c1-cd15e3bc240f', 'Delivered', 1), ('909709a4-461a-4e9e-a4ac-3f641b07ebfe', 'Cancelled', 0)
  132. -> INSERT INTO country (id_country, country) VALUES ('de', 'Germany'), ('ua', 'Ukraine')
  133. -> INSERT INTO language (id_language, language) VALUES ('en', 'English'), ('de', 'Deutsch')
  134. -> INSERT INTO role (id_role, name, type, created_at, updated_at) VALUES ('9b1e3b71-882f-4ee3-879d-83110402c389', 'ROLE_BUYER', 'Account', NOW(), NOW()), ('975389d6-525a-40f8-913b-58d32ebf3add', 'ROLE_SELLER', 'Account', NOW(), NOW())
  135.  
  136. ++ migrated (0.06s)
  137.  
  138. ++ migrating 20181227170256
  139.  
  140. -> CREATE TABLE offer_inventory (id_offer_inventory CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_item CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_account_seller CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_organization CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', sku VARCHAR(100) NOT NULL, quantity NUMERIC(10, 0) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_12E837F2943B391C (id_item), INDEX IDX_12E837F2E148A089 (id_account_seller), INDEX IDX_12E837F2E22F160E (id_organization), UNIQUE INDEX unique_sku (sku), PRIMARY KEY(id_offer_inventory)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  141. -> ALTER TABLE offer_inventory ADD CONSTRAINT FK_12E837F2943B391C FOREIGN KEY (id_item) REFERENCES item (id_item)
  142. -> ALTER TABLE offer_inventory ADD CONSTRAINT FK_12E837F2E148A089 FOREIGN KEY (id_account_seller) REFERENCES account (id_account)
  143. -> ALTER TABLE offer_inventory ADD CONSTRAINT FK_12E837F2E22F160E FOREIGN KEY (id_organization) REFERENCES organization (id_organization)
  144. -> ALTER TABLE offer ADD sku VARCHAR(100) NOT NULL, DROP amount_available
  145. -> ALTER TABLE account_organization DROP PRIMARY KEY
  146. -> ALTER TABLE account_organization ADD id_account_organization CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', ADD id_role CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', ADD created_at DATETIME NOT NULL, ADD updated_at DATETIME DEFAULT NULL, ADD deleted_at DATETIME DEFAULT NULL, ADD created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', ADD updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', ADD deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', CHANGE id_account id_account CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', CHANGE id_organization id_organization CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)'
  147. -> ALTER TABLE account_organization ADD CONSTRAINT FK_5836753ADC499668 FOREIGN KEY (id_role) REFERENCES role (id_role)
  148. -> CREATE INDEX IDX_5836753ADC499668 ON account_organization (id_role)
  149. -> CREATE UNIQUE INDEX unique_id_account_id_organization_id_role ON account_organization (id_account, id_organization, id_role)
  150. -> ALTER TABLE account_organization ADD PRIMARY KEY (id_account_organization)
  151. -> ALTER TABLE account_role DROP PRIMARY KEY
  152. -> ALTER TABLE account_role ADD id_account_role CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', ADD created_at DATETIME NOT NULL, ADD updated_at DATETIME DEFAULT NULL, ADD deleted_at DATETIME DEFAULT NULL, ADD created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', ADD updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', ADD deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', CHANGE id_account id_account CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', CHANGE id_role id_role CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)'
  153. -> CREATE UNIQUE INDEX unique_id_account_id_role ON account_role (id_account, id_role)
  154. -> ALTER TABLE account_role ADD PRIMARY KEY (id_account_role)
  155.  
  156. ++ migrated (1.92s)
  157.  
  158. ++ migrating 20190104091908
  159.  
  160. -> ALTER TABLE account_credentials ADD id_account CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)' AFTER id_account_credentials
  161. -> ALTER TABLE account_credentials ADD CONSTRAINT FK_2B42D40DA3ABFFD4 FOREIGN KEY (id_account) REFERENCES account (id_account)
  162. -> CREATE UNIQUE INDEX UNIQ_2B42D40DA3ABFFD4 ON account_credentials (id_account)
  163. -> ALTER TABLE account DROP FOREIGN KEY FK_7D3656A46DA848C6
  164. -> DROP INDEX UNIQ_7D3656A46DA848C6 ON account
  165. -> ALTER TABLE account DROP id_account_credentials
  166.  
  167. ++ migrated (0.54s)
  168.  
  169. ++ migrating 20190110102536
  170.  
  171. -> ALTER TABLE order_unit_delivery DROP FOREIGN KEY FK_EFDC4E5034C0B693
  172. -> ALTER TABLE order_unit DROP FOREIGN KEY FK_914A36446DC997B
  173. -> CREATE TABLE order_line (id_order_line CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_order CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_account_seller CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_organization_seller CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_offer CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_shipment_option CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', estimated_delivery_date DATE DEFAULT NULL COMMENT '(DC2Type:date_immutable)', factual_delivery_date DATE DEFAULT NULL COMMENT '(DC2Type:date_immutable)', quantity INT UNSIGNED NOT NULL, cancelled_quantity INT UNSIGNED DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', price_amount NUMERIC(13, 4) NOT NULL, price_currency VARCHAR(3) NOT NULL, delivery_cost_amount NUMERIC(13, 4) NOT NULL, delivery_cost_currency VARCHAR(3) NOT NULL, INDEX IDX_9CE58EE11BACD2A8 (id_order), INDEX IDX_9CE58EE1E148A089 (id_account_seller), INDEX IDX_9CE58EE1B87E9FC2 (id_organization_seller), INDEX IDX_9CE58EE1C753C60E (id_offer), INDEX IDX_9CE58EE115E859FD (id_shipment_option), PRIMARY KEY(id_order_line)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  174. -> ALTER TABLE order_line ADD CONSTRAINT FK_9CE58EE11BACD2A8 FOREIGN KEY (id_order) REFERENCES `order` (id_order)
  175. -> ALTER TABLE order_line ADD CONSTRAINT FK_9CE58EE1E148A089 FOREIGN KEY (id_account_seller) REFERENCES account (id_account)
  176. -> ALTER TABLE order_line ADD CONSTRAINT FK_9CE58EE1B87E9FC2 FOREIGN KEY (id_organization_seller) REFERENCES organization (id_organization)
  177. -> ALTER TABLE order_line ADD CONSTRAINT FK_9CE58EE1C753C60E FOREIGN KEY (id_offer) REFERENCES offer (id_offer)
  178. -> ALTER TABLE order_line ADD CONSTRAINT FK_9CE58EE115E859FD FOREIGN KEY (id_shipment_option) REFERENCES shipment_option (id_shipment_option)
  179. -> DROP TABLE order_unit
  180. -> DROP TABLE order_unit_delivery
  181. -> DROP TABLE order_unit_status
  182. -> ALTER TABLE delivery ADD id_order_line CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', ADD quantity INT UNSIGNED NOT NULL
  183. -> ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10396F0E36 FOREIGN KEY (id_order_line) REFERENCES order_line (id_order_line)
  184. -> CREATE INDEX IDX_3781EC10396F0E36 ON delivery (id_order_line)
  185. -> ALTER TABLE cart CHANGE quantity quantity INT NOT NULL
  186.  
  187. ++ migrated (1.77s)
  188.  
  189. ++ migrating 20190122112205
  190.  
  191. -> ALTER TABLE order_line ADD status VARCHAR(255) DEFAULT NULL
  192.  
  193. ++ migrated (0.15s)
  194.  
  195. ++ migrating 20190122151641
  196.  
  197. -> ALTER TABLE offer ADD id_offer_inventory CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)'
  198. -> ALTER TABLE offer ADD CONSTRAINT FK_29D6873EFBB6F47A FOREIGN KEY (id_offer_inventory) REFERENCES offer_inventory (id_offer_inventory)
  199. -> CREATE INDEX IDX_29D6873EFBB6F47A ON offer (id_offer_inventory)
  200. -> ALTER TABLE offer_inventory DROP FOREIGN KEY FK_12E837F2E148A089
  201. -> DROP INDEX unique_sku ON offer_inventory
  202. -> DROP INDEX IDX_12E837F2E148A089 ON offer_inventory
  203. -> ALTER TABLE offer_inventory DROP id_account_seller
  204. -> CREATE UNIQUE INDEX unique_id_organization_sku ON offer_inventory (id_organization, sku)
  205.  
  206. ++ migrated (0.67s)
  207.  
  208. ++ migrating 20190125124135
  209.  
  210. -> CREATE TABLE order_address (id_order_address CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_order CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', address_type VARCHAR(15) NOT NULL, id_country VARCHAR(2) NOT NULL, postal_code VARCHAR(15) NOT NULL, city VARCHAR(100) NOT NULL, address VARCHAR(255) DEFAULT NULL, street_name VARCHAR(50) DEFAULT NULL, street_name_2 VARCHAR(50) DEFAULT NULL, house_number VARCHAR(10) DEFAULT NULL, addition VARCHAR(25) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_FB34C6CA1BACD2A8 (id_order), PRIMARY KEY(id_order_address)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  211. -> ALTER TABLE order_address ADD CONSTRAINT FK_FB34C6CA1BACD2A8 FOREIGN KEY (id_order) REFERENCES `order` (id_order)
  212. -> ALTER TABLE `order` ADD placed_date DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)'
  213. -> ALTER TABLE order_line DROP estimated_delivery_date, DROP factual_delivery_date, DROP cancelled_quantity, DROP delivery_cost_amount, DROP delivery_cost_currency
  214. -> ALTER TABLE address CHANGE address address VARCHAR(255) DEFAULT NULL, CHANGE street_name street_name VARCHAR(50) DEFAULT NULL, CHANGE street_name_2 street_name_2 VARCHAR(50) DEFAULT NULL, CHANGE house_number house_number VARCHAR(10) DEFAULT NULL, CHANGE addition addition VARCHAR(25) DEFAULT NULL
  215. -> ALTER TABLE account_address ADD is_default TINYINT(1) DEFAULT NULL
  216. -> ALTER TABLE organization_address ADD is_default TINYINT(1) DEFAULT NULL
  217.  
  218. ++ migrated (0.91s)
  219.  
  220. ++ migrating 20190128170426
  221.  
  222. -> ALTER TABLE order_address CHANGE id_country id_country VARCHAR(2) DEFAULT NULL
  223. -> ALTER TABLE order_address ADD CONSTRAINT FK_FB34C6CA8DEE6016 FOREIGN KEY (id_country) REFERENCES country (id_country)
  224. -> CREATE INDEX IDX_FB34C6CA8DEE6016 ON order_address (id_country)
  225. -> ALTER TABLE address CHANGE id_country id_country VARCHAR(2) DEFAULT NULL, CHANGE address address VARCHAR(255) DEFAULT NULL, CHANGE street_name street_name VARCHAR(50) DEFAULT NULL, CHANGE street_name_2 street_name_2 VARCHAR(50) DEFAULT NULL, CHANGE house_number house_number VARCHAR(10) DEFAULT NULL, CHANGE addition addition VARCHAR(25) DEFAULT NULL
  226. -> ALTER TABLE address ADD CONSTRAINT FK_D4E6F818DEE6016 FOREIGN KEY (id_country) REFERENCES country (id_country)
  227. -> CREATE INDEX IDX_D4E6F818DEE6016 ON address (id_country)
  228.  
  229. ++ migrated (0.72s)
  230.  
  231. ++ migrating 20190128170549
  232.  
  233. -> ALTER TABLE country CHANGE country country VARCHAR(255) NOT NULL
  234. -> INSERT INTO country (id_country, country) VALUES ('af', 'Afghanistan'), ('ax', 'Åland Islands'), ('al', 'Albania'), ('dz', 'Algeria'), ('as', 'American Samoa'), ('ad', 'Andorra'), ('ao', 'Angola'), ('ai', 'Anguilla'), ('aq', 'Antarctica'), ('ag', 'Antigua and Barbuda'), ('ar', 'Argentina'), ('am', 'Armenia'), ('aw', 'Aruba'), ('au', 'Australia'), ('at', 'Austria'), ('az', 'Azerbaijan'), ('bs', 'Bahamas'), ('bh', 'Bahrain'), ('bd', 'Bangladesh'), ('bb', 'Barbados'), ('by', 'Belarus'), ('be', 'Belgium'), ('bz', 'Belize'), ('bj', 'Benin'), ('bm', 'Bermuda'), ('bt', 'Bhutan'), ('bo', 'Bolivia (Plurinational State of)'), ('bq', 'Bonaire, Sint Eustatius and Saba'), ('ba', 'Bosnia and Herzegovina'), ('bw', 'Botswana'), ('bv', 'Bouvet Island'), ('br', 'Brazil'), ('io', 'British Indian Ocean Territory'), ('bn', 'Brunei Darussalam'), ('bg', 'Bulgaria'), ('bf', 'Burkina Faso'), ('bi', 'Burundi'), ('cv', 'Cabo Verde'), ('kh', 'Cambodia'), ('cm', 'Cameroon'), ('ca', 'Canada'), ('ky', 'Cayman Islands'), ('cf', 'Central African Republic'), ('td', 'Chad'), ('cl', 'Chile'), ('cn', 'China'), ('cx', 'Christmas Island'), ('cc', 'Cocos (Keeling) Islands'), ('co', 'Colombia'), ('km', 'Comoros'), ('cg', 'Congo'), ('cd', 'Congo, Democratic Republic of the'), ('ck', 'Cook Islands'), ('cr', 'Costa Rica'), ('ci', 'Côte d\'Ivoire'), ('hr', 'Croatia'), ('cu', 'Cuba'), ('cw', 'Curaçao'), ('cy', 'Cyprus'), ('cz', 'Czechia'), ('dk', 'Denmark'), ('dj', 'Djibouti'), ('dm', 'Dominica'), ('do', 'Dominican Republic'), ('ec', 'Ecuador'), ('eg', 'Egypt'), ('sv', 'El Salvador'), ('gq', 'Equatorial Guinea'), ('er', 'Eritrea'), ('ee', 'Estonia'), ('sz', 'Eswatini'), ('et', 'Ethiopia'), ('fk', 'Falkland Islands (Malvinas)'), ('fo', 'Faroe Islands'), ('fj', 'Fiji'), ('fi', 'Finland'), ('fr', 'France'), ('gf', 'French Guiana'), ('pf', 'French Polynesia'), ('tf', 'French Southern Territories'), ('ga', 'Gabon'), ('gm', 'Gambia'), ('ge', 'Georgia'), ('de', 'Germany'), ('gh', 'Ghana'), ('gi', 'Gibraltar'), ('gr', 'Greece'), ('gl', 'Greenland'), ('gd', 'Grenada'), ('gp', 'Guadeloupe'), ('gu', 'Guam'), ('gt', 'Guatemala'), ('gg', 'Guernsey'), ('gn', 'Guinea'), ('gw', 'Guinea-Bissau'), ('gy', 'Guyana'), ('ht', 'Haiti'), ('hm', 'Heard Island and McDonald Islands'), ('va', 'Holy See'), ('hn', 'Honduras'), ('hk', 'Hong Kong'), ('hu', 'Hungary'), ('is', 'Iceland'), ('in', 'India'), ('id', 'Indonesia'), ('ir', 'Iran (Islamic Republic of)'), ('iq', 'Iraq'), ('ie', 'Ireland'), ('im', 'Isle of Man'), ('il', 'Israel'), ('it', 'Italy'), ('jm', 'Jamaica'), ('jp', 'Japan'), ('je', 'Jersey'), ('jo', 'Jordan'), ('kz', 'Kazakhstan'), ('ke', 'Kenya'), ('ki', 'Kiribati'), ('kp', 'Korea (Democratic People\'s Republic of)'), ('kr', 'Korea, Republic of'), ('kw', 'Kuwait'), ('kg', 'Kyrgyzstan'), ('la', 'Lao People\'s Democratic Republic'), ('lv', 'Latvia'), ('lb', 'Lebanon'), ('ls', 'Lesotho'), ('lr', 'Liberia'), ('ly', 'Libya'), ('li', 'Liechtenstein'), ('lt', 'Lithuania'), ('lu', 'Luxembourg'), ('mo', 'Macao'), ('mk', 'Macedonia, the former Yugoslav Republic of'), ('mg', 'Madagascar'), ('mw', 'Malawi'), ('my', 'Malaysia'), ('mv', 'Maldives'), ('ml', 'Mali'), ('mt', 'Malta'), ('mh', 'Marshall Islands'), ('mq', 'Martinique'), ('mr', 'Mauritania'), ('mu', 'Mauritius'), ('yt', 'Mayotte'), ('mx', 'Mexico'), ('fm', 'Micronesia (Federated States of)'), ('md', 'Moldova, Republic of'), ('mc', 'Monaco'), ('mn', 'Mongolia'), ('me', 'Montenegro'), ('ms', 'Montserrat'), ('ma', 'Morocco'), ('mz', 'Mozambique'), ('mm', 'Myanmar'), ('na', 'Namibia'), ('nr', 'Nauru'), ('np', 'Nepal'), ('nl', 'Netherlands'), ('nc', 'New Caledonia'), ('nz', 'New Zealand'), ('ni', 'Nicaragua'), ('ne', 'Niger'), ('ng', 'Nigeria'), ('nu', 'Niue'), ('nf', 'Norfolk Island'), ('mp', 'Northern Mariana Islands'), ('no', 'Norway'), ('om', 'Oman'), ('pk', 'Pakistan'), ('pw', 'Palau'), ('ps', 'Palestine, State of'), ('pa', 'Panama'), ('pg', 'Papua New Guinea'), ('py', 'Paraguay'), ('pe', 'Peru'), ('ph', 'Philippines'), ('pn', 'Pitcairn'), ('pl', 'Poland'), ('pt', 'Portugal'), ('pr', 'Puerto Rico'), ('qa', 'Qatar'), ('re', 'Réunion'), ('ro', 'Romania'), ('ru', 'Russian Federation'), ('rw', 'Rwanda'), ('bl', 'Saint Barthélemy'), ('sh', 'Saint Helena, Ascension and Tristan da Cunha'), ('kn', 'Saint Kitts and Nevis'), ('lc', 'Saint Lucia'), ('mf', 'Saint Martin (French part)'), ('pm', 'Saint Pierre and Miquelon'), ('vc', 'Saint Vincent and the Grenadines'), ('ws', 'Samoa'), ('sm', 'San Marino'), ('st', 'Sao Tome and Principe'), ('sa', 'Saudi Arabia'), ('sn', 'Senegal'), ('rs', 'Serbia'), ('sc', 'Seychelles'), ('sl', 'Sierra Leone'), ('sg', 'Singapore'), ('sx', 'Sint Maarten (Dutch part)'), ('sk', 'Slovakia'), ('si', 'Slovenia'), ('sb', 'Solomon Islands'), ('so', 'Somalia'), ('za', 'South Africa'), ('gs', 'South Georgia and the South Sandwich Islands'), ('ss', 'South Sudan'), ('es', 'Spain'), ('lk', 'Sri Lanka'), ('sd', 'Sudan'), ('sr', 'Suriname'), ('sj', 'Svalbard and Jan Mayen'), ('se', 'Sweden'), ('ch', 'Switzerland'), ('sy', 'Syrian Arab Republic'), ('tw', 'Taiwan, Province of China'), ('tj', 'Tajikistan'), ('tz', 'Tanzania, United Republic of'), ('th', 'Thailand'), ('tl', 'Timor-Leste'), ('tg', 'Togo'), ('tk', 'Tokelau'), ('to', 'Tonga'), ('tt', 'Trinidad and Tobago'), ('tn', 'Tunisia'), ('tr', 'Turkey'), ('tm', 'Turkmenistan'), ('tc', 'Turks and Caicos Islands'), ('tv', 'Tuvalu'), ('ug', 'Uganda'), ('ua', 'Ukraine'), ('ae', 'United Arab Emirates'), ('gb', 'United Kingdom of Great Britain and Northern Ireland'), ('um', 'United States Minor Outlying Islands'), ('us', 'United States of America'), ('uy', 'Uruguay'), ('uz', 'Uzbekistan'), ('vu', 'Vanuatu'), ('ve', 'Venezuela (Bolivarian Republic of)'), ('vn', 'Viet Nam'), ('vg', 'Virgin Islands (British)'), ('vi', 'Virgin Islands (U.S.)'), ('wf', 'Wallis and Futuna'), ('eh', 'Western Sahara'), ('ye', 'Yemen'), ('zm', 'Zambia'), ('zw', 'Zimbabwe') ON DUPLICATE KEY UPDATE country=VALUES(country)
  235.  
  236. ++ migrated (0.2s)
  237.  
  238. ++ migrating 20190129125340
  239.  
  240. -> CREATE TABLE item_image (id_item_image CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_item CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', label VARCHAR(255) DEFAULT NULL, image_type VARCHAR(15) NOT NULL, url VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_EF9A1F8F943B391C (id_item), UNIQUE INDEX unique_id_item_type (id_item, image_type), PRIMARY KEY(id_item_image)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  241. -> ALTER TABLE item_image ADD CONSTRAINT FK_EF9A1F8F943B391C FOREIGN KEY (id_item) REFERENCES item (id_item)
  242.  
  243. ++ migrated (0.24s)
  244.  
  245. ++ migrating 20190130114126
  246.  
  247. -> CREATE TABLE save_list (id_save_list CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_account CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_3B284F7DA3ABFFD4 (id_account), PRIMARY KEY(id_save_list)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  248. -> CREATE TABLE save_list_item (id_save_list_item CHAR(36) NOT NULL COMMENT '(DC2Type:uuid)', id_save_list CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', id_item CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, created_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', updated_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', deleted_by CHAR(36) DEFAULT NULL COMMENT '(DC2Type:uuid)', INDEX IDX_8AE7C170BB1DF35A (id_save_list), INDEX IDX_8AE7C170943B391C (id_item), PRIMARY KEY(id_save_list_item)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB
  249. -> ALTER TABLE save_list ADD CONSTRAINT FK_3B284F7DA3ABFFD4 FOREIGN KEY (id_account) REFERENCES account (id_account)
  250. -> ALTER TABLE save_list_item ADD CONSTRAINT FK_8AE7C170BB1DF35A FOREIGN KEY (id_save_list) REFERENCES save_list (id_save_list)
  251. -> ALTER TABLE save_list_item ADD CONSTRAINT FK_8AE7C170943B391C FOREIGN KEY (id_item) REFERENCES item (id_item)
  252.  
  253. ++ migrated (0.63s)
  254.  
  255. ++ migrating 20190213132715
  256.  
  257. -> ALTER TABLE offer ADD sequence_number BIGINT UNSIGNED NOT NULL
  258. -> CREATE UNIQUE INDEX UNIQ_29D6873EF2803B3D ON offer (sequence_number)
  259.  
  260. ++ migrated (0.2s)
  261.  
  262. ------------------------
  263.  
  264. ++ finished in 19.74s
  265. ++ 13 migrations executed
  266. ++ 163 sql queries
  267. > php bin/console doctrine:fixtures:load --env=test --no-interaction
  268.  
  269. > purging database
  270. > loading Tests\DataFixtures\AccountFixtures
  271. > loading Tests\DataFixtures\CategoryFixtures
  272. > loading Tests\DataFixtures\ItemTypeFixtures
  273. > loading Tests\DataFixtures\LocalExampleFixtures
  274. > loading Tests\DataFixtures\ItemFixtures
  275. > loading Tests\DataFixtures\ItemTypeCategoryFixtures
  276. > loading Tests\DataFixtures\OfferFixtures
  277.  
  278. In AbstractMySQLDriver.php line 103:
  279.  
  280. An exception occurred while executing 'INSERT INTO offer (sequence_number,
  281. sku, offer_number, effect_datetime, expiration_datetime, warehouse_processi
  282. ng_time, is_active, created_at, updated_at, deleted_at, created_by, updated
  283. _by, deleted_by, id_offer, price_amount, price_currency, marketplace_fee_am
  284. ount, marketplace_fee_currency, id_item, id_account_seller, id_organization
  285. , id_offer_inventory) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
  286. ?, ?, ?, ?, ?, ?, ?)' with params [null, "426471", "501639", "2019-02-21 10
  287. :51:39", null, 0, 1, "2019-02-21 10:51:39", "2019-02-21 10:51:39", null, nu
  288. ll, null, null, "baf76642-7071-4337-86fc-9369dacfec90", "4.6", "USD", "0.01
  289. ", "USD", "0a8c2805-ef97-44c9-96cb-8f4c122838f5", null, null, null]:
  290.  
  291. SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sequence_numb
  292. er' cannot be null
  293.  
  294.  
  295. In PDOStatement.php line 119:
  296.  
  297. SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sequence_numb
  298. er' cannot be null
  299.  
  300.  
  301. In PDOStatement.php line 117:
  302.  
  303. SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sequence_numb
  304. er' cannot be null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!