api_test/scanapp_master_data.sql

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

delete from language_lengthunit where 1;
delete from language_weightunit where 1;
delete from language_language where 1;
delete from language_languagetranslation where 1;
delete from scanapp_popup where 1;
delete from scanapp_producttype where 1;
delete from scanapp_producttypebom where 1;
delete from scanapp_fixedbom where 1;
delete from scanapp_producttypehier where 1;
delete from scanapp_producttypetranslation where 1;
delete from scanapp_activity where 1;
delete from scanapp_activitypoints where 1;
delete from scanapp_activitytranslation where 1;

delete from scanapp_badgetypeleveltext where 1;
delete from scanapp_badgetype where 1;
delete from scanapp_badgetypelevel where 1;
delete from scanapp_badgetypetext where 1;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

INSERT INTO `language_language` (`id`, `name`, `length_unit_id`, `weight_unit_id`) VALUES
(4, 'EN-US', 4, 4),
(7, 'DE-DE', 4, 4),
(8, 'EN-GB', 4, 8),
(9, 'ES-ES', 4, 4),
(10, 'RU-RU', 4, 4),
(11, 'PT-PT', 4, 4),
(12, 'ZH-CN', 4, 4);

INSERT INTO `language_languagetranslation` (`id`, `translation`, `language_id`, `translation_language_id`) VALUES
(1, 'English', 4, 4),
(2, 'German', 7, 4),
(3, 'English - GB', 8, 4),
(4, 'Spanish', 9, 4),
(5, 'Russian', 10, 4),
(6, 'Portuguese', 11, 4),
(7, 'Simplified Chinese', 12, 4),
(8, 'English (USA)', 4, 7),
(9, 'Deutsch', 7, 7),
(10, 'English (GB)', 8, 7),
(11, 'Spanisch', 9, 7),
(12, 'Russisch', 10, 7),
(13, 'Portugiesisch', 11, 7),
(14, 'Chinesisch', 12, 7),
(15, 'English', 4, 8),
(16, 'German', 7, 8),
(17, 'English - GB', 8, 8),
(18, 'Spanish', 9, 8),
(19, 'Russian', 10, 8),
(20, 'Portuguese', 11, 8),
(21, 'Simplified Chinese', 12, 8),
(22, 'English', 4, 9),
(23, 'German', 7, 9),
(24, 'English - GB', 8, 9),
(25, 'Spanish', 9, 9),
(26, 'Russian', 10, 9),
(27, 'Portuguese', 11, 9),
(28, 'Simplified Chinese', 12, 9),
(29, 'English', 4, 10),
(30, 'German', 7, 10),
(31, 'English - GB', 8, 10),
(32, 'Spanish', 9, 10),
(33, 'Russian', 10, 10),
(34, 'Portuguese', 11, 10),
(35, 'Simplified Chinese', 12, 10),
(36, 'English', 4, 11),
(37, 'German', 7, 11),
(38, 'English - GB', 8, 11),
(39, 'Spanish', 9, 11),
(40, 'Russian', 10, 11),
(41, 'Portuguese', 11, 11),
(42, 'Simplified Chinese', 12, 11),
(43, 'English', 4, 12),
(44, 'German', 7, 12),
(45, 'English - GB', 8, 12),
(46, 'Spanish', 9, 12),
(47, 'Russian', 10, 12),
(48, 'Portuguese', 11, 12),
(49, 'Simplified Chinese', 12, 12);

INSERT INTO `language_weightunit` (`id`, `name`, `conversion_rate`) VALUES
(4, 'g', 1000),
(7, 'kg', 1),
(8, 'lb', 2.20462),
(9, 'oz', 35.27392);

INSERT INTO `language_lengthunit` (`id`, `name`, `conversion_rate`) VALUES
(4, 'M', 100),
(7, 'cm', 1);

