<?php

@mysqli_query($conexao,"ALTER TABLE `configuracoes` ADD `idioma_painel` VARCHAR(255) NOT NULL DEFAULT 'pt-br';");

@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `acessos_players` ( `codigo` int(10) NOT NULL AUTO_INCREMENT, `player` varchar(255) COLLATE latin1_general_ci NOT NULL, `total` int(10) NOT NULL, PRIMARY KEY (`codigo`) ) ENGINE=MyISAM");

@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `acessos_paginas` ( `codigo` int(10) NOT NULL AUTO_INCREMENT, `pagina` varchar(255) COLLATE latin1_general_ci NOT NULL, `total` int(10) NOT NULL, PRIMARY KEY (`codigo`) ) ENGINE=MyISAM");

@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `configuracoes_backup`( `ftp_servidor` varchar(255) NOT NULL, `ftp_usuario` varchar(255) NOT NULL, `ftp_senha` varchar(255) NOT NULL, `bkp_arquivos` char(3) NOT NULL, `bkp_mysql` char(3) NOT NULL, `bkp_mysql_stats` char(3) NOT NULL, `log` longtext NOT NULL) ENGINE=MyISAM;");

@mysqli_query($conexao,"ALTER TABLE `revendas` ADD `tema_dark` CHAR(3) NOT NULL DEFAULT 'nao' AFTER `lives`;");

@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `tema_dark` CHAR(3) NOT NULL DEFAULT 'nao' AFTER `lives`;");

@mysqli_query($conexao,"ALTER TABLE `streamings` CHANGE `espaco` `espaco` INT(10) NOT NULL DEFAULT '0';");

@mysqli_query($conexao,"ALTER TABLE `revendas` ADD `url_logo` TEXT NOT NULL AFTER `stm_exibir_app_android`;");

@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `app_multi_plataforma`( `codigo` int(10) NOT NULL AUTO_INCREMENT, `codigo_stm` int(10) NOT NULL, `nome` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `url_facebook` VARCHAR(255) NOT NULL, `url_instagram` VARCHAR(255) NOT NULL, `url_twitter` VARCHAR(255) NOT NULL, `url_youtube` VARCHAR(255) NOT NULL, `url_site` VARCHAR(255) NOT NULL, `url_chat` VARCHAR(255) NOT NULL, `url_logo` VARCHAR(255) NOT NULL, `url_background` VARCHAR(255) NOT NULL, `whatsapp` VARCHAR(255) NOT NULL, `cor_texto` CHAR(7) NOT NULL DEFAULT '#FFFFFF', `cor_menu_claro` CHAR(7) NOT NULL DEFAULT '#7386d5', `cor_menu_escuro` CHAR(7) NOT NULL DEFAULT '#6d7fcc', `cor_splash` CHAR(7) NOT NULL DEFAULT '#6d7fcc', `text_prog` LONGTEXT NOT NULL, `text_hist` LONGTEXT NOT NULL, `contador` CHAR(3) NOT NULL DEFAULT 'nao', `tela_inicial` int(1) NOT NULL DEFAULT '1', PRIMARY KEY (`codigo`)) ENGINE=MyISAM;");

@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `app_multi` CHAR(3) NOT NULL DEFAULT 'nao';");

@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `app_android` CHAR(3) NOT NULL DEFAULT 'nao';");

@mysqli_query($conexao,"ALTER TABLE `revendas` ADD `codigo_servidor_privado` INT(10) NOT NULL DEFAULT '0';");
@mysqli_query($conexao,"ALTER TABLE `revendas` ADD `lives` CHAR(3) NOT NULL DEFAULT 'nao';");
@mysqli_query($conexao,"ALTER TABLE `configuracoes` ADD `idioma_painel` VARCHAR(255) NOT NULL DEFAULT 'pt-br';");
@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `acessos_players` ( `codigo` int(10) NOT NULL AUTO_INCREMENT, `player` varchar(255) COLLATE latin1_general_ci NOT NULL, `total` int(10) NOT NULL, PRIMARY KEY (`codigo`) ) ENGINE=MyISAM");
@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `acessos_paginas` ( `codigo` int(10) NOT NULL AUTO_INCREMENT, `pagina` varchar(255) COLLATE latin1_general_ci NOT NULL, `total` int(10) NOT NULL, PRIMARY KEY (`codigo`) ) ENGINE=MyISAM");
@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `configuracoes_backup`( `ftp_servidor` varchar(255) NOT NULL, `ftp_usuario` varchar(255) NOT NULL, `ftp_senha` varchar(255) NOT NULL, `bkp_arquivos` char(3) NOT NULL, `bkp_mysql` char(3) NOT NULL, `bkp_mysql_stats` char(3) NOT NULL, `log` longtext NOT NULL) ENGINE=MyISAM;");
@mysqli_query($conexao,"ALTER TABLE `revendas` ADD `tema_dark` CHAR(3) NOT NULL DEFAULT 'nao' AFTER `lives`;");
@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `tema_dark` CHAR(3) NOT NULL DEFAULT 'nao' AFTER `lives`;");
@mysqli_query($conexao,"ALTER TABLE `streamings` CHANGE `espaco` `espaco` INT(10) NOT NULL DEFAULT '0';");
@mysqli_query($conexao,"ALTER TABLE `revendas` ADD `url_logo` TEXT NOT NULL AFTER `stm_exibir_app_android`;");
@mysqli_query($conexao,"CREATE TABLE IF NOT EXISTS `app_multi_plataforma`( `codigo` int(10) NOT NULL AUTO_INCREMENT, `codigo_stm` int(10) NOT NULL, `nome` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `url_facebook` VARCHAR(255) NOT NULL, `url_instagram` VARCHAR(255) NOT NULL, `url_twitter` VARCHAR(255) NOT NULL, `url_youtube` VARCHAR(255) NOT NULL, `url_site` VARCHAR(255) NOT NULL, `url_chat` VARCHAR(255) NOT NULL, `url_logo` VARCHAR(255) NOT NULL, `url_background` VARCHAR(255) NOT NULL, `whatsapp` VARCHAR(255) NOT NULL, `cor_texto` CHAR(7) NOT NULL DEFAULT '#FFFFFF', `cor_menu_claro` CHAR(7) NOT NULL DEFAULT '#7386d5', `cor_menu_escuro` CHAR(7) NOT NULL DEFAULT '#6d7fcc', `cor_splash` CHAR(7) NOT NULL DEFAULT '#6d7fcc', `text_prog` LONGTEXT NOT NULL, `text_hist` LONGTEXT NOT NULL, `contador` CHAR(3) NOT NULL DEFAULT 'nao', `tela_inicial` int(1) NOT NULL DEFAULT '1', PRIMARY KEY (`codigo`)) ENGINE=MyISAM;");
@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `ultimo_acesso_data` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;");
@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `ultimo_acesso_ip` VARCHAR(255) NOT NULL DEFAULT '000.000.000.000';");

@mysqli_query($conexao,"CREATE TABLE `anuncios_videos` ( `codigo` INT(10) NOT NULL AUTO_INCREMENT , `codigo_stm` INT(10) NOT NULL , `video` TEXT NOT NULL , `tempo` INT(10) NOT NULL  , `data_cadastro` DATE NOT NULL , `exibicoes` INT(10) NOT NULL , PRIMARY KEY (`codigo`)) ENGINE = MyISAM;");

@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `srt_status` CHAR(3) NOT NULL DEFAULT 'nao';");
@mysqli_query($conexao,"ALTER TABLE `streamings` ADD `srt_porta` int(10) NOT NULL DEFAULT '0';");

?>