vc_jlzf/jlzfver.sql

-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: 10.252.250.130
-- Generation Time: 2017-08-03 09:46:05
-- 服务器版本： 10.0.17-MariaDB-1~trusty-log
-- PHP Version: 7.0.15-0ubuntu0.16.04.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `jlzfver`
--

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

--
-- 表的结构 `fc_category`
--

CREATE TABLE `fc_category` (
  `cateid` int(11) UNSIGNED NOT NULL,
  `catename` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '类别名',
  `parentid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '父类id,默认为0，都是父类',
  `itemid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '项目id，默认为0，无项目'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='类别表';

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

--
-- 表的结构 `fc_item`
--

CREATE TABLE `fc_item` (
  `itemid` int(11) UNSIGNED NOT NULL,
  `itemname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目领取码'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='项目表';

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

--
-- 表的结构 `fc_log`
--

CREATE TABLE `fc_log` (
  `id` int(11) UNSIGNED NOT NULL,
  `userid` int(11) UNSIGNED NOT NULL,
  `reportid` int(11) UNSIGNED NOT NULL,
  `verid` int(11) UNSIGNED NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '操作内容',
  `addtime` int(15) UNSIGNED NOT NULL COMMENT '添加时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户操作记录表';

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

--
-- 表的结构 `fc_report`
--

CREATE TABLE `fc_report` (
  `reportid` int(11) UNSIGNED NOT NULL,
  `reportname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `areacate` tinyint(4) UNSIGNED NOT NULL DEFAULT '3' COMMENT '适用地区',
  `itemid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属项目，默认为0，通用',
  `cateid` int(11) UNSIGNED NOT NULL COMMENT '所属类别',
  `parentid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属类别父类，默认为0，都为父类',
  `userid` int(11) UNSIGNED NOT NULL COMMENT '谁创建本报表',
  `edittime` int(15) UNSIGNED NOT NULL COMMENT '最新更新时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='报表';

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

--
-- 表的结构 `fc_user`
--

CREATE TABLE `fc_user` (
  `id` int(11) UNSIGNED NOT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='管理员用户表';

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

INSERT INTO `fc_user` (`id`, `username`, `password`) VALUES
(1, '纵横知道', '$2a$08$X2qbaqmSATLNPmrjVoV9AuYFo2i28omEBWsHc16eK0R1VNtTzF/C6'),
(2, '纵横', '$2a$08$/s0ayZBQGcOrOwSJ8RIyUu62RL0dnwzn4BGcax53MN6wd4Tlz9302');

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

--
-- 表的结构 `fc_version`
--

CREATE TABLE `fc_version` (
  `verid` int(11) UNSIGNED NOT NULL,
  `reportid` int(11) UNSIGNED NOT NULL COMMENT '报表id',
  `vername` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '版本名称，以时间为格式',
  `content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '内容',
  `xmlheader` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'xml头文件代码',
  `xmlbody` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'xml报表内容',
  `status` tinyint(2) UNSIGNED NOT NULL COMMENT '状态，0为未发布，1为草稿，2为发布',
  `addtime` int(15) UNSIGNED NOT NULL COMMENT '版本添加时间',
  `edittime` int(15) UNSIGNED NOT NULL COMMENT '最新编辑时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='版本表';

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

--
-- 表的结构 `sfu_hosts`
--

CREATE TABLE `sfu_hosts` (
  `id` int(10) UNSIGNED NOT NULL,
  `serverid` mediumint(9) NOT NULL COMMENT '服务器主键id',
  `hostname` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '客户机名称',
  `domain` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '域名',
  `sales` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '销售负责人',
  `status` tinyint(4) NOT NULL COMMENT '状态',
  `webver` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '云端版本信息',
  `softver` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '软件版本信息',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='客户机表';

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

--
-- 表的结构 `sfu_servers`
--

CREATE TABLE `sfu_servers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- 表的结构 `sfu_upgradelogs`
--

CREATE TABLE `sfu_upgradelogs` (
  `id` int(10) UNSIGNED NOT NULL,
  `hid` mediumint(9) NOT NULL COMMENT 'hosts主键',
  `scondition` tinyint(1) UNSIGNED NOT NULL COMMENT '版本信息 1：更高版本 2：当前版本',
  `version` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '软件版本号',
  `jsondata` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `fc_category`
--
ALTER TABLE `fc_category`
  ADD PRIMARY KEY (`cateid`),
  ADD KEY `catename` (`catename`,`parentid`);

--
-- Indexes for table `fc_item`
--
ALTER TABLE `fc_item`
  ADD PRIMARY KEY (`itemid`),
  ADD KEY `itemname` (`itemname`),
  ADD KEY `code` (`code`);

--
-- Indexes for table `fc_log`
--
ALTER TABLE `fc_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`,`reportid`,`verid`);

--
-- Indexes for table `fc_report`
--
ALTER TABLE `fc_report`
  ADD PRIMARY KEY (`reportid`),
  ADD KEY `reportname` (`reportname`,`itemid`,`cateid`),
  ADD KEY `parentid` (`parentid`),
  ADD KEY `userid` (`userid`);

--
-- Indexes for table `fc_user`
--
ALTER TABLE `fc_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fc_version`
--
ALTER TABLE `fc_version`
  ADD PRIMARY KEY (`verid`),
  ADD KEY `reportid` (`reportid`,`vername`),
  ADD KEY `status` (`status`),
  ADD KEY `vername` (`vername`),
  ADD KEY `addtime` (`addtime`);

--
-- Indexes for table `sfu_hosts`
--
ALTER TABLE `sfu_hosts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sfu_servers`
--
ALTER TABLE `sfu_servers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sfu_upgradelogs`
--
ALTER TABLE `sfu_upgradelogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `scondition` (`scondition`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `fc_category`
--
ALTER TABLE `fc_category`
  MODIFY `cateid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- 使用表AUTO_INCREMENT `fc_item`
--
ALTER TABLE `fc_item`
  MODIFY `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- 使用表AUTO_INCREMENT `fc_log`
--
ALTER TABLE `fc_log`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1085;
--
-- 使用表AUTO_INCREMENT `fc_report`
--
ALTER TABLE `fc_report`
  MODIFY `reportid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=185;
--
-- 使用表AUTO_INCREMENT `fc_user`
--
ALTER TABLE `fc_user`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `fc_version`
--
ALTER TABLE `fc_version`
  MODIFY `verid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=341;
--
-- 使用表AUTO_INCREMENT `sfu_hosts`
--
ALTER TABLE `sfu_hosts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `sfu_servers`
--
ALTER TABLE `sfu_servers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 使用表AUTO_INCREMENT `sfu_upgradelogs`
--
ALTER TABLE `sfu_upgradelogs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;COMMIT;

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