INSERT INTO `scanapp_activity` (`id`, `name`, `publicly_available`) VALUES
(25, 'bom', 0),
(28, 'bulk_recycling', 1),
(10, 'ean_codes', 0),
(37, 'ean_codes/ID', 0),
(7, 'login', 1),
(34, 'popup_user/ID', 0),
(49, 'product_hier', 0),
(31, 'product_hier/ID', 0),
(40, 'product_pictures', 1),
(13, 'products', 0),
(16, 'recycled', 1),
(4, 'registration', 1),
(19, 'statistics', 0),
(22, 'user_statistics', 0),
(43, 'webpush', 0);

INSERT INTO `scanapp_activitytranslation` (`id`, `translation`, `activity_id`, `language_id`) VALUES
(1, 'Massenrecycling', 28, 7),
(2, 'Material recycled', 16, 7),
(3, 'Bulk recycling', 28, 4),
(4, 'Material recycled', 16, 4);


INSERT INTO `scanapp_activitypoints` (`id`, `from_date`, `to_date`, `recycling_points`, `drops`, `activity_id`, `esd`) VALUES
(4, '1970-01-01', '2099-12-31', 30, 30, 4, 5),
(7, '1970-01-01', '2099-12-31', 2, 2, 7, 0),
(10, '1970-01-01', '2099-12-31', 5, 5, 16, 1),
(13, '1970-01-01', '2099-12-31', 8, 8, 28, 1),
(16, '1970-01-01', '2099-12-31', 12, 12, 10, 2);


