XgmsHRwG

1CREATE TABLE IF NOT EXISTS `wh_reserve` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `storageid` int(11) NOT NULL,
4  `itemtypeid` int(11) NOT NULL,
5  `count` double NOT NULL,
6  `employeeid` int(11) NOT NULL,
7  PRIMARY KEY (`id`),
8  KEY `storageid` (`storageid`),
9  KEY `itemtypeid` (`itemtypeid`)
10) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;