-- phpMyAdmin SQL Dump
-- version 4.4.15.10
-- https://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: 2020-10-30 10:11:03
-- 服务器版本： 5.7.27
-- PHP Version: 5.4.45

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

--
-- Database: `db_zc`
--

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

--
-- 表的结构 `backup`
--

CREATE TABLE IF NOT EXISTS `backup` (
  `id` int(10) unsigned NOT NULL,
  `file` varchar(1024) CHARACTER SET utf8mb4 NOT NULL COMMENT '备份文件名',
  `shijian` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '备份时间',
  `type` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '备份类型，0：数据库；1：文件'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 表的结构 `bgszichan`
--

CREATE TABLE IF NOT EXISTS `bgszichan` (
  `id` bigint(12) NOT NULL COMMENT 'id',
  `zcbh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产编号',
  `xlh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '序列号',
  `zclx` int(10) unsigned NOT NULL COMMENT '资产类型',
  `cw` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zczt` int(10) unsigned NOT NULL COMMENT '资产状态I',
  `bm` int(10) unsigned NOT NULL COMMENT '所属单位',
  `bgr` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '保管人',
  `dz` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '保存地址',
  `cgsj` int(10) unsigned DEFAULT NULL COMMENT '采购时间',
  `rzsj` int(10) unsigned DEFAULT NULL COMMENT '入账时间',
  `zbsc` int(2) DEFAULT NULL COMMENT '质保时长（年）',
  `sysc` int(2) DEFAULT NULL COMMENT '报废年限（年）',
  `pp` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '品牌',
  `xh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `zcly` varchar(10) CHARACTER SET utf8mb4 DEFAULT '自购' COMMENT '资产来源',
  `zcjz` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '资产价值',
  `gg` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '规格',
  `bz` text CHARACTER SET utf8mb4 COMMENT '备注',
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产图片',
  `ll` text CHARACTER SET utf8mb4 COMMENT '履历'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='办公室资产数据表';

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

--
-- 表的结构 `chuku`
--

CREATE TABLE IF NOT EXISTS `chuku` (
  `id` int(10) unsigned NOT NULL,
  `lyr` varchar(32) CHARACTER SET utf8mb4 NOT NULL COMMENT '领用人',
  `dw` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '领用人单位',
  `lysj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '领用时间',
  `hcid` int(10) unsigned NOT NULL COMMENT '耗材ID',
  `name` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '耗材名',
  `pp` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '品牌',
  `gg` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '规格',
  `num` int(10) unsigned NOT NULL COMMENT '领用数量'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 表的结构 `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `id` int(10) unsigned NOT NULL,
  `title` varchar(256) CHARACTER SET utf8mb4 NOT NULL COMMENT '项目',
  `value` varchar(1024) CHARACTER SET utf8mb4 NOT NULL COMMENT '项目制',
  `kapian` text CHARACTER SET utf8mb4 NOT NULL COMMENT '卡片模板',
  `kpyl` mediumtext CHARACTER SET utf8mb4 COMMENT '卡片模板HTML',
  `sm` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '说明'
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `config` (`id`, `title`, `value`, `kapian`, `kpyl`, `sm`) VALUES
(1, 'xxzxauto', '1', '', NULL, '信息中心资产添加后是否保留上次数值'),
(2, 'bgsauto', '1', '', NULL, ''),
(3, 'wgbauto', '1', '', NULL, ''),
(4, 'xxkapian', '{"title":"WDSW资产卡片","ma":"1","bianma":"xlh","content":["zcbh","zclx","cw","bgr"]}', '{"panels":[{"index":0,"height":40,"width":80,"paperHeader":-1400,"paperFooter":113.38582677165356,"printElements":[{"tid":"configModule.name","options":{"left":76.5,"top":4.5,"height":28,"width":150,"fontSize":15,"fontWeight":"600","textAlign":"center","lineHeight":28,"hideTitle":true,"field":"name","testData":"WDSW资产卡片"}},{"tid":"configModule.gender","options":{"left":6,"top":39,"height":9.75,"width":154.5,"title":"资产编号","field":"zcbh","testData":"A202010104321","fontFamily":"Microsoft YaHei","fontSize":10.5}},{"tid":"configModule.mySite","options":{"left":162,"top":49.5,"height":50,"width":50,"fontSize":19,"fontWeight":"700","textAlign":"center","lineHeight":39,"hideTitle":true,"textType":"qrcode","field":"ewm","title":"123","testData":"123"}},{"tid":"configModule.email","options":{"left":6,"top":57,"height":9.75,"width":120,"title":"财务资产名","field":"cw","testData":"联想台式机","fontFamily":"Microsoft YaHei","fontWeight":"bold"}},{"tid":"configModule.like","options":{"left":6,"top":73.5,"height":9.75,"width":120,"title":"资产类型","field":"zclx","testData":"台式计算机","fontFamily":"Microsoft YaHei","fontWeight":"bolder"}},{"tid":"configModule.address","options":{"left":1.5,"top":93,"height":9.75,"width":120,"title":"保管人","field":"bgr","testData":"李文明","fontFamily":"Microsoft YaHei","fontSize":12,"fontWeight":"bolder"}}],"paperNumberLeft":-565,"paperNumberTop":-819,"paperNumberDisabled":true,"paperNumberFormat":"paperCount"}]}', '<div class="hiprint-printTemplate"><div class="hiprint-printPanel panel-index-0"> <style printstyle="">\n        @page\n        {\n             border:0;\n             padding:0cm;\n             margin:0cm;\n             size:80mm 40mm ;\n        }\n        </style>\n        <div class="hiprint-printPaper" original-height="40" style="width: 80mm; height: 39mm;"><div class="hiprint-printPaper-content"><div tabindex="1" class="hiprint-printElement hiprint-printElement-text" style="position: absolute; width: 150pt; height: 28pt; font-size: 15pt; font-weight: 600; text-align: center; line-height: 28pt; left: 76.5pt; top: 4.5pt;"><div class="hiprint-printElement-text-content hiprint-printElement-content" style="height:100%;width:100%">WDSW资产卡片</div></div><div tabindex="1" class="hiprint-printElement hiprint-printElement-text" style="position: absolute; width: 154.5pt; height: 9.75pt; font-family: &quot;Microsoft YaHei&quot;; font-size: 10.5pt; left: 6pt; top: 39pt;"><div class="hiprint-printElement-text-content hiprint-printElement-content" style="height:100%;width:100%">资产编号：A202001105631</div></div><div tabindex="1" class="hiprint-printElement hiprint-printElement-text" style="position: absolute; width: 50pt; height: 50pt; font-size: 19pt; font-weight: 700; text-align: center; line-height: 39pt; left: 162pt; top: 49.5pt;"><div class="hiprint-printElement-text-content hiprint-printElement-content" style="height:100%;width:100%" title="qrcode"><svg viewBox="0 0 25 25" width="100%" height="100%" fill="#ffffff" xmlns:xlink="http://www.w3.org/1999/xlink"><rect fill="#ffffff" width="100%" height="100%"></rect><rect fill="#000000" width="1" height="1" id="template"></rect><use x="0" y="0" xlink:href="#template"></use><use x="1" y="0" xlink:href="#template"></use><use x="2" y="0" xlink:href="#template"></use><use x="3" y="0" xlink:href="#template"></use><use x="4" y="0" xlink:href="#template"></use><use x="5" y="0" xlink:href="#template"></use><use x="6" y="0" xlink:href="#template"></use><use x="8" y="0" xlink:href="#template"></use><use x="9" y="0" xlink:href="#template"></use><use x="12" y="0" xlink:href="#template"></use><use x="13" y="0" xlink:href="#template"></use><use x="15" y="0" xlink:href="#template"></use><use x="16" y="0" xlink:href="#template"></use><use x="18" y="0" xlink:href="#template"></use><use x="19" y="0" xlink:href="#template"></use><use x="20" y="0" xlink:href="#template"></use><use x="21" y="0" xlink:href="#template"></use><use x="22" y="0" xlink:href="#template"></use><use x="23" y="0" xlink:href="#template"></use><use x="24" y="0" xlink:href="#template"></use><use x="0" y="1" xlink:href="#template"></use><use x="6" y="1" xlink:href="#template"></use><use x="8" y="1" xlink:href="#template"></use><use x="11" y="1" xlink:href="#template"></use><use x="13" y="1" xlink:href="#template"></use><use x="15" y="1" xlink:href="#template"></use><use x="16" y="1" xlink:href="#template"></use><use x="18" y="1" xlink:href="#template"></use><use x="24" y="1" xlink:href="#template"></use><use x="0" y="2" xlink:href="#template"></use><use x="2" y="2" xlink:href="#template"></use><use x="3" y="2" xlink:href="#template"></use><use x="4" y="2" xlink:href="#template"></use><use x="6" y="2" xlink:href="#template"></use><use x="10" y="2" xlink:href="#template"></use><use x="11" y="2" xlink:href="#template"></use><use x="13" y="2" xlink:href="#template"></use><use x="14" y="2" xlink:href="#template"></use><use x="16" y="2" xlink:href="#template"></use><use x="18" y="2" xlink:href="#template"></use><use x="20" y="2" xlink:href="#template"></use><use x="21" y="2" xlink:href="#template"></use><use x="22" y="2" xlink:href="#template"></use><use x="24" y="2" xlink:href="#template"></use><use x="0" y="3" xlink:href="#template"></use><use x="2" y="3" xlink:href="#template"></use><use x="3" y="3" xlink:href="#template"></use><use x="4" y="3" xlink:href="#template"></use><use x="6" y="3" xlink:href="#template"></use><use x="8" y="3" xlink:href="#template"></use><use x="9" y="3" xlink:href="#template"></use><use x="11" y="3" xlink:href="#template"></use><use x="12" y="3" xlink:href="#template"></use><use x="13" y="3" xlink:href="#template"></use><use x="14" y="3" xlink:href="#template"></use><use x="16" y="3" xlink:href="#template"></use><use x="18" y="3" xlink:href="#template"></use><use x="20" y="3" xlink:href="#template"></use><use x="21" y="3" xlink:href="#template"></use><use x="22" y="3" xlink:href="#template"></use><use x="24" y="3" xlink:href="#template"></use><use x="0" y="4" xlink:href="#template"></use><use x="2" y="4" xlink:href="#template"></use><use x="3" y="4" xlink:href="#template"></use><use x="4" y="4" xlink:href="#template"></use><use x="6" y="4" xlink:href="#template"></use><use x="8" y="4" xlink:href="#template"></use><use x="9" y="4" xlink:href="#template"></use><use x="12" y="4" xlink:href="#template"></use><use x="13" y="4" xlink:href="#template"></use><use x="14" y="4" xlink:href="#template"></use><use x="15" y="4" xlink:href="#template"></use><use x="16" y="4" xlink:href="#template"></use><use x="18" y="4" xlink:href="#template"></use><use x="20" y="4" xlink:href="#template"></use><use x="21" y="4" xlink:href="#template"></use><use x="22" y="4" xlink:href="#template"></use><use x="24" y="4" xlink:href="#template"></use><use x="0" y="5" xlink:href="#template"></use><use x="6" y="5" xlink:href="#template"></use><use x="8" y="5" xlink:href="#template"></use><use x="9" y="5" xlink:href="#template"></use><use x="12" y="5" xlink:href="#template"></use><use x="13" y="5" xlink:href="#template"></use><use x="15" y="5" xlink:href="#template"></use><use x="18" y="5" xlink:href="#template"></use><use x="24" y="5" xlink:href="#template"></use><use x="0" y="6" xlink:href="#template"></use><use x="1" y="6" xlink:href="#template"></use><use x="2" y="6" xlink:href="#template"></use><use x="3" y="6" xlink:href="#template"></use><use x="4" y="6" xlink:href="#template"></use><use x="5" y="6" xlink:href="#template"></use><use x="6" y="6" xlink:href="#template"></use><use x="8" y="6" xlink:href="#template"></use><use x="10" y="6" xlink:href="#template"></use><use x="12" y="6" xlink:href="#template"></use><use x="14" y="6" xlink:href="#template"></use><use x="16" y="6" xlink:href="#template"></use><use x="18" y="6" xlink:href="#template"></use><use x="19" y="6" xlink:href="#template"></use><use x="20" y="6" xlink:href="#template"></use><use x="21" y="6" xlink:href="#template"></use><use x="22" y="6" xlink:href="#template"></use><use x="23" y="6" xlink:href="#template"></use><use x="24" y="6" xlink:href="#template"></use><use x="10" y="7" xlink:href="#template"></use><use x="14" y="7" xlink:href="#template"></use><use x="3" y="8" xlink:href="#template"></use><use x="6" y="8" xlink:href="#template"></use><use x="10" y="8" xlink:href="#template"></use><use x="11" y="8" xlink:href="#template"></use><use x="14" y="8" xlink:href="#template"></use><use x="15" y="8" xlink:href="#template"></use><use x="16" y="8" xlink:href="#template"></use><use x="19" y="8" xlink:href="#template"></use><use x="20" y="8" xlink:href="#template"></use><use x="21" y="8" xlink:href="#template"></use><use x="23" y="8" xlink:href="#template"></use><use x="24" y="8" xlink:href="#template"></use><use x="0" y="9" xlink:href="#template"></use><use x="4" y="9" xlink:href="#template"></use><use x="5" y="9" xlink:href="#template"></use><use x="7" y="9" xlink:href="#template"></use><use x="8" y="9" xlink:href="#template"></use><use x="9" y="9" xlink:href="#template"></use><use x="10" y="9" xlink:href="#template"></use><use x="13" y="9" xlink:href="#template"></use><use x="17" y="9" xlink:href="#template"></use><use x="20" y="9" xlink:href="#template"></use><use x="21" y="9" xlink:href="#template"></use><use x="23" y="9" xlink:href="#template"></use><use x="24" y="9" xlink:href="#template"></use><use x="0" y="10" xlink:href="#template"></use><use x="1" y="10" xlink:href="#template"></use><use x="2" y="10" xlink:href="#template"></use><use x="5" y="10" xlink:href="#template"></use><use x="6" y="10" xlink:href="#template"></use><use x="8" y="10" xlink:href="#template"></use><use x="11" y="10" xlink:href="#template"></use><use x="12" y="10" xlink:href="#template"></use><use x="13" y="10" xlink:href="#template"></use><use x="18" y="10" xlink:href="#template"></use><use x="19" y="10" xlink:href="#template"></use><use x="21" y="10" xlink:href="#template"></use><use x="22" y="10" xlink:href="#template"></use><use x="23" y="10" xlink:href="#template"></use><use x="24" y="10" xlink:href="#template"></use><use x="0" y="11" xlink:href="#template"></use><use x="1" y="11" xlink:href="#template"></use><use x="2" y="11" xlink:href="#template"></use><use x="5" y="11" xlink:href="#template"></use><use x="7" y="11" xlink:href="#template"></use><use x="8" y="11" xlink:href="#template"></use><use x="9" y="11" xlink:href="#template"></use><use x="10" y="11" xlink:href="#template"></use><use x="11" y="11" xlink:href="#template"></use><use x="14" y="11" xlink:href="#template"></use><use x="15" y="11" xlink:href="#template"></use><use x="16" y="11" xlink:href="#template"></use><use x="17" y="11" xlink:href="#template"></use><use x="24" y="11" xlink:href="#template"></use><use x="0" y="12" xlink:href="#template"></use><use x="2" y="12" xlink:href="#template"></use><use x="3" y="12" xlink:href="#template"></use><use x="6" y="12" xlink:href="#template"></use><use x="7" y="12" xlink:href="#template"></use><use x="9" y="12" xlink:href="#template"></use><use x="11" y="12" xlink:href="#template"></use><use x="13" y="12" xlink:href="#template"></use><use x="14" y="12" xlink:href="#template"></use><use x="15" y="12" xlink:href="#template"></use><use x="18" y="12" xlink:href="#template"></use><use x="19" y="12" xlink:href="#template"></use><use x="20" y="12" xlink:href="#template"></use><use x="24" y="12" xlink:href="#template"></use><use x="3" y="13" xlink:href="#template"></use><use x="4" y="13" xlink:href="#template"></use><use x="5" y="13" xlink:href="#template"></use><use x="8" y="13" xlink:href="#template"></use><use x="10" y="13" xlink:href="#template"></use><use x="12" y="13" xlink:href="#template"></use><use x="13" y="13" xlink:href="#template"></use><use x="14" y="13" xlink:href="#template"></use><use x="15" y="13" xlink:href="#template"></use><use x="16" y="13" xlink:href="#template"></use><use x="24" y="13" xlink:href="#template"></use><use x="0" y="14" xlink:href="#template"></use><use x="2" y="14" xlink:href="#template"></use><use x="4" y="14" xlink:href="#template"></use><use x="5" y="14" xlink:href="#template"></use><use x="6" y="14" xlink:href="#template"></use><use x="7" y="14" xlink:href="#template"></use><use x="9" y="14" xlink:href="#template"></use><use x="10" y="14" xlink:href="#template"></use><use x="14" y="14" xlink:href="#template"></use><use x="19" y="14" xlink:href="#template"></use><use x="21" y="14" xlink:href="#template"></use><use x="24" y="14" xlink:href="#template"></use><use x="1" y="15" xlink:href="#template"></use><use x="2" y="15" xlink:href="#template"></use><use x="4" y="15" xlink:href="#template"></use><use x="7" y="15" xlink:href="#template"></use><use x="8" y="15" xlink:href="#template"></use><use x="9" y="15" xlink:href="#template"></use><use x="12" y="15" xlink:href="#template"></use><use x="13" y="15" xlink:href="#template"></use><use x="15" y="15" xlink:href="#template"></use><use x="17" y="15" xlink:href="#template"></use><use x="18" y="15" xlink:href="#template"></use><use x="19" y="15" xlink:href="#template"></use><use x="0" y="16" xlink:href="#template"></use><use x="1" y="16" xlink:href="#template"></use><use x="3" y="16" xlink:href="#template"></use><use x="6" y="16" xlink:href="#template"></use><use x="7" y="16" xlink:href="#template"></use><use x="11" y="16" xlink:href="#template"></use><use x="13" y="16" xlink:href="#template"></use><use x="16" y="16" xlink:href="#template"></use><use x="17" y="16" xlink:href="#template"></use><use x="18" y="16" xlink:href="#template"></use><use x="19" y="16" xlink:href="#template"></use><use x="20" y="16" xlink:href="#template"></use><use x="22" y="16" xlink:href="#template"></use><use x="24" y="16" xlink:href="#template"></use><use x="8" y="17" xlink:href="#template"></use><use x="9" y="17" xlink:href="#template"></use><use x="13" y="17" xlink:href="#template"></use><use x="14" y="17" xlink:href="#template"></use><use x="15" y="17" xlink:href="#template"></use><use x="16" y="17" xlink:href="#template"></use><use x="20" y="17" xlink:href="#template"></use><use x="23" y="17" xlink:href="#template"></use><use x="24" y="17" xlink:href="#template"></use><use x="0" y="18" xlink:href="#template"></use><use x="1" y="18" xlink:href="#template"></use><use x="2" y="18" xlink:href="#template"></use><use x="3" y="18" xlink:href="#template"></use><use x="4" y="18" xlink:href="#template"></use><use x="5" y="18" xlink:href="#template"></use><use x="6" y="18" xlink:href="#template"></use><use x="13" y="18" xlink:href="#template"></use><use x="16" y="18" xlink:href="#template"></use><use x="18" y="18" xlink:href="#template"></use><use x="20" y="18" xlink:href="#template"></use><use x="22" y="18" xlink:href="#template"></use><use x="23" y="18" xlink:href="#template"></use><use x="24" y="18" xlink:href="#template"></use><use x="0" y="19" xlink:href="#template"></use><use x="6" y="19" xlink:href="#template"></use><use x="9" y="19" xlink:href="#template"></use><use x="10" y="19" xlink:href="#template"></use><use x="11" y="19" xlink:href="#template"></use><use x="12" y="19" xlink:href="#template"></use><use x="14" y="19" xlink:href="#template"></use><use x="16" y="19" xlink:href="#template"></use><use x="20" y="19" xlink:href="#template"></use><use x="22" y="19" xlink:href="#template"></use><use x="23" y="19" xlink:href="#template"></use><use x="24" y="19" xlink:href="#template"></use><use x="0" y="20" xlink:href="#template"></use><use x="2" y="20" xlink:href="#template"></use><use x="3" y="20" xlink:href="#template"></use><use x="4" y="20" xlink:href="#template"></use><use x="6" y="20" xlink:href="#template"></use><use x="14" y="20" xlink:href="#template"></use><use x="15" y="20" xlink:href="#template"></use><use x="16" y="20" xlink:href="#template"></use><use x="17" y="20" xlink:href="#template"></use><use x="18" y="20" xlink:href="#template"></use><use x="19" y="20" xlink:href="#template"></use><use x="20" y="20" xlink:href="#template"></use><use x="24" y="20" xlink:href="#template"></use><use x="0" y="21" xlink:href="#template"></use><use x="2" y="21" xlink:href="#template"></use><use x="3" y="21" xlink:href="#template"></use><use x="4" y="21" xlink:href="#template"></use><use x="6" y="21" xlink:href="#template"></use><use x="8" y="21" xlink:href="#template"></use><use x="9" y="21" xlink:href="#template"></use><use x="10" y="21" xlink:href="#template"></use><use x="12" y="21" xlink:href="#template"></use><use x="13" y="21" xlink:href="#template"></use><use x="15" y="21" xlink:href="#template"></use><use x="16" y="21" xlink:href="#template"></use><use x="18" y="21" xlink:href="#template"></use><use x="19" y="21" xlink:href="#template"></use><use x="23" y="21" xlink:href="#template"></use><use x="0" y="22" xlink:href="#template"></use><use x="2" y="22" xlink:href="#template"></use><use x="3" y="22" xlink:href="#template"></use><use x="4" y="22" xlink:href="#template"></use><use x="6" y="22" xlink:href="#template"></use><use x="10" y="22" xlink:href="#template"></use><use x="12" y="22" xlink:href="#template"></use><use x="15" y="22" xlink:href="#template"></use><use x="16" y="22" xlink:href="#template"></use><use x="18" y="22" xlink:href="#template"></use><use x="21" y="22" xlink:href="#template"></use><use x="24" y="22" xlink:href="#template"></use><use x="0" y="23" xlink:href="#template"></use><use x="6" y="23" xlink:href="#template"></use><use x="9" y="23" xlink:href="#template"></use><use x="13" y="23" xlink:href="#template"></use><use x="19" y="23" xlink:href="#template"></use><use x="21" y="23" xlink:href="#template"></use><use x="0" y="24" xlink:href="#template"></use><use x="1" y="24" xlink:href="#template"></use><use x="2" y="24" xlink:href="#template"></use><use x="3" y="24" xlink:href="#template"></use><use x="4" y="24" xlink:href="#template"></use><use x="5" y="24" xlink:href="#template"></use><use x="6" y="24" xlink:href="#template"></use><use x="9" y="24" xlink:href="#template"></use><use x="12" y="24" xlink:href="#template"></use><use x="16" y="24" xlink:href="#template"></use><use x="17" y="24" xlink:href="#template"></use><use x="18" y="24" xlink:href="#template"></use><use x="19" y="24" xlink:href="#template"></use><use x="22" y="24" xlink:href="#template"></use><use x="23" y="24" xlink:href="#template"></use><use x="24" y="24" xlink:href="#template"></use></svg></div></div><div tabindex="1" class="hiprint-printElement hiprint-printElement-text" style="position: absolute; width: 120pt; height: 9.75pt; font-family: &quot;Microsoft YaHei&quot;; font-weight: bold; left: 6pt; top: 57pt;"><div class="hiprint-printElement-text-content hiprint-printElement-content" style="height:100%;width:100%">财务资产名：联想台式机</div></div><div tabindex="1" class="hiprint-printElement hiprint-printElement-text" style="position: absolute; width: 120pt; height: 9.75pt; font-family: &quot;Microsoft YaHei&quot;; font-weight: bolder; left: 6pt; top: 73.5pt;"><div class="hiprint-printElement-text-content hiprint-printElement-content" style="height:100%;width:100%">资产类型：台式计算机</div></div><div tabindex="1" class="hiprint-printElement hiprint-printElement-text" style="position: absolute; width: 120pt; height: 9.75pt; font-family: &quot;Microsoft YaHei&quot;; font-size: 12pt; font-weight: bolder; left: 1.5pt; top: 93pt;"><div class="hiprint-printElement-text-content hiprint-printElement-content" style="height:100%;width:100%">保管人：李文明</div></div><span class="hiprint-paperNumber" style="position: absolute; top: -819pt; left: -565pt; display: none;">1</span></div></div></div></div>', '资产卡片配置'),
(5, 'bgskapian', '{"title":"WDSW资产卡片","ma":"0","bianma":"zcbh","content":["zcbh","zclx","bgr"]}', '', NULL, ''),
(6, 'wgbkapian', '{"title":"WDSW资产卡片","ma":"0","bianma":"xlh","content":["zcbh","zclx","bgr"]}', '{"panels":[{"index":0,"height":40,"width":80,"paperHeader":-1400,"paperFooter":113.38582677165356,"printElements":[{"tid":"configModule.name","options":{"left":85.5,"top":4.5,"height":28,"width":150,"fontSize":15,"fontWeight":"600","textAlign":"center","lineHeight":28,"hideTitle":true,"field":"name","testData":"WDSW资产卡片"}},{"tid":"configModule.like","options":{"left":9,"top":40.5,"height":9.75,"width":120,"title":"资产类型","field":"zclx","testData":"台式计算机"}},{"tid":"configModule.gender","options":{"left":7.5,"top":54,"height":9.75,"width":120,"title":"资产编号","field":"zcbh","testData":"A202010104321"}},{"tid":"configModule.email","options":{"left":9,"top":69,"height":9.75,"width":120,"title":"保管人","field":"bgr","testData":"李文明"}},{"tid":"configModule.barcode","options":{"left":42,"top":88.5,"height":15,"width":150,"textAlign":"center","textType":"barcode","fontFamily":"Microsoft YaHei","hideTitle":"true","barcodeMode":"CODE128","field":"txm","title":"321","testData":"321"}}],"paperNumberLeft":-565,"paperNumberTop":-819,"paperNumberDisabled":true,"paperNumberFormat":"paperCount"}]}', NULL, '');

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

--
-- 表的结构 `danwei`
--

CREATE TABLE IF NOT EXISTS `danwei` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '单位名',
  `status` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态'
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `danwei` (`id`, `name`, `status`) VALUES
(1, '党组', 1),
(2, '办公室', 1);



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

--
-- 表的结构 `haocai`
--

CREATE TABLE IF NOT EXISTS `haocai` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '什么东西',
  `pp` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '品牌',
  `gg` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '规格',
  `dj` decimal(10,2) unsigned NOT NULL COMMENT '单价',
  `num` int(10) unsigned NOT NULL COMMENT '剩余数量',
  `zs` int(10) unsigned NOT NULL COMMENT '入库数量',
  `rksj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 表的结构 `juese`
--

CREATE TABLE IF NOT EXISTS `juese` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '角色名',
  `value` varchar(1024) CHARACTER SET utf8mb4 NOT NULL COMMENT '权限菜单ID',
  `bm` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '权限部门ID，0：全局（废弃）',
  `shanchu` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否具有删除权限',
  `xiugai` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否具有修改权限',
  `status` int(1) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `juese` (`id`, `name`, `value`, `bm`, `shanchu`, `xiugai`, `status`) VALUES
(1, '管理员', '4,5,6,7,8,9,10,36,29,30,34,35,11,12,14,13,23,26,32,15,16,18,17,24,27,31,19,20,22,21,25,28,33,37,38,39,40,41,', 0, 1, 1, 1),
(10, '信息安全员_查询', '11,12,14,', 0, 0, 1, 1),
(11, '信息资产管理员', '11,12,14,13,23,26,32,', 0, 0, 0, 1),
(12, '信息管理', '11,12,14,13,23,26,32,37,38,39,40,41,', 0, 1, 1, 1);

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

--
-- 表的结构 `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `id` bigint(12) unsigned NOT NULL,
  `user` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '用户',
  `action` varchar(1024) CHARACTER SET utf8mb4 NOT NULL COMMENT '所执行的操作',
  `ip` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IP',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='日志';

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

--
-- 表的结构 `shanchu`
--

CREATE TABLE IF NOT EXISTS `shanchu` (
  `id` bigint(12) NOT NULL COMMENT 'id',
  `zcbh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产编号',
  `xlh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '序列号',
  `zclx` int(10) unsigned NOT NULL COMMENT '资产类型',
  `cw` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '财务资产名',
  `zczt` int(10) unsigned NOT NULL COMMENT '资产状态',
  `bm` int(10) unsigned NOT NULL COMMENT '所属单位',
  `bgr` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '保管人',
  `dz` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '保存地址',
  `cgsj` int(10) unsigned DEFAULT NULL COMMENT '采购时间',
  `rzsj` int(10) unsigned DEFAULT NULL COMMENT '入账时间',
  `zbsc` int(2) DEFAULT NULL COMMENT '质保时长（年）',
  `sysc` int(2) DEFAULT NULL COMMENT '报废年限（年）',
  `pp` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '品牌',
  `xh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `zcly` varchar(10) CHARACTER SET utf8mb4 DEFAULT '自购' COMMENT '资产来源',
  `zcjz` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '资产价值',
  `gg` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '规格',
  `bz` text CHARACTER SET utf8mb4 COMMENT '备注',
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产图片',
  `wlbs` int(1) unsigned DEFAULT NULL COMMENT '网络标识',
  `ip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IP地址',
  `xsq` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '显示器信息',
  `yp` int(5) unsigned DEFAULT NULL COMMENT '硬盘信息',
  `nc` int(5) unsigned DEFAULT NULL COMMENT '内存信息',
  `ll` mediumtext CHARACTER SET utf8mb4 COMMENT '履历',
  `dotime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后操作时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='信息中心资产数据表';

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

--
-- 表的结构 `system_menu`
--

CREATE TABLE IF NOT EXISTS `system_menu` (
  `id` int(11) unsigned NOT NULL COMMENT 'ID',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  `icon` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单图标',
  `href` varchar(100) NOT NULL DEFAULT '' COMMENT '链接',
  `target` varchar(20) NOT NULL DEFAULT '_self' COMMENT '链接打开方式',
  `sort` int(11) DEFAULT '0' COMMENT '菜单排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注信息',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `delete_at` timestamp NULL DEFAULT NULL COMMENT '删除时间'
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统菜单表';

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

INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `href`, `target`, `sort`, `status`, `remark`, `create_at`, `update_at`, `delete_at`) VALUES
(4, 0, '系统管理', 'fa fa-address-book', '', '_self', 4, 1, '', '2020-10-23 02:04:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 4, '系统设置', 'fa fa-gears', '', '_self', 3, 1, '', '2020-10-23 02:04:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 5, '角色管理', 'fa fa-user-secret', 'page/juese.php', '_self', 5, 1, '', '2020-10-23 02:04:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 5, '用户管理', 'fa fa-user', 'page/user.php', '_self', 4, 1, '', '2020-10-23 02:04:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 5, '单位管理', 'fa fa-bank', 'page/danwei.php', '_self', 3, 1, '', '2020-10-23 02:04:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 5, '资产类型', 'fa fa-joomla', 'page/leixing.php', '_self', 2, 1, '', '2020-10-23 02:04:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 5, '资产状态', 'fa fa-cube', 'page/zhuangtai.php', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 0, '信息中心资产', 'fa fa-address-book', '', '_self', 3, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 11, '资产管理', 'fa fa-newspaper-o', '', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 12, '信息资产录入', 'fa fa-plus-square', 'page/add_xinxi.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 12, '信息资产查询', 'fa fa-search', 'page/search_xinxi.php', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 0, '物管办资产', 'fa fa-address-book', '', '_self', 2, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 15, '资产管理', 'fa fa-newspaper-o', '', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 16, '资产录入', 'fa fa-plus-square', 'page/add_wgb.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 16, '资产查询', 'fa fa-search', 'page/search_wgb.php', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 0, '办公室资产', 'fa fa-address-book', '', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 19, '资产管理', 'fa fa-newspaper-o', '', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 20, '资产录入', 'fa fa-plus-square', 'page/add_bgs.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 20, '资产查询', 'fa fa-search', 'page/search_bgs.php', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 11, '系统设置', 'fa fa-newspaper-o', '', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 15, '系统设置', 'fa fa-newspaper-o', '', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 19, '系统设置', 'fa fa-newspaper-o', '', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 23, '资产类型', 'fa fa-newspaper-o', 'page/xxzclx.php', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, 24, '资产类型', 'fa fa-newspaper-o', 'page/wgbzclx.php', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, 25, '资产类型', 'fa fa-newspaper-o', 'page/bgszclx.php', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, 4, '系统日志', 'fa fa-file-text', '', '_self', 2, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, 29, '操作日志', 'fa fa-file-text-o', 'page/log.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 24, '参数设置', 'fa fa-sun-o', 'page/canshu.php?zz=3', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, 23, '参数设置', 'fa fa-sun-o', 'page/canshu.php?zz=1', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, 25, '参数设置', 'fa fa-sun-o', 'page/canshu.php?zz=2', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, 4, '数据安全', 'fa fa-database', '', '_self', 1, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 34, '备份导出', 'fa fa-download', 'page/sqlbackup.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 5, '菜单管理', 'fa fa-newspaper-o', 'page/menu.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 0, '耗材管理', 'fa fa-newspaper-o', '', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 37, '耗材管理', 'fa fa-newspaper-o', '', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 38, '入库', 'fa fa-sign-in', 'page/ruku.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, 38, '出库', 'fa fa-sign-out', 'page/chuku.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, 38, '盘点', 'fa fa-eye', 'page/pandian.php', '_self', 0, 1, '', '2020-10-23 02:04:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- 表的结构 `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL,
  `username` varchar(128) CHARACTER SET utf8mb4 NOT NULL COMMENT '用户名',
  `password` varchar(1024) CHARACTER SET utf8mb4 NOT NULL COMMENT '密码',
  `juese` int(2) unsigned NOT NULL COMMENT '角色ID',
  `bm` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '权限部门ID，0：全局',
  `status` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态'
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户信息表';

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

INSERT INTO `user` (`id`, `username`, `password`, `juese`, `bm`, `status`) VALUES
(1, 'admin', 'sha512:10000:24:hXJefLjmwWFX4gcbuo3+/gHyJoAV8FFd:/JDiHC7RyWfjJljsshZZvKcx1KJFoCK+', 1, '0', 1);

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

--
-- 表的结构 `wgbzichan`
--

CREATE TABLE IF NOT EXISTS `wgbzichan` (
  `id` bigint(12) NOT NULL COMMENT 'id',
  `zcbh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产编号',
  `xlh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '序列号',
  `zclx` int(10) unsigned NOT NULL COMMENT '资产类型',
  `cw` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zczt` int(10) unsigned NOT NULL COMMENT '资产状态',
  `bm` int(10) unsigned NOT NULL COMMENT '所属单位',
  `bgr` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '保管人',
  `dz` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '保存地址',
  `cgsj` int(10) unsigned DEFAULT NULL COMMENT '采购时间',
  `rzsj` int(10) unsigned DEFAULT NULL COMMENT '入账时间',
  `zbsc` int(2) DEFAULT NULL COMMENT '质保时长（年）',
  `sysc` int(2) DEFAULT NULL COMMENT '报废年限（年）',
  `pp` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '品牌',
  `xh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `zcly` varchar(10) CHARACTER SET utf8mb4 DEFAULT '自购' COMMENT '资产来源',
  `zcjz` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '资产价值',
  `gg` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '规格',
  `bz` text CHARACTER SET utf8mb4 COMMENT '备注',
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产图片',
  `ll` text CHARACTER SET utf8mb4 COMMENT '履历'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='物管办资产数据表';

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

--
-- 表的结构 `xinxizichan`
--

CREATE TABLE IF NOT EXISTS `xinxizichan` (
  `id` bigint(12) NOT NULL COMMENT 'id',
  `zcbh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产编号',
  `xlh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '序列号',
  `zclx` int(10) unsigned NOT NULL COMMENT '资产类型',
  `cw` varchar(512) CHARACTER SET utf8mb4 NOT NULL COMMENT '财务资产名',
  `zczt` int(10) unsigned NOT NULL COMMENT '资产状态',
  `bm` int(10) unsigned NOT NULL COMMENT '所属单位',
  `bgr` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '保管人',
  `dz` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '保存地址',
  `cgsj` int(10) unsigned DEFAULT NULL COMMENT '采购时间',
  `rzsj` int(10) unsigned DEFAULT NULL COMMENT '入账时间',
  `zbsc` int(2) DEFAULT NULL COMMENT '质保时长（年）',
  `sysc` int(2) DEFAULT NULL COMMENT '报废年限（年）',
  `pp` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '品牌',
  `xh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `zcly` varchar(10) CHARACTER SET utf8mb4 DEFAULT '自购' COMMENT '资产来源',
  `zcjz` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '资产价值',
  `gg` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '规格',
  `bz` text CHARACTER SET utf8mb4 COMMENT '备注',
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资产图片',
  `wlbs` int(1) unsigned DEFAULT NULL COMMENT '网络标识',
  `ip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IP地址',
  `xsq` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '显示器信息',
  `yp` int(5) unsigned DEFAULT NULL COMMENT '硬盘信息',
  `nc` int(5) unsigned DEFAULT NULL COMMENT '内存信息',
  `ll` mediumtext CHARACTER SET utf8mb4 COMMENT '履历',
  `dotime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后操作时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='信息中心资产数据表';

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

--
-- 表的结构 `zclx`
--

CREATE TABLE IF NOT EXISTS `zclx` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '资产类型名称',
  `zcfl` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '资产分组，0：管理员管理的；1：信息中心管理的；2：办公室管理的；3：物管办管理的',
  `status` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态'
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='资产类型';

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

INSERT INTO `zclx` (`id`, `name`, `zcfl`, `status`) VALUES
(1, '台式电脑', 1, 1),
(2, '笔记本电脑', 1, 1),
(3, '电脑一体机', 1, 1),
(4, '激光打印机', 1, 1),
(5, '针式打印机', 1, 1),
(6, '打复印一体机', 1, 1),
(7, '交换机', 1, 1),
(8, '路由器', 1, 1),
(9, '防火墙', 1, 1),
(10, '服务器', 1, 1),
(11, '投影仪', 1, 1),
(12, '会议终端', 1, 1),
(18, '电视机', 3, 1),
(35, '扫码枪', 1, 1),
(34, '自助机', 1, 1),
(33, '执法记录仪', 1, 1),
(32, '碎纸机', 1, 1),
(31, '扫描仪', 1, 1),
(30, '高拍仪', 1, 1),
(36, '自助办税终端', 1, 1),
(37, '摄像头', 1, 1),
(38, '地点', 2, 1);

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

--
-- 表的结构 `zhuangtai`
--

CREATE TABLE IF NOT EXISTS `zhuangtai` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '状态名',
  `status` int(1) unsigned NOT NULL DEFAULT '1',
  `icon` varchar(64) CHARACTER SET utf8mb4 NOT NULL COMMENT '图标',
  `color` varchar(64) CHARACTER SET utf8mb4 NOT NULL COMMENT '颜色'
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `zhuangtai` (`id`, `name`, `status`, `icon`, `color`) VALUES
(1, '在用', 1, 'fa-circle', '#06f530'),
(2, '未分配', 1, 'fa-circle-o', '#0352f5'),
(3, '报废在用', 1, 'fa-dot-circle-o', '#f58e0b'),
(4, '报废待处置', 1, 'fa-adjust', '#d60af3'),
(5, '报废已处置', 1, 'fa-ban', '#f50606'),
(6, '借出', 1, 'fa-stop-circle', '#1aa094');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `system_menu`
--
ALTER TABLE `system_menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `title` (`title`),
  ADD KEY `href` (`href`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `backup`
--
ALTER TABLE `backup`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bgszichan`
--
ALTER TABLE `bgszichan`
  MODIFY `id` bigint(12) NOT NULL AUTO_INCREMENT COMMENT 'id';
--
-- AUTO_INCREMENT for table `chuku`
--
ALTER TABLE `chuku`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `config`
--
ALTER TABLE `config`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `danwei`
--
ALTER TABLE `danwei`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `haocai`
--
ALTER TABLE `haocai`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `juese`
--
ALTER TABLE `juese`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `system_menu`
--
ALTER TABLE `system_menu`
  MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',AUTO_INCREMENT=42;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT for table `wgbzichan`
--
ALTER TABLE `wgbzichan`
  MODIFY `id` bigint(12) NOT NULL AUTO_INCREMENT COMMENT 'id';
--
-- AUTO_INCREMENT for table `xinxizichan`
--
ALTER TABLE `xinxizichan`
  MODIFY `id` bigint(12) NOT NULL AUTO_INCREMENT COMMENT 'id';
--
-- AUTO_INCREMENT for table `zclx`
--
ALTER TABLE `zclx`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=39;
--
-- AUTO_INCREMENT for table `zhuangtai`
--
ALTER TABLE `zhuangtai`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
/*!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 */;
