API tools faq
paste
Advertisement
qlixes

data dumy gfapps

qlixes
Jan 29th, 2020
422
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.58 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO `brands` (`id`, `index_id`, `brand_nama`, `brand_banner`, `brand_thumbnail`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
  2. (1, 1,'Garudafood', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL),
  3. (2, 2,'Garuda', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL),
  4. (3, 3,'Gery', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL),
  5. (4, 4,'Gery Saluut', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL),
  6. (5, 5,'Chocolatos', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL),
  7. (6, 6,'Leo', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL),
  8. (7, 7,'Clevo', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL),
  9. (8, 8,'Warkop', 'noimage.jpg', 'noimage.jpg', 1, NULL, NULL, NULL);
  10.  
  11. INSERT INTO `subbrands` (`id`, `brand_id`, `index_id`, `subbrand_nama`, `subbrand_banner`, `subbrand_thumbnail`, `subbrand_level`, `is_active`, `subbrand_parent`, `created_at`, `updated_at`, `deleted_at`) VALUES
  12. (1, 1, 3,'Lokasi Produksi', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  13. (2, 1, 4,'Corporate Logo', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  14. (3, 1, 5,'Info lengkap', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  15. (4, 2, 3,'Pilus Garuda', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  16. (5, 2, 4,'Garuda Ting-Ting', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  17. (6, 2, 5,'Garuda TVC', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  18. (7, 3, 1,'Snack Sereal Wafer', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  19. (8, 3, 2,'Snack Sereal Extrude', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  20. (9, 3, 3,'Pasta', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  21. (10, 3, 4,'Meises', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  22. (11, 3, 5,'Bischoc', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  23. (12, 3, 6,'Kreker Beras', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  24. (13, 3, 7,'Festive', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  25. (14, 3, 8,'Malkist', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  26. (15, 3, 9,'Snack Extrude Ring', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  27. (16, 3, 10,'Hollanda', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  28. (17, 3, 11,'Gery TVC', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  29. (42, 2, 1,'Garuda Roasted Peanut', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  30. (43, 2, 2,'Garuda Coasted Peanut', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  31. (50, 1, 1,'Garudafood core values', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  32. (51, 1, 2,'Mentalitas dasar dan ciri pempimpin', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  33. (57, 5, 1,'Chocolatos RTD', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  34. (58, 5, 2,'Wafer Cream', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  35. (18, 2, 1,'Garuda Kacang Kulit Original', 'noimage.jpg', 'noimage.jpg', 2, 1, 42, NULL, NULL, NULL),
  36. (19, 2, 2,'Garuda Kacang Kulit Rasa', 'noimage.jpg', 'noimage.jpg', 2, 1, 42, NULL, NULL, NULL),
  37. (20, 2, 3,'Garuda BIGA', 'noimage.jpg', 'noimage.jpg', 2, 1, 42, NULL, NULL, NULL),
  38. (21, 2, 1,'Kacang Kulit Original Premium', 'noimage.jpg', 'noimage.jpg', 3, 1, 18, NULL, NULL, NULL),
  39. (22, 2, 2,'Kacang Kulit Original Semi', 'noimage.jpg', 'noimage.jpg', 3, 1, 18, NULL, NULL, NULL),
  40. (59, 5, 3,'TVC terbaru chocolatos', 'noimage.jpg', 'noimage.jpg', 1, 1, NULL, NULL, NULL, NULL),
  41. (60, 5, 1,'Chocolatos Original', 'noimage.jpg', 'noimage.jpg', 2, 1, 57, NULL, NULL, NULL),
  42. (61, 5, 2,'Chocolatos Tetrapak', 'noimage.jpg', 'noimage.jpg', 2, 1, 57, NULL, NULL, NULL);
  43.  
  44. insert into products(subbrand_id, index_id, product_year, product_deskripsi, product_description, product_nama, product_thumbnail) values
  45. (21, 1,2018, 'testing Indonesia', 'testing English','Garuda Kacang Kulit Original (GA)','noimage.jpg' ),
  46. (21, 2,2018, 'testing Indonesia', 'testing English','Garuda Kacang Kulit Original (GB)','noimage.jpg' ),
  47. (21, 3,2018, 'testing Indonesia', 'testing English','Garuda Kacang Kulit Original (GC)','noimage.jpg' ),
  48. (21, 4,2018, 'testing Indonesia', 'testing English','Garuda Kacang Kulit Original (GC2)','noimage.jpg' ),
  49. (21, 5,2018, 'testing Indonesia', 'testing English','Garuda Kacang Kulit Original (GD1)','noimage.jpg' ),
  50. (21, 6,2018, 'testing Indonesia', 'testing English','Garuda Kacang Kulit Original (GD3)','noimage.jpg');
  51.  
  52. insert into products(subbrand_id, index_id, product_year, product_deskripsi, product_description, product_nama, product_thumbnail, is_continue) values
  53. (21, 7,2018, 'testing Indonesia', 'testing English','Garuda Kacang Kulit Original (G2)','noimage.jpg',  false);
  54.  
  55. insert into images(product_id, index_id, image_name, imagehd_name) values
  56. (1, 1, 'noimage.jpg','imagehd1'),
  57. (1, 2, 'noimage.jpg','imagehd2'),
  58. (1, 3, 'noimage.jpg','imagehd3'),
  59. (1, 4, 'noimage.jpg','imagehd4'),
  60. (1, 5, 'noimage.jpg','imagehd5'),
  61. (1, 6, 'noimage.jpg','imagehd6');
  62.  
  63. insert into playlists(subbrand_id, playlist_year, playlist_url) values (42, 2018, 'https://www.youtube.com/playlist?list=PLl_xaLX85BGsNNS7Fz90yMVR8RqfiZH8X');
  64.  
  65. INSERT INTO `subbrands` (`id`, `brand_id`, `index_id`, `subbrand_nama`, `subbrand_banner`, `subbrand_thumbnail`, `subbrand_level`, `is_active`, `subbrand_parent`) VALUES
  66. (62, 6, 1, 'Leo Casava Chips', 'noimage.jpg','noimage.jpg', 1, false, null),
  67. (63, 6, 2, 'Leo Crisps', 'noimage.jpg','noimage.jpg', 1, true, null),
  68. (64, 6, 3, 'Leo Pop Corn', 'noimage.jpg','noimage.jpg', 1, true, null),
  69. (65, 6, 4, 'TVC Terbaru Leo', 'noimage.jpg','noimage.jpg', 1, true, null),
  70. (66, 6, 1, 'Leo Cassava Chips Rasa Ayam Lada Hitam', 'noimage.jpg','noimage.jpg', 2, false, 62),
  71. (67, 6, 1, 'Leo Cassava Chips Rasa Ayam Bawang', 'noimage.jpg','noimage.jpg', 2, false, 62),
  72. (68, 6, 1, 'Leo Cassava Chips Rasa Ayam Lada Hitam 1', 'noimage.jpg','noimage.jpg', 3, false, 66),
  73. (69, 6, 1, 'Leo Cassava Chips Rasa Ayam Bawang 1', 'noimage.jpg','noimage.jpg', 3, false, 67),
  74. (70, 6, 1, 'Leo Cassava Chips Rasa Ayam Lada Hitam 2', 'noimage.jpg','noimage.jpg', 4, false, 68),
  75. (71, 6, 1, 'Leo Cassava Chips Rasa Ayam Bawang 2', 'noimage.jpg','noimage.jpg', 4, false, 69),
  76. (72, 6, 1, 'Leo Cassava Chips Rasa Ayam Lada Hitam 3', 'noimage.jpg','noimage.jpg', 5, false, 70),
  77. (73, 6, 1, 'Leo Cassava Chips Rasa Ayam Bawang 3', 'noimage.jpg','noimage.jpg', 5, false, 71);
  78.  
  79. insert into products(index_id, subbrand_id, product_year, product_nama, product_thumbnail, product_deskripsi, product_description, product_marker, product_version, is_continue) values
  80. (1, 72, 2018, 'Leo Casava Chips Rasa Ayam Lada Hitam (LSCD)', 'noimage.jpg',  'Leo Casava Chips Rasa Ayam Lada Hitam', 'Leo Casava with Black Pepper Chicken', null, 1, true),
  81. (1, 72, 2019, 'Leo Casava Chips Rasa Ayam Lada Hitam (LSCD)', 'noimage.jpg', 'Leo Casava Chips Rasa Ayam Lada Hitam', 'Leo Casava with Black Pepper Chicken', null, 2, true),
  82. (1, 73, 2018, 'Leo Casava Chips Rasa Ayam Bawang (LSAD)', 'noimage.jpg', 'Leo Casava Chips Rasa Ayam Lada Hitam', 'Leo Casava with Black Pepper Chicken', null, 1, true),
  83. (1, 73, 2019, 'Leo Casava Chips Rasa Ayam Bawang (LSAD)', 'noimage.jpg', 'Leo Casava Chips Rasa Ayam Lada Hitam', 'Leo Casava with Black Pepper Chicken', null, 2, true);
  84.  
  85. insert into images(index_id, product_id, image_version, image_name, imagehd_name, is_active) values
  86. (1,8, 1, 'noimage.jpg', 'imagehd01', true),
  87. (2,8, 1, 'noimage.jpg', 'imagehd01', true),
  88. (3,8, 1, 'noimage.jpg', 'imagehd01', false),
  89. (1,9, 1, 'noimage.jpg', 'imagehd01', true),
  90. (2,9, 1, 'noimage.jpg', 'imagehd01', true),
  91. (3,9, 1, 'noimage.jpg', 'imagehd01', true),
  92. (1,10, 1, 'noimage.jpg', 'imagehd01', true),
  93. (2,10, 1, 'noimage.jpg', 'imagehd01', true),
  94. (3,10, 1, 'noimage.jpg', 'imagehd01', true),
  95. (1,11, 1, 'noimage.jpg', 'imagehd01', true),
  96. (2,11, 1, 'noimage.jpg', 'imagehd01', true),
  97. (3,11, 1, 'noimage.jpg', 'imagehd01', false),
  98. (1,8, 2, 'noimage.jpg', 'imagehd01', true),
  99. (2,8, 2, 'noimage.jpg', 'imagehd01', true),
  100. (3,8, 2, 'noimage.jpg', 'imagehd01', true);
  101.  
  102. update subbrands set is_tvc = true where id = 6;
  103. update subbrands set is_tvc = true where id = 17;
  104. update subbrands set is_tvc = true where id = 59;
  105. update subbrands set is_tvc = true where id = 65;
  106.  
  107. update brands set updated_at = now();
  108. update subbrands set updated_at = now();
  109. update products set updated_at = now();
  110. update playlists set updated_at = now();
  111. update playlist2 set updated_at = now();
  112. update images set updated_at = now();
  113.  
  114. insert into playlists(subbrand_id, playlist_year, playlist_url) values
  115. (65, 2018, 'https://www.youtube.com/playlist?list=PL4cUxeGkcC9jLYyp2Aoh6hcWuxFDX6PBJ');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!