jiliangzhifu2017/附件.sql

ALTER TABLE `jl_item_attachment`
  DROP `mpid`,
  DROP `itemid`,
  DROP `categoryid`,
  DROP `tips`;

  ALTER TABLE  `jl_item_attachment` ADD  `pid` INT NOT NULL DEFAULT  '0' AFTER  `ownerid` ,
ADD  `pmid` INT NOT NULL DEFAULT  '0' AFTER  `pid` ;

CREATE TABLE IF NOT EXISTS `jl_item_measure_numofper` (
  `imnid` int(11) NOT NULL AUTO_INCREMENT,
  `iaid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `pmid` int(11) NOT NULL,
  `numpname` smallint(6) NOT NULL,
  `softwareitemid` int(11) NOT NULL,
  `isdel` tinyint(4) NOT NULL DEFAULT '0',
  `intime` int(11) NOT NULL DEFAULT '0',
  `deltime` int(11) NOT NULL DEFAULT '0',
  `ownerid` mediumint(9) NOT NULL DEFAULT '0',
  `categoryid` mediumint(9) NOT NULL,
  `tips` text NOT NULL,
  PRIMARY KEY (`imnid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

ALTER TABLE  `jl_item_attachment` ADD  `oldiaid` MEDIUMINT NOT NULL ;

ALTER TABLE  `jl_item_measure_numofper` ADD  `deluid` MEDIUMINT NOT NULL AFTER  `deltime` ;