CREATE DATABASE /*!32312 IF NOT EXISTS*/`supermarketmanagerdb` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `supermarketmanagerdb`;
/*Table structure for table `sm_goods` */
DROP TABLE IF EXISTS `sm_goods`;
CREATE TABLE `sm_goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`inventory_quantity` int(11) NOT NULL,
`last_purchasing_price` float NOT NULL,
`min_num` int(11) NOT NULL,
`model` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`producer` varchar(200) DEFAULT NULL,