db.sql 547 B

123456789101112131415
  1. -- ----------------------------
  2. -- Table structure for t_device
  3. -- ----------------------------
  4. DROP TABLE IF EXISTS `t_device`;
  5. CREATE TABLE `t_device` (
  6. `code` varchar(10) NOT NULL,
  7. `title` varchar(20) DEFAULT NULL,
  8. `streamUrl` varchar(255) DEFAULT NULL,
  9. PRIMARY KEY (`code`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='监控设备信息';
  11. -- ----------------------------
  12. -- Records of t_device
  13. -- ----------------------------
  14. INSERT INTO `t_device` VALUES ('dev1', '胡南卫视RTMP流', 'rtmp://58.200.131.2:1935/livetv/hunantv');