51aspx/jspdichan.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

# SQL Manager 2005 Lite for MySQL 3.6.0.3
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : jspdichan


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

SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `jspdichan`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

#
# Structure for the `fangchan` table : 
#

CREATE TABLE `fangchan` (
  `fcid` int(11) NOT NULL auto_increment,
  `fcm` varchar(40) default NULL,
  `hx` varchar(40) default NULL,
  `mj` varchar(40) default NULL,
  `sj` varchar(40) default NULL,
  `dz` varchar(40) default NULL,
  `kfs` varchar(40) default NULL,
  `lxdh` varchar(40) default NULL,
  `kpsj` varchar(40) default NULL,
  `wy` varchar(40) default NULL,
  `lxid` int(11) default NULL,
  PRIMARY KEY  (`fcid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

#
# Structure for the `fankui` table : 
#

CREATE TABLE `fankui` (
  `fkbid` int(11) NOT NULL auto_increment,
  `qd` varchar(40) default NULL,
  `fs` varchar(40) default NULL,
  `gc` varchar(40) default NULL,
  `pj` varchar(40) default NULL,
  `sj` varchar(40) default NULL,
  `yhm` varchar(40) default NULL,
  `fcid` int(40) default NULL,
  PRIMARY KEY  (`fkbid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;

#
# Structure for the `leixing` table : 
#

CREATE TABLE `leixing` (
  `lxid` int(11) NOT NULL auto_increment,
  `lxmc` varchar(40) default NULL,