sql.txt

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

CREATE TABLE `pesticideinfosys`.`login` (
  `adminname` VARCHAR(20) NOT NULL DEFAULT '',
  `password` VARCHAR(16) NOT NULL DEFAULT '',
  PRIMARY KEY(`adminname`)
)



CREATE TABLE `pesticideinfosys`.`news` (
  `newsnum` INTEGER UNSIGNED NOT NULL DEFAULT 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`)
)

CREATE TABLE `pesticideinfosys`.`PDetail` (
  `PID` CHAR(20) UNSIGNED NOT NULL DEFAULT '',
  `detail` VARCHAR(1000) NOT NULL DEFAULT '',
  `qty` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  `company` VARCHAR(45) NOT NULL DEFAULT '',
  PRIMARY KEY(`PID`),
  CONSTRAINT `FK_PDetail_1` FOREIGN KEY `FK_PDetail_1` (`PID`)
    REFERENCES `pesticide` (`PID`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)

CREATE TABLE `pesticideinfosys`.`advice` (
  `advicenum` INTEGER UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT,
  `content` VARCHAR(100) NOT NULL DEFAULT '',
  `date` VARCHAR(45) NOT NULL DEFAULT '',
  `adminname` VARCHAR(20) NOT NULL DEFAULT '',
  PRIMARY KEY(`advicenum`)
)

CREATE TABLE `pesticideinfosys`.`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 '',
  PRIMARY KEY(`PID`)
)