jiliangzhifu/jlweb.sql

-- phpMyAdmin SQL Dump
-- version 4.2.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2015-09-16 16:43:12
-- 服务器版本： 10.1.4-MariaDB-1~trusty-wsrep-log
-- PHP Version: 5.5.29-1+deb.sury.org~trusty+3

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

--
-- Database: `jlweb`
--

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

--
-- 表的结构 `jl_attachment`
--

CREATE TABLE IF NOT EXISTS `jl_attachment` (
`aid` int(11) NOT NULL,
  `pid` mediumint(9) NOT NULL,
  `stid` mediumint(9) NOT NULL,
  `mpid` mediumint(9) NOT NULL,
  `pmid` mediumint(9) NOT NULL,
  `numpname` smallint(6) NOT NULL,
  `times` smallint(6) NOT NULL DEFAULT '0',
  `auditoruid` mediumint(9) NOT NULL,
  `filepath` char(255) NOT NULL,
  `ziphashcode` char(32) NOT NULL,
  `filehashcode` char(32) NOT NULL,
  `isnew` tinyint(4) NOT NULL DEFAULT '1',
  `intime` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2351 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_auser`
--

CREATE TABLE IF NOT EXISTS `jl_auser` (
`auid` mediumint(9) NOT NULL,
  `auname` char(255) NOT NULL,
  `aupass` char(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_item_attachment`
--

CREATE TABLE IF NOT EXISTS `jl_item_attachment` (
`iaid` mediumint(11) NOT NULL,
  `mpid` mediumint(11) NOT NULL,
  `ownerid` smallint(11) NOT NULL,
  `itemid` char(255) CHARACTER SET utf8 NOT NULL,
  `filename` char(255) CHARACTER SET utf8 NOT NULL,
  `fileext` char(5) CHARACTER SET utf8 NOT NULL,
  `filesize` char(255) CHARACTER SET utf8 NOT NULL,
  `filepath` char(255) CHARACTER SET utf8 NOT NULL,
  `categoryid` smallint(6) NOT NULL,
  `intime` int(11) NOT NULL,
  `isdel` tinyint(2) NOT NULL DEFAULT '0',
  `tips` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;

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

--
-- 表的结构 `jl_measure_audit`
--

CREATE TABLE IF NOT EXISTS `jl_measure_audit` (
`maid` smallint(6) NOT NULL,
  `pid` mediumint(9) NOT NULL,
  `creatoruid` mediumint(9) NOT NULL,
  `auditoruid` mediumint(9) NOT NULL DEFAULT '0',
  `mpid` mediumint(9) NOT NULL DEFAULT '0',
  `pmid` mediumint(9) NOT NULL,
  `stid` mediumint(9) NOT NULL,
  `numpname` mediumint(9) NOT NULL,
  `times` smallint(6) NOT NULL DEFAULT '0',
  `mastatus` enum('uncheck','checking','checked','checkno') NOT NULL DEFAULT 'uncheck',
  `last` tinyint(4) NOT NULL DEFAULT '2',
  `audittime` int(11) NOT NULL,
  `auditcontent` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3551 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_measure_numofper`
--

CREATE TABLE IF NOT EXISTS `jl_measure_numofper` (
`mpid` mediumint(9) NOT NULL,
  `iszero` tinyint(3) unsigned NOT NULL,
  `uid` mediumint(9) NOT NULL,
  `pid` smallint(6) unsigned NOT NULL,
  `pmid` smallint(5) unsigned NOT NULL,
  `stid` smallint(5) unsigned NOT NULL,
  `numpname` smallint(5) unsigned NOT NULL,
  `times` smallint(6) NOT NULL DEFAULT '0',
  `currcontractval` char(255) NOT NULL COMMENT '本期合同计量',
  `currchangeval` char(255) NOT NULL COMMENT '本期数量变更计量',
  `stopnowtotal` char(255) NOT NULL COMMENT '截止上期累计完成',
  `currdone` char(255) NOT NULL COMMENT '本期完成计量',
  `curralltotal` char(255) NOT NULL COMMENT '累计完成计量',
  `currstatus` enum('uncheck','checking','checked','checkno') NOT NULL DEFAULT 'checking',
  `audittime` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=740 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_project`
--

CREATE TABLE IF NOT EXISTS `jl_project` (
`pid` int(11) NOT NULL,
  `uid` mediumint(9) NOT NULL,
  `pname` char(255) NOT NULL,
  `intime` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_project_measure`
--

CREATE TABLE IF NOT EXISTS `jl_project_measure` (
`pmid` int(11) NOT NULL,
  `pid` mediumint(8) DEFAULT '0',
  `stid` mediumint(8) NOT NULL DEFAULT '0',
  `uid` mediumint(9) NOT NULL,
  `pmname` char(255) DEFAULT NULL,
  `contracttotal` char(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=681 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_section_type`
--

CREATE TABLE IF NOT EXISTS `jl_section_type` (
`stid` int(11) NOT NULL,
  `pid` mediumint(8) NOT NULL DEFAULT '0',
  `uid` mediumint(9) NOT NULL,
  `stname` char(255) NOT NULL,
  `stkey` char(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_users`
--

CREATE TABLE IF NOT EXISTS `jl_users` (
`uid` int(11) NOT NULL,
  `uemail` char(255) NOT NULL,
  `upass` char(60) NOT NULL,
  `intime` int(11) NOT NULL,
  `isstop` tinyint(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_users_auth`
--

CREATE TABLE IF NOT EXISTS `jl_users_auth` (
`aid` int(11) NOT NULL,
  `token` char(255) NOT NULL,
  `expirestime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_users_friends`
--

CREATE TABLE IF NOT EXISTS `jl_users_friends` (
  `uid` int(11) NOT NULL,
  `fuid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_user_profiles`
--

CREATE TABLE IF NOT EXISTS `jl_user_profiles` (
  `userid` int(11) NOT NULL,
  `name` char(50) NOT NULL,
  `company` char(255) NOT NULL,
  `jobs` char(255) NOT NULL,
  `phone` char(255) NOT NULL,
  `mobile` char(255) NOT NULL,
  `qq` char(50) NOT NULL,
  `groups` enum('vip','anonymous') NOT NULL DEFAULT 'anonymous',
  `avatar` char(255) NOT NULL DEFAULT 'global/avatar/avtra.jpg'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `jl_zero_audit`
--

CREATE TABLE IF NOT EXISTS `jl_zero_audit` (
`zaid` smallint(6) NOT NULL,
  `uid` int(11) NOT NULL,
  `catid` int(11) NOT NULL,
  `auditstatus` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `jl_attachment`
--
ALTER TABLE `jl_attachment`
 ADD PRIMARY KEY (`aid`);

--
-- Indexes for table `jl_auser`
--
ALTER TABLE `jl_auser`
 ADD PRIMARY KEY (`auid`);

--
-- Indexes for table `jl_item_attachment`
--
ALTER TABLE `jl_item_attachment`
 ADD PRIMARY KEY (`iaid`);

--
-- Indexes for table `jl_measure_audit`
--
ALTER TABLE `jl_measure_audit`
 ADD PRIMARY KEY (`maid`), ADD UNIQUE KEY `auditoruid` (`auditoruid`,`pmid`,`numpname`,`times`);

--
-- Indexes for table `jl_measure_numofper`
--
ALTER TABLE `jl_measure_numofper`
 ADD PRIMARY KEY (`mpid`), ADD UNIQUE KEY `pmid_numpname_times` (`pmid`,`numpname`,`times`), ADD UNIQUE KEY `mpid` (`mpid`);

--
-- Indexes for table `jl_project`
--
ALTER TABLE `jl_project`
 ADD PRIMARY KEY (`pid`);

--
-- Indexes for table `jl_project_measure`
--
ALTER TABLE `jl_project_measure`
 ADD PRIMARY KEY (`pmid`);

--
-- Indexes for table `jl_section_type`
--
ALTER TABLE `jl_section_type`
 ADD PRIMARY KEY (`stid`);

--
-- Indexes for table `jl_users`
--
ALTER TABLE `jl_users`
 ADD PRIMARY KEY (`uid`), ADD UNIQUE KEY `uemail` (`uemail`);

--
-- Indexes for table `jl_users_auth`
--
ALTER TABLE `jl_users_auth`
 ADD PRIMARY KEY (`aid`);

--
-- Indexes for table `jl_user_profiles`
--
ALTER TABLE `jl_user_profiles`
 ADD UNIQUE KEY `userid` (`userid`);

--
-- Indexes for table `jl_zero_audit`
--
ALTER TABLE `jl_zero_audit`
 ADD PRIMARY KEY (`zaid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `jl_attachment`
--
ALTER TABLE `jl_attachment`
MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2351;
--
-- AUTO_INCREMENT for table `jl_auser`
--
ALTER TABLE `jl_auser`
MODIFY `auid` mediumint(9) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `jl_item_attachment`
--
ALTER TABLE `jl_item_attachment`
MODIFY `iaid` mediumint(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `jl_measure_audit`
--
ALTER TABLE `jl_measure_audit`
MODIFY `maid` smallint(6) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3551;
--
-- AUTO_INCREMENT for table `jl_measure_numofper`
--
ALTER TABLE `jl_measure_numofper`
MODIFY `mpid` mediumint(9) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=740;
--
-- AUTO_INCREMENT for table `jl_project`
--
ALTER TABLE `jl_project`
MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=147;
--
-- AUTO_INCREMENT for table `jl_project_measure`
--
ALTER TABLE `jl_project_measure`
MODIFY `pmid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=681;
--
-- AUTO_INCREMENT for table `jl_section_type`
--
ALTER TABLE `jl_section_type`
MODIFY `stid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=221;
--
-- AUTO_INCREMENT for table `jl_users`
--
ALTER TABLE `jl_users`
MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=165;
--
-- AUTO_INCREMENT for table `jl_users_auth`
--
ALTER TABLE `jl_users_auth`
MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `jl_zero_audit`
--
ALTER TABLE `jl_zero_audit`
MODIFY `zaid` smallint(6) NOT NULL AUTO_INCREMENT;
/*!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 */;