new project 20070703 1413.sql

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.2.0-falcon-alpha-community-nt


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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema pesticideinfosys
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ pesticideinfosys;
USE pesticideinfosys;

--
-- Table structure for table `pesticideinfosys`.`advice`
--

DROP TABLE IF EXISTS `advice`;
CREATE TABLE `advice` (
  `advicenum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(100) NOT NULL DEFAULT '',
  `date` varchar(45) NOT NULL DEFAULT '',
  `adminname` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`advicenum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`advice`
--

/*!40000 ALTER TABLE `advice` DISABLE KEYS */;
/*!40000 ALTER TABLE `advice` ENABLE KEYS */;


--
-- Table structure for table `pesticideinfosys`.`login`
--

DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(16) NOT NULL DEFAULT '',
  `role` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`login`
--

/*!40000 ALTER TABLE `login` DISABLE KEYS */;
INSERT INTO `login` (`username`,`password`,`role`) VALUES 
 ('admin','1','admin'),
 ('ccccc','123456','user'),
 ('jiecai','1','user'),
 ('Zheng','1','user');
/*!40000 ALTER TABLE `login` ENABLE KEYS */;


--
-- Table structure for table `pesticideinfosys`.`news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `newsnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL DEFAULT '',
  `content` varchar(1000) NOT NULL DEFAULT '',
  `reportdate` varchar(45) NOT NULL DEFAULT '',
  `adminname` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`newsnum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`news`
--

/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` (`newsnum`,`title`,`content`,`reportdate`,`adminname`) VALUES 
 (1,'the way of using pesticide','welcome','2007-1-1','admin'),
 (2,'the question asked by users','first:','2007-5-6','admin'),
 (6,'中过','士大夫似的士大夫似的发射点法十分士大夫似的发是\r\n发射点法士大夫似的发射点法十分似的','07/07/01','admin'),
 (9,'好消息','今天所有农药全部买１送１','07/07/03','admin');
/*!40000 ALTER TABLE `news` ENABLE KEYS */;


--
-- Table structure for table `pesticideinfosys`.`orderbyuser`
--

DROP TABLE IF EXISTS `orderbyuser`;
CREATE TABLE `orderbyuser` (
  `ordernum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL DEFAULT '',
  `pesticidename` varchar(45) NOT NULL DEFAULT '',
  `orderdate` varchar(45) NOT NULL DEFAULT '',
  `qty` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ordernum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`orderbyuser`
--

/*!40000 ALTER TABLE `orderbyuser` DISABLE KEYS */;
INSERT INTO `orderbyuser` (`ordernum`,`username`,`pesticidename`,`orderdate`,`qty`) VALUES 
 (1,'Zheng','LiuHuan','07/07/01',10),
 (2,'Zheng','佳非','07/07/01',21),
 (3,'Zheng','佳非','07/07/01',21),
 (4,'Zheng','佳非','07/07/01',22),
 (5,'Zheng','佳非','07/07/01',22),
 (6,'Zheng','尿素','07/07/02',1),
 (7,'Zheng','磷肥','07/07/02',1),
 (8,'Zheng','化肥','07/07/02',1),
 (9,'Zheng','尿素','07/07/02',1),
 (10,'Zheng','尿素','07/07/02',1),
 (11,'Zheng','尿素','07/07/02',100),
 (12,'Zheng','化肥','07/07/02',10),
 (13,'Zheng','磷肥','07/07/03',1),
 (14,'Zheng','佳非','07/07/03',2);
/*!40000 ALTER TABLE `orderbyuser` ENABLE KEYS */;


--
-- Table structure for table `pesticideinfosys`.`pdetail`
--

DROP TABLE IF EXISTS `pdetail`;
CREATE TABLE `pdetail` (
  `PID` char(20) NOT NULL DEFAULT '',
  `description` varchar(1000) NOT NULL DEFAULT '',
  `company` varchar(45) NOT NULL DEFAULT '',
  PRIMARY KEY (`PID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`pdetail`
--

/*!40000 ALTER TABLE `pdetail` DISABLE KEYS */;
INSERT INTO `pdetail` (`PID`,`description`,`company`) VALUES 
 ('2','http://www.4ewriting.com/',''),
 ('P1002AB2','一种好肥料','');
/*!40000 ALTER TABLE `pdetail` ENABLE KEYS */;


--
-- Table structure for table `pesticideinfosys`.`pesticide`
--

DROP TABLE IF EXISTS `pesticide`;
CREATE TABLE `pesticide` (
  `PID` char(20) NOT NULL DEFAULT '',
  `Pname` varchar(45) NOT NULL DEFAULT '',
  `toxicity` varchar(10) NOT NULL DEFAULT '',
  `charachter` varchar(45) NOT NULL DEFAULT '',
  `price` float NOT NULL DEFAULT '0',
  `qty` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`PID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`pesticide`
--

/*!40000 ALTER TABLE `pesticide` DISABLE KEYS */;
INSERT INTO `pesticide` (`PID`,`Pname`,`toxicity`,`charachter`,`price`,`qty`) VALUES 
 ('','磷肥','low','none',100,200),
 ('2','磷肥','2','2',2,0),
 ('P1001ABC','佳非','low','none',23,12),
 ('P1001BCC','磷肥','low','none',100,200),
 ('P1001CDF','尿素','无','现无',100,786),
 ('P1002AB2','化肥','low','none',101,232);
/*!40000 ALTER TABLE `pesticide` ENABLE KEYS */;


--
-- Table structure for table `pesticideinfosys`.`replyofuser`
--

DROP TABLE IF EXISTS `replyofuser`;
CREATE TABLE `replyofuser` (
  `num` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL DEFAULT '',
  `username` varchar(20) NOT NULL DEFAULT '',
  `replydate` varchar(45) NOT NULL DEFAULT '',
  `replycontent` varchar(500) NOT NULL DEFAULT '',
  PRIMARY KEY (`num`),
  KEY `FK_replyofuser_1` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`replyofuser`
--

/*!40000 ALTER TABLE `replyofuser` DISABLE KEYS */;
INSERT INTO `replyofuser` (`num`,`title`,`username`,`replydate`,`replycontent`) VALUES 
 (1,'the way of using pesticide','07/06/29/08/25','Zheng','cvxcv'),
 (2,'the way of using pesticide','07/06/29/08/52','Zheng','dfsdfs'),
 (3,'the way of using pesticide','07/06/29/08/53','Zheng','fsdfsd'),
 (4,'the way of using pesticide','07/06/30/12/33','Zheng','发'),
 (5,'the question asked by users','07/06/30/11/04','Zheng','为什么你们的系统这么好呢'),
 (6,'the way of using pesticide','07/07/03/01/51','Zheng','感谢');
/*!40000 ALTER TABLE `replyofuser` ENABLE KEYS */;


--
-- Table structure for table `pesticideinfosys`.`userinfo`
--

DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `UserName` varchar(16) NOT NULL DEFAULT '',
  `RealName` varchar(45) NOT NULL DEFAULT '',
  `email` varchar(45) NOT NULL DEFAULT '',
  `accountNum` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`UserName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pesticideinfosys`.`userinfo`
--

/*!40000 ALTER TABLE `userinfo` DISABLE KEYS */;
INSERT INTO `userinfo` (`UserName`,`RealName`,`email`,`accountNum`) VALUES 
 ('ccccc','jack','yideyo@163,.com','8888'),
 ('jiecai','111111','[e-mail]','1111'),
 ('Zheng','jiecai,zheng','[e-mail]','987654321');
/*!40000 ALTER TABLE `userinfo` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;