数据库/dy.sql

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

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

/*
MySQL Data Transfer
Source Host: localhost
Source Database: dy
Target Host: localhost
Target Database: dy
Date: 2013/4/2 16:46:13
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
CREATE TABLE `admin` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `password` varchar(50) default NULL,
  `realname` varchar(50) default NULL,
  `sex` varchar(50) default NULL,
  `age` varchar(50) default NULL,
  `address` varchar(50) default NULL,
  `tel` varchar(50) default NULL,
  `addtime` varchar(50) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for affiche
-- ----------------------------
CREATE TABLE `affiche` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(50) default NULL,
  `content` varchar(500) default NULL,
  `addtime` varchar(50) default NULL,
  `adder` varchar(50) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for guestbook
-- ----------------------------
CREATE TABLE `guestbook` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(100) default NULL,
  `content` varchar(500) default NULL,
  `addtime` varchar(50) default NULL,
  `member` varchar(50) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for kc
-- ----------------------------
CREATE TABLE `kc` (
  `id` int(4) NOT NULL auto_increment,
  `bh` varchar(50) default NULL,
  `title` varchar(50) default NULL,
  `content` varchar(500) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;