进销存管理系统代码_商品进销存系统代码

/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.7.28-log : Database - jxcmanager
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

会员（会员id，姓名、性别、手机号、会员卡号、卡内余额、可用积分、上次消费时间）

货品（货品id，名称、规格、条码、计量单位、零售价、促销价）

供应商表（供应商id，供应商名称，联系人，联系电话，供应商状态）

收银（收银id，收银员id，顾客id，收银时间，应收金额、实收金额、支付方式，销售状态）

收银明细（收货明细id，收银id，货物id，销售数量，零售价、促销价）

库存（库存id、货品id，库存数量、昨日库存、月初库存）

扎帐(扎帐id,收银员id,扎帐时间，应收金额，实收金额，差错原因)

CREATE DATABASE /*!32312 IF NOT EXISTS*/`jxcmanager` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `jxcmanager`;

/*Table structure for table `gongyingshang` */

DROP TABLE IF EXISTS `gongyingshang`;

CREATE TABLE `gongyingshang` (
  `gysid` int(11) NOT NULL COMMENT '供应商id',
  `gysmc` varchar(20) DEFAULT NULL COMMENT '供应商名称',
  `gyslxr` varchar(20) DEFAULT NULL COMMENT '供应商联系人',
  `gystele` varchar(20) DEFAULT NULL COMMENT '供应商联系电话',
  `gyszt` varchar(20) DEFAULT NULL COMMENT '供应商状态(0 正常往来 1 暂停往来 2 不再往来)',
  PRIMARY KEY (`gysid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `gongyingshang` */

/*Table structure for table `huiyuan` */

DROP TABLE IF EXISTS `huiyuan`;

CREATE TABLE `huiyuan` (
  `hyid` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员信息表id 从10000开始',
  `xm` varchar(50) DEFAULT NULL COMMENT '会员姓名',
  `xb` char(1) DEFAULT NULL COMMENT '会员性别',
  `tele` varchar(20) DEFAULT NULL COMMENT '手机号',
  `hykh` varchar(20) DEFAULT NULL COMMENT '会员卡号',
  `knye` decimal(9,2) DEFAULT NULL COMMENT '卡内余额',
  `kyjf` int(11) DEFAULT NULL COMMENT '可用积分',
  `scxfsj` datetime DEFAULT NULL COMMENT '上次消费时间',
  PRIMARY KEY (`hyid`)
) ENGINE=InnoDB AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8;

/*Data for the table `huiyuan` */

/*Table structure for table `huopin` */

DROP TABLE IF EXISTS `huopin`;

CREATE TABLE `huopin` (
  `hpid` int(11) NOT NULL COMMENT '货品id',
  `hpmc` varchar(50) DEFAULT NULL COMMENT '货品名称',
  `hpgg` varchar(20) DEFAULT NULL COMMENT '货品规格',
  `hptm` varchar(20) DEFAULT NULL COMMENT '货品条码',
  `hpjldw` varchar(20) DEFAULT NULL COMMENT '货品计量单位',
  `hplsj` decimal(9,2) DEFAULT NULL COMMENT '货品零售价',
  `hpcxj` decimal(9,2) DEFAULT NULL COMMENT '货品促销价',
  `hpzt` tinyint(4) DEFAULT NULL COMMENT '货品状态(0 正常 1 暂停进货但可以销售 2 不再进货也不能销售)',
  `hpmcsx` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`hpid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `huopin` */

insert  into `huopin`(`hpid`,`hpmc`,`hpgg`,`hptm`,`hpjldw`,`hplsj`,`hpcxj`,`hpzt`,`hpmcsx`) values (9,'可口可乐','','101','瓶','3.00','2.50',0,'kkkl'),(10,'百事可乐','','102','瓶','3.00','2.50',0,'bskl'),(11,'伊利牛奶','','103','盒','5.00','4.50',0,'ylnn'),(12,'农夫山泉','','105','瓶','2.00','1.50',0,'nfsq'),(13,'涪陵榨菜','','106','袋','1.00','0.80',0,'flzc'),(14,'青岛啤酒','','107','听','5.00','4.50',0,'qdpj');

/*Table structure for table `hzpyb` */

DROP TABLE IF EXISTS `hzpyb`;

CREATE TABLE `hzpyb` (
  `hz` char(2) DEFAULT NULL,
  `jp` char(1) DEFAULT NULL,
  `py` varchar(10) DEFAULT NULL,
  KEY `hz` (`hz`)
) ENGINE=InnoDB DEFAULT CHARSET=gb18030;

/*Data for the table `hzpyb` */

insert  into `hzpyb`(`hz`,`jp`,`py`) values 

/*Table structure for table `kucun` */

DROP TABLE IF EXISTS `kucun`;

CREATE TABLE `kucun` (
  `kcid` int(11) NOT NULL COMMENT '库存id',
  `hpid` int(11) DEFAULT NULL COMMENT '货品id(用来代表id)',
  `kcsl` decimal(18,3) DEFAULT NULL COMMENT '(当前)库存数量',
  `zrkc` decimal(18,3) DEFAULT NULL COMMENT '昨日库存(用于日清),系统自动维护',
  `yckc` decimal(18,3) DEFAULT NULL COMMENT '月初库存(用于月结),系统自动维护',
  PRIMARY KEY (`kcid`),
  KEY `hpid` (`hpid`),
  CONSTRAINT `kucun_ibfk_1` FOREIGN KEY (`hpid`) REFERENCES `huopin` (`hpid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `kucun` */

/*Table structure for table `shouyin` */

DROP TABLE IF EXISTS `shouyin`;

CREATE TABLE `shouyin` (
  `syid` int(11) NOT NULL COMMENT '收银id',
  `syyid` int(11) DEFAULT NULL COMMENT '收银员id',
  `hyid` int(11) DEFAULT NULL COMMENT '会员id(顾客ID 0 普通顾客1-9999 >=10000会员)',
  `zzid` int(11) DEFAULT NULL COMMENT '扎帐id',
  `sysj` datetime DEFAULT NULL,
  `ysje` decimal(20,2) DEFAULT NULL COMMENT '应收金额',
  `ssje` decimal(20,2) DEFAULT NULL COMMENT '实收金额',
  `zffs` tinyint(4) DEFAULT NULL COMMENT '支付方式:0.现金 1.储蓄卡 2.支付宝 3.微信支付',
  `xszt` tinyint(4) DEFAULT NULL COMMENT '销售状态 0 正常 1 已退货',
  `yhje` decimal(20,2) DEFAULT NULL COMMENT '优惠金额',
  PRIMARY KEY (`syid`),
  KEY `zzid` (`zzid`),
  CONSTRAINT `shouyin_ibfk_1` FOREIGN KEY (`zzid`) REFERENCES `zhazhang` (`zzid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `shouyin` */

/*Table structure for table `shouyininfo` */

DROP TABLE IF EXISTS `shouyininfo`;

CREATE TABLE `shouyininfo` (
  `shmxid` int(11) NOT NULL COMMENT '收货明细id',
  `syid` int(11) NOT NULL COMMENT '收银id',
  `hpid` int(11) DEFAULT NULL COMMENT '货品id',
  `xssl` decimal(18,3) DEFAULT NULL COMMENT '销售数量',
  `hplsj` decimal(9,2) DEFAULT NULL COMMENT '货品零售价(用来解决货品调价问题)',
  `hpcxj` decimal(9,2) DEFAULT NULL COMMENT '货品促销价',
  PRIMARY KEY (`shmxid`),
  KEY `syid` (`syid`),
  KEY `hpid` (`hpid`),
  CONSTRAINT `shouyininfo_ibfk_1` FOREIGN KEY (`syid`) REFERENCES `shouyin` (`syid`),
  CONSTRAINT `shouyininfo_ibfk_2` FOREIGN KEY (`hpid`) REFERENCES `huopin` (`hpid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `shouyininfo` */

/*Table structure for table `zhazhang` */

DROP TABLE IF EXISTS `zhazhang`;

CREATE TABLE `zhazhang` (
  `zzid` int(11) NOT NULL COMMENT '扎帐id',
  `syyid` int(11) DEFAULT NULL COMMENT '收银员id',
  `zzsj` datetime DEFAULT NULL COMMENT '扎帐时间',
  `ysje` decimal(18,2) DEFAULT NULL COMMENT '应收金额(由系统计算)',
  `ssje` decimal(18,2) DEFAULT NULL COMMENT '实收金额(由收银员输入)',
  `ccyy` varchar(200) DEFAULT NULL COMMENT '差错原因',
  PRIMARY KEY (`zzid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `zhazhang` */

insert  into `zhazhang`(`zzid`,`syyid`,`zzsj`,`ysje`,`ssje`,`ccyy`) values (5,66,'2021-04-20 16:03:00','15.00','15.00','本次结账无差错');

/* Trigger structure for table `huopin` */

DELIMITER $$

/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `update_mcsx_before_huopin` */$$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `update_mcsx_before_huopin` BEFORE UPDATE ON `huopin` FOR EACH ROW BEGIN
    set new.hpmcsx=mcsxx(new.hpmc);
END */$$

DELIMITER ;

/* Trigger structure for table `huopin` */

DELIMITER $$

/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `Update_mcsx_before_insert_hpmcb` */$$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `Update_mcsx_before_insert_hpmcb` BEFORE UPDATE ON `huopin` FOR EACH ROW BEGIN
    insert into `huopin`values(`hpid`,`hpmc`,`hpgg`,`hptm`,`hpjldw`,`hplsj`,`hpcxj`,`hpzt`,mcsxx(new.hpmc));
END */$$

DELIMITER ;

/* Trigger structure for table `huopin` */

DELIMITER $$

/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `Update_mcsx_before_update_hpmcb_hpmc` */$$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `Update_mcsx_before_update_hpmcb_hpmc` BEFORE UPDATE ON `huopin` FOR EACH ROW BEGIN
     UPDATE `huopin` SET `huopin`.`hpmc`=hpmc,
        `huopin`.`hpgg`=hpgg,
        `huopin`.`hptm`=hptm,
        `huopin`.`hpjldw`=hpjldw,
        `huopin`.`hplsj`=hplsj,
        `huopin`.`hpcxj`=hpcxj,
        `huopin`.`hpzt`=hpzt,
        `huopin`.`hpmcsx`=mcsxx(new.hpmc)
        WHERE`huopin`.`hpid`=hpid;
END */$$

DELIMITER ;

/* Function  structure for function  `mcsxx` */

/*!50003 DROP FUNCTION IF EXISTS `mcsxx` */;
DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` FUNCTION `mcsxx`(hpmc varchar(50)) RETURNS varchar(20) CHARSET utf8
    NO SQL
begin
    set @l=char_length(hpmc);
    set @i=1;
    set @jp='';
    set @mcsx='';
    while @i<=@l do
     set @hz=substring(hpmc,@i,1);
     select jp into @jp from hzpyb where hz=@hz;
     set @mcsx = concat(@mcsx,@jp);
     set @i=@i+1;
    end while;
    return @mcsx;
end */$$
DELIMITER ;

/* Function  structure for function  `PysxCx` */

/*!50003 DROP FUNCTION IF EXISTS `PysxCx` */;
DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` FUNCTION `PysxCx`(hpmc VARCHAR(20)) RETURNS varchar(20) CHARSET latin1
    NO SQL
begin
    set @mcsx= mcsxx(hpmc);
    return @mcsx;
end */$$
DELIMITER ;

/* Procedure structure for procedure `HpxxCx` */

/*!50003 DROP PROCEDURE IF EXISTS  `HpxxCx` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `HpxxCx`(IN hpid INT)
BEGIN
    SELECT * FROM `huopin` WHERE `huopin`.`hpid`=hpid; 
END */$$
DELIMITER ;

/* Procedure structure for procedure `HpxxWh` */

/*!50003 DROP PROCEDURE IF EXISTS  `HpxxWh` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `HpxxWh`(hpid INT,
hpmc VARCHAR(50),
hpgg VARCHAR(20),
hptm VARCHAR(20),
hpjldw VARCHAR(20),
hplsj DECIMAL(9,2),
hpcxj DECIMAL(9,2),
hpzt TINYINT(4)
)
BEGIN
    IF hpid=0 THEN
    INSERT INTO `huopin`(`hpid`,`hpmc`,`hpgg`,`hptm`,`hpjldw`,`hplsj`,`hpcxj`,`hpzt`,`hpmcsx`) 
    VALUES(`hpid`,`hpmc`,`hpgg`,`hptm`,`hpjldw`,`hplsj`,`hpcxj`,`hpzt`,mcsxx(hpmc));
     ELSEIF hpid<0 THEN
     DELETE FROM  `huopin` WHERE hpid=-hpid;
     ELSE
     UPDATE `huopin` SET `huopin`.`hpmc`=hpmc,
        `huopin`.`hpgg`=hpgg,
        `huopin`.`hptm`=hptm,
        `huopin`.`hpjldw`=hpjldw,
        `huopin`.`hplsj`=hplsj,
        `huopin`.`hpcxj`=hpcxj,
        `huopin`.`hpzt`=hpzt,
        `huopin`.`hpmcsx`=mcsxx(hpmc)
      WHERE`huopin`.`hpid`=hpid;
    END IF;   
    
END */$$
DELIMITER ;

/* Procedure structure for procedure `SyjlCx` */

/*!50003 DROP PROCEDURE IF EXISTS  `SyjlCx` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `SyjlCx`(cxlb int,cxcs int)
begin
    if cxlb=0 then 
    SELECT `syid`,`syyid`,`hyid`,`ysje`,`sysj`,`ssje`,`yhje`,
    CASE `zffs`
    WHEN 0 THEN '现金'
    WHEN 1 THEN '储值卡'
    WHEN 2 THEN '支付宝'
    WHEN 3 THEN '微信支付'
    END AS 支付方式
    FROM `shouyin`
    WHERE syyid=cxcs AND `sysj`<=CURDATE() 
    ORDER BY syid DESC;
    else
        select * from shouyininfo where `syid`=cxcs;
    end if;        
end */$$
DELIMITER ;

/* Procedure structure for procedure `Thjlcp` */

/*!50003 DROP PROCEDURE IF EXISTS  `Thjlcp` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `Thjlcp`(syid int)
begin
    select hyid into @hyid from `shouyin`
    where `shouyin`.`syid`=syid;
    select ssje into @ssje from `shouyin`
    where `shouyin`.`syid`=syid;
    
    if @hyid >10000 then
        update `huiyuan` set knye=knye+@ssje,
        kyjf=kyjf-floor(@ssje)
        where huiyuan.`hyid`=@hyid;
    end if;
    
    drop table if exists lsb;
    create temporary table lsb(
        hpid int,
        xssl numeric(18,3)
    );
    insert into lsb(hpid,xssl)
    select hpid,sum(xssl)
    from shouyininfo
    where shouyininfo.`syid`=syid
    group by hpid;
    
    update `kucun` b1,lsb b2 
    set b1.`kcsl`=b1.`kcsl`+b2.xssl 
    where b1.`hpid`=b2.hpid;
    
    delete from shouyininfo where shouyininfo.`syid`=syid;
    delete from shouyin where shouyin.`syid`=syid;
end */$$
DELIMITER ;

/* Procedure structure for procedure `Thjlcp_new` */

/*!50003 DROP PROCEDURE IF EXISTS  `Thjlcp_new` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `Thjlcp_new`(syid int)
begin
    DELETE FROM shouyin WHERE shouyin.`syid`=syid;
end */$$
DELIMITER ;

/* Procedure structure for procedure `thjlcp_new1` */

/*!50003 DROP PROCEDURE IF EXISTS  `thjlcp_new1` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `thjlcp_new1`(syid INT)
BEGIN
    IF syid>0 THEN
    DELETE FROM shouyin WHERE shouyin.`syid`=syid;
    ELSE
    INSERT shouyin(syyid,hyid,sysj,ysje,ssje,yhje,xszt,zzid)
    SELECT syyid,hyid,NOW(),zffs,-ysje,-ssje,-yhje,-1,zzid    
    from shouyin where shouyin.`syid`=syid;
    set @syid_new=@@identity;
    update shouyin set xszt=@syid_new;
    insert into shouyininfo (`syid`,`hpid`,`xssl`,`hplsj`,`hpcxj`)
    select @syid_new,hpid,-xssl,hplsj,hpcxj
    from shouyininfo where shouyininfo.`syid`=-syid;
    /*变更库存表*/
    drop table if exists lsb;
    create table lsb(
    hpid int,
    xssl numeric(18,3)
    )charset utf8;
    insert into lsb select hpid,sum(xssl) from shouyininfo
    where shouyininfo.`syid`=-syid group by hpid;
    update `kucun` b1,lsb b2 set b1.kcsl=b1.kcsl+b2.xssl
    where b1.hpid=b2.hpid;
    /*会员积分*/
    select hyid into @hyid from shouyin where shouyin.`syid`=-syid;
    select ssje into @ssje from shouyin where shouyin.`syid`=-syid;
    if @hyid>10000 then
       update huiyuan set knye=knye+@ssje,kyjf=kyjf-floor(@ssje)
       where huiyuan.`hyid`=@hyid;
      end if;
    end if;
END */$$
DELIMITER ;

/* Procedure structure for procedure `xsjlcp` */

/*!50003 DROP PROCEDURE IF EXISTS  `xsjlcp` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `xsjlcp`(xsmx varchar(1000))
begin
    drop table if exists lsb;
    create temporary table lsb(hpid int,xxsl numeric(18,3));
    while (xsmx>'') do
        set @k=position(','in xsmx);
        set @hpid=left(xsmx,@k-1);
        set xsmx=substr(xsmx,@k+1);
        set @k=position(','in xsmx);
        set @xssl=left(xsmx,@k-1);
        insert into lsb values(@hpid,@xssl);
        set xsmx=SUBSTR(xsmx,@k+1);
        end while;
        select * from lsb;
        select `huopin`.hptm,`huopin`.hpmc,
        `huopin`.hpjldw,`huopin`.hplsj,`huopin`.hpcxj,
        `shouyininfo`.xssl*`huopin`.hpcxj as 金额 
        from `huopin`,lsb,`shouyininfo` 
        where `huopin`.`hpid`=`shouyininfo`.`hpid` and `huopin`.`hpid`=lsb.hpid;    
end */$$
DELIMITER ;

/* Procedure structure for procedure `xsjlcp_new` */

/*!50003 DROP PROCEDURE IF EXISTS  `xsjlcp_new` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `xsjlcp_new`(syyid int,hyid int,ysje decimal(18,2),ssje decimal(18,2),zffs tinyint,xsmx varchar(1000))
begin
    insert into `shouyin`(syyid,hyid,ysje,ssje,zffs) values(syyid,hyid,ysje,ssje,zffs);
    SET @syid=@@identity;
    drop table if exists lsb;
    create temporary table lsb(hpid INT,xxsl NUMERIC(18,3));
    while(xsmx>'') do
        set @k=position(','in xsmx);
        set @hpid=left(xsmx,@k-1);
        set @xsmx=substr(xsmx,@k+1);
        set @k=position(','in @xsmx);
        set @xssl=left(@xsmx,@k-1);
        insert into lsb values(@hpid,@xssl);
        select * from lsb;
        set xsmx=SUBSTR(xsmx,@k+1);
        end while;
    insert into `shouyininfo`(syid,hpid,xssl,hpcxj,hplsj)
    select @syid,lsb.hpid,xssl,hpcxj,hplsj
    from lsb,`huopin`
    where lsb.hpid=`huopin`.`hpid`;
    drop table if exists lsb1;
    create temporary table lsb1(hpid int,xssl numeric(18,3));
    insert into lsb1 select hpid,sum(xssl) from lsb 
    group by hpid;
    update `kucun` b1,lsb1 b2 set b1.kcsl=b1.kcsl-b2.xssl 
    where b1.hpid=b2.hpid;
    if hyid>10000 then
        update `huiyuan` set knye=knye-ssje,kyjf=kyjf+floor(ssje)
        where `huiyuan`.`hyid`=hyid;
     end if;    
end */$$
DELIMITER ;

/*Table structure for table `v_hpkcb` */

DROP TABLE IF EXISTS `v_hpkcb`;

/*!50001 DROP VIEW IF EXISTS `v_hpkcb` */;
/*!50001 DROP TABLE IF EXISTS `v_hpkcb` */;

/*!50001 CREATE TABLE  `v_hpkcb`(
 `hpid` int(11) ,
 `hpmc` varchar(50) ,
 `jldw` varchar(50) ,
 `kcsl` decimal(18,3) 
)*/;

/*Table structure for table `v_symxb` */

DROP TABLE IF EXISTS `v_symxb`;

/*!50001 DROP VIEW IF EXISTS `v_symxb` */;
/*!50001 DROP TABLE IF EXISTS `v_symxb` */;

/*!50001 CREATE TABLE  `v_symxb`(
 `mxid` int(11) ,
 `syid` int(11) ,
 `hpmc` varchar(50) ,
 `jldw` varchar(20) ,
 `xxsl` decimal(18,3) ,
 `dj` decimal(9,2) ,
 `lsj` decimal(9,2) 
)*/;

/*Table structure for table `v_xsjlmxb` */

DROP TABLE IF EXISTS `v_xsjlmxb`;

/*!50001 DROP VIEW IF EXISTS `v_xsjlmxb` */;
/*!50001 DROP TABLE IF EXISTS `v_xsjlmxb` */;

/*!50001 CREATE TABLE  `v_xsjlmxb`(
 `shmxid` int(11) ,
 `syid` int(11) ,
 `hpmc` varchar(50) ,
 `hpjldw` varchar(20) ,
 `xssl` decimal(18,3) ,
 `hplsj` decimal(9,2) ,
 `hpcxj` decimal(9,2) 
)*/;

/*View structure for view v_hpkcb */

/*!50001 DROP TABLE IF EXISTS `v_hpkcb` */;
/*!50001 DROP VIEW IF EXISTS `v_hpkcb` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_hpkcb` AS select `kucun`.`hpid` AS `hpid`,`huopin`.`hpmc` AS `hpmc`,`huopin`.`hpmc` AS `jldw`,`kucun`.`kcsl` AS `kcsl` from (`huopin` join `kucun`) where (`huopin`.`hpid` = `kucun`.`hpid`) */;

/*View structure for view v_symxb */

/*!50001 DROP TABLE IF EXISTS `v_symxb` */;
/*!50001 DROP VIEW IF EXISTS `v_symxb` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_symxb` AS select `shouyininfo`.`shmxid` AS `mxid`,`shouyininfo`.`syid` AS `syid`,`huopin`.`hpmc` AS `hpmc`,`huopin`.`hpjldw` AS `jldw`,`shouyininfo`.`xssl` AS `xxsl`,`shouyininfo`.`hpcxj` AS `dj`,`shouyininfo`.`hplsj` AS `lsj` from (`shouyininfo` join `huopin`) where (`shouyininfo`.`hpid` = `huopin`.`hpid`) */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_xsjlmxb` AS select `shouyininfo`.`shmxid` AS `shmxid`,`shouyininfo`.`syid` AS `syid`,`huopin`.`hpmc` AS `hpmc`,`huopin`.`hpjldw` AS `hpjldw`,`shouyininfo`.`xssl` AS `xssl`,`huopin`.`hplsj` AS `hplsj`,`huopin`.`hpcxj` AS `hpcxj` from (`huopin` join `shouyininfo`) where (`huopin`.`hpid` = `shouyininfo`.`hpid`) */;