56,678
社区成员
发帖
与我相关
我的任务
分享
--
-- 表的结构 `a`
--
CREATE TABLE IF NOT EXISTS `a` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(10) NOT NULL,
`rkno` varchar(25) NOT NULL,
`packageno` varchar(20) NOT NULL,
`type` varchar(20) NOT NULL,
`cust_no` varchar(20) NOT NULL,
`snp` int(4) NOT NULL,
`wh_info` varchar(20) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`ID`),
KEY `packageno` (`packageno`),
KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
-- --------------------------------------------------------
--
-- 表的结构 `b`
--
CREATE TABLE IF NOT EXISTS `b` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`stock_no` varchar(20) NOT NULL,
`adress` varchar(10) NOT NULL,
`arr_time` datetime NOT NULL,
`c_type` varchar(20) NOT NULL,
`pu_no` varchar(20) NOT NULL,
`cust_no` varchar(20) NOT NULL,
`mount` int(10) NOT NULL,
`snp` int(10) NOT NULL,
`c1_time` datetime NOT NULL,
`c2_time` datetime NOT NULL,
PRIMARY KEY (`ID`)
)
-- --------------------------------------------------------
--
-- 表的结构 `c`
--
CREATE TABLE IF NOT EXISTS `c` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(25) NOT NULL,
`packageno` varchar(20) NOT NULL,
`hi_no` varchar(20) NOT NULL,
`cust_no` varchar(20) NOT NULL,
`lotno` varchar(20) NOT NULL,
`description` varchar(20) NOT NULL,
`type` varchar(20) NOT NULL,
`barcode` varchar(50) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`ID`),
KEY `packageno` (`packageno`),
KEY `lotno` (`lotno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=167027 ;