骆驼IPTV-源码+APP.zip

-- MySQL dump 10.13 Distrib 5.6.37, for Linux (x86_64) -- -- Host: localhost Database: luotuo -- ------------------------------------------------------ -- Server version 5.6.37-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 `chzb_admin` -- DROP TABLE IF EXISTS `chzb_admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chzb_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) NOT NULL, `psw` varchar(32) NOT NULL, `showcounts` tinyint(4) NOT NULL DEFAULT '20', `author` tinyint(4) NOT NULL DEFAULT '0', `useradmin` tinyint(4) NOT NULL DEFAULT '0', `ipcheck` tinyint(4) NOT NULL DEFAULT '0', `epgadmin` tinyint(4) NOT NULL DEFAULT '0', `channeladmin` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chzb_admin` -- LOCK TABLES `chzb_admin` WRITE; /*!40000 ALTER TABLE `chzb_admin` DISABLE KEYS */; INSERT INTO `chzb_admin` VALUES (1,'admin','8114c88b2062d554b895f92bd3d7b9b8',20,1,1,1,1,1); /*!40000 ALTER TABLE `chzb_admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chzb_adminrec` -- DROP TABLE IF EXISTS `chzb_adminrec`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chzb_adminrec` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) NOT NULL, `ip` varchar(16) NOT NULL, `loc` varchar(64) NOT NULL, `time` varchar(64) NOT NULL, `func` varchar(64) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chzb_adminrec` -- LOCK TABLES `chzb_adminrec` WRITE; /*!40000 ALTER TABLE `chzb_adminrec` DISABLE KEYS */; INSERT INTO `chzb_adminrec` VALUES (1,'admin','219.152.144.132','','2020-03-06 13:12:16','输入错误密码'),(2,'admin','219.152.144.132','','2020-03-06 13:12:21','用户登入'),(3,'admin','219.152.144.132','','2020-03-06 15:21:00','用户登入'); /*!40000 ALTER TABLE `chzb_adminrec` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chzb_appdata` -- DROP TABLE IF EXISTS `chzb_appdata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chzb_appdata` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dataver` int(11) NOT NULL, `appver` varchar(16) NOT NULL, `setver` int(11) NOT NULL DEFAULT '0', `dataurl` varchar(255) NOT NULL, `appurl` varchar(255) NOT NULL, `adtext` varchar(1024) NOT NULL, `showtime` int(11) NOT NULL, `showinterval` int(11) NOT NULL, `needauthor` int(11) NOT NULL DEFAULT '1', `splash` varchar(255) NOT NULL, `decoder` int(11) NOT NULL DEFAULT '0', `buffTimeOut` int(11) NOT NULL DEFAULT '10', `tipusernoreg` varchar(100) NOT NULL, `tipuserexpired` varchar(100) NOT NULL, `tipuserforbidden` varchar(100) NOT NULL, `tiploading` varchar(100) NOT NULL, `ipcount` int(11) NOT NULL DEFAULT '5', `trialdays` int(11) DEFAULT NULL, `qqinfo` varchar(255) DEFAULT NULL, `autoupdate` int(11) DEFAULT '1', `randkey` varchar(100) DEFAULT '827ccb0eea8a706c4c34a16891f84e7b', `updateinterval` int(11) DEFAULT '15', `up_size` varchar(16) DEFAULT NULL, `up_sets` int(11) NOT NULL, `up_text` varchar(1024) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chzb_appdata` -- LOCK TABLES `chzb_appdata` WRITE; /*!40000 ALTER TABLE `chzb_appdata` DISABLE KEYS */; INSERT INTO `chzb_appdata` VALUES (1,2,'1.0',1,'http://127.0.0.1','http://127.0.0.1/1.apk','欢迎使用IPTV高清播放系统',120,5,1,'http://47.97.115.241/luotuo/admin/../images/start_up.png',1,30,'该设备无授权，请联系你的代理续费.','账号已到期，请联系你的代理续费。','账号已禁用，请联系你的代理续费.','正在连接，请稍后 ...',2,-999,'欢迎使用IPTV高清播放系统',1,'827ccb0eea8a706c4c34a16891f84e7b',10,'',1,''); /*!40000 ALTER TABLE `chzb_appdata` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chzb_category` -- DROP TABLE IF EXISTS `chzb_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chzb_category` ( `id` int(11) NOT NULL, `name` varchar(16) NOT NULL, `enable` tinyint(4) NOT NULL DEFAULT '1', `psw` varchar(16) DEFAULT '', `type` varchar(16) NOT NULL DEFAULT 'default', `url` varchar(1024) DEFAULT NULL, UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chzb_category` -- LOCK TABLES `chzb_category` WRITE; /*!40000 ALTER TABLE `chzb_category` DISABLE KEYS */; INSERT INTO `chzb_category` VALUES (50,'隐藏频道',1,'123','vip',NULL),(1,'默认频道',1,'','default',NULL); /*!40000 ALTER TABLE `chzb_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chzb_channels` -- DROP TABLE IF EXISTS `chzb_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chzb_channels` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `url` varchar(600) DEFAULT NULL, `category` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chzb_channels` -- LOCK TABLES `chzb_channels` WRITE; /*!40000 ALTER TABLE `chzb_channels` DISABLE KEYS */; INSERT INTO `chzb_channels` VALUES (15,'CCTV-1高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226744/10000100000000060000000001351427_0.smil','默认频道'),(16,'CCTV-2高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226815/10000100000000060000000001357827_0.smil','默认频道'),(17,'CCTV-3高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226943/10000100000000060000000004016455_0.smil','默认频道'),(18,'CCTV-4高清','rtsp://172.3.12.66:554/PLTV/101/224/3221227037/10000100000000060000000007214668_0.smil','默认频道'),(19,'CCTV-5高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226941/10000100000000060000000004013320_0.smil','默认频道'),(20,'CCTV-6高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226906/10000100000000060000000004013319_0.smil','默认频道'),(21,'CCTV-7高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226800/10000100000000060000000001357825_0.smil','默认频道'),(22,'CCTV-8高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226939/10000100000000060000000004013318_0.smil','默认频道'),(23,'CCTV-9高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226819/10000100000000060000000001357829_0.smil','默认频道'),(24,'CCTV-10高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226817/10000100000000060000000001357828_0.smil','默认频道'),(25,'CCTV-12高清','rtsp://172.3.12.66:554/PLTV/101/224/3221226802/10000100000000060000000001357830_0.smil','默认频道'),(26,'CCTV-13','rtsp://172.3.12.66:554/PLTV/101/224/3221226734/10000100000000060000000001351383_0.smil','默认频道'),(27,'重庆时尚超高清','rtsp://172.3.12.66:554/PLTV/101/224/322122