UPDATE s_core_auth
SET apiKey = 'demo'
WHERE username = 'demo';

REPLACE INTO s_core_shops (id,
                          main_id,
                          name,
                          title,
                          position,
                          host,
                          base_path,
                          base_url,
                          hosts,
                          secure,
                          template_id,
                          document_template_id,
                          category_id,
                          locale_id,
                          currency_id,
                          customer_group_id,
                          fallback_id,
                          customer_scope,
                          `default`,
                          active)
VALUES (2,
        1,
        'Demo shop en',
        null,
        0,
        null,
        null,
        null,
        '10.222.222.30',
        0,
        22,
        22,
        3,
        2,
        1,
        1,
        null,
        0,
        0,
        1);

REPLACE INTO s_core_currencies (id, currency, name, standard, factor, templatechar, symbol_position, position)
VALUES (3, 'USD', 'Dollar', 0, 0, '$', 16, 0);

UPDATE s_core_countries
SET active = 1
WHERE id IN (3, 4);

REPLACE INTO s_core_shop_currencies (shop_id, currency_id)
VALUES (1, 3);

REPLACE INTO `swag_enterprise_price_list`
VALUES
(1, 'Test 01', 0)
,(2, 'Test 02', 0)
,(3, 'Test 03', 0)
,(4, 'Test 04', 0)
,(5, 'Test 05', 0)
,(6, 'Test 06 only Brutto prices', 0)
,(7, 'Test 07 with date related prices', 0)
,(8, 'Dummy Price List for Unit testing', 0)
,(9, 'Price List for Unit testing with CustomerCondition', 10)
,(10, 'Price List for Unit testing with calculations', 10)
,(11, 'Price List for Unit testing merge feature', 0)
,(12, 'Price List for Unit testing merge feature', 10)
;

