-- -- 表的结构 `order` -- CREATE TABLE IF NOT EXISTS `order` ( `id` varchar(10) NOT NULL, `user_id` varchar(10) NOT NULL, `price` float NOT NULL, `status` int(11) NOT NULL, `address` varchar(100) NOT NULL, `name` varchar(25) NOT NULL, `date` varchar(25) NOT NULL, `ps` text NOT NULL, `phone` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gbk; --