zrUL5zRK

1DROP TABLE IF EXISTS `moopledev`.`shopitems`;
2CREATE TABLE  `moopledev`.`shopitems` (
3  `shopitemid` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `shopid` int(10) unsigned NOT NULL,
5  `itemid` int(11) NOT NULL,
6  `price` int(11) NOT NULL,
7  `pitch` int(11) NOT NULL DEFAULT '0',
8  `position` int(11) NOT NULL COMMENT 'sort is an arbitrary field designed to give leeway when modifying shops. The lowest number is 104 and it increments by 4 for each item to allow decent space for swapping/inserting/removing items.',
9  PRIMARY KEY (`shopitemid`)
10) ENGINE=MyISAM AUTO_INCREMENT=20021 DEFAULT CHARSET=latin1;