DELETE FROM s_user_addresses;
DELETE FROM s_order;

INSERT INTO `s_campaigns_mailaddresses` (`customer`, `groupID`, `email`, `lastmailing`, `lastread`, `added`, `double_optin_confirmed`) VALUES
    (1,	0,	'test5@example.com',	0,	0,	'2018-06-07 10:46:11',	NULL);

INSERT INTO `s_order` (`ordernumber`, `userID`, `invoice_amount`, `invoice_amount_net`, `invoice_shipping`, `invoice_shipping_net`, `ordertime`, `status`, `cleared`, `paymentID`, `transactionID`, `comment`, `customercomment`, `internalcomment`, `net`, `taxfree`, `partnerID`, `temporaryID`, `referer`, `cleareddate`, `trackingcode`, `language`, `dispatchID`, `currency`, `currencyFactor`, `subshopID`, `remote_addr`, `deviceType`, `changed`) VALUES
    ('20001',	4,	650,	600,	0,	0,	'2012-08-30 10:15:54',	0,	17,	4,	'',	'',	'',	'',	1,	0,	'',	'',	'',	NULL,	'',	'1',	9,	'EUR',	1,	1,	'x.x.x.x',	NULL,	'2018-06-05 11:46:25'),
    ('20002',	4,	100,	80,	0,	0,	'2012-08-30 10:15:54',	0,	17,	4,	'',	'',	'',	'',	1,	0,	'',	'',	'',	NULL,	'',	'1',	9,	'EUR',	1,	1,	'x.x.x.x',	NULL,	'2018-06-05 11:46:25'),
    ('20003',	5,	850,	800,	0,	0,	'2012-08-30 10:15:54',	0,	17,	4,	'',	'',	'',	'',	1,	0,	'',	'',	'',	NULL,	'',	'1',	9,	'EUR',	1,	1,	'x.x.x.x',	NULL,	'2018-06-05 11:46:25');

