From 7e14428717a3929077447e71173ff3a52dcedc36 Mon Sep 17 00:00:00 2001 From: Roland Haeder Date: Thu, 13 Apr 2017 13:40:10 +0200 Subject: [PATCH] added initial "test data" which can be used to initialize some tables, so you have lesser to input. Please note, that the email addresses for SMS delivery are not all correct. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Roland Häder --- test_data/jjobs.sql | 67 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 67 insertions(+) create mode 100644 test_data/jjobs.sql diff --git a/test_data/jjobs.sql b/test_data/jjobs.sql new file mode 100644 index 0000000..33b5615 --- /dev/null +++ b/test_data/jjobs.sql @@ -0,0 +1,67 @@ +SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; + +-- Exportiere Daten aus Tabelle jjobs.mobile_numbers: ~1 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.mobile_provider: ~1 rows (ungefähr) +INSERT INTO `mobile_provider` (`provider_id`, `provider_dial_prefix`, `provider_entry_created`, `provider_mail_pattern`, `provider_name`, `provider_country_id`) VALUES + (1, 1511, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (2, 1512, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (3, 1514, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (4, 1515, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (5, 1516, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (6, 1517, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (7, 160, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (8, 170, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (9, 171, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (10, 175, now(), '%s@t-mobile-sms.de', 'Telekom', 1), + (11, 1520, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (12, 1522, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (13, 1523, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (14, 1525, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (15, 162, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (16, 172, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (17, 173, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (18, 174, now(), '%s@vodafone-sms.de', 'Vodafone', 1), + (19, 1570, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (20, 1573, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (21, 1575, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (22, 1577, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (23, 1578, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (24, 163, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (25, 177, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (26, 178, now(), '%s@smsmail.eplus.de', 'E-Plus', 1), + (27, 1590, now(), '%s@unknown.invalid', 'O2', 1), + (28, 176, now(), '%s@unknown.invalid', 'O2', 1), + (29, 179, now(), '%s@unknown.invalid', 'O2', 1); + +-- Exportiere Daten aus Tabelle jjobs.company_basic_data: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_branch_offices: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_contacts: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_departments: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_employees: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_headquarters: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_job_positions: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_logos: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.company_opening_times: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.country_data: ~0 rows (ungefähr) +INSERT INTO `country_data` (`country_id`, `country_abroad_dial_prefix`, `country_code`, `country_entry_created`, `country_external_dial_prefix`, `country_i18n_key`, `country_is_local_prefix_required`, `country_phone_code`) VALUES + (1, '00', 'DE', '2016-04-19 10:08:14', '0', 'COUNTRY_GERMANY', 1, 49); + +-- Exportiere Daten aus Tabelle jjobs.email_changes: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.fax_numbers: ~0 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.phone_numbers: ~1 rows (ungefähr) + +-- Exportiere Daten aus Tabelle jjobs.users: ~1 rows (ungefähr) + +SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS); -- 2.39.5