DB_51aspx/mrysys_db.sql

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

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

/*
MySQL Data Transfer
Source Host: localhost
Source Database: mrysys_db
Target Host: localhost
Target Database: mrysys_db
Date: 2013/2/27 16:32:25
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for mrs
-- ----------------------------
DROP TABLE IF EXISTS `mrs`;
CREATE TABLE `mrs` (
  `id` int(11) NOT NULL auto_increment,
  `realname` varchar(255) default NULL,
  `sex` varchar(255) default NULL,
  `age` varchar(255) default NULL,
  `img` varchar(255) default NULL,
  `remark` varchar(255) default NULL,
  `delstatus` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(150) default NULL,
  `content` text,
  `savetime` varchar(50) default NULL,
  `imgurl` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for pj
-- ----------------------------
DROP TABLE IF EXISTS `pj`;
CREATE TABLE `pj` (
  `id` int(50) unsigned NOT NULL auto_increment,
  `content` text,
  `savetime` varchar(50) default NULL,
  `pid` int(50) default NULL,
  `addr` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for porder
-- ----------------------------
DROP TABLE IF EXISTS `porder`;
CREATE TABLE `porder` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` varchar(50) default NULL,
  `uid` varchar(50) default NULL,
  `yytime` varchar(50) default NULL,