-- MySQL dump 10.13  Distrib 5.7.33, for Win64 (x86_64)
--
-- Host: localhost    Database: sitemoderno
-- ------------------------------------------------------
-- Server version	5.5.5-10.6.5-MariaDB-log

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `ads`
--

DROP TABLE IF EXISTS `ads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Ads',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'footer',
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ads`
--

LOCK TABLES `ads` WRITE;
/*!40000 ALTER TABLE `ads` DISABLE KEYS */;
INSERT INTO `ads` VALUES (1,'Anúncio','','storage/img/ads/top/default.gif','top',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(2,'Anúncio','','storage/img/ads/side/default.gif','side',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,'Anúncio 1','','storage/img/ads/footer/default.jpg','footer',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(4,'Anúncio 2','','storage/img/ads/footer/default.jpg','footer',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(5,'Anúncio 3','','storage/img/ads/footer/default.jpg','footer',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(6,'Anúncio 4','','storage/img/ads/footer/default.jpg','footer',1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `ads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `colors`
--

DROP TABLE IF EXISTS `colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `colors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `primary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `primary_contrast` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secondary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secondary_contrast` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tertiary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tertiary_contrast` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_background` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_texts` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_titles` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `top_menu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `top_menu_selected` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `colors`
--

LOCK TABLES `colors` WRITE;
/*!40000 ALTER TABLE `colors` DISABLE KEYS */;
INSERT INTO `colors` VALUES (1,'#ffcc00','#121111','#ffffff','#171717','#ff8400','#ffcc00','#1d1b21','#9ba1ac','#ffffff','#ffffff','#ffcc00','2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `colors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emails`
--

DROP TABLE IF EXISTS `emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emails` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emails`
--

LOCK TABLES `emails` WRITE;
/*!40000 ALTER TABLE `emails` DISABLE KEYS */;
INSERT INTO `emails` VALUES (1,'Alexandre','contato@domain.com',1,NULL,NULL);
/*!40000 ALTER TABLE `emails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
INSERT INTO `events` VALUES (1,'Aniversário da Rádio','DIA: 24/01/2022 nosso aniversario com Atrações Incríveis a partir da 18:00 HS',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(2,'Programa especial','Neste Domingo em nosso estúdio AO VIVO não perca.',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,'Festival do Açai 2022','Este ano o Festival do Açai esta imperdivel com atrações nacionais fantasticas não Perca EM BREVE mais informações.',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(4,'NO AR','Quinta -Feira Entrevista com Prefeito de Feijó-Acre.',1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events_texts`
--

DROP TABLE IF EXISTS `events_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events_texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events_texts`
--

LOCK TABLES `events_texts` WRITE;
/*!40000 ALTER TABLE `events_texts` DISABLE KEYS */;
INSERT INTO `events_texts` VALUES (1,'<i class=\"fa fa-calendar\" aria-hidden=\"true\"></i> Eventos','Fique por dentro de nossa Agenda e não perca os melhores eventos da nossa Rádio.',NULL,NULL);
/*!40000 ALTER TABLE `events_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `layouts`
--

DROP TABLE IF EXISTS `layouts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `layouts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `layouts`
--

LOCK TABLES `layouts` WRITE;
/*!40000 ALTER TABLE `layouts` DISABLE KEYS */;
INSERT INTO `layouts` VALUES (1,'Ícone','favicon','Essa é o Ícone do rádio (500x100)','storage/img/layouts/2131326151651651651321.png',NULL,NULL),(2,'Logo início','header','Essa é a logo que aparece no todo do site (500x100)','storage/img/layouts/435644234693461332417.png',NULL,NULL),(3,'Logo do rodapé','footer','Essa é a logo que aparece no rodapé do site (500x100)','storage/img/layouts/2645187659446313322147365.png',NULL,NULL),(4,'Logo do gerenciador','footer','Essa é a logo que aparece no topo do gerenciador (500x100)','storage/img/layouts/56434654657426412772565485.png',NULL,NULL),(5,'Facebook','facebook','Essa é a logo do facebook (250x250)','storage/img/layouts/34320534134621055.png',NULL,NULL),(6,'Instagram','instagram','Essa é a logo do Instagram (250x250)','storage/img/layouts/3451633407343217.png',NULL,NULL),(7,'Whatsapp','whatsapp','Essa é a logo do Whatsapp (250x250)','storage/img/layouts/545103241230332712.png',NULL,NULL),(8,'Slide 1','slide','Esse é o primeiro slide que aparece no site (1920x1000)','storage/img/layouts/15213361381653281343218.jpg',NULL,NULL),(9,'Slide 2','slide','Esse é o segundo slide que aparece no site (1920x1000)','storage/img/layouts/56351463341732341731.jpg',NULL,NULL);
/*!40000 ALTER TABLE `layouts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menuses`
--

DROP TABLE IF EXISTS `menuses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menuses`
--

LOCK TABLES `menuses` WRITE;
/*!40000 ALTER TABLE `menuses` DISABLE KEYS */;
INSERT INTO `menuses` VALUES (1,'INICIO','header','/',1,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(2,'SOBRE','header','#sobre',2,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,'PROGRAMAÇÃO','header','#programacao',3,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(4,'EQUIPE','header','#equipe',4,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(5,'FOTOS','header','#galeria',5,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(6,'ENQUETE','header','#enquete',6,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(7,'BLOG','header','#blog',7,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(8,'CONTATO','header','#faleconosco',8,0,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(9,'SOBRE NÓS','footer','#',1,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(10,'PROGRAMAÇÃO','footer','#programacao',2,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(11,'FAQ','footer','#',3,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(12,'BLOG','footer','#blog',4,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(13,'CONTATO','footer','#',5,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(14,'OUTROS','footer','#',6,1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `menuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=595 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (568,'2014_10_12_100000_create_password_resets_table',1),(569,'2019_08_19_000000_create_failed_jobs_table',1),(570,'2019_12_14_000001_create_personal_access_tokens_table',1),(571,'2021_12_24_194142_create_users_table',1),(572,'2021_12_27_140756_create_posts_table',1),(573,'2021_12_27_170059_create_ads_table',1),(574,'2021_12_27_170526_create_emails_table',1),(575,'2021_12_27_170830_create_settings_table',1),(576,'2021_12_28_135047_create_menuses_table',1),(577,'2021_12_28_170507_create_colors_table',1),(578,'2021_12_28_192932_create_teams_table',1),(579,'2021_12_29_124443_create_schedules_table',1),(580,'2021_12_30_133319_create_streams_table',1),(581,'2021_12_30_181920_create_photos_table',1),(582,'2021_12_30_193435_create_polls_table',1),(583,'2021_12_30_194123_create_poll_options_table',1),(584,'2022_01_03_140410_create_post_categories_table',1),(585,'2022_01_03_161209_create_events_table',1),(586,'2022_01_03_175813_create_statistics_informations_table',1),(587,'2022_01_03_183355_create_layouts_table',1),(588,'2022_01_11_163739_create_schedule_texts_table',1),(589,'2022_01_11_164454_create_team_texts_table',1),(590,'2022_01_11_170904_create_photos_texts_table',1),(591,'2022_01_11_172721_create_polls_texts_table',1),(592,'2022_01_11_173237_create_events_texts_table',1),(593,'2022_01_11_175651_create_stream_texts_table',1),(594,'2022_01_11_181336_create_posts_texts_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_access_tokens`
--

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `photos`
--

DROP TABLE IF EXISTS `photos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `photos`
--

LOCK TABLES `photos` WRITE;
/*!40000 ALTER TABLE `photos` DISABLE KEYS */;
INSERT INTO `photos` VALUES (1,'Luan Santana','storage/img/photos/651231651232119478.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(2,'Gustavo Lima','storage/img/photos/164673654894634456815665154.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,'Zé Neto e Cristiano','storage/img/photos/23842344231322342316531.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(4,'Marilha Mendonça','storage/img/photos/49847456574546571451.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(5,'Gustavo Lima','storage/img/photos/86951786591678519678519657.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(6,'Bruno e Marrone','storage/img/photos/6165132198798498498.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `photos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `photos_texts`
--

DROP TABLE IF EXISTS `photos_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `photos_texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `photos_texts`
--

LOCK TABLES `photos_texts` WRITE;
/*!40000 ALTER TABLE `photos_texts` DISABLE KEYS */;
INSERT INTO `photos_texts` VALUES (1,'<i class=\"fa fa-camera\" aria-hidden=\"true\"></i> GALERIA DE FOTOS','Show e artistas mais tocados na rádio.',NULL,NULL);
/*!40000 ALTER TABLE `photos_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `poll_options`
--

DROP TABLE IF EXISTS `poll_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `poll_options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_poll` int(11) NOT NULL,
  `answer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_votes` int(11) NOT NULL DEFAULT 0,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `poll_options`
--

LOCK TABLES `poll_options` WRITE;
/*!40000 ALTER TABLE `poll_options` DISABLE KEYS */;
INSERT INTO `poll_options` VALUES (1,1,'Ótimo',94,'2022-01-24 20:29:07','2022-01-24 20:29:15'),(2,1,'Muito bom',4,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,1,'Regular',2,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(4,1,'Pode melhorar',1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `poll_options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `polls`
--

DROP TABLE IF EXISTS `polls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `polls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_votes` int(11) NOT NULL DEFAULT 0,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'storage/img/polls/default.jpg',
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `polls`
--

LOCK TABLES `polls` WRITE;
/*!40000 ALTER TABLE `polls` DISABLE KEYS */;
INSERT INTO `polls` VALUES (1,'O que você achou de nosso Site?',101,'storage/img/polls/default.jpg',1,1,'2022-01-24 20:29:07','2022-01-24 20:29:15');
/*!40000 ALTER TABLE `polls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `polls_texts`
--

DROP TABLE IF EXISTS `polls_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `polls_texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `polls_texts`
--

LOCK TABLES `polls_texts` WRITE;
/*!40000 ALTER TABLE `polls_texts` DISABLE KEYS */;
INSERT INTO `polls_texts` VALUES (1,'<i class=\"fa fa-question-circle\" aria-hidden=\"true\"></i> ENQUETE','<span style=\"color:#000000\">A Nossa Rádio esta evoluindo e com isso agora elaboramos um novo Site para você nosso ouvinte ficar por dentro de tudo que acontece e não perder nossa programação.<strong>PARTICIPE DA NOSSA PESQUISA DE OPNIÃO!</strong></span>',NULL,NULL);
/*!40000 ALTER TABLE `polls_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `post_categories`
--

DROP TABLE IF EXISTS `post_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `post_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `post_categories`
--

LOCK TABLES `post_categories` WRITE;
/*!40000 ALTER TABLE `post_categories` DISABLE KEYS */;
INSERT INTO `post_categories` VALUES (1,'Notícias','2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `post_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Vázio',
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `summary` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `emphasis` tinyint(1) NOT NULL DEFAULT 0,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'storage/img/news/default.png',
  `id_post_category` int(11) NOT NULL DEFAULT 1,
  `order` int(11) NOT NULL DEFAULT 1,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts`
--

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
INSERT INTO `posts` VALUES (1,'Coronavirus no Brasil, Cuidados e Precauções que devem ser tomadas fique atento as dicas.','1. Lave bem as mãos e com frequência, usando álcool em gel ou água e sabão.\r\n                    Por quê? Lavar as mãos com água e sabão ou usar álcool em gel mata os vírus que podem estar nas suas mãos.\r\n                    \r\n                     \r\n                    \r\n                    2. Mantenha uma distância mínima de 1 metro entre você e qualquer pessoa que tosse ou espirra.\r\n                    Por quê? Quando alguém tosse ou espirra, gotas de fluido que podem conter o vírus são liberadas pelo nariz ou pela boca. Se você estiver muito perto, pode respirar as gotículas e, com elas, o vírus COVID-19.\r\n                    \r\n                     \r\n                    \r\n                    3. Evite tocar nos olhos, nariz e boca.\r\n                    Por quê? As mãos tocam muitas superfícies e podem “pegar” vírus. Uma vez contaminadas, as mãos podem transferir o vírus para os olhos, nariz ou boca. A partir daí o vírus pode entrar no seu corpo e causar doenças.\r\n                    \r\n                     \r\n                    \r\n                    4. Você e as pessoas ao seu redor devem manter uma boa higiene das vias aéreas. Isso significa cobrir a boca e o nariz com o cotovelo dobrado ou com um lenço de papel quando tossir ou espirrar. O lenço usado deve ser descartado imediatamente.\r\n                    Por quê? Os vírus se espalham através de gotículas. Ao manter uma boa higiene respiratória, você protege as pessoas ao seu redor contra vírus como resfriado, gripe e COVID-19.\r\n                    \r\n                     \r\n                    \r\n                    5. Fique em casa se não estiver bem. Se você tiver febre, tosse e falta de ar, procure atendimento médico e ligue com antecedência para o posto de saúde, UPA ou pronto-socorro.\r\n                    Por quê? Ligar com antecedência permitirá que o seu atendimento seja direcionado rapidamente ao centro de saúde certo. Isso também irá protegê-lo e ajudar a impedir a propagação de vírus e outras infecções.\r\n                    \r\n                     \r\n                    \r\n                    6. Mantenha-se informado sobre as últimas notícias sobre a COVID-19 em canais oficiais e siga as orientações sobre como se proteger e a outras pessoas da COVID-19.\r\n                    Por quê? Os canais oficiais terão as informações mais atualizadas sobre se a COVID-19 está se espalhando em sua área e sobre os cuidados corretos para se proteger.\r\n                    \r\n                     \r\n                    \r\n                    7. Confira as últimas notícias sobre as áreas mais perigosas (ou seja, as cidades e lugares onde a doença está se espalhando mais amplamente). Se possível, evite se deslocar para essas áreas, especialmente se você é idoso ou tem diabetes, doenças cardíacas ou pulmonares.\r\n                    Por quê? Essas precauções devem ser tomadas nessas áreas, porque a probabilidade de contrair COVID-19 é maior.\r\n                    \r\n                     ','Fique em casa vamos combater esse virus de forma responsavel.','Governo de Santa Catarina',1,'storage/img/posts/23654657143215426561736.jpg',1,1,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(2,'Cazuza é reavivado com disco de músicas inéditas, documentário, show, podcasts e atualização de livro','\r\n                    Uma canção inédita de Cazuza acaba de ser disponibilizada para as plataformas de streaming. “Mina” é apresentada aos fãs junto de um videoclipe animado por Humberto Barros.\r\n\r\nA composição é uma parceria com George Israel e Nilo Romero e ficou de fora da seleção de repertório do álbum Só se for a 2, de 1987.\r\n\r\nPara a letra de “Mina”, Cazuza teve como inspiração uma confusão criada em um bar de Araxá-MG, quando o artista defendeu uma garota de um “cara que achava que era seu dono”.\r\n\r\nNilo lembra dessa episódio: “Saímos para comer uma pizza e a determinada altura apareceu um cara querendo mandar numa das meninas que estava ali. ‘Esse aí me viu crescer e acha que é meu dono’, ela disse. Lá pelas tantas, o cara pegou uma faca, Cazuza defendeu todo mundo, jogou uma mesa nele, o segurança chegou… Um tempo depois, veio ‘Mina\'”.\r\n\r\nA canção, que Nilo destaca como contendo “a marca de originalidade que Cazuza de crônicas da noite ácidas, viscerais”, chegou a ser lançada por Leo Jaime, em 1990, em 2007 pelo próprio George Israel.\r\n                    ','Música inédita de Cazuza será lançada para o publico.','Amanda Cordeiro',0,'storage/img/posts/326517832976354065463.jpg',1,2,1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,'Meta desativa contas de empresas que usavam o Facebook para espionagem','\r\n                    A Meta, empresa controladora do Facebook, anunciou nesta quinta-feira (16) que desativou cerca de 1.500 contas vinculadas a empresas acusadas de espionar ativistas, dissidentes e jornalistas em todo o mundo.\r\n\r\nAs contas suspensas do Facebook e Instagram foram vinculadas a sete empresas cujos serviços vão desde o armazenamento de informações públicas ao uso de perfis falsos para conquistar a confiança de suas vítimas e até mesmo espionagem digital através de ataques de hackers.\r\n\r\nA Meta revelou planos para alertar cerca de 50.000 pessoas que poderiam ser alvos de espionagem em cerca de 100 países por várias empresas, incluindo algumas sediadas em Israel, líder na indústria de vigilância cibernética. A plataforma também desativou contas relacionadas em suas outras plataformas.\r\n\r\n\"Os cibermercenários frequentemente afirmam que seus serviços visam apenas criminosos e terroristas\", de acordo com um comunicado da Meta.\r\n\r\nMas \"os alvos são de fato indiscriminados e incluem jornalistas, dissidentes e críticos de regimes autoritários, famílias, membros da oposição e ativistas de direitos humanos\", afirma o texto.\r\n\r\nAs empresas que vendem \"serviços de inteligência na web\" geralmente iniciam um processo de vigilância coletando informações disponíveis por meio de fontes públicas, como artigos de jornais e Wikipedia.\r\n\r\nAssim, os cibermercenários criam contas falsas em várias redes sociais para coletar informações dos perfis e até mesmo participam de conversas e grupos para aprender mais sobre seus alvos, segundo pesquisadores da Meta.\r\n\r\n\r\n                    ','Foram removidas 1.500 perfis vinculados a empresas acusadas de espionar ativistas, dissidentes e jornalistas em todo o mundo.','G1',0,'storage/img/posts/546314231349793574.jpg',1,4,1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts_texts`
--

DROP TABLE IF EXISTS `posts_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts_texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts_texts`
--

LOCK TABLES `posts_texts` WRITE;
/*!40000 ALTER TABLE `posts_texts` DISABLE KEYS */;
INSERT INTO `posts_texts` VALUES (1,'<i class=\"fa fa-newspaper\" aria-hidden=\"true\"></i> Blog',NULL,NULL);
/*!40000 ALTER TABLE `posts_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schedule_texts`
--

DROP TABLE IF EXISTS `schedule_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schedule_texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schedule_texts`
--

LOCK TABLES `schedule_texts` WRITE;
/*!40000 ALTER TABLE `schedule_texts` DISABLE KEYS */;
INSERT INTO `schedule_texts` VALUES (1,'PROGRAMAÇÃO <strong>?</strong>','<span style=\"color:#E6E6FA\"><span style=\"font-size:20px\">Fique por dentro de toda nossa </span></span><span style=\"color:#FFD700\"><span style=\"font-size:20px\"><strong>Programação</strong></span></span><span style=\"font-size:20px\"> <span style=\"color:#E6E6FA\">e se divirta, acompanha nossa grade de programas.</span></span>',NULL,NULL);
/*!40000 ALTER TABLE `schedule_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schedules`
--

DROP TABLE IF EXISTS `schedules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schedules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'AutoDJ',
  `presenter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '00:00',
  `day_the_week` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sunday',
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schedules`
--

LOCK TABLES `schedules` WRITE;
/*!40000 ALTER TABLE `schedules` DISABLE KEYS */;
INSERT INTO `schedules` VALUES (1,'Coração Sertanejo','','02:00','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(2,'Fandangueando','','04:00','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,'Vibe Sertaneja','','07:00','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(4,'Diante do Rei','','07:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(5,'Santa Missa Dominical','','08:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(6,'Espelho da Tradição','','09:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(7,'Taliani Nel Mondo','','14:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(8,'Só Bandas','','14:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(9,'Ritmos','','16:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(10,'Giro Musical','','18:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(11,'Vitrine Musical','','20:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(12,'Mega Mix','','22:30','sunday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(13,'Violada Sertaneja','','00:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(14,'Só Clássicos Sertanejos','','01:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(15,'Sertão Caboclo','','02:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(16,'Violada Sertaneja','','04:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(17,'Canta Brasil','','05:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(18,'Bom dia Rainha','','07:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(19,'De bem com a vida','','08:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(20,'Rainha Notícias','','09:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(21,'Show da Manhã','','10:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(22,'Conexão Rainha','','12:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(23,'Violada Sertaneja','','13:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(24,'Misturadão','','14:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(25,'Revista Rainha','','15:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(26,'Rainha Pop','','16:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(27,'Paradão Sertanejo','','17:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(28,'Rainha no Sertão','','18:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(29,'A voz do Brasil','','19:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(30,'Blitz Sertanejo','','20:00','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(31,'Charme','','20:30','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(32,'Misturadão','','22:30','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(33,'Só Clássicos Sertanejos','','23:30','monday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(34,'Violada Sertaneja','','00:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(35,'Só Clássicos Sertanejos','','01:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(36,'Sertão Caboclo','','02:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(37,'Violada Sertaneja','','04:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(38,'Canta Brasil','','05:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(39,'Bom dia Rainha','','07:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(40,'De bem com a vida','','08:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(41,'Rainha Notícias','','09:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(42,'Show da Manhã','','10:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(43,'Conexão Rainha','','12:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(44,'Violada Sertaneja','','13:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(45,'Misturadão','','14:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(46,'Revista Rainha','','15:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(47,'Rainha Pop','','16:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(48,'Paradão Sertanejo','','17:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(49,'Rainha no Sertão','','18:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(50,'A voz do Brasil','','19:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(51,'Blitz Sertanejo','','20:00','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(52,'Charme','','20:30','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(53,'Misturadão','','22:30','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(54,'Só Clássicos Sertanejos','','23:30','tuesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(55,'Violada Sertaneja','','00:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(56,'Só Clássicos Sertanejos','','01:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(57,'Sertão Caboclo','','02:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(58,'Violada Sertaneja','','04:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(59,'Canta Brasil','','05:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(60,'Bom dia Rainha','','07:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(61,'De bem com a vida','','08:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(62,'Rainha Notícias','','09:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(63,'Show da Manhã','','10:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(64,'Conexão Rainha','','12:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(65,'Violada Sertaneja','','13:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(66,'Misturadão','','14:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(67,'Revista Rainha','','15:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(68,'Rainha Pop','','16:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(69,'Paradão Sertanejo','','17:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(70,'Rainha no Sertão','','18:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(71,'A voz do Brasil','','19:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(72,'Blitz Sertanejo','','20:00','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(73,'Charme','','20:30','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(74,'Misturadão','','22:30','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(75,'Só Clássicos Sertanejos','','23:30','wednesday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(76,'Violada Sertaneja','','00:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(77,'Só Clássicos Sertanejos','','01:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(78,'Sertão Caboclo','','02:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(79,'Violada Sertaneja','','04:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(80,'Canta Brasil','','05:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(81,'Bom dia Rainha','','07:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(82,'De bem com a vida','','08:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(83,'Rainha Notícias','','09:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(84,'Show da Manhã','','10:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(85,'Conexão Rainha','','12:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(86,'Violada Sertaneja','','13:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(87,'Misturadão','','14:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(88,'Revista Rainha','','15:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(89,'Rainha Pop','','16:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(90,'Paradão Sertanejo','','17:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(91,'Rainha no Sertão','','18:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(92,'A voz do Brasil','','19:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(93,'Blitz Sertanejo','','20:00','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(94,'Charme','','20:30','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(95,'Misturadão','','22:30','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(96,'Só Clássicos Sertanejos','','23:30','thursday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(97,'Violada Sertaneja','','00:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(98,'Só Clássicos Sertanejos','','01:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(99,'Sertão Caboclo','','02:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(100,'Violada Sertaneja','','04:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(101,'Canta Brasil','','05:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(102,'Bom dia Rainha','','07:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(103,'De bem com a vida','','08:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(104,'Rainha Notícias','','09:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(105,'Show da Manhã','','10:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(106,'Conexão Rainha','','12:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(107,'Violada Sertaneja','','13:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(108,'Misturadão','','14:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(109,'Revista Rainha','','15:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(110,'Rainha Pop','','16:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(111,'Paradão Sertanejo','','17:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(112,'Rainha no Sertão','','18:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(113,'A voz do Brasil','','19:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(114,'Blitz Sertanejo','','20:00','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(115,'Charme','','20:30','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(116,'Misturadão','','22:30','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(117,'Só Clássicos Sertanejos','','23:30','friday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(118,'Coração Sertanejo','','00:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(119,'Só Bandas','','02:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(120,'Amigos do Teodoro e Sampaio','','04:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(121,'Viola de Ouro','','05:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(122,'Pastoral da Terra','','06:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(123,'Sábado Antenado','','07:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(124,'Sulcredi/Crediluz','','09:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(125,'Paróquia São Sebastião','','10:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(126,'Câm de Vereadores','','11:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(127,'O Semeador','','11:30','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(128,'Top 20 Sertanejo','','12:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(129,'Arena Pop','','14:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(130,'Conexão Total','','16:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(131,'Top 30','','18:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(132,'Festival Sertanejo','','20:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(133,'Giro Musical','','21:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(134,'Top 20 Sertanejo','','22:00','saturday','',1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `schedules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `smtp_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_source_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_source_return` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_port` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_security` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'notls',
  `smtp_enable` tinyint(1) NOT NULL DEFAULT 0,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tiktok` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1.0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'contato@localhost','Web Rádio','As melhores músicas você encontra aqui','rádio onlie, música, Diversão, entretenimento, web rádio','','','','','','','','notls',0,'','','','','','(99) 9999-9999','(88) 8888-8888','Rua 7 de Setembro','1.0','2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `statistics_informations`
--

DROP TABLE IF EXISTS `statistics_informations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statistics_informations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `statistics_informations`
--

LOCK TABLES `statistics_informations` WRITE;
/*!40000 ALTER TABLE `statistics_informations` DISABLE KEYS */;
INSERT INTO `statistics_informations` VALUES (1,'+ Ouvintes por Dia','500',1,NULL,NULL),(2,'Estamos Presentes em Todo o Brasil','5770',1,NULL,NULL),(3,'Horas Online','24',1,NULL,NULL);
/*!40000 ALTER TABLE `statistics_informations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stream_texts`
--

DROP TABLE IF EXISTS `stream_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stream_texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `live` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `chat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stream_texts`
--

LOCK TABLES `stream_texts` WRITE;
/*!40000 ALTER TABLE `stream_texts` DISABLE KEYS */;
INSERT INTO `stream_texts` VALUES (1,'<i class=\"fa fa-question-circle\" aria-hidden=\"true\"></i> FIQUE POR DENTRO','<h5 style=\"color: #fff;\">A Nossa Rádio esta evoluindo e com isso agora elaboramos um novo Site para você nosso ouvinte ficar por dentro de tudo.</h5>','CÂMERA AO VIVO','BATE-PAPO',NULL,NULL);
/*!40000 ALTER TABLE `stream_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `streams`
--

DROP TABLE IF EXISTS `streams`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `streams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `player` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `enable_player_popup` tinyint(1) NOT NULL DEFAULT 1,
  `player_popup` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_player` tinyint(1) NOT NULL DEFAULT 1,
  `web_tv` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_webtv` tinyint(1) NOT NULL DEFAULT 1,
  `chat` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_chat` tinyint(1) NOT NULL DEFAULT 1,
  `current_song` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_current_song` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `streams`
--

LOCK TABLES `streams` WRITE;
/*!40000 ALTER TABLE `streams` DISABLE KEYS */;
INSERT INTO `streams` VALUES (1,'<iframe src=\"https://player.conectastm.com/player-barra/8146/000000\" frameborder=\"0\" width=\"100%\" height=\"65\"></iframe>',1,'https://player.conectastm.com/player-popup-responsivo/8146/2',1,'<iframe class=\"embed-responsive-item\" width=\"560\" height=\"315\" src=\"https://playerv.srvstm.com/video/wesley//false/false/VTNSdFZqRXVjM0oyYzNSdExtTnZiUT09K0Q=/16:9//nao/nao\" frameborder=\"0\" scrolling=\"no\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"></iframe>',1,'<iframe class=\"embed-responsive-item\" width=\"560\" height=\"315\" src=\"https://player.conectastm.com/chat/8146\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"></iframe> ',1,'https://ssl.srvstm.com:8146/currentsong',1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `streams` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `team_texts`
--

DROP TABLE IF EXISTS `team_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `team_texts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `team_texts`
--

LOCK TABLES `team_texts` WRITE;
/*!40000 ALTER TABLE `team_texts` DISABLE KEYS */;
INSERT INTO `team_texts` VALUES (1,'<div class=\"titulo_padrao\"><i class=\"fa fa-users\" aria-hidden=\"true\"></i> EQUIPE</div>','Alguns de nossos principais colaboradores da Rádio.',NULL,NULL);
/*!40000 ALTER TABLE `team_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teams`
--

DROP TABLE IF EXISTS `teams`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `teams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sector` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_network` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(11) NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'storage/img/teams/default.jpg',
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  `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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `teams`
--

LOCK TABLES `teams` WRITE;
/*!40000 ALTER TABLE `teams` DISABLE KEYS */;
INSERT INTO `teams` VALUES (1,'Roberto Jr','Edição e Marketing','',1,'storage/img/teams/3165036511654324.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(2,'Wesley Carmo','Desenvolvedor Web','',1,'storage/img/teams/6516514324324651.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(3,'Amanda Cordeiro','Marketing','',1,'storage/img/teams/65165132146543.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07'),(4,'José Coelho','Diretor Geral','',1,'storage/img/teams/616514324313213.jpg',1,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `teams` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'storage/img/users/default.png',
  `last_login` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Administrador','admin','$2y$10$Cu7vr1m6ypSk.zdWkOQ/uek9HDhaHRjSzWVJWFS.UFFpi18GGhnW2','contato@localhost','storage/img/users/default.png',NULL,'2022-01-24 20:29:07',NULL,'2022-01-24 20:29:07','2022-01-24 20:29:07');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-01-24 14:31:04
