cld/dongleerp.sql

-- phpMyAdmin SQL Dump
-- version 4.0.10.17
-- https://www.phpmyadmin.net
--
-- 主机: 192.168.73.139
-- 生成日期: 2017-02-24 10:32:39
-- 服务器版本: 5.1.73
-- PHP 版本: 5.5.37

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

--
-- 数据库: `dongleerp`
--

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

--
-- 表的结构 `CLD_accountItem`
--

CREATE TABLE IF NOT EXISTS `CLD_accountItem` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(160) NOT NULL,
  `name` varchar(160) NOT NULL,
  PRIMARY KEY (`aid`),
  UNIQUE KEY `aid` (`aid`),
  UNIQUE KEY `aid_2` (`aid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;

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

--
-- 表的结构 `CLD_action_log`
--

CREATE TABLE IF NOT EXISTS `CLD_action_log` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `updatetime` varchar(20) NOT NULL,
  `time` varchar(40) NOT NULL,
  `action` varchar(250) NOT NULL,
  `class` varchar(40) NOT NULL,
  `sid` int(10) NOT NULL,
  `cid` int(10) NOT NULL,
  `status` int(2) NOT NULL,
  `districtid` varchar(20) NOT NULL,
  `city` varchar(25) NOT NULL,
  `province` varchar(25) NOT NULL,
  `nature` varchar(25) NOT NULL,
  `company` varchar(160) NOT NULL,
  PRIMARY KEY (`aid`),
  UNIQUE KEY `aid` (`aid`),
  KEY `sid` (`sid`),
  KEY `updatetime` (`updatetime`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=360589 ;

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

--
-- 表的结构 `CLD_client`
--

CREATE TABLE IF NOT EXISTS `CLD_client` (
  `cid` int(10) NOT NULL AUTO_INCREMENT,
  `gender` varchar(2) NOT NULL,
  `nicename` varchar(40) NOT NULL,
  `qq` varchar(40) NOT NULL,
  `telephone` varchar(35) NOT NULL,
  `phone` varchar(45) NOT NULL,
  `email` varchar(80) NOT NULL,
  `clientname` varchar(40) NOT NULL,
  `keynum` varchar(160) NOT NULL,
  `companyid` int(10) NOT NULL,
  `companyname` varchar(120) NOT NULL,
  `unit` varchar(90) NOT NULL,
  `area` varchar(100) NOT NULL,
  `nature` varchar(400) NOT NULL,
  `local` varchar(35) NOT NULL,
  `fax` varchar(40) NOT NULL,
  `webservice` varchar(60) NOT NULL,
  `department` varchar(30) NOT NULL,
  `position` varchar(30) NOT NULL,
  `office` varchar(30) NOT NULL,
  `address` tinytext NOT NULL,
  `district` varchar(20) NOT NULL,
  `tag` varchar(15) NOT NULL,
  `ride` text NOT NULL,
  `stay` tinytext NOT NULL,
  `landmarks` tinytext NOT NULL,
  `mark` tinytext NOT NULL,
  `priority` int(10) NOT NULL DEFAULT '5',
  `updatetime` int(10) NOT NULL,
  `servicetime` int(10) NOT NULL,
  PRIMARY KEY (`cid`),
  UNIQUE KEY `cid` (`cid`),
  KEY `cid_2` (`cid`),
  KEY `servicetime` (`servicetime`),
  KEY `updatetime` (`updatetime`),
  KEY `cid_3` (`cid`),
  KEY `cid_4` (`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=76295 ;

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

--
-- 表的结构 `CLD_client_staff`
--

CREATE TABLE IF NOT EXISTS `CLD_client_staff` (
  `csid` int(10) NOT NULL AUTO_INCREMENT,
  `sid` int(10) NOT NULL,
  `cid` int(10) NOT NULL,
  PRIMARY KEY (`csid`),
  UNIQUE KEY `csid` (`csid`),
  KEY `sid` (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=77139 ;

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

--
-- 表的结构 `CLD_company`
--

CREATE TABLE IF NOT EXISTS `CLD_company` (
  `cid` int(10) NOT NULL AUTO_INCREMENT,
  `stay` tinytext NOT NULL,
  `staffid` int(10) NOT NULL,
  `companyname` varchar(80) NOT NULL,
  `nature` varchar(600) NOT NULL,
  `local` varchar(60) NOT NULL,
  `fax` varchar(30) NOT NULL,
  `webservice` varchar(40) NOT NULL,
  `department` varchar(30) NOT NULL,
  `position` varchar(40) NOT NULL,
  `office` varchar(40) NOT NULL,
  `address` tinytext NOT NULL,
  `ride` tinytext NOT NULL,
  `district` varchar(35) NOT NULL,
  `landmarks` tinytext NOT NULL,
  PRIMARY KEY (`cid`),
  UNIQUE KEY `cid` (`cid`),
  KEY `cid_2` (`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23024 ;

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

--
-- 表的结构 `CLD_C_tooltip`
--

CREATE TABLE IF NOT EXISTS `CLD_C_tooltip` (
  `tip` int(10) NOT NULL AUTO_INCREMENT,
  `sid` int(10) NOT NULL,
  `cateid` int(10) NOT NULL,
  `name` varchar(60) NOT NULL,
  `cid` int(10) NOT NULL,
  PRIMARY KEY (`tip`),
  UNIQUE KEY `tip` (`tip`),
  KEY `tip_2` (`tip`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5401 ;

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

--
-- 表的结构 `CLD_district`
--

CREATE TABLE IF NOT EXISTS `CLD_district` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `level` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `usetype` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `upid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `displayorder` smallint(6) NOT NULL DEFAULT '0',
  `area` tinyint(4) NOT NULL COMMENT '所属区域',
  PRIMARY KEY (`id`),
  KEY `upid` (`upid`,`displayorder`),
  KEY `level` (`level`),
  KEY `level_2` (`level`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45098 ;

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

--
-- 表的结构 `CLD_district_staff`
--

CREATE TABLE IF NOT EXISTS `CLD_district_staff` (
  `dsid` int(20) NOT NULL AUTO_INCREMENT,
  `did` int(20) NOT NULL,
  `sid` int(20) NOT NULL,
  PRIMARY KEY (`dsid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=76295 ;

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

--
-- 表的结构 `CLD_eMailJournal`
--

CREATE TABLE IF NOT EXISTS `CLD_eMailJournal` (
  `ejid` int(10) NOT NULL AUTO_INCREMENT,
  `clientId` int(10) NOT NULL,
  `etid` int(10) NOT NULL COMMENT '邮件模板',
  `status` int(2) NOT NULL COMMENT '邮件发送状态(0,1)',
  `date` date NOT NULL,
  `email` varchar(280) NOT NULL,
  `title` varchar(180) NOT NULL,
  `clientName` varchar(180) NOT NULL,
  PRIMARY KEY (`ejid`),
  UNIQUE KEY `ejid` (`ejid`),
  KEY `ejid_2` (`ejid`),
  KEY `ejid_3` (`ejid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=216781 ;

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

--
-- 表的结构 `CLD_eMailList`
--

CREATE TABLE IF NOT EXISTS `CLD_eMailList` (
  `elid` int(11) NOT NULL AUTO_INCREMENT,
  `clientEmail` longtext NOT NULL COMMENT '目标客户邮件列表',
  `clientEmail2` longtext NOT NULL,
  `clientEmail3` longtext NOT NULL,
  `clientName2` longtext NOT NULL,
  `clientName3` longtext NOT NULL,
  `examine` int(2) NOT NULL,
  `mark` varchar(70) NOT NULL,
  `clientName` longtext NOT NULL,
  `illegalEmail` longtext NOT NULL,
  `sendEmail` longtext NOT NULL,
  `etid` int(10) NOT NULL,
  `templateName` varchar(40) NOT NULL,
  `eTitle` tinytext NOT NULL,
  `html` text NOT NULL,
  `content` text NOT NULL,
  `info` text NOT NULL,
  `annex` text NOT NULL,
  `annexName` varchar(120) NOT NULL,
  `staffId` int(10) NOT NULL,
  `staffName` varchar(180) NOT NULL,
  `tag` tinytext NOT NULL,
  `status` int(2) NOT NULL DEFAULT '0',
  `send1` int(2) NOT NULL,
  `send2` int(2) NOT NULL,
  `send3` int(2) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`elid`),
  UNIQUE KEY `elid` (`elid`),
  KEY `elid_2` (`elid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=347 ;

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

--
-- 表的结构 `CLD_eMailTemplate`
--

CREATE TABLE IF NOT EXISTS `CLD_eMailTemplate` (
  `etid` int(10) NOT NULL AUTO_INCREMENT,
  `staffId` int(10) NOT NULL,
  `staffName` varchar(180) NOT NULL,
  `title` tinytext NOT NULL,
  `content` text NOT NULL,
  `html` text NOT NULL,
  `skin` varchar(50) NOT NULL COMMENT '皮肤',
  `annex` varchar(180) NOT NULL COMMENT '附件',
  `annexName` varchar(120) NOT NULL,
  `tag` tinytext NOT NULL,
  `status` int(10) NOT NULL COMMENT '发送状态',
  PRIMARY KEY (`etid`),
  UNIQUE KEY `etid` (`etid`),
  KEY `etid_2` (`etid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=421 ;

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

--
-- 表的结构 `cld_enclosur`
--

CREATE TABLE IF NOT EXISTS `cld_enclosur` (
  `eid` int(10) NOT NULL AUTO_INCREMENT,
  `rid` int(10) NOT NULL,
  `name` varchar(60) NOT NULL,
  PRIMARY KEY (`eid`),
  UNIQUE KEY `eid` (`eid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `CLD_execute`
--

CREATE TABLE IF NOT EXISTS `CLD_execute` (
  `eid` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(160) NOT NULL,
  `staff` mediumtext NOT NULL,
  `mold` varchar(160) NOT NULL,
  PRIMARY KEY (`eid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

--
-- 表的结构 `CLD_executeCopy`
--

CREATE TABLE IF NOT EXISTS `CLD_executeCopy` (
  `ecid` int(10) NOT NULL AUTO_INCREMENT,
  `staff` mediumtext NOT NULL,
  `eid` int(10) NOT NULL,
  `rid` int(10) NOT NULL,
  PRIMARY KEY (`ecid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `CLD_itemStatistics`
--

CREATE TABLE IF NOT EXISTS `CLD_itemStatistics` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL,
  `staff` int(11) NOT NULL,
  `price` decimal(12,2) NOT NULL,
  `itemCategory` varchar(60) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`sid`),
  UNIQUE KEY `sid` (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7152 ;

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

--
-- 表的结构 `CLD_loanReceipt`
--

CREATE TABLE IF NOT EXISTS `CLD_loanReceipt` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `accountItem` mediumtext NOT NULL,
  `loanItem` mediumtext NOT NULL,
  `staff` int(11) NOT NULL,
  `sum` decimal(12,2) NOT NULL,
  `loanSum` decimal(12,2) NOT NULL,
  `date` date NOT NULL,
  `pastDate` date NOT NULL,
  `cid` int(11) NOT NULL COMMENT '办事处',
  `status` int(11) NOT NULL COMMENT '1同意2审批中3退回4编辑',
  `Rtype` int(2) NOT NULL COMMENT '报销单类型',
  `reviseDetail` text NOT NULL,
  `revisePrice` decimal(12,2) NOT NULL,
  `receiptOrder` varchar(60) NOT NULL,
  `verify` varchar(400) NOT NULL,
  `verifyStaff` text NOT NULL COMMENT 'status ：1同意 3不同意 4等待',
  `nowStaff` varchar(20) NOT NULL,
  `verifyBreakup` text NOT NULL,
  `explanation` text NOT NULL,
  `notice` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

--
-- 表的结构 `CLD_longle`
--

CREATE TABLE IF NOT EXISTS `CLD_longle` (
  `lid` int(10) NOT NULL AUTO_INCREMENT,
  `year` int(10) NOT NULL,
  `cid` int(10) NOT NULL,
  `category` varchar(80) NOT NULL,
  `status` int(10) NOT NULL DEFAULT '1' COMMENT '1:生成 2:接收 3:借出 4:销售 5:升级 6:更换 7:收回',
  `statuslog` varchar(25) NOT NULL,
  `statusT` varchar(30) NOT NULL,
  `key_num` varchar(20) NOT NULL,
  `SerialNumber` varchar(120) NOT NULL,
  `product` varchar(40) NOT NULL,
  `alloted_time` varchar(35) NOT NULL,
  `product_id` int(11) NOT NULL,
  `make_day` varchar(60) NOT NULL,
  `responsible` varchar(40) NOT NULL,
  `version` varchar(80) NOT NULL,
  `client` varchar(40) NOT NULL,
  `clientid` int(10) NOT NULL,
  PRIMARY KEY (`lid`),
  UNIQUE KEY `lid` (`lid`),
  KEY `cid` (`cid`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37089 ;

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

--
-- 表的结构 `CLD_longlelog`
--

CREATE TABLE IF NOT EXISTS `CLD_longlelog` (
  `logid` int(10) NOT NULL AUTO_INCREMENT,
  `lid` int(10) NOT NULL,
  `status` int(10) NOT NULL COMMENT '8:备注',
  `statusT` varchar(30) NOT NULL,
  `sell_client` varchar(40) NOT NULL,
  `client` varchar(40) NOT NULL,
  `clientid` int(10) NOT NULL,
  `responsible` varchar(40) NOT NULL COMMENT '责任员',
  `operator` varchar(40) NOT NULL COMMENT '操作员',
  `product_id` int(10) NOT NULL,
  `product` varchar(50) NOT NULL,
  `category` varchar(40) NOT NULL COMMENT '办事处',
  `new_key_num` varchar(60) NOT NULL,
  `mark` varchar(500) NOT NULL,
  `dateline` varchar(60) NOT NULL,
  PRIMARY KEY (`logid`),
  UNIQUE KEY `logid` (`logid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=105344 ;

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

--
-- 表的结构 `CLD_L_category`
--

CREATE TABLE IF NOT EXISTS `CLD_L_category` (
  `cid` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL,
  `defult` int(11) NOT NULL,
  `districtid` int(10) NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;

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

--
-- 表的结构 `CLD_office_area`
--

CREATE TABLE IF NOT EXISTS `CLD_office_area` (
  `oaid` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`oaid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `CLD_product`
--

CREATE TABLE IF NOT EXISTS `CLD_product` (
  `pid` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL,
  `typeid` int(2) NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;

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

--
-- 表的结构 `CLD_receipt`
--

CREATE TABLE IF NOT EXISTS `CLD_receipt` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `accountItem` mediumtext NOT NULL,
  `loanItem` mediumtext NOT NULL,
  `staff` int(11) NOT NULL,
  `sum` decimal(12,2) NOT NULL,
  `loanSum` decimal(10,0) NOT NULL,
  `date` date NOT NULL,
  `pastDate` date NOT NULL,
  `executeDate` date NOT NULL,
  `cid` int(11) NOT NULL COMMENT '办事处',
  `status` int(11) NOT NULL COMMENT '1同意2审批中3退回4编辑',
  `Rtype` int(2) NOT NULL,
  `isBK` int(2) NOT NULL,
  `reviseDetail` text NOT NULL,
  `revisePrice` decimal(12,2) NOT NULL,
  `receiptOrder` varchar(60) NOT NULL,
  `verify` varchar(400) NOT NULL,
  `verifyStaff` text NOT NULL COMMENT 'status ：1同意 3不同意 4等待',
  `nowStaff` varchar(20) NOT NULL,
  `execute` int(11) NOT NULL,
  `executeStaff` text NOT NULL,
  `executeCopy` mediumtext NOT NULL,
  `verifyBreakup` text NOT NULL,
  `explanation` text NOT NULL,
  `implementOpinions` tinytext NOT NULL,
  `notice` int(2) NOT NULL DEFAULT '0',
  `loanRid` int(11) NOT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2277 ;

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

--
-- 表的结构 `CLD_receiptDetail`
--

CREATE TABLE IF NOT EXISTS `CLD_receiptDetail` (
  `rdid` int(11) NOT NULL AUTO_INCREMENT,
  `staff` int(11) NOT NULL,
  `item` varchar(160) NOT NULL,
  `itemCategory` varchar(160) NOT NULL,
  `price` decimal(12,2) NOT NULL,
  `date` date NOT NULL,
  `pastDate` date NOT NULL,
  `cid` int(11) NOT NULL COMMENT '办事处',
  `rid` int(11) NOT NULL COMMENT '报销单据ID',
  `status` int(11) NOT NULL COMMENT '1同意支付，2审批中，3退回4编辑',
  PRIMARY KEY (`rdid`),
  UNIQUE KEY `rdid` (`rdid`),
  UNIQUE KEY `rdid_2` (`rdid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10114 ;

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

--
-- 表的结构 `CLD_receiptLog`
--

CREATE TABLE IF NOT EXISTS `CLD_receiptLog` (
  `rlid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(160) NOT NULL,
  `uid` int(11) NOT NULL,
  `date` varchar(60) NOT NULL,
  `opinion` varchar(260) NOT NULL,
  `rolename` varchar(160) NOT NULL,
  `img` varchar(160) NOT NULL,
  `rid` int(11) NOT NULL,
  `status` int(3) NOT NULL,
  PRIMARY KEY (`rlid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=85 ;

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

--
-- 表的结构 `CLD_remind`
--

CREATE TABLE IF NOT EXISTS `CLD_remind` (
  `rid` int(10) NOT NULL AUTO_INCREMENT,
  `day` int(4) NOT NULL,
  `remark` varchar(180) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '0' COMMENT '1:不需要提醒',
  `time` varchar(40) NOT NULL,
  `staffID` int(10) NOT NULL,
  `clientName` varchar(80) NOT NULL,
  `clientID` int(10) NOT NULL,
  `companyName` varchar(80) NOT NULL,
  `companyID` int(10) NOT NULL,
  `class` varchar(30) NOT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=484 ;

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

--
-- 表的结构 `CLD_role`
--

CREATE TABLE IF NOT EXISTS `CLD_role` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(160) NOT NULL,
  `staff` mediumtext NOT NULL,
  PRIMARY KEY (`rid`),
  UNIQUE KEY `rid` (`rid`),
  KEY `rid_2` (`rid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

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

--
-- 表的结构 `CLD_service_log`
--

CREATE TABLE IF NOT EXISTS `CLD_service_log` (
  `slid` int(10) NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL,
  `mark` text NOT NULL,
  `date` date NOT NULL,
  `category` varchar(40) NOT NULL,
  `clientid` int(11) NOT NULL,
  `staffname` varchar(60) NOT NULL,
  `staffid` int(11) NOT NULL,
  PRIMARY KEY (`slid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=190107 ;

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

--
-- 表的结构 `CLD_sms`
--

CREATE TABLE IF NOT EXISTS `CLD_sms` (
  `sid` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(160) NOT NULL,
  `content` text NOT NULL,
  `signature` varchar(30) NOT NULL COMMENT '签名',
  `client` longtext NOT NULL COMMENT '目标发送者',
  `illegal` longtext NOT NULL COMMENT '非法',
  `status` int(11) NOT NULL COMMENT '1待审核2已审核3已发送',
  `kind` int(2) NOT NULL,
  `mark` varchar(160) NOT NULL,
  `tag` varchar(60) NOT NULL,
  `districtId` int(10) NOT NULL DEFAULT '0',
  `category` varchar(40) NOT NULL,
  `staffId` int(20) NOT NULL,
  `staffName` varchar(60) NOT NULL,
  `errorInfo` varchar(60) NOT NULL,
  `date` varchar(20) NOT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

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

--
-- 表的结构 `CLD_staff`
--

CREATE TABLE IF NOT EXISTS `CLD_staff` (
  `sid` int(10) NOT NULL AUTO_INCREMENT,
  `isadmin` int(3) NOT NULL DEFAULT '0',
  `username` varchar(60) NOT NULL COMMENT '公司员工',
  `passwork` varchar(60) NOT NULL,
  `cid` int(11) NOT NULL COMMENT '办事处ＩＤ',
  `othercid` varchar(40) NOT NULL,
  `category` varchar(40) NOT NULL,
  `othercategory` varchar(80) NOT NULL,
  `gender` varchar(2) NOT NULL,
  `qq` varchar(15) NOT NULL,
  `phone` varchar(35) NOT NULL,
  `telephone` varchar(35) NOT NULL,
  `email` varchar(80) NOT NULL,
  `avatar` varchar(600) NOT NULL DEFAULT '/global/img/avtra',
  `birthday` varchar(60) NOT NULL,
  `position` varchar(30) NOT NULL,
  `appDate` varchar(40) NOT NULL,
  `hiredate` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '入职时间',
  `nature` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '员工性质，1为正式员工，2为实习生',
  `wxid` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '微信的id',
  PRIMARY KEY (`sid`),
  KEY `nature` (`nature`),
  KEY `wxid` (`wxid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=99 ;

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

--
-- 表的结构 `CLD_staffDynamic`
--

CREATE TABLE IF NOT EXISTS `CLD_staffDynamic` (
  `sdid` int(10) NOT NULL AUTO_INCREMENT,
  `content` varchar(250) NOT NULL,
  `time` int(16) NOT NULL,
  `category` varchar(16) NOT NULL,
  `cid` int(10) NOT NULL,
  `sid` int(10) NOT NULL,
  `staff` varchar(30) NOT NULL,
  `status` int(10) NOT NULL,
  PRIMARY KEY (`sdid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=397 ;

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

--
-- 表的结构 `CLD_statistics`
--

CREATE TABLE IF NOT EXISTS `CLD_statistics` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL COMMENT '年月',
  `cid` int(11) NOT NULL,
  `staff` int(11) NOT NULL,
  `agPrice` decimal(12,2) NOT NULL,
  `rePrice` decimal(12,2) NOT NULL COMMENT '总金额',
  PRIMARY KEY (`sid`),
  UNIQUE KEY `sid` (`sid`),
  KEY `sid_2` (`sid`),
  KEY `cid` (`cid`),
  KEY `staff` (`staff`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1065 ;

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

--
-- 表的结构 `CLD_tag`
--

CREATE TABLE IF NOT EXISTS `CLD_tag` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `sid` int(10) NOT NULL COMMENT '用户ID',
  `colorid` int(10) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=680 ;

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

--
-- 表的结构 `CLD_tagCompany`
--

CREATE TABLE IF NOT EXISTS `CLD_tagCompany` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `sid` int(10) NOT NULL COMMENT '用户ID',
  `colorid` int(10) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=904 ;

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

--
-- 表的结构 `CLD_tagCompanyNexus`
--

CREATE TABLE IF NOT EXISTS `CLD_tagCompanyNexus` (
  `tcid` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(10) NOT NULL,
  `company` int(10) NOT NULL,
  `tag` varchar(80) NOT NULL,
  PRIMARY KEY (`tcid`),
  UNIQUE KEY `tcid` (`tcid`),
  KEY `company` (`company`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=235 ;

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

--
-- 表的结构 `CLD_tag_client`
--

CREATE TABLE IF NOT EXISTS `CLD_tag_client` (
  `tcid` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(10) NOT NULL,
  `client` int(10) NOT NULL,
  `tag` varchar(80) NOT NULL,
  PRIMARY KEY (`tcid`),
  UNIQUE KEY `tcid` (`tcid`),
  KEY `client` (`client`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35742 ;

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

--
-- 表的结构 `CLD_verify`
--

CREATE TABLE IF NOT EXISTS `CLD_verify` (
  `vid` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(160) NOT NULL,
  `staff` mediumtext NOT NULL,
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;

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

--
-- 表的结构 `holiday_acman`
--

CREATE TABLE IF NOT EXISTS `holiday_acman` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(500) COLLATE utf8_unicode_ci NOT NULL COMMENT '名字，以，号分隔保存',
  `type` tinyint(1) unsigned NOT NULL COMMENT '1为审批组，2为抄送组',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='假期审批组和抄送人组' AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `holiday_approval`
--

CREATE TABLE IF NOT EXISTS `holiday_approval` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `hid` int(11) unsigned NOT NULL COMMENT '请假申请表的id',
  `aid` int(11) unsigned NOT NULL COMMENT '审批人id',
  `aname` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '审批人名字',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '审批结果，1：审批通过，2：审批不通过，0（默认）：未审批',
  `approvetime` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT '审批时间',
  `description` varchar(5000) COLLATE utf8_unicode_ci NOT NULL COMMENT '审批回复内容',
  PRIMARY KEY (`id`),
  KEY `hid` (`hid`,`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='假期审批表' AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `holiday_day`
--

CREATE TABLE IF NOT EXISTS `holiday_day` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL COMMENT '申请人id',
  `type` smallint(4) unsigned NOT NULL COMMENT '类型',
  `daytime` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT '日期',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`,`type`,`daytime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='假期日期记录表' AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `holiday_msg`
--

CREATE TABLE IF NOT EXISTS `holiday_msg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL COMMENT '发起人id',
  `aid` smallint(4) unsigned NOT NULL COMMENT '审批组id',
  `cid` smallint(4) unsigned NOT NULL COMMENT '抄送组id',
  `type` smallint(4) unsigned NOT NULL COMMENT '类型',
  `starttime` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT '开始时间',
  `endtime` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT '结束时间',
  `daynum` decimal(10,1) unsigned NOT NULL COMMENT '请假天数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '审批类型，1：审批通过，2：审批不通过，0（默认）：未审批',
  `addtime` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT '提交时间',
  `approvetime` varchar(15) COLLATE utf8_unicode_ci NOT NULL COMMENT '审批时间',
  `description` varchar(5000) COLLATE utf8_unicode_ci NOT NULL COMMENT '申请内容',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`,`aid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='假期申请与审批' AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `holiday_staff`
--

CREATE TABLE IF NOT EXISTS `holiday_staff` (
  `uid` int(11) unsigned NOT NULL COMMENT '员工id',
  `yearnum` decimal(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '年假数目',
  `addnum` decimal(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '加值班存假数目',
  `othernum` decimal(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '其它假期数目（后台手动输入）',
  `isadmin` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是审批人，1：是，0否',
  PRIMARY KEY (`uid`),
  KEY `yearnum` (`yearnum`,`addnum`,`othernum`),
  KEY `isadmin` (`isadmin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='员工假期表';

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

--
-- 表的结构 `holiday_type`
--

CREATE TABLE IF NOT EXISTS `holiday_type` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='假期类型' AUTO_INCREMENT=12 ;

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