-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.30 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table affy.instagram_lives
CREATE TABLE IF NOT EXISTS `instagram_lives` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `instagramUID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ig_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `like_count` int NOT NULL,
  `media_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `media_url` text COLLATE utf8mb4_unicode_ci,
  `permalink` text COLLATE utf8mb4_unicode_ci,
  `thumbnail_url` text COLLATE utf8mb4_unicode_ci,
  `timestamp` datetime NOT NULL,
  `media_product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caption` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table affy.instagram_lives: ~4 rows (approximately)
/*!40000 ALTER TABLE `instagram_lives` DISABLE KEYS */;
REPLACE INTO `instagram_lives` (`id`, `instagramUID`, `video_id`, `ig_id`, `like_count`, `media_type`, `media_url`, `permalink`, `thumbnail_url`, `timestamp`, `media_product_type`, `caption`, `created_at`, `updated_at`) VALUES
	(1, '17841444918594249', '17989994089615029', '2968485761509192581', 0, 'VIDEO', 'https://video.cdninstagram.com/v/t50.16885-16/312315596_795572484861895_1675817565038002948_n.mp4?_nc_cat=110&vs=842951063416612_229677970&_nc_vs=HBkcFQAYJEdNeU9uUkxIYjFxbmtkTUNBQVJEYzFBeXMwRVhidlZCQUFBRhUAAsgBACgAGAAbAYgHdXNlX29pbAExFQAAJtC1gubW4%2FI%2FFQIoAkMzLBdALgAAAAAAABgSZGFzaF9iYXNlbGluZV8xX3YxEQB17AcA&ccb=1-7&_nc_sid=59939d&efg=eyJ2ZW5jb2RlX3RhZyI6InZ0c192b2RfdXJsZ2VuLjcyMC5pZ3R2In0%3D&_nc_ohc=tCnn2OTqrzEAX-2JTJ-&_nc_ht=video.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfDs37NKN7h2xbwVIIYTP-2DqnJXbkzN4H35ozlE2WZ-og&oe=63742DC5&_nc_rid=20c17441e0', NULL, 'https://scontent.cdninstagram.com/v/t51.29350-15/314523001_6173854789311282_3666525672130956910_n.jpg?_nc_cat=111&ccb=1-7&_nc_sid=8ae9d6&_nc_ohc=bn-9yZSM9kgAX_x1QZg&_nc_ht=scontent.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfCrbLbztrpkZbUJuu2Zq6PQOO-Amqmg8NxqKky8Fh9LFQ&oe=637820FE', '2022-11-10 14:39:21', 'FEED', 'Teste de video Reels?', '2022-11-15 15:38:09', '2022-11-15 15:38:09'),
	(2, '17841444918594249', '17987437465517759', '2911968671554217149', 0, 'VIDEO', 'https://video.cdninstagram.com/v/t50.33184-16/10000000_173845631821100_3649907267438421471_n.mp4?_nc_cat=100&vs=18103908205290454_1452895966&_nc_vs=HBksFQAYJEdJQ1dtQUFzWlNHWEhKNEFBTl9seUZwU0U2Y3licUNCQUFBRhUAAsgBABUAGCRHRFBiOEJIS2lSY3c4ZDBDQVBCRWRPQk93VmM5YnFDQkFBQUYVAgLIAQAoABgAGwGIB3VzZV9vaWwBMRUAACbqjo6%2F7qTlPxUCKAJDMywXQKj18i0OVgQYEmRhc2hfYmFzZWxpbmVfM192MREAdewHAA%3D%3D&ccb=1-7&_nc_sid=59939d&efg=eyJ2ZW5jb2RlX3RhZyI6InZ0c192b2RfdXJsZ2VuLjQzMi5pZ3R2In0%3D&_nc_ohc=YQuWgpCyVPAAX9rPTZ5&_nc_ht=video.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfCCE4EqDefHR9DvM-B91RNwpTtFKj-0yATF45LYtYoypg&oe=637443EB&_nc_rid=1c138b33af', NULL, 'https://scontent.cdninstagram.com/v/t51.29350-15/301212402_785701975795555_1554640604342933654_n.jpg?_nc_cat=101&ccb=1-7&_nc_sid=8ae9d6&_nc_ohc=OxkKKL1RyhYAX-ceRAt&_nc_ht=scontent.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfCwwHcYuHjoUU0i6Pc_mRgwT6_oBtWU0bUBZGBD39SgjQ&oe=63791700', '2022-08-24 15:09:40', 'FEED', '', '2022-11-15 15:40:46', '2022-11-15 15:40:46'),
	(3, '17841444918594249', '17968268584790527', '2911472739968559349', 0, 'VIDEO', 'https://video.cdninstagram.com/v/t50.33184-16/10000000_127553879804215_1457854056884770620_n.mp4?_nc_cat=105&vs=17905236620545978_936381462&_nc_vs=HBksFQAYJEdJQ1dtQUEzQ2JKekFuUUFBRHlYX21xS1Zqc1VicUNCQUFBRhUAAsgBABUAGCRHTDVYX0JHd1ZuNFhqYUlEQUVwTTNvdU0wazVfYnFDQkFBQUYVAgLIAQAoABgAGwGIB3VzZV9vaWwBMRUAACaS66Or8cO2PxUCKAJDMywXQJcjvGp%2B%2BdsYEmRhc2hfYmFzZWxpbmVfM192MREAdewHAA%3D%3D&ccb=1-7&_nc_sid=59939d&efg=eyJ2ZW5jb2RlX3RhZyI6InZ0c192b2RfdXJsZ2VuLjQzMi5pZ3R2In0%3D&_nc_ohc=-NDvEKC7DdEAX8DHVj4&_nc_ht=video.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfAeRoZ9Uhqj4lqdoSfyIxUu8EAT4Ndt6KI1EHkpnllP9Q&oe=63745A14&_nc_rid=b1aa4bdf94', NULL, 'https://scontent.cdninstagram.com/v/t51.29350-15/301002878_5552046444859775_7095838836743805874_n.jpg?_nc_cat=110&ccb=1-7&_nc_sid=8ae9d6&_nc_ohc=Bfm5vGlKogAAX8YvmhC&_nc_ht=scontent.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfAGFKLm7VR_kl-ZKxYZiJ3mlDoZSqiga2HIAI58WF2ueg&oe=6377FD5B', '2022-08-23 22:43:53', 'FEED', '', '2022-11-15 15:40:46', '2022-11-15 15:40:46'),
	(4, '17841444918594249', '18010816051443599', '2911423290147670877', 0, 'VIDEO', 'https://video.cdninstagram.com/v/t50.33184-16/10000000_1051447702198730_4106705172142765041_n.mp4?_nc_cat=109&vs=17869429154712378_431845293&_nc_vs=HBksFQAYJEdJQ1dtQURLR2NvX1Nid0RBUEV6MUlhWTh2MDRicUNCQUFBRhUAAsgBABUAGCRHTXRqMXhGTVZ6Tkxpck1DQUxOd01RVWFiNjFhYnFDQkFBQUYVAgLIAQAoABgAGwGIB3VzZV9vaWwBMRUAACaEtd%2BA5OCTQBUCKAJDMywXQJ3VYEGJN0wYEmRhc2hfYmFzZWxpbmVfM192MREAdewHAA%3D%3D&ccb=1-7&_nc_sid=59939d&efg=eyJ2ZW5jb2RlX3RhZyI6InZ0c192b2RfdXJsZ2VuLjQzMi5pZ3R2In0%3D&_nc_ohc=-4ZAL8yXd8oAX_7XQ0J&_nc_ht=video.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfDLe1avwe2s3StBJ7sBhH0DiBMk-95X4dehs6ukLOgVQQ&oe=63745226&_nc_rid=5906eb8791', NULL, 'https://scontent.cdninstagram.com/v/t51.29350-15/300866920_461393959258548_8817507654304230228_n.jpg?_nc_cat=109&ccb=1-7&_nc_sid=8ae9d6&_nc_ohc=mFkaXY2J7NoAX8LeREA&_nc_ht=scontent.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AfCeSsYzckQLiVl8RGI7SzbIVHylanPlwkT04kfHUov2RA&oe=63799AB6', '2022-08-23 21:05:42', 'FEED', '', '2022-11-15 15:40:46', '2022-11-15 15:40:46');
/*!40000 ALTER TABLE `instagram_lives` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
