123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456 |
- 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 */;
|