Online mall 7-order module, online mall 7-order

Online mall 7-order module, online mall 7-order

1. Create a table:

CREATE TABLE `orders` (  `oid` int(11) NOT NULL AUTO_INCREMENT,  `total` double DEFAULT NULL,  `ordertime` datetime DEFAULT NULL,  `state` int(11) DEFAULT NULL,  `name` varchar(20) DEFAULT NULL,  `addr` varchar(100) DEFAULT NULL,  `phone` varchar(20) DEFAULT NULL,  `uid` int(11) DEFAULT NULL,  PRIMARY KEY (`oid`),  KEY `FKC3DF62E5AA3D9C7` (`uid`),  CONSTRAINT `FKC3DF62E5AA3D9C7` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;CREATE TABLE `orderitem` (  `itemid` int(11) NOT NULL AUTO_INCREMENT,  `count` int(11) DEFAULT NULL,  `subtotal` double DEFAULT NULL,  `pid` int(11) DEFAULT NULL,  `oid` int(11) DEFAULT NULL,  PRIMARY KEY (`itemid`),  KEY `FKE8B2AB6166C01961` (`oid`),  KEY `FKE8B2AB6171DB7AE4` (`pid`),  CONSTRAINT `FKE8B2AB6166C01961` FOREIGN KEY (`oid`) REFERENCES `orders` (`oid`),  CONSTRAINT `FKE8B2AB6171DB7AE4` FOREIGN KEY (`pid`) REFERENCES `product` (`pid`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;