-- phpMyAdmin SQL Dump
-- version phpStudy 2014
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2019 �?04 �?18 �?09:47
-- 服务器版本: 10.1.19-MariaDB
-- PHP 版本: 5.6.28

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- 数据库: `ipa100`
--

-- --------------------------------------------------------

--
-- 表的结构 `infrareddata`
--

CREATE TABLE IF NOT EXISTS `infrareddata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deviceId` varchar(16) NOT NULL,
  `infraredData` varchar(999) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;

-- --------------------------------------------------------

--
-- 表的结构 `rs232data`
--

CREATE TABLE IF NOT EXISTS `rs232data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deviceId` varchar(16) NOT NULL,
  `rs232Data` varchar(800) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `userlist`
--

CREATE TABLE IF NOT EXISTS `userlist` (
  `id` int(11) NOT NULL,
  `username` varchar(10) NOT NULL,
  `password` varchar(10) NOT NULL,
  `logintype` varchar(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `userlist`
--

INSERT INTO `userlist` (`id`, `username`, `password`, `logintype`) VALUES
(2, 'admin', 'admin', '0');

-- --------------------------------------------------------

--
-- 表的结构 `userscreen`
--

CREATE TABLE IF NOT EXISTS `userscreen` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `pagetype` varchar(50) NOT NULL COMMENT '所属页面',
  `devicetype` varchar(10) NOT NULL COMMENT '设备类型',
  `listnum` int(11) NOT NULL COMMENT '在所属页面的组别顺序',
  `name` varchar(10) NOT NULL COMMENT '改组的别名',
  `devicelist` text COMMENT '存储设备的MAC地址',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk COMMENT='分组功能存储表' AUTO_INCREMENT=71 ;

--
-- 转存表中的数据 `userscreen`
--

INSERT INTO `userscreen` (`id`, `pagetype`, `devicetype`, `listnum`, `name`, `devicelist`) VALUES
(11, 'videoswitching', 'rx', 1, 'Preset #1', NULL),
(12, 'videoswitching', 'rx', 1, 'Preset #2', NULL),
(13, 'videoswitching', 'rx', 1, 'Preset #3', NULL),
(14, 'videoswitching', 'rx', 1, 'Preset #4', NULL),
(15, 'videoswitching', 'rx', 1, 'Preset #5', NULL),
(16, 'videoswitching', 'rx', 1, 'Preset #6', NULL),
(17, 'videoswitching', 'rx', 1, 'Preset #7', NULL),
(18, 'videoswitching', 'rx', 1, 'Preset #8', NULL),
(19, 'videoswitching', 'rx', 1, 'Preset #9', NULL),
(21, 'hdmi_audio', 'rx', 1, 'Preset #1', NULL),
(22, 'hdmi_audio', 'rx', 1, 'Preset #2', NULL),
(23, 'hdmi_audio', 'rx', 1, 'Preset #3', NULL),
(24, 'hdmi_audio', 'rx', 1, 'Preset #4', NULL),
(25, 'hdmi_audio', 'rx', 1, 'Preset #5', NULL),
(26, 'hdmi_audio', 'rx', 1, 'Preset #6', NULL),
(27, 'hdmi_audio', 'rx', 1, 'Preset #7', NULL),
(28, 'hdmi_audio', 'rx', 1, 'Preset #8', NULL),
(29, 'hdmi_audio', 'rx', 1, 'Preset #9', NULL),
(31, 'analog_audio', 'rx', 1, 'Preset #1', NULL),
(41, 'rs232', 'rx', 1, 'Preset #1', NULL),
(51, 'infrared', 'rx', 1, 'Preset #1', NULL),
(32, 'analog_audio', 'rx', 1, 'Preset #2', NULL),
(33, 'analog_audio', 'rx', 1, 'Preset #3', NULL),
(34, 'analog_audio', 'rx', 1, 'Preset #4', NULL),
(35, 'analog_audio', 'rx', 1, 'Preset #5', NULL),
(36, 'analog_audio', 'rx', 1, 'Preset #6', NULL),
(37, 'analog_audio', 'rx', 1, 'Preset #7', NULL),
(38, 'analog_audio', 'rx', 1, 'Preset #8', NULL),
(39, 'analog_audio', 'rx', 1, 'Preset #9', NULL),
(42, 'rs232', 'rx', 1, 'Preset #2', NULL),
(43, 'rs232', 'rx', 1, 'Preset #3', NULL),
(44, 'rs232', 'rx', 1, 'Preset #4', NULL),
(45, 'rs232', 'rx', 1, 'Preset #5', NULL),
(46, 'rs232', 'rx', 1, 'Preset #6', NULL),
(47, 'rs232', 'rx', 1, 'Preset #7', NULL),
(48, 'rs232', 'rx', 1, 'Preset #8', NULL),
(49, 'rs232', 'rx', 1, 'Preset #9', NULL),
(52, 'infrared', 'rx', 1, 'Preset #2', NULL),
(53, 'infrared', 'rx', 1, 'Preset #3', NULL),
(54, 'infrared', 'rx', 1, 'Preset #4', NULL),
(55, 'infrared', 'rx', 1, 'Preset #5', NULL),
(56, 'infrared', 'rx', 1, 'Preset #6', NULL),
(57, 'infrared', 'rx', 1, 'Preset #7', NULL),
(58, 'infrared', 'rx', 1, 'Preset #8', NULL),
(59, 'infrared', 'rx', 1, 'Preset #9', NULL),
(61, 'videowall', 'rx', 1, 'Preset #1', NULL),
(62, 'videowall', 'rx', 1, 'Preset #2', NULL),
(63, 'videowall', 'rx', 1, 'Preset #3', NULL),
(64, 'videowall', 'rx', 1, 'Preset #4', NULL),
(65, 'videowall', 'rx', 1, 'Preset #5', NULL),
(66, 'videowall', 'rx', 1, 'Preset #6', NULL),
(67, 'videowall', 'rx', 1, 'Preset #7', NULL),
(68, 'videowall', 'rx', 1, 'Preset #8', NULL),
(69, 'videowall', 'rx', 1, 'Preset #9', NULL);

/*!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 */;