INSERT INTO `scanapp_popup` (`id`, `name`, `link_image`, `link_video`, `link_sound`, `delay`, `link`, `popup_type`, `toast_text`) VALUES
(4, 'test with GIF only', 'https://78.media.tumblr.com/fec5fd45e289e590cd90a146c1f05252/tumblr_mxbnijw7W01qfr6udo1_400.gif', 'none', 'none', 10, 'none', 1, NULL),
(7, 'Sound and Image', 'https://78.media.tumblr.com/fec5fd45e289e590cd90a146c1f05252/tumblr_mxbnijw7W01qfr6udo1_400.gif', 'none', 'https://www.mediacollege.com/downloads/sound-effects/nature/forest/rainforest-ambient.wav', 10000, 'none', 1, NULL),
(10, 'Video with GIF', 'https://78.media.tumblr.com/fec5fd45e289e590cd90a146c1f05252/tumblr_mxbnijw7W01qfr6udo1_400.gif', 'https://sample-videos.com/video/mp4/720/big_buck_bunny_720p_1mb.mp4', 'none', 40, 'none', 1, NULL),
(13, 'Test with JPEG', 'http://notgoaway.com/wp-content/uploads/2017/07/Fun-Wallpaper-6E.jpg', 'none', 'none', 10, 'none', 1, NULL),
(16, 'PNG-Example', 'http://people.sc.fsu.edu/~jburkardt/data/png/apollonian_gasket.png', 'none', 'none', 10, 'none', 1, NULL),
(19, 'MP3-Sound', 'https://media.giphy.com/media/l4hLwMmFVBOAKF3EI/giphy.gif', 'none', 'http://www.orangefreesounds.com/wp-content/uploads/2018/06/Bell-ding-sound-effect.mp3', 10, 'none', 1, NULL),
(22, 'Video with GIF', 'https://78.media.tumblr.com/fec5fd45e289e590cd90a146c1f05252/tumblr_mxbnijw7W01qfr6udo1_400.gif', 'https://static.videezy.com/system/resources/previews/000/000/614/original/Xplosion.mp4', 'none', 10, 'none', 1, NULL),
(28, 'Consecutive login - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_cl_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(29, 'Consecutive login - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_cl_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(30, 'Consecutive login - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_cl_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(31, 'Consecutive login - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_cl_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(32, 'Consecutive login - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_cl_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(33, 'Consecutive login - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_cl_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(34, 'Overall Login - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_ld_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(35, 'Overall Login - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_ld_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(36, 'Overall Login - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_ld_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(37, 'Overall Login - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_ld_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(38, 'Overall Login - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_ld_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(39, 'Overall Login - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_ld_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(40, 'Batteries - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_ba_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(41, 'Batteries - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_ba_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(42, 'Batteries - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_ba_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(43, 'Batteries - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_ba_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(44, 'Batteries - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_ba_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(45, 'Batteries - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_ba_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(46, 'E-Waste - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_ew_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(47, 'E-Waste - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_ew_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(48, 'E-Waste - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_ew_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(49, 'E-Waste - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_ew_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(50, 'E-Waste - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_ew_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(51, 'E-Waste - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_ew_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(52, 'TetraPak - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_tp_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(53, 'TetraPak - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_tp_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(54, 'TetraPak - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_tp_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(55, 'TetraPak - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_tp_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(56, 'TetraPak - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_tp_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(57, 'TetraPak - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_tp_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(58, 'Plastic - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_pl_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(59, 'Plastic - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_pl_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(60, 'Plastic - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_pl_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(61, 'Plastic - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_pl_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(62, 'Plastic - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_pl_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(63, 'Plastic - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_pl_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(64, 'Metal - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_me_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(65, 'Metal - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_me_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(66, 'Metal - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_me_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(67, 'Metal - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_me_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(68, 'Metal - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_me_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(69, 'Metal - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_me_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(70, 'Paper - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_pa_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(71, 'Paper - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_pa_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(72, 'Paper - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_pa_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(73, 'Paper - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_pa_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(74, 'Paper - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_pa_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(75, 'Paper - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_pa_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(76, 'Glass - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_gl_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(77, 'Glass - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_gl_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(78, 'Glass - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_gl_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(79, 'Glass - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_gl_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(80, 'Glass - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_gl_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(81, 'Glass - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_gl_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(82, 'Cleanuminati Event - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_clean_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(83, 'Cleanuminati Event - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_clean_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(84, 'Cleanuminati Event - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_clean_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(85, 'Cleanuminati Event - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_clean_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(86, 'Cleanuminati Event - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_clean_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(87, 'Cleanuminati Event - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_clean_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(88, 'Trashspotters - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_trspot_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(89, 'Trashspotters - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_trspot_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(90, 'Trashspotters - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_trspot_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(91, 'Trashspotters - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_trspot_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(92, 'Trashspotters - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_trspot_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(93, 'Trashspotters - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_trspot_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(94, 'New Products - English - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_np_en_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(95, 'New Products - English - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_np_en_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(96, 'New Products - English - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_np_en_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(97, 'New Products - German - Bronze', 'https://app-test.earthsquad.global/image/nginx_static/popup_np_de_bronze.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(98, 'New Products - German - Silver', 'https://app-test.earthsquad.global/image/nginx_static/popup_np_de_silver.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(99, 'New Products - German - Golden', 'https://app-test.earthsquad.global/image/nginx_static/popup_np_de_golden.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(101, 'Daily popup', 'None', 'None', 'None', 600, 'None', 5, NULL),
(102, 'First login - English', 'https://app-test.earthsquad.global/image/nginx_static/popup_fl_en.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!'),
(103, 'First login - German', 'https://app-test.earthsquad.global/image/nginx_static/popup_fl_de.jpg', 'none', 'none', 600, 'none', 1, 'Badge earned!');

INSERT INTO `scanapp_fixedbom` (`id`, `weight`, `product_type_id`, `product_type_bom_id`) VALUES
(4, 0.033, 10, 4),
(7, 0.043, 28, 7),
(10, 0.045, 28, 10),
(13, 0.025, 28, 13),
(16, 0.055, 40, 16),
(19, 0.1, 40, 19),
(22, 0.15, 28, 22),
(28, 0.034, 10, 28),
(29, 0.025, 22, 29),
(30, 0.002, 22, 30);


INSERT INTO `scanapp_badgetype` (`id`, `name`, `calculation_type`, `lvl_001`, `lvl_002`, `lvl_003`, `lvl_004`, `lvl_005`, `product_type_id`) VALUES
(1, 'FL', 99, 1, 99, 99, 99, 99, NULL),
(2, 'CL', 3, 7, 30, 90, 365, 0, NULL),
(3, 'LD', 2, 30, 90, 365, 1200, 0, NULL),
(4, 'BA', 1, 10, 100, 500, 2000, 0, 22),
(5, 'EW', 1, 10, 100, 500, 2000, 0, 19),
(6, 'PL', 1, 100, 1000, 3000, 9000, 0, 25),
(7, 'ME', 1, 100, 1000, 3000, 9000, 0, 31),
(8, 'PA', 1, 100, 1000, 3000, 9000, 0, 16),
(9, 'GL', 1, 100, 1000, 3000, 9000, 0, 40),
(10, 'ES', 4, 1, 3, 8, 20, 0, NULL),
(11, 'TD', 5, 1, 3, 8, 20, 0, NULL),
(12, 'NE', 6, 10, 50, 300, 1000, 0, NULL),
(13, 'TP', 1, 100, 1000, 3000, 9000, 0, 67);

INSERT INTO `scanapp_badgetypelevel` (`id`, `badge_type_id`, `level_name`) VALUES
(5, 1, 'bronze'),
(7, 2, 'silver'),
(8, 2, 'golden'),
(9, 2, 'diamond'),
(10, 3, 'bronze'),
(11, 3, 'silver'),
(12, 3, 'golden'),
(14, 2, 'bronze'),
(15, 3, 'diamond'),
(16, 4, 'bronze'),
(17, 4, 'silver'),
(18, 4, 'golden'),
(19, 4, 'diamond'),
(20, 5, 'bronze'),
(21, 5, 'silver'),
(22, 5, 'golden'),
(23, 5, 'diamond'),
(24, 6, 'bronze'),
(25, 6, 'silver'),
(26, 6, 'golden'),
(27, 6, 'diamond'),
(28, 7, 'bronze'),
(29, 7, 'silver'),
(30, 7, 'golden'),
(31, 7, 'diamond'),
(32, 8, 'bronze'),
(33, 8, 'silver'),
(34, 8, 'golden'),
(35, 8, 'diamond'),
(36, 9, 'bronze'),
(37, 9, 'silver'),
(38, 9, 'golden'),
(39, 9, 'diamond'),
(40, 10, 'bronze'),
(41, 10, 'silver'),
(42, 10, 'golden'),
(43, 10, 'diamond'),
(44, 11, 'bronze'),
(45, 11, 'silver'),
(46, 11, 'golden'),
(47, 11, 'diamond'),
(48, 12, 'bronze'),
(49, 12, 'silver'),
(50, 12, 'golden'),
(51, 12, 'diamond'),
(52, 13, 'bronze'),
(53, 13, 'silver'),
(54, 13, 'golden'),
(55, 13, 'diamond');

INSERT INTO `scanapp_badgetypeleveltext` (`id`, `name_short`, `name_long`, `image`, `badge_type_level_id`, `language_id`, `popup_id`, `image_zoom`) VALUES
(19, 'Batteries Diamond', 'Batteries Diamond', 'badge_ba_diamond.gif', 19, 4, 4, 'badge_ba_diamond.gif'),
(13, '365 cons. days!', '365 days constant activtity!', 'badge_cl_diamond.gif', 9, 4, 4, 'badge_cl_diamond.gif'),
(39, 'E-Waste Diamond', 'E-Waste Diamond', 'badge_ew_diamond.gif', 23, 4, 4, 'badge_ew_diamond.gif'),
(28, 'Glass Diamond', 'Glass Badge Diamond', 'badge_gl_diamond.gif', 39, 4, 4, 'badge_gl_diamond.gif'),
(16, '1200 days!', '1200 days activity', 'badge_ld_diamond.gif', 15, 4, 4, 'badge_ld_diamond.gif'),
(25, 'Metal Diamond', 'Metal Badge Diamond', 'badge_me_diamond.gif', 31, 4, 4, 'badge_me_diamond.gif'),
(35, 'New Products King', 'New Products scout - Diamond!', 'badge_np_diamond.gif', 51, 4, 4, 'badge_np_diamond.gif'),
(42, 'Paper diamond', 'Paper Diamon Badge', 'badge_pa_diamond.gif', 35, 4, 4, 'badge_pa_diamond.gif'),
(22, 'Plastics Diamond', 'Plastics recycling Badge Diamond', 'badge_pl_diamond.gif', 27, 4, 4, 'badge_pl_diamond.gif'),
(32, 'Tetra Pak Diamond', 'Tetra Pak Diamond', 'badge_tp_diamond.gif', 55, 4, 4, 'badge_tp_diamond.gif'),
(4, 'Batteries Bronze', 'Batteries Bronze', 'badge_ba_bronze.png', 16, 4, 40, 'popup_ba_en_bronze.jpg'),
(18, 'Batteries Golden', 'Batteries Golden', 'badge_ba_golden.png', 18, 4, 42, 'popup_ba_en_golden.jpg'),
(17, 'Batteries Silver', 'Batteries Silver', 'badge_ba_silver.png', 17, 4, 41, 'popup_ba_en_silver.jpg'),
(2, '7 cons days!', '7 consecutive days of login!', 'badge_cl_bronze.png', 14, 4, 28, 'popup_cl_en_bronze.jpg'),
(12, '90 cons. days!', '90 days constant activtity!', 'badge_cl_golden.png', 8, 4, 30, 'popup_cl_en_golden.jpg'),
(11, '30 cons. days!', '30 days constant activtity!', 'badge_cl_silver.png', 7, 4, 29, 'popup_cl_en_silver.jpg'),
(36, 'E-Waste Bronze', 'E-Waste Bronze', 'badge_ew_bronze.png', 20, 4, 46, 'popup_ew_en_bronze.jpg'),
(38, 'E-Waste Golden', 'E-Waste Golden', 'badge_ew_golden.png', 22, 4, 48, 'popup_ew_en_golden.png'),
(37, 'E-Waste Silver', 'E-Waste Silver', 'badge_ew_silver.png', 21, 4, 47, 'popup_ew_en_silver.jpg'),
(0, 'First Login!', 'Welcome to EarthSquad!', 'badge_fl.png', 5, 4, 102, 'popup_fl_en.jpg'),
(9, 'Glass Bronze', 'Glass Badge Bronze', 'badge_gl_bronze.png', 36, 4, 76, 'popup_gl_en_bronze.jpg'),
(27, 'Glass Golden', 'Glass Badge Golden', 'badge_gl_golden.png', 38, 4, 78, 'popup_gl_en_golden.jpg'),
(26, 'Glass Silver', 'Glass Badge Silver', 'badge_gl_silver.png', 37, 4, 77, 'popup_gl_en_silver.jpg'),
(3, 'Login Day Bronze', 'Login Days Bronze achieved!', 'badge_ld_bronze.png', 10, 4, 34, 'popup_ld_en_bronze.jpg'),
(15, '365 days!', '365 days activity', 'badge_ld_golden.png', 12, 4, 36, 'popup_ld_en_golden.jpg'),
(14, '90 days!', '90 days activity', 'badge_ld_silver.png', 11, 4, 35, 'popup_ld_en_silver.jpg'),
(7, 'Metal Bronze', 'Metal Badge Bronze', 'badge_me_bronze.png', 28, 4, 64, 'popup_me_en_bronze.jpg'),
(24, 'Metal Golden', 'Metal Badge Golden', 'badge_me_golden.png', 30, 4, 66, 'popup_me_en_golden.jpg'),
(23, 'Metal Silver', 'Metal Badge Silver', 'badge_me_silver.png', 29, 4, 65, 'popup_me_en_silver.jpg'),
(10, 'New Products created', 'New Products scout in Bronze', 'badge_np_bronze.png', 48, 4, 94, 'popup_np_en_bronze.jpg'),
(34, 'New Products created', 'New Products scout in Gold', 'badge_np_golden.png', 50, 4, 96, 'popup_np_en_golden.jpg'),
(33, 'New Products created', 'New Products scout in Silver', 'badge_np_silver.png', 49, 4, 95, 'popup_np_en_silver.jpg'),
(8, 'Paper bronze', 'Paper Bronze Badge', 'badge_pa_bronze.png', 32, 4, 70, 'popup_pa_en_bronze.jpg'),
(40, 'Paper Silver', 'Paper Silver Badge', 'badge_pa_silver.png', 33, 4, 71, 'popup_pa_en_bronze.jpg'),
(41, 'Paper golden', 'Paper Golden Badge', 'badge_pa_golden.png', 34, 4, 72, 'popup_pa_en_golden.jpg'),
(6, 'Plastics Bronze', 'Plastics recycling Badge Bronze', 'badge_pl_bronze.png', 24, 4, 58, 'popup_pl_en_bronze.jpg'),
(21, 'Plastics Golden', 'Plastics recycling Badge Golden', 'badge_pl_golden.png', 26, 4, 60, 'popup_pl_en_golden.jpg'),
(20, 'Plastics Silver', 'Plastics recycling Badge Silver', 'badge_pl_silver.png', 25, 4, 59, 'popup_pl_en_silver.jpg'),
(29, 'Tetra Pak Bronze', 'Tetra Pak Bronze', 'badge_tp_bronze.png', 52, 4, 52, 'popup_tp_en_bronze.jpg'),
(31, 'Tetra Pak Golden', 'Tetra Pak Golden', 'badge_tp_golden.png', 54, 4, 54, 'popup_tp_en_golden.jpg'),
(30, 'Tetra Pak Silver', 'Tetra Pak Silver', 'badge_tp_silver.png', 53, 4, 53, 'popup_tp_en_silver.jpg');

INSERT INTO `scanapp_badgetypetext` (`id`, `name_short`, `name_long`, `badge_type_id`, `language_id`) VALUES
(1, 'Welcome!', 'Welcome first login!', 1, 4),
(2, 'Cons.Login', 'Consequitive Login Days Challenge', 2, 4),
(3, 'Login Days', 'Login Days Challenge', 3, 4),
(4, 'Batteries', 'Batteries', 4, 4),
(5, 'E-Waste', 'E-Waste Badge', 5, 4),
(6, 'Plastics', 'Plastics recycling Badge', 6, 4),
(7, 'Metal', 'Metal Badge', 7, 4),
(8, 'Glass', 'Glass Badge', 9, 4),
(9, 'Cleanuminati', 'Cleanuminati Events', 10, 4),
(10, 'Trashspotter!', 'Trashspotter Badge', 11, 4),
(11, 'New Products', 'New Products scout', 12, 4),
(12, 'Tetra Pak', 'Tetra Pak', 13, 4),
(13, 'Paper', 'Paper', 8, 4);


INSERT INTO `scanapp_producttype` (`id`, `is_packaging_material`, `icon`, `deleted`, `name`, `lvl_001`, `lvl_002`, `lvl_003`, `lvl_004`, `lvl_005`) VALUES
(1, 0, 'static/drops.png', 0, 'Product Types', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(2, 1, 'icon_glass', 0, 'Recycling Materials', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(10, 1, 'icon_metall', 0, 'Aluminium', '0.002173', '0.000960', '0.000000', '0.003867', '0.000000'),
(13, 1, 'biod', 0, 'Biodegradable', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(16, 1, 'paper', 0, 'Paper and Cardboard', '0.003375', '0.000477', '0.000001', '0.004825', '0.000000'),
(19, 1, 'icon_div', 0, 'E-Waste', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(22, 1, 'icon_battery', 0, 'Batteries', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(25, 1, 'plastic', 0, 'Plastic', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(28, 1, 'PET', 0, 'PET-Plastic', '0.001520', '0.002280', '0.000000', '0.001044', '0.000000'),
(31, 1, 'icon_metal', 0, 'Metal', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(34, 1, 'Wood', 0, 'Wood', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(37, 1, 'Tires', 0, 'Tires', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(40, 1, 'glass', 0, 'Glass', '0.000105', '0.000735', '0.000000', '0.000455', '0.000000'),
(43, 1, 'nores-plastic', 0, 'Waste (non-recyclable)', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(46, 0, 'icon_dummy', 0, 'PET 0,5l', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(49, 0, 'icon_dummy', 0, 'PET 1,0l', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(52, 0, 'icon_dummy', 0, 'PET 1,5l', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(55, 0, 'icon_dummy', 0, 'beer 0,33l', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(58, 0, 'icon_dummy', 0, 'beer 0,5l', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(61, 0, 'icon_dummy', 0, 'glass bottle 0,5l', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(64, 0, 'icon_dummy', 0, 'glass bottle 1,0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(65, 0, 'icon_dummy', 0, 'Battery AA', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(66, 0, 'icon_dummy', 0, 'Battery AAA', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000'),
(67, 1, 'icon_div', 0, 'Tetra Pack', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000');


INSERT INTO `scanapp_producttypebom` (`id`, `created_at`, `updated_at`, `product_type_id`) VALUES
(4, '2018-06-22 13:49:00.599002', '2018-07-12 06:30:11.116771', 55),
(7, '2018-06-22 13:49:16.342903', '2018-07-12 06:29:54.576937', 52),
(10, '2018-06-22 13:49:33.956186', '2018-07-12 06:29:38.152841', 49),
(13, '2018-06-22 13:49:52.813425', '2018-07-12 06:29:19.656163', 49),
(16, '2018-06-22 13:50:07.079450', '2018-07-12 15:54:57.977940', 64),
(19, '2018-06-22 13:50:28.545773', '2018-07-12 15:54:21.809192', 61),
(22, '2018-06-22 13:50:48.039702', '2018-07-12 06:29:01.240854', 46),
(28, '2018-07-12 06:30:36.225361', '2018-07-12 15:54:11.776823', 58),
(29, '2018-08-05 13:50:48.039702', '2018-08-05 13:50:48.039702', 66),
(30, '2018-08-05 13:50:48.039702', '2018-08-05 13:50:48.039702', 65);



INSERT INTO `scanapp_producttypehier` (`id`, `child_id`, `parent_id`) VALUES
(4, 13, 2),
(10, 10, 31),
(16, 16, 2),
(19, 19, 2),
(22, 22, 2),
(25, 25, 2),
(28, 28, 25),
(31, 31, 2),
(34, 34, 2),
(37, 37, 2),
(40, 40, 2),
(43, 43, 2),
(46, 46, 1),
(49, 49, 1),
(52, 52, 1),
(55, 55, 1),
(58, 58, 1),
(64, 61, 1),
(67, 64, 1),
(68, 65, 1),
(69, 66, 1),
(70, 67, 2);


INSERT INTO `scanapp_producttypetranslation` (`id`, `translation`, `language_id`, `word_id_id`) VALUES
(4, 'Standard Products', 4, 1),
(7, 'Recycling Materials', 4, 2),
(10, 'Aluminium', 4, 10),
(13, 'Biodegradable', 4, 13),
(16, 'Paper and Cardboard', 4, 16),
(19, 'E-Waste', 4, 19),
(22, 'Batteries', 4, 22),
(25, 'Plastic', 4, 25),
(28, 'PET-Plastic', 4, 28),
(31, 'Metal', 4, 31),
(34, 'Wood', 4, 34),
(37, 'Tires', 4, 37),
(40, 'Glass', 4, 40),
(43, 'Waste (non-recyclable)', 4, 43),
(46, 'PET 0,5l', 4, 46),
(49, 'PET 1,0l', 4, 49),
(52, 'PET 1,5l', 4, 52),
(55, 'Aluminium can 0,33l', 4, 55),
(58, 'Aluminium can 0,5l', 4, 58),
(61, 'Glas bottle 0,5l', 4, 61),
(64, 'Glas bottle 1,0l', 4, 64),
(65, 'Battery AA', 4, 65),
(66, 'Battery AAA', 4, 66),
(67, 'Tetra Pack', 4, 67);





SET FOREIGN_KEY_CHECKS=1;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;