smartcost/smartcostv2_结构.sql

-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: 10.252.250.130
-- Generation Time: 2017-08-03 09:57:48
-- 服务器版本： 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: `smartcostv2`
--

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

--
-- 表的结构 `sc_animation`
--

CREATE TABLE `sc_animation` (
  `aid` int(10) NOT NULL,
  `title` varchar(120) NOT NULL,
  `url` mediumtext NOT NULL,
  `down_url` tinytext NOT NULL,
  `img_url` varchar(180) NOT NULL,
  `belong` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `sc_article`
--

CREATE TABLE `sc_article` (
  `aid` int(10) NOT NULL,
  `title` varchar(120) NOT NULL,
  `content` longtext NOT NULL,
  `synopsis` tinytext NOT NULL COMMENT '新闻概要',
  `thum` varchar(260) NOT NULL DEFAULT '/global/img/2.png' COMMENT '缩略图',
  `a_type` int(1) NOT NULL,
  `trainingType` int(2) NOT NULL COMMENT '1免费培训2收费培训',
  `area` varchar(160) NOT NULL,
  `enroll` text NOT NULL,
  `enroll_title` varchar(180) NOT NULL,
  `enroll_obj` mediumtext NOT NULL,
  `enroll_content` mediumtext NOT NULL,
  `enroll_fun` mediumtext NOT NULL,
  `enroll_adrr` mediumtext NOT NULL,
  `enroll_pay` mediumtext NOT NULL,
  `enroll_name` mediumtext NOT NULL,
  `enroll_downdoc` mediumtext NOT NULL,
  `enroll_mark` mediumtext NOT NULL,
  `attachment` varchar(160) NOT NULL,
  `cid` int(10) NOT NULL,
  `enroll_time` varchar(80) NOT NULL,
  `time` int(10) NOT NULL,
  `update_time` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `sc_column`
--

CREATE TABLE `sc_column` (
  `cid` int(10) NOT NULL,
  `title` varchar(80) NOT NULL,
  `c_type` int(1) NOT NULL,
  `link` varchar(180) NOT NULL,
  `description` text NOT NULL,
  `display` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `sc_down`
--

CREATE TABLE `sc_down` (
  `did` int(10) NOT NULL,
  `title` varchar(120) NOT NULL,
  `fulltitle` varchar(200) NOT NULL,
  `key_number` varchar(20) NOT NULL,
  `down_url` mediumtext NOT NULL,
  `size` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `sc_product`
--

CREATE TABLE `sc_product` (
  `pid` int(10) NOT NULL,
  `fulltitle` varchar(200) NOT NULL,
  `title` varchar(120) NOT NULL,
  `content` text NOT NULL,
  `p_type` int(2) NOT NULL DEFAULT '1',
  `logo` varchar(225) NOT NULL,
  `link` varchar(220) NOT NULL,
  `anid` varchar(250) NOT NULL DEFAULT '0',
  `edition` text NOT NULL,
  `did` varchar(180) NOT NULL DEFAULT '0',
  `cid` int(10) NOT NULL,
  `time` int(10) NOT NULL,
  `orders` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `zhhelp_article`
--

CREATE TABLE `zhhelp_article` (
  `title` mediumtext CHARACTER SET utf8 NOT NULL,
  `aid` int(10) NOT NULL,
  `content` text CHARACTER SET utf8 NOT NULL,
  `cid` int(10) NOT NULL,
  `time` int(10) NOT NULL,
  `displayorder` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- 表的结构 `zhhelp_category`
--

CREATE TABLE `zhhelp_category` (
  `cid` int(10) UNSIGNED NOT NULL,
  `name` varchar(80) CHARACTER SET utf8 NOT NULL,
  `pid` int(5) NOT NULL,
  `grade` int(5) NOT NULL,
  `displayorder` int(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `sc_column`
--
ALTER TABLE `sc_column`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `sc_down`
--
ALTER TABLE `sc_down`
  ADD PRIMARY KEY (`did`);

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

--
-- Indexes for table `zhhelp_article`
--
ALTER TABLE `zhhelp_article`
  ADD PRIMARY KEY (`aid`),
  ADD UNIQUE KEY `aid` (`aid`);

--
-- Indexes for table `zhhelp_category`
--
ALTER TABLE `zhhelp_category`
  ADD PRIMARY KEY (`cid`);

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

--
-- 使用表AUTO_INCREMENT `sc_animation`
--
ALTER TABLE `sc_animation`
  MODIFY `aid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- 使用表AUTO_INCREMENT `sc_article`
--
ALTER TABLE `sc_article`
  MODIFY `aid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1260;
--
-- 使用表AUTO_INCREMENT `sc_column`
--
ALTER TABLE `sc_column`
  MODIFY `cid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- 使用表AUTO_INCREMENT `sc_down`
--
ALTER TABLE `sc_down`
  MODIFY `did` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=372;
--
-- 使用表AUTO_INCREMENT `sc_product`
--
ALTER TABLE `sc_product`
  MODIFY `pid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- 使用表AUTO_INCREMENT `zhhelp_article`
--
ALTER TABLE `zhhelp_article`
  MODIFY `aid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=258;
--
-- 使用表AUTO_INCREMENT `zhhelp_category`
--
ALTER TABLE `zhhelp_category`
  MODIFY `cid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;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 */;