REPLACE INTO swag_enterprise_price_list_condition (id, price_list_id, type, value)
VALUES (1, 2, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CountryCondition', '2'),
       (2, 2, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\ShopCondition', '1'),
       (3, 2, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CurrencyCondition', 'EUR'),
       (4, 3, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CountryCondition', '2'),
       (5, 3, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\ShopCondition', '1'),
       (6, 3, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CurrencyCondition', 'USD'),
       (7, 4, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CountryCondition', '2'),
       (8, 4, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\ShopCondition', '2'),
       (9, 4, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CurrencyCondition', 'EUR'),
       (10, 5, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CountryCondition', '2'),
       (11, 5, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\ShopCondition', '2'),
       (12, 5, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CurrencyCondition', 'USD'),
       (13, 6, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CountryCondition', '3'),
       (14, 7, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CountryCondition', '4'),
       (15, 9, 'SwagEnterprisePricingEngine\\Source\\PriceListCondition\\Conditions\\CustomerCondition', '250');

TRUNCATE `swag_enterprise_price_list_prices`;
INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 1,
             sad.ordernumber,
             (price * 0.9),
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             NULL,
             0
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 2,
             sad.ordernumber,
             (price * 0.8),
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             NULL,
             0
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 3,
             sad.ordernumber,
             (price * 0.7),
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             NULL,
             0
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 4,
             sad.ordernumber,
             (price * 0.6),
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             NULL,
             0
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 5,
             sad.ordernumber,
             (price * 0.5),
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             NULL,
             0
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 6,
             sad.ordernumber,
             42.42,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             101,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 0 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 1 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             102,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 1 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 2 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             103,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 2 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 3 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             104,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 3 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 4 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             105,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 4 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 5 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             106,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 5 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 6 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             107,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 6 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 7 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             108,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 7 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 8 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             109,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 8 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 9 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1010,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 9 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 10 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1011,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 10 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 11 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1012,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 11 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 12 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1013,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 12 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 13 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1014,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 13 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 14 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1015,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 14 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 15 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1016,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 15 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 16 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1017,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 16 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 17 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1018,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 17 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 18 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1019,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 18 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 19 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1020,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 19 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 20 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1021,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 20 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 21 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1022,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 21 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 22 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 7,
             sad.ordernumber,
             1023,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             DATE_ADD(CURRENT_DATE(), INTERVAL 22 HOUR),
             DATE_ADD(CURRENT_DATE(), INTERVAL 23 HOUR),
             NULL,
             1
FROM s_articles_prices sap
         INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 10,
             sad.ordernumber,
             1023,
             (price * 1.4),
             (price * 1.6),
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             '(%height% + %width% + %length% + %stock% + %weight%) * 0.1',
             0
FROM s_articles_prices sap
INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK';


INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 11,
             sad.ordernumber,
             100,
             200,
             300,
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             '',
             0
FROM s_articles_prices sap
INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK' AND sad.ordernumber IN ('SW10001','SW10002');

INSERT INTO `swag_enterprise_price_list_prices`
SELECT NULL, 12,
             sad.ordernumber,
             50,
             100,
             200,
             sap.`from`,
             REPLACE(sap.`to`, 'beliebig', 2147483647),
             NULL,
             NULL,
             '',
             0
FROM s_articles_prices sap
INNER JOIN s_articles_details sad ON sad.id = sap.articledetailsID
WHERE sap.pricegroup = 'EK' AND sad.ordernumber IN ('SW10001');

INSERT INTO s_user (id,
                    password,
                    encoder,
                    email,
                    active,
                    accountmode,
                    confirmationkey,
                    paymentID,
                    firstlogin,
                    lastlogin,
                    sessionID,
                    newsletter,
                    validation,
                    affiliate,
                    customergroup,
                    paymentpreset,
                    `language`,
                    subshopID,
                    referer,
                    pricegroupID,
                    internalcomment,
                    failedlogins,
                    lockeduntil,
                    default_billing_address_id,
                    default_shipping_address_id,
                    title,
                    salutation,
                    firstname,
                    lastname,
                    birthday,
                    customernumber)
VALUES (249,
        '$2y$10$BcCML5U2cEMTkleL8an4P.z3o7jTcobMKuppKdC/9L.tOwqtQ45hC',
        'bcrypt',
        'debtor2@example.com',
        1,
        0,
        '',
        5,
        '2011-11-23',
        '2016-11-18 21:57:59.000',
        'a50340ed8e2084f4dffe3ea98b57gc25a',
        0,
        '',
        0,
        'EK',
        0,
        '1',
        1,
        '',
        NULL,
        '',
        0,
        NULL,
        28,
        35,
        '',
        'mr',
        'Max',
        'Mustermann',
        NULL,
        '2324'),
       (250,
        '$2y$10$W9s78fS7b5uU1DHT4mEmfeg1cQxbeKy/E2YI4wAQNEywTlw5gF.XW',
        'bcrypt',
        'debtor@example.com',
        1,
        0,
        '',
        5,
        '2011-11-23',
        '2016-11-18 21:41:57.000',
        'a50340ed8e2084f4dffe3ea98b57c25a',
        0,
        '',
        0,
        'EK',
        0,
        '1',
        1,
        '',
        NULL,
        '',
        0,
        NULL,
        28,
        1,
        '',
        'mr',
        'Max',
        'Mustermann',
        NULL,
        '1324'),
       (251,
        'a256a310bc1e5db755fd392c524028a8',
        'md5',
        'contact1@example.com',
        1,
        0,
        '',
        5,
        '2011-11-23',
        '2012-01-04 14:12:05.000',
        '',
        0,
        '',
        0,
        'EK',
        0,
        '1',
        1,
        '',
        NULL,
        '',
        0,
        NULL,
        26,
        27,
        NULL,
        'mr',
        'Max',
        'Contact1',
        NULL,
        '3234');

INSERT INTO s_user_attributes (id, userID)
VALUES (449, 249),
       (450, 250),
       (452, 251);

INSERT INTO `s_user_addresses` (`id`,
                                `user_id`,
                                `company`,
                                `department`,
                                `salutation`,
                                `firstname`,
                                `lastname`,
                                `street`,
                                `zipcode`,
                                `city`,
                                `phone`,
                                `country_id`,
                                `state_id`,
                                `ustid`)
VALUES (26,
        250,
        'Debtor GMBH GmbH',
        NULL,
        'mr',
        'Max',
        'Mustermann',
        'Musterstr. 55',
        '55555',
        'Musterhausen',
        '05555 / 555555',
        2,
        3,
        NULL),
       (27,
        251,
        'Debtor GMBH GmbH',
        NULL,
        'mr',
        'Max',
        'Mustermann',
        'Musterstr. 55',
        '55555',
        'Musterhausen',
        '05555 / 555555',
        2,
        3,
        NULL),
       (28,
        250,
        'Debtor GMBH GmbH',
        NULL,
        'mr',
        'Max',
        'Mustermann',
        'Musterstr. 55',
        '55555',
        'Musterhausen',
        '05555 / 555555',
        2,
        3,
        NULL),
       (35,
        250,
        'Debtor FQM',
        'Einkauf',
        'mr',
        'Händler',
        'Kundengruppe-Netto',
        'Musterweg 1',
        '55555',
        'Musterstadt',
        '012345 / 6789',
        2,
        3,
        NULL);

INSERT INTO `s_user_addresses_attributes` (`address_id`)
VALUES (26),
       (27),
       (28),
       (35);
